On Saturday 17 November 2001 03:20 pm, Mike Wexler wrote: > >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)
Mike: You have enough info to create a repeatable bug report. Please copy the tables involved in the trouble query to a test machine and try it there. One thing was not clear, though. you had two traces, but only one query. Also, you should check the query that is listed in the coredump handler message - that is usually more reliable than simply the last query in the log. -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA <___/ --------------------------------------------------------------------- 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
