Bug#682232: [debian-mysql] Bug#682232: mysql-server-5.5: Fails to upgrade squeeze - wheezy, does not start
Hi, have you configured --log-error within my.cnf? See [0] What does the error log says? This is most likely due to custom configuriation below /etc/mysql/conf.d/ [0] http://dev.mysql.com/doc/refman/5.5/en/error-log.html Cheers B -- To UNSUBSCRIBE, email to debian-bugs-dist-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
Excerpts from Gary Dale's message of 2013-07-06 21:39:32 -0700: Package: mysql-server-5.5 Version: 5.5.31+dfsg-0+wheezy1 Followup-For: Bug #682232 Dear Maintainer, *** Please consider answering these questions, where appropriate *** * What led up to the situation? upgrading a server from squeeze to wheezy * What exactly did you do (or not do) that was effective (or ineffective)? tried to install the package again, tried to configure it. * What was the outcome of this action? mysql still fails to state. I get this output: Setting up mysql-server-5.5 (5.5.31+dfsg-0+wheezy1) ... [ ok ] Stopping MySQL database server: mysqld. insserv: warning: script 'K01setwol.sh' missing LSB tags and overrides insserv: warning: script 'K01hylafax' missing LSB tags and overrides insserv: warning: script 'K01netatalk' missing LSB tags and overrides insserv: warning: script 'S22initrd-tools.sh' missing LSB tags and overrides insserv: warning: script 'xfree86-common' missing LSB tags and overrides insserv: warning: script 'modutils' missing LSB tags and overrides insserv: warning: script 'hylafax' missing LSB tags and overrides insserv: warning: script 'netatalk' missing LSB tags and overrides insserv: warning: script 'initrd-tools.sh' missing LSB tags and overrides insserv: warning: script 'setwol.sh' missing LSB tags and overrides [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 dpkg: dependency problems prevent configuration of mysql-server: mysql-server depends on mysql-server-5.5; however: Package mysql-server-5.5 is not configured yet. Hi Gary, sorry you're having problems. Can you look for anything relevant in /var/log/mysql* (Sorry to be so vague but the location has changed a few times). If you don't see anything there, try just running mysqld It should print out why it is unable to start. -- To UNSUBSCRIBE, email to debian-bugs-dist-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
Hi Sergio, thanks for taking the time to report a bug. Can you include your entire /etc/mysql/my.cnf And also a listing of your datadir (usually /var/lib/mysql). I think the answer, since you have no innodb tables, is to rm /var/lib/mysql/ib*. I have tested the squeeze - wheezy upgrade and it worked ok for me in the simple case of an empty database without any innodb tables, but perhaps your innodb tablespace was corrupted somehow. -- To UNSUBSCRIBE, email to debian-bugs-dist-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
Clint: /etc/mysql/my.cnf Attached. A listing of my datadir is below. And yes the answer was to rm /var/lib/mysql/ib* After do that I can run mysqld normally with innodb_force_recovery = 0 Thanks for your help and work. Regards. Sergio Vernis Debian:/var/lib/mysql# ls -la total 20612 drwx-- 11 mysql mysql 4096 mar 19 18:42 . drwxr-xr-x 103 root root 4096 mar 12 18:59 .. drwx-- 2 mysql mysql 4096 nov 13 2008 books drwx-- 2 mysql mysql 4096 feb 16 2012 cumples -rw-r--r-- 1 mysql mysql0 dic 16 2005 debian-4.1.flag -rw-r--r-- 1 mysql mysql0 ene 18 2011 debian-5.0.flag -rw-r--r-- 1 mysql mysql0 dic 5 20:32 debian-5.1.flag -rw-r--r-- 1 mysql mysql0 mar 12 19:01 debian-5.5.flag drwx-- 2 mysql mysql 4096 nov 13 2008 farma -rw-rw 1 mysql mysql25088 abr 11 2005 ib_arch_log_00 -rw-rw 1 mysql mysql 10485760 mar 18 19:21 ibdata1 -rw-rw 1 mysql mysql 5242880 mar 19 18:42 ib_logfile0 -rw-rw 1 mysql mysql 5242880 abr 11 2005 ib_logfile1 drwx-- 2 mysql mysql 4096 feb 3 2009 mantis -rw-r--r-- 1 mysql mysql 48 nov 4 2004 my.cnf drwx-- 2 mysql mysql 4096 mar 13 19:25 mysql -rw--- 1 mysql mysql6 mar 13 19:25 mysql_upgrade_info -rw--- 1 mysql mysql4 jul 5 2006 mysql_upgrade.info drwx-- 2 mysql mysql12288 abr 18 2012 mythconverg drwx-- 2 mysql mysql 4096 mar 13 19:25 performance_schema drwxr-xr-x 2 mysql mysql 4096 oct 30 2008 test drwx-- 2 mysql mysql 4096 nov 21 2008 todo En Tue, 19 Mar 2013 09:39:28 -0700 Clint Byrum cl...@ubuntu.com escribió: Hi Sergio, thanks for taking the time to report a bug. Can you include your entire /etc/mysql/my.cnf And also a listing of your datadir (usually /var/lib/mysql). I think the answer, since you have no innodb tables, is to rm /var/lib/mysql/ib*. I have tested the squeeze - wheezy upgrade and it worked ok for me in the simple case of an empty database without any innodb tables, but perhaps your innodb tablespace was corrupted somehow. -- Yo uso software libre - I use freedom-based software -- Linux user since 973047600 my.cnf Description: Binary data
Bug#682232: [debian-mysql] Bug#682232: mysql-server-5.5: Fails to upgrade squeeze - wheezy, does not start
Hi - On Fri, Jul 20, 2012 at 4:03 PM, Antti-Juhani Kaijanaho a...@debian.org wrote: 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! # This also appears to affect a fresh install of mysql-server-5.5, too, with an empty /var/lib/mysql directory. - Mark -- Mark Kamichoff p...@prolixium.com http://www.prolixium.com/ -- To UNSUBSCRIBE, email to debian-bugs-dist-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 Sat, Jul 21, 2012 at 00:22:13 +0300, Antti-Juhani Kaijanaho wrote: Julien, I notice you added a moreinfo tag without asking a question of me. What info do you require of me? That was probably before I saw your syslog, since for some reason you replied out of thread. Cheers, Julien signature.asc Description: Digital signature
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-dist-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: [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-dist-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-dist-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