MySQL crashes after I run sudo apt-get upgrade
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
mysql-dfsg-5.1 (Ubuntu) |
New
|
Undecided
|
Unassigned |
Bug Description
Hi All,
I'm using a 64-bit version of Ubuntu 9.10 server on an Amazon EC2 instance. Since a couple weeks ago, "sudo apt-get upgrade" has failed because it can't upgrade MySQL successfully. When I run apt-get upgrade, the server downloads the latest MySQL files and stops the MySQL daemon in order to upgrade the server. But then it fails when trying to start MySQL.
When I investigated the cause of this error, I realized that the cause of the problem is that the "sudo apt-get upgrade" creates 2 binary log files which have the root:root account and group as the owner. These binary log files are in the directory /var/lib/mysql/ and have names like mysql-bin.000107. I'm not sure why "sudo apt-get upgrade" creates 2 files, but it always seems to create 2 files. When I change the owner of these binary log files to mysql:mysql, then MySQL successfully starts.
As a result of this bug, I haven't been able to successfully run sudo apt-get upgrade for a couple weeks. Any help or advice would be appreciated!
Here is info about my server.
Output from lsb_release -rd
Description: Ubuntu 9.10
Release: 9.10
Amazon EC2 AMI: I created my own AMI but built it on top of the official Canonical Ubuntu 64-bit 9.10 AMI in December, 2009.
Here is the output from when I run sudo apt-get upgrade:
Reading package lists... Done us.ec2. archive. ubuntu. com karmic-updates/main dpkg 1.15.4ubuntu2.1 [2,126kB] us.ec2. archive. ubuntu. com karmic-updates/main tzdata 2010e-0ubuntu0.9.10 [683kB] us.ec2. archive. ubuntu. com karmic-updates/main apache2 2.2.12-1ubuntu2.2 [1,426B] us.ec2. archive. ubuntu. com karmic-updates/main apache2-mpm-prefork 2.2.12-1ubuntu2.2 [2,376B] us.ec2. archive. ubuntu. com karmic-updates/main apache2.2-common 2.2.12-1ubuntu2.2 [285kB] us.ec2. archive. ubuntu. com karmic-updates/main apache2.2-bin 2.2.12-1ubuntu2.2 [1,309kB] us.ec2. archive. ubuntu. com karmic-updates/main apache2-utils 2.2.12-1ubuntu2.2 [155kB] us.ec2. archive. ubuntu. com karmic-updates/main dpkg-dev 1.15.4ubuntu2.1 [573kB] 1.15.4ubuntu2. 1_i386. deb) ...
Building dependency tree
Reading state information... Done
The following packages have been kept back:
bind9-host dnsutils libbind9-50 libdns50 libgssapi-krb5-2 libgssrpc4 libisc50 libisccc50 libisccfg50 libk5crypto3 libkadm5srv6 libkrb5-3 libkrb5-dev libkrb5support0 liblwres50 linux-ec2 linux-image-ec2 linux-image-virtual linux-virtual
The following packages will be upgraded:
apache2 apache2-mpm-prefork apache2-utils apache2.2-bin apache2.2-common dpkg dpkg-dev tzdata
8 upgraded, 0 newly installed, 0 to remove and 19 not upgraded.
2 not fully installed or removed.
Need to get 5,136kB of archives.
After this operation, 65.5kB disk space will be freed.
Get:1 http://
Get:2 http://
Get:3 http://
Get:4 http://
Get:5 http://
Get:6 http://
Get:7 http://
Get:8 http://
Fetched 5,136kB in 0s (16.4MB/s)
Preconfiguring packages ...
(Reading database ... 32789 files and directories currently installed.)
Preparing to replace dpkg 1.15.4ubuntu2 (using .../dpkg_
Unpacking replacement dpkg ...
Processing triggers for man-db ...
Setting up dpkg (1.15.4ubuntu2.1) ...
(Reading database ... 32789 files and directories currently installed.) 2010e-0ubuntu0. 9.10_all. deb) ... 0ubuntu0. 9.10) ...
Preparing to replace tzdata 2009u-0ubuntu0.9.10 (using .../tzdata_
Unpacking replacement tzdata ...
Setting up tzdata (2010e-
Current default time zone: 'America/New_York'
Local time is now: Fri Mar 12 12:57:25 EST 2010.
Universal Time is now: Fri Mar 12 17:57:25 UTC 2010.
Run 'dpkg-reconfigure tzdata' if you wish to change it.
(Reading database ... 32798 files and directories currently installed.) 2.2.12- 1ubuntu2. 2_all.deb) ... mpm-prefork_ 2.2.12- 1ubuntu2. 2_all.deb) ... 2-common_ 2.2.12- 1ubuntu2. 2_all.deb) ... 2-bin_2. 2.12-1ubuntu2. 2_i386. deb) ... utils_2. 2.12-1ubuntu2. 2_i386. deb) ...
Preparing to replace apache2 2.2.12-1ubuntu2.1 (using .../apache2_
Unpacking replacement apache2 ...
Preparing to replace apache2-mpm-prefork 2.2.12-1ubuntu2.1 (using .../apache2-
* Stopping web server htcacheclean
... waiting ...done.
Unpacking replacement apache2-mpm-prefork ...
Preparing to replace apache2.2-common 2.2.12-1ubuntu2.1 (using .../apache2.
Unpacking replacement apache2.2-common ...
Preparing to replace apache2.2-bin 2.2.12-1ubuntu2.1 (using .../apache2.
Unpacking replacement apache2.2-bin ...
Preparing to replace apache2-utils 2.2.12-1ubuntu2.1 (using .../apache2-
Unpacking replacement...