I am right now looking over the logs. I had the regular log on and the binlog on to test it. I'm going over the log right now. The binlog is helpful -- I'm looking at the last queries in each (since a new one was created every time MySQL crashed).
The only thing in common is that they are always (100%) an update or replace. Some examples: update logins set expire=1030501300 where loginid=2961860; and SET TIMESTAMP=1030501283; update logins_plus set pageviews = pageviews+1 where transactionid = 1016040153 and loginid=54522 and period_begin='2002-08-13' and period_end = '2002-09-13'; and replace into presence.chatrooms_users(chatroomid,login,msgtime) values ( 65637, 'joe', 1030501249 ); So maybe at write__9MYSQL_LOGP3THDPCcUil + 1210 there is a problem with data sent via update/replace. However, the sever likely crashes before the log is written, so this is potentially meaningless... (One of the binlogs did not have any queries inside.) On the other hand, the log file (not binlog) shows a bunch of connections before the thread id goes back to 1. And just to make it more confusing, sometimes the last entry in a binlog can't be found in the log file. I wish there was a web accessible version of the source so I could quickly go look at it (like PHP's lxr.php.net)... Sincerely, Steven Roussey http://Network54.com/?pp=e > -----Original Message----- > From: Jocelyn Fournier [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, August 27, 2002 11:48 pm > To: [EMAIL PROTECTED]; Mysql > Subject: Re: 4.0.3 crashes every 5 seconds. > > Hi, > > I'm "happy" to know I'm not the only one which have this segfault problem. > Do you have any idea of what kind of queries causes those segfault ? (I > unfortunatly have also a nil pointer) > > Thanks and regards, > Jocelyn > > > ----- Original Message ----- > From: "Steven Roussey" <[EMAIL PROTECTED]> > To: "Mysql" <[EMAIL PROTECTED]> > Sent: Wednesday, August 28, 2002 5:02 AM > Subject: 4.0.3 crashes every 5 seconds. > > > > I downloaded a copy of 4.0.3 from the download page and it crashes every > > five seconds! Resolving the stack trace gives: > > > > 0x806ebdb handle_segfault__Fi + 447 > > 0x8261718 pthread_sighandler + 184 > > 0x828cf8f memcpy + 31 > > 0x80a89ce write__9MYSQL_LOGP3THDPCcUil + 1210 > > 0x80783fd dispatch_command__F19enum_server_commandP3THDPcUi + 4105 > > 0x80773e5 do_command__FP3THD + 93 > > 0x8076c2e handle_one_connection__FPv + 674 > > 0x825edfc pthread_start_thread + 204 > > 0x82941fa thread_start + 4 > > > > and > > > > 0x806ebdb handle_segfault__Fi + 447 > > 0x8261718 pthread_sighandler + 184 > > 0x828cf97 memcpy + 39 > > 0x80a89ce write__9MYSQL_LOGP3THDPCcUil + 1210 > > 0x80783fd dispatch_command__F19enum_server_commandP3THDPcUi + 4105 > > 0x80773e5 do_command__FP3THD + 93 > > 0x8076c2e handle_one_connection__FPv + 674 > > 0x825edfc pthread_start_thread + 204 > > 0x82941fa thread_start + 4 > > > > keep repeating. > > > > Unfortunately, the query field is (nil). :( > > > > Nice to have the sym file... > > > > I guess I rushed to download too quickly... > > > > I'll write back with more info soon. > > > > Sincerely, > > Steven Roussey > > http://Network54.com/?pp=e > > > > > > > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > > > > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <mysql-unsubscribe- > [EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
