Ubuntu
mysql-dfsg-5.0 package

Upgrading mysql-server from 4.1 to 5.0 is broken

Bug #78317 reported by EndelWar
2
Affects Status Importance Assigned to Milestone
mysql-dfsg-5.0 (Ubuntu)
Invalid
Undecided
Unassigned

Bug Description

Binary package hint: mysql-server-5.0

I'm using ubuntu feisty, and did a dist-upgrade that included mysql-server that was upgraded from 4.1.x to 5.0.30.
After starting mysql gives this error:
root@prometheus:/var/lib/mysql/mysql# mysqld
070107 16:42:43 InnoDB: Started; log sequence number 0 3958625
070107 16:42:43 [Note] Recovering after a crash using /var/log/mysql/mysql-bin
070107 16:42:43 [Note] Starting crash recovery...
070107 16:42:43 [Note] Crash recovery finished.
070107 16:42:43 [ERROR] Fatal error: Can't open and lock privilege tables: Incorrect file format 'user'

Revision history for this message
Mathias Gug (mathiaz) wrote :

Thanks taking the time to report this bug and helping to make Ubuntu better.

From which version are you trying to upgrade from ?

Changed in mysql-dfsg-5.0:
status: New → Incomplete
Revision history for this message
EndelWar (endelwar) wrote :

It was the edgy version: 4.1.15, if I remember correctly

Revision history for this message
Mathias Gug (mathiaz) wrote :

Can you post the content of mysql configuration file (/etc/mysql/my.cnf) ?

Did you make any change to the file during the upgrade (like merge the maintainer version of the file) ?

Revision history for this message
EndelWar (endelwar) wrote :

I'm attaching two my.conf files:
my.cnf is the actual mysql configuration
my.cnf.dpkg-old is the old one

ls -la /etc/mysql/my.*
-rw-r--r-- 1 root root 3636 2007-03-23 16:09 /etc/mysql/my.cnf
-rw-r--r-- 1 root root 3996 2006-12-04 13:18 /etc/mysql/my.cnf.dpkg-old

Revision history for this message
Launchpad Janitor (janitor) wrote :

[Expired for mysql-dfsg-5.0 (Ubuntu) because there has been no activity for 60 days.]

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.