Description:
Sometimes my hosting mysql server segfaulting
typical backtrace follows
0x80be1f8 handle_segfault + 424
0x4011e8d5 _end + 938550201
0x80dbf61 find_item_in_list__FP4ItemRt4List1Z4Item + 417
0x80ec0b0 find_order_in_list__FP3THDP13st_table_listP8st_orderRt4List1Z4ItemT3 +
Description:
Sometimes my hosting mysql server segfaulting
typical backtrace follows
0x80be1f8 handle_segfault + 424
0x4011e8d5 _end + 938550201
0x80dbf61 find_item_in_list__FP4ItemRt4List1Z4Item + 417
0x80ec0b0 find_order_in_list__FP3THDP13st_table_listP8st_orderRt4List1Z4ItemT3 +
I tracked down the bug
I have one table with BLOB field in it
Then I execute queries like
SELECT * FROM _search WHERE (LOWER(keywords) LIKE LOWER('% blabla %'))
here, keywords is a blob fields
when (LOWER(keywords) LIKE LOWER('% blabla %')) is true, mysql dies
hope this helps
--
Paul P
Description:
Sometimes my hosting mysql server segfaulting
typical backtrace follows
0x80be1f8 handle_segfault + 424
0x4011e8d5 _end + 938550201
0x80dbf61 find_item_in_list__FP4ItemRt4List1Z4Item + 417
0x80ec0b0 find_order_in_list__FP3THDP13st_table_listP8st_orderRt4List1Z4ItemT3 +
Description:
Sometimes my hosting mysql server segfaulting
typical backtrace follows
0x80be1f8 handle_segfault + 424
0x4011e8d5 _end + 938550201
0x80dbf61 find_item_in_list__FP4ItemRt4List1Z4Item + 417
0x80ec0b0 find_order_in_list__FP3THDP13st_table_listP8st_orderRt4List1Z4ItemT3 +