[debian-mysql] Bug#575213: done a painful purge

Fri Jul 22 23:48:00 UTC 2011

Following steps fixed the issue on my squeeze! In my case the error was
produced by older packages. Best you can do, if old mysql-server was
present or any other mysql related package:

$ dpkg -l | grep mysql

Painfully remove all mysql related stuff:

$ apt-get purge libapache2-mod-auth-mysql libcrypt-mysql-perl
libdbd-mysql-perl libmysqlclient-dev libmysqlclient16 libqt4-sql-mysql
mysql-client mysql-client-5.1 mysql-common  mysql-server
mysql-server-5.1 mysql-server-core-5.1 php5-mysql

Remove old /var/lib/mysql dir, best is to do a backup! (if present!).

Then install mysql-server again with for instance:

apt-get install mysql-server

Iam absolutly unsure if this may work in your issue cases?! 

Also i want to provide the daemon.log, that ive forgot to post before.
In the log you may see a non squeeze version installed, but believe me
its technical identical with squeeze.

so far
Markus
-------------- next part --------------
Jul 23 01:17:07 gamerzzone mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
Jul 23 01:17:07 gamerzzone mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
Jul 23 01:17:07 gamerzzone mysqld: 110723  1:17:07 [Note] Plugin 'FEDERATED' is disabled.
Jul 23 01:17:07 gamerzzone mysqld: 110723  1:17:07 [Note] Plugin 'FEDERATED' is disabled.
Jul 23 01:17:07 gamerzzone mysqld: /usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
Jul 23 01:17:07 gamerzzone mysqld: /usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
Jul 23 01:17:07 gamerzzone mysqld: 110723  1:17:07 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
Jul 23 01:17:07 gamerzzone mysqld: 110723  1:17:07 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
Jul 23 01:17:07 gamerzzone mysqld: 110723  1:17:07  InnoDB: Started; log sequence number 0 44233
Jul 23 01:17:07 gamerzzone mysqld: 110723  1:17:07  InnoDB: Started; log sequence number 0 44233
Jul 23 01:17:07 gamerzzone mysqld: 110723  1:17:07 [ERROR] /usr/sbin/mysqld: unknown option '--skip-bdb'
Jul 23 01:17:07 gamerzzone mysqld: 110723  1:17:07 [ERROR] /usr/sbin/mysqld: unknown option '--skip-bdb'
Jul 23 01:17:07 gamerzzone mysqld: 110723  1:17:07 [ERROR] Aborting
Jul 23 01:17:07 gamerzzone mysqld: 110723  1:17:07 [ERROR] Aborting
Jul 23 01:17:07 gamerzzone mysqld: 
Jul 23 01:17:07 gamerzzone mysqld: 
Jul 23 01:17:07 gamerzzone mysqld: 110723  1:17:07  InnoDB: Starting shutdown...
Jul 23 01:17:07 gamerzzone mysqld: 110723  1:17:07  InnoDB: Starting shutdown...
Jul 23 01:17:12 gamerzzone mysqld: 110723  1:17:12  InnoDB: Shutdown completed; log sequence number 0 44233
Jul 23 01:17:12 gamerzzone mysqld: 110723  1:17:12  InnoDB: Shutdown completed; log sequence number 0 44233
Jul 23 01:17:12 gamerzzone mysqld: 110723  1:17:12 [Note] /usr/sbin/mysqld: Shutdown complete
Jul 23 01:17:12 gamerzzone mysqld: 110723  1:17:12 [Note] /usr/sbin/mysqld: Shutdown complete
Jul 23 01:17:12 gamerzzone mysqld: 
Jul 23 01:17:12 gamerzzone mysqld: 
Jul 23 01:17:12 gamerzzone mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
Jul 23 01:17:12 gamerzzone mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
Jul 23 01:17:21 gamerzzone /etc/init.d/mysql[19623]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Jul 23 01:17:21 gamerzzone /etc/init.d/mysql[19623]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Jul 23 01:17:21 gamerzzone /etc/init.d/mysql[19623]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
Jul 23 01:17:21 gamerzzone /etc/init.d/mysql[19623]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
Jul 23 01:17:21 gamerzzone /etc/init.d/mysql[19623]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Jul 23 01:17:21 gamerzzone /etc/init.d/mysql[19623]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Jul 23 01:17:21 gamerzzone /etc/init.d/mysql[19623]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Jul 23 01:17:21 gamerzzone /etc/init.d/mysql[19623]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Jul 23 01:17:21 gamerzzone /etc/init.d/mysql[19623]: 
Jul 23 01:17:21 gamerzzone /etc/init.d/mysql[19623]: 
Jul 23 01:31:52 gamerzzone mysqld_safe[20785]: 
Jul 23 01:31:52 gamerzzone mysqld_safe[20785]: 
Jul 23 01:31:52 gamerzzone mysqld_safe[20785]: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
Jul 23 01:31:52 gamerzzone mysqld_safe[20785]: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
Jul 23 01:31:52 gamerzzone mysqld_safe[20785]: To do so, start the server, then issue the following commands:
Jul 23 01:31:52 gamerzzone mysqld_safe[20785]: To do so, start the server, then issue the following commands:
Jul 23 01:31:52 gamerzzone mysqld_safe[20785]: 
Jul 23 01:31:52 gamerzzone mysqld_safe[20785]: 
Jul 23 01:31:52 gamerzzone mysqld_safe[20785]: /usr/bin/mysqladmin -u root password 'new-password'
Jul 23 01:31:52 gamerzzone mysqld_safe[20785]: /usr/bin/mysqladmin -u root password 'new-password'
Jul 23 01:31:52 gamerzzone mysqld_safe[20785]: /usr/bin/mysqladmin -u root -h gamerzzone password 'new-password'
Jul 23 01:31:52 gamerzzone mysqld_safe[20785]: /usr/bin/mysqladmin -u root -h gamerzzone password 'new-password'
Jul 23 01:31:52 gamerzzone mysqld_safe[20785]: 
Jul 23 01:31:52 gamerzzone mysqld_safe[20785]: 
Jul 23 01:31:52 gamerzzone mysqld_safe[20785]: Alternatively you can run:
Jul 23 01:31:52 gamerzzone mysqld_safe[20785]: Alternatively you can run:
Jul 23 01:31:52 gamerzzone mysqld_safe[20785]: /usr/bin/mysql_secure_installation
Jul 23 01:31:52 gamerzzone mysqld_safe[20785]: /usr/bin/mysql_secure_installation
Jul 23 01:31:52 gamerzzone mysqld_safe[20785]: 
Jul 23 01:31:52 gamerzzone mysqld_safe[20785]: 
Jul 23 01:31:52 gamerzzone mysqld_safe[20785]: which will also give you the option of removing the test
Jul 23 01:31:52 gamerzzone mysqld_safe[20785]: which will also give you the option of removing the test
Jul 23 01:31:52 gamerzzone mysqld_safe[20785]: databases and anonymous user created by default.  This is
Jul 23 01:31:52 gamerzzone mysqld_safe[20785]: databases and anonymous user created by default.  This is
Jul 23 01:31:52 gamerzzone mysqld_safe[20785]: strongly recommended for production servers.
Jul 23 01:31:52 gamerzzone mysqld_safe[20785]: strongly recommended for production servers.
Jul 23 01:31:52 gamerzzone mysqld_safe[20785]: 
Jul 23 01:31:52 gamerzzone mysqld_safe[20785]: 
Jul 23 01:31:52 gamerzzone mysqld_safe[20785]: See the manual for more instructions.
Jul 23 01:31:52 gamerzzone mysqld_safe[20785]: See the manual for more instructions.
Jul 23 01:31:52 gamerzzone mysqld_safe[20785]: 
Jul 23 01:31:52 gamerzzone mysqld_safe[20785]: 
Jul 23 01:31:52 gamerzzone mysqld_safe[20785]: Please report any problems with the /usr/scripts/mysqlbug script!
Jul 23 01:31:52 gamerzzone mysqld_safe[20785]: Please report any problems with the /usr/scripts/mysqlbug script!
Jul 23 01:31:52 gamerzzone mysqld_safe[20785]: 
Jul 23 01:31:52 gamerzzone mysqld_safe[20785]: 
Jul 23 01:31:52 gamerzzone mysqld_safe[20830]: 110723  1:31:52 [Note] Plugin 'FEDERATED' is disabled.
Jul 23 01:31:52 gamerzzone mysqld_safe[20830]: 110723  1:31:52 [Note] Plugin 'FEDERATED' is disabled.
Jul 23 01:31:52 gamerzzone mysqld_safe[20830]: InnoDB: The first specified data file ./ibdata1 did not exist:
Jul 23 01:31:52 gamerzzone mysqld_safe[20830]: InnoDB: The first specified data file ./ibdata1 did not exist:
Jul 23 01:31:52 gamerzzone mysqld_safe[20830]: InnoDB: a new database to be created!
Jul 23 01:31:52 gamerzzone mysqld_safe[20830]: InnoDB: a new database to be created!
Jul 23 01:31:52 gamerzzone mysqld_safe[20830]: 110723  1:31:52  InnoDB: Setting file ./ibdata1 size to 10 MB
Jul 23 01:31:52 gamerzzone mysqld_safe[20830]: 110723  1:31:52  InnoDB: Setting file ./ibdata1 size to 10 MB
Jul 23 01:31:52 gamerzzone mysqld_safe[20830]: InnoDB: Database physically writes the file full: wait...
Jul 23 01:31:52 gamerzzone mysqld_safe[20830]: InnoDB: Database physically writes the file full: wait...
Jul 23 01:31:53 gamerzzone mysqld_safe[20830]: 110723  1:31:53  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
Jul 23 01:31:53 gamerzzone mysqld_safe[20830]: 110723  1:31:53  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
Jul 23 01:31:53 gamerzzone mysqld_safe[20830]: InnoDB: Setting log file ./ib_logfile0 size to 5 MB
Jul 23 01:31:53 gamerzzone mysqld_safe[20830]: InnoDB: Setting log file ./ib_logfile0 size to 5 MB
Jul 23 01:31:53 gamerzzone mysqld_safe[20830]: InnoDB: Database physically writes the file full: wait...
Jul 23 01:31:53 gamerzzone mysqld_safe[20830]: InnoDB: Database physically writes the file full: wait...
Jul 23 01:31:53 gamerzzone mysqld_safe[20830]: 110723  1:31:53  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
Jul 23 01:31:53 gamerzzone mysqld_safe[20830]: 110723  1:31:53  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
Jul 23 01:31:53 gamerzzone mysqld_safe[20830]: InnoDB: Setting log file ./ib_logfile1 size to 5 MB
Jul 23 01:31:53 gamerzzone mysqld_safe[20830]: InnoDB: Setting log file ./ib_logfile1 size to 5 MB
Jul 23 01:31:53 gamerzzone mysqld_safe[20830]: InnoDB: Database physically writes the file full: wait...
Jul 23 01:31:53 gamerzzone mysqld_safe[20830]: InnoDB: Database physically writes the file full: wait...
Jul 23 01:31:53 gamerzzone mysqld_safe[20830]: InnoDB: Doublewrite buffer not found: creating new
Jul 23 01:31:53 gamerzzone mysqld_safe[20830]: InnoDB: Doublewrite buffer not found: creating new
Jul 23 01:31:53 gamerzzone mysqld_safe[20830]: InnoDB: Doublewrite buffer created
Jul 23 01:31:53 gamerzzone mysqld_safe[20830]: InnoDB: Doublewrite buffer created
Jul 23 01:31:53 gamerzzone mysqld_safe[20830]: InnoDB: Creating foreign key constraint system tables
Jul 23 01:31:53 gamerzzone mysqld_safe[20830]: InnoDB: Creating foreign key constraint system tables
Jul 23 01:31:53 gamerzzone mysqld_safe[20830]: InnoDB: Foreign key constraint system tables created
Jul 23 01:31:53 gamerzzone mysqld_safe[20830]: InnoDB: Foreign key constraint system tables created
Jul 23 01:31:53 gamerzzone mysqld_safe[20830]: 110723  1:31:53  InnoDB: Started; log sequence number 0 0
Jul 23 01:31:53 gamerzzone mysqld_safe[20830]: 110723  1:31:53  InnoDB: Started; log sequence number 0 0
Jul 23 01:31:53 gamerzzone mysqld_safe[20830]: 110723  1:31:53  InnoDB: Starting shutdown...
Jul 23 01:31:53 gamerzzone mysqld_safe[20830]: 110723  1:31:53  InnoDB: Starting shutdown...
Jul 23 01:31:58 gamerzzone mysqld_safe[20830]: 110723  1:31:58  InnoDB: Shutdown completed; log sequence number 0 44233
Jul 23 01:31:58 gamerzzone mysqld_safe[20830]: 110723  1:31:58  InnoDB: Shutdown completed; log sequence number 0 44233
Jul 23 01:32:03 gamerzzone mysqld_safe[20867]: 110723  1:32:03 [Note] Plugin 'FEDERATED' is disabled.
Jul 23 01:32:03 gamerzzone mysqld_safe[20867]: 110723  1:32:03 [Note] Plugin 'FEDERATED' is disabled.
Jul 23 01:32:04 gamerzzone mysqld_safe[20867]: 110723  1:32:04  InnoDB: Started; log sequence number 0 44233
Jul 23 01:32:04 gamerzzone mysqld_safe[20867]: 110723  1:32:04  InnoDB: Started; log sequence number 0 44233
Jul 23 01:32:04 gamerzzone mysqld_safe[20867]: ERROR: 1064  You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE user ADD column Show_view_priv enum('N','Y') CHARACTER SET utf8 NOT ' at line 1
Jul 23 01:32:04 gamerzzone mysqld_safe[20867]: ERROR: 1064  You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE user ADD column Show_view_priv enum('N','Y') CHARACTER SET utf8 NOT ' at line 1
Jul 23 01:32:04 gamerzzone mysqld_safe[20867]: 110723  1:32:04 [ERROR] Aborting
Jul 23 01:32:04 gamerzzone mysqld_safe[20867]: 110723  1:32:04 [ERROR] Aborting
Jul 23 01:32:04 gamerzzone mysqld_safe[20867]: 
Jul 23 01:32:04 gamerzzone mysqld_safe[20867]: 
Jul 23 01:32:04 gamerzzone mysqld_safe[20867]: 110723  1:32:04  InnoDB: Starting shutdown...
Jul 23 01:32:04 gamerzzone mysqld_safe[20867]: 110723  1:32:04  InnoDB: Starting shutdown...
Jul 23 01:32:09 gamerzzone mysqld_safe[20867]: 110723  1:32:09  InnoDB: Shutdown completed; log sequence number 0 44233
Jul 23 01:32:09 gamerzzone mysqld_safe[20867]: 110723  1:32:09  InnoDB: Shutdown completed; log sequence number 0 44233
Jul 23 01:32:09 gamerzzone mysqld_safe[20867]: 110723  1:32:09 [Note] /usr/sbin/mysqld: Shutdown complete
Jul 23 01:32:09 gamerzzone mysqld_safe[20867]: 110723  1:32:09 [Note] /usr/sbin/mysqld: Shutdown complete
Jul 23 01:32:09 gamerzzone mysqld_safe[20867]: 
Jul 23 01:32:09 gamerzzone mysqld_safe[20867]: 
Jul 23 01:32:09 gamerzzone mysqld_safe[20882]: 110723  1:32:09 [Note] Plugin 'FEDERATED' is disabled.
Jul 23 01:32:09 gamerzzone mysqld_safe[20882]: 110723  1:32:09 [Note] Plugin 'FEDERATED' is disabled.
Jul 23 01:32:09 gamerzzone mysqld_safe[20882]: 110723  1:32:09  InnoDB: Started; log sequence number 0 44233
Jul 23 01:32:09 gamerzzone mysqld_safe[20882]: 110723  1:32:09  InnoDB: Started; log sequence number 0 44233
Jul 23 01:32:09 gamerzzone mysqld_safe[20882]: 110723  1:32:09  InnoDB: Starting shutdown...
Jul 23 01:32:09 gamerzzone mysqld_safe[20882]: 110723  1:32:09  InnoDB: Starting shutdown...
Jul 23 01:32:14 gamerzzone mysqld_safe[20882]: 110723  1:32:14  InnoDB: Shutdown completed; log sequence number 0 44233
Jul 23 01:32:14 gamerzzone mysqld_safe[20882]: 110723  1:32:14  InnoDB: Shutdown completed; log sequence number 0 44233
Jul 23 01:32:14 gamerzzone mysqld_safe[20897]: 110723  1:32:14 [Note] Plugin 'FEDERATED' is disabled.
Jul 23 01:32:14 gamerzzone mysqld_safe[20897]: 110723  1:32:14 [Note] Plugin 'FEDERATED' is disabled.
Jul 23 01:32:14 gamerzzone mysqld_safe[20897]: 110723  1:32:14  InnoDB: Started; log sequence number 0 44233
Jul 23 01:32:14 gamerzzone mysqld_safe[20897]: 110723  1:32:14  InnoDB: Started; log sequence number 0 44233
Jul 23 01:32:14 gamerzzone mysqld_safe[20897]: ERROR: 1050  Table 'plugin' already exists
Jul 23 01:32:14 gamerzzone mysqld_safe[20897]: ERROR: 1050  Table 'plugin' already exists
Jul 23 01:32:14 gamerzzone mysqld_safe[20897]: 110723  1:32:14 [ERROR] Aborting
Jul 23 01:32:14 gamerzzone mysqld_safe[20897]: 110723  1:32:14 [ERROR] Aborting
Jul 23 01:32:14 gamerzzone mysqld_safe[20897]: 
Jul 23 01:32:14 gamerzzone mysqld_safe[20897]: 
Jul 23 01:32:14 gamerzzone mysqld_safe[20897]: 110723  1:32:14  InnoDB: Starting shutdown...
Jul 23 01:32:14 gamerzzone mysqld_safe[20897]: 110723  1:32:14  InnoDB: Starting shutdown...
Jul 23 01:32:19 gamerzzone mysqld_safe[20897]: 110723  1:32:19  InnoDB: Shutdown completed; log sequence number 0 44233
Jul 23 01:32:19 gamerzzone mysqld_safe[20897]: 110723  1:32:19  InnoDB: Shutdown completed; log sequence number 0 44233
Jul 23 01:32:19 gamerzzone mysqld_safe[20897]: 110723  1:32:19 [Note] /usr/sbin/mysqld: Shutdown complete
Jul 23 01:32:19 gamerzzone mysqld_safe[20897]: 110723  1:32:19 [Note] /usr/sbin/mysqld: Shutdown complete
Jul 23 01:32:19 gamerzzone mysqld_safe[20897]: 
Jul 23 01:32:19 gamerzzone mysqld_safe[20897]: 
Jul 23 01:32:20 gamerzzone mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
Jul 23 01:32:20 gamerzzone mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
Jul 23 01:32:20 gamerzzone mysqld: 110723  1:32:20 [Note] Plugin 'FEDERATED' is disabled.
Jul 23 01:32:20 gamerzzone mysqld: 110723  1:32:20 [Note] Plugin 'FEDERATED' is disabled.
Jul 23 01:32:20 gamerzzone mysqld: 110723  1:32:20  InnoDB: Started; log sequence number 0 44233
Jul 23 01:32:20 gamerzzone mysqld: 110723  1:32:20  InnoDB: Started; log sequence number 0 44233
Jul 23 01:32:20 gamerzzone mysqld: 110723  1:32:20 [Note] Event Scheduler: Loaded 0 events
Jul 23 01:32:20 gamerzzone mysqld: 110723  1:32:20 [Note] Event Scheduler: Loaded 0 events
Jul 23 01:32:20 gamerzzone mysqld: 110723  1:32:20 [Note] /usr/sbin/mysqld: ready for connections.
Jul 23 01:32:20 gamerzzone mysqld: 110723  1:32:20 [Note] /usr/sbin/mysqld: ready for connections.
Jul 23 01:32:20 gamerzzone mysqld: Version: '5.1.49-3+ultimedia1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Debian)
Jul 23 01:32:20 gamerzzone mysqld: Version: '5.1.49-3+ultimedia1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Debian)
Jul 23 01:32:21 gamerzzone /etc/mysql/debian-start[21109]: Upgrading MySQL tables if necessary.
Jul 23 01:32:21 gamerzzone /etc/mysql/debian-start[21109]: Upgrading MySQL tables if necessary.
Jul 23 01:32:21 gamerzzone mysqld: 
Jul 23 01:32:21 gamerzzone mysqld: 
Jul 23 01:32:21 gamerzzone mysqld: Status information:
Jul 23 01:32:21 gamerzzone mysqld: Status information:
Jul 23 01:32:21 gamerzzone mysqld: 
Jul 23 01:32:21 gamerzzone mysqld: 
Jul 23 01:32:21 gamerzzone mysqld: Current dir: /var/lib/mysql/
Jul 23 01:32:21 gamerzzone mysqld: Current dir: /var/lib/mysql/
Jul 23 01:32:21 gamerzzone mysqld: Running threads: 1  Stack size: 196608
Jul 23 01:32:21 gamerzzone mysqld: Running threads: 1  Stack size: 196608
Jul 23 01:32:21 gamerzzone mysqld: Current locks:
Jul 23 01:32:21 gamerzzone mysqld: Current locks:
Jul 23 01:32:21 gamerzzone mysqld: lock: 0xb8e14b40: write
Jul 23 01:32:21 gamerzzone mysqld: lock: 0xb8e14b40: write
Jul 23 01:32:21 gamerzzone mysqld: write     : 0xb8dd5e28 (6:7); 
Jul 23 01:32:21 gamerzzone mysqld: write     : 0xb8dd5e28 (6:7); 
Jul 23 01:32:21 gamerzzone mysqld: 
Jul 23 01:32:21 gamerzzone mysqld: 
Jul 23 01:32:21 gamerzzone mysqld: lock: 0xb8e5c3d0:
Jul 23 01:32:21 gamerzzone mysqld: lock: 0xb8e5c3d0:
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 198 bytes
Desc: This is a digitally signed message part
URL: <http://lists.alioth.debian.org/pipermail/pkg-mysql-maint/attachments/20110723/c95fad6b/attachment-0001.pgp>