[Bug 522185] Re: package mysql-server-5.1 5.1.37-1ubuntu5 failed to install/upgrade: subprocess new pre-removal script returned error exit status 1
@David Park: you're having a different bug as the package upgrade is able to stop mysql but not restart it. Please open a new bug. -- package mysql-server failed to install/upgrade: subprocess new pre-removal script returned error exit status 1 https://bugs.launchpad.net/bugs/522185 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 522185] Re: package mysql-server-5.1 5.1.37-1ubuntu5 failed to install/upgrade: subprocess new pre-removal script returned error exit status 1
The issue is related to: * Stopping MySQL database server mysqld ...fail! Could you paste the output of running the mysqld init script stop action with debugging set to yes? (Edit /etc/init.d/mysql to add 'set -x' at the beginning of the file and then run sudo /etc/init.d/mysql stop). ** Summary changed: - package mysql-server-5.1 5.1.37-1ubuntu5 failed to install/upgrade: subprocess new pre-removal script returned error exit status 1 + package mysql-server failed to install/upgrade: subprocess new pre-removal script returned error exit status 1 ** Changed in: mysql-dfsg-5.1 (Ubuntu) Status: Confirmed = Incomplete -- package mysql-server failed to install/upgrade: subprocess new pre-removal script returned error exit status 1 https://bugs.launchpad.net/bugs/522185 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 522185] Re: package mysql-server-5.1 5.1.37-1ubuntu5 failed to install/upgrade: subprocess new pre-removal script returned error exit status 1
Nicolas Connault's simple-o-fied version of David's instructions. Highly recommended! Tried everything else! STOPS the APT error because it allows APT to upgrade the package AND ENABLES MySQL = restarts MySQL after this!!! NICE! -- package mysql-server-5.1 5.1.37-1ubuntu5 failed to install/upgrade: subprocess new pre-removal script returned error exit status 1 https://bugs.launchpad.net/bugs/522185 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 522185] Re: package mysql-server-5.1 5.1.37-1ubuntu5 failed to install/upgrade: subprocess new pre-removal script returned error exit status 1
I'm writing to add some more details re: this bug. I encountered the same problem and figured out what the apt-get upgrade command did that made the mysql upgrade fail. 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. CancelOk Here's the output from the apt-get upgrade command: Reading package lists... Done 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://us.ec2.archive.ubuntu.com karmic-updates/main dpkg 1.15.4ubuntu2.1 [2,126kB] Get:2 http://us.ec2.archive.ubuntu.com karmic-updates/main tzdata 2010e-0ubuntu0.9.10 [683kB] Get:3 http://us.ec2.archive.ubuntu.com karmic-updates/main apache2 2.2.12-1ubuntu2.2 [1,426B] Get:4 http://us.ec2.archive.ubuntu.com karmic-updates/main apache2-mpm-prefork 2.2.12-1ubuntu2.2 [2,376B] Get:5 http://us.ec2.archive.ubuntu.com karmic-updates/main apache2.2-common 2.2.12-1ubuntu2.2 [285kB] Get:6 http://us.ec2.archive.ubuntu.com karmic-updates/main apache2.2-bin 2.2.12-1ubuntu2.2 [1,309kB] Get:7 http://us.ec2.archive.ubuntu.com karmic-updates/main apache2-utils 2.2.12-1ubuntu2.2 [155kB] Get:8 http://us.ec2.archive.ubuntu.com karmic-updates/main dpkg-dev 1.15.4ubuntu2.1 [573kB] 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_1.15.4ubuntu2.1_i386.deb) ... Unpacking replacement dpkg ... Processing triggers for man-db ... Setting up dpkg (1.15.4ubuntu2.1) ... (Reading database ... 32789 files and directories currently installed.) Preparing to replace tzdata 2009u-0ubuntu0.9.10 (using .../tzdata_2010e-0ubuntu0.9.10_all.deb) ... Unpacking replacement tzdata ... Setting up tzdata (2010e-0ubuntu0.9.10) ... 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.) Preparing to replace apache2 2.2.12-1ubuntu2.1 (using .../apache2_2.2.12-1ubuntu2.2_all.deb) ... Unpacking replacement apache2 ... Preparing to replace apache2-mpm-prefork 2.2.12-1ubuntu2.1 (using .../apache2-mpm-prefork_2.2.12-1ubuntu2.2_all.deb) ... * Stopping web server htcacheclean ... waiting ...done. Unpacking replacement apache2-mpm-prefork ... Preparing to replace apache2.2-common 2.2.12-1ubuntu2.1 (using .../apache2.2-common_2.2.12-1ubuntu2.2_all.deb) ... Unpacking replacement apache2.2-common ... Preparing to replace apache2.2-bin 2.2.12-1ubuntu2.1 (using .../apache2.2-bin_2.2.12-1ubuntu2.2_i386.deb) ... Unpacking replacement apache2.2-bin ... Preparing to replace apache2-utils 2.2.12-1ubuntu2.1 (using .../apache2-utils_2.2.12-1ubuntu2.2_i386.deb) ... Unpacking replacement apache2-utils ... Preparing to replace dpkg-dev 1.15.4ubuntu2 (using .../dpkg-dev_1.15.4ubuntu2.1_all.deb) ... Unpacking replacement dpkg-dev ... Processing triggers for ufw ... Processing triggers for man-db ... Setting up mysql-server-5.1 (5.1.37-1ubuntu5.1) ... * Stopping MySQL database server mysqld ...done. * Starting MySQL database server mysqld ...fail! invoke-rc.d: initscript
[Bug 522185] Re: package mysql-server-5.1 5.1.37-1ubuntu5 failed to install/upgrade: subprocess new pre-removal script returned error exit status 1
I don't know if I had the same bug as the message I had when I updated was that dpkg couldn't stop mysql. I tried sudo /etc/init.d/mysql stop but it failed. Then I did sudo killall mysqld which worked, I re-launched sudo /etc/init.d/mysql stop : it worked. Then apt-get upgrade did his work fine… Mysql seems to work fine now. -- package mysql-server-5.1 5.1.37-1ubuntu5 failed to install/upgrade: subprocess new pre-removal script returned error exit status 1 https://bugs.launchpad.net/bugs/522185 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 522185] Re: package mysql-server-5.1 5.1.37-1ubuntu5 failed to install/upgrade: subprocess new pre-removal script returned error exit status 1
I used the instructions that Sinquin David posted, and that seemed to work. There were a few files in the /var/lib/mysql that were not owned by mysql - after doing the process, all the files were mysql mysql for owner and group. The file I was concerned with was the debian-5.1.flag file. Is it possible the MySQL deamon did not have access to the flag file, and this was causing the problem? I could not get MySQL to stop, so the update never got very far. After the hard shutdown, clean shutdown, then update, everything seems fine. MySQL now starts and stops normally as well. -- package mysql-server-5.1 5.1.37-1ubuntu5 failed to install/upgrade: subprocess new pre-removal script returned error exit status 1 https://bugs.launchpad.net/bugs/522185 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 522185] Re: package mysql-server-5.1 5.1.37-1ubuntu5 failed to install/upgrade: subprocess new pre-removal script returned error exit status 1
I can confirm that David's solution works. sudo killall mysqld sudo /etc/init.d/mysql stop apt-get upgrade -- package mysql-server-5.1 5.1.37-1ubuntu5 failed to install/upgrade: subprocess new pre-removal script returned error exit status 1 https://bugs.launchpad.net/bugs/522185 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 522185] Re: package mysql-server-5.1 5.1.37-1ubuntu5 failed to install/upgrade: subprocess new pre-removal script returned error exit status 1
I think that the bug that I reported may be different from the one that has been reported here. I tried David's solution. And it didn't work on my server. Server stopped MySQL successfully. But it didn't start MySQL for the same reasons that I outlined in my bug report above. -- package mysql-server-5.1 5.1.37-1ubuntu5 failed to install/upgrade: subprocess new pre-removal script returned error exit status 1 https://bugs.launchpad.net/bugs/522185 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 522185] Re: package mysql-server-5.1 5.1.37-1ubuntu5 failed to install/upgrade: subprocess new pre-removal script returned error exit status 1
** Changed in: mysql-dfsg-5.1 (Ubuntu) Importance: Undecided = Medium ** Changed in: mysql-dfsg-5.1 (Ubuntu) Status: New = Confirmed -- package mysql-server-5.1 5.1.37-1ubuntu5 failed to install/upgrade: subprocess new pre-removal script returned error exit status 1 https://bugs.launchpad.net/bugs/522185 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
