The hostname.err log will generally be located in the data directory. >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 2/4/04, 2:42:02 PM, Daniel Powell <[EMAIL PROTECTED]> wrote regarding Re: Mysql ECHILD resets on Queries: > Where exactly SHOULD these be and is it something I need to enable in > my.cnf > the generic /var/log/mysqld.log has this each time the process dies: > Number of processes running now: 0 > 040203 22:21:08 mysqld restarted > Cannot initialize InnoDB as 'innodb_data_file_path' is not set. > If you do not want to use transactional InnoDB tables, add a line > skip-innodb > to the [mysqld] section of init parameters in your my.cnf > or my.ini. If you want to use InnoDB tables, add to the [mysqld] > section, for example, > innodb_data_file_path = ibdata1:10M:autoextend > But to get good performance you should adjust for your hardware > the InnoDB startup options listed in section 2 at > http://www.innodb.com/ibman.html > /usr/libexec/mysqld: ready for connections > libgcc_s.so.1 must be installed for pthread_cancel to work > until I enabled skip-innodb and now i get : > Number of processes running now: 0 > 040204 14:31:18 mysqld restarted > /usr/libexec/mysqld: ready for connections > libgcc_s.so.1 must be installed for pthread_cancel to work > libgcc_s.so.1 is in /lib as a symlink: > [EMAIL PROTECTED] lib]# ls -al libgcc_s* > -rwxr-xr-x 1 root root 30324 Feb 25 2003 libgcc_s-3.2.2-20030225.so.1 > lrwxrwxrwx 1 root root 28 Jul 25 2003 libgcc_s.so.1 -> libgcc_s-3.2.2-20030225.so.1 > On Wed, 4 Feb 2004 [EMAIL PROTECTED] wrote: > > 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] > > > > > -- > ================================================================= > 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]
