hi!
I am hoping someone has experienced this before or knows how we can resolve
this. I am running into an innodb assertion error (see below) and cannot
reproduce it. It has happened 3-4 times, MySQL crashes and sometimes
recovers and other times it is unable to recover (MySQL repeatedly
MySQL 3.2.3 installed in our server suddenly started giving problem after
restarting the server m/c.
/etc/init.d/mysqld status sys,
mysqld dead but subsys locked
Checked the log file and found that there is some Assertion failure for InnoDB,
can you pls. provide a possible solution for this.
Hello.
I don't see any attempts from InnoDB to recover the data, so
it is crashing before the recovering. To save your data, if you're
unable to get tables with mysqldump, this might be helpful:
http://dev.mysql.com/doc/refman/5.0/en/forcing-recovery.html
MySQL 3.2.3 installed in
- a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php
- Original Message -
From: Gleb Paharenko [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Thursday, November 10, 2005 12:42 AM
Subject: Re: InnoDb assertion error
Hello.
I
Philip,
- Forwarded message from Philip Molter [EMAIL PROTECTED] -
Date: Mon, 10 Mar 2003 08:30:22 -0600
From: Philip Molter [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: InnoDB Assertion Error
THE SITUATION:
We're running MySQL 3.23.51. We have a table which has a primary
THE SITUATION:
We're running MySQL 3.23.51. We have a table which has a primary-keyed
field 'sid'. We have four tables what have foreign key references
on that field. We deleted all rows from those four tables that
had values in that foreign key index and then tried to delete the
row in the