Ubuntu 11.10 -> 12.04 upgrade wipes all mysql databases and user info

Bug #990593 reported by Warren
18
This bug affects 3 people
Affects Status Importance Assigned to Milestone
mysql-5.5 (Ubuntu)
Confirmed
Undecided
Unassigned
ubiquity (Ubuntu)
Confirmed
High
Unassigned

Bug Description

Package: mysql-server (and possibly other mysql-related packages)

Upgraded by using 12.04 LiveCD, 64-bit version. On completion of apparently successful upgrade, all user mysql databases are GONE from /var/lib/mysql/. All user account information seems to be gone, according to Workbench. Unable to log into PHPMyAdmin by any means. It looks like the upgrade completly deletes all previous mysql data and does a fresh install.

This is some seriously unfriendly behavior that, if not just a fluke, warrants immediate attention.

ProblemType: Bug
DistroRelease: Ubuntu 12.04
Package: mysql-server 5.5.22-0ubuntu1
ProcVersionSignature: Ubuntu 3.2.0-24.37-generic 3.2.14
Uname: Linux 3.2.0-24-generic x86_64
NonfreeKernelModules: wl
ApportVersion: 2.0.1-0ubuntu7
Architecture: amd64
Date: Sat Apr 28 08:45:10 2012
InstallationMedia: Ubuntu 12.04 LTS "Precise Pangolin" - Release amd64 (20120425)
Logs.var.log.daemon.log:

Logs.var.log.kern.log:
 Apr 27 16:25:49 warren-laptop2 kernel: [ 21.905012] type=1400 audit(1335569149.398:19): apparmor="STATUS" operation="profile_load" name="/usr/sbin/mysqld" pid=957 comm="apparmor_parser"
 Apr 27 16:25:49 warren-laptop2 kernel: [ 21.962907] type=1400 audit(1335569149.454:20): apparmor="STATUS" operation="profile_load" name="/usr/sbin/mysqld-akonadi" pid=958 comm="apparmor_parser"
 Apr 27 22:11:29 warren-laptop2 kernel: [ 8.041361] type=1400 audit(1335589889.165:11): apparmor="STATUS" operation="profile_load" name="/usr/sbin/mysqld" pid=914 comm="apparmor_parser"
 Apr 28 07:15:50 warren-laptop2 kernel: [ 2060.905423] type=1400 audit(1335622550.652:28): apparmor="STATUS" operation="profile_replace" name="/usr/sbin/mysqld" pid=6353 comm="apparmor_parser"
 Apr 28 08:30:10 warren-laptop2 kernel: [ 6514.017884] type=1400 audit(1335627010.736:30): apparmor="STATUS" operation="profile_replace" name="/usr/sbin/mysqld" pid=11966 comm="apparmor_parser"
MySQLConf.etc.mysql.conf.d.mysqld.safe.syslog.cnf:
 [mysqld_safe]
 syslog
MySQLVarLibDirListing: False
PackageArchitecture: all
ProcEnviron:
 TERM=xterm
 PATH=(custom, user)
 LANG=en_US.UTF-8
 SHELL=/bin/bash
SourcePackage: mysql-5.5
UpgradeStatus: No upgrade log present (probably fresh install)

Revision history for this message
Warren (wseverin) wrote :
Revision history for this message
MarcRandolph (mrand) wrote :

I believe this has been confirmed by another user, and by a third in a VM. Not sure if this is ubiquity or mysql.

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

Status changed to 'Confirmed' because the bug affects multiple users.

Changed in mysql-5.5 (Ubuntu):
status: New → Confirmed
Changed in ubiquity (Ubuntu):
status: New → Confirmed
Revision history for this message
Pål Orby (orby) wrote :

This prevents me from updating from 11.10 to 12.04.

Yes, I know I can do a dump of my databases and import it later, but this bug is quite scary...

Revision history for this message
David Morris (dave-greenacre) wrote :

I raised bug #1008531 which is potentially the same thing.

mysql-server was uninstalled although the data all remained

Revision history for this message
Brian Murray (brian-murray) wrote :

This is actually the same root issue as bug 992241 were /var/lib/mysql/ is wiped out.

Changed in ubiquity (Ubuntu):
importance: Undecided → High
assignee: nobody → Canonical Foundations Team (canonical-foundations)
assignee: Canonical Foundations Team (canonical-foundations) → nobody
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

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