MySQL died

Started by Bionic Antboy, April 04, 2005, 11:55:21 AM

Previous topic - Next topic

Bionic Antboy

I've been using a Mail Toaster setup for about 3 years with no problems to date.  We recently had a bad crash, and it appears that MySQL has died.

I've tried logging in, but it won't accept known sername/password
combos, and get the following error...

-----
ERROR 2002: Can't connecto to local MySQL server through socket
'/usr/mysql.sock' (61)
-----

Here's what the errorlog in /var/db/mysql reports:

-----
050404 11:40:30  mysqld started
050404 11:40:31  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 0 43892
InnoDB: Doing recovery: scanned up to log sequence number 0 43892
InnoDB: Error: trying to access a stray pointer 8a193ff8
InnoDB: buf pool start is at 99a0000, number of pages 512
050404 11:40:31  InnoDB: Assertion failure in thread 138162176 in file
../../innobase/page/../include/buf0buf.ic line 284
InnoDB: We intentionally generate a memory trap.
InnoDB: Send a detailed bug report to mailto:mysql@lists.mysql.com" target="_blank">mysql@lists.mysql.com
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=8388600
read_buffer_size=131072
sort_buffer_size=0
max_used_connections=0
max_connections=100
threads_connected=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size +
sort_buffer_size)*max_connections = 20991 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

050404 11:40:31  mysqld ended
-----

Because my MySQL knowledge isn't barely above noob level, I'm not sure where I should be replacing files, or if I should do a re-install...

Any help would be greatly appreciated...

Thanks.

matt

try just disabling the InnoDB stuff by adding one of these options to /etc/my.cnf:

skip-innodb            
skip-innodb        = 1

which one depends on your version of MySQL. See mysql.com for details.

Bionic Antboy

Thanks matt!

That helped.  Of course, it happened just as I was prepping to build an all new system, too!.