InnoDB: Failing assertion: mtr_memo_contains_page(mtr, page, 2) || mtr_memo_contains_page(mtr, page, 1) in file btr0btr.ic line 169
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
Medium
|
Krunal Bauskar | ||
5.1 |
Won't Fix
|
Medium
|
Unassigned | ||
5.5 |
Fix Released
|
Medium
|
Krunal Bauskar | ||
5.6 |
Fix Released
|
Medium
|
Krunal Bauskar |
Bug Description
InnoDB: Error: the age of the oldest untracked record exceeds the log group capacity!
InnoDB: Error: stopping the log tracking thread at LSN 204650236
2013-06-20 03:48:53 27439 [ERROR] InnoDB: log tracking bitmap write failed, stopping log tracking thread!
2013-06-20 03:56:08 7fa9503f7700 InnoDB: Assertion failure in thread 140365172537088 in file btr0btr.ic line 169
InnoDB: Failing assertion: mtr_memo_
InnoDB: We intentionally generate a memory trap.
Thread 1 (LWP 31022):
+bt
#0 0x0000003fde20c69c in pthread_kill () from /lib64/
#1 0x000000000068302e in handle_fatal_signal (sig=6) at /bzr/5.
#2 <signal handler called>
#3 0x0000003fdde328a5 in raise () from /lib64/libc.so.6
#4 0x0000003fdde34085 in abort () from /lib64/libc.so.6
#5 0x0000000000b34632 in btr_page_get_next (page=0x7fa9466
#6 0x0000000000b39529 in btr_cur_
#7 0x0000000000b40977 in btr_cur_
#8 0x0000000000a9709e in row_ins_
#9 0x0000000000a9a075 in row_ins_
#10 0x0000000000a9b7f7 in row_ins_index_entry (thr=0x7fa94c08
#11 row_ins_
#12 row_ins (thr=0x7fa94c08
#13 row_ins_step (thr=0x7fa94c08
#14 0x0000000000aae1ec in row_insert_
#15 0x00000000009ea39e in ha_innobase:
#16 0x00000000005b7b04 in handler:
#17 0x00000000006f8540 in write_record (thd=0x1dd9d90, table=0x7fa94c0
#18 0x00000000007002d1 in mysql_insert (thd=0x1dd9d90, table_list=
#19 0x000000000071806e in mysql_execute_
#20 0x000000000071b8b8 in mysql_parse (thd=0x1dd9d90, rawbuf=0x1ddc148 "p\234\065\001", length=<optimized out>, parser_
#21 0x000000000071c923 in dispatch_command (command=COM_QUERY, thd=0x1dd9d90, packet=0x1dddd01 " INSERT INTO v ( `c21` ) VALUES ( 105665706257180
#22 0x000000000071d86b in do_command (thd=0x1dd9d90) at /bzr/5.
#23 0x00000000006e261f in do_handle_
#24 0x00000000006e2707 in handle_
#25 0x00000000009beb49 in pfs_spawn_thread (arg=0x1dd7e00) at /bzr/5.
#26 0x0000003fde207851 in start_thread () from /lib64/
#27 0x0000003fddee890d in clone () from /lib64/libc.so.6
tags: |
added: fake-changes i20439 xtradb removed: bitmap |
tags: | removed: qablock |
[roel@qaserver 934394]$ cat cmd9 cmdrun_ 9 cmdrun_ 9 column_ names --reporter= Shutdown, Backtrace, QueryTimeout, ErrorLog, ErrorLogAlarm --mysqld= --log-output= none --mysqld= --sql_mode= ONLY_FULL_ GROUP_BY --grammar= conf/percona_ qa/5.6/ 5.6.yy --gendata= conf/percona_ qa/5.6/ 5.6.zz --basedir= /ssd2/Percona- Server- 5.6.11- rc60.3- 383-debug. Linux.x86_ 64 --threads=25 --no-mask --views --notnull --validator= Transformer --mysqld= --innodb_ track_changed_ pages=1 --mysqld= --innodb_ max_bitmap_ file_size= 922337203685477 5807 --mysqld= --innodb_ changed_ pages=FORCE --mysqld= --innodb_ max_changed_ pages=100 --mysqld= --innodb_ log_file_ size=1048576 --mysqld= --innodb_ log_files_ in_group= 2 --mysqld= --innodb_ log_buffer_ size=1048576 --mysqld= --innodb_ log_block_ size=512 --mysqld= --innodb_ fast_shutdown= 2 --mysqld= --innodb_ log_group_ home_dir= /ssd2/934394/ _epoch/ 137168859900281 8017 --mysqld= --innodb_ use_global_ flush_log_ at_trx_ commit= 0 --mysqld=--userstat --mysqld= --innodb_ flush_method= O_DIRECT --mysqld= --innodb_ file_per_ table=1 --mtr-build- thread= 790 --mask=34062 --vardir1= /ssd2/934394/ cmdrun_ 9 > /ssd2/934394/ cmdrun9. log 2>&1"
ps -ef | grep 'cmdrun_9' | grep -v grep | awk '{print $2}' | xargs sudo kill -9
rm -Rf /ssd2/934394/
mkdir /ssd2/934394/
cd /ssd2/randgen
bash -c "set -o pipefail; perl runall.pl --queries=100000000 --seed=14638 --duration=300 --querytimeout=60 --short_