Bug #31422 --connect_timeout and --wait keys are not take effect
Submitted: 5 Oct 2007 15:22 Modified: 3 Nov 2023 21:40
Reporter: Vladimir Turov Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S3 (Non-critical)
Version:5.0.27, 5.0, 5.1, 4.1 BK OS:Any
Assigned to: CPU Architecture:Any
Tags: connect_timeout, wait

[5 Oct 2007 15:22] Vladimir Turov 
Description:
Command line clients for win32 and for unix doesn't seem to have any reaction on keys:
--connect_timeout
--wait

How to repeat:
Stop MYSQL service

execute command:
mysql -uroot --connect_timeout=60 --wait --execute="SHOW DATABASES;"
[8 Oct 2007 14:05] Vladimir Turov 
bug-information corrected
[10 Oct 2007 1:17] MySQL Verification Team 
Thank you for the bug report. Do you got the below conclusion from
our Manual?. If yes, could you please point us where. Thanks in
advance.

"With the "--connect_timeout=x" key I'am expecting MYSQL-client to wait for MYSQL-server
start in x seconds after executing the command. Is it wrong?"
[10 Oct 2007 8:46] Vladimir Turov 
here's the link:
http://mysql.org/doc/refman/5.0/en/mysql-command-options.html

...
--wait, -w 
If the connection cannot be established, wait and retry instead of aborting. 
...
connect_timeout 
The number of seconds before connection timeout. (Default value is 0.) 
...
[10 Oct 2007 22:54] Sveta Smirnova 
Thank you for the report.

Verified as described.
[22 Jan 2008 20:16] Omer Barnir 
triage: changed bug to documenting as this is not a bug in the code
[25 Jan 2008 16:29] Paul DuBois 
Hello Vladimir,

What leads you to think that mysql will start the server if --wait is given? I don't see anything in the description that implies that.
[25 Jan 2008 16:48] Vladimir Turov 
I don't said that I expect server to autostart if I'll insert --wait key.
I said only that if I give --wait key I expect that client will wait the server to start "instead of aborting", and, if it starts, connect to it.

Now I understand that --connect_timeout is have no meaning "try to reconnect timeout", so then I don't understand what the meaning of --wait key? Wait for what? In what cases? How long?
[28 Jan 2008 20:09] Omer Barnir 
triage: if this is set back to 'client' then the lead needs to be Georg
[3 Nov 2023 21:40] Philip Olson 
Posted by developer:
 
Fixed as of the upcoming MySQL Server 8.3.0 release, and here's the proposed changelog entry from the documentation team:

The --wait command-line option did not function with the mysql client.

Thank you for the bug report.