Bug#682232: [debian-mysql] Bug#682232: mysql-server-5.5: Fails to upgrade squeeze - wheezy, does not start
On Fri, Jul 20, 2012 at 09:06:12PM +0100, Nicholas Bamber wrote: After that relevant sections from syslog please. Already sent several hours before your mail. -- Antti-Juhani Kaijanaho, Jyväskylä, Finland http://antti-juhani.kaijanaho.fi/newblog/ http://www.flickr.com/photos/antti-juhani/ -- To UNSUBSCRIBE, email to debian-bugs-rc-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Bug#682232: [debian-mysql] Bug#682232: mysql-server-5.5: Fails to upgrade squeeze - wheezy, does not start
On Fri, Jul 20, 2012 at 10:24:08PM +0200, Julien Cristau wrote: There's nothing to fix AFAICT, logcheck configuration doesn't need to be readable by non-root. Quite. Julien, I notice you added a moreinfo tag without asking a question of me. What info do you require of me? -- Antti-Juhani Kaijanaho, Jyväskylä, Finland http://antti-juhani.kaijanaho.fi/newblog/ http://www.flickr.com/photos/antti-juhani/ signature.asc Description: Digital signature
Bug#682232: mysql-server-5.5: Fails to upgrade squeeze - wheezy, does not start
Package: mysql-server-5.5 Version: 5.5.24+dfsg-4 Severity: grave Justification: renders package unusable During an upgrade from squeeze to wheezy, I got this: Setting up mysql-server-5.5 (5.5.24+dfsg-4) ... [ ok ] Stopping MySQL database server: mysqld. [FAIL] Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed! invoke-rc.d: initscript mysql, action start failed. dpkg: error processing mysql-server-5.5 (--configure): subprocess installed post-installation script returned error exit status 1 Indeed, starting manually fails as well: # /etc/init.d/mysql start [FAIL] Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed! # -- System Information: Debian Release: wheezy/sid APT prefers testing APT policy: (500, 'testing') Architecture: i386 (i686) Kernel: Linux 2.6.32.33-kvm-i386-2028-dirty (SMP w/1 CPU core) Locale: LANG=C.UTF-8, LC_CTYPE=C.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/bash Versions of packages mysql-server-5.5 depends on: ii adduser3.113+nmu3 ii debconf [debconf-2.0] 1.5.44 ii initscripts2.88dsf-22.1 ii libc6 2.13-33 ii libdbi-perl1.622-1 ii libgcc11:4.7.1-2 ii libstdc++6 4.7.1-2 ii lsb-base 4.1+Debian7 ii mysql-client-5.5 5.5.24+dfsg-4 ii mysql-common 5.5.24+dfsg-4 ii mysql-server-core-5.5 5.5.24+dfsg-4 ii passwd 1:4.1.5.1-1 ii perl 5.14.2-12 ii psmisc 22.19-1 ii zlib1g 1:1.2.7.dfsg-13 Versions of packages mysql-server-5.5 recommends: ii bsd-mailx [mailx] 8.1.2-0.2006cvs-1 ii libhtml-template-perl 2.91-1 Versions of packages mysql-server-5.5 suggests: pn tinyca none -- Configuration Files: /etc/logcheck/ignore.d.paranoid/mysql-server-5_5 [Errno 13] Permission denied: u'/etc/logcheck/ignore.d.paranoid/mysql-server-5_5' /etc/logcheck/ignore.d.server/mysql-server-5_5 [Errno 13] Permission denied: u'/etc/logcheck/ignore.d.server/mysql-server-5_5' /etc/logcheck/ignore.d.workstation/mysql-server-5_5 [Errno 13] Permission denied: u'/etc/logcheck/ignore.d.workstation/mysql-server-5_5' -- debconf information: mysql-server/error_setting_password: mysql-server-5.5/postrm_remove_databases: false mysql-server-5.5/nis_warning: mysql-server-5.5/really_downgrade: false mysql-server-5.5/start_on_boot: true mysql-server/password_mismatch: mysql-server/no_upgrade_when_using_ndb: -- To UNSUBSCRIBE, email to debian-bugs-rc-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Bug#682232: [debian-mysql] Bug#682232: mysql-server-5.5: Fails to upgrade squeeze - wheezy, does not start
On Fri, Jul 20, 2012 at 4:03 PM, Antti-Juhani Kaijanaho a...@debian.org wrote: [FAIL] Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed! Indeed, starting manually fails as well: What do the logs (syslog etc) say? Olaf -- To UNSUBSCRIBE, email to debian-bugs-rc-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Bug#682232: mysql-server-5.5: Fails to upgrade squeeze - wheezy, does not start
Package: mysql-server-5.5 Followup-For: Bug #682232 What are the etc logs? Anyway, /var/log/mysql* logs do not contain anything relevant: $ LC_ALL=C ls -l /var/log/mysql* | grep 'Jul 20' -rw-r- 1 mysql adm0 Jul 20 17:05 /var/log/mysql.err -rw-r- 1 mysql adm0 Jul 20 17:05 /var/log/mysql.log -rw-r- 1 mysql adm 0 Jul 20 01:30 mysql.log $ Syslog output follows. Jul 20 17:24:24 flowerpot mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql Jul 20 17:24:24 flowerpot mysqld: 120720 17:24:24 [Note] Plugin 'FEDERATED' is disabled. Jul 20 17:24:24 flowerpot mysqld: 120720 17:24:24 InnoDB: The InnoDB memory heap is disabled Jul 20 17:24:24 flowerpot mysqld: 120720 17:24:24 InnoDB: Mutexes and rw_locks use GCC atomic builtins Jul 20 17:24:24 flowerpot mysqld: 120720 17:24:24 InnoDB: Compressed tables use zlib 1.2.7 Jul 20 17:24:24 flowerpot mysqld: 120720 17:24:24 InnoDB: Using Linux native AIO Jul 20 17:24:24 flowerpot mysqld: 120720 17:24:24 InnoDB: Initializing buffer pool, size = 128.0M Jul 20 17:24:24 flowerpot mysqld: 120720 17:24:24 InnoDB: Completed initialization of buffer pool Jul 20 17:24:24 flowerpot mysqld: 120720 17:24:24 InnoDB: highest supported file format is Barracuda. Jul 20 17:24:24 flowerpot mysqld: 120720 17:24:24 InnoDB: Error: trying to access tablespace 1 page no. 2, Jul 20 17:24:24 flowerpot mysqld: InnoDB: but the tablespace does not exist or is just being dropped. Jul 20 17:24:24 flowerpot mysqld: 120720 17:24:24 InnoDB: Error: trying to access tablespace 1 page no. 2, Jul 20 17:24:24 flowerpot mysqld: InnoDB: but the tablespace does not exist or is just being dropped. Jul 20 17:24:24 flowerpot mysqld: 120720 17:24:24 InnoDB: Error: trying to access tablespace 1 page no. 2, Jul 20 17:24:24 flowerpot mysqld: InnoDB: but the tablespace does not exist or is just being dropped. Jul 20 17:24:24 flowerpot mysqld: 120720 17:24:24 InnoDB: Error: trying to access tablespace 1 page no. 2, Jul 20 17:24:24 flowerpot mysqld: InnoDB: but the tablespace does not exist or is just being dropped. Jul 20 17:24:24 flowerpot mysqld: 120720 17:24:24 InnoDB: Error: trying to access tablespace 1 page no. 2, Jul 20 17:24:24 flowerpot mysqld: InnoDB: but the tablespace does not exist or is just being dropped. Jul 20 17:24:24 flowerpot mysqld: 120720 17:24:24 InnoDB: Error: trying to access tablespace 1 page no. 2, Jul 20 17:24:24 flowerpot mysqld: InnoDB: but the tablespace does not exist or is just being dropped. Jul 20 17:24:24 flowerpot mysqld: 120720 17:24:24 InnoDB: Error: trying to access tablespace 1 page no. 2, Jul 20 17:24:24 flowerpot mysqld: InnoDB: but the tablespace does not exist or is just being dropped. Jul 20 17:24:24 flowerpot mysqld: 120720 17:24:24 InnoDB: Error: trying to access tablespace 1 page no. 2, Jul 20 17:24:24 flowerpot mysqld: InnoDB: but the tablespace does not exist or is just being dropped. Jul 20 17:24:24 flowerpot mysqld: 120720 17:24:24 InnoDB: Error: trying to access tablespace 1 page no. 2, Jul 20 17:24:24 flowerpot mysqld: InnoDB: but the tablespace does not exist or is just being dropped. Jul 20 17:24:24 flowerpot mysqld: 120720 17:24:24 InnoDB: Error: trying to access tablespace 1 page no. 2, Jul 20 17:24:24 flowerpot mysqld: InnoDB: but the tablespace does not exist or is just being dropped. Jul 20 17:24:24 flowerpot mysqld: 120720 17:24:24 InnoDB: Error: trying to access tablespace 1 page no. 2, Jul 20 17:24:24 flowerpot mysqld: InnoDB: but the tablespace does not exist or is just being dropped. Jul 20 17:24:24 flowerpot mysqld: 120720 17:24:24 InnoDB: Error: trying to access tablespace 1 page no. 2, Jul 20 17:24:24 flowerpot mysqld: InnoDB: but the tablespace does not exist or is just being dropped. Jul 20 17:24:24 flowerpot mysqld: 120720 17:24:24 InnoDB: Error: trying to access tablespace 1 page no. 2, Jul 20 17:24:24 flowerpot mysqld: InnoDB: but the tablespace does not exist or is just being dropped. Jul 20 17:24:24 flowerpot mysqld: 120720 17:24:24 InnoDB: Error: trying to access tablespace 1 page no. 2, Jul 20 17:24:24 flowerpot mysqld: InnoDB: but the tablespace does not exist or is just being dropped. Jul 20 17:24:24 flowerpot mysqld: 120720 17:24:24 InnoDB: Error: trying to access tablespace 1 page no. 2, Jul 20 17:24:24 flowerpot mysqld: InnoDB: but the tablespace does not exist or is just being dropped. Jul 20 17:24:24 flowerpot mysqld: 120720 17:24:24 InnoDB: Error: trying to access tablespace 1 page no. 2, Jul 20 17:24:24 flowerpot mysqld: InnoDB: but the tablespace does not exist or is just being dropped. Jul 20 17:24:24 flowerpot mysqld: 120720 17:24:24 InnoDB: Error: trying to access tablespace 1 page no. 2, Jul 20 17:24:24 flowerpot mysqld: InnoDB: but the tablespace does not exist or is just being dropped. Jul 20 17:24:24 flowerpot mysqld: 120720 17:24:24 InnoDB: Error: trying to access tablespace 1 page no. 2, Jul 20 17:24:24 flowerpot mysqld:
Bug#682232: mysql-server-5.5: Fails to upgrade squeeze - wheezy, does not start
Package: mysql-server-5.5 Version: 5.5.24+dfsg-4 Followup-For: Bug #682232 I worked around this by the following: First, started mysqld with innodb_force_recovery = 1. Then, verified that none of my tables actually used InnoDB by the following query: SELECT table_schema, table_name FROM INFORMATION_SCHEMA.TABLES WHERE engine = 'innodb'; Finally, after stopping mysqld again, I took a backup of /var/lib/mysql and then deleted the InnoDB files there. Afterwards, mysql started fine with innodb_force_recovery = 0 and appears now to be working correctly. -- System Information: Debian Release: wheezy/sid APT prefers testing APT policy: (500, 'testing') Architecture: i386 (i686) Kernel: Linux 2.6.32.33-kvm-i386-2028-dirty (SMP w/1 CPU core) Locale: LANG=C.UTF-8, LC_CTYPE=C.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/bash Versions of packages mysql-server-5.5 depends on: ii adduser3.113+nmu3 ii debconf [debconf-2.0] 1.5.44 ii initscripts2.88dsf-22.1 ii libc6 2.13-33 ii libdbi-perl1.622-1 ii libgcc11:4.7.1-2 ii libstdc++6 4.7.1-2 ii lsb-base 4.1+Debian7 ii mysql-client-5.5 5.5.24+dfsg-4 ii mysql-common 5.5.24+dfsg-4 ii mysql-server-core-5.5 5.5.24+dfsg-4 ii passwd 1:4.1.5.1-1 ii perl 5.14.2-12 ii psmisc 22.19-1 ii zlib1g 1:1.2.7.dfsg-13 Versions of packages mysql-server-5.5 recommends: ii bsd-mailx [mailx] 8.1.2-0.2006cvs-1 ii libhtml-template-perl 2.91-1 Versions of packages mysql-server-5.5 suggests: pn tinyca none -- Configuration Files: /etc/logcheck/ignore.d.paranoid/mysql-server-5_5 [Errno 13] Permission denied: u'/etc/logcheck/ignore.d.paranoid/mysql-server-5_5' /etc/logcheck/ignore.d.server/mysql-server-5_5 [Errno 13] Permission denied: u'/etc/logcheck/ignore.d.server/mysql-server-5_5' /etc/logcheck/ignore.d.workstation/mysql-server-5_5 [Errno 13] Permission denied: u'/etc/logcheck/ignore.d.workstation/mysql-server-5_5' -- debconf information: mysql-server/error_setting_password: mysql-server-5.5/postrm_remove_databases: false mysql-server-5.5/nis_warning: mysql-server-5.5/really_downgrade: false mysql-server-5.5/start_on_boot: true mysql-server/password_mismatch: mysql-server/no_upgrade_when_using_ndb: -- To UNSUBSCRIBE, email to debian-bugs-rc-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Bug#682232: [debian-mysql] Bug#682232: mysql-server-5.5: Fails to upgrade squeeze - wheezy, does not start
-- Configuration Files: /etc/logcheck/ignore.d.paranoid/mysql-server-5_5 [Errno 13] Permission denied: u'/etc/logcheck/ignore.d.paranoid/mysql-server-5_5' /etc/logcheck/ignore.d.server/mysql-server-5_5 [Errno 13] Permission denied: u'/etc/logcheck/ignore.d.server/mysql-server-5_5' /etc/logcheck/ignore.d.workstation/mysql-server-5_5 [Errno 13] Permission denied: u'/etc/logcheck/ignore.d.workstation/mysql-server-5_5' -- debconf information: mysql-server/error_setting_password: mysql-server-5.5/postrm_remove_databases: false mysql-server-5.5/nis_warning: mysql-server-5.5/really_downgrade: false mysql-server-5.5/start_on_boot: true mysql-server/password_mismatch: mysql-server/no_upgrade_when_using_ndb: Antti-Juhani, Have you tried fixing the permission errors? After that relevant sections from syslog please. -- To UNSUBSCRIBE, email to debian-bugs-rc-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Bug#682232: [debian-mysql] Bug#682232: mysql-server-5.5: Fails to upgrade squeeze - wheezy, does not start
On Fri, Jul 20, 2012 at 21:06:12 +0100, Nicholas Bamber wrote: -- Configuration Files: /etc/logcheck/ignore.d.paranoid/mysql-server-5_5 [Errno 13] Permission denied: u'/etc/logcheck/ignore.d.paranoid/mysql-server-5_5' /etc/logcheck/ignore.d.server/mysql-server-5_5 [Errno 13] Permission denied: u'/etc/logcheck/ignore.d.server/mysql-server-5_5' /etc/logcheck/ignore.d.workstation/mysql-server-5_5 [Errno 13] Permission denied: u'/etc/logcheck/ignore.d.workstation/mysql-server-5_5' [...] Antti-Juhani, Have you tried fixing the permission errors? There's nothing to fix AFAICT, logcheck configuration doesn't need to be readable by non-root. Cheers, Julien signature.asc Description: Digital signature