-- built details cmake . -DWITH_DEBUG=1 -DWITH_BOOST=./boost -DCMAKE_INSTALL_PREFIX=/export/umesh/server/source/bugs/84173/5.7.17 time make -j16 make install && make clean rm -rf data bin/mysqld --initialize-insecure --basedir=/export/umesh/server/source/bugs/84173/5.7.17 --datadir=/export/umesh/server/source/bugs/84173/5.7.17 --innodb_log_file_size=1G --innodb_log_buffer_size=64M --innodb_flush_log_at_trx_commit=0 --innodb_flush_method=O_DIRECT --innodb_io_capacity=1000 --innodb_io_capacity_max=10000 --innodb_checksum_algorithm=strict_crc32 --innodb_purge_threads=8 --innodb_flush_neighbors=0 --innodb_change_buffer_max_size=5 --innodb_flush_log_at_trx_commit=2 --innodb_max_dirty_pages_pct=95 --innodb_sync_array_size=4 --innodb_monitor_enable="%" --innodb_buffer_pool_dump_pct=100 --innodb_open_files=1000 --innodb_max_purge_lag=1000000 --innodb_max_purge_lag_delay=10000 --innodb_undo_tablespaces=2 --innodb_undo_log_truncate=1 --performance_schema=off --server_id=1 --table_definition_cache=200000 --table_open_cache=200000 --table_open_cache_instances=1 -v bin/mysqld --no-defaults --basedir=/export/umesh/server/source/bugs/84173/5.7.17 --datadir=/export/umesh/server/source/bugs/84173/5.7.17 --core-file --socket=/tmp/mysql.sock --port=3306 --log-error=/export/umesh/server/source/bugs/84173/5.7.17/log.err --skip-external-locking --bind-address=127.0.0.1 --max_allowed_packet=16M --thread_stack=192K --thread_cache_size=8 --max_connections=4096 --expire_logs_days=1 --max_binlog_size=100M --innodb_buffer_pool_size=16G --innodb_log_file_size=1G --innodb_log_buffer_size=64M --innodb_flush_log_at_trx_commit=0 --innodb_flush_method=O_DIRECT --innodb_io_capacity=1000 --innodb_io_capacity_max=10000 --innodb_checksum_algorithm=strict_crc32 --innodb_purge_threads=8 --innodb_flush_neighbors=0 --innodb_change_buffer_max_size=5 --innodb_flush_log_at_trx_commit=2 --innodb_max_dirty_pages_pct=95 --innodb_sync_array_size=4 --innodb_monitor_enable="%" --innodb_buffer_pool_dump_pct=100 --innodb_open_files=1000 --innodb_max_purge_lag=1000000 --innodb_max_purge_lag_delay=10000 --innodb_undo_tablespaces=2 --innodb_undo_log_truncate=1 --performance_schema=off --server_id=1 --table_definition_cache=200000 --table_open_cache=200000 --table_open_cache_instances=1 2>&1 & -- 100k tables creations sysbench/sysbench --test=/home/umshastr/bugs/sysbench/sysbench/tests/db/oltp.lua --report-interval=1 --oltp-tables-count=100000 --oltp-table-size=100 --max-time=0 --oltp-read-only=off --max-requests=0 --num-threads=64 --rand-type=uniform --db-driver=mysql --mysql-user=root --mysql-db=test --mysql-socket=/tmp/mysql.sock prepare -- Initiate shutdown - first time [umshastr@hod03]/export/umesh/server/source/bugs/84173/5.7.17: bin/mysqladmin -uroot -S /tmp/mysql.sock shutdown -- excerpt from error log 2017-01-16T05:30:21.017602Z 0 [Note] Giving 0 client threads a chance to die gracefully 2017-01-16T05:30:21.017633Z 0 [Note] Shutting down slave threads 2017-01-16T05:30:21.017649Z 0 [Note] Forcefully disconnecting 0 remaining clients 2017-01-16T05:30:21.017665Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2017-01-16T05:30:21.017760Z 0 [Note] Binlog end 2017-01-16T05:32:42.981759Z 0 [Note] Shutting down plugin 'ngram' 2017-01-16T05:32:42.981815Z 0 [Note] Shutting down plugin 'partition' 2017-01-16T05:32:42.981828Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2017-01-16T05:32:42.981838Z 0 [Note] Shutting down plugin 'ARCHIVE' 2017-01-16T05:32:42.981844Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2017-01-16T05:32:42.981941Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2017-01-16T05:32:42.981958Z 0 [Note] Shutting down plugin 'MyISAM' 2017-01-16T05:32:42.981992Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2017-01-16T05:32:42.982001Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2017-01-16T05:32:42.982008Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2017-01-16T05:32:42.982015Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2017-01-16T05:32:42.982021Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2017-01-16T05:32:42.982030Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2017-01-16T05:32:42.982036Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2017-01-16T05:32:42.982041Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2017-01-16T05:32:42.982047Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2017-01-16T05:32:42.982052Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2017-01-16T05:32:42.982057Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2017-01-16T05:32:42.982066Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2017-01-16T05:32:42.982072Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2017-01-16T05:32:42.982078Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2017-01-16T05:32:42.982083Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2017-01-16T05:32:42.982089Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2017-01-16T05:32:42.982095Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2017-01-16T05:32:42.982103Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2017-01-16T05:32:42.982108Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2017-01-16T05:32:42.982113Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2017-01-16T05:32:42.982118Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2017-01-16T05:32:42.982123Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2017-01-16T05:32:42.982129Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2017-01-16T05:32:42.982134Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2017-01-16T05:32:42.982139Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2017-01-16T05:32:42.982145Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2017-01-16T05:32:42.982150Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2017-01-16T05:32:42.982162Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2017-01-16T05:32:42.982167Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2017-01-16T05:32:42.982173Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2017-01-16T05:32:42.982186Z 0 [Note] Shutting down plugin 'MEMORY' 2017-01-16T05:32:42.982194Z 0 [Note] Shutting down plugin 'CSV' 2017-01-16T05:32:42.982202Z 0 [Note] Shutting down plugin 'sha256_password' 2017-01-16T05:32:42.982207Z 0 [Note] Shutting down plugin 'mysql_native_password' 2017-01-16T05:32:42.982311Z 0 [Note] Shutting down plugin 'binlog' 2017-01-16T05:32:42.982326Z 0 [Note] Shutting down plugin 'InnoDB' 2017-01-16T05:32:42.982454Z 0 [Note] InnoDB: FTS optimize thread exiting. 2017-01-16T05:32:42.982544Z 0 [Note] InnoDB: Starting shutdown... 2017-01-16T05:32:43.082768Z 0 [Note] InnoDB: Dumping buffer pool(s) to /export/umesh/server/source/bugs/84173/5.7.17/ib_buffer_pool 2017-01-16T05:32:43.277277Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 170116 6:32:43 2017-01-16T05:45:21.699377Z 0 [Note] InnoDB: Shutdown completed; log sequence number 6106464386 2017-01-16T05:45:21.701698Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2017-01-16T05:45:21.739663Z 0 [Note] bin/mysqld: Shutdown complete -- pt-pmp [umshastr@hod03]~/bugs: ./pt-pmp --pid=19005 Mon Jan 16 06:32:23 CET 2017 10 __io_getevents_0_4(libaio.so.1),LinuxAIOHandler::collect(os0file.cc:2492),LinuxAIOHandler::poll(os0file.cc:2638),os_aio_linux_handler(os0file.cc:2694),os_aio_handler(os0file.cc:6246),fil_aio_wait(fil0fil.cc:5817),io_handler_thread(srv0start.cc:308),start_thread(libpthread.so.0),clone(libc.so.6) 7 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),srv_worker_thread(srv0srv.cc:2506),start_thread(libpthread.so.0),clone(libc.so.6) 3 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),buf_flush_page_cleaner_worker(buf0flu.cc:3496),start_thread(libpthread.so.0),clone(libc.so.6) 1 sigwaitinfo(libc.so.6),timer_notify_thread_func(posix_timers.c:77),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),sync_array_wait_event(sync0arr.cc:475),TTASEventMutex::wait(ut0mutex.ic:89),TTASEventMutex::spin_and_try_lock(ib0mutex.h:850),TTASEventMutex::enter(ib0mutex.h:707),PolicyMutex::enter(ib0mutex.h:987),dict_mutex_enter_for_mysql(dict0dict.cc:264),srv_master_evict_from_table_cache(srv0srv.cc:1970),srv_master_do_idle_tasks(srv0srv.cc:2216),srv_master_thread(srv0srv.cc:2371),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),srv_purge_coordinator_suspend(srv0srv.cc:2662),srv_purge_coordinator_thread(srv0srv.cc:2778),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),buf_resize_thread(buf0buf.cc:3015),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),buf_dump_thread(buf0dump.cc:781),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_timedwait,os_event::timed_wait(os0event.cc:285),os_event::wait_time_low(os0event.cc:412),os_event_wait_time_low(os0event.cc:517),srv_monitor_thread(srv0srv.cc:1571),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_timedwait,os_event::timed_wait(os0event.cc:285),os_event::wait_time_low(os0event.cc:412),os_event_wait_time_low(os0event.cc:517),srv_error_monitor_thread(srv0srv.cc:1737),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_timedwait,os_event::timed_wait(os0event.cc:285),os_event::wait_time_low(os0event.cc:412),os_event_wait_time_low(os0event.cc:517),pc_sleep_if_needed(buf0flu.cc:2690),buf_flush_page_cleaner_coordinator(buf0flu.cc:3191),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_timedwait,os_event::timed_wait(os0event.cc:285),os_event::wait_time_low(os0event.cc:412),os_event_wait_time_low(os0event.cc:517),lock_wait_timeout_thread(lock0wait.cc:501),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_timedwait,os_event::timed_wait(os0event.cc:285),os_event::wait_time_low(os0event.cc:412),os_event_wait_time_low(os0event.cc:517),ib_wqueue_timedwait(ut0wqueue.cc:160),fts_optimize_thread(fts0opt.cc:3040),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_timedwait,os_event::timed_wait(os0event.cc:285),os_event::wait_time_low(os0event.cc:412),os_event_wait_time_low(os0event.cc:517),dict_stats_thread(dict0stats_bg.cc:421),start_thread(libpthread.so.0),clone(libc.so.6) 1 dict_lru_validate(dict0dict.cc:6563),dict_table_close(dict0dict.cc:524),row_prebuilt_free(row0mysql.cc:1066),ha_innobase::close(ha_innodb.cc:6298),handler::ha_close(handler.cc:2826),closefrm(table.cc:3449),intern_close_table(sql_base.cc:1108),Table_cache::free_all_unused_tables(table_cache.cc:160),Table_cache_manager::free_all_unused_tables(table_cache.cc:395),close_cached_tables(sql_base.cc:1177),table_def_start_shutdown(sql_base.cc:578),clean_up(mysqld.cc:1303),mysqld_main(mysqld.cc:5099),main(main.cc:25) [umshastr@hod03]~/bugs: ./pt-pmp --pid=19005 Mon Jan 16 06:38:05 CET 2017 1 sigwaitinfo(libc.so.6),timer_notify_thread_func(posix_timers.c:77),start_thread(libpthread.so.0),clone(libc.so.6) 1 dict_lru_find_table(dict0dict.cc:6590),dict_table_remove_from_cache_low(dict0dict.cc:2177),dict_table_remove_from_cache(dict0dict.cc:2235),dict_close(dict0dict.cc:6514),innobase_shutdown_for_mysql(srv0start.cc:2739),innobase_end(ha_innodb.cc:4100),ha_finalize_handlerton(handler.cc:781),plugin_deinitialize(sql_plugin.cc:999),reap_plugins(sql_plugin.cc:1081),plugin_shutdown(sql_plugin.cc:1849),clean_up(mysqld.cc:1304),mysqld_main(mysqld.cc:5099),main(main.cc:25) -- Start up - first time bin/mysqld --no-defaults --basedir=/export/umesh/server/source/bugs/84173/5.7.17 --datadir=/export/umesh/server/source/bugs/84173/5.7.17/data --core-file --socket=/tmp/mysql_master.sock --port=3306 --log-error=/export/umesh/server/source/bugs/84173/5.7.17/data/log.err --skip-external-locking --bind-address=127.0.0.1 --max_allowed_packet=16M --thread_stack=192K --thread_cache_size=8 --max_connections=4096 --expire_logs_days=1 --max_binlog_size=100M --innodb_buffer_pool_size=16G --innodb_log_file_size=1G --innodb_log_buffer_size=64M --innodb_flush_log_at_trx_commit=0 --innodb_flush_method=O_DIRECT --innodb_io_capacity=1000 --innodb_io_capacity_max=10000 --innodb_checksum_algorithm=strict_crc32 --innodb_purge_threads=8 --innodb_flush_neighbors=0 --innodb_change_buffer_max_size=5 --innodb_flush_log_at_trx_commit=2 --innodb_max_dirty_pages_pct=95 --innodb_sync_array_size=4 --innodb_monitor_enable="%" --innodb_buffer_pool_dump_pct=100 --innodb_open_files=1000 --innodb_max_purge_lag=1000000 --innodb_max_purge_lag_delay=10000 --innodb_undo_tablespaces=2 --innodb_undo_log_truncate=1 --performance_schema=off --server_id=1 --table_definition_cache=200000 --table_open_cache=200000 --table_open_cache_instances=1 2>&1 & -- excerpt from error log 2017-01-16T05:51:25.562187Z 0 [Note] InnoDB: Opened 2 undo tablespaces 2017-01-16T05:51:25.562205Z 0 [Note] InnoDB: 2 undo tablespaces made active 2017-01-16T05:51:25.562771Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2017-01-16T05:54:55.972464Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2017-01-16T05:54:55.972569Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2017-01-16T05:54:55.994143Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2017-01-16T05:54:56.030591Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2017-01-16T05:54:56.030634Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2017-01-16T05:54:56.188028Z 0 [Note] InnoDB: Waiting for purge to start 2017-01-16T05:54:56.238198Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 210691ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.) 2017-01-16T05:54:56.238288Z 0 [Note] InnoDB: 5.7.17 started; log sequence number 6106464386 2017-01-16T05:54:56.238506Z 0 [Note] InnoDB: Loading buffer pool(s) from /export/umesh/server/source/bugs/84173/5.7.17/ib_buffer_pool 2017-01-16T05:54:56.239181Z 0 [Note] Plugin 'FEDERATED' is disabled. 2017-01-16T05:54:56.912035Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2017-01-16T05:54:56.912081Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 2017-01-16T05:54:56.912122Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 2017-01-16T05:54:56.912149Z 0 [Note] Server socket created on IP: '127.0.0.1'. 2017-01-16T05:54:58.385348Z 0 [Note] Event Scheduler: Loaded 0 events 2017-01-16T05:54:58.385585Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check. 2017-01-16T05:54:58.385598Z 0 [Note] Beginning of list of non-natively partitioned tables 2017-01-16T05:56:22.074055Z 0 [Note] End of list of non-natively partitioned tables 2017-01-16T05:56:22.074362Z 0 [Note] bin/mysqld: ready for connections. Version: '5.7.17-debug' socket: '/tmp/mysql.sock' port: 3306 Source distribution -- pt-pmp [umshastr@hod03]~/bugs: ./pt-pmp --pid=12171 Mon Jan 16 06:51:47 CET 2017 10 __io_getevents_0_4(libaio.so.1),LinuxAIOHandler::collect(os0file.cc:2492),LinuxAIOHandler::poll(os0file.cc:2638),os_aio_linux_handler(os0file.cc:2694),os_aio_handler(os0file.cc:6246),fil_aio_wait(fil0fil.cc:5817),io_handler_thread(srv0start.cc:308),start_thread(libpthread.so.0),clone(libc.so.6) 3 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),buf_flush_page_cleaner_worker(buf0flu.cc:3496),start_thread(libpthread.so.0),clone(libc.so.6) 1 sigwaitinfo(libc.so.6),timer_notify_thread_func(posix_timers.c:77),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),buf_flush_page_cleaner_coordinator(buf0flu.cc:3172),start_thread(libpthread.so.0),clone(libc.so.6) 1 MutexDebug(libc.so.6),GenericPolicy::locked(sync0policy.h:360),PolicyMutex::trylock(ib0mutex.h:1020),rw_lock_debug_mutex_enter(sync0debug.cc:1300),rw_lock_add_debug_info(sync0rw.cc:980),rw_lock_s_lock_low(sync0rw.ic:389),pfs_rw_lock_s_lock_low(sync0rw.ic:873),buf_page_optimistic_get(buf0buf.cc:4712),btr_cur_optimistic_latch_leaves(btr0cur.cc:428),btr_pcur_restore_position_func(btr0pcur.cc:289),dict_getnext_system(dict0load.cc:289),dict_check_sys_tablespaces(dict0load.cc:1173),dict_check_tablespaces_and_store_max_id(dict0load.cc:1520),innobase_start_or_create_for_mysql(srv0start.cc:2288),innobase_init(ha_innodb.cc:3989),ha_initialize_handlerton(handler.cc:838),plugin_initialize(sql_plugin.cc:1197),plugin_init(sql_plugin.cc:1539),init_server_components(mysqld.cc:4036),mysqld_main(mysqld.cc:4673),main(main.cc:25) [umshastr@hod03]~/bugs: [umshastr@hod03]~/bugs: ./pt-pmp --pid=12171 Mon Jan 16 06:51:53 CET 2017 10 __io_getevents_0_4(libaio.so.1),LinuxAIOHandler::collect(os0file.cc:2492),LinuxAIOHandler::poll(os0file.cc:2638),os_aio_linux_handler(os0file.cc:2694),os_aio_handler(os0file.cc:6246),fil_aio_wait(fil0fil.cc:5817),io_handler_thread(srv0start.cc:308),start_thread(libpthread.so.0),clone(libc.so.6) 3 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),buf_flush_page_cleaner_worker(buf0flu.cc:3496),start_thread(libpthread.so.0),clone(libc.so.6) 1 sigwaitinfo(libc.so.6),timer_notify_thread_func(posix_timers.c:77),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),buf_flush_page_cleaner_coordinator(buf0flu.cc:3172),start_thread(libpthread.so.0),clone(libc.so.6) 1 buf_page_get_state(buf0buf.ic:221),buf_LRU_validate_instance(buf0lru.cc:2670),buf_LRU_validate(buf0lru.cc:2698),buf_pool_validate_instance(buf0buf.cc:6244),buf_validate(buf0buf.cc:6264),buf_page_optimistic_get(buf0buf.cc:4754),btr_cur_optimistic_latch_leaves(btr0cur.cc:428),btr_pcur_restore_position_func(btr0pcur.cc:289),dict_getnext_system(dict0load.cc:289),dict_check_sys_tablespaces(dict0load.cc:1173),dict_check_tablespaces_and_store_max_id(dict0load.cc:1520),innobase_start_or_create_for_mysql(srv0start.cc:2288),innobase_init(ha_innodb.cc:3989),ha_initialize_handlerton(handler.cc:838),plugin_initialize(sql_plugin.cc:1197),plugin_init(sql_plugin.cc:1539),init_server_components(mysqld.cc:4036),mysqld_main(mysqld.cc:4673),main(main.cc:25) [umshastr@hod03]~/bugs: [umshastr@hod03]~/bugs: ./pt-pmp --pid=12171 Mon Jan 16 06:51:59 CET 2017 10 __io_getevents_0_4(libaio.so.1),LinuxAIOHandler::collect(os0file.cc:2492),LinuxAIOHandler::poll(os0file.cc:2638),os_aio_linux_handler(os0file.cc:2694),os_aio_handler(os0file.cc:6246),fil_aio_wait(fil0fil.cc:5817),io_handler_thread(srv0start.cc:308),start_thread(libpthread.so.0),clone(libc.so.6) 3 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),buf_flush_page_cleaner_worker(buf0flu.cc:3496),start_thread(libpthread.so.0),clone(libc.so.6) 1 sigwaitinfo(libc.so.6),timer_notify_thread_func(posix_timers.c:77),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),buf_flush_page_cleaner_coordinator(buf0flu.cc:3172),start_thread(libpthread.so.0),clone(libc.so.6) 1 CheckInFreeList::operator(buf0buf.h:2451),ut_list_mapbuf_page_t::*>,CheckInFreeList>(ut0lst.h:409),ut_list_validatebuf_page_t::*>,CheckInFreeList>(ut0lst.h:442),CheckInFreeList::validate(buf0buf.h:2457),buf_LRU_validate_instance(buf0lru.cc:2664),buf_LRU_validate(buf0lru.cc:2698),buf_pool_validate_instance(buf0buf.cc:6244),buf_validate(buf0buf.cc:6264),buf_page_optimistic_get(buf0buf.cc:4754),btr_cur_optimistic_latch_leaves(btr0cur.cc:428),btr_pcur_restore_position_func(btr0pcur.cc:289),dict_getnext_system(dict0load.cc:289),dict_check_sys_tablespaces(dict0load.cc:1173),dict_check_tablespaces_and_store_max_id(dict0load.cc:1520),innobase_start_or_create_for_mysql(srv0start.cc:2288),innobase_init(ha_innodb.cc:3989),ha_initialize_handlerton(handler.cc:838),plugin_initialize(sql_plugin.cc:1197),plugin_init(sql_plugin.cc:1539),init_server_components(mysqld.cc:4036),mysqld_main(mysqld.cc:4673),main(main.cc:25) [umshastr@hod03]~/bugs: [umshastr@hod03]~/bugs: ./pt-pmp --pid=12171 Mon Jan 16 06:52:06 CET 2017 10 __io_getevents_0_4(libaio.so.1),LinuxAIOHandler::collect(os0file.cc:2492),LinuxAIOHandler::poll(os0file.cc:2638),os_aio_linux_handler(os0file.cc:2694),os_aio_handler(os0file.cc:6246),fil_aio_wait(fil0fil.cc:5817),io_handler_thread(srv0start.cc:308),start_thread(libpthread.so.0),clone(libc.so.6) 3 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),buf_flush_page_cleaner_worker(buf0flu.cc:3496),start_thread(libpthread.so.0),clone(libc.so.6) 1 ut_list_validatebuf_page_t::*>,CheckInFreeList>(ut0lst.h:447),CheckInFreeList::validate(buf0buf.h:2457),buf_LRU_validate_instance(buf0lru.cc:2664),buf_LRU_validate(buf0lru.cc:2698),buf_pool_validate_instance(buf0buf.cc:6244),buf_validate(buf0buf.cc:6264),buf_page_optimistic_get(buf0buf.cc:4754),btr_cur_optimistic_latch_leaves(btr0cur.cc:428),btr_pcur_restore_position_func(btr0pcur.cc:289),dict_getnext_system(dict0load.cc:289),dict_check_sys_tablespaces(dict0load.cc:1173),dict_check_tablespaces_and_store_max_id(dict0load.cc:1520),innobase_start_or_create_for_mysql(srv0start.cc:2288),innobase_init(ha_innodb.cc:3989),ha_initialize_handlerton(handler.cc:838),plugin_initialize(sql_plugin.cc:1197),plugin_init(sql_plugin.cc:1539),init_server_components(mysqld.cc:4036),mysqld_main(mysqld.cc:4673),main(main.cc:25) 1 sigwaitinfo(libc.so.6),timer_notify_thread_func(posix_timers.c:77),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),buf_flush_page_cleaner_coordinator(buf0flu.cc:3172),start_thread(libpthread.so.0),clone(libc.so.6) [umshastr@hod03]~/bugs: [umshastr@hod03]~/bugs: ./pt-pmp --pid=12171 Mon Jan 16 06:52:13 CET 2017 10 __io_getevents_0_4(libaio.so.1),LinuxAIOHandler::collect(os0file.cc:2492),LinuxAIOHandler::poll(os0file.cc:2638),os_aio_linux_handler(os0file.cc:2694),os_aio_handler(os0file.cc:6246),fil_aio_wait(fil0fil.cc:5817),io_handler_thread(srv0start.cc:308),start_thread(libpthread.so.0),clone(libc.so.6) 3 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),buf_flush_page_cleaner_worker(buf0flu.cc:3496),start_thread(libpthread.so.0),clone(libc.so.6) 1 ut_list_validatebuf_page_t::*>,CheckInFreeList>(ut0lst.h:447),CheckInFreeList::validate(buf0buf.h:2457),buf_LRU_validate_instance(buf0lru.cc:2664),buf_LRU_validate(buf0lru.cc:2698),buf_pool_validate_instance(buf0buf.cc:6244),buf_validate(buf0buf.cc:6264),buf_page_optimistic_get(buf0buf.cc:4754),btr_cur_optimistic_latch_leaves(btr0cur.cc:428),btr_pcur_restore_position_func(btr0pcur.cc:289),dict_getnext_system(dict0load.cc:289),dict_check_sys_tablespaces(dict0load.cc:1173),dict_check_tablespaces_and_store_max_id(dict0load.cc:1520),innobase_start_or_create_for_mysql(srv0start.cc:2288),innobase_init(ha_innodb.cc:3989),ha_initialize_handlerton(handler.cc:838),plugin_initialize(sql_plugin.cc:1197),plugin_init(sql_plugin.cc:1539),init_server_components(mysqld.cc:4036),mysqld_main(mysqld.cc:4673),main(main.cc:25) 1 sigwaitinfo(libc.so.6),timer_notify_thread_func(posix_timers.c:77),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),buf_flush_page_cleaner_coordinator(buf0flu.cc:3172),start_thread(libpthread.so.0),clone(libc.so.6) [umshastr@hod03]~/bugs: [umshastr@hod03]~/bugs: ./pt-pmp --pid=12171 Mon Jan 16 06:52:19 CET 2017 10 __io_getevents_0_4(libaio.so.1),LinuxAIOHandler::collect(os0file.cc:2492),LinuxAIOHandler::poll(os0file.cc:2638),os_aio_linux_handler(os0file.cc:2694),os_aio_handler(os0file.cc:6246),fil_aio_wait(fil0fil.cc:5817),io_handler_thread(srv0start.cc:308),start_thread(libpthread.so.0),clone(libc.so.6) 3 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),buf_flush_page_cleaner_worker(buf0flu.cc:3496),start_thread(libpthread.so.0),clone(libc.so.6) 1 sigwaitinfo(libc.so.6),timer_notify_thread_func(posix_timers.c:77),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),buf_flush_page_cleaner_coordinator(buf0flu.cc:3172),start_thread(libpthread.so.0),clone(libc.so.6) 1 PolicyMutex(libc.so.6),buf_pool_validate_instance(buf0buf.cc:6128),buf_validate(buf0buf.cc:6264),buf_page_optimistic_get(buf0buf.cc:4754),btr_cur_optimistic_latch_leaves(btr0cur.cc:428),btr_pcur_restore_position_func(btr0pcur.cc:289),dict_getnext_system(dict0load.cc:289),dict_check_sys_tablespaces(dict0load.cc:1173),dict_check_tablespaces_and_store_max_id(dict0load.cc:1520),innobase_start_or_create_for_mysql(srv0start.cc:2288),innobase_init(ha_innodb.cc:3989),ha_initialize_handlerton(handler.cc:838),plugin_initialize(sql_plugin.cc:1197),plugin_init(sql_plugin.cc:1539),init_server_components(mysqld.cc:4036),mysqld_main(mysqld.cc:4673),main(main.cc:25) [umshastr@hod03]~/bugs: [umshastr@hod03]~/bugs: ./pt-pmp --pid=12171 Mon Jan 16 06:52:40 CET 2017 10 __io_getevents_0_4(libaio.so.1),LinuxAIOHandler::collect(os0file.cc:2492),LinuxAIOHandler::poll(os0file.cc:2638),os_aio_linux_handler(os0file.cc:2694),os_aio_handler(os0file.cc:6246),fil_aio_wait(fil0fil.cc:5817),io_handler_thread(srv0start.cc:308),start_thread(libpthread.so.0),clone(libc.so.6) 3 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),buf_flush_page_cleaner_worker(buf0flu.cc:3496),start_thread(libpthread.so.0),clone(libc.so.6) 1 ut_list_validatebuf_page_t::*>,CheckInFreeList>(ut0lst.h:447),CheckInFreeList::validate(buf0buf.h:2457),buf_LRU_validate_instance(buf0lru.cc:2664),buf_LRU_validate(buf0lru.cc:2698),buf_pool_validate_instance(buf0buf.cc:6244),buf_validate(buf0buf.cc:6264),buf_page_optimistic_get(buf0buf.cc:4754),btr_cur_optimistic_latch_leaves(btr0cur.cc:428),btr_pcur_restore_position_func(btr0pcur.cc:289),dict_getnext_system(dict0load.cc:289),dict_check_sys_tables(dict0load.cc:1358),dict_check_tablespaces_and_store_max_id(dict0load.cc:1525),innobase_start_or_create_for_mysql(srv0start.cc:2288),innobase_init(ha_innodb.cc:3989),ha_initialize_handlerton(handler.cc:838),plugin_initialize(sql_plugin.cc:1197),plugin_init(sql_plugin.cc:1539),init_server_components(mysqld.cc:4036),mysqld_main(mysqld.cc:4673),main(main.cc:25) 1 sigwaitinfo(libc.so.6),timer_notify_thread_func(posix_timers.c:77),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),buf_flush_page_cleaner_coordinator(buf0flu.cc:3172),start_thread(libpthread.so.0),clone(libc.so.6) [umshastr@hod03]~/bugs: [umshastr@hod03]~/bugs: ./pt-pmp --pid=12171 Mon Jan 16 06:52:47 CET 2017 10 __io_getevents_0_4(libaio.so.1),LinuxAIOHandler::collect(os0file.cc:2492),LinuxAIOHandler::poll(os0file.cc:2638),os_aio_linux_handler(os0file.cc:2694),os_aio_handler(os0file.cc:6246),fil_aio_wait(fil0fil.cc:5817),io_handler_thread(srv0start.cc:308),start_thread(libpthread.so.0),clone(libc.so.6) 3 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),buf_flush_page_cleaner_worker(buf0flu.cc:3496),start_thread(libpthread.so.0),clone(libc.so.6) 1 sigwaitinfo(libc.so.6),timer_notify_thread_func(posix_timers.c:77),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),buf_flush_page_cleaner_coordinator(buf0flu.cc:3172),start_thread(libpthread.so.0),clone(libc.so.6) 1 CheckInFreeList::operator(buf0buf.h:2451),ut_list_mapbuf_page_t::*>,CheckInFreeList>(ut0lst.h:409),ut_list_validatebuf_page_t::*>,CheckInFreeList>(ut0lst.h:442),CheckInFreeList::validate(buf0buf.h:2457),buf_LRU_validate_instance(buf0lru.cc:2664),buf_LRU_validate(buf0lru.cc:2698),buf_pool_validate_instance(buf0buf.cc:6244),buf_validate(buf0buf.cc:6264),buf_page_optimistic_get(buf0buf.cc:4754),btr_cur_optimistic_latch_leaves(btr0cur.cc:428),btr_pcur_restore_position_func(btr0pcur.cc:289),dict_getnext_system(dict0load.cc:289),dict_check_sys_tables(dict0load.cc:1358),dict_check_tablespaces_and_store_max_id(dict0load.cc:1525),innobase_start_or_create_for_mysql(srv0start.cc:2288),innobase_init(ha_innodb.cc:3989),ha_initialize_handlerton(handler.cc:838),plugin_initialize(sql_plugin.cc:1197),plugin_init(sql_plugin.cc:1539),init_server_components(mysqld.cc:4036),mysqld_main(mysqld.cc:4673),main(main.cc:25) [umshastr@hod03]~/bugs: [umshastr@hod03]~/bugs: ./pt-pmp --pid=12171 Mon Jan 16 06:52:53 CET 2017 10 __io_getevents_0_4(libaio.so.1),LinuxAIOHandler::collect(os0file.cc:2492),LinuxAIOHandler::poll(os0file.cc:2638),os_aio_linux_handler(os0file.cc:2694),os_aio_handler(os0file.cc:6246),fil_aio_wait(fil0fil.cc:5817),io_handler_thread(srv0start.cc:308),start_thread(libpthread.so.0),clone(libc.so.6) 3 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),buf_flush_page_cleaner_worker(buf0flu.cc:3496),start_thread(libpthread.so.0),clone(libc.so.6) 1 sigwaitinfo(libc.so.6),timer_notify_thread_func(posix_timers.c:77),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),buf_flush_page_cleaner_coordinator(buf0flu.cc:3172),start_thread(libpthread.so.0),clone(libc.so.6) 1 buf_page_get_state(buf0buf.ic:221),buf_LRU_validate_instance(buf0lru.cc:2670),buf_LRU_validate(buf0lru.cc:2698),buf_pool_validate_instance(buf0buf.cc:6244),buf_validate(buf0buf.cc:6264),buf_page_optimistic_get(buf0buf.cc:4754),btr_cur_optimistic_latch_leaves(btr0cur.cc:428),btr_pcur_restore_position_func(btr0pcur.cc:289),dict_getnext_system(dict0load.cc:289),dict_check_sys_tables(dict0load.cc:1358),dict_check_tablespaces_and_store_max_id(dict0load.cc:1525),innobase_start_or_create_for_mysql(srv0start.cc:2288),innobase_init(ha_innodb.cc:3989),ha_initialize_handlerton(handler.cc:838),plugin_initialize(sql_plugin.cc:1197),plugin_init(sql_plugin.cc:1539),init_server_components(mysqld.cc:4036),mysqld_main(mysqld.cc:4673),main(main.cc:25) [umshastr@hod03]~/bugs: [umshastr@hod03]~/bugs: ./pt-pmp --pid=12171 Mon Jan 16 06:53:00 CET 2017 10 __io_getevents_0_4(libaio.so.1),LinuxAIOHandler::collect(os0file.cc:2492),LinuxAIOHandler::poll(os0file.cc:2638),os_aio_linux_handler(os0file.cc:2694),os_aio_handler(os0file.cc:6246),fil_aio_wait(fil0fil.cc:5817),io_handler_thread(srv0start.cc:308),start_thread(libpthread.so.0),clone(libc.so.6) 3 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),buf_flush_page_cleaner_worker(buf0flu.cc:3496),start_thread(libpthread.so.0),clone(libc.so.6) 1 sigwaitinfo(libc.so.6),timer_notify_thread_func(posix_timers.c:77),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),buf_flush_page_cleaner_coordinator(buf0flu.cc:3172),start_thread(libpthread.so.0),clone(libc.so.6) 1 buf_page_get_state(buf0buf.ic:221),buf_LRU_validate_instance(buf0lru.cc:2670),buf_LRU_validate(buf0lru.cc:2698),buf_pool_validate_instance(buf0buf.cc:6244),buf_validate(buf0buf.cc:6264),buf_page_get_known_nowait(buf0buf.cc:4862),btr_search_guess_on_hash(btr0sea.cc:1030),btr_cur_search_to_nth_level(btr0cur.cc:928),btr_pcur_open_low(btr0pcur.ic:465),btr_pcur_open_on_user_rec_func(btr0pcur.cc:603),dict_get_first_path(dict0load.cc:775),dict_check_sys_tables(dict0load.cc:1449),dict_check_tablespaces_and_store_max_id(dict0load.cc:1525),innobase_start_or_create_for_mysql(srv0start.cc:2288),innobase_init(ha_innodb.cc:3989),ha_initialize_handlerton(handler.cc:838),plugin_initialize(sql_plugin.cc:1197),plugin_init(sql_plugin.cc:1539),init_server_components(mysqld.cc:4036),mysqld_main(mysqld.cc:4673),main(main.cc:25) [umshastr@hod03]~/bugs: [umshastr@hod03]~/bugs: ./pt-pmp --pid=12171 Mon Jan 16 06:53:09 CET 2017 10 __io_getevents_0_4(libaio.so.1),LinuxAIOHandler::collect(os0file.cc:2492),LinuxAIOHandler::poll(os0file.cc:2638),os_aio_linux_handler(os0file.cc:2694),os_aio_handler(os0file.cc:6246),fil_aio_wait(fil0fil.cc:5817),io_handler_thread(srv0start.cc:308),start_thread(libpthread.so.0),clone(libc.so.6) 3 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),buf_flush_page_cleaner_worker(buf0flu.cc:3496),start_thread(libpthread.so.0),clone(libc.so.6) 1 std::_Rb_tree::_M_lower_bound(stl_tree.h:1140),std::_Rb_tree::find(stl_tree.h:1792),std::map::find(stl_map.h:822),ut_new_get_key_by_file(ut0new.cc:218),ut_allocator::get_mem_key(ut0new.h:663),ut_allocator::allocate_trace(ut0new.h:714),ut_allocator::allocate(ut0new.h:379),mem_heap_create_block_func(mem0mem.cc:302),mem_heap_create_func(mem0mem.ic:493),btr_pcur_restore_position_func(btr0pcur.cc:306),dict_getnext_system(dict0load.cc:289),dict_check_sys_tables(dict0load.cc:1358),dict_check_tablespaces_and_store_max_id(dict0load.cc:1525),innobase_start_or_create_for_mysql(srv0start.cc:2288),innobase_init(ha_innodb.cc:3989),ha_initialize_handlerton(handler.cc:838),plugin_initialize(sql_plugin.cc:1197),plugin_init(sql_plugin.cc:1539),init_server_components(mysqld.cc:4036),mysqld_main(mysqld.cc:4673),main(main.cc:25) 1 sigwaitinfo(libc.so.6),timer_notify_thread_func(posix_timers.c:77),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),buf_flush_page_cleaner_coordinator(buf0flu.cc:3172),start_thread(libpthread.so.0),clone(libc.so.6) [umshastr@hod03]~/bugs: [umshastr@hod03]~/bugs: [umshastr@hod03]~/bugs: ./pt-pmp --pid=12171 Mon Jan 16 06:53:17 CET 2017 10 __io_getevents_0_4(libaio.so.1),LinuxAIOHandler::collect(os0file.cc:2492),LinuxAIOHandler::poll(os0file.cc:2638),os_aio_linux_handler(os0file.cc:2694),os_aio_handler(os0file.cc:6246),fil_aio_wait(fil0fil.cc:5817),io_handler_thread(srv0start.cc:308),start_thread(libpthread.so.0),clone(libc.so.6) 3 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),buf_flush_page_cleaner_worker(buf0flu.cc:3496),start_thread(libpthread.so.0),clone(libc.so.6) 1 ut_list_validatebuf_page_t::*>,CheckInFreeList>(ut0lst.h:447),CheckInFreeList::validate(buf0buf.h:2457),buf_LRU_validate_instance(buf0lru.cc:2664),buf_LRU_validate(buf0lru.cc:2698),buf_pool_validate_instance(buf0buf.cc:6244),buf_validate(buf0buf.cc:6264),buf_page_get_known_nowait(buf0buf.cc:4862),btr_search_guess_on_hash(btr0sea.cc:1030),btr_cur_search_to_nth_level(btr0cur.cc:928),btr_pcur_open_low(btr0pcur.ic:465),btr_pcur_open_on_user_rec_func(btr0pcur.cc:603),dict_get_first_path(dict0load.cc:775),dict_check_sys_tables(dict0load.cc:1449),dict_check_tablespaces_and_store_max_id(dict0load.cc:1525),innobase_start_or_create_for_mysql(srv0start.cc:2288),innobase_init(ha_innodb.cc:3989),ha_initialize_handlerton(handler.cc:838),plugin_initialize(sql_plugin.cc:1197),plugin_init(sql_plugin.cc:1539),init_server_components(mysqld.cc:4036),mysqld_main(mysqld.cc:4673),main(main.cc:25) 1 sigwaitinfo(libc.so.6),timer_notify_thread_func(posix_timers.c:77),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),buf_flush_page_cleaner_coordinator(buf0flu.cc:3172),start_thread(libpthread.so.0),clone(libc.so.6) [umshastr@hod03]~/bugs: [umshastr@hod03]~/bugs: ./pt-pmp --pid=12171 Mon Jan 16 06:53:25 CET 2017 10 __io_getevents_0_4(libaio.so.1),LinuxAIOHandler::collect(os0file.cc:2492),LinuxAIOHandler::poll(os0file.cc:2638),os_aio_linux_handler(os0file.cc:2694),os_aio_handler(os0file.cc:6246),fil_aio_wait(fil0fil.cc:5817),io_handler_thread(srv0start.cc:308),start_thread(libpthread.so.0),clone(libc.so.6) 3 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),buf_flush_page_cleaner_worker(buf0flu.cc:3496),start_thread(libpthread.so.0),clone(libc.so.6) 1 ut_list_validatebuf_page_t::*>,CheckInFreeList>(ut0lst.h:447),CheckInFreeList::validate(buf0buf.h:2457),buf_LRU_validate_instance(buf0lru.cc:2664),buf_LRU_validate(buf0lru.cc:2698),buf_pool_validate_instance(buf0buf.cc:6244),buf_validate(buf0buf.cc:6264),buf_page_get_known_nowait(buf0buf.cc:4862),btr_search_guess_on_hash(btr0sea.cc:1030),btr_cur_search_to_nth_level(btr0cur.cc:928),btr_pcur_open_low(btr0pcur.ic:465),btr_pcur_open_on_user_rec_func(btr0pcur.cc:603),dict_get_first_path(dict0load.cc:775),dict_check_sys_tables(dict0load.cc:1449),dict_check_tablespaces_and_store_max_id(dict0load.cc:1525),innobase_start_or_create_for_mysql(srv0start.cc:2288),innobase_init(ha_innodb.cc:3989),ha_initialize_handlerton(handler.cc:838),plugin_initialize(sql_plugin.cc:1197),plugin_init(sql_plugin.cc:1539),init_server_components(mysqld.cc:4036),mysqld_main(mysqld.cc:4673),main(main.cc:25) 1 sigwaitinfo(libc.so.6),timer_notify_thread_func(posix_timers.c:77),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),buf_flush_page_cleaner_coordinator(buf0flu.cc:3172),start_thread(libpthread.so.0),clone(libc.so.6) [umshastr@hod03]~/bugs: [umshastr@hod03]~/bugs: [umshastr@hod03]~/bugs: ./pt-pmp --pid=12171 Mon Jan 16 06:53:33 CET 2017 10 __io_getevents_0_4(libaio.so.1),LinuxAIOHandler::collect(os0file.cc:2492),LinuxAIOHandler::poll(os0file.cc:2638),os_aio_linux_handler(os0file.cc:2694),os_aio_handler(os0file.cc:6246),fil_aio_wait(fil0fil.cc:5817),io_handler_thread(srv0start.cc:308),start_thread(libpthread.so.0),clone(libc.so.6) 3 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),buf_flush_page_cleaner_worker(buf0flu.cc:3496),start_thread(libpthread.so.0),clone(libc.so.6) 1 sigwaitinfo(libc.so.6),timer_notify_thread_func(posix_timers.c:77),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),buf_flush_page_cleaner_coordinator(buf0flu.cc:3172),start_thread(libpthread.so.0),clone(libc.so.6) 1 buf_page_get_state(buf0buf.ic:221),buf_LRU_validate_instance(buf0lru.cc:2670),buf_LRU_validate(buf0lru.cc:2698),buf_pool_validate_instance(buf0buf.cc:6244),buf_validate(buf0buf.cc:6264),buf_page_get_known_nowait(buf0buf.cc:4862),btr_search_guess_on_hash(btr0sea.cc:1030),btr_cur_search_to_nth_level(btr0cur.cc:928),btr_pcur_open_low(btr0pcur.ic:465),btr_pcur_open_on_user_rec_func(btr0pcur.cc:603),dict_get_first_path(dict0load.cc:775),dict_check_sys_tables(dict0load.cc:1449),dict_check_tablespaces_and_store_max_id(dict0load.cc:1525),innobase_start_or_create_for_mysql(srv0start.cc:2288),innobase_init(ha_innodb.cc:3989),ha_initialize_handlerton(handler.cc:838),plugin_initialize(sql_plugin.cc:1197),plugin_init(sql_plugin.cc:1539),init_server_components(mysqld.cc:4036),mysqld_main(mysqld.cc:4673),main(main.cc:25) [umshastr@hod03]~/bugs: [umshastr@hod03]~/bugs: ./pt-pmp --pid=12171 Mon Jan 16 06:53:41 CET 2017 10 __io_getevents_0_4(libaio.so.1),LinuxAIOHandler::collect(os0file.cc:2492),LinuxAIOHandler::poll(os0file.cc:2638),os_aio_linux_handler(os0file.cc:2694),os_aio_handler(os0file.cc:6246),fil_aio_wait(fil0fil.cc:5817),io_handler_thread(srv0start.cc:308),start_thread(libpthread.so.0),clone(libc.so.6) 3 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),buf_flush_page_cleaner_worker(buf0flu.cc:3496),start_thread(libpthread.so.0),clone(libc.so.6) 1 sigwaitinfo(libc.so.6),timer_notify_thread_func(posix_timers.c:77),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),buf_flush_page_cleaner_coordinator(buf0flu.cc:3172),start_thread(libpthread.so.0),clone(libc.so.6) 1 CheckInFreeList::operator(buf0buf.h:2451),ut_list_mapbuf_page_t::*>,CheckInFreeList>(ut0lst.h:409),ut_list_validatebuf_page_t::*>,CheckInFreeList>(ut0lst.h:442),CheckInFreeList::validate(buf0buf.h:2457),buf_LRU_validate_instance(buf0lru.cc:2664),buf_LRU_validate(buf0lru.cc:2698),buf_pool_validate_instance(buf0buf.cc:6244),buf_validate(buf0buf.cc:6264),buf_page_get_gen(buf0buf.cc:4594),btr_cur_search_to_nth_level(btr0cur.cc:1107),btr_pcur_open_low(btr0pcur.ic:465),btr_pcur_open_on_user_rec_func(btr0pcur.cc:603),dict_space_get_name(dict0load.cc:865),dict_check_sys_tables(dict0load.cc:1417),dict_check_tablespaces_and_store_max_id(dict0load.cc:1525),innobase_start_or_create_for_mysql(srv0start.cc:2288),innobase_init(ha_innodb.cc:3989),ha_initialize_handlerton(handler.cc:838),plugin_initialize(sql_plugin.cc:1197),plugin_init(sql_plugin.cc:1539),init_server_components(mysqld.cc:4036),mysqld_main(mysqld.cc:4673),main(main.cc:25) [umshastr@hod03]~/bugs: [umshastr@hod03]~/bugs: [umshastr@hod03]~/bugs: ./pt-pmp --pid=12171 Mon Jan 16 06:53:58 CET 2017 10 __io_getevents_0_4(libaio.so.1),LinuxAIOHandler::collect(os0file.cc:2492),LinuxAIOHandler::poll(os0file.cc:2638),os_aio_linux_handler(os0file.cc:2694),os_aio_handler(os0file.cc:6246),fil_aio_wait(fil0fil.cc:5817),io_handler_thread(srv0start.cc:308),start_thread(libpthread.so.0),clone(libc.so.6) 3 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),buf_flush_page_cleaner_worker(buf0flu.cc:3496),start_thread(libpthread.so.0),clone(libc.so.6) 1 sigwaitinfo(libc.so.6),timer_notify_thread_func(posix_timers.c:77),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),buf_flush_page_cleaner_coordinator(buf0flu.cc:3172),start_thread(libpthread.so.0),clone(libc.so.6) 1 CheckInFreeList::operator(buf0buf.h:2451),ut_list_mapbuf_page_t::*>,CheckInFreeList>(ut0lst.h:409),ut_list_validatebuf_page_t::*>,CheckInFreeList>(ut0lst.h:442),CheckInFreeList::validate(buf0buf.h:2457),buf_LRU_validate_instance(buf0lru.cc:2664),buf_LRU_validate(buf0lru.cc:2698),buf_pool_validate_instance(buf0buf.cc:6244),buf_validate(buf0buf.cc:6264),buf_page_optimistic_get(buf0buf.cc:4754),btr_cur_optimistic_latch_leaves(btr0cur.cc:428),btr_pcur_restore_position_func(btr0pcur.cc:289),dict_getnext_system(dict0load.cc:289),dict_check_sys_tables(dict0load.cc:1358),dict_check_tablespaces_and_store_max_id(dict0load.cc:1525),innobase_start_or_create_for_mysql(srv0start.cc:2288),innobase_init(ha_innodb.cc:3989),ha_initialize_handlerton(handler.cc:838),plugin_initialize(sql_plugin.cc:1197),plugin_init(sql_plugin.cc:1539),init_server_components(mysqld.cc:4036),mysqld_main(mysqld.cc:4673),main(main.cc:25) [umshastr@hod03]~/bugs: [umshastr@hod03]~/bugs: ./pt-pmp --pid=12171 Mon Jan 16 06:54:07 CET 2017 10 __io_getevents_0_4(libaio.so.1),LinuxAIOHandler::collect(os0file.cc:2492),LinuxAIOHandler::poll(os0file.cc:2638),os_aio_linux_handler(os0file.cc:2694),os_aio_handler(os0file.cc:6246),fil_aio_wait(fil0fil.cc:5817),io_handler_thread(srv0start.cc:308),start_thread(libpthread.so.0),clone(libc.so.6) 3 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),buf_flush_page_cleaner_worker(buf0flu.cc:3496),start_thread(libpthread.so.0),clone(libc.so.6) 1 ut_list_mapbuf_page_t::*>,CheckInFreeList>(ut0lst.h:405),ut_list_validatebuf_page_t::*>,CheckInFreeList>(ut0lst.h:442),CheckInFreeList::validate(buf0buf.h:2457),buf_LRU_validate_instance(buf0lru.cc:2664),buf_LRU_validate(buf0lru.cc:2698),buf_pool_validate_instance(buf0buf.cc:6244),buf_validate(buf0buf.cc:6264),buf_page_get_known_nowait(buf0buf.cc:4862),btr_search_guess_on_hash(btr0sea.cc:1030),btr_cur_search_to_nth_level(btr0cur.cc:928),btr_pcur_open_low(btr0pcur.ic:465),btr_pcur_open_on_user_rec_func(btr0pcur.cc:603),dict_get_first_path(dict0load.cc:775),dict_check_sys_tables(dict0load.cc:1449),dict_check_tablespaces_and_store_max_id(dict0load.cc:1525),innobase_start_or_create_for_mysql(srv0start.cc:2288),innobase_init(ha_innodb.cc:3989),ha_initialize_handlerton(handler.cc:838),plugin_initialize(sql_plugin.cc:1197),plugin_init(sql_plugin.cc:1539),init_server_components(mysqld.cc:4036),mysqld_main(mysqld.cc:4673),main(main.cc:25) 1 sigwaitinfo(libc.so.6),timer_notify_thread_func(posix_timers.c:77),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),buf_flush_page_cleaner_coordinator(buf0flu.cc:3172),start_thread(libpthread.so.0),clone(libc.so.6) [umshastr@hod03]~/bugs: [umshastr@hod03]~/bugs: [umshastr@hod03]~/bugs: ./pt-pmp --pid=12171 Mon Jan 16 06:54:25 CET 2017 10 __io_getevents_0_4(libaio.so.1),LinuxAIOHandler::collect(os0file.cc:2492),LinuxAIOHandler::poll(os0file.cc:2638),os_aio_linux_handler(os0file.cc:2694),os_aio_handler(os0file.cc:6246),fil_aio_wait(fil0fil.cc:5817),io_handler_thread(srv0start.cc:308),start_thread(libpthread.so.0),clone(libc.so.6) 3 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),buf_flush_page_cleaner_worker(buf0flu.cc:3496),start_thread(libpthread.so.0),clone(libc.so.6) 1 sigwaitinfo(libc.so.6),timer_notify_thread_func(posix_timers.c:77),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),buf_flush_page_cleaner_coordinator(buf0flu.cc:3172),start_thread(libpthread.so.0),clone(libc.so.6) 1 btr_search_guess_on_hash(btr0sea.cc:1125),btr_cur_search_to_nth_level(btr0cur.cc:928),btr_pcur_open_low(btr0pcur.ic:465),btr_pcur_open_on_user_rec_func(btr0pcur.cc:603),dict_get_first_path(dict0load.cc:775),dict_check_sys_tables(dict0load.cc:1449),dict_check_tablespaces_and_store_max_id(dict0load.cc:1525),innobase_start_or_create_for_mysql(srv0start.cc:2288),innobase_init(ha_innodb.cc:3989),ha_initialize_handlerton(handler.cc:838),plugin_initialize(sql_plugin.cc:1197),plugin_init(sql_plugin.cc:1539),init_server_components(mysqld.cc:4036),mysqld_main(mysqld.cc:4673),main(main.cc:25) [umshastr@hod03]~/bugs: [umshastr@hod03]~/bugs: ./pt-pmp --pid=12171 Mon Jan 16 06:54:35 CET 2017 10 __io_getevents_0_4(libaio.so.1),LinuxAIOHandler::collect(os0file.cc:2492),LinuxAIOHandler::poll(os0file.cc:2638),os_aio_linux_handler(os0file.cc:2694),os_aio_handler(os0file.cc:6246),fil_aio_wait(fil0fil.cc:5817),io_handler_thread(srv0start.cc:308),start_thread(libpthread.so.0),clone(libc.so.6) 3 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),buf_flush_page_cleaner_worker(buf0flu.cc:3496),start_thread(libpthread.so.0),clone(libc.so.6) 1 sigwaitinfo(libc.so.6),timer_notify_thread_func(posix_timers.c:77),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),buf_flush_page_cleaner_coordinator(buf0flu.cc:3172),start_thread(libpthread.so.0),clone(libc.so.6) 1 buf_page_get_state(buf0buf.ic:221),buf_LRU_validate_instance(buf0lru.cc:2670),buf_LRU_validate(buf0lru.cc:2698),buf_pool_validate_instance(buf0buf.cc:6244),buf_validate(buf0buf.cc:6264),buf_page_get_known_nowait(buf0buf.cc:4862),btr_search_guess_on_hash(btr0sea.cc:1030),btr_cur_search_to_nth_level(btr0cur.cc:928),btr_pcur_open_low(btr0pcur.ic:465),btr_pcur_open_on_user_rec_func(btr0pcur.cc:603),dict_space_get_name(dict0load.cc:865),dict_check_sys_tables(dict0load.cc:1417),dict_check_tablespaces_and_store_max_id(dict0load.cc:1525),innobase_start_or_create_for_mysql(srv0start.cc:2288),innobase_init(ha_innodb.cc:3989),ha_initialize_handlerton(handler.cc:838),plugin_initialize(sql_plugin.cc:1197),plugin_init(sql_plugin.cc:1539),init_server_components(mysqld.cc:4036),mysqld_main(mysqld.cc:4673),main(main.cc:25) [umshastr@hod03]~/bugs: [umshastr@hod03]~/bugs: ./pt-pmp --pid=12171 Mon Jan 16 06:55:21 CET 2017 10 __io_getevents_0_4(libaio.so.1),LinuxAIOHandler::collect(os0file.cc:2492),LinuxAIOHandler::poll(os0file.cc:2638),os_aio_linux_handler(os0file.cc:2694),os_aio_handler(os0file.cc:6246),fil_aio_wait(fil0fil.cc:5817),io_handler_thread(srv0start.cc:308),start_thread(libpthread.so.0),clone(libc.so.6) 7 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),srv_worker_thread(srv0srv.cc:2506),start_thread(libpthread.so.0),clone(libc.so.6) 3 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),buf_flush_page_cleaner_worker(buf0flu.cc:3496),start_thread(libpthread.so.0),clone(libc.so.6) 1 sigwaitinfo(libc.so.6),timer_notify_thread_func(posix_timers.c:77),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_join(libpthread.so.0),my_thread_join(my_thread.c:138),bootstrap(bootstrap.cc:367),bootstrap_single_query(bootstrap.cc:375),mysqld_main(mysqld.cc:4966),main(main.cc:25) 1 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),sync_array_wait_event(sync0arr.cc:475),TTASEventMutex::wait(ut0mutex.ic:89),TTASEventMutex::spin_and_try_lock(ib0mutex.h:850),TTASEventMutex::enter(ib0mutex.h:707),PolicyMutex::enter(ib0mutex.h:987),fil_space_get_flags(fil0fil.cc:1597),fil_space_get_page_size(fil0fil.cc:1698),buf_page_get_gen(buf0buf.cc:4091),btr_cur_search_to_nth_level_with_no_latch(btr0cur.cc:2068),row_ins_sorted_clust_index_entry(row0ins.cc:2702),row_ins_clust_index_entry(row0ins.cc:3321),row_insert_for_mysql_using_cursor(row0mysql.cc:1591),row_insert_for_mysql(row0mysql.cc:1854),ha_innobase::intrinsic_table_write_row(ha_innodb.cc:7321),ha_innobase::write_row(ha_innodb.cc:7345),handler::ha_write_row(handler.cc:7923),schema_table_store_record(sql_show.cc:3155),get_schema_tables_record(sql_show.cc:5136),fill_schema_table_from_frm(sql_show.cc:4394),get_all_tables(sql_show.cc:4702),do_fill_table(sql_show.cc:8115),get_schema_tables_result(sql_show.cc:8245),JOIN::prepare_result(sql_select.cc:909),JOIN::exec(sql_executor.cc:124),handle_query(sql_select.cc:184),execute_sqlcom_select(sql_parse.cc:5195),mysql_execute_command(sql_parse.cc:2794),mysql_parse(sql_parse.cc:5611),handle_bootstrap_impl(bootstrap.cc:254),::handle_bootstrap(bootstrap.cc:325),pfs_spawn_thread(pfs.cc:2188),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),srv_purge_coordinator_suspend(srv0srv.cc:2662),srv_purge_coordinator_thread(srv0srv.cc:2778),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),buf_resize_thread(buf0buf.cc:3015),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_wait,native_cond_wait(thr_cond.h:140),safe_cond_wait(thr_cond.c:48),my_cond_wait(thr_cond.h:193),inline_mysql_cond_wait(mysql_thread.h:1199),signal_hand(mysqld.cc:2095),pfs_spawn_thread(pfs.cc:2188),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_timedwait,os_event::timed_wait(os0event.cc:285),os_event::wait_time_low(os0event.cc:412),os_event_wait_time_low(os0event.cc:517),srv_monitor_thread(srv0srv.cc:1571),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_timedwait,os_event::timed_wait(os0event.cc:285),os_event::wait_time_low(os0event.cc:412),os_event_wait_time_low(os0event.cc:517),srv_error_monitor_thread(srv0srv.cc:1737),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_timedwait,os_event::timed_wait(os0event.cc:285),os_event::wait_time_low(os0event.cc:412),os_event_wait_time_low(os0event.cc:517),pc_sleep_if_needed(buf0flu.cc:2690),buf_flush_page_cleaner_coordinator(buf0flu.cc:3191),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_timedwait,os_event::timed_wait(os0event.cc:285),os_event::wait_time_low(os0event.cc:412),os_event_wait_time_low(os0event.cc:517),lock_wait_timeout_thread(lock0wait.cc:501),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_timedwait,os_event::timed_wait(os0event.cc:285),os_event::wait_time_low(os0event.cc:412),os_event_wait_time_low(os0event.cc:517),ib_wqueue_timedwait(ut0wqueue.cc:160),fts_optimize_thread(fts0opt.cc:3040),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_timedwait,os_event::timed_wait(os0event.cc:285),os_event::wait_time_low(os0event.cc:412),os_event_wait_time_low(os0event.cc:517),dict_stats_thread(dict0stats_bg.cc:421),start_thread(libpthread.so.0),clone(libc.so.6) 1 nanosleep(libpthread.so.0),os_thread_sleep(os0thread.cc:279),srv_master_sleep(srv0srv.cc:2316),srv_master_thread(srv0srv.cc:2363),start_thread(libpthread.so.0),clone(libc.so.6) 1 Check::operator(fil0fil.cc:6086),ut_list_mapfil_node_t::*>,Check>(ut0lst.h:409),ut_list_validatefil_node_t::*>,Check>(ut0lst.h:442),Check::validate(fil0fil.cc:6097),fil_validate(fil0fil.cc:6126),fil_validate_skip(fil0fil.cc:262),fil_io(fil0fil.cc:5793),buf_read_page_low(buf0rea.cc:183),buf_read_page_background(buf0rea.cc:442),buf_load(buf0dump.cc:679),buf_dump_thread(buf0dump.cc:776),start_thread(libpthread.so.0),clone(libc.so.6) [umshastr@hod03]~/bugs: [umshastr@hod03]~/bugs: ./pt-pmp --pid=12171 Mon Jan 16 06:55:49 CET 2017 10 __io_getevents_0_4(libaio.so.1),LinuxAIOHandler::collect(os0file.cc:2492),LinuxAIOHandler::poll(os0file.cc:2638),os_aio_linux_handler(os0file.cc:2694),os_aio_handler(os0file.cc:6246),fil_aio_wait(fil0fil.cc:5817),io_handler_thread(srv0start.cc:308),start_thread(libpthread.so.0),clone(libc.so.6) 7 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),srv_worker_thread(srv0srv.cc:2506),start_thread(libpthread.so.0),clone(libc.so.6) 3 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),buf_flush_page_cleaner_worker(buf0flu.cc:3496),start_thread(libpthread.so.0),clone(libc.so.6) 1 ut_list_mapfil_node_t::*>,Check>(ut0lst.h:403),ut_list_validatefil_node_t::*>,Check>(ut0lst.h:442),Check::validate(fil0fil.cc:6097),fil_validate(fil0fil.cc:6126),fil_validate_skip(fil0fil.cc:262),fil_io(fil0fil.cc:5793),buf_read_page_low(buf0rea.cc:183),buf_read_page_background(buf0rea.cc:442),buf_load(buf0dump.cc:679),buf_dump_thread(buf0dump.cc:776),start_thread(libpthread.so.0),clone(libc.so.6) 1 sigwaitinfo(libc.so.6),timer_notify_thread_func(posix_timers.c:77),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_join(libpthread.so.0),my_thread_join(my_thread.c:138),bootstrap(bootstrap.cc:367),bootstrap_single_query(bootstrap.cc:375),mysqld_main(mysqld.cc:4966),main(main.cc:25) 1 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),sync_array_wait_event(sync0arr.cc:475),TTASEventMutex::wait(ut0mutex.ic:89),TTASEventMutex::spin_and_try_lock(ib0mutex.h:850),TTASEventMutex::enter(ib0mutex.h:707),PolicyMutex::enter(ib0mutex.h:987),fil_space_release_free_extents(fil0fil.cc:5251),btr_cur_pessimistic_insert(btr0cur.cc:3471),row_ins_sorted_clust_index_entry(row0ins.cc:2746),row_ins_clust_index_entry(row0ins.cc:3321),row_insert_for_mysql_using_cursor(row0mysql.cc:1591),row_insert_for_mysql(row0mysql.cc:1854),ha_innobase::intrinsic_table_write_row(ha_innodb.cc:7321),ha_innobase::write_row(ha_innodb.cc:7345),handler::ha_write_row(handler.cc:7923),schema_table_store_record(sql_show.cc:3155),get_schema_tables_record(sql_show.cc:5136),fill_schema_table_from_frm(sql_show.cc:4394),get_all_tables(sql_show.cc:4702),do_fill_table(sql_show.cc:8115),get_schema_tables_result(sql_show.cc:8245),JOIN::prepare_result(sql_select.cc:909),JOIN::exec(sql_executor.cc:124),handle_query(sql_select.cc:184),execute_sqlcom_select(sql_parse.cc:5195),mysql_execute_command(sql_parse.cc:2794),mysql_parse(sql_parse.cc:5611),handle_bootstrap_impl(bootstrap.cc:254),::handle_bootstrap(bootstrap.cc:325),pfs_spawn_thread(pfs.cc:2188),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),srv_purge_coordinator_suspend(srv0srv.cc:2662),srv_purge_coordinator_thread(srv0srv.cc:2778),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),buf_resize_thread(buf0buf.cc:3015),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_wait,native_cond_wait(thr_cond.h:140),safe_cond_wait(thr_cond.c:48),my_cond_wait(thr_cond.h:193),inline_mysql_cond_wait(mysql_thread.h:1199),signal_hand(mysqld.cc:2095),pfs_spawn_thread(pfs.cc:2188),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_timedwait,os_event::timed_wait(os0event.cc:285),os_event::wait_time_low(os0event.cc:412),os_event_wait_time_low(os0event.cc:517),srv_monitor_thread(srv0srv.cc:1571),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_timedwait,os_event::timed_wait(os0event.cc:285),os_event::wait_time_low(os0event.cc:412),os_event_wait_time_low(os0event.cc:517),srv_error_monitor_thread(srv0srv.cc:1737),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_timedwait,os_event::timed_wait(os0event.cc:285),os_event::wait_time_low(os0event.cc:412),os_event_wait_time_low(os0event.cc:517),pc_sleep_if_needed(buf0flu.cc:2690),buf_flush_page_cleaner_coordinator(buf0flu.cc:3191),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_timedwait,os_event::timed_wait(os0event.cc:285),os_event::wait_time_low(os0event.cc:412),os_event_wait_time_low(os0event.cc:517),lock_wait_timeout_thread(lock0wait.cc:501),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_timedwait,os_event::timed_wait(os0event.cc:285),os_event::wait_time_low(os0event.cc:412),os_event_wait_time_low(os0event.cc:517),ib_wqueue_timedwait(ut0wqueue.cc:160),fts_optimize_thread(fts0opt.cc:3040),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_timedwait,os_event::timed_wait(os0event.cc:285),os_event::wait_time_low(os0event.cc:412),os_event_wait_time_low(os0event.cc:517),dict_stats_thread(dict0stats_bg.cc:421),start_thread(libpthread.so.0),clone(libc.so.6) 1 nanosleep(libpthread.so.0),os_thread_sleep(os0thread.cc:279),srv_master_sleep(srv0srv.cc:2316),srv_master_thread(srv0srv.cc:2363),start_thread(libpthread.so.0),clone(libc.so.6) [umshastr@hod03]~/bugs: ## -- Initiate shutdown - second time [umshastr@hod03]/export/umesh/server/source/bugs/84173/5.7.17: bin/mysqladmin -uroot -S /tmp/mysql.sock shutdown -- Secondtime shutdown happens instantly 2017-01-16T05:58:56.034479Z 0 [Note] Shutting down slave threads 2017-01-16T05:58:56.034494Z 0 [Note] Forcefully disconnecting 0 remaining clients 2017-01-16T05:58:56.034509Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2017-01-16T05:58:56.034604Z 0 [Note] Binlog end 2017-01-16T05:58:56.572486Z 0 [Note] Shutting down plugin 'ngram' 2017-01-16T05:58:56.572529Z 0 [Note] Shutting down plugin 'partition' 2017-01-16T05:58:56.572540Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2017-01-16T05:58:56.572549Z 0 [Note] Shutting down plugin 'ARCHIVE' 2017-01-16T05:58:56.572555Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2017-01-16T05:58:56.572639Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2017-01-16T05:58:56.572657Z 0 [Note] Shutting down plugin 'MyISAM' 2017-01-16T05:58:56.572688Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2017-01-16T05:58:56.572697Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2017-01-16T05:58:56.572706Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2017-01-16T05:58:56.572712Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2017-01-16T05:58:56.572718Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2017-01-16T05:58:56.572724Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2017-01-16T05:58:56.572730Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2017-01-16T05:58:56.572735Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2017-01-16T05:58:56.572742Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2017-01-16T05:58:56.572749Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2017-01-16T05:58:56.572754Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2017-01-16T05:58:56.572760Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2017-01-16T05:58:56.572765Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2017-01-16T05:58:56.572771Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2017-01-16T05:58:56.572776Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2017-01-16T05:58:56.572782Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2017-01-16T05:58:56.572787Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2017-01-16T05:58:56.572792Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2017-01-16T05:58:56.572799Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2017-01-16T05:58:56.572805Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2017-01-16T05:58:56.572810Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2017-01-16T05:58:56.572815Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2017-01-16T05:58:56.572820Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2017-01-16T05:58:56.572835Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2017-01-16T05:58:56.572841Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2017-01-16T05:58:56.572846Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2017-01-16T05:58:56.572854Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2017-01-16T05:58:56.572863Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2017-01-16T05:58:56.572868Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2017-01-16T05:58:56.572874Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2017-01-16T05:58:56.572879Z 0 [Note] Shutting down plugin 'MEMORY' 2017-01-16T05:58:56.572887Z 0 [Note] Shutting down plugin 'CSV' 2017-01-16T05:58:56.572895Z 0 [Note] Shutting down plugin 'sha256_password' 2017-01-16T05:58:56.572900Z 0 [Note] Shutting down plugin 'mysql_native_password' 2017-01-16T05:58:56.572998Z 0 [Note] Shutting down plugin 'binlog' 2017-01-16T05:58:56.573015Z 0 [Note] Shutting down plugin 'InnoDB' 2017-01-16T05:58:56.573151Z 0 [Note] InnoDB: FTS optimize thread exiting. 2017-01-16T05:58:56.573439Z 0 [Note] InnoDB: Starting shutdown... 2017-01-16T05:58:56.596411Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170116 6:58:56 2017-01-16T05:58:56.596488Z 0 [Note] InnoDB: Dumping buffer pool(s) to /export/umesh/server/source/bugs/84173/5.7.17/ib_buffer_pool 2017-01-16T05:58:56.618473Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 170116 6:58:56 2017-01-16T05:59:00.511864Z 0 [Note] InnoDB: Shutdown completed; log sequence number 6106464414 2017-01-16T05:59:00.524636Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2017-01-16T05:59:00.583694Z 0 [Note] bin/mysqld: Shutdown complete -- Start up - second time bin/mysqld --no-defaults --basedir=/export/umesh/server/source/bugs/84173/5.7.17 --datadir=/export/umesh/server/source/bugs/84173/5.7.17/data --core-file --socket=/tmp/mysql_master.sock --port=3306 --log-error=/export/umesh/server/source/bugs/84173/5.7.17/data/log.err --skip-external-locking --bind-address=127.0.0.1 --max_allowed_packet=16M --thread_stack=192K --thread_cache_size=8 --max_connections=4096 --expire_logs_days=1 --max_binlog_size=100M --innodb_buffer_pool_size=16G --innodb_log_file_size=1G --innodb_log_buffer_size=64M --innodb_flush_log_at_trx_commit=0 --innodb_flush_method=O_DIRECT --innodb_io_capacity=1000 --innodb_io_capacity_max=10000 --innodb_checksum_algorithm=strict_crc32 --innodb_purge_threads=8 --innodb_flush_neighbors=0 --innodb_change_buffer_max_size=5 --innodb_flush_log_at_trx_commit=2 --innodb_max_dirty_pages_pct=95 --innodb_sync_array_size=4 --innodb_monitor_enable="%" --innodb_buffer_pool_dump_pct=100 --innodb_open_files=1000 --innodb_max_purge_lag=1000000 --innodb_max_purge_lag_delay=10000 --innodb_undo_tablespaces=2 --innodb_undo_log_truncate=1 --performance_schema=off --server_id=1 --table_definition_cache=200000 --table_open_cache=200000 --table_open_cache_instances=1 2>&1 & -- start up messages from error log 2017-01-16T06:01:28.173404Z 0 [Note] InnoDB: Opened 2 undo tablespaces 2017-01-16T06:01:28.173419Z 0 [Note] InnoDB: 2 undo tablespaces made active 2017-01-16T06:01:28.173954Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2017-01-16T06:04:03.969343Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2017-01-16T06:04:03.969458Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2017-01-16T06:04:03.991540Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2017-01-16T06:04:04.027662Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2017-01-16T06:04:04.027699Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2017-01-16T06:04:04.183947Z 0 [Note] InnoDB: Waiting for purge to start 2017-01-16T06:04:04.234117Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 156076ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.) 2017-01-16T06:04:04.234199Z 0 [Note] InnoDB: 5.7.17 started; log sequence number 6106464414 2017-01-16T06:04:04.234438Z 0 [Note] InnoDB: Loading buffer pool(s) from /export/umesh/server/source/bugs/84173/5.7.17/ib_buffer_pool 2017-01-16T06:04:04.235146Z 0 [Note] Plugin 'FEDERATED' is disabled. 2017-01-16T06:04:04.851215Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2017-01-16T06:04:04.851272Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 2017-01-16T06:04:04.851315Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 2017-01-16T06:04:04.851351Z 0 [Note] Server socket created on IP: '127.0.0.1'. 2017-01-16T06:04:06.371677Z 0 [Note] Event Scheduler: Loaded 0 events 2017-01-16T06:04:06.371911Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check. 2017-01-16T06:04:06.371923Z 0 [Note] Beginning of list of non-natively partitioned tables 2017-01-16T06:05:26.597534Z 0 [Note] End of list of non-natively partitioned tables 2017-01-16T06:05:26.597850Z 0 [Note] bin/mysqld: ready for connections. Version: '5.7.17-debug' socket: '/tmp/mysql.sock' port: 3306 Source distribution -- pt-pmp [umshastr@hod03]~/bugs: ./pt-pmp --pid=14885 Mon Jan 16 07:02:23 CET 2017 10 __io_getevents_0_4(libaio.so.1),LinuxAIOHandler::collect(os0file.cc:2492),LinuxAIOHandler::poll(os0file.cc:2638),os_aio_linux_handler(os0file.cc:2694),os_aio_handler(os0file.cc:6246),fil_aio_wait(fil0fil.cc:5817),io_handler_thread(srv0start.cc:308),start_thread(libpthread.so.0),clone(libc.so.6) 3 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),buf_flush_page_cleaner_worker(buf0flu.cc:3496),start_thread(libpthread.so.0),clone(libc.so.6) 1 ut_list_mapbuf_page_t::*>,CheckInFreeList>(ut0lst.h:405),ut_list_validatebuf_page_t::*>,CheckInFreeList>(ut0lst.h:442),CheckInFreeList::validate(buf0buf.h:2457),buf_LRU_validate_instance(buf0lru.cc:2664),buf_LRU_validate(buf0lru.cc:2698),buf_pool_validate_instance(buf0buf.cc:6244),buf_validate(buf0buf.cc:6264),buf_page_get_known_nowait(buf0buf.cc:4862),btr_search_guess_on_hash(btr0sea.cc:1030),btr_cur_search_to_nth_level(btr0cur.cc:928),btr_pcur_open_low(btr0pcur.ic:465),btr_pcur_open_on_user_rec_func(btr0pcur.cc:603),dict_space_get_name(dict0load.cc:865),dict_check_sys_tables(dict0load.cc:1417),dict_check_tablespaces_and_store_max_id(dict0load.cc:1525),innobase_start_or_create_for_mysql(srv0start.cc:2288),innobase_init(ha_innodb.cc:3989),ha_initialize_handlerton(handler.cc:838),plugin_initialize(sql_plugin.cc:1197),plugin_init(sql_plugin.cc:1539),init_server_components(mysqld.cc:4036),mysqld_main(mysqld.cc:4673),main(main.cc:25) 1 sigwaitinfo(libc.so.6),timer_notify_thread_func(posix_timers.c:77),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),buf_flush_page_cleaner_coordinator(buf0flu.cc:3172),start_thread(libpthread.so.0),clone(libc.so.6) [umshastr@hod03]~/bugs: [umshastr@hod03]~/bugs: ./pt-pmp --pid=14885 Mon Jan 16 07:02:30 CET 2017 10 __io_getevents_0_4(libaio.so.1),LinuxAIOHandler::collect(os0file.cc:2492),LinuxAIOHandler::poll(os0file.cc:2638),os_aio_linux_handler(os0file.cc:2694),os_aio_handler(os0file.cc:6246),fil_aio_wait(fil0fil.cc:5817),io_handler_thread(srv0start.cc:308),start_thread(libpthread.so.0),clone(libc.so.6) 3 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),buf_flush_page_cleaner_worker(buf0flu.cc:3496),start_thread(libpthread.so.0),clone(libc.so.6) 1 ut_list_validatebuf_page_t::*>,CheckInFreeList>(ut0lst.h:447),CheckInFreeList::validate(buf0buf.h:2457),buf_LRU_validate_instance(buf0lru.cc:2664),buf_LRU_validate(buf0lru.cc:2698),buf_pool_validate_instance(buf0buf.cc:6244),buf_validate(buf0buf.cc:6264),buf_page_get_known_nowait(buf0buf.cc:4862),btr_search_guess_on_hash(btr0sea.cc:1030),btr_cur_search_to_nth_level(btr0cur.cc:928),btr_pcur_open_low(btr0pcur.ic:465),btr_pcur_open_on_user_rec_func(btr0pcur.cc:603),dict_space_get_name(dict0load.cc:865),dict_check_sys_tables(dict0load.cc:1417),dict_check_tablespaces_and_store_max_id(dict0load.cc:1525),innobase_start_or_create_for_mysql(srv0start.cc:2288),innobase_init(ha_innodb.cc:3989),ha_initialize_handlerton(handler.cc:838),plugin_initialize(sql_plugin.cc:1197),plugin_init(sql_plugin.cc:1539),init_server_components(mysqld.cc:4036),mysqld_main(mysqld.cc:4673),main(main.cc:25) 1 sigwaitinfo(libc.so.6),timer_notify_thread_func(posix_timers.c:77),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),buf_flush_page_cleaner_coordinator(buf0flu.cc:3172),start_thread(libpthread.so.0),clone(libc.so.6) [umshastr@hod03]~/bugs: [umshastr@hod03]~/bugs: [umshastr@hod03]~/bugs: ./pt-pmp --pid=14885 Mon Jan 16 07:03:01 CET 2017 10 __io_getevents_0_4(libaio.so.1),LinuxAIOHandler::collect(os0file.cc:2492),LinuxAIOHandler::poll(os0file.cc:2638),os_aio_linux_handler(os0file.cc:2694),os_aio_handler(os0file.cc:6246),fil_aio_wait(fil0fil.cc:5817),io_handler_thread(srv0start.cc:308),start_thread(libpthread.so.0),clone(libc.so.6) 3 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),buf_flush_page_cleaner_worker(buf0flu.cc:3496),start_thread(libpthread.so.0),clone(libc.so.6) 1 ut_list_mapbuf_page_t::*>,CheckInFreeList>(ut0lst.h:405),ut_list_validatebuf_page_t::*>,CheckInFreeList>(ut0lst.h:442),CheckInFreeList::validate(buf0buf.h:2457),buf_LRU_validate_instance(buf0lru.cc:2664),buf_LRU_validate(buf0lru.cc:2698),buf_pool_validate_instance(buf0buf.cc:6244),buf_validate(buf0buf.cc:6264),buf_page_get_known_nowait(buf0buf.cc:4862),btr_search_guess_on_hash(btr0sea.cc:1030),btr_cur_search_to_nth_level(btr0cur.cc:928),btr_pcur_open_low(btr0pcur.ic:465),btr_pcur_open_on_user_rec_func(btr0pcur.cc:603),dict_space_get_name(dict0load.cc:865),dict_check_sys_tables(dict0load.cc:1417),dict_check_tablespaces_and_store_max_id(dict0load.cc:1525),innobase_start_or_create_for_mysql(srv0start.cc:2288),innobase_init(ha_innodb.cc:3989),ha_initialize_handlerton(handler.cc:838),plugin_initialize(sql_plugin.cc:1197),plugin_init(sql_plugin.cc:1539),init_server_components(mysqld.cc:4036),mysqld_main(mysqld.cc:4673),main(main.cc:25) 1 sigwaitinfo(libc.so.6),timer_notify_thread_func(posix_timers.c:77),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),buf_flush_page_cleaner_coordinator(buf0flu.cc:3172),start_thread(libpthread.so.0),clone(libc.so.6) [umshastr@hod03]~/bugs: [umshastr@hod03]~/bugs: ./pt-pmp --pid=14885 Mon Jan 16 07:03:32 CET 2017 10 __io_getevents_0_4(libaio.so.1),LinuxAIOHandler::collect(os0file.cc:2492),LinuxAIOHandler::poll(os0file.cc:2638),os_aio_linux_handler(os0file.cc:2694),os_aio_handler(os0file.cc:6246),fil_aio_wait(fil0fil.cc:5817),io_handler_thread(srv0start.cc:308),start_thread(libpthread.so.0),clone(libc.so.6) 3 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),buf_flush_page_cleaner_worker(buf0flu.cc:3496),start_thread(libpthread.so.0),clone(libc.so.6) 1 ut_list_validatebuf_page_t::*>,CheckInFreeList>(ut0lst.h:447),CheckInFreeList::validate(buf0buf.h:2457),buf_LRU_validate_instance(buf0lru.cc:2664),buf_LRU_validate(buf0lru.cc:2698),buf_pool_validate_instance(buf0buf.cc:6244),buf_validate(buf0buf.cc:6264),buf_page_get_gen(buf0buf.cc:4594),btr_cur_search_to_nth_level(btr0cur.cc:1107),btr_pcur_open_low(btr0pcur.ic:465),btr_pcur_open_on_user_rec_func(btr0pcur.cc:603),dict_get_first_path(dict0load.cc:775),dict_check_sys_tables(dict0load.cc:1449),dict_check_tablespaces_and_store_max_id(dict0load.cc:1525),innobase_start_or_create_for_mysql(srv0start.cc:2288),innobase_init(ha_innodb.cc:3989),ha_initialize_handlerton(handler.cc:838),plugin_initialize(sql_plugin.cc:1197),plugin_init(sql_plugin.cc:1539),init_server_components(mysqld.cc:4036),mysqld_main(mysqld.cc:4673),main(main.cc:25) 1 sigwaitinfo(libc.so.6),timer_notify_thread_func(posix_timers.c:77),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),buf_flush_page_cleaner_coordinator(buf0flu.cc:3172),start_thread(libpthread.so.0),clone(libc.so.6) [umshastr@hod03]~/bugs: [umshastr@hod03]~/bugs: ./pt-pmp --pid=14885 Mon Jan 16 07:04:28 CET 2017 10 __io_getevents_0_4(libaio.so.1),LinuxAIOHandler::collect(os0file.cc:2492),LinuxAIOHandler::poll(os0file.cc:2638),os_aio_linux_handler(os0file.cc:2694),os_aio_handler(os0file.cc:6246),fil_aio_wait(fil0fil.cc:5817),io_handler_thread(srv0start.cc:308),start_thread(libpthread.so.0),clone(libc.so.6) 7 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),srv_worker_thread(srv0srv.cc:2506),start_thread(libpthread.so.0),clone(libc.so.6) 3 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),buf_flush_page_cleaner_worker(buf0flu.cc:3496),start_thread(libpthread.so.0),clone(libc.so.6) 1 ut_list_mapfil_node_t::*>,Check>(ut0lst.h:442),Check::validate(fil0fil.cc:6097),fil_validate(fil0fil.cc:6126),fil_validate_skip(fil0fil.cc:262),fil_io(fil0fil.cc:5489),buf_read_page_low(buf0rea.cc:183),buf_read_page_background(buf0rea.cc:442),buf_load(buf0dump.cc:679),buf_dump_thread(buf0dump.cc:776),start_thread(libpthread.so.0),clone(libc.so.6) 1 ut_delay(libc.so.6),TTASEventMutex::is_free(ib0mutex.h:792),TTASEventMutex::spin_and_try_lock(ib0mutex.h:823),TTASEventMutex::enter(ib0mutex.h:707),PolicyMutex::enter(ib0mutex.h:987),fil_space_get_flags(fil0fil.cc:1597),fil_space_get_page_size(fil0fil.cc:1698),buf_page_get_gen(buf0buf.cc:4091),btr_cur_search_to_nth_level_with_no_latch(btr0cur.cc:2068),row_ins_sorted_clust_index_entry(row0ins.cc:2702),row_ins_clust_index_entry(row0ins.cc:3321),row_insert_for_mysql_using_cursor(row0mysql.cc:1591),row_insert_for_mysql(row0mysql.cc:1854),ha_innobase::intrinsic_table_write_row(ha_innodb.cc:7321),ha_innobase::write_row(ha_innodb.cc:7345),handler::ha_write_row(handler.cc:7923),schema_table_store_record(sql_show.cc:3155),get_schema_tables_record(sql_show.cc:5136),fill_schema_table_from_frm(sql_show.cc:4394),get_all_tables(sql_show.cc:4702),do_fill_table(sql_show.cc:8115),get_schema_tables_result(sql_show.cc:8245),JOIN::prepare_result(sql_select.cc:909),JOIN::exec(sql_executor.cc:124),handle_query(sql_select.cc:184),execute_sqlcom_select(sql_parse.cc:5195),mysql_execute_command(sql_parse.cc:2794),mysql_parse(sql_parse.cc:5611),handle_bootstrap_impl(bootstrap.cc:254),::handle_bootstrap(bootstrap.cc:325),pfs_spawn_thread(pfs.cc:2188),start_thread(libpthread.so.0),clone(libc.so.6) 1 sigwaitinfo(libc.so.6),timer_notify_thread_func(posix_timers.c:77),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_join(libpthread.so.0),my_thread_join(my_thread.c:138),bootstrap(bootstrap.cc:367),bootstrap_single_query(bootstrap.cc:375),mysqld_main(mysqld.cc:4966),main(main.cc:25) 1 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),srv_purge_coordinator_suspend(srv0srv.cc:2662),srv_purge_coordinator_thread(srv0srv.cc:2778),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_wait,os_event::wait(os0event.cc:165),os_event::wait_low(os0event.cc:335),os_event_wait_low(os0event.cc:534),buf_resize_thread(buf0buf.cc:3015),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_wait,native_cond_wait(thr_cond.h:140),safe_cond_wait(thr_cond.c:48),my_cond_wait(thr_cond.h:193),inline_mysql_cond_wait(mysql_thread.h:1199),signal_hand(mysqld.cc:2095),pfs_spawn_thread(pfs.cc:2188),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_timedwait,os_event::timed_wait(os0event.cc:285),os_event::wait_time_low(os0event.cc:412),os_event_wait_time_low(os0event.cc:517),srv_monitor_thread(srv0srv.cc:1571),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_timedwait,os_event::timed_wait(os0event.cc:285),os_event::wait_time_low(os0event.cc:412),os_event_wait_time_low(os0event.cc:517),srv_error_monitor_thread(srv0srv.cc:1737),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_timedwait,os_event::timed_wait(os0event.cc:285),os_event::wait_time_low(os0event.cc:412),os_event_wait_time_low(os0event.cc:517),pc_sleep_if_needed(buf0flu.cc:2690),buf_flush_page_cleaner_coordinator(buf0flu.cc:3191),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_timedwait,os_event::timed_wait(os0event.cc:285),os_event::wait_time_low(os0event.cc:412),os_event_wait_time_low(os0event.cc:517),lock_wait_timeout_thread(lock0wait.cc:501),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_timedwait,os_event::timed_wait(os0event.cc:285),os_event::wait_time_low(os0event.cc:412),os_event_wait_time_low(os0event.cc:517),ib_wqueue_timedwait(ut0wqueue.cc:160),fts_optimize_thread(fts0opt.cc:3040),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_timedwait,os_event::timed_wait(os0event.cc:285),os_event::wait_time_low(os0event.cc:412),os_event_wait_time_low(os0event.cc:517),dict_stats_thread(dict0stats_bg.cc:421),start_thread(libpthread.so.0),clone(libc.so.6) 1 nanosleep(libpthread.so.0),os_thread_sleep(os0thread.cc:279),srv_master_sleep(srv0srv.cc:2316),srv_master_thread(srv0srv.cc:2363),start_thread(libpthread.so.0),clone(libc.so.6) [umshastr@hod03]~/bugs: