LP:1004910 - Failing assertion: block->page.space == page_get_space_id(page_align(ptr))

Percona XtraDB (http://www.percona.com) 1.1.8-26.0 started

InnoDB: Assertion failure in thread 140213844621056 in file buf0buf.c line 2317

InnoDB: Failing assertion: block->page.space == page_get_space_id(page_align(ptr))

#5  0x00007f86239eeb0b in __GI_abort () at abort.c:92

#6  0x0000000000ae1dc2 in buf_block_align_instance (buf_pool=0x3949628, ptr=0x7f8618c14000 "") at storage/xtradb/buf/buf0buf.c:2316

#7  0x0000000000ae1e81 in buf_block_align (ptr=0x7f8618c14000 "") at storage/xtradb/buf/buf0buf.c:2347

#8  0x0000000000b8fa2b in mtr_memo_contains_page (mtr=0x7f8614667e20, ptr=0x7f8618c14000 "", type=2) at storage/xtradb/mtr/mtr0mtr.c:369

#9  0x0000000000b55951 in ibuf_bitmap_page_get_bits_low (page=0x7f8618c14000 "", page_no=3, zip_size=0, latch_type=2, mtr=0x7f8614667e20, bit=2) at storage/xtradb/ibuf/ibuf0ibuf.c:752

#10 0x0000000000b5cec9 in ibuf_merge_or_delete_for_page (block=0x7f86188df0a0, space=10, page_no=3, zip_size=0, update_ibuf_bitmap=1) at storage/xtradb/ibuf/ibuf0ibuf.c:4495

#11 0x0000000000ae6490 in buf_page_io_complete (bpage=0x7f86188df0a0) at storage/xtradb/buf/buf0buf.c:4079

#12 0x0000000000afae83 in buf_read_page_low (err=0x7f8614668470, sync=1, mode=132, space=10, zip_size=0, unzip=0, tablespace_version=4, offset=3, trx=0x0) at storage/xtradb/buf/buf0rea.c:213

#13 0x0000000000afb33e in buf_read_page (space=10, zip_size=0, offset=3, trx=0x0) at storage/xtradb/buf/buf0rea.c:410

#14 0x0000000000ae26dd in buf_page_get_gen (space=10, zip_size=0, offset=3, rw_latch=3, guess=0x0, mode=10, file=0xe1d978 "storage/xtradb/include/btr0pcur.ic", line=519, mtr=0x7f8614668e30) at storage/xtradb/buf/buf0buf.c:2590

#15 0x0000000000ac2794 in btr_cur_open_at_index_side_func (from_left=1, index=0x3c60fa8, latch_mode=1, cursor=0x3c8e278, file=0xe1d978 "storage/xtradb/include/btr0pcur.ic", line=519, mtr=0x7f8614668e30) at storage/xtradb/btr/btr0cur.c:914

#16 0x0000000000a52c6e in btr_pcur_open_at_index_side (from_left=1, index=0x3c60fa8, latch_mode=1, pcur=0x3c8e278, do_init=0, mtr=0x7f8614668e30) at storage/xtradb/include/btr0pcur.ic:518

#17 0x0000000000a5a608 in row_search_for_mysql (buf=0x3c5d2c8 "\377", mode=1, prebuilt=0x3c8e208, match_mode=0, direction=0) at storage/xtradb/row/row0sel.c:4116

#18 0x0000000000a18e45 in ha_innobase::index_read (this=0x3c8b9d8, buf=0x3c5d2c8 "\377", key_ptr=0x0, key_len=0, find_flag=HA_READ_AFTER_KEY) at storage/xtradb/handler/ha_innodb.cc:6739

#19 0x0000000000a19a84 in ha_innobase::index_first (this=0x3c8b9d8, buf=0x3c5d2c8 "\377") at storage/xtradb/handler/ha_innodb.cc:7090

#20 0x0000000000a19c6c in ha_innobase::rnd_next (this=0x3c8b9d8, buf=0x3c5d2c8 "\377") at storage/xtradb/handler/ha_innodb.cc:7187

#21 0x00000000005a73b4 in handler::ha_rnd_next (this=0x3c8b9d8, buf=0x3c5d2c8 "\377") at sql/sql_class.h:4263

#22 0x00000000008e0d5f in rr_sequential (info=0x3c4da70) at sql/records.cc:452

#23 0x00000000006653fc in join_init_read_record (tab=0x3c4d9c0) at sql/sql_select.cc:16949

#24 0x0000000000663538 in sub_select (join=0x3c4c9e0, join_tab=0x3c4d9c0, end_of_records=false) at sql/sql_select.cc:16095

#25 0x0000000000662e4b in do_select (join=0x3c4c9e0, fields=0x3b4b910, table=0x0, procedure=0x0) at sql/sql_select.cc:15768

#26 0x0000000000643831 in JOIN::exec (this=0x3c4c9e0) at sql/sql_select.cc:2824

#27 0x000000000064402d in mysql_select (thd=0x3b48da0, rref_pointer_array=0x3b4ba58, tables=0x3c4c348, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x3c4c9c0, unit=0x3b4b128, select_lex=0x3b4b800) at sql/sql_select.cc:3044

#28 0x000000000063ac15 in handle_select (thd=0x3b48da0, lex=0x3b4b078, result=0x3c4c9c0, setup_tables_done_option=0) at sql/sql_select.cc:313

#29 0x0000000000613ee5 in execute_sqlcom_select (thd=0x3b48da0, all_tables=0x3c4c348) at sql/sql_parse.cc:4621

#30 0x000000000060ca2a in mysql_execute_command (thd=0x3b48da0) at sql/sql_parse.cc:2189

#31 0x000000000061674d in mysql_parse (thd=0x3b48da0, rawbuf=0x3c4c168 "SELECT * FROM t1", length=16, parser_state=0x7f861466a500) at sql/sql_parse.cc:5736

#32 0x0000000000609fc3 in dispatch_command (command=COM_QUERY, thd=0x3b48da0, packet=0x3c44951 "", packet_length=16) at sql/sql_parse.cc:1055

#33 0x000000000060927a in do_command (thd=0x3b48da0) at sql/sql_parse.cc:794

#34 0x000000000070a69f in do_handle_one_connection (thd_arg=0x3b48da0) at sql/sql_connect.cc:1253

#35 0x000000000070a08a in handle_one_connection (arg=0x3b48da0) at sql/sql_connect.cc:1168

#36 0x0000000000bffcbf in pfs_spawn_thread (arg=0x3cbf360) at storage/perfschema/pfs.cc:1015

#37 0x00007f8624725efc in start_thread (arg=0x7f861466b700) at pthread_create.c:304

InnoDB: Assertion failure in thread 139991125931776 in file buf0buf.c line 2080

InnoDB: Failing assertion: block->page.space == page_get_space_id(page_align(ptr))

#3  <signal handler called>

#4  0x00007f5249d4c3a5 in __GI_raise (sig=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:64

#5  0x00007f5249d4fb0b in __GI_abort () at abort.c:92

#6  0x00007f523f036e62 in buf_block_align_instance (buf_pool=0x40f9f98, ptr=0x7f523ecc8000 "") at storage/innobase/buf/buf0buf.c:2079

#7  0x00007f523f036f21 in buf_block_align (ptr=0x7f523ecc8000 "") at storage/innobase/buf/buf0buf.c:2110

#8  0x00007f523f0d72db in mtr_memo_contains_page (mtr=0x7f523954fec0, ptr=0x7f523ecc8000 "", type=2) at storage/innobase/mtr/mtr0mtr.c:368

#9  0x00007f523f09ba34 in ibuf_bitmap_page_get_bits_low (page=0x7f523ecc8000 "", page_no=3, zip_size=0, latch_type=2, mtr=0x7f523954fec0, bit=2) at storage/innobase/ibuf/ibuf0ibuf.c:710

#10 0x00007f523f0a2f6b in ibuf_merge_or_delete_for_page (block=0x7f523e7d4b28, space=1, page_no=3, zip_size=0, update_ibuf_bitmap=1) at storage/innobase/ibuf/ibuf0ibuf.c:4447

#11 0x00007f523f03aef0 in buf_page_io_complete (bpage=0x7f523e7d4b28) at storage/innobase/buf/buf0buf.c:3620

#12 0x00007f523f04dbc8 in buf_read_page_low (err=0x7f52395504c0, sync=1, mode=132, space=1, zip_size=0, unzip=0, tablespace_version=4, offset=3) at storage/innobase/buf/buf0rea.c:160

#13 0x00007f523f04e0f2 in buf_read_page (space=1, zip_size=0, offset=3) at storage/innobase/buf/buf0rea.c:355

#14 0x00007f523f0375b4 in buf_page_get_gen (space=1, zip_size=0, offset=3, rw_latch=3, guess=0x0, mode=10, file=0x7f523f208828 "storage/innobase/include/btr0pcur.ic", line=519, mtr=0x7f5239550e30) at storage/innobase/buf/buf0buf.c:2308

#15 0x00007f523f015c7c in btr_cur_open_at_index_side_func (from_left=1, index=0x454bbe8, latch_mode=1, cursor=0x4543a48, file=0x7f523f208828 "storage/innobase/include/btr0pcur.ic", line=519, mtr=0x7f5239550e30) at storage/innobase/btr/btr0cur.c:861

#16 0x00007f523f1581bd in btr_pcur_open_at_index_side (from_left=1, index=0x454bbe8, latch_mode=1, pcur=0x4543a48, do_init=0, mtr=0x7f5239550e30) at storage/innobase/include/btr0pcur.ic:518

#17 0x00007f523f15f1fe in row_search_for_mysql (buf=0x4549338 "\377", mode=1, prebuilt=0x45439d8, match_mode=0, direction=0) at storage/innobase/row/row0sel.c:3907

#18 0x00007f523f10dbe6 in ha_innodb::index_read (this=0x4541428, buf=0x4549338 "\377", key_ptr=0x0, key_len=0, find_flag=HA_READ_AFTER_KEY) at storage/innobase/handler/ha_innodb.cc:5973

#19 0x00007f523f10e71c in ha_innodb::index_first (this=0x4541428, buf=0x4549338 "\377") at storage/innobase/handler/ha_innodb.cc:6298

#20 0x00007f523f10e904 in ha_innodb::rnd_next (this=0x4541428, buf=0x4549338 "\377") at storage/innobase/handler/ha_innodb.cc:6395

#21 0x00000000005a73b4 in handler::ha_rnd_next (this=0x4541428, buf=0x4549338 "\377") at sql/sql_class.h:4263

#22 0x00000000008e0d5f in rr_sequential (info=0x43eb000) at sql/records.cc:452

#23 0x00000000006653fc in join_init_read_record (tab=0x43eaf50) at sql/sql_select.cc:16949

#24 0x0000000000663538 in sub_select (join=0x43e9f70, join_tab=0x43eaf50, end_of_records=false) at sql/sql_select.cc:16095

#25 0x0000000000662e4b in do_select (join=0x43e9f70, fields=0x42ea620, table=0x0, procedure=0x0) at sql/sql_select.cc:15768

#26 0x0000000000643831 in JOIN::exec (this=0x43e9f70) at sql/sql_select.cc:2824

#27 0x000000000064402d in mysql_select (thd=0x42e7ab0, rref_pointer_array=0x42ea768, tables=0x43e98d8, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x43e9f50, unit=0x42e9e38, select_lex=0x42ea510) at sql/sql_select.cc:3044

#28 0x000000000063ac15 in handle_select (thd=0x42e7ab0, lex=0x42e9d88, result=0x43e9f50, setup_tables_done_option=0) at sql/sql_select.cc:313

#29 0x0000000000613ee5 in execute_sqlcom_select (thd=0x42e7ab0, all_tables=0x43e98d8) at sql/sql_parse.cc:4621

#30 0x000000000060ca2a in mysql_execute_command (thd=0x42e7ab0) at sql/sql_parse.cc:2189

#31 0x000000000061674d in mysql_parse (thd=0x42e7ab0, rawbuf=0x43e96f8 "SELECT * FROM t1", length=16, parser_state=0x7f5239552500) at sql/sql_parse.cc:5736

#32 0x0000000000609fc3 in dispatch_command (command=COM_QUERY, thd=0x42e7ab0, packet=0x43e2fc1 "", packet_length=16) at sql/sql_parse.cc:1055

#33 0x000000000060927a in do_command (thd=0x42e7ab0) at sql/sql_parse.cc:794

#34 0x000000000070a69f in do_handle_one_connection (thd_arg=0x42e7ab0) at sql/sql_connect.cc:1253

#35 0x000000000070a08a in handle_one_connection (arg=0x42e7ab0) at sql/sql_connect.cc:1168

#36 0x0000000000bffcbf in pfs_spawn_thread (arg=0x455c9d0) at storage/perfschema/pfs.cc:1015

#37 0x00007f524aa86efc in start_thread (arg=0x7f5239553700) at pthread_create.c:304

#38 0x00007f5249df959d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112

Some pointers may be invalid and cause the dump to abort.

Query (0x2e0ed48): SELECT * FROM t1

Connection ID (thread ID): 2

Status: NOT_KILLED

maria/5.5

bzr version-info

revision-id: <email address hidden>

date: 2012-06-24 09:10:11 -0700

revno: 3458

bzr version-info

revision-id: <email address hidden>

date: 2012-06-21 14:36:22 +0200

build-date: 2012-06-25 01:46:37 +0400

revno: 270

# Test case:

# (sometimes it takes a couple of attempts)

--source include/have_innodb.inc

SET GLOBAL innodb_file_per_table=1;

CREATE TABLE t1 (a INT) ENGINE=InnoDB;

INSERT INTO t1 VALUES (1),(2);

--let $datadir = `SELECT @@datadir`

--copy_file $datadir/test/t1.ibd $datadir/test/t1.ibd.save

ALTER TABLE t1 DISCARD TABLESPACE;

--error ER_GET_ERRNO

SELECT * FROM t1;

--move_file $datadir/test/t1.ibd.save $datadir/test/t1.ibd

ALTER TABLE t1 IMPORT TABLESPACE;

SELECT * FROM t1;

DROP TABLE t1;