Ubuntu
mysql-dfsg-5.0 package

  1. Bug #105457
  2. Comment #5

Comment 5 for bug 105457

Revision history for this message
Gargoyle (g-rgoyle) wrote :

I have also seen this problem today on MySQL. My /var/log/mysql.err and .log files are also empty, I suspect this is another bug where the installation file is not configuring syslogd properly. However, below are some lines from /var/log/syslog. After I noticed that mysqld_safe was at 100% cpu, I issued a mysqladmin shutdown. (Note, up until that point the server and database were still running fine)

I suspect the first "mysqld_safe[15155]: ended" message is from the shutdown command and the second is the one I manually killed of via top.

----
Jan 22 14:27:24 mysql-01 -- MARK --
Jan 22 14:30:45 mysql-01 mysqld[13897]: 080122 14:30:45 [Note] /usr/sbin/mysqld: Normal shutdown
Jan 22 14:30:45 mysql-01 mysqld[13897]:
Jan 22 14:30:47 mysql-01 mysqld[13897]: 080122 14:30:47 InnoDB: Starting shutdown...
Jan 22 14:30:52 mysql-01 mysqld[13897]: 080122 14:30:52 InnoDB: Shutdown completed; log sequence number 0 71517936
Jan 22 14:30:52 mysql-01 mysqld[13897]: 080122 14:30:52 [Note] /usr/sbin/mysqld: Shutdown complete
Jan 22 14:30:52 mysql-01 mysqld[13897]:
Jan 22 14:30:52 mysql-01 mysqld_safe[15155]: ended
Jan 22 14:43:42 mysql-01 mysqld_safe[15180]: ended
Jan 22 14:44:04 mysql-01 mysqld_safe[15279]: started
Jan 22 14:44:08 mysql-01 mysqld[15282]: 080122 14:44:08 InnoDB: Started; log sequence number 0 71517936
Jan 22 14:44:08 mysql-01 mysqld[15282]: 080122 14:44:08 [Note] /usr/sbin/mysqld: ready for connections.
Jan 22 14:44:08 mysql-01 mysqld[15282]: Version: '5.0.45-Debian_1ubuntu3.1-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Debian etch distribution
Jan 22 14:44:08 mysql-01 /etc/mysql/debian-start[15344]: Upgrading MySQL tables if necessary.
Jan 22 14:44:09 mysql-01 /etc/mysql/debian-start[15348]: Looking for 'mysql' in: /usr/bin/mysql
Jan 22 14:44:09 mysql-01 /etc/mysql/debian-start[15348]: Looking for 'mysqlcheck' in: /usr/bin/mysqlcheck
Jan 22 14:44:09 mysql-01 /etc/mysql/debian-start[15348]: This installation of MySQL is already upgraded to 5.0.45, use --force if you still need to run mysql_upgrade
Jan 22 14:44:09 mysql-01 /etc/mysql/debian-start[15357]: Checking for insecure root accounts.
Jan 22 14:44:09 mysql-01 /etc/mysql/debian-start[15361]: Checking for crashed MySQL tables.
----