MySQL 5.0.18 crashes
"Erik Dunder" <[email protected]> Sat, 4 Feb 2006 12:30:54 +0100
| Newsgroups | gmane.comp.db.mysql.bugs |
|---|---|
| Message-ID | <[email protected]> |
I need a little help with MySQL 5.0.18. Its been running for about a week now and it has crashed every day, serveral times within a few hours just to run fine the rest of the day etc.. I have checked the MyISAM tables serveraltimes and run the testscripts thats in the package. I have also activated log and tried to run the ~10 last queries without any problem. The stacktrace is almost identical each crash and the first is a segfault?! if it is what is causing it? Hera are the last 2 stacktraces: ========================================================= 0x81536e8 handle_segfault + 356 0x4ff3ac45 _end + 1201650805 0x8144541 _ZNK12Field_string4typeEv + 13 0x81a4689 _Z18create_ref_for_keyP4JOINP13st_join_tableP8keyuse_ty + 717 0x81a4326 _Z20get_best_combinationP4JOIN + 306 0x819ad18 _Z20make_join_statisticsP4JOINP13st_table_listP4ItemP16st_dynamic_array + 2092 0x8191fb6 _ZN4JOIN8optimizeEv + 750 0x8195226 _Z12mysql_selectP3THDPPP4ItemP13st_table_listjR4ListIS1_ES2_jP8st_orderSB_S2_SB_mP13select_resultP18st_select_lex_unitP13st_sel + 130 0x819135e _Z13handle_selectP3THDP6st_lexP13select_resultm + 234 0x8167301 _Z21mysql_execute_commandP3THD + 585 0x816e176 _Z11mysql_parseP3THDPcj + 306 0x8165c3e _Z16dispatch_command19enum_server_commandP3THDPcj + 1178 0x8165769 _Z10do_commandP3THD + 129 0x8164c71 handle_one_connection + 609 0x4ff34ca3 _end + 1201626323 0x500c9c97 _end + 1203285191 ========================================================= 0x81536e8 handle_segfault + 356 0x435aac45 _end + 990297205 0x8144541 _ZNK12Field_string4typeEv + 13 0x81a4689 _Z18create_ref_for_keyP4JOINP13st_join_tableP8keyuse_ty + 717 0x81a4326 _Z20get_best_combinationP4JOIN + 306 0x819ad18 _Z20make_join_statisticsP4JOINP13st_table_listP4ItemP16st_dynamic_array + 2092 0x8191fb6 _ZN4JOIN8optimizeEv + 750 0x8195226 _Z12mysql_selectP3THDPPP4ItemP13st_table_listjR4ListIS1_ES2_jP8st_orderSB_S2_SB_mP13select_resultP18st_select_lex_unitP13st_sel + 130 0x819135e _Z13handle_selectP3THDP6st_lexP13select_resultm + 234 0x8167301 _Z21mysql_execute_commandP3THD + 585 0x816e176 _Z11mysql_parseP3THDPcj + 306 0x8165c3e _Z16dispatch_command19enum_server_commandP3THDPcj + 1178 0x8165769 _Z10do_commandP3THD + 129 0x8164c71 handle_one_connection + 609 0x435a4ca3 _end + 990272723 0x43739c97 _end + 991931591 ========================================================= /Erik