Hi Guys,

I have CentOS 4.4, kernel 2.6.9-55.ELsmp. Originally, I had installed MySQL-4.4.7 from source. It worked great for months until a couple of days ago I read a message on screen stating that needed to restart server to fix a mysql issue. After restarting server, when I try to start MySQL all I get is:

Number of processes running now: 0
071202 12:03:50 mysqld restarted

Number of processes running now: 0
071202 12:03:50 mysqld restarted

Number of processes running now: 0
071202 12:03:50 mysqld restarted

Number of processes running now: 0
071202 12:03:50 mysqld restarted

Number of processes running now: 0
071202 12:03:50 mysqld restarted

Number of processes running now: 0
071202 12:03:50 mysqld restarted

Number of processes running now: 0
071202 12:03:50 mysqld restarted

Number of processes running now: 0
071202 12:03:50 mysqld restarted

I upgraded with a fresh installation to Mysql-5.0.45.tar.gz, but once I try to start mysql, same error happens. What can I do to fix it please. This is a production server. Thanks God I have a backup of mysql database.

What can I do to fix this problem. All help is greatly appreciated.

Did you run "make uninstall" in the source directory for the previous mysql version? If not, you may have all kinds of conflicting files.

I recommend running "make uninstall" in the newest version first, and the "make uninstall" in the older version. Then try building the newer version again.

Also, pore over your mysqld.log file for any other pertinent information. You might find interesting information in "/var/log/debug". There is always useful information in the output of "dmesg" and "/var/log/messages".

Hi David,

Thanks for you help. I uninstaled both versions, 5.0.45 first, then 4.0.27. Then reinstalled mysql-5.0.45. Unfortunately, it still doesn't start. Here is the mysqld.log. Please, advice.


071129 23:28:20 mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
071129 23:28:20 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
071129 23:28:20 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
071129 23:28:21 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
071129 23:28:21 InnoDB: Started; log sequence number 0 0
071129 23:28:21 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.22' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
071130 2:49:47 [Note] /usr/libexec/mysqld: Normal shutdown

071130 2:49:47 InnoDB: Starting shutdown...
071130 2:49:49 InnoDB: Shutdown completed; log sequence number 0 43655
071130 2:49:49 [Note] /usr/libexec/mysqld: Shutdown complete

071130 02:49:49 mysqld ended

071202 01:26:17 mysqld started
071202 1:26:17 InnoDB: Started; log sequence number 0 43655
071202 1:26:17 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.22' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
071202 2:38:38 [Note] /usr/libexec/mysqld: Normal shutdown

071202 2:38:38 InnoDB: Starting shutdown...
071202 2:38:39 InnoDB: Shutdown completed; log sequence number 0 43655
071202 2:38:39 [Note] /usr/libexec/mysqld: Shutdown complete

071202 02:38:39 mysqld ended

071202 20:49:12 mysqld started
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process


InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
071202 20:50:03 InnoDB: Started; log sequence number 0 43655
071202 20:50:03 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

071202 20:50:03 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.0.45' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
071202 20:50:03 InnoDB: Starting shutdown...
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
071202 21:02:02 mysqld started
071202 21:02:04 InnoDB: Started; log sequence number 0 43655
071202 21:02:05 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.0.45' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
071202 21:07:20 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

071202 21:07:20 InnoDB: Starting shutdown...
071202 21:07:22 InnoDB: Shutdown completed; log sequence number 0 43655
071202 21:07:22 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

071202 21:07:22 mysqld ended

Some slackware users solved their problem by changing the ownership of some files and directories to the mysql user:

Starting MySQL on Slackware

You might be experiencing the same problem if you installed MySQL as root.