Have you looked in the hostname.err logs for the MySQL server?
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 2/4/04, 2:00:53 PM, Daniel Powell <[EMAIL PROTECTED]> wrote
regarding Mysql ECHILD resets on Queries:
> 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]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
