apt-get hangs when upgrading mysql-server-5.1

[exodar]

When I attempt to do the following:

sudo apt-get update
sudo apt-get upgrade

on my Ubuntu Server 10.04 installation, it hangs at the following line:

Preparing to replace mysql-server-5.1 5.1.41-3ubuntu12.1 (using .../mysql-server-5.1_5.1.41-3ubuntu12.3_i386.deb)

I cannot even CTRL-C out of it! I end up having to kill my session and log in from a different terminal and the upgrade process is still running. I have rebooted it several times and when I go back and try again it tells me:

E: dpkg was interrupted, you must manually run 'sudo --configure -a' to correct the problem.

Once I do that I am back at square one and it freezes up when I try to upgrade mysql.

Thanks...

[nebajoth]

Bump ^. This is happening to me as well. Did you find a fix?

[hymerman]

I'm getting the exact same thing. I've fiddled about all over the place but I can't get it to work. I've managed to uninstall it but on installing it it hangs in the same way.

It looks like it's hanging whilst waiting to start/stop the mysql service - "ps aux | grep mysql" always shows either "stop mysql" or "start mysql". Killing those processes makes the upgrade/installation continue with an error. Note that I can start/stop the services manually just fine.

[cyberedsun]

I am also facing this issue. I even tried to re-install the system and did the upgrade when the issue happened again.

Please help to give out solution.
Thanks.

[jaya28inside]

exactly!

I encounter the same
like u all experienced....

got stuck at this line...

Setting up mysql-client-core-5.1 (5.1.41-3ubuntu12.6) ...
Setting up mysql-client-5.1 (5.1.41-3ubuntu12.6) ...
Setting up mysql-server-core-5.1 (5.1.41-3ubuntu12.6) ...
Setting up mysql-server-5.1 (5.1.41-3ubuntu12.6) ...
Installing new version of config file /etc/init/mysql.conf ...

and until now... already 10 minutes passed
still stuck.
still hang over there.

I wonder, perhaps this is because the previous action I did
was... removing the mysql-server via this unhealthy way...

root# : apt-get remove mysql-server
... Later I choose Yes.

root# : apt-get remove mysql-client
... Later I choose Yes.

and Thus, it's done removed.
but still the trash is still everywhere...
rather than using

root# : apt-get remove --purge mysql-server

OMG.
then If I'm not mistaken,
without realizing my mistakes previously,
I continue to execute this command

root# : apt-get install mysql-server

which is yes,,, getting stuck until now. Any Idea?

[AnRkey]

I have the same issue, I will post the answer if I fix mine.

[gramoun_kal]

Same happened to me after my machine froze while mysql was installing. I finished the install after a hard-reset, but I hit the same issue.

I tried apt-get purge 'ing all the packages starting with 'mysql' and reinstalling afresh, no success. I tried renaming the /etc/init/mysql.conf, still no success.

The problem seemed to be that the root account was corrupter or something, but was not reset by a reinstall.

In the end, I found where mysql keeps its users (including "root"): In a bunch of files in /var/lib/mysql. I apt-get purge 'd all mysql packages, deleted this folder (but you might want to rename it instead, just in case it contained something you'd miss: sudo mv /var/lib/mysql /var/lib/mysql-backup

When I reinstalled mysql, it set me up a new fresh, pristine root account for mysql. Hurray.

[Rocketeer]

Any news on this? I had similar problems, but purging, removing and cleaning did not help. During reinstall I recieve now

Quote:
start: Job failed to start
invoke-rc.d: initscript mysql, action "start" failed.
Regards

[thale]

Fixed it.

I purged all of the mysql packages, cleaned the cached deb's, removed the mysql user, removed the /var/lib/mysql /etc/mysql /etc/init/mysql.conf /etc/init.d/mysql blah blah

everything. However, I missed the /var/run/mysql/mysql.sock AND there was a mysql zombie process that wouldn't respond to kill -9. I had to reboot the machine. After all that I was able to reinstall mysql.

[deepesh]

I faced the same problem. Stopping mysql server let the upgrade proceed.
$sudo service mysql stop