Re: Mysl crashing
Steven, Tuesday, June 04, 2002, 5:29:06 AM, you wrote: Description: SW 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 SW is invalid pointer and others (nil) is invalid pointer). We do have a process which regularly does a show processlist on this server. SW 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 SW 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 SW step, I can do this. How-To-Repeat: SW 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. Can you repeat it with the official MySQL binary distribution? Please, also check the tables. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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
Re: Mysl crashing
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: lrwxrwxrwx1 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 lrwxrwxrwx1 root root 13 May 22 10:44 /lib/libc.so.6 - libc-2.2.5.so -rwxr-xr-x1 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
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 version10 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: lrwxrwxrwx1 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 lrwxrwxrwx1 root root 13 May 22 10:44 /lib/libc.so.6 - libc-2.2.5.so -rwxr-xr-x1 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 --datadir=/usr/share --sysconfdir=/etc/mysql --localstatedir=/var/lib/mysql --includedir=/usr/include --infodir=/usr/share/info --mandir=/usr/share/man --enable-shared --with-libwrap --enable-assembler --with-berkeley-db --with-innodb --enable-static --enable-shared --enable-local-infile --with-raid --enable-thread-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