Bug #83705 | Assertion `!thd_get_cache_mngr(thd)->dbug_any_finalized()' while stopping master | ||
---|---|---|---|
Submitted: | 5 Nov 2016 16:50 | Modified: | 11 Nov 2016 12:24 |
Reporter: | Shahriyar Rzayev | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: Replication | Severity: | S2 (Serious) |
Version: | 5.6.32, 5.6.34 | OS: | Linux |
Assigned to: | CPU Architecture: | Any |
[5 Nov 2016 16:50]
Shahriyar Rzayev
[10 Nov 2016 12:41]
MySQL Verification Team
Hello Shahriyar, Thank you for the bug report and details. I'm not seeing any issues with current GA 5.6.34 and while bringing down server under the scenario you mentioned. Could you please try with 5.6.34 and let us know if you are still seeing this issue? Thanks.. -- Extract from error log pre/post shutdown 2016-11-09 12:21:22 1613 [Note] bin/mysqld: ready for connections. Version: '5.6.34-enterprise-commercial-advanced-log' socket: '/tmp/mysql_master.sock' port: 3306 MySQL Enterprise Server - Advanced Edition (Commercial) 2016-11-09 12:23:31 1613 [Warning] Disk is full writing '/ramdisk/83705/mysql-bin.000003' (Errcode: 28 - No space left on device). Waiting for someone to free space... 2016-11-09 12:23:31 1613 [Warning] Retry in 60 secs. Message reprinted in 600 secs 2016-11-09 12:25:31 1613 [Note] bin/mysqld: Normal shutdown 2016-11-09 12:25:31 1613 [Note] Giving 2 client threads a chance to die gracefully 2016-11-09 12:25:31 1613 [Note] Event Scheduler: Purging the queue. 0 events 2016-11-09 12:25:31 1613 [Note] Shutting down slave threads 2016-11-09 12:26:31 1613 [ERROR] An error occurred during flush stage of the commit. 'binlog_error_action' is set to 'IGNORE_ERROR'. Hence turning logging off for the whole duration of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it. 2016-11-09 12:26:33 1613 [Note] Forcefully disconnecting 0 remaining clients 2016-11-09 12:26:33 1613 [Note] Binlog end 2016-11-09 12:26:33 1613 [Note] Shutting down plugin 'partition' 2016-11-09 12:26:33 1613 [Note] Shutting down plugin 'ARCHIVE' 2016-11-09 12:26:33 1613 [Note] Shutting down plugin 'BLACKHOLE' 2016-11-09 12:26:33 1613 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2016-11-09 12:26:33 1613 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2016-11-09 12:26:33 1613 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2016-11-09 12:26:33 1613 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2016-11-09 12:26:33 1613 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2016-11-09 12:26:33 1613 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2016-11-09 12:26:33 1613 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2016-11-09 12:26:33 1613 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2016-11-09 12:26:33 1613 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2016-11-09 12:26:33 1613 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2016-11-09 12:26:33 1613 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2016-11-09 12:26:33 1613 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2016-11-09 12:26:33 1613 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2016-11-09 12:26:33 1613 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2016-11-09 12:26:33 1613 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2016-11-09 12:26:33 1613 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2016-11-09 12:26:33 1613 [Note] Shutting down plugin 'INNODB_METRICS' 2016-11-09 12:26:33 1613 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2016-11-09 12:26:33 1613 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2016-11-09 12:26:33 1613 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2016-11-09 12:26:33 1613 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2016-11-09 12:26:33 1613 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2016-11-09 12:26:33 1613 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2016-11-09 12:26:33 1613 [Note] Shutting down plugin 'INNODB_CMPMEM' 2016-11-09 12:26:33 1613 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2016-11-09 12:26:33 1613 [Note] Shutting down plugin 'INNODB_CMP' 2016-11-09 12:26:33 1613 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2016-11-09 12:26:33 1613 [Note] Shutting down plugin 'INNODB_LOCKS' 2016-11-09 12:26:33 1613 [Note] Shutting down plugin 'INNODB_TRX' 2016-11-09 12:26:33 1613 [Note] Shutting down plugin 'InnoDB' 2016-11-09 12:26:33 1613 [Note] InnoDB: FTS optimize thread exiting. 2016-11-09 12:26:33 1613 [Note] InnoDB: Starting shutdown... 2016-11-09 12:26:35 1613 [Note] InnoDB: Shutdown completed; log sequence number 221431215 2016-11-09 12:26:35 1613 [Note] Shutting down plugin 'CSV' 2016-11-09 12:26:35 1613 [Note] Shutting down plugin 'MEMORY' 2016-11-09 12:26:35 1613 [Note] Shutting down plugin 'MyISAM' 2016-11-09 12:26:35 1613 [Note] Shutting down plugin 'MRG_MYISAM' 2016-11-09 12:26:35 1613 [Note] Shutting down plugin 'sha256_password' 2016-11-09 12:26:35 1613 [Note] Shutting down plugin 'mysql_old_password' 2016-11-09 12:26:35 1613 [Note] Shutting down plugin 'mysql_native_password' 2016-11-09 12:26:35 1613 [Note] Shutting down plugin 'binlog' 2016-11-09 12:26:35 1613 [Note] bin/mysqld: Shutdown complete Thanks, Umesh
[10 Nov 2016 12:48]
Shahriyar Rzayev
Could you please check it using debug build?
[11 Nov 2016 12:24]
MySQL Verification Team
Thank you for the feedback. Observed that only debug build is affected and release build has no issues in stopping master server.