Hi,
It happened to me ...with Red Hat 7.2 and MySQL 3.23.47.
Anyway if you want to see easily what's wrong you can do:
Identify the PID of your process which make monitoring processes.
In other task you can do :
strace -d -p the_PID
...and let it open.
When MySQL crash strace tell you with what signal is out.
If the signal is one of : SIGILL or SIGBUS you have a hardware problem for
sure . Else ....
So...which what signal die ?
Regards,
Gelu
_____________________________________________________
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
----- Original Message -----
From: "Steven Wilton" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 04, 2002 5:29 AM
Subject: Mysl crashing
> >Description:
> Our mysql server crashes relatively often. Most of the time after a
crash, the error logs show a line like "thd->query at 0x84aef98 = show
processlist" (although some have "0x50e64580 is invalid pointer" and others
"(nil) is invalid pointer"). We do have a process which regularly does a
"show processlist" on this server.
> I was running the debian packaged version of mysql (latest version in
woody), but upgraded to mysql-max and ran myisamchk on all tables before
starting the database to make sure that the problems were not benig caused
by table corruption. I do not believe that we are using any functions that
require mysql-max, so if installing the binary release of mysql is the next
recommended step, I can do this.
>
> >How-To-Repeat:
> I can not get this to happen on demand, but I was wondering if the above
lines indicate that the "show processlist" command was causing the problem.
>
> >Fix:
> Unknown
>
> >Submitter-Id: <submitter ID>
> >Originator: root
> >Organization:
>
> >MySQL support: none
> >Synopsis:
> >Severity:
> >Priority:
> >Category: mysql
> >Class:
> >Release: mysql-3.23.49 (Source distribution)
> >Server: /usr/bin/mysqladmin Ver 8.23 Distrib 3.23.49, for pc-linux-gnu
on i686
> Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
> This software comes with ABSOLUTELY NO WARRANTY. This is free software,
> and you are welcome to modify and redistribute it under the GPL license
>
> Server version 3.23.49a-max-log
> Protocol version 10
> Connection Localhost via UNIX socket
> UNIX socket /var/run/mysqld/mysqld.sock
> Uptime: 3 days 9 hours 36 min 13 sec
>
> Threads: 45 Questions: 21283332 Slow queries: 701 Opens: 186 Flush
tables: 1 Open tables: 98 Queries per second avg: 72.448
> >Environment:
>
> System: Linux mysql1 2.4.18 #3 SMP Thu May 9 14:56:09 WST 2002 i686
unknown
> Architecture: i686
>
> Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
> GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs
> gcc version 2.95.4 20011002 (Debian prerelease)
> Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS=''
> LIBC:
> lrwxrwxrwx 1 root root 14 Mar 8 09:07 /lib/libc.so.5 ->
libc.so.5.4.46
> -rw-r--r-- 1 root root 563068 Feb 5 05:30
/lib/libc.so.5.4.46
> lrwxrwxrwx 1 root root 13 May 22 10:44 /lib/libc.so.6 ->
libc-2.2.5.so
> -rwxr-xr-x 1 root root 1153784 Apr 28 17:57 /lib/libc-2.2.5.so
> -rw-r--r-- 1 root root 2390922 Apr 28 17:58 /usr/lib/libc.a
> -rw-r--r-- 1 root root 178 Apr 28 17:58 /usr/lib/libc.so
> Configure command:
./configure --prefix=/usr --exec-prefix=/usr --libexecdir=/usr/sbin --datad
ir=/usr/share --sysconfdir=/etc/mysql --localstatedir=/var/lib/mysql --inclu
dedir=/usr/include --infodir=/usr/share/info --mandir=/usr/share/man --enabl
e-shared --with-libwrap --enable-assembler --with-berkeley-db --with-innodb
--enable-static --enable-shared --enable-local-infile --with-raid --enable-t
hread-safe-client --without-readline --with-unix-socket-path=/var/run/mysqld
/mysqld.sock --with-mysqld-user=mysql --without-bench --with-client-ldflags=
-lstdc++ --with-extra-charsets=all
>
>
> ---------------------------------------------------------------------
> 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
