Hi,
If you're using 4.0.20, jump to 4.0.21 :
"Fixed crash in MATCH ... AGAINST() on a phrase search operator with a missing closing double quote."
Regards, Jocelyn
> 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]
>
>
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
