[debian-mysql] Bug#545751: Bug#545751

Tue Oct 20 23:56:19 UTC 2009

I'd like to confirm that this also happens with a clean install of pure squeeze (only iceweasel taken from experimental). I tried both mysql-server from squeeze (5.1.37-2) and sid (5.1.39-1). 

I have no knowledge on how this all works, I only need it as a kmail dependency (which is quite silly BTW). I didn't sent an upstream bug. Since it's a syntax error the bug is most likely linked to the package itself. 

marcin at localhost:~$ sudo cat /var/log/syslog | grep mysql

Oct 21 01:38:13 localhost mysqld_safe[6640]: 091021  1:38:13 [Warning] Forcing shutdown of 2 plugins
Oct 21 01:38:13 localhost mysqld_safe[6640]: 091021  1:38:13 [Warning] Forcing shutdown of 2 plugins
Oct 21 01:38:13 localhost mysqld_safe[6640]: 
Oct 21 01:38:13 localhost mysqld_safe[6640]: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
Oct 21 01:38:13 localhost mysqld_safe[6640]: To do so, start the server, then issue the following commands:
Oct 21 01:38:13 localhost mysqld_safe[6640]: 
Oct 21 01:38:13 localhost mysqld_safe[6640]: /usr/bin/mysqladmin -u root password 'new-password'
Oct 21 01:38:13 localhost mysqld_safe[6640]: /usr/bin/mysqladmin -u root -h localhost password 'new-password'
Oct 21 01:38:13 localhost mysqld_safe[6640]: 
Oct 21 01:38:13 localhost mysqld_safe[6640]: Alternatively you can run:
Oct 21 01:38:13 localhost mysqld_safe[6640]: /usr/bin/mysql_secure_installation
Oct 21 01:38:13 localhost mysqld_safe[6640]: 
Oct 21 01:38:13 localhost mysqld_safe[6640]: which will also give you the option of removing the test
Oct 21 01:38:13 localhost mysqld_safe[6640]: databases and anonymous user created by default.  This is
Oct 21 01:38:13 localhost mysqld_safe[6640]: strongly recommended for production servers.
Oct 21 01:38:13 localhost mysqld_safe[6640]: 
Oct 21 01:38:13 localhost mysqld_safe[6640]: See the manual for more instructions.
Oct 21 01:38:13 localhost mysqld_safe[6640]: 
Oct 21 01:38:13 localhost mysqld_safe[6640]: Please report any problems with the /usr/scripts/mysqlbug script!
Oct 21 01:38:13 localhost mysqld_safe[6640]: 
Oct 21 01:38:13 localhost mysqld_safe[6640]: The latest information about MySQL is available at http://www.mysql.com/
Oct 21 01:38:13 localhost mysqld_safe[6640]: Support MySQL by buying support/licenses from http://shop.mysql.com/
Oct 21 01:38:13 localhost mysqld_safe[6640]: 
Oct 21 01:38:13 localhost mysqld_safe[6686]: 091021  1:38:13 [Note] Plugin 'FEDERATED' is disabled.
Oct 21 01:38:13 localhost mysqld_safe[6686]: 091021  1:38:13  InnoDB: Started; log sequence number 0 44233
Oct 21 01:38:13 localhost mysqld_safe[6686]: 091021  1:38:13  InnoDB: Starting shutdown...
Oct 21 01:38:14 localhost mysqld_safe[6686]: 091021  1:38:14  InnoDB: Shutdown completed; log sequence number 0 44233
Oct 21 01:38:14 localhost mysqld_safe[6686]: 091021  1:38:14 [Warning] Forcing shutdown of 1 plugins
Oct 21 01:38:15 localhost mysqld_safe[6738]: 091021  1:38:15 [Note] Plugin 'FEDERATED' is disabled.
Oct 21 01:38:15 localhost mysqld_safe[6738]: 091021  1:38:15  InnoDB: Started; log sequence number 0 44233
Oct 21 01:38:15 localhost mysqld_safe[6738]: 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
Oct 21 01:38:15 localhost mysqld_safe[6738]: 091021  1:38:15 [ERROR] Aborting
Oct 21 01:38:15 localhost mysqld_safe[6738]: 
Oct 21 01:38:15 localhost mysqld_safe[6738]: 091021  1:38:15  InnoDB: Starting shutdown...
Oct 21 01:38:17 localhost mysqld_safe[6738]: 091021  1:38:17  InnoDB: Shutdown completed; log sequence number 0 44233
Oct 21 01:38:17 localhost mysqld_safe[6738]: 091021  1:38:17 [Warning] Forcing shutdown of 1 plugins
Oct 21 01:38:17 localhost mysqld_safe[6738]: 091021  1:38:17 [Note] /usr/sbin/mysqld: Shutdown complete
Oct 21 01:38:17 localhost mysqld_safe[6738]: 
Oct 21 01:38:17 localhost mysqld_safe[6760]: 091021  1:38:17 [Note] Plugin 'FEDERATED' is disabled.
Oct 21 01:38:17 localhost mysqld_safe[6760]: 091021  1:38:17  InnoDB: Started; log sequence number 0 44233
Oct 21 01:38:17 localhost mysqld_safe[6760]: 091021  1:38:17  InnoDB: Starting shutdown...
Oct 21 01:38:18 localhost mysqld_safe[6760]: 091021  1:38:18  InnoDB: Shutdown completed; log sequence number 0 44233
Oct 21 01:38:18 localhost mysqld_safe[6760]: 091021  1:38:18 [Warning] Forcing shutdown of 1 plugins
Oct 21 01:38:18 localhost mysqld_safe[6786]: 091021  1:38:18 [Note] Plugin 'FEDERATED' is disabled.
Oct 21 01:38:18 localhost mysqld_safe[6786]: 091021  1:38:18  InnoDB: Started; log sequence number 0 44233
Oct 21 01:38:18 localhost mysqld_safe[6786]: ERROR: 1050  Table 'plugin' already exists
Oct 21 01:38:18 localhost mysqld_safe[6786]: 091021  1:38:18 [ERROR] Aborting
Oct 21 01:38:18 localhost mysqld_safe[6786]: 
Oct 21 01:38:18 localhost mysqld_safe[6786]: 091021  1:38:18  InnoDB: Starting shutdown...
Oct 21 01:38:19 localhost mysqld_safe[6786]: 091021  1:38:19  InnoDB: Shutdown completed; log sequence number 0 44233
Oct 21 01:38:19 localhost mysqld_safe[6786]: 091021  1:38:19 [Warning] Forcing shutdown of 1 plugins
Oct 21 01:38:19 localhost mysqld_safe[6786]: 091021  1:38:19 [Note] /usr/sbin/mysqld: Shutdown complete
Oct 21 01:38:19 localhost mysqld_safe[6786]: 
Oct 21 01:38:19 localhost mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
Oct 21 01:38:19 localhost mysqld: 091021  1:38:19 [Note] Plugin 'FEDERATED' is disabled.
Oct 21 01:38:20 localhost mysqld: 091021  1:38:20  InnoDB: Started; log sequence number 0 44233
Oct 21 01:38:20 localhost mysqld: 091021  1:38:20 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
Oct 21 01:38:20 localhost mysqld: 091021  1:38:20 [ERROR] Do you already have another mysqld server running on port: 3306 ?
Oct 21 01:38:20 localhost mysqld: 091021  1:38:20 [ERROR] Aborting
Oct 21 01:38:20 localhost mysqld: 
Oct 21 01:38:20 localhost mysqld: 091021  1:38:20  InnoDB: Starting shutdown...
Oct 21 01:38:21 localhost mysqld: 091021  1:38:21  InnoDB: Shutdown completed; log sequence number 0 44233
Oct 21 01:38:21 localhost mysqld: 091021  1:38:21 [Warning] Forcing shutdown of 1 plugins
Oct 21 01:38:21 localhost mysqld: 091021  1:38:21 [Note] /usr/sbin/mysqld: Shutdown complete
Oct 21 01:38:21 localhost mysqld: 
Oct 21 01:38:21 localhost mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
Oct 21 01:38:34 localhost /etc/init.d/mysql[7258]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Oct 21 01:38:34 localhost /etc/init.d/mysql[7258]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
Oct 21 01:38:34 localhost /etc/init.d/mysql[7258]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Oct 21 01:38:34 localhost /etc/init.d/mysql[7258]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Oct 21 01:38:34 localhost /etc/init.d/mysql[7258]: 
Oct 21 01:38:35 localhost mysqld_safe[7346]: 091021  1:38:35 [Warning] Forcing shutdown of 2 plugins
Oct 21 01:38:35 localhost mysqld_safe[7346]: 091021  1:38:35 [Warning] Forcing shutdown of 2 plugins
Oct 21 01:38:35 localhost mysqld_safe[7346]: 
Oct 21 01:38:35 localhost mysqld_safe[7346]: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
Oct 21 01:38:35 localhost mysqld_safe[7346]: To do so, start the server, then issue the following commands:
Oct 21 01:38:35 localhost mysqld_safe[7346]: 
Oct 21 01:38:35 localhost mysqld_safe[7346]: /usr/bin/mysqladmin -u root password 'new-password'
Oct 21 01:38:35 localhost mysqld_safe[7346]: /usr/bin/mysqladmin -u root -h localhost password 'new-password'
Oct 21 01:38:35 localhost mysqld_safe[7346]: 
Oct 21 01:38:35 localhost mysqld_safe[7346]: Alternatively you can run:
Oct 21 01:38:35 localhost mysqld_safe[7346]: /usr/bin/mysql_secure_installation
Oct 21 01:38:35 localhost mysqld_safe[7346]: 
Oct 21 01:38:35 localhost mysqld_safe[7346]: which will also give you the option of removing the test
Oct 21 01:38:35 localhost mysqld_safe[7346]: databases and anonymous user created by default.  This is
Oct 21 01:38:35 localhost mysqld_safe[7346]: strongly recommended for production servers.
Oct 21 01:38:35 localhost mysqld_safe[7346]: 
Oct 21 01:38:35 localhost mysqld_safe[7346]: See the manual for more instructions.
Oct 21 01:38:35 localhost mysqld_safe[7346]: 
Oct 21 01:38:35 localhost mysqld_safe[7346]: Please report any problems with the /usr/scripts/mysqlbug script!
Oct 21 01:38:35 localhost mysqld_safe[7346]: 
Oct 21 01:38:35 localhost mysqld_safe[7346]: The latest information about MySQL is available at http://www.mysql.com/
Oct 21 01:38:35 localhost mysqld_safe[7346]: Support MySQL by buying support/licenses from http://shop.mysql.com/
Oct 21 01:38:35 localhost mysqld_safe[7346]: 
Oct 21 01:38:35 localhost mysqld_safe[7397]: 091021  1:38:35 [Note] Plugin 'FEDERATED' is disabled.
Oct 21 01:38:35 localhost mysqld_safe[7397]: 091021  1:38:35  InnoDB: Started; log sequence number 0 44233
Oct 21 01:38:35 localhost mysqld_safe[7397]: 091021  1:38:35  InnoDB: Starting shutdown...
Oct 21 01:38:36 localhost mysqld_safe[7397]: 091021  1:38:36  InnoDB: Shutdown completed; log sequence number 0 44233
Oct 21 01:38:36 localhost mysqld_safe[7397]: 091021  1:38:36 [Warning] Forcing shutdown of 1 plugins
Oct 21 01:38:36 localhost mysqld_safe[7427]: 091021  1:38:36 [Note] Plugin 'FEDERATED' is disabled.
Oct 21 01:38:36 localhost mysqld_safe[7427]: 091021  1:38:36  InnoDB: Started; log sequence number 0 44233
Oct 21 01:38:36 localhost mysqld_safe[7427]: 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
Oct 21 01:38:36 localhost mysqld_safe[7427]: 091021  1:38:36 [ERROR] Aborting
Oct 21 01:38:36 localhost mysqld_safe[7427]: 
Oct 21 01:38:36 localhost mysqld_safe[7427]: 091021  1:38:36  InnoDB: Starting shutdown...
Oct 21 01:38:38 localhost mysqld_safe[7427]: 091021  1:38:38  InnoDB: Shutdown completed; log sequence number 0 44233
Oct 21 01:38:38 localhost mysqld_safe[7427]: 091021  1:38:38 [Warning] Forcing shutdown of 1 plugins
Oct 21 01:38:38 localhost mysqld_safe[7427]: 091021  1:38:38 [Note] /usr/sbin/mysqld: Shutdown complete
Oct 21 01:38:38 localhost mysqld_safe[7427]: 
Oct 21 01:38:38 localhost mysqld_safe[7450]: 091021  1:38:38 [Note] Plugin 'FEDERATED' is disabled.
Oct 21 01:38:38 localhost mysqld_safe[7450]: 091021  1:38:38  InnoDB: Started; log sequence number 0 44233
Oct 21 01:38:38 localhost mysqld_safe[7450]: 091021  1:38:38  InnoDB: Starting shutdown...
Oct 21 01:38:39 localhost mysqld_safe[7450]: 091021  1:38:39  InnoDB: Shutdown completed; log sequence number 0 44233
Oct 21 01:38:39 localhost mysqld_safe[7450]: 091021  1:38:39 [Warning] Forcing shutdown of 1 plugins
Oct 21 01:38:39 localhost mysqld_safe[7473]: 091021  1:38:39 [Note] Plugin 'FEDERATED' is disabled.
Oct 21 01:38:39 localhost mysqld_safe[7473]: 091021  1:38:39  InnoDB: Started; log sequence number 0 44233
Oct 21 01:38:39 localhost mysqld_safe[7473]: ERROR: 1050  Table 'plugin' already exists
Oct 21 01:38:39 localhost mysqld_safe[7473]: 091021  1:38:39 [ERROR] Aborting
Oct 21 01:38:39 localhost mysqld_safe[7473]: 
Oct 21 01:38:39 localhost mysqld_safe[7473]: 091021  1:38:39  InnoDB: Starting shutdown...
Oct 21 01:38:40 localhost mysqld_safe[7473]: 091021  1:38:40  InnoDB: Shutdown completed; log sequence number 0 44233
Oct 21 01:38:40 localhost mysqld_safe[7473]: 091021  1:38:40 [Warning] Forcing shutdown of 1 plugins
Oct 21 01:38:40 localhost mysqld_safe[7473]: 091021  1:38:40 [Note] /usr/sbin/mysqld: Shutdown complete
Oct 21 01:38:40 localhost mysqld_safe[7473]: 
Oct 21 01:38:40 localhost mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
Oct 21 01:38:40 localhost mysqld: 091021  1:38:40 [Note] Plugin 'FEDERATED' is disabled.
Oct 21 01:38:41 localhost mysqld: 091021  1:38:41  InnoDB: Started; log sequence number 0 44233
Oct 21 01:38:41 localhost mysqld: 091021  1:38:41 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
Oct 21 01:38:41 localhost mysqld: 091021  1:38:41 [ERROR] Do you already have another mysqld server running on port: 3306 ?
Oct 21 01:38:41 localhost mysqld: 091021  1:38:41 [ERROR] Aborting
Oct 21 01:38:41 localhost mysqld: 
Oct 21 01:38:41 localhost mysqld: 091021  1:38:41  InnoDB: Starting shutdown...
Oct 21 01:38:42 localhost mysqld: 091021  1:38:42  InnoDB: Shutdown completed; log sequence number 0 44233
Oct 21 01:38:42 localhost mysqld: 091021  1:38:42 [Warning] Forcing shutdown of 1 plugins
Oct 21 01:38:42 localhost mysqld: 091021  1:38:42 [Note] /usr/sbin/mysqld: Shutdown complete
Oct 21 01:38:42 localhost mysqld: 
Oct 21 01:38:42 localhost mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
Oct 21 01:38:55 localhost /etc/init.d/mysql[7945]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Oct 21 01:38:55 localhost /etc/init.d/mysql[7945]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
Oct 21 01:38:55 localhost /etc/init.d/mysql[7945]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Oct 21 01:38:55 localhost /etc/init.d/mysql[7945]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Oct 21 01:38:55 localhost /etc/init.d/mysql[7945]: 