Bug #31422 --connect_timeout and --wait keys are not take effect
Submitted: 5 Oct 2007 15:22 Modified: 25 Jan 2008 16:48
Reporter: Vladimir Turov Email Updates:
Status: Verified 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