List:General Discussion« Previous MessageNext Message »
From:Daniel Powell Date:February 4 2004 8:00pm
Subject:Mysql ECHILD resets on Queries
View as plain text  
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+              djpowell@stripped
Networkgeek              MCP               http://networkgeek.org
=================================================================
And Trogdor smote the Kerrek, and all was laid to Burnination.
=================================================================


Thread
Mysql ECHILD resets on QueriesDaniel Powell4 Feb
  • Re: Mysql ECHILD resets on Queriesvpendleton4 Feb
    • Re: Mysql ECHILD resets on QueriesDaniel Powell4 Feb
      • Re: Mysql ECHILD resets on Queriesvpendleton4 Feb
Re: Mysql ECHILD resets on Queriesvpendleton4 Feb
  • Re: Mysql ECHILD resets on QueriesDaniel Powell4 Feb
    • Re: Mysql ECHILD resets on Queriesvpendleton4 Feb
      • Re: Mysql ECHILD resets on QueriesDaniel Powell4 Feb
        • Re: Mysql ECHILD resets on Queriesvpendleton4 Feb
          • Re: Mysql ECHILD resets on QueriesDaniel Powell4 Feb
            • Re: Mysql ECHILD resets on QueriesDaniel Powell4 Feb