Mauricio, please send the FULL .err log to me. Do not cut anything off.
[EMAIL PROTECTED] Best regards, Heikki Innobase Oy InnoDB - transactions, row level locking, and foreign keys for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php Order MySQL support from http://www.mysql.com/support/index.html .................... Hi, I've experienced a hang after running a query wich is run usually 2 to 3 times a day without a problem till now. This is what the error log reports nnoDB: Thread 4784139 stopped in file btr0pcur.c line 205 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, fp=0xbe3fddb8, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x8108af7 0x4014c895 0x8280a88 0x82630ba 0x82694eb 0x82697a1 0x82818f0 0x8282495 0x828267a 0x826b7bc 0x817abf3 0x814edf1 0x814ef81 0x81401e2 0x8137049 0x8137585 0x814e061 0x8118164 0x811b121 0x811552f 0x8114ec2 0x8114637 0x40146c60 0x402e9b77 New value of fp=(nil) failed sanity check, terminating stack trace! Also have part of the query in the log. and some other warnings about the memory bee used acording to the defined variables. I've used resolve_stack_dump -s /usr/lib/mysql/mysqld-max.sym -n mysqld.stack as instructed in the manual, with the following result 0x8108af7 handle_segfault + 423 0x4014c895 _end + 934924901 0x8280a88 row_upd_build_sec_rec_difference_binary + 408 0x82630ba row_ins_sec_index_entry_by_modify + 90 0x82694eb row_ins_index_entry_low + 2859 0x82697a1 row_ins_index_entry + 65 0x82818f0 row_upd_sec_index_entry + 848 0x8282495 row_upd + 197 0x828267a row_upd_step + 282 0x826b7bc row_update_for_mysql + 700 0x817abf3 update_row__11ha_innobasePCcPc + 291 0x814edf1 do_updates__12multi_updateb + 465 0x814ef81 send_eof__12multi_update + 49 0x81401e2 do_select__FP4JOINPt4List1Z4ItemP8st_tableP9Procedure + 530 0x8137049 exec__4JOIN + 4185 0x8137585 mysql_select__FP3THDPPP4ItemP13st_table_listUiRt4List1Z4ItemP4ItemUiP8st_ord erT7T5T7Ul \ P13select_resultP18st_select_lex_unitP13s + 837 0x814e061 mysql_multi_update__FP3THDP13st_table_listPt4List1Z4ItemT2P4ItemUl15enum_dup licatesP18 \ st_select_lex_unitP13st_select_lex + 369 0x8118164 mysql_execute_command__FP3THD + \ 7780 0x811b121 mysql_parse__FP3THDPcUi + 177 0x811552f dispatch_command__F19enum_server_commandP3THDPcUi + 1631 0x8114ec2 do_command__FP3THD + 162 0x8114637 handle_one_connection + 551 0x40146c60 _end + 934901296 0x402e9b77 _end + 936617287 Watching those entries in the error log I cant figure why is this happening. Can anybody give me a hint? Thank you Mauricio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
