Comment 10 for bug 1086700

Revision history for this message
Roel Van de Paar (roel11) wrote :

Had another occurrence:

===============
130122 11:11:05 [Note] /ssd/Percona-Server-5.5.28-rel29.3-415.Linux.x86_64/bin/mysqld: ready for connections.
Version: '5.5.29-rel29.3-log' socket: '/tmp/bug2/tmp/master.sock' port: 13100 Percona Server with XtraDB (GPL), Release rel29.3, Revision 415
InnoDB: Warning: hash index ref_count (2) is not zero after fil_discard_tablespace().
index: "PRIMARY" table: "test/table500_innodb_dynamic_int_autoinc"
InnoDB: Warning: hash index ref_count (2) is not zero after fil_discard_tablespace().
index: "PRIMARY" table: "test/table500_innodb_dynamic_int_autoinc"
InnoDB: Warning: hash index ref_count (2) is not zero after fil_discard_tablespace().
index: "PRIMARY" table: "test/table500_innodb_dynamic_int_autoinc"
InnoDB: Warning: hash index ref_count (2) is not zero after fil_discard_tablespace().
index: "PRIMARY" table: "test/table500_innodb_dynamic_int_autoinc"
InnoDB: Warning: hash index ref_count (2) is not zero after fil_discard_tablespace().
index: "c34" table: "test/table500_innodb_dynamic"
InnoDB: Warning: hash index ref_count (2) is not zero after fil_discard_tablespace().
index: "c34" table: "test/table500_innodb_dynamic"
130122 11:27:25 InnoDB: Error: trying to access tablespace 148 page no. 49,
InnoDB: but the tablespace does not exist or is just being dropped.
130122 11:27:25 InnoDB: Error: trying to access tablespace 148 page no. 49,
InnoDB: but the tablespace does not exist or is just being dropped.
[.... same ....]
130122 11:27:25 InnoDB: Error: trying to access tablespace 148 page no. 49,
InnoDB: but the tablespace does not exist or is just being dropped.
InnoDB: Error: Unable to read tablespace 148 page no 49 into the buffer pool after 100 attempts
InnoDB: The most probable cause of this error may be that the table has been corrupted.
InnoDB: You can try to fix this problem by using innodb_force_recovery.
InnoDB: Please see reference manual for more details.
InnoDB: Aborting...
130122 11:27:25 InnoDB: Assertion failure in thread 140277794035456 in file buf0buf.c line 2612
===============

=============== +bt
#0 0x0000003da180c60c in pthread_kill () from /lib64/libpthread.so.0
#1 0x000000000069386f in handle_fatal_signal (sig=6) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/signal_handler.cc:249
#2 <signal handler called>
#3 0x0000003da1435935 in raise () from /lib64/libc.so.6
#4 0x0000003da14370e8 in abort () from /lib64/libc.so.6
#5 0x000000000086cb0e in buf_page_get_gen (space=148, zip_size=zip_size@entry=0, offset=offset@entry=49, rw_latch=rw_latch@entry=1, guess=<optimized out>, guess@entry=0x0, mode=mode@entry=10, file=file@entry=0xa72430 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/btr/btr0cur.c", line=line@entry=5181
, mtr=mtr@entry=0x7f94f8152210) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/buf/buf0buf.c:2612
#6 0x000000000084ef19 in btr_copy_blob_prefix (buf=0x7f94da417620 "", len=len@entry=11312, space_id=space_id@entry=148, page_no=page_no@entry=49, offset=38) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/btr/btr0cur.c:5181
#7 0x000000000085bf0f in btr_copy_externally_stored_field_prefix_low (offset=<optimized out>, page_no=49, space_id=148, zip_size=0, len=11312, buf=<optimized out>) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/btr/btr0cur.c:5391
#8 btr_copy_externally_stored_field (heap=<optimized out>, local_len=<optimized out>, zip_size=0, data=0x7f94f00022ab "", len=0x7f94f81527a0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/btr/btr0cur.c:5498
#9 btr_rec_copy_externally_stored_field (rec=rec@entry=0x7f94f0002268 "", offsets=offsets@entry=0x7f94f8152970, zip_size=0, no=<optimized out>, len=len@entry=0x7f94f81527a0, heap=<optimized out>) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/btr/btr0cur.c:5551
#10 0x0000000000517e47 in row_sel_store_mysql_rec (mysql_rec=mysql_rec@entry=0x7f94c95ae4d8 "\200\003V\332\002", prebuilt=prebuilt@entry=0x7f94d8a744a8, rec=0x7f94f0002268 "", rec_clust=0, offsets=0x7f94f8152970) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0sel.c:2764
#11 0x000000000080e054 in row_search_for_mysql (buf=0x7f94c95ae4d8 "\200\003V\332\002", mode=2, prebuilt=<optimized out>, match_mode=1, direction=0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0sel.c:4618
#12 0x00000000007e23e8 in ha_innobase::index_read (this=0x7f94d89b5f90, buf=0x7f94c95ae4d8 "\200\003V\332\002", key_ptr=0x7f94f8153240 "", key_len=4, find_flag=<optimized out>) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/handler/ha_innodb.cc:6834
#13 0x0000000000693ed8 in handler::index_read_idx_map (this=0x7f94d89b5f90, buf=0x7f94c95ae4d8 "\200\003V\332\002", index=<optimized out>, key=0x7f94f8153240 "", keypart_map=18446744073709551615, find_flag=<optimized out>) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/handler.cc:4988
#14 0x000000000058c435 in write_record (thd=thd@entry=0x1b8bd00, table=table@entry=0x7f94d8a8f380, info=info@entry=0x7f94f81536a0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_insert.cc:1612
#15 0x000000000058e4c4 in mysql_insert (thd=0x1b8bd00, table_list=0x7f94d80087f0, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_UPDATE, ignore=true) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_insert.cc:956
#16 0x00000000005a2644 in mysql_execute_command (thd=thd@entry=0x1b8bd00) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:3091
#17 0x00000000005a5ca2 in mysql_parse (thd=thd@entry=0x1b8bd00, rawbuf=<optimized out>, length=129, parser_state=parser_state@entry=0x7f94f8154810) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:5844
#18 0x00000000005a71dd in dispatch_command (command=COM_QUERY, thd=0x1b8bd00, packet=0x1b8f751 "INSERT IGNORE INTO `view_table500_innodb_dynamic` ( `c10` ) VALUES ( 'then' ) ON DUPLICATE KEY UPDATE `c5` = 9967591875277750272", packet_length=<optimized out>) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_pa
rse.cc:1061
#19 0x000000000063fd6f in do_handle_one_connection (thd_arg=thd_arg@entry=0x1b8bd00) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1497
#20 0x000000000063fe31 in handle_one_connection (arg=0x1b8bd00) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1404
#21 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0
#22 0x0000003da14f168d in clone () from /lib64/libc.so.6
===============

Full thread bt attached.