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
>
---------------------------------------------------------------------
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
