Bug #2186 restarting mysql.server make ssh can't logout

• Submitted: 22 Dec 2003 7:52
• Modified: 30 Jan 2004 10:20
• Reporter: xuefer tinys
• Status: Can't repeat
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 4.0.17
• OS: Linux (linux)
• Assigned to: Lenz Grimmer
• CPU Architecture: Any

[22 Dec 2003 7:52] xuefer tinys

Description:
build from source
restarting mysql.server always make ssh can't logout remote to return to local shell
i have to kill ssh

both crond (wrote a script to run mysql if it's not started)
and ssh have same problem
but telnet is ok

How to repeat:
ssh to remote host
shell> mysql.server restart
shell> exit

screen is cleared, but is waiting there, can't return to local shell

Suggested fix:
seems mysql don't detach from tty

[23 Dec 2003 7:25] Dean Ellis

The OpenSSH FAQ covers this:

http://openssh.org/faq.html#3.10

Modifying the init script per their recommendations works, but this has the possibly undesirable effect of discarding output from the script.

I am verifying it in the event we want to modify our init script along similar lines, though.

[30 Dec 2003 12:30] Brian Aker

Personally I have always found this sort of behavior to be annoying.

[30 Jan 2004 10:20] Michael Widenius

Can't repeat this with the current MYSQL 4.0 tree
(Note that mysqld_safe will hang if you don't use > /dev/null 2>&1 &, but that is expected)