110327 7:45:20 InnoDB: Assertion failure in thread 904820496 in file buf0buf.c line 3296 InnoDB: Failing assertion: !block->page.file_page_was_freed InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html InnoDB: about forcing recovery. ==14947== ==14947== Process terminating with default action of signal 6 (SIGABRT) ==14947== at 0x30E14329A5: raise (raise.c:64) ==14947== by 0x30E1434184: abort (abort.c:92) ==14947== by 0xAA9130: buf_page_get_gen (buf0buf.c:3296) ==14947== by 0xA8CCE0: btr_estimate_n_rows_in_range_on_level (btr0cur.c:3268) ==14947== by 0xA8D297: btr_estimate_n_rows_in_range (btr0cur.c:3487) ==14947== by 0x9E6F4F: ha_innobase::records_in_range(unsigned int, st_key_range*, st_key_range*) (ha_innodb.cc:7995) ==14947== by 0x591745: handler::multi_range_read_info_const(unsigned int, st_range_seq_if*, void*, unsigned int, unsigned int*, unsigned int*, COST_VECT*) (handler.cc:4534) ==14947== by 0x592AD9: DsMrr_impl::dsmrr_info_const(unsigned int, st_range_seq_if*, void*, unsigned int, unsigned int*, unsigned int*, COST_VECT*) (handler.cc:5096) ==14947== by 0x9EDB78: ha_innobase::multi_range_read_info_const(unsigned int, st_range_seq_if*, void*, unsigned int, unsigned int*, unsigned int*, COST_VECT*) (ha_innodb.cc:12734) ==14947== by 0x859FA9: check_quick_select(PARAM*, unsigned int, bool, SEL_ARG*, bool, unsigned int*, unsigned int*, COST_VECT*) (opt_range.cc:7850) ==14947== by 0x85274A: get_key_scans_params(PARAM*, SEL_TREE*, bool, bool, double) (opt_range.cc:4945) ==14947== by 0x84D108: SQL_SELECT::test_quick_select(THD*, Bitmap<64u>, unsigned long long, unsigned long long, bool, bool) (opt_range.cc:2379) ==14947== by 0x796541: SQL_SELECT::check_quick(THD*, bool, unsigned long long) (opt_range.h:924) ==14947== by 0x790EAD: mysql_update(THD*, TABLE_LIST*, List&, List&, Item*, unsigned int, st_order*, unsigned long long, enum_duplicates, bool, unsigned long long*, unsigned long long*) (sql_update.cc:406) ==14947== by 0x6EC8AB: mysql_execute_command(THD*) (sql_parse.cc:2762) ==14947== by 0x6F44C9: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:5597) ==14947== by 0x6E864B: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1093) ==14947== by 0x6E785E: do_command(THD*) (sql_parse.cc:815) ==14947== by 0x6C18DD: do_handle_one_connection(THD*) (sql_connect.cc:771) ==14947== by 0x6C146E: handle_one_connection (sql_connect.cc:707) ==14947== by 0x30E1807760: start_thread (pthread_create.c:301) ==14947== by 0x35EE770F: ??? ==14947== ==14947== ---- Attach to debugger ? --- [Return/N/n/Y/y/C/c] ---- y ==14947== starting debugger with cmd: /usr/bin/gdb -nw /proc/16411/fd/10000 16411 GNU gdb (GDB) Fedora (7.1-18.fc13) Copyright (C) 2010 Free Software Foundation, Inc. License GPLv3+: GNU GPL version 3 or later This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law. Type "show copying" and "show warranty" for details. This GDB was configured as "x86_64-redhat-linux-gnu". For bug reporting instructions, please see: ... Reading symbols from /proc/16411/fd/10000...done. Attaching to program: /proc/16411/fd/10000, process 16411 Reading symbols from /usr/lib64/valgrind/vgpreload_core-amd64-linux.so...done. Loaded symbols for /usr/lib64/valgrind/vgpreload_core-amd64-linux.so Reading symbols from /usr/lib64/valgrind/vgpreload_memcheck-amd64-linux.so...done. Loaded symbols for /usr/lib64/valgrind/vgpreload_memcheck-amd64-linux.so Reading symbols from /lib64/libpthread.so.0...Reading symbols from /usr/lib/debug/lib64/libpthread-2.12.so.debug...done. [Thread debugging using libthread_db enabled] done. Loaded symbols for /lib64/libpthread.so.0 Reading symbols from /lib64/libz.so.1...Reading symbols from /usr/lib/debug/lib64/libz.so.1.2.3.debug...done. done. Loaded symbols for /lib64/libz.so.1 Reading symbols from /lib64/libm.so.6...Reading symbols from /usr/lib/debug/lib64/libm-2.12.so.debug...done. done. Loaded symbols for /lib64/libm.so.6 Reading symbols from /lib64/librt.so.1...Reading symbols from /usr/lib/debug/lib64/librt-2.12.so.debug...done. done. Loaded symbols for /lib64/librt.so.1 Reading symbols from /lib64/libcrypt.so.1...Reading symbols from /usr/lib/debug/lib64/libcrypt-2.12.so.debug...done. done. Loaded symbols for /lib64/libcrypt.so.1 Reading symbols from /lib64/libdl.so.2...Reading symbols from /usr/lib/debug/lib64/libdl-2.12.so.debug...done. done. Loaded symbols for /lib64/libdl.so.2 Reading symbols from /lib64/libc.so.6...Reading symbols from /usr/lib/debug/lib64/libc-2.12.so.debug...done. done. Loaded symbols for /lib64/libc.so.6 Reading symbols from /lib64/ld-linux-x86-64.so.2...Reading symbols from /usr/lib/debug/lib64/ld-2.12.so.debug...done. done. Loaded symbols for /lib64/ld-linux-x86-64.so.2 Reading symbols from /lib64/libfreebl3.so...Reading symbols from /usr/lib/debug/lib64/libfreebl3.so.debug...done. done. Loaded symbols for /lib64/libfreebl3.so Reading symbols from /lib64/libgcc_s.so.1...Reading symbols from /usr/lib/debug/lib64/libgcc_s-4.4.4-20100630.so.1.debug...done. done. Loaded symbols for /lib64/libgcc_s.so.1 0x00000030e14329a5 in raise (sig=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:64 64 return INLINE_SYSCALL (tgkill, 3, pid, selftid, sig); (gdb) bt #0 0x00000030e14329a5 in raise (sig=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:64 #1 0x00000030e1434185 in abort () at abort.c:92 #2 0x0000000000aa9131 in buf_page_get_gen (space=0, zip_size=0, offset=825, rw_latch=1, guess=0x0, mode=10, file=0xd6b390 "/home/sbester/build/bzr/mysql-trunk/storage/innobase/btr/btr0cur.c", line=3269, mtr=0x35edd710) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/buf/buf0buf.c:3296 #3 0x0000000000a8cce1 in btr_estimate_n_rows_in_range_on_level (index=0x2a452888, slot1=0x35ee0150, slot2=0x35ede210, n_rows_on_prev_level=272, is_n_rows_exact=0x35ede158) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/btr/btr0cur.c:3268 #4 0x0000000000a8d298 in btr_estimate_n_rows_in_range (index=0x2a452888, tuple1=0x300a8898, mode1=2, tuple2=0x300a88e8, mode2=1) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/btr/btr0cur.c:3487 #5 0x00000000009e6f50 in ha_innobase::records_in_range (this=0x2a493c50, keynr=0, min_key=0x0, max_key=0x35ee21e0) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/handler/ha_innodb.cc:7995 #6 0x0000000000591746 in handler::multi_range_read_info_const (this=0x2a493c50, keyno=0, seq=0x35ee2640, seq_init_param=0x35ee2380, n_ranges_arg=0, bufsz=0x35ee22b0, flags=0x35ee22b4, cost=0x35ee26d0) at /home/sbester/build/bzr/mysql-trunk/sql/handler.cc:4534 #7 0x0000000000592ada in DsMrr_impl::dsmrr_info_const (this=0x2a493ed8, keyno=0, seq=0x35ee2640, seq_init_param=0x35ee2380, n_ranges=0, bufsz=0x35ee272c, flags=0x35ee2730, cost=0x35ee26d0) at /home/sbester/build/bzr/mysql-trunk/sql/handler.cc:5096 #8 0x00000000009edb79 in ha_innobase::multi_range_read_info_const (this=0x2a493c50, keyno=0, seq=0x35ee2640, seq_init_param=0x35ee2380, n_ranges=0, bufsz=0x35ee272c, flags=0x35ee2730, cost=0x35ee26d0) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/handler/ha_innodb.cc:12734 #9 0x0000000000859faa in check_quick_select (param=0x35ee27e0, idx=0, index_only=false, tree=0x300a85c0, update_tbl_stats=true, mrr_flags=0x35ee2730, bufsize=0x35ee272c, cost=0x35ee26d0) at /home/sbester/build/bzr/mysql-trunk/sql/opt_range.cc:7850 #10 0x000000000085274b in get_key_scans_params (param=0x35ee27e0, tree=0x300a8320, index_read_must_be_used=false, update_tbl_stats=true, read_time=1023.2) at /home/sbester/build/bzr/mysql-trunk/sql/opt_range.cc:4945 #11 0x000000000084d109 in SQL_SELECT::test_quick_select (this=0x3038a870, thd=0x30bc3540, keys_to_use=..., prev_tables=0, limit=1, force_quick_range=false, ordered_output=false) at /home/sbester/build/bzr/mysql-trunk/sql/opt_range.cc:2379 #12 0x0000000000796542 in SQL_SELECT::check_quick (this=0x3038a870, thd=0x30bc3540, force_quick_range=false, limit=1) at /home/sbester/build/bzr/mysql-trunk/sql/opt_range.h:924 #13 0x0000000000790eae in mysql_update (thd=0x30bc3540, table_list=0x3038a110, fields=..., values=..., conds=0x30ea29f0, order_num=0, order=0x0, limit=1, handle_duplicates=DUP_ERROR, ignore=true, found_return=0x35ee5bc8, updated_return=0x35ee5bc0) at /home/sbester/build/bzr/mysql-trunk/sql/sql_update.cc:406 #14 0x00000000006ec8ac in mysql_execute_command (thd=0x30bc3540) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:2762 #15 0x00000000006f44ca in mysql_parse (thd=0x30bc3540, rawbuf=0x30388700 "update ignore `blobtest` set `data`='xmsifgvfyqpxjllohelzaxrtluhetxthyxffpvttpzerrmyrdqhayqhcjtwbcweugiqcxueezmfmhfxwpnzroiicuoyfuhjsluehwuwycmwygeveugrwcrofmxjmefcfjinscqenhqjibrdasbaiajjwnakkkiuepyivjfcutxpbcijfrhifxtkmakhppvtnivhiybtnkpzilwxyihksxkluzzwsqkttdllcjlnsiuhgfytofqnkeyyhkjsanhysixcbfqwmkigkulelorcgldauohyfybvdaqxmixyirtpwjnaqwfwvoikxebkrvttbrzgozcrdommoeykipixvykbamhfbpekylrobibfbanrjgshqltbjzmkqedczuhvbqpcegsesrzbqyakhnzzkbpwqtnpzjtgztgifunnngrhqmlqqapddywinwdamhpexjbscxeolalxhdiqpnpdlyxglnizqstvmvtfhwyxhhoviobmyohoetpvxwiqoxltmtojrjxiorwzcjhatidwpuzahckflygggbiadmlsuqsyavylbpdbuncutgkfopnhwwltpjamuloarswmcznlqupxwokqagsgorwnxfbcwiwulihszgatdddbbduqxztukceugpxfxxyqzjukjnzaeafiwdodzltkqwgucxlkjgylnpkzvflsecjsngogztzdocljrtbqhvqwzqsshuozwuprtwcehzeczivowjmtjldnsqutznelvrbliqaumydvkyduaifnbrclzbidtiimsttbzruwuvlcdlftlznvdnjrqbqrcekyxbwesiacityqevflkfsovrqwzgzfimpqoizklyuzxokaxllpqgfvbvokmvklevtentinhvovuklizugnmrjiwmxygpmsouahcryamefgoplvpjzddbvzmnptmfbmnbxjvygunmtznvtzemmefyldtckojbaeixogxjul"..., length=6492, parser_state=0x35ee6540) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:5597 #16 0x00000000006e864c in dispatch_command (command=COM_QUERY, thd=0x30bc3540, packet=0x300267b1 "update ignore `blobtest` set `data`='xmsifgvfyqpxjllohelzaxrtluhetxthyxffpvttpzerrmyrdqhayqhcjtwbcweugiqcxueezmfmhfxwpnzroiicuoyfuhjsluehwuwycmwygeveugrwcrofmxjmefcfjinscqenhqjibrdasbaiajjwnakkkiuepyivjfcutxpbcijfrhifxtkmakhppvtnivhiybtnkpzilwxyihksxkluzzwsqkttdllcjlnsiuhgfytofqnkeyyhkjsanhysixcbfqwmkigkulelorcgldauohyfybvdaqxmixyirtpwjnaqwfwvoikxebkrvttbrzgozcrdommoeykipixvykbamhfbpekylrobibfbanrjgshqltbjzmkqedczuhvbqpcegsesrzbqyakhnzzkbpwqtnpzjtgztgifunnngrhqmlqqapddywinwdamhpexjbscxeolalxhdiqpnpdlyxglnizqstvmvtfhwyxhhoviobmyohoetpvxwiqoxltmtojrjxiorwzcjhatidwpuzahckflygggbiadmlsuqsyavylbpdbuncutgkfopnhwwltpjamuloarswmcznlqupxwokqagsgorwnxfbcwiwulihszgatdddbbduqxztukceugpxfxxyqzjukjnzaeafiwdodzltkqwgucxlkjgylnpkzvflsecjsngogztzdocljrtbqhvqwzqsshuozwuprtwcehzeczivowjmtjldnsqutznelvrbliqaumydvkyduaifnbrclzbidtiimsttbzruwuvlcdlftlznvdnjrqbqrcekyxbwesiacityqevflkfsovrqwzgzfimpqoizklyuzxokaxllpqgfvbvokmvklevtentinhvovuklizugnmrjiwmxygpmsouahcryamefgoplvpjzddbvzmnptmfbmnbxjvygunmtznvtzemmefyldtckojbaeixogxjul"..., packet_length=6492) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:1093 #17 0x00000000006e785f in do_command (thd=0x30bc3540) at /home/sbester/build/bzr/mysql-trunk/sql/sql_parse.cc:815 #18 0x00000000006c18de in do_handle_one_connection (thd_arg=0x30bc3540) at /home/sbester/build/bzr/mysql-trunk/sql/sql_connect.cc:771 #19 0x00000000006c146f in handle_one_connection (arg=0x30bc3540) at /home/sbester/build/bzr/mysql-trunk/sql/sql_connect.cc:707 #20 0x00000030e1807761 in start_thread (arg=0x35ee7710) at pthread_create.c:301 #21 0x00000030e14e14ed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 (gdb) (gdb) frame 2 #2 0x0000000000aa9131 in buf_page_get_gen (space=0, zip_size=0, offset=825, rw_latch=1, guess=0x0, mode=10, file=0xd6b390 "/home/sbester/build/bzr/mysql-trunk/storage/innobase/btr/btr0cur.c", line=3269, mtr=0x35edd710) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/buf/buf0buf.c:3296 3296 ut_a(!block->page.file_page_was_freed); (gdb) frame 3 #3 0x0000000000a8cce1 in btr_estimate_n_rows_in_range_on_level (index=0x2a452888, slot1=0x35ee0150, slot2=0x35ede210, n_rows_on_prev_level=272, is_n_rows_exact=0x35ede158) at /home/sbester/build/bzr/mysql-trunk/storage/innobase/btr/btr0cur.c:3268 3268 block = buf_page_get(space, zip_size, page_no, RW_S_LATCH, (gdb)