Ive got a machine running redhat 9 kernel 2.4.20-28.9 and a recent update
from APT seems to have destroyed mysql somehow.
Mysql Version is 3.23.58-1.9
Any query kills the child process of mysqld and it has to respawn. This
does not seem to be the proper behaviour and it is causing many issues for
the php scripts that talk to mysql.
php is version 4.3.3-2 apache is 2.0.47-6
i cant even get a dump of the databases because of the respawning child
process. Ive been searching google and the arcives here for the last 24
hours and I've found nothing of the like..
an strace of the safe_mysqld shows this.
I'm at my witts end here. any insight or way to get a better dump of what
is really killing it?
--- SIGCHLD (Child exited) @ 0 (0) ---
waitpid(-1, 0xbfffef24, WNOHANG) = -1 ECHILD (No child processes)
sigreturn() = ? (mask now [])
rt_sigprocmask(SIG_BLOCK, NULL, [], 8) = 0
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0
pipe([3, 4]) = 0
rt_sigprocmask(SIG_BLOCK, [INT CHLD], [CHLD], 8) = 0
clone(child_stack=0, flags=CLONE_CHILD_CLEARTID|CLONE_CHILD_SETTID|0x11,
<ignored>, <ignored>, 0x4015c0c8) = 2134
rt_sigprocmask(SIG_SETMASK, [CHLD], NULL, 8) = 0
close(4) = 0
close(4) = -1 EBADF (Bad file descriptor)
rt_sigprocmask(SIG_BLOCK, [INT CHLD], [CHLD], 8) = 0
clone(child_stack=0, flags=CLONE_CHILD_CLEARTID|CLONE_CHILD_SETTID|0x11,
<ignored>, <ignored>, 0x4015c0c8) = 2136
rt_sigprocmask(SIG_SETMASK, [CHLD], NULL, 8) = 0
close(3) = 0
rt_sigprocmask(SIG_BLOCK, [CHLD], [CHLD], 8) = 0
rt_sigprocmask(SIG_SETMASK, [CHLD], NULL, 8) = 0
rt_sigprocmask(SIG_BLOCK, [CHLD], [CHLD], 8) = 0
rt_sigaction(SIGINT, {0x8075dc0, [], SA_RESTORER, 0x4004b9a8}, {SIG_IGN},
8) = 0
waitpid(-1, [WIFEXITED(s) && WEXITSTATUS(s) == 0], 0) = 2134
waitpid(-1, [WIFEXITED(s) && WEXITSTATUS(s) == 0], 0) = 2136
rt_sigprocmask(SIG_SETMASK, [CHLD], NULL, 8) = 0
rt_sigaction(SIGINT, {SIG_IGN}, {0x8075dc0, [], SA_RESTORER, 0x4004b9a8},
8) = 0
close(3) = -1 EBADF (Bad file descriptor)
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
--- SIGCHLD (Child exited) @ 0 (0) ---
waitpid(-1, 0xbffff1e4, WNOHANG) = -1 ECHILD (No child processes)
sigreturn() = ? (mask now [])
rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
stat64("/bin/rm", {st_mode=S_IFREG|0755, st_size=26780, ...}) = 0
access("/bin/rm", X_OK) = 0
rt_sigprocmask(SIG_BLOCK, [INT CHLD], [], 8) = 0
clone(child_stack=0, flags=CLONE_CHILD_CLEARTID|CLONE_CHILD_SETTID|0x11,
<ignored>, <ignored>, 0x4015c0c8) = 2137
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
--- SIGCHLD (Child exited) @ 0 (0) ---
waitpid(-1, [WIFEXITED(s) && WEXITSTATUS(s) == 0], WNOHANG) = 2137
waitpid(-1, 0xbfffef64, WNOHANG) = -1 ECHILD (No child processes)
sigreturn() = ? (mask now [])
rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0
rt_sigaction(SIGINT, {0x8075dc0, [], SA_RESTORER, 0x4004b9a8}, {SIG_IGN},
8) = 0
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
rt_sigaction(SIGINT, {SIG_IGN}, {0x8075dc0, [], SA_RESTORER, 0x4004b9a8},
8) = 0
rt_sigprocmask(SIG_BLOCK, NULL, [], 8) = 0
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
stat64("/usr/bin/nohup", {st_mode=S_IFREG|0755, st_size=2129, ...}) = 0
access("/usr/bin/nohup", X_OK) = 0
rt_sigprocmask(SIG_BLOCK, [INT CHLD], [], 8) = 0
clone(child_stack=0, flags=CLONE_CHILD_CLEARTID|CLONE_CHILD_SETTID|0x11,
<ignored>, <ignored>, 0x4015c0c8) = 2138
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
rt_sigprocmask(SIG_BLOCK, [CHLD], [], 8) = 0
rt_sigaction(SIGINT, {0x8075dc0, [], SA_RESTORER, 0x4004b9a8}, {SIG_IGN},
8) = 0
waitpid(-1, <unfinished ...>
--
=================================================================
Daniel Powell A+ [EMAIL PROTECTED]
Networkgeek MCP http://networkgeek.org
=================================================================
And Trogdor smote the Kerrek, and all was laid to Burnination.
=================================================================
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
