>Description:
MySQL core dumps with the following trace:
0x807b83f handle_segfault__Fi + 383
0x812bdca pthread_sighandler + 154
0x80f5e3f _mi_key_cmp + 575
0x80f86e0 _mi_seq_search + 200
0x8100872 w_search + 194
0x810099b w_search + 491
0x81013dc _mi_ck_write + 88
0x81003c4 mi_write + 548
0x80c69e9 write_row__9ha_myisamPc + 89
0x80a7cd2 write_record__FP8st_tableP12st_copy_info + 514
0x80a75ff
mysql_insert__FP3THDP13st_table_listRt4List1Z4ItemRt4List1Zt4List1Z4Item15enum_duplicates13thr_lock_type
+ 1055
0x808309b mysql_execute_command__Fv + 5103
0x8085d96 mysql_parse__FP3THDPcUi + 210
0x80813bd do_command__FP3THD + 1261
0x80808bc handle_one_connection__FPv + 548
AND
0x807b83f handle_segfault__Fi + 383
0x812bdca pthread_sighandler + 154
0x812d482 pthread_rwlock_rdlock + 178
0x80f4c0a mi_rnext + 122
0x80c654b index_next__9ha_myisamPc + 39
0x80be904 get_next__12QUICK_SELECT + 76
0x80c0cb3 rr_quick__FP14st_read_record + 23
0x80a0eb9 sub_select__FP4JOINP13st_join_tableb + 253
0x80a0bf3 do_select__FP4JOINPt4List1Z4ItemP8st_tableP9Procedure + 395
0x8099b37
mysql_select__FP3THDP13st_table_listRt4List1Z4ItemP4ItemRt4List1Z15Ite
m_func_matchP8st_orderT5P4ItemT5UiP13select_result + 4231
0x80825dd mysql_execute_command__Fv + 2353
0x8085d96 mysql_parse__FP3THDPcUi + 210
0x80813bd do_command__FP3THD + 1261
0x80808bc handle_one_connection__FPv + 548
>How-To-Repeat:
The last binlog entry for the thread that failed in the second crash was:
#011117 12:33:39 server id 1 Query thread_id=63971 exec_time=131 error_c\
ode=0
SET TIMESTAMP=1006029219;
# /home/services/tias/cgi-bin/gifts.fcgi (adams.tias.com 12593)
CREATE TEMPORARY TABLE rn1
SELECT item.itemKey, itemNo,title,price, item.description, account.accountKey,
relativeUrl, account.storeid
FROM inventory.item, account.account, inventory.thumbs
WHERE account.groupKey=1
AND thumbs.itemKey=item.itemKey
AND account.active=1
AND account.storeid=item.storeid
AND status="forsale"
AND ((title IS NOT NULL) OR (LENGTH(item.description)>10))
AND relativeUrl IS NOT NULL
AND price BETWEEN 5 AND 9.99
ORDER BY RAND()
LIMIT 500
;
>Fix:
>Submitter-Id: <submitter ID>
>Originator: Mike Wexler
>Organization:
TIAS.COM
>MySQL support: license
>Synopsis: mysqld dumps core
>Severity: critical
>Priority: high
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.44 (Official MySQL RPM)
>Environment:
System: Linux spode 2.2.19-6.2.7 #2 SMP Tue Jul 17 14:41:17 PDT 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/egcs-2.91.66/specs
gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
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 Dec 26 2000 /lib/libc.so.6 -> libc-2.1.3.so
-rwxr-xr-x 1 root root 4101836 Jan 15 2001 /lib/libc-2.1.3.so
-rw-r--r-- 1 root root 20273324 Jan 15 2001 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Jan 15 2001 /usr/lib/libc.so
lrwxrwxrwx 1 root root 10 Jun 29 16:32 /usr/lib/libc-client.a ->
c-client.a
Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static
--with-client-ldflags=-all-static --without-berkeley-db --without-innodb
--enable-assembler --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/info --includedir=/usr/include --mandir=/usr/man
'--with-comment=Official MySQL RPM'
Perl: This is perl, version 5.005_03 built for i386-linux
---------------------------------------------------------------------
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
