>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
