If you are running RedHat, look at the files /etc/cron.daily,
/etc/cron.weekly etc.
Stephan Skusa wrote:
> The Cron-Jobs working on all tables of these database are
> all running between 2:00 and 4:00 ... none at 0:00!
>
>
>> -----Ursprungliche Nachricht-----
>> Von: Gerald Clark [mailto:[EMAIL PROTECTED]]
>> Gesendet: Montag, 7. Mai 2001 15:24
>> An: Stephan Skusa
>> Cc: MySQL
>> Betreff: Re: MySQL-Server getting signal 11 ... !!
>>
>>
>> Check what cron does every day at 0:00.
>> It is probably deleting your socket.
>>
>> Stephan Skusa wrote:
>>
>>
>>> Hello,
>>>
>>> I've got a problem:
>>>
>>> My MySQL-Server gets signal 11 almost every day arround 0:00 am
>>
>> ... I have a
>>
>>> nice
>>> mrtg - graph showing this ... ;o)
>>>
>>> In fact every time the server crashes the statement shown in
>>
>> the server.log
>>
>>> (or a
>>> similar one with other memID) is executed.
>>>
>>> topsitesTEMP is a temporary table. Every time I execute this statement
>>> manualy
>>> using tool mysql everything works fine.
>>>
>>> TIA
>>> Stephan Skusa
>>>
>>>
>>> mysqld got signal 11;
>>> The manual section 'Debugging a MySQL server' tells you how to use a
>>> stack trace and/or the core file to produce a readable
>>
>> backtrace that may
>>
>>> help in finding out why mysqld died
>>> Attemping backtrace. You can use the following information to find out
>>> where mysqld died. If you see no messages after this, something went
>>> terribly wrong
>>> stack range sanity check, ok, backtrace follows
>>> 0x4009365d
>>> 0x80d7664
>>> 0x80b7d2d
>>> 0x80dab94
>>> 0x80dab19
>>> 0x80c3629
>>> 0x80c67e2
>>> 0x80c27f3
>>> 0x80c1b57
>>> stack trace successful, now will try to get some
>>> variables. Some pointers may be invalid and cause dump abort
>>> thd->query at 0x84af148 = SELECT myROWNUM, histRANKING FROM topsitesTEMP
>>> WHERE memID=12800
>>> thd->thread_id = 17276
>>> successfully dumped variables, if you ran with --log
>>> take a look at the details of what thread 17276 did to cause the crash.
>>> In some cases of really bad corruption, this value can be invalid
>>> Please use the information above to create a repeatable
>>> test case for the crash, and send it to [EMAIL PROTECTED]
>>>
>>> Number of processes running now: 0
>>> 010504 23:56:38 mysqld restarted
>>> /usr/local/mysql-3.23.33/libexec/mysqld: Warten auf Verbindungen.
>>>
>>>
>>> ---------------------------------------------------------------------
>>> 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
>>
>>
>> --
>> Gerald L. Clark
>> [EMAIL PROTECTED]
>>
>>
>> ---------------------------------------------------------------------
>> 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
>>
--
Gerald L. Clark
[EMAIL PROTECTED]
---------------------------------------------------------------------
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