InnoDB: Assertion failure in thread <nr> in file buf0buf.cc line 2648 | InnoDB: Error: Unable to read tablespace 77 page no 3934 into the buffer pool after 100 attempts | InnoDB: Error: trying to access tablespace 77 page no. 3934 | abort (sig=6) in buf_page_get_gen

[Roel Van de Paar]

2013-09-16 14:51:16 18738 [Note] /ssd/Percona-Server-5.6.13-rc60.5-437-debug.Linux.x86_64/bin/mysqld: ready for connections.
Version: '5.6.13-rc60.5-debug-log' socket: '/ssd//128776/current1_8/tmp/master.sock' port: 13140 Percona Server with XtraDB (GPL), Release rc60.5, Revision 437-debug
row_ins_clust_index_entry_by_modify returning DB_FAIL!
2013-09-16 14:55:13 7f393d7a9700 InnoDB: Error: trying to access tablespace 77 page no. 3934,
InnoDB: but the tablespace does not exist or is just being dropped.
[...]
2013-09-16 14:55:13 7f393d7a9700 InnoDB: Error: trying to access tablespace 77 page no. 3934,
InnoDB: but the tablespace does not exist or is just being dropped.
InnoDB: Error: Unable to read tablespace 77 page no 3934 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...
2013-09-16 14:55:13 7f393d7a9700 InnoDB: Assertion failure in thread 139883821307648 in file buf0buf.cc line 2648
InnoDB: We intentionally generate a memory trap.
[...]
Writing a core file
<EOF>

===============

Thread 1 (LWP 18756):
+bt
#0 0x000000363720c69c in pthread_kill () from /lib64/libpthread.so.0
#1 0x00000000006874ae in handle_fatal_signal (sig=6) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/signal_handler.cc:251
#2 <signal handler called>
#3 0x0000003636e328a5 in raise () from /lib64/libc.so.6
#4 0x0000003636e34085 in abort () from /lib64/libc.so.6
#5 0x0000000000b82dbc in buf_page_get_gen (space=77, zip_size=0, offset=3934, rw_latch=2, guess=<optimized out>, mode=16, file=0xde34c0 "/bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/innobase/lock/lock0lock.cc", line=5845, mtr=0x7f393d7a7e60) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/innobase/buf/buf0buf.cc:2648
#6 0x0000000000a4c4e1 in lock_rec_block_validate (space=77, page_no=3934) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/innobase/lock/lock0lock.cc:5845
#7 0x0000000000a4d445 in lock_validate () at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/innobase/lock/lock0lock.cc:5897
#8 lock_print_info_all_transactions (file=0x7f393d7a8bc0) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/innobase/lock/lock0lock.cc:5320
#9 0x0000000000b0878f in srv_printf_innodb_monitor (file=<optimized out>, nowait=1, trx_start_pos=<optimized out>, trx_end=<optimized out>) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/innobase/srv/srv0srv.cc:1478
#10 0x0000000000b08dbe in srv_monitor_thread (arg=<optimized out>) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/innobase/srv/srv0srv.cc:1870
#11 0x0000003637207851 in start_thread () from /lib64/libpthread.so.0
#12 0x0000003636ee890d in clone () from /lib64/libc.so.6

[Roel Van de Paar (roel11)]

RQG @ 909 <email address hidden>
PS @ Percona-Server-5.6.13-rc60.5-437-debug.Linux.x86_64 (5.6-QA)

[Roel Van de Paar (roel11)]

(gdb) f 5
#5 0x0000000000b82dbc in buf_page_get_gen (space=77, zip_size=0, offset=3934, rw_latch=2, guess=<optimized out>, mode=16, file=0xde34c0 "/bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/innobase/lock/lock0lock.cc", line=5845, mtr=0x7f393d7a7e60) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/innobase/buf/buf0buf.cc:2648
2648 ut_error;
(gdb) p trx->fake_changes
Cannot access memory at address 0x130
(gdb) f 8
#8 lock_print_info_all_transactions (file=0x7f393d7a8bc0) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/innobase/lock/lock0lock.cc:5320
5320 ut_ad(lock_validate());
(gdb) p trx->fake_changes
value has been optimized out

Nothing in other frames

[Launchpad Janitor (janitor)]

[Expired for Percona Server because there has been no activity for 60 days.]

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-723