Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

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

Description

**Reported in Launchpad by Roel Van de Paar last update 27-09-2013 05:02:21

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

Environment

None

Smart Checklist

Activity

lpjirasync January 20, 2018 at 5:33 PM

**Comment from Launchpad by: Laurynas Biveinis on: 19-09-2013 11:46:52

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.

lpjirasync January 20, 2018 at 5:33 PM

**Comment from Launchpad by: Roel Van de Paar on: 12-09-2013 09:40:39

Example #2 stacks moved to bug 1168265

lpjirasync January 20, 2018 at 5:32 PM

**Comment from Launchpad by: Roel Van de Paar on: 12-09-2013 09:36:49

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

lpjirasync January 20, 2018 at 5:32 PM

**Comment from Launchpad by: Roel Van de Paar on: 12-09-2013 09:36:09

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

lpjirasync January 20, 2018 at 5:32 PM

**Comment from Launchpad by: Roel Van de Paar on: 12-09-2013 09:22:13

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

Done

Details

Assignee

Reporter

Labels

Priority

Smart Checklist

Created January 20, 2018 at 5:31 PM
Updated January 20, 2018 at 5:33 PM
Resolved January 20, 2018 at 5:32 PM