Bug #6430 Changing engine from BDB to InnoDB prevents MySQL from starting.
Submitted: 4 Nov 2004 11:37 Modified: 13 Nov 2004 17:48
Reporter: Christian Hammers (Silver Quality Contributor) (OCA) Email Updates:
Status: Won't fix Impact on me:
Category:MySQL Server Severity:S2 (Serious)
Version:4.0.22 OS:Linux (Debian GNU/Linux)
Assigned to: Sergei Golubchik CPU Architecture:Any

[4 Nov 2004 11:37] Christian Hammers
Reported as Debian bug report by Laurent Defours <laurent.defours@laposte.net>
I could reproduce the problem. Original report at http://bugs.debian.org/279634

I created a BDB table and changed it to InnoDB afterwards. Then, mysqld fails to
start with the following error:

mysqld[9717]: 041104  9:42:19 bdb:  Recovery function for LSN 1 29242 failed
mysqld[9717]: 041104  9:42:19 Can't init databases
mysqld[9717]: 041104  9:42:19 Aborting

I found a bdb log file log.XXXXXXXXXX
Everything is fine again after its deletion.

How to repeat:

Suggested fix:
[13 Nov 2004 17:48] Sergei Golubchik
This is fixed in 4.1 - where we have newer bdb version (4.1.24 instead of 3.2.9 in 4.0)