Comment 22 for bug 316974

Revision history for this message
ekinsokmen (ekin-sokmen) wrote :

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.