Public bug reported:
Problem started with failure to update my sites after my system hung and
forced hard shutdown. On rebooting, could not get the server to
connect neither could I stop it. I got Error #2002 unable to connect
with my phpMyAdmin. Then on the terminal, I could not connect to
** Attachment added: .etc.apparmor.d.usr.sbin.mysqld.txt
https://bugs.launchpad.net/bugs/617678/+attachment/1489145/+files/.etc.apparmor.d.usr.sbin.mysqld.txt
** Attachment added: AptOrdering.txt
https://bugs.launchpad.net/bugs/617678/+attachment/1489146/+files/AptOrdering.txt
**
This is the output of grep mysql /var/log/syslog:
usr/bin/mysql
Aug 15 19:28:10 ubuntu /etc/mysql/debian-start[32460]: Looking for 'mysqlcheck'
as: /usr/bin/mysqlcheck
Aug 15 19:28:10 ubuntu /etc/mysql/debian-start[32460]: This installation of
MySQL is already upgraded to 5.1.41, use --force if
Don't know if this would be of any help. I copied it from the error.log
-/var/log/mysql/error.log:
100815 19:28:45 InnoDB: Started; log sequence number 1 637983031
InnoDB: Starting in background the rollback of uncommitted transactions
InnoDB: Cleaning up trx with id 0 1738733
100815 19:28:45
The output of grep mysql /var/log/syslog after the error generated by
sudo mysql stop:
usr/bin/mysql
Aug 15 19:28:10 ubuntu /etc/mysql/debian-start[32460]: Looking for 'mysqlcheck'
as: /usr/bin/mysqlcheck
Aug 15 19:28:10 ubuntu /etc/mysql/debian-start[32460]: This installation of
MySQL is
Tried forcing InnoDB recovery by adding innodb_force_recovery = 4 to
my.cnf file under the section [mysqld] as suggested in
http://dev.mysql.com/doc/refman/5.1/en/forcing-recovery.html but it did
not help.
No change in the grep mysql /var/log/syslog output:
Aug 16 03:26:46 ubuntu
Thanks but the purging and installing the mysql-server-5.1 did not help.
My databases were not dropped. I tried dropping one of them after I
login to mysql, then the server was gone as the error recurred.
I would be glad to send my databases to you guys to help find the bug
and help others in
Please find below the transactions on my terminal with trying to purge
and reinstall the server. Hope it makes sense to someone:
kay...@ubuntu:~$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version:
Then two minutes later, without doing anything new:
kay...@ubuntu:~$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.41-3ubuntu12.6 (Ubuntu)
Type 'help;' or '\h' for help. Type '\c' to clear the current
Even sudo-apt-get remove mysql-server-5.1 did not work:
kay...@ubuntu:~$ sudo apt-get purge mysql-server-5.1
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following packages were automatically installed and are no longer required:
I could not backup the database with the instructions given.
Eventually on the advise of a friend I moved the database:
sudo mv /var/lib/mysql /var/lib/mysql.corrupted
after doing:
sudo apt-get purge mysql-server-5.1
then I was able to reinstall the server:
sudo apt-get install
11 matches
Mail list logo