List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:March 29 2001 5:42pm
Subject:Re: safe-mysqld segfaults every 10 minutes
View as plain text  
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 <mysql-thread69938@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Thread
safe-mysqld segfaults every 10 minutesIvan Lamouret29 Mar
  • Re: safe-mysqld segfaults every 10 minutesGerald Clark29 Mar
    • Re: safe-mysqld segfaults every 10 minutesIvan Lamouret2 Apr