Linux systems normally run with file locking off. With NFS shares, this can allow the server to read the index file as it is being updated. This can cause the crash make sure you don't use --skip-locking.
root wrote:
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>Mikel Tidwell, Case's Ladder
Originator: root
Organization:
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
--------------------------------------------------------------------- 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