Re: Major upgrade on MySQL (5.0.xx to 5.1.xx)

Thanks Simon. Turned out to be a red herring. Stopping a non-existent instance from the Zend ZCMYSQL menu generates that error. I had started the instance, which silently failed, and then later when I stopped it, it really wasn't running and generated that error because the process wasn't running. Of course something more helpful like, "The instance is not running" as a message would be a lot more helpful but ....

I still cannot start this upgraded instance using the ZCMYSQL menu. I CAN start it using the mysqld command from PASE so be it must be something in the Zend configuration that is causing the error. I may toss this over to the Zend folks.

Pete


Simon Coulter wrote:

On 07/01/2010, at 7:35 AM, Pete Helgren wrote:

Cannot open /usr/local/mysqldata/zmysql.pid.

Looks hosed up. Can anyone help?

.pid files are usually Process ID files often used as part of a half- arsed locking mechanism, or so a "stop" function can determine the "active" process. Check permissions to the file and the directories in the path. Probably can just delete the file and let it be recreated on start.

A Google search on mysql and pid may help you too.

Regards,
Simon Coulter.
--------------------------------------------------------------------
FlyByNight Software OS/400, i5/OS Technical Specialists

http://www.flybynight.com.au/
Phone: +61 2 6657 8251 Mobile: +61 0411 091 400 /"\
Fax: +61 2 6657 8251 \ /
X
ASCII Ribbon campaign against HTML E-Mail / \
--------------------------------------------------------------------