Here is my final analysis of this problem. May it be correct or not, mysql is no longer panicing the child process..
libgcc was either corrupt or incompatible. It was the original version so I lean towards corrupt. Whatever corrupted it, I have no idea what, mysql was PISSED off about it. Whatever call Mysql was making for pthreads and such wasnt hitting the stack pointer right and totally taking a dump. The parent process saw this and restarted the child. this of course pissed off apache and whatever other thread was pointing to that socket/pid for mysql access. Thus all the "mysql not responding" and such from applications. I'll have to trace back several upgrades before I can pinpoint the exact upgrade that caused the failure. Thanks for everyone's input! On Wed, 4 Feb 2004, Daniel Powell wrote: > > I may have resolved the crashing issue... > > I upgraded gcc and libgcc, as well as bintools and cpp for dependancy > issues... the child PID no longer crashes... possible that the libgcc was > corrupt? im stracing the pid now and it does not exit as before. no more > constant respawning. I will enable --log on the init script and see if it > shows me anything blatanly evil. > > > On Wed, 4 Feb 2004 [EMAIL PROTECTED] wrote: > > > All logging will grow very rapidly on a `busy` server. To enable all > > logging you can add the --log option to the safe_mysqld command. > > safe_mysqld --log > > > > > > >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<< > > > > On 2/4/04, 3:48:46 PM, Daniel Powell <[EMAIL PROTECTED]> wrote > > regarding Re: Mysql ECHILD resets on Queries: > > > > > > > its pretty default. I'd like to enable all logging if possible. What > > > specificly should I enable in my.cnf? > > > > > > > On Wed, 4 Feb 2004 [EMAIL PROTECTED] wrote: > > > > > > If the server is up and running can you log in a perform a > > > > show variales from the mysql monitor. From this information you can learn > > > > where your logs are being stored. > > > > ... > > > > Also, what sort of logging are you currently performing? Are you logging > > > > just errors , slow queries or everything? > > > > ... > > > > > > > > > > > > >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<< > > > > > > > > On 2/4/04, 3:27:55 PM, Daniel Powell <[EMAIL PROTECTED]> wrote > > > > regarding Re: Mysql ECHILD resets on Queries: > > > > > > > > > > > > > It appears to be running with safe_mysqld > > > > > > > > > root 7237 1 0 14:26 pts/0 00:00:01 /bin/sh > > > > /usr/bin/safe_mysqld --defaults-file=/etc/my.cnf > > > > > > > > > and locate *.err returns nothing. > > > > > > > > > > > > > > > > > > > > > On Wed, 4 Feb 2004 [EMAIL PROTECTED] wrote: > > > > > > > > > > A locate *.err returns nothing? > > > > > > What happens when you attempt to start MySQL with safe_mysqld? > > > > > > > > > > > > >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<< > > > > > > > > > > > > On 2/4/04, 3:04:54 PM, Daniel Powell <[EMAIL PROTECTED]> wrote > > > > > > regarding Re: Mysql ECHILD resets on Queries: > > > > > > > > > > > > > > > > > > > nothing of the sort. no .err files on the machine nothing named > > > > > > > redstone.err or localhost.err. > > > > > > > > > > > > > Just baffling. something had mysql hosed and any request or query, even > > > > > > > something from mysqladmin, kills it. > > > > > > > > > > > > > -- > > > > > > > ================================================================= > > > > > > > Daniel Powell A+ [EMAIL PROTECTED] > > > > > > > Networkgeek MCP http://networkgeek.org > > > > > > > ================================================================= > > > > > > > And Trogdor smote the Kerrek, and all was laid to Burnination. > > > > > > > ================================================================= > > > > > > > > > > > > > > > -- > > > > > ================================================================= > > > > > 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] > > > > > > > > > > > > > -- > > > ================================================================= > > > Daniel Powell A+ [EMAIL PROTECTED] > > > Networkgeek MCP http://networkgeek.org > > > ================================================================= > > > And Trogdor smote the Kerrek, and all was laid to Burnination. > > > ================================================================= > > > > -- ================================================================= 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]
