mysql sporadic crashes in find_item_in_list

2002-12-22 Thread Paul P Komkoff Jr
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 +

mysql sporadic crashes in find_item_in_list

2002-12-21 Thread Paul P Komkoff Jr
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 +

More info on mysql sporadic crashes

2002-12-21 Thread Paul P Komkoff Jr
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

mysql sporadic crashes in find_item_in_list

2002-12-21 Thread Paul P Komkoff Jr
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 +

mysql sporadic crashes in find_item_in_list

2002-12-21 Thread Paul P Komkoff Jr
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 +