I have the same issue and used the same solution (chowning 2 files in
/var/lib/mysql/mysql-bin.*). When I "apt-get-upgrade" the issue reappears:
##### mysql output #####
root@mail:/var/log# apt-get upgrade
Reading package lists... Done
Building dependency tree
Reading state information... Done
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
2 not fully installed or removed.
After this operation, 0 B of additional disk space will be used.
Do you want to continue [Y/n]? Y
Setting up mysql-server-5.1 (5.1.61-0+squeeze1) ...
Stopping MySQL database server: mysqld.
insserv: warning: script 'additional_ips.sh' missing LSB tags and overrides
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing mysql-server-5.1 (--configure):
subprocess installed post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of mysql-server:
mysql-server depends on mysql-server-5.1; however:
Package mysql-server-5.1 is not configured yet.
dpkg: error processing mysql-server (--configure):
dependency problems - leaving unconfigured
configured to not write apport reports
configured to not write apport reports
Errors were encountered while processing:
mysql-server-5.1
mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)
##### uname #####
root@mail:/# uname -a
Linux mail.host.de 2.6.32-5-amd64 #1 SMP Mon Oct 3 03:59:20 UTC 2011 x86_64
GNU/Linux
##### syslog #####
The log part from /var/log/syslog:
Mar 8 09:53:31 mail mysqld_safe[24603]: 120308 9:53:31 [Warning]
'--skip-locking' is deprecated and will be removed in a future release. Please
use '--skip-external-locking' instead.
Mar 8 09:53:31 mail mysqld_safe[24603]: 120308 9:53:31 [Warning] '--log' is
deprecated and will be removed in a future release. Please use
''--general_log'/'--general_log_file'' instead.
Mar 8 09:53:31 mail mysqld_safe[24603]: 120308 9:53:31 [Warning]
'--skip-locking' is deprecated and will be removed in a future release. Please
use '--skip-external-locking' instead.
Mar 8 09:53:31 mail mysqld_safe[24603]: 120308 9:53:31 [Warning] '--log' is
deprecated and will be removed in a future release. Please use
''--general_log'/'--general_log_file'' instead.
Mar 8 09:53:31 mail mysqld_safe[24603]:
Mar 8 09:53:31 mail mysqld_safe[24603]: PLEASE REMEMBER TO SET A PASSWORD FOR
THE MySQL root USER !
Mar 8 09:53:31 mail mysqld_safe[24603]: To do so, start the server, then issue
the following commands:
Mar 8 09:53:31 mail mysqld_safe[24603]:
Mar 8 09:53:31 mail mysqld_safe[24603]: /usr/bin/mysqladmin -u root password
'new-password'
Mar 8 09:53:31 mail mysqld_safe[24603]: /usr/bin/mysqladmin -u root -h
mail.host.de password 'new-password'
Mar 8 09:53:31 mail mysqld_safe[24603]:
Mar 8 09:53:31 mail mysqld_safe[24603]: Alternatively you can run:
Mar 8 09:53:31 mail mysqld_safe[24603]: /usr/bin/mysql_secure_installation
Mar 8 09:53:31 mail mysqld_safe[24603]:
Mar 8 09:53:31 mail mysqld_safe[24603]: which will also give you the option of
removing the test
Mar 8 09:53:31 mail mysqld_safe[24603]: databases and anonymous user created
by default. This is
Mar 8 09:53:31 mail mysqld_safe[24603]: strongly recommended for production
servers.
Mar 8 09:53:31 mail mysqld_safe[24603]:
Mar 8 09:53:31 mail mysqld_safe[24603]: See the manual for more instructions.
Mar 8 09:53:31 mail mysqld_safe[24603]:
Mar 8 09:53:31 mail mysqld_safe[24603]: Please report any problems with the
/usr/bin/mysqlbug script!
Mar 8 09:53:31 mail mysqld_safe[24603]:
Mar 8 09:53:31 mail mysqld_safe[24634]: 120308 9:53:31 [Warning]
'--skip-locking' is deprecated and will be removed in a future release. Please
use '--skip-external-locking' instead.
Mar 8 09:53:31 mail mysqld_safe[24634]: 120308 9:53:31 [Warning] '--log' is
deprecated and will be removed in a future release. Please use
''--general_log'/'--general_log_file'' instead.
Mar 8 09:53:31 mail mysqld_safe[24634]: 120308 9:53:31 [Note] Plugin
'FEDERATED' is disabled.
Mar 8 09:53:31 mail mysqld_safe[24634]: 120308 9:53:31 InnoDB: Initializing
buffer pool, size = 8.0M
Mar 8 09:53:31 mail mysqld_safe[24634]: 120308 9:53:31 InnoDB: Completed
initialization of buffer pool
Mar 8 09:53:32 mail mysqld_safe[24634]: 120308 9:53:32 InnoDB: Started; log
sequence number 0 10139064
Mar 8 09:53:32 mail mysqld_safe[24634]: #007/usr/sbin/mysqld: File
'./mysql-bin.000153' not found (Errcode: 13)
Mar 8 09:53:32 mail mysqld_safe[24634]: 120308 9:53:32 [ERROR] Failed to open
log (file './mysql-bin.000153', errno 13)
Mar 8 09:53:32 mail mysqld_safe[24634]: 120308 9:53:32 [ERROR] Could not open
log file
Mar 8 09:53:32 mail mysqld_safe[24634]: 120308 9:53:32 [ERROR] Can't init tc
log
Mar 8 09:53:32 mail mysqld_safe[24634]: 120308 9:53:32 [ERROR] Aborting
Mar 8 09:53:32 mail mysqld_safe[24634]:
Mar 8 09:53:32 mail mysqld_safe[24634]: 120308 9:53:32 InnoDB: Starting
shutdown...
I will gladly send you more information.
Regards
Benedikt
--
To UNSUBSCRIBE, email to [email protected]
with a subject of "unsubscribe". Trouble? Contact [email protected]
