I would check to see what chron is doing every 10 minutes.
Ivan Lamouret wrote:
>
> >Description:
>
> safe_myqld keeps restarting the server until it eventually dies (number of running
>process 0).
> This is true when the server is ran as a daemon and from the shell !!
> using --skip-grant-table does not help
>
> just leaving safe-mysqld running (without any query or even connection to the
>database),
> I get the following message in the error log,
>
> >>Number of processes running now: 1
> >>mysqld process hanging, pid 2483 - killed
> >>010329 15:10:05 mysqld restarted
> >>/usr/local/mysql/bin/mysqld: ready for connections
>
> Note that it is always exactly 10, 20, 30, etc, past the hour ...
> By the way, during the interval between restarts, the server works fine.
> On standard error there is also
> >> ./bin/safe_mysqld: line 255: 2480 Segmentation fault $NOHUP_NICENESS
>$ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR
>$USER_OPTION --pid-file=$pid_file --skip-locking >> $err_log 2>&1
>
> I have seen a couple of emails in the general discussion mailing list
> from people with Pbs similar to mines, but I can not get any help from the answers :(
> e.g.
> - safe_mysqld & causing a loop of crashes (Sept 99)
> Running a RH binary distrib on a Slackware, and the advice was to
>use a src distrib
>
> - mysqld got signal 11 every 10 minutes (Feb 2001)
> using a src distrib on a Suse and the advice was to try the exact same
>binary distrib I am using!
> also Subject: mysql bug report.
> From: Roy F. Cabaniss
> Date: Fri, 16 Jul 1999 14:02:46 -0500
> <quote>The only way to recover was to do a fresh install of the entire linux
>on a
> freshly formatted hard drive (bummer). </quote>
> also Subject: SegFault when starting safe_mysqld or mysqld
> From: beber.BlackDoor
> Date: Thu, 10 Aug 2000 18:54:51 +0200
> also Subject: Server error: Segmentation fault
> From: Andres Valenciano
> Date: Thu, 01 Feb 2001 15:20:04 -0600
> also Subject:ct: Help with a seg fault
> From: Boulat Khakimov
> Date: Mon, 26 Feb 2001 17:27:10 -0500
>
> I think the Pb might come from the safe-mysqld script :
> the loop is obviously there, but I do not understand it very well.
> Why does the script detects only one mysqld process, while doing ps aux gives 3 ?
> Is it possible that the script wrongly think mysqld hangs, because it fails on
> the $NOHUP_NICENESS or something...
>
>
> Thanks for your help
>
> >How-To-Repeat:
>
> Nothing to do, just wait 10 minutes and see it happen.
>
> >Fix:
> <how to correct or work around the problem, if known (multiple lines)>
>
> >Submitter-Id: <submitter ID>
> >Originator:
> >Organization:
> <organization of PR author (multiple lines)>
> >MySQL support: [none | licence | email support | extended email support ]
> >Synopsis: <synopsis of the problem (one line)>
> >Severity: <[ non-critical | serious | critical ] (one line)>
> >Priority: <[ low | medium | high ] (one line)>
> >Category: mysql
> >Class: <[ sw-bug | doc-bug | change-request | support ] (one line)>
> >Release: mysql-3.22.32 (Source distribution)
> >Server: /usr/local/bin/mysqladmin Ver 8.0 Distrib 3.22.32, for pc-linux-gnu on i686
> TCX Datakonsult AB, by Monty
>
> Server version 3.23.33
> Protocol version 10
> Connection Localhost via UNIX socket
> UNIX socket /tmp/mysql.sock
> Uptime: 1 min 40 sec
>
> Threads: 1 Questions: 1 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0
>Queries per second avg: 0.010
> >Environment:
> <machine, os, target, libraries (multiple lines)>
> System: Linux linux1 2.2.14 #1 Tue May 9 00:33:32 GMT 2000 i686 unknown
> Architecture: i686
>
> Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/local/bin/gcc
>/usr/bin/cc
> GCC: Reading specs from /usr/local/lib/gcc-lib/i686-pc-linux-gnu/2.95.2/specs
> gcc version 2.95.2 19991024 (release)
> Compilation info: CC='gcc' CFLAGS='' CXX='/usr/local/bin/g++' CXXFLAGS=''
>LDFLAGS=''
> Configure command: ./configure
> Perl: This is perl, version 5.005_03 built for i586-linux
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
