>Description: <Seems everytime I do a queary on the mysql server it just crashes out and restarts displays this "/usr/local/mysql/bin/safe_mysqld: line 273: 3078 Segmentation fault " and also the below in the log file [root@dev mysql-test]# ./mysql-test-run Installing Test Databases Removing Stale Files Installing Master Databases mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked agaist is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail
key_buffer_size=8388600 record_buffer=131072 sort_buffer=2097144 max_used_connections=0 max_connections=100 threads_connected=1 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 225791 K bytes of memory Hope that's ok, if not, decrease some variables in the equation Attempting 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: 0x808478e 0x8131730 0x8142ac6 0x808bc59 0x808e166 0x8086edb Stack trace seems successful - bottom reached Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at 0x82528f0 = CREATE TABLE db ( Host char(60) DEFAULT '' NOT NULL, Db char(64) DEFAULT '' NOT NULL, User char(16) DEFAULT '' NOT NULL, Select_priv enum('N','Y') DEFAULT 'N' NOT NULL, Insert_priv enum('N','Y') DEFAULT 'N' NOT NULL, Update_priv enum('N','Y') DEFAULT 'N' NOT NULL, Delete_priv enum('N','Y') DEFAULT 'N' NOT NULL, Create_priv enum('N','Y') DEFAULT 'N' NOT NULL, Drop_priv enum('N','Y') DEFAULT 'N' NOT NULL, Grant_priv enum('N','Y') DEFAULT 'N' NOT NULL, References_priv enum('N','Y') DEFAULT 'N' NOT NULL, Index_priv enum('N','Y') DEFAULT 'N' NOT NULL, Alter_priv enum('N','Y') DEFAULT 'N' NOT NULL, PRIMARY KEY Host (Host,Db,User), KEY User (User) ) comment='Database privileges' thd->thread_id=1 Successfully dumped variables, if you ran with --log, take a look at the details of what thread 1 did to cause the crash. In some cases of really bad corruption, the values shown above may be invalid The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains information that should help you find out what is causing the crash I did a stack follow up on it to reveal this [root@dev tmp]# /usr/local/mysql/bin/resolve_stack_dump -s /tmp/mysqld.sym -n mysqld.stack 0x808478e _Z15handle_segfaulti + 398 0x8131730 __pthread_sighandler + 116 0x8142ac6 __strtol_internal + 1390 0x808bc59 _Z17add_field_to_listPc16enum_field_typesS_S_jP4ItemS_P10st_typelib + 313 0x808e166 _Z7yyparsev + 3358 0x8086edb _Z16handle_bootstrapPv + 687 > >How-To-Repeat: <Well any query really, even the ones in scripts that came with the mysql source distro> >Fix: >Submitter-Id: <submitter ID> >Originator: Nick Clewer >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: <Mysql crashing> >Severity: >Priority: >Category: mysql >Class: >Release: mysql-3.23.53 (Source distribution) >Environment: System: Linux dev.webinteractive.com.au 2.4.18-14 #1 Wed Sep 4 13:35:50 EDT 2002 i686 i686 i386 GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.2/specs Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking --host=i386-redhat-linux --with-system-zlib --enable-__cxa_atexit Thread model: posix gcc version 3.2 20020903 (Red Hat Linux 8.0 3.2-7) Compilation info: CC='gcc' CFLAGS='-O3' CXX='gcc' CXXFLAGS='-O3 -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 14 Oct 16 2002 /lib/libc.so.6 -> libc-2.2.93.so -rwxr-xr-x 1 root root 1235468 Sep 6 09:12 /lib/libc-2.2.93.so -rw-r--r-- 1 root root 2233342 Sep 6 08:59 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Sep 6 08:50 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql --enable-assembler --with-mysqld-ldflags=-all-static --localstatedir=/var/lib/mysql CFLAGS=-O3 'CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti' CXX=gcc --------------------------------------------------------------------- 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