Sorry, I forgot to include the version of mysql. I am running 4.0.16 from the binary archive(tar.gz) on the mysql.com download page. I did have the same problem on 4.0.15 and upgraded yesterday to 4.0.16.
I was running 4.0.15 since it came out before this problem suddenly reared its ugly head yesterday. If anyone has any input on the crash I am dealing with I will be eternally grateful. Ian Rubado -----Original Message----- From: Ian Rubado [mailto:[EMAIL PROTECTED] Sent: Thursday, November 20, 2003 5:07 PM To: [EMAIL PROTECTED] Subject: suddenly started crashing Since yesterday I have noticed that mysql keeps crashing on me. At first I thought it was related to RAM, so I replaced the RAM. Problem persists, so now I am perplexed. HELP!! I am running a dual XEON 2.6ghz with 2GB ram. Linux 2.4.18-6mdkenterprise #1 SMP Fri Mar 15 02:28:20 CET 2002 i686 unknown All the db apps have been running for MONTHS and had no problems until yesterday. The query pointer in the .err log did not point out anything. Here is an output from my stack trace on two different crashes both occured today: 1st Crash: ----------------------------------------------------------- 0x8070670 handle_segfault + 420 0x8288b08 pthread_sighandler + 184 0x826c1b9 find_key_block + 369 0x826bd2e key_cache_read + 134 0x824c16a _mi_fetch_keypage + 58 0x8253f2c w_search + 96 0x8254093 w_search + 455 0x8254093 w_search + 455 0x8254093 w_search + 455 0x8254093 w_search + 455 0x8253d82 _mi_ck_write_btree + 142 0x8253ce9 _mi_ck_write + 65 0x825392f mi_write + 591 0x80c521d write_row__9ha_myisamPc + 101 0x80a3c25 write_record__FP8st_tableP12st_copy_info + 513 0x80a3544 mysql_insert__FP3THDP13st_table_listRt4List1Z4ItemRt4List1Zt4List1Z4Item15en um_duplicates + 1168 0x807c47a mysql_execute_command__Fv + 6566 0x807ea75 mysql_parse__FP3THDPcUi + 153 0x8079fe3 dispatch_command__F19enum_server_commandP3THDPcUi + 1435 0x8079a3d do_command__FP3THD + 165 0x8079229 handle_one_connection + 641 0x82862bc pthread_start_thread + 220 0x82bba7a thread_start + 4 2nd Crash: -------------------------------------------------------- 0x8070670 handle_segfault + 420 0x8288b08 pthread_sighandler + 184 0x80a36e2 mysql_insert__FP3THDP13st_table_listRt4List1Z4ItemRt4List1Zt4List1Z4Item15en um_duplicates + 1582 0x807c51f mysql_execute_command__Fv + 6731 0x807ea75 mysql_parse__FP3THDPcUi + 153 0x8079fe3 dispatch_command__F19enum_server_commandP3THDPcUi + 1435 0x8079a3d do_command__FP3THD + 165 0x8079229 handle_one_connection + 641 0x82862bc pthread_start_thread + 220 0x82bba7a thread_start + 4 ------------------------------------------------------- Ian Rubado 321.956.0019 OFFICE 321.956.0048 FAX 321.960.4264 GSM -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]