My mysql server just died after ~1 months of continous run. It's a vanilla mysql 4.0.17 downloaded in binary form from mysql.com. The underlying HW&SW was an athlon-xp cpu, vanilla 2.4.23 kernel, debian sid. It is proved to be stable otherwise.
I've included the error log. Sorry for sending here, i think it's a mailing list, but this is what innodb told me to do in its debug message. The stack trace is: 0x8070610 handle_segfault + 420 0x8289628 pthread_sighandler + 184 0x823076c mem_area_free + 548 0x822f5c1 mem_heap_block_free + 385 0x8171530 btr_cur_optimistic_update + 4664 0x8145b6e row_upd_clust_rec + 82 0x8146384 row_upd_clust_step + 1124 0x81464aa row_upd + 106 0x8146712 row_upd_step + 330 0x812f3fd row_update_for_mysql + 777 0x80cb13d update_row__11ha_innobasePCcPc + 589 0x80a6aed mysql_update__FP3THDP13st_table_listRt4List1Z4ItemT2P4ItemP8st_orderUl15enum_duplicates + 2405 0x807c429 mysql_execute_command__Fv + 6229 0x807eb8a mysql_parse__FP3THDPcUi + 146 0x807a0e3 dispatch_command__F19enum_server_commandP3THDPcUi + 1435 0x8079b3d do_command__FP3THD + 165 0x8079329 handle_one_connection + 641 0x8286ddc pthread_start_thread + 220 0x82bc5ba thread_start + 4
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]