2019-04-30T15:35:10.875277Z 0 [Note] Giving 1 client threads a chance to die gracefully 2019-04-30T15:35:10.875321Z 0 [Note] Shutting down slave threads 2019-04-30T15:35:20.877754Z 0 [Note] Forcefully disconnecting 0 remaining clients 2019-04-30T15:35:20.877828Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2019-04-30T15:35:20.878035Z 0 [Note] Binlog end 2019-04-30T15:35:20.884685Z 0 [Note] Shutting down plugin 'ngram' 2019-04-30T15:35:20.884732Z 0 [Note] Shutting down plugin 'ARCHIVE' 2019-04-30T15:35:20.884744Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2019-04-30T15:35:20.884754Z 0 [Note] Shutting down plugin 'partition' 2019-04-30T15:35:20.884763Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2019-04-30T15:35:20.884771Z 0 [Note] Shutting down plugin 'CSV' 2019-04-30T15:35:20.884781Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2019-04-30T15:35:20.884835Z 0 [Note] Shutting down plugin 'MyISAM' 2019-04-30T15:35:20.884849Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2019-04-30T15:35:20.884857Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2019-04-30T15:35:20.884865Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2019-04-30T15:35:20.884873Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2019-04-30T15:35:20.884881Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2019-04-30T15:35:20.884888Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2019-04-30T15:35:20.884896Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2019-04-30T15:35:20.884903Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2019-04-30T15:35:20.884911Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2019-04-30T15:35:20.884918Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2019-04-30T15:35:20.884926Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2019-04-30T15:35:20.884933Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2019-04-30T15:35:20.884941Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2019-04-30T15:35:20.884949Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2019-04-30T15:35:20.884956Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2019-04-30T15:35:20.884964Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2019-04-30T15:35:20.884971Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2019-04-30T15:35:20.884979Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2019-04-30T15:35:20.884986Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2019-04-30T15:35:20.884994Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2019-04-30T15:35:20.885001Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2019-04-30T15:35:20.885009Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2019-04-30T15:35:20.885017Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2019-04-30T15:35:20.885024Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2019-04-30T15:35:20.885032Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2019-04-30T15:35:20.885039Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2019-04-30T15:35:20.885047Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2019-04-30T15:35:20.885055Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2019-04-30T15:35:20.885062Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2019-04-30T15:35:20.885070Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2019-04-30T15:35:20.885077Z 0 [Note] Shutting down plugin 'InnoDB' 2019-04-30T15:35:20.885198Z 0 [Note] InnoDB: FTS optimize thread exiting. 2019-04-30T15:35:20.885517Z 0 [Note] InnoDB: Starting shutdown... 2019-04-30T15:35:20.985868Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2019-04-30T15:35:20.987440Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 190430 18:35:20 2019-04-30T15:35:21.920160Z 0 [Note] InnoDB: Shutdown completed; log sequence number 68105549595 2019-04-30T15:35:21.920237Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-04-30T15:35:21.920243Z 0 [Note] Shutting down plugin 'MEMORY' 2019-04-30T15:35:21.920283Z 0 [Note] Shutting down plugin 'sha256_password' 2019-04-30T15:35:21.920285Z 0 [Note] Shutting down plugin 'mysql_native_password' 2019-04-30T15:35:21.920385Z 0 [Note] Shutting down plugin 'binlog' 2019-04-30T15:35:21.920918Z 0 [Note] Unable to delete pid file: No such file or directory 2019-04-30T15:35:21.920923Z 0 [Note] /usr/sbin/mysqld: Shutdown complete 2019-05-06T08:13:46.653156Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2019-05-06T08:13:46.653195Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000) 2019-05-06T08:13:46.804540Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2019-05-06T08:13:46.804548Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release. 2019-05-06T08:13:46.806550Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.26-0ubuntu0.16.04.1-log) starting as process 1145 ... 2019-05-06T08:13:46.831876Z 0 [Note] InnoDB: PUNCH HOLE support available 2019-05-06T08:13:46.831888Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-05-06T08:13:46.831890Z 0 [Note] InnoDB: Uses event mutexes 2019-05-06T08:13:46.831893Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2019-05-06T08:13:46.831895Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2019-05-06T08:13:46.831897Z 0 [Note] InnoDB: Using Linux native AIO 2019-05-06T08:13:46.833895Z 0 [Note] InnoDB: Number of pools: 1 2019-05-06T08:13:46.835939Z 0 [Note] InnoDB: Using CPU crc32 instructions 2019-05-06T08:13:46.836762Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2019-05-06T08:13:46.842317Z 0 [Note] InnoDB: Completed initialization of buffer pool 2019-05-06T08:13:46.843859Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-05-06T08:13:46.860999Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2019-05-06T08:13:46.926281Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-05-06T08:13:46.926316Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-05-06T08:13:46.956631Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2019-05-06T08:13:46.957181Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2019-05-06T08:13:46.957187Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2019-05-06T08:13:46.957469Z 0 [Note] InnoDB: Waiting for purge to start 2019-05-06T08:13:47.007605Z 0 [Note] InnoDB: 5.7.26 started; log sequence number 68105549595 2019-05-06T08:13:47.007695Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2019-05-06T08:13:47.007801Z 0 [Note] Plugin 'FEDERATED' is disabled. 2019-05-06T08:13:47.039436Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2019-05-06T08:13:47.039445Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 2019-05-06T08:13:47.039452Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 2019-05-06T08:13:47.039464Z 0 [Note] Server socket created on IP: '127.0.0.1'. 2019-05-06T08:13:47.065666Z 0 [Note] Failed to start slave threads for channel '' 2019-05-06T08:13:47.102398Z 0 [Note] Event Scheduler: Loaded 0 events 2019-05-06T08:13:47.102500Z 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.7.26-0ubuntu0.16.04.1-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu) 2019-05-06T08:13:47.105301Z 2 [Note] Start binlog_dump to master_thread_id(2) slave_server(2), pos(mysql-bin.000111, 154) 2019-05-06T08:13:47.629980Z 4 [Note] Access denied for user 'root'@'localhost' (using password: NO) 2019-05-06T08:13:47.630060Z 3 [Note] Access denied for user 'root'@'localhost' (using password: NO) 2019-05-06T08:13:48.111562Z 0 [Note] InnoDB: Buffer pool(s) load completed at 190506 11:13:48