[debian-mysql] Bug#663000:

Sprite Service spriteserviceline at hotmail.com
Thu Mar 8 09:33:37 UTC 2012


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

 		 	   		  




More information about the pkg-mysql-maint mailing list