mysqld got signal 11 in plugin_foreach_with_mask on RESET CHANGED_PAGE_BITMAPS statement.

[Ramesh Sivaraman]

-------------- Server crash info

mysqld got signal 11 ;
(plugin_foreach_with_mask(THD*, char (*)(THD*, st_plugin_int**, void*), int, unsigned int, void*)+0x2d2)[0x7f5187]
(ha_purge_changed_page_bitmaps(unsigned long long)+0x2e)[0x6491a9]
(reload_acl_and_cache(THD*, unsigned long, TABLE_LIST*, int*)+0xacd)[0x807d41]
(mysql_execute_command(THD*)+0x5a5f)[0x7e4a3d]
(mysql_parse(THD*, char*, unsigned int, Parser_state*)+0x5a6)[0x7ea051]

-------------- gdb

+bt
#0 0x00007fb68ac3869c in pthread_kill () from /lib64/libpthread.so.0
#1 0x0000000000ab09a2 in my_write_core (sig=11) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/mysys/stacktrace.c:422
#2 0x000000000072ca03 in handle_fatal_signal (sig=11) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/sql/signal_handler.cc:236
#3 <signal handler called>
#4 0x0000000000b3ce59 in pfs_mutex_enter_func (mutex=0x200460, file_name=0x1040f50 "/mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/storage/innobase/log/log0online.cc", line=1801) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/storage/innobase/include/sync0sync.ic:360
#5 0x0000000000b4054f in log_online_purge_changed_page_bitmaps (lsn=18446744073709551615) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/storage/innobase/log/log0online.cc:1801
#6 0x0000000000aca1a1 in innobase_purge_changed_page_bitmaps (lsn=0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/storage/innobase/handler/ha_innodb.cc:3857
#7 0x0000000000649179 in purge_changed_page_bitmaps_handlerton (unused1=0x0, plugin=0x7fb5f17799a8, lsn=0x7fb5f17799f8) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/sql/handler.cc:7314
#8 0x00000000007f5187 in plugin_foreach_with_mask (thd=0x0, func=0x649128 <purge_changed_page_bitmaps_handlerton(THD*, plugin_ref, void*)>, type=1, state_mask=4294967287, arg=0x7fb5f17799f8) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/sql/sql_plugin.cc:2162
#9 0x00000000006491a9 in ha_purge_changed_page_bitmaps (lsn=0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/sql/handler.cc:7319
#10 0x0000000000807d41 in reload_acl_and_cache (thd=0x7fb653fdd000, options=8388608, tables=0x0, write_to_binlog=0x7fb5f177a71c) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/sql/sql_reload.cc:406
#11 0x00000000007e4a3d in mysql_execute_command (thd=0x7fb653fdd000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/sql/sql_parse.cc:4632
#12 0x00000000007ea051 in mysql_parse (thd=0x7fb653fdd000, rawbuf=0x7fb5f05a0010 "RESET CHANGED_PAGE_BITMAPS", length=26, parser_state=0x7fb5f177ac90) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/sql/sql_parse.cc:6744
#13 0x00000000007dc5ec in dispatch_command (command=COM_QUERY, thd=0x7fb653fdd000, packet=0x7fb653fed001 "RESET CHANGED_PAGE_BITMAPS", packet_length=26) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/sql/sql_parse.cc:1432
#14 0x00000000007db518 in do_command (thd=0x7fb653fdd000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/sql/sql_parse.cc:1049
#15 0x00000000008bf984 in threadpool_process_request (thd=0x7fb653fdd000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/sql/threadpool_common.cc:311
#16 0x00000000008c22c6 in handle_event (connection=0x7fb653bdad60) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/sql/threadpool_unix.cc:1553
#17 0x00000000008c24f6 in worker_main (param=0x188cc00) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/sql/threadpool_unix.cc:1606
#18 0x0000000000dbdbb8 in pfs_spawn_thread (arg=0x7fb5f3484020) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/storage/perfschema/pfs.cc:1860
#19 0x00007fb68ac33851 in start_thread () from /lib64/libpthread.so.0
#20 0x00007fb68999d94d in clone () from /lib64/libc.so.6
(gdb) +set logging off

------------------- SQL statements

SET @@GLOBAL.innodb_track_changed_pages=TRUE;
RESET CHANGED_PAGE_BITMAPS;

-------------------- Version
PS : Percona-Server-5.6.20-rel68.0-658.Linux.x86_64-debug

[Ramesh Sivaraman (rameshvs02)]

Fulll bundle with all files (core, gdb stacks, error log, vardir and more)

[Ramesh Sivaraman (rameshvs02)]

Reproduced with PS-5.5

mysql> select version();
+-------------------+
| version() |
+-------------------+
| 5.5.39-36.0-debug |
+-------------------+
1 row in set (0.00 sec)

mysql> SET @@GLOBAL.innodb_track_changed_pages=TRUE;
Query OK, 0 rows affected (0.00 sec)

mysql> RESET CHANGED_PAGE_BITMAPS;
ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql>

------------- error log.

Thread pointer: 0x2d3fa50
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 7f3a56acadc8 thread_stack 0x40000
/ssd/ramesh/ps55dbg/bin/mysqld(my_print_stacktrace+0x35)[0x803162]
/ssd/ramesh/ps55dbg/bin/mysqld(handle_fatal_signal+0x314)[0x6c3a7c]
/lib64/libpthread.so.0(+0xf130)[0x7f3a7521a130]
/ssd/ramesh/ps55dbg/bin/mysqld[0x866806]
/ssd/ramesh/ps55dbg/bin/mysqld[0x94fa61]
/ssd/ramesh/ps55dbg/bin/mysqld[0x80ca76]
/ssd/ramesh/ps55dbg/bin/mysqld[0x6c4546]
/ssd/ramesh/ps55dbg/bin/mysqld(_Z24plugin_foreach_with_maskP3THDPFcS0_PP13st_plugin_intPvEijS4_+0x2eb)[0x5b4dab]
/ssd/ramesh/ps55dbg/bin/mysqld(_Z29ha_purge_changed_page_bitmapsy+0x2b)[0x6c5299]
/ssd/ramesh/ps55dbg/bin/mysqld(_Z20reload_acl_and_cacheP3THDmP10TABLE_LISTPi+0xa2c)[0x67dbef]
/ssd/ramesh/ps55dbg/bin/mysqld(_Z21mysql_execute_commandP3THD+0x3824)[0x5a9457]
/ssd/ramesh/ps55dbg/bin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x225)[0x5ab71c]
/ssd/ramesh/ps55dbg/bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0xc4d)[0x5aceaf]
/ssd/ramesh/ps55dbg/bin/mysqld(_Z10do_commandP3THD+0x284)[0x5aebb3]
/ssd/ramesh/ps55dbg/bin/mysqld(_Z24do_handle_one_connectionP3THD+0x121)[0x65a89f]
/ssd/ramesh/ps55dbg/bin/mysqld(handle_one_connection+0x52)[0x65a99e]
/lib64/libpthread.so.0(+0x7df3)[0x7f3a75212df3]
/lib64/libc.so.6(clone+0x6d)[0x7f3a73aa101d]

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (7f3a48004bd0): RESET CHANGED_PAGE_BITMAPS
Connection ID (thread ID): 2
Status: NOT_KILLED