[opensuse] 11.4 / mysql does not start automatically
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, I recently upgraded my home server from OS11.2 to OS11.4 (fresh install). Since then, the mysql doesn't start automatically any more. mysqld.log says: 110419 15:06:32 mysqld_safe mysqld from pid file /var/run/mysql/mysqld.pid ended 110419 15:26:52 mysqld_safe Starting mysqld daemon with databases from /server/mysql 110419 15:26:54 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead. ^G/usr/sbin/mysqld: File './mysql-bin.~rec~' not found (Errcode: 13) 110419 15:26:54 [ERROR] MYSQL_BIN_LOG::open_purge_index_file failed to open register file. 110419 15:26:54 [ERROR] MYSQL_BIN_LOG::open_index_file failed to sync the index file. 110419 15:26:54 [ERROR] Aborting 110419 15:26:54 [Note] /usr/sbin/mysqld: Shutdown complete If I try starting it manually with rcmysql start after the machine has booted up, is goes without problems. Any hints? - -S - -- (o_ Stefan Gofferje | SCLT, MCP, CCSA //\ Reg'd Linux User #247167 | VCP #2263 V_/_ Heckler & Koch - the original point and click interface -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.16 (GNU/Linux) iEYEARECAAYFAk2tz6sACgkQbQKZlCdPOMPayQCgstJwFtuN7IPp7VoTVoV1xD7H LRAAnj4KKymBSVfbCVeSxxRKKDFNw/9x =cEbD -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
Stefan Gofferje wrote:
I recently upgraded my home server from OS11.2 to OS11.4 (fresh install). Since then, the mysql doesn't start automatically any more. mysqld.log says:
If I try starting it manually with rcmysql start after the machine has booted up, is goes without problems.
Any hints?
There was some chatter on the forum about some change in network initialization that affected mysql. I didn't follow the details but it would be worth searching. Cheers, Dave -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On 04/20/2011 12:56 PM, Dave Howorth wrote:
Any hints?
There was some chatter on the forum about some change in network initialization that affected mysql. I didn't follow the details but it would be worth searching.
https://bugzilla.novell.com/show_bug.cgi?id=675870 Quick fix: 3. edit /etc/init.d/mysql 4. remove run level 2 from "Default-Start:" 5. chkconfig --add mysql -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
Hi, On Wednesday 20 April 2011, Silviu Marin-Caea wrote:
That's not it. I already suspected something like that and took mysql out of runlevel 2. It still doesn't start in the boot process... -S -- (o_ Stefan Gofferje | SCLT, MCP, CCSA //\ Reg'd Linux User #247167 | VCP #2263 V_/_ Heckler & Koch - the original point and click interface -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On 04/20/2011 07:20 PM, Stefan Gofferje wrote:
Hi,
On Wednesday 20 April 2011, Silviu Marin-Caea wrote:
That's not it. I already suspected something like that and took mysql out of runlevel 2. It still doesn't start in the boot process...
Can you verify that it's really enabled? chkconfig --list mysql also ls -l /etc/init.d/rc3.d/*mysql /etc/init.d/rc5.d/*mysql -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
Hi, On Friday 22 April 2011, Silviu Marin-Caea wrote:
Can you verify that it's really enabled?
chkconfig --list mysql
also
ls -l /etc/init.d/rc3.d/*mysql /etc/init.d/rc5.d/*mysql
Double checked... If it wasn't enabled, there wouldn't be "Starting mysql... failed" in the boot sequence and also no error messages in mysqld.log ;). -S -- (o_ Stefan Gofferje | SCLT, MCP, CCSA //\ Reg'd Linux User #247167 | VCP #2263 V_/_ Heckler & Koch - the original point and click interface
Stefan Gofferje wrote:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Hi,
I recently upgraded my home server from OS11.2 to OS11.4 (fresh install). Since then, the mysql doesn't start automatically any more. mysqld.log says:
110419 15:06:32 mysqld_safe mysqld from pid file /var/run/mysql/mysqld.pid ended 110419 15:26:52 mysqld_safe Starting mysqld daemon with databases from /server/mysql 110419 15:26:54 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead. ^G/usr/sbin/mysqld: File './mysql-bin.~rec~' not found (Errcode: 13) 110419 15:26:54 [ERROR] MYSQL_BIN_LOG::open_purge_index_file failed to open register file. 110419 15:26:54 [ERROR] MYSQL_BIN_LOG::open_index_file failed to sync the index file. 110419 15:26:54 [ERROR] Aborting
110419 15:26:54 [Note] /usr/sbin/mysqld: Shutdown complete
If I try starting it manually with rcmysql start after the machine has booted up, is goes without problems.
Any hints?
I think errcode 13 indicates a permission problem - have you looked at that? -- Per Jessen, Zürich (15.4°C) -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Friday 22 April 2011, Per Jessen wrote:
I think errcode 13 indicates a permission problem - have you looked at that?
Not really. I am not familiar with the mysqld start-process. At least this file mysql-bin.~rec~ is nowhere on the fs. But it only doesn't start AUTOMATICALLY. If I login as root immediately after boot, rcmysql start works fine... -S -- (o_ Stefan Gofferje | SCLT, MCP, CCSA //\ Reg'd Linux User #247167 | VCP #2263 V_/_ Heckler & Koch - the original point and click interface
Stefan Gofferje wrote:
On Friday 22 April 2011, Per Jessen wrote:
I think errcode 13 indicates a permission problem - have you looked at that?
Not really. I am not familiar with the mysqld start-process. At least this file mysql-bin.~rec~ is nowhere on the fs.
But it only doesn't start AUTOMATICALLY. If I login as root immediately after boot, rcmysql start works fine...
Yeah, I did notice you said that. How about the permissions for your server directory? /server/mysql ? -- Per Jessen, Zürich (18.8°C) -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Friday 22 April 2011, Per Jessen wrote:
Yeah, I did notice you said that. How about the permissions for your server directory? /server/mysql ?
root:root 0775 I changed it to mysql:mysql now to test... Although... during the boot process, the rc-scripts are run as root, right? So, the dir permissions shouldn't make any difference between /etc/init.d/mysql being run by the boot process or by hand as root. Let's see. -S -- (o_ Stefan Gofferje | SCLT, MCP, CCSA //\ Reg'd Linux User #247167 | VCP #2263 V_/_ Heckler & Koch - the original point and click interface
Stefan Gofferje wrote:
On Friday 22 April 2011, Per Jessen wrote:
Yeah, I did notice you said that. How about the permissions for your server directory? /server/mysql ?
root:root 0775
I changed it to mysql:mysql now to test... Although... during the boot process, the rc-scripts are run as root, right?
Yes, but mysqld is running as mysql. And it's not the init-script that is complaining, it's mysqld.
So, the dir permissions shouldn't make any difference between /etc/init.d/mysql being run by the boot process or by hand as root.
I agree, I don't see how that makes a difference. -- Per Jessen, Zürich (20.4°C) -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
Per Jessen wrote:
Stefan Gofferje wrote:
On Friday 22 April 2011, Per Jessen wrote:
Yeah, I did notice you said that. How about the permissions for your server directory? /server/mysql ?
root:root 0775
I changed it to mysql:mysql now to test... Although... during the boot process, the rc-scripts are run as root, right?
Yes, but mysqld is running as mysql. And it's not the init-script that is complaining, it's mysqld.
So, the dir permissions shouldn't make any difference between /etc/init.d/mysql being run by the boot process or by hand as root.
I agree, I don't see how that makes a difference.
One mysql difference between 11.3 and 11.4 I've just noticed - in 11.3, the mysql group-id was 108, in 11.4 it's 105. Did you get your mysql to run, Stefan? -- Per Jessen, Zürich (15.6°C) -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Tuesday 26 April 2011, Per Jessen wrote:
Did you get your mysql to run, Stefan?
I have planned a maintenance reboot for tomorrow afternoon. I will report. -S -- (o_ Stefan Gofferje | SCLT, MCP, CCSA //\ Reg'd Linux User #247167 | VCP #2263 V_/_ Heckler & Koch - the original point and click interface
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Took some time longer before I could reboot. But changing the owner/rights seemingly did it. MySQL is starting at boot time now. - -- (o_ Stefan Gofferje | SCLT, MCP, CCSA //\ Reg'd Linux User #247167 | VCP #2263 V_/_ Heckler & Koch - the original point and click interface -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.16 (GNU/Linux) iEYEARECAAYFAk3KfQIACgkQbQKZlCdPOMNQcACff6cf8BrriFyns6IH8iiQgGkK C28AnRn/Bv0/0PfaYvkKzvewPjczvzDG =4THD -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
participants (4)
-
Dave Howorth -
Per Jessen -
Silviu Marin-Caea -
Stefan Gofferje