2021-01-25T07:54:29.838808Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2021-01-25T07:54:30.408460Z 0 [Warning] InnoDB: New log files created, LSN=45790 2021-01-25T07:54:30.624110Z 0 [Warning] InnoDB: Creating foreign key constraint system tables. 2021-01-25T07:54:30.720762Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 8e417958-5ee2-11eb-a9b8-fa163e996432. 2021-01-25T07:54:30.757099Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2021-01-25T07:54:31.111909Z 0 [Warning] CA certificate ca.pem is self signed. 2021-01-25T07:54:31.258492Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option. 2021-01-25T07:54:46.016406Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2021-01-25T07:54:46.018633Z 0 [Note] mysqld (mysqld 5.7.32-0ubuntu0.18.04.1) starting as process 41130 ... 2021-01-25T07:54:46.024942Z 0 [Note] InnoDB: PUNCH HOLE support available 2021-01-25T07:54:46.024974Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2021-01-25T07:54:46.024983Z 0 [Note] InnoDB: Uses event mutexes 2021-01-25T07:54:46.024990Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2021-01-25T07:54:46.024998Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-01-25T07:54:46.025005Z 0 [Note] InnoDB: Using Linux native AIO 2021-01-25T07:54:46.025334Z 0 [Note] InnoDB: Number of pools: 1 2021-01-25T07:54:46.025485Z 0 [Note] InnoDB: Using CPU crc32 instructions 2021-01-25T07:54:46.028104Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2021-01-25T07:54:46.040121Z 0 [Note] InnoDB: Completed initialization of buffer pool 2021-01-25T07:54:46.043560Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2021-01-25T07:54:46.055662Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2021-01-25T07:54:46.103404Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-01-25T07:54:46.103483Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-01-25T07:54:46.162873Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2021-01-25T07:54:46.163927Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2021-01-25T07:54:46.163944Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2021-01-25T07:54:46.164619Z 0 [Note] InnoDB: Waiting for purge to start 2021-01-25T07:54:46.214794Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 2747668 2021-01-25T07:54:46.215071Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2021-01-25T07:54:46.215385Z 0 [Note] Plugin 'FEDERATED' is disabled. 2021-01-25T07:54:46.217060Z 0 [Note] InnoDB: Buffer pool(s) load completed at 210125 7:54:46 2021-01-25T07:54:46.223451Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2021-01-25T07:54:46.223471Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2021-01-25T07:54:46.224277Z 0 [Warning] CA certificate ca.pem is self signed. 2021-01-25T07:54:46.224324Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2021-01-25T07:54:46.254377Z 0 [Warning] Insecure configuration for --pid-file: Location '/tmp' in the path is accessible to all OS users. Consider choosing a different directory. 2021-01-25T07:54:46.266174Z 0 [Note] Event Scheduler: Loaded 0 events 2021-01-25T07:54:46.266475Z 0 [Note] mysqld: ready for connections. Version: '5.7.32-0ubuntu0.18.04.1' socket: '/tmp/tmp.cBDRCTH7BN/mysqld.sock' port: 0 (Ubuntu) 2021-01-25T07:54:46.274637Z 2 [Note] Access denied for user 'root'@'localhost' (using password: NO) 2021-01-25T07:54:46.277578Z 0 [Note] Giving 0 client threads a chance to die gracefully 2021-01-25T07:54:46.277600Z 0 [Note] Shutting down slave threads 2021-01-25T07:54:46.277612Z 0 [Note] Forcefully disconnecting 0 remaining clients 2021-01-25T07:54:46.277620Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2021-01-25T07:54:46.277690Z 0 [Note] Binlog end 2021-01-25T07:54:46.278116Z 0 [Note] Shutting down plugin 'ngram' 2021-01-25T07:54:46.278131Z 0 [Note] Shutting down plugin 'partition' 2021-01-25T07:54:46.278138Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2021-01-25T07:54:46.278145Z 0 [Note] Shutting down plugin 'ARCHIVE' 2021-01-25T07:54:46.278151Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2021-01-25T07:54:46.278178Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2021-01-25T07:54:46.278185Z 0 [Note] Shutting down plugin 'MyISAM' 2021-01-25T07:54:46.278193Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2021-01-25T07:54:46.278200Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2021-01-25T07:54:46.278205Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2021-01-25T07:54:46.278210Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2021-01-25T07:54:46.278215Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2021-01-25T07:54:46.278220Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2021-01-25T07:54:46.278225Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2021-01-25T07:54:46.278230Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2021-01-25T07:54:46.278236Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2021-01-25T07:54:46.278241Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2021-01-25T07:54:46.278246Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2021-01-25T07:54:46.278251Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2021-01-25T07:54:46.278256Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2021-01-25T07:54:46.278261Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2021-01-25T07:54:46.278266Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2021-01-25T07:54:46.278272Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2021-01-25T07:54:46.278277Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2021-01-25T07:54:46.278282Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2021-01-25T07:54:46.278287Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2021-01-25T07:54:46.278292Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2021-01-25T07:54:46.278297Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2021-01-25T07:54:46.278303Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2021-01-25T07:54:46.278308Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2021-01-25T07:54:46.278313Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2021-01-25T07:54:46.278318Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2021-01-25T07:54:46.278323Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2021-01-25T07:54:46.278328Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2021-01-25T07:54:46.278333Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2021-01-25T07:54:46.278338Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2021-01-25T07:54:46.278343Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2021-01-25T07:54:46.278348Z 0 [Note] Shutting down plugin 'InnoDB' 2021-01-25T07:54:46.278420Z 0 [Note] InnoDB: FTS optimize thread exiting. 2021-01-25T07:54:46.278565Z 0 [Note] InnoDB: Starting shutdown... 2021-01-25T07:54:46.378775Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2021-01-25T07:54:46.379010Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 210125 7:54:46 2021-01-25T07:54:47.816007Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2747687 2021-01-25T07:54:47.818182Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-01-25T07:54:47.818201Z 0 [Note] Shutting down plugin 'MEMORY' 2021-01-25T07:54:47.818210Z 0 [Note] Shutting down plugin 'CSV' 2021-01-25T07:54:47.818229Z 0 [Note] Shutting down plugin 'sha256_password' 2021-01-25T07:54:47.818236Z 0 [Note] Shutting down plugin 'mysql_native_password' 2021-01-25T07:54:47.818409Z 0 [Note] Shutting down plugin 'binlog' 2021-01-25T07:54:47.819085Z 0 [Note] mysqld: Shutdown complete 2021-01-25T07:54:49.856664Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2021-01-25T07:54:49.858907Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.32-0ubuntu0.18.04.1) starting as process 41272 ... 2021-01-25T07:54:49.864894Z 0 [Note] InnoDB: PUNCH HOLE support available 2021-01-25T07:54:49.864934Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2021-01-25T07:54:49.864943Z 0 [Note] InnoDB: Uses event mutexes 2021-01-25T07:54:49.864951Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2021-01-25T07:54:49.864958Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-01-25T07:54:49.864966Z 0 [Note] InnoDB: Using Linux native AIO 2021-01-25T07:54:49.865297Z 0 [Note] InnoDB: Number of pools: 1 2021-01-25T07:54:49.865444Z 0 [Note] InnoDB: Using CPU crc32 instructions 2021-01-25T07:54:49.868164Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2021-01-25T07:54:49.881099Z 0 [Note] InnoDB: Completed initialization of buffer pool 2021-01-25T07:54:49.884004Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2021-01-25T07:54:49.896254Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2021-01-25T07:54:49.946623Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-01-25T07:54:49.946716Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-01-25T07:54:49.998940Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2021-01-25T07:54:49.999996Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2021-01-25T07:54:50.000014Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2021-01-25T07:54:50.000947Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 2747687 2021-01-25T07:54:50.001148Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2021-01-25T07:54:50.001438Z 0 [Note] Plugin 'FEDERATED' is disabled. 2021-01-25T07:54:50.003576Z 0 [Note] InnoDB: Buffer pool(s) load completed at 210125 7:54:49 2021-01-25T07:54:50.009132Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2021-01-25T07:54:50.009153Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2021-01-25T07:54:50.009971Z 0 [Warning] CA certificate ca.pem is self signed. 2021-01-25T07:54:50.010019Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2021-01-25T07:54:50.010125Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 2021-01-25T07:54:50.010149Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 2021-01-25T07:54:50.010201Z 0 [Note] Server socket created on IP: '127.0.0.1'. 2021-01-25T07:54:50.021114Z 0 [Note] Event Scheduler: Loaded 0 events 2021-01-25T07:54:50.021408Z 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.7.32-0ubuntu0.18.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu) 2021-01-25T08:01:24.050593Z 0 [Note] Giving 0 client threads a chance to die gracefully 2021-01-25T08:01:24.050633Z 0 [Note] Shutting down slave threads 2021-01-25T08:01:24.050645Z 0 [Note] Forcefully disconnecting 0 remaining clients 2021-01-25T08:01:24.050656Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2021-01-25T08:01:24.050737Z 0 [Note] Binlog end 2021-01-25T08:01:24.051424Z 0 [Note] Shutting down plugin 'ngram' 2021-01-25T08:01:24.051439Z 0 [Note] Shutting down plugin 'partition' 2021-01-25T08:01:24.051446Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2021-01-25T08:01:24.051465Z 0 [Note] Shutting down plugin 'ARCHIVE' 2021-01-25T08:01:24.051471Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2021-01-25T08:01:24.051507Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2021-01-25T08:01:24.051514Z 0 [Note] Shutting down plugin 'MyISAM' 2021-01-25T08:01:24.051523Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2021-01-25T08:01:24.051529Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2021-01-25T08:01:24.051535Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2021-01-25T08:01:24.051540Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2021-01-25T08:01:24.051545Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2021-01-25T08:01:24.051551Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2021-01-25T08:01:24.051556Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2021-01-25T08:01:24.051561Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2021-01-25T08:01:24.051566Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2021-01-25T08:01:24.051571Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2021-01-25T08:01:24.051576Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2021-01-25T08:01:24.051581Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2021-01-25T08:01:24.051587Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2021-01-25T08:01:24.051592Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2021-01-25T08:01:24.051597Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2021-01-25T08:01:24.051602Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2021-01-25T08:01:24.051607Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2021-01-25T08:01:24.051612Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2021-01-25T08:01:24.051618Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2021-01-25T08:01:24.051623Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2021-01-25T08:01:24.051628Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2021-01-25T08:01:24.051633Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2021-01-25T08:01:24.051638Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2021-01-25T08:01:24.051643Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2021-01-25T08:01:24.051649Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2021-01-25T08:01:24.051654Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2021-01-25T08:01:24.051659Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2021-01-25T08:01:24.051664Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2021-01-25T08:01:24.051669Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2021-01-25T08:01:24.051674Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2021-01-25T08:01:24.051679Z 0 [Note] Shutting down plugin 'InnoDB' 2021-01-25T08:01:24.051757Z 0 [Note] InnoDB: FTS optimize thread exiting. 2021-01-25T08:01:24.051900Z 0 [Note] InnoDB: Starting shutdown... 2021-01-25T08:01:24.152412Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2021-01-25T08:01:24.152705Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 210125 8:01:24 2021-01-25T08:01:25.710706Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2747715 2021-01-25T08:01:25.712870Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-01-25T08:01:25.712890Z 0 [Note] Shutting down plugin 'MEMORY' 2021-01-25T08:01:25.712898Z 0 [Note] Shutting down plugin 'CSV' 2021-01-25T08:01:25.712906Z 0 [Note] Shutting down plugin 'sha256_password' 2021-01-25T08:01:25.712912Z 0 [Note] Shutting down plugin 'mysql_native_password' 2021-01-25T08:01:25.713086Z 0 [Note] Shutting down plugin 'binlog' 2021-01-25T08:01:25.713496Z 0 [Note] /usr/sbin/mysqld: Shutdown complete 2021-01-25T08:01:25.821882Z 0 [Warning] Changed limits: max_open_files: 5000 (requested 5120) 2021-01-25T08:01:25.822163Z 0 [Warning] Changed limits: table_open_cache: 1983 (requested 2000) 2021-01-25T08:01:26.029311Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2021-01-25T08:01:26.031430Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.32-0ubuntu0.18.04.1) starting as process 63093 ... 2021-01-25T08:01:26.037492Z 0 [Note] InnoDB: PUNCH HOLE support available 2021-01-25T08:01:26.037520Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2021-01-25T08:01:26.037528Z 0 [Note] InnoDB: Uses event mutexes 2021-01-25T08:01:26.037536Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2021-01-25T08:01:26.037543Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-01-25T08:01:26.037551Z 0 [Note] InnoDB: Using Linux native AIO 2021-01-25T08:01:26.038343Z 0 [Note] InnoDB: Number of pools: 1 2021-01-25T08:01:26.038491Z 0 [Note] InnoDB: Using CPU crc32 instructions 2021-01-25T08:01:26.041248Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2021-01-25T08:01:26.054237Z 0 [Note] InnoDB: Completed initialization of buffer pool 2021-01-25T08:01:26.057201Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2021-01-25T08:01:26.069333Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2021-01-25T08:01:26.112596Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-01-25T08:01:26.112692Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-01-25T08:01:26.168594Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2021-01-25T08:01:26.169660Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2021-01-25T08:01:26.169678Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2021-01-25T08:01:26.170677Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 2747715 2021-01-25T08:01:26.170955Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2021-01-25T08:01:26.171212Z 0 [Note] Plugin 'FEDERATED' is disabled. 2021-01-25T08:01:26.172925Z 0 [Note] InnoDB: Buffer pool(s) load completed at 210125 8:01:26 2021-01-25T08:01:26.179004Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2021-01-25T08:01:26.179026Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2021-01-25T08:01:26.179845Z 0 [Warning] CA certificate ca.pem is self signed. 2021-01-25T08:01:26.179894Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2021-01-25T08:01:26.180003Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 2021-01-25T08:01:26.180021Z 0 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 2021-01-25T08:01:26.180073Z 0 [Note] Server socket created on IP: '0.0.0.0'. 2021-01-25T08:01:26.191588Z 0 [Note] Event Scheduler: Loaded 0 events 2021-01-25T08:01:26.191875Z 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.7.32-0ubuntu0.18.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu) 2021-01-25T08:02:29.656385Z 4 [Note] Aborted connection 4 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets) 2021-01-25T08:02:53.197575Z 5 [Note] Aborted connection 5 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets) 2021-01-25T08:10:15.561298Z 10 [Note] Aborted connection 10 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets) 2021-01-25T08:10:15.561469Z 11 [Note] Aborted connection 11 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets) 2021-01-25T08:10:25.670765Z 12 [Note] Aborted connection 12 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets) 2021-01-25T08:13:55.953663Z 19 [Note] Aborted connection 19 to db: 'cinder' user: 'root' host: 'localhost' (Got an error reading communication packets) 2021-01-25T08:14:05.199548Z 22 [Note] Aborted connection 22 to db: 'placement' user: 'root' host: 'localhost' (Got an error reading communication packets) 2021-01-25T08:15:11.243060Z 25 [Note] Aborted connection 25 to db: 'nova_api' user: 'root' host: 'localhost' (Got an error reading communication packets) 2021-01-25T08:15:15.227910Z 28 [Note] Aborted connection 28 to db: 'nova_api' user: 'root' host: 'localhost' (Got an error reading communication packets) 2021-01-25T08:17:09.185161Z 32 [Note] Aborted connection 32 to db: 'nova_cell1' user: 'root' host: 'localhost' (Got an error reading communication packets) 2021-01-25T08:17:09.185216Z 31 [Note] Aborted connection 31 to db: 'nova_cell1' user: 'root' host: 'localhost' (Got an error reading communication packets) 2021-01-25T08:18:58.458838Z 35 [Note] Aborted connection 35 to db: 'nova_cell0' user: 'root' host: 'localhost' (Got an error reading communication packets) 2021-01-25T08:18:58.458898Z 34 [Note] Aborted connection 34 to db: 'nova_cell0' user: 'root' host: 'localhost' (Got an error reading communication packets) 2021-01-25T08:18:58.459831Z 36 [Note] Aborted connection 36 to db: 'nova_cell0' user: 'root' host: 'localhost' (Got an error reading communication packets) 2021-01-25T08:18:58.459895Z 33 [Note] Aborted connection 33 to db: 'nova_api' user: 'root' host: 'localhost' (Got an error reading communication packets) 2021-01-25T08:19:02.530009Z 39 [Note] Aborted connection 39 to db: 'nova_cell0' user: 'root' host: 'localhost' (Got an error reading communication packets) 2021-01-25T08:19:02.530889Z 37 [Note] Aborted connection 37 to db: 'nova_cell0' user: 'root' host: 'localhost' (Got an error reading communication packets) 2021-01-25T08:19:02.530977Z 38 [Note] Aborted connection 38 to db: 'nova_api' user: 'root' host: 'localhost' (Got an error reading communication packets) 2021-01-25T08:19:06.524744Z 40 [Note] Aborted connection 40 to db: 'nova_api' user: 'root' host: 'localhost' (Got an error reading communication packets) 2021-01-25T08:20:49.442594Z 81 [Note] Aborted connection 81 to db: 'nova_api' user: 'root' host: 'localhost' (Got an error reading communication packets) 2021-01-25T08:22:15.414427Z 91 [Note] Aborted connection 91 to db: 'cinder' user: 'root' host: 'localhost' (Got an error reading communication packets) 2021-01-25T08:22:35.963206Z 102 [Note] Aborted connection 102 to db: 'nova_cell0' user: 'root' host: 'localhost' (Got an error reading communication packets) 2021-01-25T08:22:35.963273Z 101 [Note] Aborted connection 101 to db: 'nova_api' user: 'root' host: 'localhost' (Got an error reading communication packets) 2021-01-25T08:22:35.963798Z 103 [Note] Aborted connection 103 to db: 'nova_cell1' user: 'root' host: 'localhost' (Got an error reading communication packets) 2021-01-25T08:22:35.963867Z 104 [Note] Aborted connection 104 to db: 'nova_cell0' user: 'root' host: 'localhost' (Got an error reading communication packets) 2021-01-25T08:30:06.170711Z 107 [Note] Aborted connection 107 to db: 'nova_cell1' user: 'root' host: 'localhost' (Got an error reading communication packets) 2021-01-25T08:30:06.171652Z 106 [Note] Aborted connection 106 to db: 'nova_api' user: 'root' host: 'localhost' (Got an error reading communication packets) 2021-01-25T08:30:08.215870Z 48 [Note] Aborted connection 48 to db: 'nova_cell0' user: 'root' host: 'localhost' (Got an error reading communication packets) 2021-01-25T08:30:08.216167Z 45 [Note] Aborted connection 45 to db: 'nova_cell0' user: 'root' host: 'localhost' (Got an error reading communication packets) 2021-01-25T08:30:08.217945Z 47 [Note] Aborted connection 47 to db: 'nova_cell0' user: 'root' host: 'localhost' (Got an error reading communication packets) 2021-01-25T08:30:08.218145Z 43 [Note] Aborted connection 43 to db: 'nova_cell0' user: 'root' host: 'localhost' (Got an error reading communication packets) 2021-01-25T08:30:08.218205Z 44 [Note] Aborted connection 44 to db: 'nova_cell1' user: 'root' host: 'localhost' (Got an error reading communication packets) 2021-01-25T08:30:08.322225Z 105 [Note] Aborted connection 105 to db: 'nova_api' user: 'root' host: 'localhost' (Got an error reading communication packets) 2021-01-25T08:30:08.322305Z 46 [Note] Aborted connection 46 to db: 'nova_cell1' user: 'root' host: 'localhost' (Got an error reading communication packets) 2021-01-25T08:30:08.322461Z 42 [Note] Aborted connection 42 to db: 'nova_api' user: 'root' host: 'localhost' (Got an error reading communication packets) 2021-01-25T08:30:08.327934Z 41 [Note] Aborted connection 41 to db: 'nova_api' user: 'root' host: 'localhost' (Got an error reading communication packets) 2021-01-25T08:30:15.859185Z 80 [Note] Aborted connection 80 to db: 'nova_cell1' user: 'root' host: 'localhost' (Got an error reading communication packets) 2021-01-25T08:30:18.786763Z 79 [Note] Aborted connection 79 to db: 'nova_cell1' user: 'root' host: 'localhost' (Got an error reading communication packets) 2021-01-25T08:30:19.052393Z 78 [Note] Aborted connection 78 to db: 'nova_cell1' user: 'root' host: 'localhost' (Got an error reading communication packets) 2021-01-25T08:55:06.261201Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8425ms. The settings might not be optimal. (flushed=1 and evicted=0, during the time.) 2021-01-25T09:05:07.587769Z 251 [Note] Aborted connection 251 to db: 'cinder' user: 'root' host: 'localhost' (Got an error reading communication packets) 2021-01-25T09:05:11.984645Z 242 [Note] Aborted connection 242 to db: 'cinder' user: 'root' host: 'localhost' (Got an error reading communication packets) 2021-01-25T09:10:50.814710Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 14571ms. The settings might not be optimal. (flushed=1 and evicted=0, during the time.) 2021-01-25T09:11:47.207798Z 268 [Note] Aborted connection 268 to db: 'cinder' user: 'root' host: 'localhost' (Got an error reading communication packets) 2021-01-25T09:11:47.208619Z 296 [Note] Aborted connection 296 to db: 'cinder' user: 'root' host: 'localhost' (Got an error reading communication packets) 2021-01-25T09:16:15.284986Z 250 [Note] Aborted connection 250 to db: 'cinder' user: 'root' host: 'localhost' (Got an error reading communication packets) 2021-01-25T09:16:15.288471Z 287 [Note] Aborted connection 287 to db: 'cinder' user: 'root' host: 'localhost' (Got an error reading communication packets) 2021-01-25T09:19:53.761288Z 371 [Note] Aborted connection 371 to db: 'cinder' user: 'root' host: 'localhost' (Got an error reading communication packets) 2021-01-25T09:20:50.577343Z 472 [Note] Aborted connection 472 to db: 'cinder' user: 'root' host: 'localhost' (Got an error reading communication packets) 2021-01-25T09:23:00.158580Z 499 [Note] Aborted connection 499 to db: 'cinder' user: 'root' host: 'localhost' (Got an error reading communication packets) 2021-01-25T09:24:34.001578Z 530 [Note] Aborted connection 530 to db: 'cinder' user: 'root' host: 'localhost' (Got an error reading communication packets)