Re: 4.0.3 crashes every 5 seconds.
Steven, I assume you are running on Linux, since you were able to resolve the stack traces. Which distro: rpm or .tar.gz? I am right now running all my stress tests on 4.0.3 on the .tar.gz distro on a 4-way Linux-2.4.16-64GB-SMP, and it seems to work. Your bug is probably query- or platform-specific. Regards, Heikki - Original Message - From: Steven Roussey [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Wednesday, August 28, 2002 6:10 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 4.0.3 crashes every 5 seconds.
Subject: Re: 4.0.3 crashes every 5 seconds. From: Heikki Tuuri [EMAIL PROTECTED] === Steven, I assume you are running on Linux, since you were able to resolve the stack traces. Which distro: rpm or .tar.gz? I am right now running all my stress tests on 4.0.3 on the .tar.gz distro on a 4-way Linux-2.4.16-64GB-SMP, and it seems to work. Your bug is probably query- or platform-specific. Regards, Heikki - Original Message - From: Steven Roussey [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Wednesday, August 28, 2002 6:10 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 [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
Re: 4.0.3 crashes every 5 seconds.
Subject: Re: 4.0.3 crashes every 5 seconds. From: Jocelyn Fournier [EMAIL PROTECTED] === 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 [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
Re: 4.0.3 crashes every 5 seconds.
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Wednesday 28 August 2002 05:02, Steven Roussey wrote: 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. Ouch! Thanks for the report. Can you please give us some more details? Which operating system (kernel, glibc), which package did you use? Fortunately I did not send out the announcement yet... Bye, LenZ - -- For technical support contracts, visit https://order.mysql.com/?ref=mlgr __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Lenz Grimmer [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE9bIB6SVDhKrJykfIRAtPKAJ9cpRmfSenXKY9lJUX5R2rp+lbTMQCfYg9Z eRdHC8jtmR+Tn9qvV0CchM8= =v1qU -END PGP SIGNATURE- - 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
RE: 4.0.3 crashes every 5 seconds.
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
RE: 4.0.3 crashes every 5 seconds.
It did not occur to me under after I sent the last email, that the binlog does not log every query. For our site, it does not even log every database. So I'm going to look a bit harder at the other log file... 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
RE: 4.0.3 crashes every 5 seconds.
Also, OS is ReadHat Linux 7.3 Glib is 2.2.5 Kernel is 2.4.18-10smp Two Athlon MPs and 1.5Gb RAM. Sincerely, Steven Roussey http://Network54.com/?pp=e -Original Message- From: Lenz Grimmer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 12:49 am To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; Jocelyn Fournier Subject: Re: 4.0.3 crashes every 5 seconds. -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Wednesday 28 August 2002 05:02, Steven Roussey wrote: 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. Ouch! Thanks for the report. Can you please give us some more details? Which operating system (kernel, glibc), which package did you use? Fortunately I did not send out the announcement yet... Bye, LenZ - -- For technical support contracts, visit https://order.mysql.com/?ref=mlgr __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Lenz Grimmer [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE9bIB6SVDhKrJykfIRAtPKAJ9cpRmfSenXKY9lJUX5R2rp+lbTMQCfYg9Z eRdHC8jtmR+Tn9qvV0CchM8= =v1qU -END PGP SIGNATURE- - 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
Re: 4.0.3 crashes every 5 seconds.
Hi,
On my side I'm still waiting for a real crash.
The server crashed this morning but it's quite odd since even the .err file
seems to be wrong this time.
I can only read :
/usr/local/mysql/libexec/mysqld: ready for connections
mysqld got signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help
diagnose
the problem, but since we have already crashed, something is definitely
wrong
and this may fail.
key_buffer_size=335540224
read_buffer_size=520192
Number of processes running now: 0
020828 09:20:17 mysqld restarted
020828 9:20:17 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 13 1844149035
InnoDB: Doing recovery: scanned up to log sequence number 13 1844179927
020828 9:20:17 InnoDB: Starting an apply batch of log records to the
database...
InnoDB: Progress in percents: 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54
55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79
80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
InnoDB: Last MySQL binlog file position 0 4183905, file name ./forum-bin.001
020828 9:20:18 InnoDB: Flushing modified pages from the buffer pool...
020828 9:20:18 InnoDB: Started
/usr/local/mysql/libexec/mysqld: ready for connections
As you can see, it misses several information after read_buffer_size.
The latest query executed before the crash were :
REPLACE INTO online (pseudo,date,cat,forum) VALUES
('Violette',1030519217,0,1);
UPDATE forumconthardwarefr7 SET vue=vue+1 WHERE numeropost='157896';
UPDATE forumconthardwarefrcache7 SET vue=vue+1 WHERE numeropost='157896';
REPLACE INTO guest (pseudo,date,forum) VALUES ('193.252.8.9',1030519217,1);
So it's an UPDATE followed by a REPLACE too. BTW forumconthardwarefrcache7,
guest and online are HEAP tables.
Regards,
Jocelyn
- Original Message -
From: Steven Roussey [EMAIL PROTECTED]
To: 'Jocelyn Fournier' [EMAIL PROTECTED]; 'Mysql'
[EMAIL PROTECTED]
Cc: 'Lenz Grimmer' [EMAIL PROTECTED]
Sent: Wednesday, August 28, 2002 10:20 PM
Subject: RE: 4.0.3 crashes every 5 seconds.
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
RE: 4.0.3 crashes every 5 seconds.
Lastly, we use the .tar.gz file of the linux binary made by MySQL AB. Sincerely, Steven Roussey http://Network54.com/?pp=e -Original Message- OS is ReadHat Linux 7.3 Glib is 2.2.5 Kernel is 2.4.18-10smp Two Athlon MPs and 1.5Gb RAM. Sql,query - 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
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
