11.4 / mysql does not start automatically

[Stefan Gofferje]

-----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-----

[Dave Howorth]

Post by Stefan Gofferje
I recently upgraded my home server from OS11.2 to OS11.4 (fresh install).
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

[Silviu Marin-Caea]

Post by Dave Howorth

Post by Stefan Gofferje
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

[Stefan Gofferje]

Hi,

Post by Silviu Marin-Caea
https://bugzilla.novell.com/show_bug.cgi?id=675870

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

[Silviu Marin-Caea]

Post by Stefan Gofferje
Hi,

Post by Silviu Marin-Caea
https://bugzilla.novell.com/show_bug.cgi?id=675870

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

[Stefan Gofferje]

Hi,

Post by Silviu Marin-Caea
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

[Per Jessen]

Post by Stefan Gofferje
-----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.
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?

[Stefan Gofferje]

Post by Per Jessen
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

[Per Jessen]

Post by Stefan Gofferje

Post by Per Jessen
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 ?

[Stefan Gofferje]

Post by Per Jessen
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

[Per Jessen]

Post by Stefan Gofferje

Post by Per Jessen
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.

Post by Stefan Gofferje
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]

Post by Per Jessen

Post by Stefan Gofferje

Post by Per Jessen
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.

Post by Stefan Gofferje
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?

[Stefan Gofferje]

Post by Per Jessen
Did you get your mysql to run, Stefan?

I have planned a maintenance reboot for tomorrow afternoon. I will report.

-S

[Stefan Gofferje]

-----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-----