>Description: I installed the most recent rpm for RedHat Linux 7.2. After running for no more than 10 minutes, it crashed. safe_mysqld failed to restart the daemon. >How-To-Repeat: I don't know. Here is all the information I have on the problem: Stack Trace: 0x806fc04 char_val + 44 0x8121588 _ufc_doit_r + 184 0x80d8d28 remove_key + 220 0x80d9cab nisam_create + 2491 0x80e2f17 mi_lock_database + 1031 0x80e2fb9 mi_copy_status + 1 0x80e2fb9 mi_copy_status + 1 0x80e313f _mi_writeinfo + 79 0x80e306a _mi_readinfo + 122 0x80bb82c mysql_load__FP3THDP12sql_exchangeP13st_table_listRt4List1Z4Item15enum_duplicatesb13thr_lock_type + 1052 0x80b1c8b optimize__9ha_myisamP3THDP15st_ha_check_opt + 111 0x80b3157 create__9ha_myisamPCcP8st_tableP24st_ha_create_information + 1547 0x80aeb25 make_sortkey__FP13st_sort_paramPUcPc + 589 0x808efb8 create_tmp_field__FP8st_tableP4ItemQ24Item4TypePPP17Item_result_fieldPP5FieldbT5 + 836 0x808d676 make_join_readinfo__FP4JOINUi + 862 0x8076860 add_join_on__FP13st_table_listP4Item + 64 0x807a91c yyparse__Fv + 15644 0x8075a15 mysql_init_query__FP3THD + 137 0x8074db7 mysql_execute_command__Fv + 10163
Query in log: thd->query at 0x8382ec0 = SELECT challenge FROM ladder_rules WHERE ladder='dartpros' thd->thread_id=1915 I should note that ladder_rules is actually a symlinked file to another file on an NFS share. We do this on all machines that are "read-only" queries for that table. >Fix: >Submitter-Id: <submitter ID> >Originator: root >Organization: Mikel Tidwell, Case's Ladder >MySQL support: none >Synopsis: mysqld crash >Severity: serious >Priority: medium >Category: mysql >Class: sw-bug >Release: mysql-3.23.56 (Official MySQL RPM) >Server: /usr/bin/mysqladmin Ver 8.23 Distrib 3.23.56, for pc-linux 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.56 Protocol version 10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 8 min 13 sec Threads: 9 Questions: 10938 Slow queries: 13 Opens: 156 Flush tables: 1 Open tables: 150 Queries per second avg: 22.187 >Environment: System: Linux cgi3 2.4.7-10smp #1 SMP Thu Sep 6 17:09:31 EDT 2001 i686 unknown 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/2.96/specs gcc version 2.96 20000731 (Red Hat Linux 7.1 2.96-98) Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='gcc' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Apr 5 2002 /lib/libc.so.6 -> libc-2.2.4.so -rwxr-xr-x 2 root root 1282588 Sep 4 2001 /lib/libc-2.2.4.so -rw-r--r-- 1 root root 27304836 Sep 4 2001 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Sep 4 2001 /usr/lib/libc.so Configure command: ./configure '--disable-shared' '--with-mysqld-ldflags=-all-static' '--with-client-ldflags=-all-static' '--without-berkeley-db' '--without-innodb' '--enable-assembler' '--enable-local-infile' '--with-mysqld-user=mysql' '--with-unix-socket-path=/var/lib/mysql/mysql.sock' '--prefix=/' '--with-extra-charsets=complex' '--exec-prefix=/usr' '--libexecdir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--localstatedir=/var/lib/mysql' '--infodir=/usr/share/info' '--includedir=/usr/include' '--mandir=/usr/share/man' '--with-comment=Official MySQL RPM' 'CC=gcc' 'CFLAGS=-O6 -fno-omit-frame-pointer -mpentium' 'CXXFLAGS=-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' '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