Bug #19590 mysqld only starts once and fails on consequent starts
Submitted: 7 May 2006 2:24 Modified: 7 May 2006 10:54
Reporter: Øyvind Kinsey Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:5.0.19-r1 OS:Linux (Linux 2.6.16-gentoo-r3)
Assigned to: CPU Architecture:Any

[7 May 2006 2:24] Øyvind Kinsey
Description:
mysqld starts successfully after a emerge --config =dev-db/mysql-5.0.19-r1
(inits the db and sets the root password).
If I start and stop the mysqld via /etc/init.d/mysql start/stop and try to start it again it shows:
 *  ...
 * Starting mysql (/etc/mysql/my.cnf)
 * MySQL NOT started (0)                                                  [ !! ]

If I delete the file ibdata1 that is created in the data folder then the server works again. 
Is this supposed to be deleted at exit?

This is a freshly build system

How to repeat:
Emerge mysql-5.0.19-r1 on Linux 2.6.16-gentoo-r3
Start mysqld
stop mysqld
start mysql again.
[7 May 2006 10:54] Alexander Keremidarski
Please try repeating that with MySQL installed from official binary downloaded from http://dev.mysql.com/downloads/mysql/5.0.html

The messages you get don't come from rc.init startup script provided by MySQL. 

With regard of ibdata files refer to the MySQL Manual. Bugs database is not the proper place to ask such questions.
[7 May 2006 10:55] Alexander Keremidarski
Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.mysql.com/how-to-report.php

If you can provide more information, feel free to add it
to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.