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
Triage: Triaged: D3 (Medium)

[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] Miguel Solorzano
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