mysql55: "The server quit without updating PID file"

[eric.lebigot@…]

When I start mysql with

sudo /opt/local/share/mysql55/support-files/mysql.server start

it fails with

Starting MySQL
. ERROR! The server quit without updating PID file (/opt/local/var/db/mysql55/weinberg.local.pid).

It used to work (I believe before the August 5th, 2013 version), and I haven't touched MySQL.

The error logs in /opt/local/var/db/mysql55 are created by are empty.

I searched the web for solutions, tried many things (changing permissions, ownerships, deleting log files,…), to no avail.

[eric.lebigot@…]

PS: I get the exact same problem with mysql56 after installing it.

[tdsimpson@…]

Cc Me!

[auke@…]

I found the problem (at least in mysql56). It's an if-statement in /opt/local/lib/mysql56/bin/mysqld_safe at line 725.

When you remove lines 725, 726 and 729 from mysqld_safe, the server will start.

[eric.lebigot@…]

Yeah, something like this. :)

There is actually another ticket (​https://trac.macports.org/ticket/40040) that indicates that an "if" test is missing. Line 726 of /opt/local/lib/mysql55/bin/mysqld_safe should be:

if ps -ef | grep -v mysqld_safe | grep -- $MYSQLD | grep $PID > /dev/null

[burtonpatrick0@…]

Replying to eric.lebigot@…:

Yeah, something like this. :)

There is actually another ticket (​https://trac.macports.org/ticket/40040) that indicates that an "if" test is missing. Line 726 of /opt/local/lib/mysql55/bin/mysqld_safe should be:

if ps -ef | grep -v mysqld_safe | grep -- $MYSQLD | grep $PID > /dev/null

Just to clarify. You mean line 725 should read if ps -ef | grep -v mysqld_safe | grep -- $MYSQLD | grep $PID > /dev/null not 726. I just modified the line for 725 and it worked. Thanks for the tip!

[eric.lebigot@…]

Yes, indeed, you're right.

[pixilla (Bradley Giesbrecht)]

Duplicate of #40040