Percona Server with XtraDB

mysqld-debug: .../sql/protocol.cc:518: void Protocol::end_statement(): Assertion `0' failed on a INFORMATION_SCHEMA.INNODB_CHANGED_PAGES query.

Reported by Roel Van de Paar on 2013-06-16
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server
Status tracked in 5.6
5.1
High
Laurynas Biveinis
5.5
High
Laurynas Biveinis
5.6
High
Laurynas Biveinis

Bug Description

InnoDB: Error: inconsistent bitmap file directory for a INFORMATION_SCHEMA.INNODB_CHANGED_PAGES query
mysqld-debug: /bzr/5.6_val/Percona-Server-5.6.11-alpha60.3/sql/protocol.cc:518: void Protocol::end_statement(): Assertion `0' failed.
01:51:22 UTC - mysqld got signal 6 ;
[...]
Query (20fa03a8): SELECT start_lsn, end_lsn, space_id, page_id FROM INFORMATION_SCHEMA.INNODB_CHANGED_PAGES LIMIT 8

Thread 23 (LWP 7075):
+bt
#0 0x0000003fde20c69c in pthread_kill () from /lib64/libpthread.so.0
#1 0x00000000006e711d in handle_fatal_signal (sig=6) at /bzr/5.6_val/Percona-Server-5.6.11-alpha60.3/sql/signal_handler.cc:251
#2 <signal handler called>
#3 0x0000003fdde328a5 in raise () from /lib64/libc.so.6
#4 0x0000003fdde34085 in abort () from /lib64/libc.so.6
#5 0x0000003fdde2ba1e in __assert_fail_base () from /lib64/libc.so.6
#6 0x0000003fdde2bae0 in __assert_fail () from /lib64/libc.so.6
#7 0x00000000006e08c5 in Protocol::end_statement (this=0x2029dbc0) at /bzr/5.6_val/Percona-Server-5.6.11-alpha60.3/sql/protocol.cc:518
#8 0x0000000000770687 in dispatch_command (command=<optimized out>, thd=0x2029d690, packet=<optimized out>, packet_length=553255646) at /bzr/5.6_val/Percona-Se
rver-5.6.11-alpha60.3/sql/sql_parse.cc:1766
#9 0x0000000000771b60 in do_command (thd=0x2029d690) at /bzr/5.6_val/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:1051
#10 0x000000000073c48f in do_handle_one_connection (thd_arg=<optimized out>) at /bzr/5.6_val/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1615
#11 0x000000000073c550 in handle_one_connection (arg=<optimized out>) at /bzr/5.6_val/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1526
#12 0x00000000009c8e59 in pfs_spawn_thread (arg=0x20b3d6b0) at /bzr/5.6_val/Percona-Server-5.6.11-alpha60.3/storage/perfschema/pfs.cc:1853
#13 0x0000003fde207851 in start_thread () from /lib64/libpthread.so.0
#14 0x0000003fddee890d in clone () from /lib64/libc.so.6

Roel Van de Paar (roel11) wrote :
Roel Van de Paar (roel11) wrote :
Roel Van de Paar (roel11) wrote :

Ignore the Valgrind error, this is dealt with in bug 1191582

One bug and one issue needing investigation here:
1) why the bitmap dir was considered inconsistent, will push the diagnostic branch same as for bug 1191580;
2) the bitmap range setup error was not correctly returned to client, hence the assert failure.

tags: added: xtradb
Roel Van de Paar (roel11) wrote :

This bug was also seen a fair bit in QA 5.6 run, including in the special bp-split only feature test on 9/9/13.

mysqld: /bzr/5.6-QA_val/Percona-Server-5.6.12-rc60.4/sql/protocol.cc:518: void Protocol::end_statement(): Assertion `0' failed.

Agreed this to be another 'fix first' bug for 5.6 QA w/ Laurynas on 9/9.

tags: added: qablock
Roel Van de Paar (roel11) wrote :

Seen in latest iteration of QA-5.6 branch ( Percona-Server-5.6.13-rc60.5-431) also, though seemingly less then before. Adding an occurence

Roel Van de Paar (roel11) wrote :
Roel Van de Paar (roel11) wrote :
Roel Van de Paar (roel11) wrote :
Roel Van de Paar (roel11) wrote :
Roel Van de Paar (roel11) wrote :

Last example other bug as per input Laurynas. More research needed.

tags: removed: qablock
Roel Van de Paar (roel11) wrote :

qablock removed, original "inconsistent bitmap file directory" no longer visible ftm

Roel Van de Paar (roel11) wrote :

Example #2 stacks moved to bug 1168265

The

InnoDB: Error: inconsistent bitmap file directory for a INFORMATION_SCHEMA.INNODB_CHANGED_PAGES query

diagnostics is not a bug and expected if there are concurrent I_S.I_C_P and PURGE CHANGED_PAGE_BITMAPS ... queries.

summary: - InnoDB: Error: inconsistent bitmap file directory for a
- INFORMATION_SCHEMA.INNODB_CHANGED_PAGES query | mysqld-debug:
- .../sql/protocol.cc:518: void Protocol::end_statement(): Assertion `0'
- failed.
+ mysqld-debug: .../sql/protocol.cc:518: void Protocol::end_statement():
+ Assertion `0' failed on a INFORMATION_SCHEMA.INNODB_CHANGED_PAGES query.
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers