2020-10-27T22:28:38.766272Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2020-10-27T22:28:38.966448Z 0 [Warning] InnoDB: New log files created, LSN=45790 2020-10-27T22:28:39.021074Z 0 [Warning] InnoDB: Creating foreign key constraint system tables. 2020-10-27T22:28:39.038163Z 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: c2b617d2-18a3-11eb-85e9-fa163e77e42a. 2020-10-27T22:28:39.041088Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2020-10-27T22:28:39.450039Z 0 [Warning] CA certificate ca.pem is self signed. 2020-10-27T22:28:39.644392Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option. 2020-10-27T22:28:46.231648Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2020-10-27T22:28:46.233809Z 0 [Note] mysqld (mysqld 5.7.32-0ubuntu0.18.04.1) starting as process 41535 ... 2020-10-27T22:28:46.240344Z 0 [Note] InnoDB: PUNCH HOLE support available 2020-10-27T22:28:46.240379Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2020-10-27T22:28:46.240388Z 0 [Note] InnoDB: Uses event mutexes 2020-10-27T22:28:46.240396Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2020-10-27T22:28:46.240403Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2020-10-27T22:28:46.240410Z 0 [Note] InnoDB: Using Linux native AIO 2020-10-27T22:28:46.240740Z 0 [Note] InnoDB: Number of pools: 1 2020-10-27T22:28:46.240887Z 0 [Note] InnoDB: Using CPU crc32 instructions 2020-10-27T22:28:46.243443Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2020-10-27T22:28:46.256045Z 0 [Note] InnoDB: Completed initialization of buffer pool 2020-10-27T22:28:46.258878Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2020-10-27T22:28:46.271050Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2020-10-27T22:28:46.282260Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2020-10-27T22:28:46.282336Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2020-10-27T22:28:46.302280Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2020-10-27T22:28:46.303433Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2020-10-27T22:28:46.303452Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2020-10-27T22:28:46.304736Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 2747070 2020-10-27T22:28:46.305561Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2020-10-27T22:28:46.305790Z 0 [Note] Plugin 'FEDERATED' is disabled. 2020-10-27T22:28:46.307598Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201027 22:28:46 2020-10-27T22:28:46.314017Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2020-10-27T22:28:46.314038Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2020-10-27T22:28:46.314871Z 0 [Warning] CA certificate ca.pem is self signed. 2020-10-27T22:28:46.314920Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2020-10-27T22:28:46.317645Z 0 [Warning] Insecure configuration for --pid-file: Location '/tmp' in the path is accessible to all OS users. Consider choosing a different directory. 2020-10-27T22:28:46.329474Z 0 [Note] Event Scheduler: Loaded 0 events 2020-10-27T22:28:46.329970Z 0 [Note] mysqld: ready for connections. Version: '5.7.32-0ubuntu0.18.04.1' socket: '/tmp/tmp.Eas72jtZ3a/mysqld.sock' port: 0 (Ubuntu) 2020-10-27T22:28:46.344204Z 2 [Note] Access denied for user 'root'@'localhost' (using password: NO) 2020-10-27T22:28:46.348640Z 0 [Note] Giving 0 client threads a chance to die gracefully 2020-10-27T22:28:46.348685Z 0 [Note] Shutting down slave threads 2020-10-27T22:28:46.348703Z 0 [Note] Forcefully disconnecting 0 remaining clients 2020-10-27T22:28:46.348716Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2020-10-27T22:28:46.348889Z 0 [Note] Binlog end 2020-10-27T22:28:46.349288Z 0 [Note] Shutting down plugin 'ngram' 2020-10-27T22:28:46.349302Z 0 [Note] Shutting down plugin 'partition' 2020-10-27T22:28:46.349308Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2020-10-27T22:28:46.349315Z 0 [Note] Shutting down plugin 'ARCHIVE' 2020-10-27T22:28:46.349320Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2020-10-27T22:28:46.349346Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2020-10-27T22:28:46.349352Z 0 [Note] Shutting down plugin 'MyISAM' 2020-10-27T22:28:46.349361Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2020-10-27T22:28:46.349367Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2020-10-27T22:28:46.349372Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2020-10-27T22:28:46.349377Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2020-10-27T22:28:46.349382Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2020-10-27T22:28:46.349387Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2020-10-27T22:28:46.349392Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2020-10-27T22:28:46.349397Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2020-10-27T22:28:46.349402Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2020-10-27T22:28:46.349407Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2020-10-27T22:28:46.349412Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2020-10-27T22:28:46.349417Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2020-10-27T22:28:46.349422Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2020-10-27T22:28:46.349427Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2020-10-27T22:28:46.349432Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2020-10-27T22:28:46.349437Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2020-10-27T22:28:46.349442Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2020-10-27T22:28:46.349447Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2020-10-27T22:28:46.349452Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2020-10-27T22:28:46.349457Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2020-10-27T22:28:46.349462Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2020-10-27T22:28:46.349466Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2020-10-27T22:28:46.349471Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2020-10-27T22:28:46.349476Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2020-10-27T22:28:46.349481Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2020-10-27T22:28:46.349486Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2020-10-27T22:28:46.349491Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2020-10-27T22:28:46.349496Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2020-10-27T22:28:46.349500Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2020-10-27T22:28:46.349505Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2020-10-27T22:28:46.349510Z 0 [Note] Shutting down plugin 'InnoDB' 2020-10-27T22:28:46.349622Z 0 [Note] InnoDB: FTS optimize thread exiting. 2020-10-27T22:28:46.349893Z 0 [Note] InnoDB: Starting shutdown... 2020-10-27T22:28:46.450287Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2020-10-27T22:28:46.450822Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 201027 22:28:46 2020-10-27T22:28:47.963648Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2747089 2020-10-27T22:28:47.967304Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2020-10-27T22:28:47.967338Z 0 [Note] Shutting down plugin 'MEMORY' 2020-10-27T22:28:47.967351Z 0 [Note] Shutting down plugin 'CSV' 2020-10-27T22:28:47.967364Z 0 [Note] Shutting down plugin 'sha256_password' 2020-10-27T22:28:47.967391Z 0 [Note] Shutting down plugin 'mysql_native_password' 2020-10-27T22:28:47.967672Z 0 [Note] Shutting down plugin 'binlog' 2020-10-27T22:28:47.968321Z 0 [Note] mysqld: Shutdown complete 2020-10-27T22:28:49.999083Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2020-10-27T22:28:50.001285Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.32-0ubuntu0.18.04.1) starting as process 41679 ... 2020-10-27T22:28:50.007487Z 0 [Note] InnoDB: PUNCH HOLE support available 2020-10-27T22:28:50.007529Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2020-10-27T22:28:50.007538Z 0 [Note] InnoDB: Uses event mutexes 2020-10-27T22:28:50.007545Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2020-10-27T22:28:50.007553Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2020-10-27T22:28:50.007560Z 0 [Note] InnoDB: Using Linux native AIO 2020-10-27T22:28:50.007884Z 0 [Note] InnoDB: Number of pools: 1 2020-10-27T22:28:50.008037Z 0 [Note] InnoDB: Using CPU crc32 instructions 2020-10-27T22:28:50.010737Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2020-10-27T22:28:50.023118Z 0 [Note] InnoDB: Completed initialization of buffer pool 2020-10-27T22:28:50.026568Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2020-10-27T22:28:50.040023Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2020-10-27T22:28:50.061611Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2020-10-27T22:28:50.061705Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2020-10-27T22:28:50.082993Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2020-10-27T22:28:50.084060Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2020-10-27T22:28:50.084076Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2020-10-27T22:28:50.084831Z 0 [Note] InnoDB: Waiting for purge to start 2020-10-27T22:28:50.135101Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 2747089 2020-10-27T22:28:50.135424Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2020-10-27T22:28:50.136138Z 0 [Note] Plugin 'FEDERATED' is disabled. 2020-10-27T22:28:50.139534Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201027 22:28:50 2020-10-27T22:28:50.148511Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2020-10-27T22:28:50.148544Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2020-10-27T22:28:50.149877Z 0 [Warning] CA certificate ca.pem is self signed. 2020-10-27T22:28:50.149955Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2020-10-27T22:28:50.150133Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 2020-10-27T22:28:50.150163Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 2020-10-27T22:28:50.150215Z 0 [Note] Server socket created on IP: '127.0.0.1'. 2020-10-27T22:28:50.168302Z 0 [Note] Event Scheduler: Loaded 0 events 2020-10-27T22:28:50.168888Z 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) 2020-10-27T22:36:09.427102Z 0 [Note] Giving 0 client threads a chance to die gracefully 2020-10-27T22:36:09.427143Z 0 [Note] Shutting down slave threads 2020-10-27T22:36:09.427156Z 0 [Note] Forcefully disconnecting 0 remaining clients 2020-10-27T22:36:09.427166Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2020-10-27T22:36:09.427285Z 0 [Note] Binlog end 2020-10-27T22:36:09.427916Z 0 [Note] Shutting down plugin 'ngram' 2020-10-27T22:36:09.427929Z 0 [Note] Shutting down plugin 'partition' 2020-10-27T22:36:09.427936Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2020-10-27T22:36:09.427956Z 0 [Note] Shutting down plugin 'ARCHIVE' 2020-10-27T22:36:09.427962Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2020-10-27T22:36:09.428000Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2020-10-27T22:36:09.428007Z 0 [Note] Shutting down plugin 'MyISAM' 2020-10-27T22:36:09.428016Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2020-10-27T22:36:09.428022Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2020-10-27T22:36:09.428027Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2020-10-27T22:36:09.428033Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2020-10-27T22:36:09.428038Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2020-10-27T22:36:09.428043Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2020-10-27T22:36:09.428048Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2020-10-27T22:36:09.428053Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2020-10-27T22:36:09.428058Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2020-10-27T22:36:09.428063Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2020-10-27T22:36:09.428069Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2020-10-27T22:36:09.428074Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2020-10-27T22:36:09.428078Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2020-10-27T22:36:09.428083Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2020-10-27T22:36:09.428088Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2020-10-27T22:36:09.428094Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2020-10-27T22:36:09.428098Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2020-10-27T22:36:09.428103Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2020-10-27T22:36:09.428109Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2020-10-27T22:36:09.428114Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2020-10-27T22:36:09.428119Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2020-10-27T22:36:09.428124Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2020-10-27T22:36:09.428129Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2020-10-27T22:36:09.428134Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2020-10-27T22:36:09.428139Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2020-10-27T22:36:09.428144Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2020-10-27T22:36:09.428149Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2020-10-27T22:36:09.428154Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2020-10-27T22:36:09.428160Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2020-10-27T22:36:09.428165Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2020-10-27T22:36:09.428170Z 0 [Note] Shutting down plugin 'InnoDB' 2020-10-27T22:36:09.428285Z 0 [Note] InnoDB: FTS optimize thread exiting. 2020-10-27T22:36:09.428560Z 0 [Note] InnoDB: Starting shutdown... 2020-10-27T22:36:09.528961Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2020-10-27T22:36:09.529371Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 201027 22:36:09 2020-10-27T22:36:11.045270Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2747117 2020-10-27T22:36:11.048918Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2020-10-27T22:36:11.048953Z 0 [Note] Shutting down plugin 'MEMORY' 2020-10-27T22:36:11.048968Z 0 [Note] Shutting down plugin 'CSV' 2020-10-27T22:36:11.048979Z 0 [Note] Shutting down plugin 'sha256_password' 2020-10-27T22:36:11.048990Z 0 [Note] Shutting down plugin 'mysql_native_password' 2020-10-27T22:36:11.049260Z 0 [Note] Shutting down plugin 'binlog' 2020-10-27T22:36:11.049900Z 0 [Note] /usr/sbin/mysqld: Shutdown complete 2020-10-27T22:36:11.169918Z 0 [Warning] Changed limits: max_open_files: 5000 (requested 5120) 2020-10-27T22:36:11.170203Z 0 [Warning] Changed limits: table_open_cache: 1983 (requested 2000) 2020-10-27T22:36:11.372517Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2020-10-27T22:36:11.374694Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.32-0ubuntu0.18.04.1) starting as process 63216 ... 2020-10-27T22:36:11.380941Z 0 [Note] InnoDB: PUNCH HOLE support available 2020-10-27T22:36:11.380974Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2020-10-27T22:36:11.380982Z 0 [Note] InnoDB: Uses event mutexes 2020-10-27T22:36:11.380989Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2020-10-27T22:36:11.380996Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2020-10-27T22:36:11.381004Z 0 [Note] InnoDB: Using Linux native AIO 2020-10-27T22:36:11.381787Z 0 [Note] InnoDB: Number of pools: 1 2020-10-27T22:36:11.381934Z 0 [Note] InnoDB: Using CPU crc32 instructions 2020-10-27T22:36:11.384716Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2020-10-27T22:36:11.396308Z 0 [Note] InnoDB: Completed initialization of buffer pool 2020-10-27T22:36:11.399244Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2020-10-27T22:36:11.411350Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2020-10-27T22:36:11.431179Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2020-10-27T22:36:11.431259Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2020-10-27T22:36:11.449914Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2020-10-27T22:36:11.451220Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2020-10-27T22:36:11.451241Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2020-10-27T22:36:11.452276Z 0 [Note] InnoDB: Waiting for purge to start 2020-10-27T22:36:11.502548Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 2747117 2020-10-27T22:36:11.503059Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2020-10-27T22:36:11.503306Z 0 [Note] Plugin 'FEDERATED' is disabled. 2020-10-27T22:36:11.506252Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201027 22:36:11 2020-10-27T22:36:11.515682Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2020-10-27T22:36:11.515714Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2020-10-27T22:36:11.517078Z 0 [Warning] CA certificate ca.pem is self signed. 2020-10-27T22:36:11.517156Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2020-10-27T22:36:11.517334Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 2020-10-27T22:36:11.517373Z 0 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 2020-10-27T22:36:11.517452Z 0 [Note] Server socket created on IP: '0.0.0.0'. 2020-10-27T22:36:11.536302Z 0 [Note] Event Scheduler: Loaded 0 events 2020-10-27T22:36:11.536896Z 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) 2020-10-27T22:36:34.427238Z 4 [Note] Aborted connection 4 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets) 2020-10-27T22:36:47.927811Z 5 [Note] Aborted connection 5 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets) 2020-10-27T22:43:51.938224Z 10 [Note] Aborted connection 10 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets) 2020-10-27T22:43:51.938398Z 11 [Note] Aborted connection 11 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets) 2020-10-27T22:43:56.374198Z 12 [Note] Aborted connection 12 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets) 2020-10-27T22:45:37.487264Z 6 [Note] Aborted connection 6 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets) 2020-10-27T22:45:37.489159Z 7 [Note] Aborted connection 7 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets) 2020-10-27T22:50:18.403572Z 20 [Warning] Following users were specified in CREATE USER IF NOT EXISTS but they already exist. Corresponding entry in binary log used default authentication plugin 'mysql_native_password' to rewrite authentication information(if any) for them: 'root'@'%' 2020-10-27T22:50:18.663574Z 0 [Note] Giving 0 client threads a chance to die gracefully 2020-10-27T22:50:18.663623Z 0 [Note] Shutting down slave threads 2020-10-27T22:50:18.663638Z 0 [Note] Forcefully disconnecting 0 remaining clients 2020-10-27T22:50:18.663649Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2020-10-27T22:50:18.663769Z 0 [Note] Binlog end 2020-10-27T22:50:18.665581Z 0 [Note] Shutting down plugin 'ngram' 2020-10-27T22:50:18.665598Z 0 [Note] Shutting down plugin 'partition' 2020-10-27T22:50:18.665605Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2020-10-27T22:50:18.665613Z 0 [Note] Shutting down plugin 'ARCHIVE' 2020-10-27T22:50:18.665618Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2020-10-27T22:50:18.665657Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2020-10-27T22:50:18.665664Z 0 [Note] Shutting down plugin 'MyISAM' 2020-10-27T22:50:18.665674Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2020-10-27T22:50:18.665681Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2020-10-27T22:50:18.665687Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2020-10-27T22:50:18.665692Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2020-10-27T22:50:18.665698Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2020-10-27T22:50:18.665704Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2020-10-27T22:50:18.665709Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2020-10-27T22:50:18.665715Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2020-10-27T22:50:18.665720Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2020-10-27T22:50:18.665725Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2020-10-27T22:50:18.665731Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2020-10-27T22:50:18.665736Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2020-10-27T22:50:18.665741Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2020-10-27T22:50:18.665747Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2020-10-27T22:50:18.665752Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2020-10-27T22:50:18.665757Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2020-10-27T22:50:18.665763Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2020-10-27T22:50:18.665768Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2020-10-27T22:50:18.665773Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2020-10-27T22:50:18.665779Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2020-10-27T22:50:18.665784Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2020-10-27T22:50:18.665790Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2020-10-27T22:50:18.665795Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2020-10-27T22:50:18.665800Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2020-10-27T22:50:18.665806Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2020-10-27T22:50:18.665812Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2020-10-27T22:50:18.665817Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2020-10-27T22:50:18.665822Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2020-10-27T22:50:18.665828Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2020-10-27T22:50:18.665833Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2020-10-27T22:50:18.665839Z 0 [Note] Shutting down plugin 'InnoDB' 2020-10-27T22:50:18.665955Z 0 [Note] InnoDB: FTS optimize thread exiting. 2020-10-27T22:50:18.666231Z 0 [Note] InnoDB: Starting shutdown... 2020-10-27T22:50:18.766706Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2020-10-27T22:50:18.767498Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 201027 22:50:18 2020-10-27T22:50:20.294691Z 0 [Note] InnoDB: Shutdown completed; log sequence number 11940723 2020-10-27T22:50:20.298308Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2020-10-27T22:50:20.298364Z 0 [Note] Shutting down plugin 'MEMORY' 2020-10-27T22:50:20.298380Z 0 [Note] Shutting down plugin 'CSV' 2020-10-27T22:50:20.298392Z 0 [Note] Shutting down plugin 'sha256_password' 2020-10-27T22:50:20.298401Z 0 [Note] Shutting down plugin 'mysql_native_password' 2020-10-27T22:50:20.298750Z 0 [Note] Shutting down plugin 'binlog' 2020-10-27T22:50:20.299724Z 0 [Note] /usr/sbin/mysqld: Shutdown complete 2020-10-27T22:50:20.419263Z 0 [Warning] Changed limits: max_open_files: 5000 (requested 5120) 2020-10-27T22:50:20.419560Z 0 [Warning] Changed limits: table_open_cache: 1983 (requested 2000) 2020-10-27T22:50:20.634406Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2020-10-27T22:50:20.636603Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.32-0ubuntu0.18.04.1) starting as process 105722 ... 2020-10-27T22:50:20.642973Z 0 [Note] InnoDB: PUNCH HOLE support available 2020-10-27T22:50:20.643013Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2020-10-27T22:50:20.643022Z 0 [Note] InnoDB: Uses event mutexes 2020-10-27T22:50:20.643029Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2020-10-27T22:50:20.643037Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2020-10-27T22:50:20.643044Z 0 [Note] InnoDB: Using Linux native AIO 2020-10-27T22:50:20.643848Z 0 [Note] InnoDB: Number of pools: 1 2020-10-27T22:50:20.643998Z 0 [Note] InnoDB: Using CPU crc32 instructions 2020-10-27T22:50:20.646882Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2020-10-27T22:50:20.658986Z 0 [Note] InnoDB: Completed initialization of buffer pool 2020-10-27T22:50:20.661956Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2020-10-27T22:50:20.674071Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2020-10-27T22:50:20.707688Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2020-10-27T22:50:20.707796Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2020-10-27T22:50:20.725715Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2020-10-27T22:50:20.727564Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2020-10-27T22:50:20.727597Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2020-10-27T22:50:20.729639Z 0 [Note] InnoDB: Waiting for purge to start 2020-10-27T22:50:20.779935Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 11940723 2020-10-27T22:50:20.780850Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2020-10-27T22:50:20.781049Z 0 [Note] Plugin 'FEDERATED' is disabled. 2020-10-27T22:50:20.794923Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2020-10-27T22:50:20.794969Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2020-10-27T22:50:20.815539Z 0 [Warning] CA certificate ca.pem is self signed. 2020-10-27T22:50:20.815590Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2020-10-27T22:50:20.815704Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 2020-10-27T22:50:20.815723Z 0 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 2020-10-27T22:50:20.815779Z 0 [Note] Server socket created on IP: '0.0.0.0'. 2020-10-27T22:50:20.818322Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201027 22:50:20 2020-10-27T22:50:20.828805Z 0 [Note] Event Scheduler: Loaded 0 events 2020-10-27T22:50:20.829290Z 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) 2020-10-27T22:50:45.910457Z 4 [Note] Aborted connection 4 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets) 2020-10-27T22:50:59.437588Z 5 [Note] Aborted connection 5 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets) 2020-10-27T22:58:08.190859Z 10 [Note] Aborted connection 10 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets) 2020-10-27T22:58:08.191029Z 11 [Note] Aborted connection 11 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets) 2020-10-27T22:58:12.600185Z 12 [Note] Aborted connection 12 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets) 2020-10-27T22:59:58.182245Z 7 [Note] Aborted connection 7 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets) 2020-10-27T22:59:58.190707Z 6 [Note] Aborted connection 6 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets) 2020-10-27T23:04:41.228676Z 20 [Warning] Following users were specified in CREATE USER IF NOT EXISTS but they already exist. Corresponding entry in binary log used default authentication plugin 'mysql_native_password' to rewrite authentication information(if any) for them: 'root'@'%' 2020-10-27T23:04:41.482143Z 0 [Note] Giving 0 client threads a chance to die gracefully 2020-10-27T23:04:41.482182Z 0 [Note] Shutting down slave threads 2020-10-27T23:04:41.482195Z 0 [Note] Forcefully disconnecting 0 remaining clients 2020-10-27T23:04:41.482206Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2020-10-27T23:04:41.482316Z 0 [Note] Binlog end 2020-10-27T23:04:41.484447Z 0 [Note] Shutting down plugin 'ngram' 2020-10-27T23:04:41.484469Z 0 [Note] Shutting down plugin 'partition' 2020-10-27T23:04:41.484477Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2020-10-27T23:04:41.484485Z 0 [Note] Shutting down plugin 'ARCHIVE' 2020-10-27T23:04:41.484491Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2020-10-27T23:04:41.484529Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2020-10-27T23:04:41.484537Z 0 [Note] Shutting down plugin 'MyISAM' 2020-10-27T23:04:41.484546Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2020-10-27T23:04:41.484553Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2020-10-27T23:04:41.484559Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2020-10-27T23:04:41.484565Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2020-10-27T23:04:41.484571Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2020-10-27T23:04:41.484576Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2020-10-27T23:04:41.484582Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2020-10-27T23:04:41.484588Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2020-10-27T23:04:41.484594Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2020-10-27T23:04:41.484599Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2020-10-27T23:04:41.484605Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2020-10-27T23:04:41.484611Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2020-10-27T23:04:41.484617Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2020-10-27T23:04:41.484623Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2020-10-27T23:04:41.484628Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2020-10-27T23:04:41.484634Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2020-10-27T23:04:41.484640Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2020-10-27T23:04:41.484646Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2020-10-27T23:04:41.484651Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2020-10-27T23:04:41.484657Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2020-10-27T23:04:41.484663Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2020-10-27T23:04:41.484668Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2020-10-27T23:04:41.484674Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2020-10-27T23:04:41.484679Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2020-10-27T23:04:41.484685Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2020-10-27T23:04:41.484705Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2020-10-27T23:04:41.484711Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2020-10-27T23:04:41.484716Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2020-10-27T23:04:41.484721Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2020-10-27T23:04:41.484726Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2020-10-27T23:04:41.484731Z 0 [Note] Shutting down plugin 'InnoDB' 2020-10-27T23:04:41.484866Z 0 [Note] InnoDB: FTS optimize thread exiting. 2020-10-27T23:04:41.485144Z 0 [Note] InnoDB: Starting shutdown... 2020-10-27T23:04:41.585553Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2020-10-27T23:04:41.586494Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 201027 23:04:41 2020-10-27T23:04:43.014984Z 0 [Note] InnoDB: Shutdown completed; log sequence number 23038538 2020-10-27T23:04:43.018769Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2020-10-27T23:04:43.018806Z 0 [Note] Shutting down plugin 'MEMORY' 2020-10-27T23:04:43.018822Z 0 [Note] Shutting down plugin 'CSV' 2020-10-27T23:04:43.018835Z 0 [Note] Shutting down plugin 'sha256_password' 2020-10-27T23:04:43.018844Z 0 [Note] Shutting down plugin 'mysql_native_password' 2020-10-27T23:04:43.019119Z 0 [Note] Shutting down plugin 'binlog' 2020-10-27T23:04:43.020069Z 0 [Note] /usr/sbin/mysqld: Shutdown complete 2020-10-27T23:04:43.141568Z 0 [Warning] Changed limits: max_open_files: 5000 (requested 5120) 2020-10-27T23:04:43.141841Z 0 [Warning] Changed limits: table_open_cache: 1983 (requested 2000) 2020-10-27T23:04:43.356010Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2020-10-27T23:04:43.358231Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.32-0ubuntu0.18.04.1) starting as process 17433 ... 2020-10-27T23:04:43.364656Z 0 [Note] InnoDB: PUNCH HOLE support available 2020-10-27T23:04:43.364686Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2020-10-27T23:04:43.364695Z 0 [Note] InnoDB: Uses event mutexes 2020-10-27T23:04:43.364703Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2020-10-27T23:04:43.364711Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2020-10-27T23:04:43.364719Z 0 [Note] InnoDB: Using Linux native AIO 2020-10-27T23:04:43.365537Z 0 [Note] InnoDB: Number of pools: 1 2020-10-27T23:04:43.365696Z 0 [Note] InnoDB: Using CPU crc32 instructions 2020-10-27T23:04:43.368672Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2020-10-27T23:04:43.380531Z 0 [Note] InnoDB: Completed initialization of buffer pool 2020-10-27T23:04:43.383557Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2020-10-27T23:04:43.395794Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2020-10-27T23:04:43.430543Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2020-10-27T23:04:43.430676Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2020-10-27T23:04:43.450241Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2020-10-27T23:04:43.451428Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2020-10-27T23:04:43.451449Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2020-10-27T23:04:43.452422Z 0 [Note] InnoDB: Waiting for purge to start 2020-10-27T23:04:43.502732Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 23038538 2020-10-27T23:04:43.503534Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2020-10-27T23:04:43.503914Z 0 [Note] Plugin 'FEDERATED' is disabled. 2020-10-27T23:04:43.531515Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2020-10-27T23:04:43.531545Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2020-10-27T23:04:43.532396Z 0 [Warning] CA certificate ca.pem is self signed. 2020-10-27T23:04:43.532441Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2020-10-27T23:04:43.532553Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 2020-10-27T23:04:43.532572Z 0 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 2020-10-27T23:04:43.532627Z 0 [Note] Server socket created on IP: '0.0.0.0'. 2020-10-27T23:04:43.558870Z 0 [Note] Event Scheduler: Loaded 0 events 2020-10-27T23:04:43.559744Z 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) 2020-10-27T23:04:44.518531Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201027 23:04:44 2020-10-27T23:05:08.114884Z 4 [Note] Aborted connection 4 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets) 2020-10-27T23:05:21.629437Z 5 [Note] Aborted connection 5 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets) 2020-10-27T23:12:31.312069Z 10 [Note] Aborted connection 10 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets) 2020-10-27T23:12:31.312250Z 11 [Note] Aborted connection 11 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets) 2020-10-27T23:12:35.752211Z 12 [Note] Aborted connection 12 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets) 2020-10-27T23:14:21.212006Z 6 [Note] Aborted connection 6 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets) 2020-10-27T23:14:21.212970Z 7 [Note] Aborted connection 7 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets) 2020-10-27T23:19:04.928912Z 20 [Warning] Following users were specified in CREATE USER IF NOT EXISTS but they already exist. Corresponding entry in binary log used default authentication plugin 'mysql_native_password' to rewrite authentication information(if any) for them: 'root'@'%' 2020-10-27T23:19:05.173192Z 0 [Note] Giving 0 client threads a chance to die gracefully 2020-10-27T23:19:05.173232Z 0 [Note] Shutting down slave threads 2020-10-27T23:19:05.173244Z 0 [Note] Forcefully disconnecting 0 remaining clients 2020-10-27T23:19:05.173255Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2020-10-27T23:19:05.173353Z 0 [Note] Binlog end 2020-10-27T23:19:05.175283Z 0 [Note] Shutting down plugin 'ngram' 2020-10-27T23:19:05.175302Z 0 [Note] Shutting down plugin 'partition' 2020-10-27T23:19:05.175309Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2020-10-27T23:19:05.175317Z 0 [Note] Shutting down plugin 'ARCHIVE' 2020-10-27T23:19:05.175323Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2020-10-27T23:19:05.175361Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2020-10-27T23:19:05.175368Z 0 [Note] Shutting down plugin 'MyISAM' 2020-10-27T23:19:05.175378Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2020-10-27T23:19:05.175384Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2020-10-27T23:19:05.175390Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2020-10-27T23:19:05.175396Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2020-10-27T23:19:05.175402Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2020-10-27T23:19:05.175408Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2020-10-27T23:19:05.175414Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2020-10-27T23:19:05.175420Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2020-10-27T23:19:05.175425Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2020-10-27T23:19:05.175431Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2020-10-27T23:19:05.175437Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2020-10-27T23:19:05.175442Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2020-10-27T23:19:05.175448Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2020-10-27T23:19:05.175453Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2020-10-27T23:19:05.175474Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2020-10-27T23:19:05.175480Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2020-10-27T23:19:05.175485Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2020-10-27T23:19:05.175490Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2020-10-27T23:19:05.175495Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2020-10-27T23:19:05.175501Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2020-10-27T23:19:05.175506Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2020-10-27T23:19:05.175511Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2020-10-27T23:19:05.175516Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2020-10-27T23:19:05.175521Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2020-10-27T23:19:05.175526Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2020-10-27T23:19:05.175532Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2020-10-27T23:19:05.175537Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2020-10-27T23:19:05.175542Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2020-10-27T23:19:05.175547Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2020-10-27T23:19:05.175552Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2020-10-27T23:19:05.175557Z 0 [Note] Shutting down plugin 'InnoDB' 2020-10-27T23:19:05.175680Z 0 [Note] InnoDB: FTS optimize thread exiting. 2020-10-27T23:19:05.175918Z 0 [Note] InnoDB: Starting shutdown... 2020-10-27T23:19:05.276340Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2020-10-27T23:19:05.277700Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 201027 23:19:05 2020-10-27T23:19:06.707998Z 0 [Note] InnoDB: Shutdown completed; log sequence number 33987547 2020-10-27T23:19:06.711896Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2020-10-27T23:19:06.711932Z 0 [Note] Shutting down plugin 'MEMORY' 2020-10-27T23:19:06.711947Z 0 [Note] Shutting down plugin 'CSV' 2020-10-27T23:19:06.711959Z 0 [Note] Shutting down plugin 'sha256_password' 2020-10-27T23:19:06.711969Z 0 [Note] Shutting down plugin 'mysql_native_password' 2020-10-27T23:19:06.712249Z 0 [Note] Shutting down plugin 'binlog' 2020-10-27T23:19:06.713216Z 0 [Note] /usr/sbin/mysqld: Shutdown complete 2020-10-27T23:19:06.834501Z 0 [Warning] Changed limits: max_open_files: 5000 (requested 5120) 2020-10-27T23:19:06.834800Z 0 [Warning] Changed limits: table_open_cache: 1983 (requested 2000) 2020-10-27T23:19:07.043743Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2020-10-27T23:19:07.045945Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.32-0ubuntu0.18.04.1) starting as process 60011 ... 2020-10-27T23:19:07.052290Z 0 [Note] InnoDB: PUNCH HOLE support available 2020-10-27T23:19:07.052328Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2020-10-27T23:19:07.052337Z 0 [Note] InnoDB: Uses event mutexes 2020-10-27T23:19:07.052345Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2020-10-27T23:19:07.052352Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2020-10-27T23:19:07.052359Z 0 [Note] InnoDB: Using Linux native AIO 2020-10-27T23:19:07.053176Z 0 [Note] InnoDB: Number of pools: 1 2020-10-27T23:19:07.053323Z 0 [Note] InnoDB: Using CPU crc32 instructions 2020-10-27T23:19:07.056378Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2020-10-27T23:19:07.068287Z 0 [Note] InnoDB: Completed initialization of buffer pool 2020-10-27T23:19:07.071850Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2020-10-27T23:19:07.085382Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2020-10-27T23:19:07.131858Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2020-10-27T23:19:07.131960Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2020-10-27T23:19:07.158687Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2020-10-27T23:19:07.160552Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2020-10-27T23:19:07.160584Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2020-10-27T23:19:07.161768Z 0 [Note] InnoDB: Waiting for purge to start 2020-10-27T23:19:07.212045Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 33987547 2020-10-27T23:19:07.213236Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2020-10-27T23:19:07.213625Z 0 [Note] Plugin 'FEDERATED' is disabled. 2020-10-27T23:19:07.251314Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2020-10-27T23:19:07.251345Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2020-10-27T23:19:07.252192Z 0 [Warning] CA certificate ca.pem is self signed. 2020-10-27T23:19:07.252243Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2020-10-27T23:19:07.252356Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 2020-10-27T23:19:07.252381Z 0 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 2020-10-27T23:19:07.252436Z 0 [Note] Server socket created on IP: '0.0.0.0'. 2020-10-27T23:19:07.286839Z 0 [Note] Event Scheduler: Loaded 0 events 2020-10-27T23:19:07.287365Z 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) 2020-10-27T23:19:08.227241Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201027 23:19:08 2020-10-27T23:19:32.779602Z 4 [Note] Aborted connection 4 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets) 2020-10-27T23:19:46.418258Z 5 [Note] Aborted connection 5 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets) 2020-10-27T23:26:56.073200Z 10 [Note] Aborted connection 10 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets) 2020-10-27T23:26:56.073372Z 11 [Note] Aborted connection 11 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets) 2020-10-27T23:27:00.541033Z 12 [Note] Aborted connection 12 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets) 2020-10-27T23:28:51.433972Z 7 [Note] Aborted connection 7 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets) 2020-10-27T23:28:51.433982Z 6 [Note] Aborted connection 6 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)