Hi,
Our mysqld segfaults from time to time on our system. We don't see any other programs segfaulting, and therefore suspect a bug in mysql.
I enclose a resolved stacktrace, and any other system information that might be helpful. I hope someone has any suggestions on what to do in this matter. Should we file a mysql bug-report?
Please advise. I am happy to provide any additional information that you should find necesarry to resolve the issue.
Sincerely, Anders Schau Knatten Norway
OS: Debian GNU/Linux Kernel: Linux 2.6.8-rc1 #4 SMP Fri Jul 16 18:03:51 CEST 2004 x86_64 unknown CPU: Dual AMD Opteron 250
Resolved stack-trace:
0x80eb61f handle_segfault + 423
0x5567ff54 _end + 1294348216
0x832bd1a ft_init_boolean_search + 586
0x832bed7 ft_init_boolean_search + 1031
0x832c57d ft_boolean_find_relevance + 513
0x832c303 ft_boolean_read_next + 835
0x814a7cc ft_read__9ha_myisamPc + 52
0x812037f error_if_full_join__FP4JOIN + 1791
0x811a496 create_myisam_from_heap__FP3THDP8st_tableP15TMP_TABLE_PARAMib + 1870
0x811a256 create_myisam_from_heap__FP3THDP8st_tableP15TMP_TABLE_PARAMib + 1294
0x8112dd8 mysql_select__FP3THDP13st_table_listRt4List1Z4ItemP4ItemP8st_orderT4T3T4UlP13select_result + 7000
0x811f963 handle_select__FP3THDP6st_lexP13select_result + 95
0x80f7d7e mysql_execute_command__Fv + 1010
0x80fb438 mysql_parse__FP3THDPcUi + 568
0x80f6ed1 dispatch_command__F19enum_server_commandP3THDPcUi + 1469
0x80fcadd do_command__FP3THD + 153
0x80f6187 handle_one_connection + 639
0x5567d0ba _end + 1294336286
0x55814d6a _end + 1296006606
Additional info from syslog:
Sep 14 03:14:05 mysqld[21855]: Cannot determine thread, fp=0xff3feb58, backtrace may not be correct.
Sep 14 03:14:05 mysqld[21855]: Stack range sanity check OK, backtrace follows:
(...)
Sep 14 03:14:05 mysqld[21855]: New value of fp=(nil) failed sanity check, terminating stack trace!
(...)
Sep 14 03:14:05 mysqld[21855]: Trying to get some variables.
Sep 14 03:14:05 mysqld[21855]: Some pointers may be invalid and cause the dump to abort...
Sep 14 03:14:05 mysqld[21855]: thd->query at 0x8599938 = SELECT t.tid^M
Sep 14 03:14:05 mysqld[21855]: ^I^I^I^I^I^I^IFROM ippbe_topics t^M
Sep 14 03:14:05 mysqld[21855]: ^I^I^I^I^I^I^IWHERE t.last_post > 1092531929 AND t.forum_id IN (27,190,89,11,12,13,14,15,16,17,18,19,20,23,24,25,26,28,87,30,31,32,33,35,37,38,40,41,46,44,48,51,53,
54,57,58,60,61,62,63,64,75,65,66,67,82,69,81,72,73,76,78,79,80,83,84,88,86,91,108,94,95,96,131,98,132,130,101,133,103,104,107,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,
128,129,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,156,155,157,158,159,162,161,160,184,189,179,178,182,181,175,169,172,171,174,177,176,185,183,180,187,188,191,19
2,193,200,194,195,196,197,198,199,203,202,209,206,208,210,212,211,213,215,214,216,217,219,218)^M
Sep 14 03:14:05 mysqld[21855]: ^I^I^I^I^I^I^I AND t.approved=1 AND MATCH(title) AGAINST ('"resette' IN BOOLEAN MODE)
Sep 14 03:14:05 mysqld[21855]: thd->thread_id=127169
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
