2017-01-23T17:00:48.498450Z 0 [Note] Giving 0 client threads a chance to die gracefully 2017-01-23T17:00:48.535741Z 0 [Note] Shutting down slave threads 2017-01-23T17:00:48.535758Z 0 [Note] Forcefully disconnecting 0 remaining clients 2017-01-23T17:00:48.535767Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2017-01-23T17:00:48.546015Z 0 [Note] Binlog end 2017-01-23T17:00:48.548170Z 0 [Note] Shutting down plugin 'validate_password' 2017-01-23T17:00:48.548191Z 0 [Note] Shutting down plugin 'ngram' 2017-01-23T17:00:48.548194Z 0 [Note] Shutting down plugin 'partition' 2017-01-23T17:00:48.548197Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2017-01-23T17:00:48.548199Z 0 [Note] Shutting down plugin 'ARCHIVE' 2017-01-23T17:00:48.548201Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2017-01-23T17:00:48.548218Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2017-01-23T17:00:48.548221Z 0 [Note] Shutting down plugin 'MyISAM' 2017-01-23T17:00:48.548226Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2017-01-23T17:00:48.548229Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2017-01-23T17:00:48.548231Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2017-01-23T17:00:48.548232Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2017-01-23T17:00:48.548234Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2017-01-23T17:00:48.548236Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2017-01-23T17:00:48.548238Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2017-01-23T17:00:48.548239Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2017-01-23T17:00:48.548241Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2017-01-23T17:00:48.548243Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2017-01-23T17:00:48.548245Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2017-01-23T17:00:48.548246Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2017-01-23T17:00:48.548248Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2017-01-23T17:00:48.548250Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2017-01-23T17:00:48.548252Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2017-01-23T17:00:48.548253Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2017-01-23T17:00:48.548255Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2017-01-23T17:00:48.548257Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2017-01-23T17:00:48.548259Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2017-01-23T17:00:48.548261Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2017-01-23T17:00:48.548262Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2017-01-23T17:00:48.548264Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2017-01-23T17:00:48.548266Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2017-01-23T17:00:48.548268Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2017-01-23T17:00:48.548270Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2017-01-23T17:00:48.548271Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2017-01-23T17:00:48.548273Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2017-01-23T17:00:48.548275Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2017-01-23T17:00:48.548277Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2017-01-23T17:00:48.548279Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2017-01-23T17:00:48.548280Z 0 [Note] Shutting down plugin 'InnoDB' 2017-01-23T17:00:48.548315Z 0 [Note] InnoDB: FTS optimize thread exiting. 2017-01-23T17:00:48.548536Z 0 [Note] InnoDB: Starting shutdown... 2017-01-23T17:00:48.648832Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2017-01-23T17:00:48.746997Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 170123 18:00:48 2017-01-23T17:00:50.261130Z 0 [Note] InnoDB: Shutdown completed; log sequence number 658895073 2017-01-23T17:00:50.281465Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2017-01-23T17:00:50.281504Z 0 [Note] Shutting down plugin 'MEMORY' 2017-01-23T17:00:50.281511Z 0 [Note] Shutting down plugin 'CSV' 2017-01-23T17:00:50.281517Z 0 [Note] Shutting down plugin 'sha256_password' 2017-01-23T17:00:50.281532Z 0 [Note] Shutting down plugin 'mysql_native_password' 2017-01-23T17:00:50.281864Z 0 [Note] Shutting down plugin 'binlog' 2017-01-23T17:00:50.325138Z 0 [Note] /usr/sbin/mysqld: Shutdown complete 2017-01-24T08:06:03.191666Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2017-01-24T08:06:03.191937Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000) 2017-01-24T08:06:03.491807Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-01-24T08:06:03.641698Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.17-0ubuntu0.16.10.1) starting as process 1362 ... 2017-01-24T08:06:04.512864Z 0 [Note] InnoDB: PUNCH HOLE support available 2017-01-24T08:06:04.512897Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-01-24T08:06:04.512902Z 0 [Note] InnoDB: Uses event mutexes 2017-01-24T08:06:04.512904Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2017-01-24T08:06:04.512908Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2017-01-24T08:06:04.512910Z 0 [Note] InnoDB: Using Linux native AIO 2017-01-24T08:06:04.605337Z 0 [Note] InnoDB: Number of pools: 1 2017-01-24T08:06:04.749520Z 0 [Note] InnoDB: Using CPU crc32 instructions 2017-01-24T08:06:04.750307Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2017-01-24T08:06:04.823926Z 0 [Note] InnoDB: Completed initialization of buffer pool 2017-01-24T08:06:04.849157Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2017-01-24T08:06:05.176275Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2017-01-24T08:06:09.697421Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2017-01-24T08:06:09.697581Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2017-01-24T08:06:09.873091Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2017-01-24T08:06:09.874981Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2017-01-24T08:06:09.875012Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2017-01-24T08:06:09.878354Z 0 [Note] InnoDB: 5.7.17 started; log sequence number 658895073 2017-01-24T08:06:09.878384Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5029ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.) 2017-01-24T08:06:09.882051Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2017-01-24T08:06:09.924081Z 0 [Note] Plugin 'FEDERATED' is disabled. 2017-01-24T08:06:10.751908Z 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-24T08:06:10.751933Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 2017-01-24T08:06:10.751941Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 2017-01-24T08:06:10.751962Z 0 [Note] Server socket created on IP: '127.0.0.1'. 2017-01-24T08:06:13.411160Z 0 [Note] Event Scheduler: Loaded 0 events 2017-01-24T08:06:13.411505Z 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-24T08:06:13.411533Z 0 [Note] Beginning of list of non-natively partitioned tables 2017-01-24T08:06:14.495081Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170124 9:06:14 2017-01-24T08:06:24.518269Z 0 [Note] End of list of non-natively partitioned tables 2017-01-24T08:06:24.518505Z 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.7.17-0ubuntu0.16.10.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu) 2017-01-24T08:06:24.557006Z 3 [Note] Access denied for user 'root'@'localhost' (using password: NO) 2017-01-24T08:09:25.384443Z 0 [Note] Giving 0 client threads a chance to die gracefully 2017-01-24T08:09:25.384463Z 0 [Note] Shutting down slave threads 2017-01-24T08:09:25.384467Z 0 [Note] Forcefully disconnecting 0 remaining clients 2017-01-24T08:09:25.384470Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2017-01-24T08:09:25.399827Z 0 [Note] Binlog end 2017-01-24T08:09:25.400565Z 0 [Note] Shutting down plugin 'validate_password' 2017-01-24T08:09:25.400576Z 0 [Note] Shutting down plugin 'ngram' 2017-01-24T08:09:25.400578Z 0 [Note] Shutting down plugin 'partition' 2017-01-24T08:09:25.400580Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2017-01-24T08:09:25.400582Z 0 [Note] Shutting down plugin 'ARCHIVE' 2017-01-24T08:09:25.400584Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2017-01-24T08:09:25.400594Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2017-01-24T08:09:25.400596Z 0 [Note] Shutting down plugin 'MyISAM' 2017-01-24T08:09:25.400600Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2017-01-24T08:09:25.400601Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2017-01-24T08:09:25.400603Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2017-01-24T08:09:25.400605Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2017-01-24T08:09:25.400606Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2017-01-24T08:09:25.400607Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2017-01-24T08:09:25.400609Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2017-01-24T08:09:25.400610Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2017-01-24T08:09:25.400612Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2017-01-24T08:09:25.400613Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2017-01-24T08:09:25.400615Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2017-01-24T08:09:25.400616Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2017-01-24T08:09:25.400618Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2017-01-24T08:09:25.400619Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2017-01-24T08:09:25.400621Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2017-01-24T08:09:25.400622Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2017-01-24T08:09:25.400624Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2017-01-24T08:09:25.400625Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2017-01-24T08:09:25.400627Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2017-01-24T08:09:25.400628Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2017-01-24T08:09:25.400629Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2017-01-24T08:09:25.400631Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2017-01-24T08:09:25.400632Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2017-01-24T08:09:25.400634Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2017-01-24T08:09:25.400635Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2017-01-24T08:09:25.400637Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2017-01-24T08:09:25.400638Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2017-01-24T08:09:25.400640Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2017-01-24T08:09:25.400641Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2017-01-24T08:09:25.400642Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2017-01-24T08:09:25.400644Z 0 [Note] Shutting down plugin 'InnoDB' 2017-01-24T08:09:25.400683Z 0 [Note] InnoDB: FTS optimize thread exiting. 2017-01-24T08:09:25.400747Z 0 [Note] InnoDB: Starting shutdown... 2017-01-24T08:09:25.501686Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2017-01-24T08:09:25.501825Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 170124 9:09:25 2017-01-24T08:09:27.054974Z 0 [Note] InnoDB: Shutdown completed; log sequence number 658895101 2017-01-24T08:09:27.056210Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2017-01-24T08:09:27.056218Z 0 [Note] Shutting down plugin 'MEMORY' 2017-01-24T08:09:27.056221Z 0 [Note] Shutting down plugin 'CSV' 2017-01-24T08:09:27.056224Z 0 [Note] Shutting down plugin 'sha256_password' 2017-01-24T08:09:27.056225Z 0 [Note] Shutting down plugin 'mysql_native_password' 2017-01-24T08:09:27.056341Z 0 [Note] Shutting down plugin 'binlog' 2017-01-24T08:09:27.056714Z 0 [Note] /usr/sbin/mysqld: Shutdown complete 2017-01-24T08:11:55.766140Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2017-01-24T08:11:55.766189Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000) 2017-01-24T08:11:55.983875Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-01-24T08:11:56.036623Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.17-0ubuntu0.16.10.1) starting as process 1327 ... 2017-01-24T08:11:56.589690Z 0 [Note] InnoDB: PUNCH HOLE support available 2017-01-24T08:11:56.589751Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-01-24T08:11:56.589764Z 0 [Note] InnoDB: Uses event mutexes 2017-01-24T08:11:56.589773Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2017-01-24T08:11:56.589784Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2017-01-24T08:11:56.589793Z 0 [Note] InnoDB: Using Linux native AIO 2017-01-24T08:11:56.639820Z 0 [Note] InnoDB: Number of pools: 1 2017-01-24T08:11:56.726109Z 0 [Note] InnoDB: Using CPU crc32 instructions 2017-01-24T08:11:56.731375Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2017-01-24T08:11:56.792300Z 0 [Note] InnoDB: Completed initialization of buffer pool 2017-01-24T08:11:56.799702Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2017-01-24T08:11:57.004930Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2017-01-24T08:12:01.705293Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2017-01-24T08:12:01.705359Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2017-01-24T08:12:01.890319Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2017-01-24T08:12:01.891083Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2017-01-24T08:12:01.891093Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2017-01-24T08:12:01.892558Z 0 [Note] InnoDB: Waiting for purge to start 2017-01-24T08:12:01.947255Z 0 [Note] InnoDB: 5.7.17 started; log sequence number 658895101 2017-01-24T08:12:01.947341Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5148ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.) 2017-01-24T08:12:01.958036Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2017-01-24T08:12:01.991155Z 0 [Note] Plugin 'FEDERATED' is disabled. 2017-01-24T08:12:02.611314Z 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-24T08:12:02.611344Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 2017-01-24T08:12:02.611357Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 2017-01-24T08:12:02.611382Z 0 [Note] Server socket created on IP: '127.0.0.1'. 2017-01-24T08:12:03.053625Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170124 9:12:03 2017-01-24T08:12:03.945295Z 0 [Note] Event Scheduler: Loaded 0 events 2017-01-24T08:12:03.945487Z 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-24T08:12:03.945508Z 0 [Note] Beginning of list of non-natively partitioned tables 2017-01-24T08:12:08.911348Z 0 [Note] End of list of non-natively partitioned tables 2017-01-24T08:12:08.911540Z 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.7.17-0ubuntu0.16.10.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu) 2017-01-24T08:12:08.925093Z 3 [Note] Access denied for user 'root'@'localhost' (using password: NO)