[MacPorts] #40273: mysql55: "The server quit without updating PID file"
#40273: mysql55: "The server quit without updating PID file" ----------------------------+-------------------------------- Reporter: eric.lebigot@… | Owner: macports-tickets@… Type: defect | Status: new Priority: Normal | Milestone: Component: ports | Version: 2.2.0 Keywords: | Port: ----------------------------+-------------------------------- 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. -- Ticket URL: <https://trac.macports.org/ticket/40273> MacPorts <http://www.macports.org/> Ports system for OS X
#40273: mysql55: "The server quit without updating PID file" -----------------------------+----------------------- Reporter: eric.lebigot@… | Owner: pixilla@… Type: defect | Status: new Priority: Normal | Milestone: Component: ports | Version: 2.2.0 Resolution: | Keywords: Port: mysql55 | -----------------------------+----------------------- Changes (by ryandesign@…): * owner: macports-tickets@… => pixilla@… * port: => mysql55 -- Ticket URL: <https://trac.macports.org/ticket/40273#comment:1> MacPorts <http://www.macports.org/> Ports system for OS X
#40273: mysql55: "The server quit without updating PID file" -----------------------------+----------------------- Reporter: eric.lebigot@… | Owner: pixilla@… Type: defect | Status: new Priority: Normal | Milestone: Component: ports | Version: 2.2.0 Resolution: | Keywords: Port: mysql55 | -----------------------------+----------------------- Comment (by eric.lebigot@…): PS: I get the exact same problem with mysql56 after installing it. -- Ticket URL: <https://trac.macports.org/ticket/40273#comment:2> MacPorts <http://www.macports.org/> Ports system for OS X
#40273: mysql55: "The server quit without updating PID file" -----------------------------+----------------------- Reporter: eric.lebigot@… | Owner: pixilla@… Type: defect | Status: new Priority: Normal | Milestone: Component: ports | Version: 2.2.0 Resolution: | Keywords: Port: mysql55 | -----------------------------+----------------------- Comment (by 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. -- Ticket URL: <https://trac.macports.org/ticket/40273#comment:4> MacPorts <http://www.macports.org/> Ports system for OS X
Do you mean these lines? *725*: if <br> then # The pid contains a mysqld process <br> log_error "A mysqld process already exists" <br> exit 1 <br> fi <br> fi <br> it didn't work for me. -- View this message in context: http://mac-os-forge.2317878.n4.nabble.com/MacPorts-40273-mysql55-The-server-... Sent from the MacPorts - Tickets mailing list archive at Nabble.com.
#40273: mysql55: "The server quit without updating PID file" -----------------------------+----------------------- Reporter: eric.lebigot@… | Owner: pixilla@… Type: defect | Status: new Priority: Normal | Milestone: Component: ports | Version: 2.2.0 Resolution: | Keywords: Port: mysql55 | -----------------------------+----------------------- Comment (by 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 -- Ticket URL: <https://trac.macports.org/ticket/40273#comment:5> MacPorts <http://www.macports.org/> Ports system for OS X
#40273: mysql55: "The server quit without updating PID file" -----------------------------+----------------------- Reporter: eric.lebigot@… | Owner: pixilla@… Type: defect | Status: new Priority: Normal | Milestone: Component: ports | Version: 2.2.0 Resolution: | Keywords: Port: mysql55 | -----------------------------+----------------------- Comment (by burtonpatrick0@…): Replying to [comment:5 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! -- Ticket URL: <https://trac.macports.org/ticket/40273#comment:6> MacPorts <http://www.macports.org/> Ports system for OS X
#40273: mysql55: "The server quit without updating PID file" -----------------------------+----------------------- Reporter: eric.lebigot@… | Owner: pixilla@… Type: defect | Status: new Priority: Normal | Milestone: Component: ports | Version: 2.2.0 Resolution: | Keywords: Port: mysql55 | -----------------------------+----------------------- Comment (by eric.lebigot@…): Yes, indeed. If you start counting at 1 and not 0. :) -- Ticket URL: <https://trac.macports.org/ticket/40273#comment:7> MacPorts <http://www.macports.org/> Ports system for OS X
#40273: mysql55: "The server quit without updating PID file" -----------------------------+----------------------- Reporter: eric.lebigot@… | Owner: pixilla@… Type: defect | Status: closed Priority: Normal | Milestone: Component: ports | Version: 2.2.0 Resolution: duplicate | Keywords: Port: mysql55 | -----------------------------+----------------------- Changes (by pixilla@…): * status: new => closed * resolution: => duplicate Comment: Duplicate of #40040 -- Ticket URL: <https://trac.macports.org/ticket/40273#comment:8> MacPorts <http://www.macports.org/> Ports system for OS X
participants (2)
-
MacPorts
-
scientist1642