[debian-mysql] Bug#682232: Bug#682232: mysql-server-5.5: Fails to upgrade squeeze -> wheezy, does not start

[Sergio Vernis]

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 mysql        0 dic 16  2005 debian-4.1.flag
-rw-r--r--   1 mysql mysql        0 ene 18  2011 debian-5.0.flag
-rw-r--r--   1 mysql mysql        0 dic  5 20:32 debian-5.1.flag
-rw-r--r--   1 mysql mysql        0 mar 12 19:01 debian-5.5.flag
drwx------   2 mysql mysql     4096 nov 13  2008 farma
-rw-rw----   1 mysql mysql    25088 abr 11  2005 ib_arch_log_0000000000
-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 mysql        6 mar 13 19:25 mysql_upgrade_info
-rw-------   1 mysql mysql        4 jul  5  2006 mysql_upgrade.info
drwx------   2 mysql mysql    12288 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 <clint at 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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: my.cnf
Type: application/octet-stream
Size: 3533 bytes
Desc: not available
URL: <http://lists.alioth.debian.org/pipermail/pkg-mysql-maint/attachments/20130319/0f4cbfd0/attachment.obj>