LP #1222625: InnoDB: Failing assertion: buf_pool->n_flush[BUF_FLUSH_LIST] == n_list_flush in file buf0buf.cc line 4716 | abort in buf_pool_validate_instance (sig=6)
Description
Environment
Smart Checklist
Activity
lpjirasync January 20, 2018 at 10:43 AM
**Comment from Launchpad by: Laurynas Biveinis on: 23-09-2013 05:09:29
Roel -
This current fix is in the trunk, and the bug itself was never present in the trunk. I believe "Invalid" is the correct status for this bug.
lpjirasync January 20, 2018 at 10:43 AM
**Comment from Launchpad by: Roel Van de Paar on: 23-09-2013 02:12:02
Ack. Will post here again if not.
Assume you will ensure all 5.6-QA fixes make it back to trunk also? Thanks
lpjirasync January 20, 2018 at 10:43 AM
**Comment from Launchpad by: Laurynas Biveinis on: 09-09-2013 05:19:45
Roel -
Should be fixed in rev 418.
lpjirasync January 20, 2018 at 10:43 AM
**Comment from Launchpad by: Roel Van de Paar on: 09-09-2013 02:24:19
From some more occurrences
3. buf_pool->n_flush[BUF_FLUSH_LIST] = 25 != n_list_flush = 23
Query (20a06fc0): UPDATE IGNORE `table100_innodb_dynamic_int` t1, `view_table100_innodb_dynamic_key_pk_parts_2_int_autoinc` t2 SET t1.`c7` = 4614500768194494464 WHERE t1.`c19` > '20010825204644.010189'
4. buf_pool->n_flush[BUF_FLUSH_LIST] = 37 != n_list_flush = 34
Query (21ccbb50): UPDATE `table500_innodb_default_int_autoinc` t1, `table500_innodb_default_int` t2 SET t1.`c14` = 17170255054326726656 WHERE t1.`c21` <> 'q'
5. buf_pool->n_flush[BUF_FLUSH_LIST] = 7 != n_list_flush = 5
No Query
6. buf_pool->n_flush[BUF_FLUSH_LIST] = 10 != n_list_flush = 9
Query (1b94ae10): OPTIMIZE LOCAL TABLE `table500_innodb_dynamic`
Adding qablock
lpjirasync January 20, 2018 at 10:43 AM
**Comment from Launchpad by: Roel Van de Paar on: 09-09-2013 02:10:59
Adding one more occurrence
Details
Assignee
UnassignedUnassignedReporter
lpjirasynclpjirasync(Deactivated)Priority
High
Details
Details
Assignee
Reporter
lpjirasyncPriority
HighSmart Checklist
Open Smart Checklist
Smart Checklist
Open Smart Checklist
Smart Checklist
**Reported in Launchpad by Roel Van de Paar last update 23-09-2013 05:09:36
buf_pool->n_flush[BUF_FLUSH_LIST] = 7 != n_list_flush = 6
2013-09-07 21:29:47 358e3700 InnoDB: Assertion failure in thread 898512640 in file buf0buf.cc line 4716
InnoDB: Failing assertion: buf_pool->n_flush[BUF_FLUSH_LIST] == n_list_flush
[...]
Query (347086c0): UPDATE LOW_PRIORITY IGNORE `table500_innodb_compressed_key_pk_parts_2_int` t1, `view_table100_innodb_compressed_int_autoinc` t2 SET t1.`c23` = NULL WHERE t1.`c22` > NULL
Connection ID (thread ID): 24
Status: NOT_KILLED
Thread 6 (LWP 25571):
+bt
#0 0x000000363720c69c in pthread_kill () from /lib64/libpthread.so.0
#1 0x00000000006f0cad in handle_fatal_signal (sig=6) at /bzr/5.6-QA_val/Percona-Server-5.6.12-rc60.4/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 0x0000000000b67b52 in buf_pool_validate_instance (buf_pool=0x9151c58) at /bzr/5.6-QA_val/Percona-Server-5.6.12-rc60.4/storage/innobase/buf/buf0buf.cc:4716
#6 0x0000000000b68114 in buf_validate () at /bzr/5.6-QA_val/Percona-Server-5.6.12-rc60.4/storage/innobase/buf/buf0buf.cc:4746
#7 0x0000000000b6c305 in buf_page_optimistic_get (rw_latch=1, block=0xad22fb8, modify_clock=70, file=0xdcf428 "/bzr/5.6-QA_val/Percona-Server-5.6.12-rc60.4/storage/innobase/row/row0mysql.cc", line=1858, mtr=0x358e0620) at /bzr/5.6-QA_val/Percona-Server-5.6.12-rc60.4/storage/innobase/buf/buf0buf.cc:3124
#8 0x0000000000b5a95d in btr_pcur_restore_position_func (latch_mode=1, cursor=0x343185b0, file=0xdcf428 "/bzr/5.6-QA_val/Percona-Server-5.6.12-rc60.4/storage/innobase/row/row0mysql.cc", line=1858, mtr=0x358e0620) at /bzr/5.6-QA_val/Percona-Server-5.6.12-rc60.4/storage/innobase/btr/btr0pcur.cc:284
#9 0x0000000000ac93f8 in row_unlock_for_mysql (prebuilt=0x34318538, has_latches_on_recs=0) at /bzr/5.6-QA_val/Percona-Server-5.6.12-rc60.4/storage/innobase/row/row0mysql.cc:1858
#10 0x0000000000a05547 in ha_innobase::unlock_row (this=0x33faee10) at /bzr/5.6-QA_val/Percona-Server-5.6.12-rc60.4/storage/innobase/handler/ha_innodb.cc:7586
#11 0x0000000000c46f0f in ha_partition::unlock_row (this=0x1392ba50) at /bzr/5.6-QA_val/Percona-Server-5.6.12-rc60.4/sql/ha_partition.cc:3779
#12 0x0000000000755f7a in evaluate_join_record (join=0x345f7508, join_tab=0x34cb2398) at /bzr/5.6-QA_val/Percona-Server-5.6.12-rc60.4/sql/sql_executor.cc:1652
#13 0x0000000000759121 in sub_select (join=0x345f7508, join_tab=0x34cb2398, end_of_records=<optimized out>) at /bzr/5.6-QA_val/Percona-Server-5.6.12-rc60.4/sql/sql_executor.cc:1273
#14 0x0000000000755db6 in evaluate_join_record (join=0x345f7508, join_tab=0x34cb2098) at /bzr/5.6-QA_val/Percona-Server-5.6.12-rc60.4/sql/sql_executor.cc:1598
#15 0x0000000000759121 in sub_select (join=0x345f7508, join_tab=0x34cb2098, end_of_records=<optimized out>) at /bzr/5.6-QA_val/Percona-Server-5.6.12-rc60.4/sql/sql_executor.cc:1273
#16 0x000000000075a213 in do_select (join=0x345f7508) at /bzr/5.6-QA_val/Percona-Server-5.6.12-rc60.4/sql/sql_executor.cc:930
#17 0x000000000075a938 in JOIN::exec (this=0x345f7508) at /bzr/5.6-QA_val/Percona-Server-5.6.12-rc60.4/sql/sql_executor.cc:191
#18 0x00000000007a3e08 in mysql_execute_select (thd=0x34a41810, select_lex=0x34a442e0, free_join=true) at /bzr/5.6-QA_val/Percona-Server-5.6.12-rc60.4/sql/sql_select.cc:1101
#19 0x00000000007a4564 in mysql_select (thd=0x34a41810, tables=0x34708988, wild_num=0, fields=..., conds=<optimized out>, order=0x0, group=0x0, having=0x0, select_options=1342177408, result=0x345f7438, unit=0x34a43c98, select_lex=0x34a442e0) at /bzr/5.6-QA_val/Percona-Server-5.6.12-rc60.4/sql/sql_select.cc:1222
#20 0x00000000007e67d7 in mysql_multi_update (thd=0x34a41810, table_list=0x34708988, fields=0x34a44400, values=0x34a44838, conds=0x34709910, options=0, handle_duplicates=DUP_ERROR, ignore=true, unit=0x34a43c98, select_lex=0x34a442e0, result=0x358e2180) at /bzr/5.6-QA_val/Percona-Server-5.6.12-rc60.4/sql/sql_update.cc:1527
#21 0x000000000077d594 in mysql_execute_command (thd=0x34a41810) at /bzr/5.6-QA_val/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:3577
#22 0x0000000000780108 in mysql_parse (thd=0x34a41810, rawbuf=0x34a41818 "@\344B\001", length=<optimized out>, parser_state=<optimized out>) at /bzr/5.6-QA_val/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477
#23 0x0000000000780c4d in dispatch_command (command=<optimized out>, thd=0x34a41810, packet=0x358e29e0 "\020\030\244\064", packet_length=<optimized out>) at /bzr/5.6-QA_val/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1355
#24 0x0000000000781985 in do_command (thd=0x34a41810) at /bzr/5.6-QA_val/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049
#25 0x000000000081f74f in threadpool_process_request (thd=0x34a41810) at /bzr/5.6-QA_val/Percona-Server-5.6.12-rc60.4/sql/threadpool_common.cc:312
#26 0x00000000008220a0 in handle_event (connection=0x19c2ba70) at /bzr/5.6-QA_val/Percona-Server-5.6.12-rc60.4/sql/threadpool_unix.cc:1466
#27 0x0000000000822168 in worker_main (param=0x1582000 <all_groups>) at /bzr/5.6-QA_val/Percona-Server-5.6.12-rc60.4/sql/threadpool_unix.cc:1519
#28 0x00000000009eaafa in pfs_spawn_thread (arg=0x13887d50) at /bzr/5.6-QA_val/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1858
#29 0x0000003637207851 in start_thread () from /lib64/libpthread.so.0
#30 0x0000003636ee890d in clone () from /lib64/libc.so.6