this looks like the rollback bug in version 3.23.38. FromQuote:>I receive the following error when trying to restart mysql after it crashed.
>We use InnoDB tables for most of our tables. The tables are nearly empty,
>so limited tablespace or disk space do not seem to be problems. Any help
>you can give is much appreciated.
The rollback bug reported below on May 14th causes also a crash if you
rollback a transaction which has modified the same row more than once. Look
below for a fixed row0undo.c. Fixed in 3.23.39.
What MySQL version you are running? What is your operating system?
Please download version 3.23.44 from http://www.mysql.com
Now the recovery may succeed. A lot of bugs have been fixed to 3.23.44.
Since InnoDB is still in beta, it is recommended to upgrade often.
If the recovery does not succeed, then try adding the following to my.cnf:
set-variable = innodb_force_recovery = 4
and dump all your tables and recreate your database.
Please report to me if this advice worked.
>011104 22:36:58 mysqld started
>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 1657439
>InnoDB: Doing recovery: scanned up to log sequence number 0 1657821
>Innobase: 1 uncommitted transaction(s) which must be rolled back
>Innobase: Starting rollback of uncommitted transactions
>Innobase: Rolling back trx no 5444
>Innobase: Assertion failure in thread 1024 in file trx0roll.c line 887
>Innobase: we intentionally generate a memory trap.
>mysqld got signal 11;
>The manual section 'Debugging a MySQL server' tells you how to use a
>stack trace and/or the core file to produce a readable backtrace that may
>help in finding out why mysqld died.
>Attempting backtrace. You can use the following information to find out
>where mysqld died. If you see no messages after this, something went
>Bogus stack limit or frame pointer, aborting backtrace.
>Innobase: Thread 3076 stopped in file os0sync.c line 374
>011104 22:36:59 mysqld ended
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php