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 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
