Re: [PLUG] MySQL server cyclic restarts

["Eric at Lucii.org" <eric@lucii.org>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Well, live and learn...

HTML email does not wrap when composing but, apparently (see below) all that is
defenestrated when the GPG kicks in!

Also, the mysql error log is NOT empty.  I was looking in the wrong place.  Of
course, it's of little help as it contains 42624 copies of this:

InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.

with a few other lines thrown in there for variety:


110315 18:10:36 [Note] Plugin 'FEDERATED' is disabled.
110315 18:12:16 [ERROR] Can't start server: Bind on TCP/IP port: Address already
in use
110315 18:12:16 [ERROR] Do you already have another mysqld server running on
port: 3306 ?
110315 18:12:16 [ERROR] Aborting

110315 18:12:16 [Note] /usr/sbin/mysqld: Shutdown complete


Curiouser and curiouser...

Eric

On 03/15/2011 01:47 PM, Eric at Lucii.org wrote:
> 
> I'm developing a web app on a Linode VM running a LAMP stack.  When I
> look at the syslog I see this bizarre behavior repeated about every
> 100 seconds day and night:
> 
> Mar 15 17:28:50 li282 init: mysql main process (4210) terminated with
> status 1
> Mar 15 17:28:50 li282 init: mysql main process ended, respawning
> Mar 15 17:28:50 li282 /etc/mysql/debian-start[4304]: Upgrading MySQL
> tables if necessary.
> Mar 15 17:28:50 li282 /etc/mysql/debian-start[4307]:
> /usr/bin/mysql_upgrade: the '--basedir' option is always ignored
> Mar 15 17:28:50 li282 /etc/mysql/debian-start[4307]: Looking for
> 'mysql' as: /usr/bin/mysql
> Mar 15 17:28:50 li282 /etc/mysql/debian-start[4307]: Looking for
> 'mysqlcheck' as: /usr/bin/mysqlcheck
> Mar 15 17:28:50 li282 /etc/mysql/debian-start[4307]: This installation
> of MySQL is already upgraded to 5.1.41, use --force if you still need
> to run mysql_upgrade
> Mar 15 17:28:50 li282 /etc/mysql/debian-start[4318]: Checking for
> insecure root accounts.
> Mar 15 17:28:50 li282 /etc/mysql/debian-start[4322]: Triggering
> myisam-recover for all MyISAM tables
> Mar 15 17:30:30 li282 init: mysql main process (4298) terminated with
> status 1
> Mar 15 17:30:30 li282 init: mysql main process ended, respawning
> Mar 15 17:30:30 li282 /etc/mysql/debian-start[4371]: Upgrading MySQL
> tables if necessary.
> Mar 15 17:30:30 li282 /etc/mysql/debian-start[4374]:
> /usr/bin/mysql_upgrade: the '--basedir' option is always ignored
> Mar 15 17:30:30 li282 /etc/mysql/debian-start[4374]: Looking for
> 'mysql' as: /usr/bin/mysql
> Mar 15 17:30:30 li282 /etc/mysql/debian-start[4374]: Looking for
> 'mysqlcheck' as: /usr/bin/mysqlcheck
> Mar 15 17:30:30 li282 /etc/mysql/debian-start[4374]: This installation
> of MySQL is already upgraded to 5.1.41, use --force if you still need
> to run mysql_upgrade
> Mar 15 17:30:30 li282 /etc/mysql/debian-start[4381]: Checking for
> insecure root accounts.
> Mar 15 17:30:30 li282 /etc/mysql/debian-start[4389]: Triggering
> myisam-recover for all MyISAM tables
> 
> The MySQL log and error log are empty (clearly not enough 'setting' on
> that!)
> 
> I tried google but did not find anything that relates to this.
> 
> Before I go cranking up logging levels and start breaking things...
> does this look familiar to anyone?
> Any hints of places to start?
> 
> I think of starting at /etc/inittab but, surprise surprise, Ubuntu
> does not have an inittab.  Sigh.
> 
> Thanks,
> Eric
> 
> PS apologies for html email but wide log files come across much better
> for me without the 80 char line wrap and I hope they do for you too.
> 

___________________________________________________________________________
Philadelphia Linux Users Group         --        http://www.phillylinux.org
Announcements - http://lists.phillylinux.org/mailman/listinfo/plug-announce
General Discussion  --   http://lists.phillylinux.org/mailman/listinfo/plug


- -- 
#  Eric Lucas
#
#                "Oh, I have slipped the surly bond of earth
#                 And danced the skies on laughter-silvered wings...
#                                        -- John Gillespie Magee Jr
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk1/rJQACgkQ2sGpvXQrZ/6qrACcCa62HqSfsNFiZiMH4NlWJTQh
WmcAoLu4265AWSjfI+VYbIdFsRbjELeR
=RFDE
-----END PGP SIGNATURE-----
___________________________________________________________________________
Philadelphia Linux Users Group         --        http://www.phillylinux.org
Announcements - http://lists.phillylinux.org/mailman/listinfo/plug-announce
General Discussion  --   http://lists.phillylinux.org/mailman/listinfo/plug