Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.0, 10.1, 10.2, 10.3
-
None
Description
10.0 d04d835f64b39edf0310e0471a7ed261b5cb2a20 |
2017-03-03 00:10:06 7f06bafa1700 InnoDB: Assertion failure in thread 139666883483392 in file buf0buf.cc line 2635
|
InnoDB: Failing assertion: zip_size == fil_space_get_zip_size(space)
|
#5 0x00007f06bb237448 in __GI_abort () at abort.c:89
|
#6 0x00007f06b370cb2c in buf_page_get_gen (space=space@entry=8, zip_size=zip_size@entry=0, offset=offset@entry=3, rw_latch=rw_latch@entry=3, guess=guess@entry=0x0, mode=mode@entry=10, file=0x7f06b394a6a8 "/data/src/10.0/storage/innobase/include/btr0pcur.ic", line=518, mtr=0x7f06baf9e7a0) at /data/src/10.0/storage/innobase/buf/buf0buf.cc:2635
|
#7 0x00007f06b36e2bb7 in btr_cur_open_at_index_side_func (from_left=from_left@entry=true, index=index@entry=0x7f06a684dff8, latch_mode=latch_mode@entry=1, cursor=cursor@entry=0x7f06a64ba0f0, level=level@entry=0, file=file@entry=0x7f06b394a6a8 "/data/src/10.0/storage/innobase/include/btr0pcur.ic", line=518, mtr=0x7f06baf9e7a0) at /data/src/10.0/storage/innobase/btr/btr0cur.cc:897
|
#8 0x00007f06b38d77f1 in btr_pcur_open_at_index_side (mtr=0x7f06baf9e7a0, level=0, init_pcur=false, pcur=0x7f06a64ba0f0, latch_mode=1, index=0x7f06a684dff8, from_left=true) at /data/src/10.0/storage/innobase/include/btr0pcur.ic:518
|
#9 row_search_for_mysql (buf=buf@entry=0x7f06af2b6c88 "\377", mode=mode@entry=1, prebuilt=0x7f06a64ba078, match_mode=match_mode@entry=0, direction=direction@entry=0) at /data/src/10.0/storage/innobase/row/row0sel.cc:4175
|
#10 0x00007f06b37d2924 in ha_innodb::index_read (this=0x7f06a646f088, buf=0x7f06af2b6c88 "\377", key_ptr=0x0, key_len=<optimized out>, find_flag=<optimized out>) at /data/src/10.0/storage/innobase/handler/ha_innodb.cc:8177
|
#11 0x00007f06b37b94b0 in ha_innodb::index_first (this=0x7f06a646f088, buf=0x7f06af2b6c88 "\377") at /data/src/10.0/storage/innobase/handler/ha_innodb.cc:8585
|
#12 0x00007f06b37cc59a in ha_innodb::rnd_next (this=0x7f06a646f088, buf=0x7f06af2b6c88 "\377") at /data/src/10.0/storage/innobase/handler/ha_innodb.cc:8682
|
#13 0x000000000073d86c in handler::ha_rnd_next (this=0x7f06a646f088, buf=0x7f06af2b6c88 "\377") at /data/src/10.0/sql/handler.cc:2598
|
#14 0x0000000000840ce4 in rr_sequential (info=0x7f06a64cf130) at /data/src/10.0/sql/records.cc:469
|
#15 0x00000000005ea294 in join_init_read_record (tab=0x7f06a64cf088) at /data/src/10.0/sql/sql_select.cc:18764
|
#16 0x00000000005ea45c in sub_select (join=join@entry=0x7f06a6422960, join_tab=join_tab@entry=0x7f06a64cf088, end_of_records=end_of_records@entry=false) at /data/src/10.0/sql/sql_select.cc:17856
|
#17 0x00000000005fae26 in do_select (join=join@entry=0x7f06a6422960, fields=fields@entry=0x7f06af35b210, table=table@entry=0x0, procedure=0x0) at /data/src/10.0/sql/sql_select.cc:17521
|
#18 0x000000000060eb8a in JOIN::exec_inner (this=this@entry=0x7f06a6422960) at /data/src/10.0/sql/sql_select.cc:3089
|
#19 0x000000000060f2f5 in JOIN::exec (this=this@entry=0x7f06a6422960) at /data/src/10.0/sql/sql_select.cc:2378
|
#20 0x000000000060bd8c in mysql_select (thd=thd@entry=0x7f06af357070, rref_pointer_array=rref_pointer_array@entry=0x7f06af35b370, tables=0x7f06a64222b0, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f06a6422940, unit=0x7f06af35aa08, select_lex=0x7f06af35b0f8) at /data/src/10.0/sql/sql_select.cc:3314
|
#21 0x000000000060bf78 in handle_select (thd=thd@entry=0x7f06af357070, lex=lex@entry=0x7f06af35a940, result=result@entry=0x7f06a6422940, setup_tables_done_option=setup_tables_done_option@entry=0) at /data/src/10.0/sql/sql_select.cc:373
|
#22 0x00000000005a9255 in execute_sqlcom_select (thd=thd@entry=0x7f06af357070, all_tables=0x7f06a64222b0) at /data/src/10.0/sql/sql_parse.cc:5301
|
#23 0x00000000005b0c55 in mysql_execute_command (thd=thd@entry=0x7f06af357070) at /data/src/10.0/sql/sql_parse.cc:2563
|
#24 0x00000000005b944d in mysql_parse (thd=thd@entry=0x7f06af357070, rawbuf=<optimized out>, length=34, parser_state=parser_state@entry=0x7f06bafa05f0) at /data/src/10.0/sql/sql_parse.cc:6583
|
#25 0x00000000005ba9b0 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f06af357070, packet=packet@entry=0x7f06af363071 "", packet_length=packet_length@entry=34) at /data/src/10.0/sql/sql_parse.cc:1309
|
#26 0x00000000005bc745 in do_command (thd=0x7f06af357070) at /data/src/10.0/sql/sql_parse.cc:999
|
#27 0x000000000069726e in do_handle_one_connection (thd_arg=thd_arg@entry=0x7f06af357070) at /data/src/10.0/sql/sql_connect.cc:1377
|
#28 0x000000000069734e in handle_one_connection (arg=arg@entry=0x7f06af357070) at /data/src/10.0/sql/sql_connect.cc:1292
|
#29 0x00000000008ba38b in pfs_spawn_thread (arg=0x7f06af2ec070) at /data/src/10.0/storage/perfschema/pfs.cc:1860
|
#30 0x00007f06bc8be0a4 in start_thread (arg=0x7f06bafa1700) at pthread_create.c:309
|
#31 0x00007f06bb2e987d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
|
The test case is only for reproducing, don't put it into the regression suite!
Test case |
--source include/master-slave.inc
|
--source include/have_innodb.inc
|
|
--connection slave
|
STOP SLAVE;
|
ALTER TABLE mysql.gtid_slave_pos ENGINE=InnoDB; |
|
--delimiter $
|
CREATE PROCEDURE pr() |
BEGIN
|
LOOP
|
SET GLOBAL gtid_slave_pos = @@global.gtid_slave_pos; |
END LOOP; |
END $ |
--delimiter ;
|
|
--send CALL pr()
|
|
--connection slave1
|
|
--let $run=10000
|
while ($run)
|
{
|
SELECT * FROM mysql.gtid_slave_pos; |
--dec $run |
}
|
I cannot check the contents of the ibd file, because at some point it disappears. I'm not sure whether this disappearance is a result of the assertion failure, or that's what causes it.
Not reproducible (at least with this test case) on 10.2.