Percona Server moved to https://jira.percona.com/projects/PS

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

Bug #1191589 reported by Roel Van de Paar on 2013-06-16

This bug affects 1 person

	Status	Importance	Assigned to	Milestone
Percona Server moved to https://jira.percona.com/projects/PS	Fix Released	High	Laurynas Biveinis	Percona Server moved to https://jira.percona.com/projects/PS 5.6.13-61.0
5.1	Fix Released	High	Laurynas Biveinis	Percona Server moved to https://jira.percona.com/projects/PS 5.1.72-14.10
5.5	Fix Released	High	Laurynas Biveinis	Percona Server moved to https://jira.percona.com/projects/PS 5.5.34-32.0
5.6	Fix Released	High	Laurynas Biveinis	Percona Server moved to https://jira.percona.com/projects/PS 5.6.13-61.0

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

Tags:

Related branches

lp:~laurynas-biveinis/percona-server/bug1191580-1191589-5.1

Merged into lp:percona-server/5.1 at revision 591

Vlad Lesin (community): Approve (g2) on 2013-09-26

Registry Administrators: Pending requested 2013-09-25

lp:~laurynas-biveinis/percona-server/bug1191580-1191589-5.5

Merged into lp:percona-server/5.5 at revision 574

Vlad Lesin (community): Approve (g2) on 2013-09-26

Registry Administrators: Pending requested 2013-09-25

lp:~laurynas-biveinis/percona-server/bug1191580-1191589-5.6

Merged into lp:percona-server/5.6 at revision 432

Vlad Lesin (community): Approve on 2013-09-26

Registry Administrators: Pending requested 2013-09-25

Revision history for this message

Roel Van de Paar (roel11) wrote on 2013-06-16:

full mysqld error log Edit (2.1 MiB, text/plain)

Revision history for this message

Roel Van de Paar (roel11) wrote on 2013-06-16:

thread apply all bt on core Edit (113.0 KiB, text/plain)

Revision history for this message

Roel Van de Paar (roel11) wrote on 2013-06-16:

thread apply all bt full (with local vars) on core Edit (965.1 KiB, text/plain)

Revision history for this message

Roel Van de Paar (roel11) wrote on 2013-06-16:

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

Revision history for this message

Laurynas Biveinis (laurynas-biveinis) wrote on 2013-06-19:

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

Revision history for this message

Roel Van de Paar (roel11) wrote on 2013-09-09:

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.

Roel Van de Paar (roel11) on 2013-09-11

tags:

added: qablock

Revision history for this message

Roel Van de Paar (roel11) wrote on 2013-09-12:

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

Revision history for this message

Roel Van de Paar (roel11) wrote on 2013-09-12:

full mysqld error log Edit (6.7 KiB, text/plain)

Revision history for this message

Roel Van de Paar (roel11) wrote on 2013-09-12:

thread apply all bt on core Edit (43.7 KiB, text/plain)

Revision history for this message

Roel Van de Paar (roel11) wrote on 2013-09-12:

#10

thread apply all bt FULL on core Edit (136.6 KiB, text/plain)

Revision history for this message

Roel Van de Paar (roel11) wrote on 2013-09-12:

#11

Command used Edit (825 bytes, text/plain)

Revision history for this message

Roel Van de Paar (roel11) wrote on 2013-09-12:

#12

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

tags:

removed: qablock

Revision history for this message

Roel Van de Paar (roel11) wrote on 2013-09-12:

#13

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

Revision history for this message

Roel Van de Paar (roel11) wrote on 2013-09-12:

#14

Example #2 stacks moved to bug 1168265

Revision history for this message

Laurynas Biveinis (laurynas-biveinis) wrote on 2013-09-19:

#15

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.

Revision history for this message

Shahriyar Rzayev (rzayev-sehriyar) wrote on 2018-01-25:

#16

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

Report a bug

This report contains Public information

Everyone can see this information.

You are

Subscribing...

Edit bug mail

Other bug subscribers

Bug attachments

Add attachment

Remote bug watches

Bug watches keep track of this bug in other bug trackers.