[Bug 316974] Re: Mysql dead after update

[ekinsokmen]

The problem seems to be caused by some permission issue on mysql binary
log files. After the upgrade mysql failed to start. Trying to start
mysql service manually (service start mysql) also failed with following
error:

100215 13:58:01 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100215 13:58:01 [Note] Plugin 'FEDERATED' is disabled.
100215 13:58:02  InnoDB: Started; log sequence number 0 698955389
^G/usr/sbin/mysqld: File './ekins-bin.000067' not found (Errcode: 13)
100215 13:58:02 [ERROR] Failed to open log (file './ekins-bin.000067', errno 13)
100215 13:58:02 [ERROR] Could not open log file
100215 13:58:02 [ERROR] Can't init tc log
100215 13:58:02 [ERROR] Aborting

in /var/lib/mysql directory these two files have root permission instead of mysql. 
-rw-rw---- 1 root  root        586 2010-02-15 14:08 ekins-bin.000069
-rw-rw---- 1 root  root     712394 2010-02-15 14:08 ekins-bin.000070

After running "chown mysql:mysql /var/lib/mysql/*"  I can start mysql
manually running "service start mysql" and it  works. But if I trigger
dpkg to configure the failed packages mysql-server and mysql-server-5.1
same error occurs and permissions of last created bin files are set to
"root" user again.

-- 
Mysql dead after update
https://bugs.launchpad.net/bugs/316974
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu.