Comment 29 for bug 105457

I am running Ubuntu 8.04 Hardy 64 bit.
This exact problem started when I added MythTV from the standard repository.
MythTV adds a MySQL server.
I had already had MySQL server from an Apache install.
Now I seem to have two SQL servers.

I have some clues to add, although I am a Linux newbie and a recent Vista convert.
I had the mysqld_safe process running at 100 percent on one processor.
I ran this command: "sudo /etc/init.d/mysql restart"
and now I have two mysqld_safe processes running, 100 percent on both of two processors.

A view of /var/log/syslog shows a gazillion lines like this:

Oct 1 07:37:48 Athlon-Ubuntu kernel: [112619.174876] VFS: busy inodes on changed media.
Oct 1 07:37:48 Athlon-Ubuntu kernel: [112619.189661] VFS: busy inodes on changed media.
Oct 1 07:38:04 Athlon-Ubuntu kernel: [112635.159970] VFS: busy inodes on changed media.
Oct 1 07:38:04 Athlon-Ubuntu kernel: [112635.173478] VFS: busy inodes on changed media.

And then there was this interesting set of lines:

Oct 1 10:15:20 Athlon-Ubuntu mysqld_safe[24687]: Fatal error: Can't remove the pid file: /var/run/mysqld/mysqld.pid
Oct 1 10:15:20 Athlon-Ubuntu mysqld_safe[24689]: Please remove it manually and start /usr/bin/mysqld_safe again
Oct 1 10:15:20 Athlon-Ubuntu mysqld_safe[24691]: mysqld daemon not started

And then more of the gazillion lines

And then this, which happened at the time I issued the restart:

Oct 1 10:15:43 Athlon-Ubuntu mysqld_safe[24932]: started
Oct 1 10:15:43 Athlon-Ubuntu mysqld[24935]: 081001 10:15:43 InnoDB: Started; log sequence number 0 43655
Oct 1 10:15:43 Athlon-Ubuntu mysqld[24935]: 081001 10:15:43 [Note] /usr/sbin/mysqld: ready for connections.
Oct 1 10:15:43 Athlon-Ubuntu mysqld[24935]: Version: '5.0.51a-3ubuntu5.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
Oct 1 10:15:44 Athlon-Ubuntu /etc/mysql/debian-start[24974]: Upgrading MySQL tables if necessary.
Oct 1 10:15:44 Athlon-Ubuntu /etc/mysql/debian-start[24983]: Looking for 'mysql' in: /usr/bin/mysql
Oct 1 10:15:44 Athlon-Ubuntu /etc/mysql/debian-start[24983]: Looking for 'mysqlcheck' in: /usr/bin/mysqlcheck
Oct 1 10:15:44 Athlon-Ubuntu /etc/mysql/debian-start[24983]: This installation of MySQL is already upgraded to 5.0.51a, use --force if you still need to run mysql_upgrade
Oct 1 10:15:44 Athlon-Ubuntu /etc/mysql/debian-start[24989]: Checking for insecure root accounts.
Oct 1 10:15:44 Athlon-Ubuntu /etc/mysql/debian-start[24993]: WARNING: mysql.user contains 3 root accounts without password!
Oct 1 10:15:44 Athlon-Ubuntu /etc/mysql/debian-start[24994]: Checking for crashed MySQL tables.
Oct 1 10:15:45 Athlon-Ubuntu kernel: [122085.868833] VFS: busy inodes on changed media.

And then, more of the gazillion lines.

I am going to try the manual remove of the Pid file and post the results.

John.