Hi! This is a bug that is fixed in upcoming 4.0.21. See below for a workaround.
" If you configure innodb_additional_mem_pool_size so small that InnoDB memory allocation spills over from it, then every 4 billionth spill may cause memory corruption. A symptom is a printout like below in the `.err' log. The workaround is to make innodb_additional_mem_pool_size big enough to hold all memory allocation. Use SHOW INNODB STATUS to determine that there is plenty of free space available in the additional mem pool, and the total allocated memory stays rather constant. InnoDB: Error: Mem area size is 0. Possibly a memory overrun of the InnoDB: previous allocated area! InnoDB: Apparent memory corruption: mem dump len 500; hex " Best regards, Heikki ................... List:MySQL General Discussion« Previous MessageNext Message » From:Horváth Ágoston JánosDate:June 1 2004 4:10pm Subject:[BUG] Error: Mem area size is 0. Possibly a memory overrun 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]
