MySQL Bugs: #3909: Start-up problems

Bug #3909	Start-up problems
Submitted:	27 May 2004 8:50	Modified:	27 May 2004 9:45
Reporter:	[ name withheld ]	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Administrator	Severity:	S1 (Critical)
Version:	3.2x	OS:	Sun Solris
Assigned to:		CPU Architecture:	Any

Description:
Not able to start MySql server properly. It gives the following messages when tried to start. Please help!!

040526 23:41:45  mysqld started
040526 23:41:46  bdb:  Log sequence error: page LSN 1153:10148110; previous LSN 1153 10151442
040526 23:41:46  bdb:  Log sequence error: page LSN 1153:10148110; previous LSN 1153 10152032
040526 23:41:46  bdb:  Log sequence error: page LSN 1153:10148110; previous LSN 1153 10152818
040526 23:41:46  bdb:  Log sequence error: page LSN 1153:10148110; previous LSN 1153 10183631
040526 23:41:46  bdb:  Log sequence error: page LSN 1153:10148110; previous LSN 1153 10184327
040526 23:41:53  bdb:  ./db_name/table_name.db: close: 5 blocks left pinned
040526 23:41:53  Can't init databases
040526 23:41:53  mysqld ended

How to repeat:
Try to Start MySql server.

Thank you for taking the time to report a problem.  Unfortunately
you are not using a current version of the product your reported a
problem with -- the problem might already be fixed. Please download
a new version from http://www.mysql.com/downloads/

If you are able to reproduce the bug with one of the latest versions,
please change the version on this bug report to the version you
tested and change the status back to "Open".  Again, thank you for
your continued support of MySQL.

Additional info:

Please upgrade to our 4.0.X version as 3.X is obsolete.

Looking at the following web-page as it will probably help: http://dev.mysql.com/doc/mysql/en/Starting_server.html

I understand that we are not using the current version of MySql and would like to upgrade as soon as possible. But until then, could you suggest a solution to overcome this problem as we cannot afford to have the database down for too long. The server was working properly untill recently and only started giving problems since the last two days.

Thanks again for your help!

We could able to fix the problem temporarily. Thanks again for your help.

Please try starting mysqld with --bdb-no-recover. If this helps, then you should remove all `log.*' files from the data directory and try starting mysqld again.

Also, bugs.mysql.com is for reporting bugs only.  If you have problems or questions please use our general mailing list instead.

If you can't afford downtime at all or if you don't want to use our mailing lists, I suggest you purchase one of our support contracts (http://www.mysql.com/support/) and you'll for sure be taken care of in no time.

Our company relies on support contracts to continue the development of MySQL and we can't afford to provide free support :(