2020-10-29T21:23:01.448786Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-10-29T21:23:01.632948Z 0 [Warning] InnoDB: New log files created, LSN=45790
2020-10-29T21:23:01.677021Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2020-10-29T21:23:01.690898Z 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: ecb21444-1a2c-11eb-a104-fa163e02b558.
2020-10-29T21:23:01.692357Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2020-10-29T21:23:02.508817Z 0 [Warning] CA certificate ca.pem is self signed.
2020-10-29T21:23:02.748936Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
2020-10-29T21:23:09.865344Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-10-29T21:23:09.867490Z 0 [Note] mysqld (mysqld 5.7.32-0ubuntu0.18.04.1) starting as process 41565 ...
2020-10-29T21:23:09.874375Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-10-29T21:23:09.874416Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-10-29T21:23:09.874425Z 0 [Note] InnoDB: Uses event mutexes
2020-10-29T21:23:09.874433Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-10-29T21:23:09.874441Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-10-29T21:23:09.874449Z 0 [Note] InnoDB: Using Linux native AIO
2020-10-29T21:23:09.874777Z 0 [Note] InnoDB: Number of pools: 1
2020-10-29T21:23:09.874925Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-10-29T21:23:09.877452Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-10-29T21:23:09.890441Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-10-29T21:23:09.893362Z 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-29T21:23:09.905486Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-10-29T21:23:09.916716Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-10-29T21:23:09.916803Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-10-29T21:23:09.940521Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-10-29T21:23:09.941594Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-10-29T21:23:09.941612Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-10-29T21:23:09.942683Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 2747070
2020-10-29T21:23:09.942898Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-10-29T21:23:09.943170Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-10-29T21:23:09.944921Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201029 21:23:09
2020-10-29T21:23:09.951508Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2020-10-29T21:23:09.951530Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2020-10-29T21:23:09.952337Z 0 [Warning] CA certificate ca.pem is self signed.
2020-10-29T21:23:09.952385Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2020-10-29T21:23:09.953813Z 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-29T21:23:09.966675Z 0 [Note] Event Scheduler: Loaded 0 events
2020-10-29T21:23:09.967011Z 0 [Note] mysqld: ready for connections.
Version: '5.7.32-0ubuntu0.18.04.1'  socket: '/tmp/tmp.7GSYAhso6v/mysqld.sock'  port: 0  (Ubuntu)
2020-10-29T21:23:09.975393Z 2 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2020-10-29T21:23:09.978437Z 0 [Note] Giving 0 client threads a chance to die gracefully
2020-10-29T21:23:09.978472Z 0 [Note] Shutting down slave threads
2020-10-29T21:23:09.978491Z 0 [Note] Forcefully disconnecting 0 remaining clients
2020-10-29T21:23:09.978503Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2020-10-29T21:23:09.978588Z 0 [Note] Binlog end
2020-10-29T21:23:09.979071Z 0 [Note] Shutting down plugin 'ngram'
2020-10-29T21:23:09.979087Z 0 [Note] Shutting down plugin 'partition'
2020-10-29T21:23:09.979094Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2020-10-29T21:23:09.979101Z 0 [Note] Shutting down plugin 'ARCHIVE'
2020-10-29T21:23:09.979107Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2020-10-29T21:23:09.979140Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2020-10-29T21:23:09.979148Z 0 [Note] Shutting down plugin 'MyISAM'
2020-10-29T21:23:09.979157Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2020-10-29T21:23:09.979164Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2020-10-29T21:23:09.979169Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2020-10-29T21:23:09.979175Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2020-10-29T21:23:09.979181Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2020-10-29T21:23:09.979186Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2020-10-29T21:23:09.979192Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2020-10-29T21:23:09.979197Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2020-10-29T21:23:09.979203Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2020-10-29T21:23:09.979209Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2020-10-29T21:23:09.979214Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2020-10-29T21:23:09.979220Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2020-10-29T21:23:09.979225Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2020-10-29T21:23:09.979231Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2020-10-29T21:23:09.979236Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2020-10-29T21:23:09.979242Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2020-10-29T21:23:09.979248Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2020-10-29T21:23:09.979253Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2020-10-29T21:23:09.979258Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2020-10-29T21:23:09.979264Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2020-10-29T21:23:09.979269Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2020-10-29T21:23:09.979275Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2020-10-29T21:23:09.979280Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2020-10-29T21:23:09.979285Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2020-10-29T21:23:09.979291Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2020-10-29T21:23:09.979297Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2020-10-29T21:23:09.979302Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2020-10-29T21:23:09.979307Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2020-10-29T21:23:09.979313Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2020-10-29T21:23:09.979319Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2020-10-29T21:23:09.979324Z 0 [Note] Shutting down plugin 'InnoDB'
2020-10-29T21:23:09.979397Z 0 [Note] InnoDB: FTS optimize thread exiting.
2020-10-29T21:23:09.979524Z 0 [Note] InnoDB: Starting shutdown...
2020-10-29T21:23:10.079760Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2020-10-29T21:23:10.080138Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 201029 21:23:10
2020-10-29T21:23:11.589392Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2747089
2020-10-29T21:23:11.591571Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-10-29T21:23:11.591592Z 0 [Note] Shutting down plugin 'MEMORY'
2020-10-29T21:23:11.591600Z 0 [Note] Shutting down plugin 'CSV'
2020-10-29T21:23:11.591609Z 0 [Note] Shutting down plugin 'sha256_password'
2020-10-29T21:23:11.591628Z 0 [Note] Shutting down plugin 'mysql_native_password'
2020-10-29T21:23:11.591803Z 0 [Note] Shutting down plugin 'binlog'
2020-10-29T21:23:11.592253Z 0 [Note] mysqld: Shutdown complete

2020-10-29T21:23:13.536506Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-10-29T21:23:13.538703Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.32-0ubuntu0.18.04.1) starting as process 41707 ...
2020-10-29T21:23:13.545605Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-10-29T21:23:13.545643Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-10-29T21:23:13.545652Z 0 [Note] InnoDB: Uses event mutexes
2020-10-29T21:23:13.545660Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-10-29T21:23:13.545668Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-10-29T21:23:13.545676Z 0 [Note] InnoDB: Using Linux native AIO
2020-10-29T21:23:13.546008Z 0 [Note] InnoDB: Number of pools: 1
2020-10-29T21:23:13.546156Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-10-29T21:23:13.548891Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-10-29T21:23:13.561577Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-10-29T21:23:13.564819Z 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-29T21:23:13.577057Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-10-29T21:23:13.595476Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-10-29T21:23:13.595567Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-10-29T21:23:13.620105Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-10-29T21:23:13.621188Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-10-29T21:23:13.621206Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-10-29T21:23:13.621917Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 2747089
2020-10-29T21:23:13.622307Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-10-29T21:23:13.622592Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-10-29T21:23:13.624965Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201029 21:23:13
2020-10-29T21:23:13.630491Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2020-10-29T21:23:13.630515Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2020-10-29T21:23:13.631351Z 0 [Warning] CA certificate ca.pem is self signed.
2020-10-29T21:23:13.631401Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2020-10-29T21:23:13.631512Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2020-10-29T21:23:13.631530Z 0 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
2020-10-29T21:23:13.631582Z 0 [Note] Server socket created on IP: '127.0.0.1'.
2020-10-29T21:23:13.643035Z 0 [Note] Event Scheduler: Loaded 0 events
2020-10-29T21:23:13.643388Z 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-29T21:29:32.607365Z 0 [Note] Giving 0 client threads a chance to die gracefully
2020-10-29T21:29:32.607401Z 0 [Note] Shutting down slave threads
2020-10-29T21:29:32.607414Z 0 [Note] Forcefully disconnecting 0 remaining clients
2020-10-29T21:29:32.607424Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2020-10-29T21:29:32.607500Z 0 [Note] Binlog end
2020-10-29T21:29:32.608200Z 0 [Note] Shutting down plugin 'ngram'
2020-10-29T21:29:32.608216Z 0 [Note] Shutting down plugin 'partition'
2020-10-29T21:29:32.608223Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2020-10-29T21:29:32.608230Z 0 [Note] Shutting down plugin 'ARCHIVE'
2020-10-29T21:29:32.608248Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2020-10-29T21:29:32.608284Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2020-10-29T21:29:32.608291Z 0 [Note] Shutting down plugin 'MyISAM'
2020-10-29T21:29:32.608300Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2020-10-29T21:29:32.608307Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2020-10-29T21:29:32.608312Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2020-10-29T21:29:32.608317Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2020-10-29T21:29:32.608323Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2020-10-29T21:29:32.608328Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2020-10-29T21:29:32.608333Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2020-10-29T21:29:32.608338Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2020-10-29T21:29:32.608343Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2020-10-29T21:29:32.608348Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2020-10-29T21:29:32.608353Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2020-10-29T21:29:32.608358Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2020-10-29T21:29:32.608363Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2020-10-29T21:29:32.608368Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2020-10-29T21:29:32.608373Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2020-10-29T21:29:32.608378Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2020-10-29T21:29:32.608383Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2020-10-29T21:29:32.608388Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2020-10-29T21:29:32.608393Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2020-10-29T21:29:32.608398Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2020-10-29T21:29:32.608403Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2020-10-29T21:29:32.608408Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2020-10-29T21:29:32.608413Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2020-10-29T21:29:32.608418Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2020-10-29T21:29:32.608423Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2020-10-29T21:29:32.608428Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2020-10-29T21:29:32.608433Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2020-10-29T21:29:32.608438Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2020-10-29T21:29:32.608443Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2020-10-29T21:29:32.608448Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2020-10-29T21:29:32.608453Z 0 [Note] Shutting down plugin 'InnoDB'
2020-10-29T21:29:32.608528Z 0 [Note] InnoDB: FTS optimize thread exiting.
2020-10-29T21:29:32.608668Z 0 [Note] InnoDB: Starting shutdown...
2020-10-29T21:29:32.708908Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2020-10-29T21:29:32.709286Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 201029 21:29:32
2020-10-29T21:29:34.318297Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2747117
2020-10-29T21:29:34.320516Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-10-29T21:29:34.320538Z 0 [Note] Shutting down plugin 'MEMORY'
2020-10-29T21:29:34.320547Z 0 [Note] Shutting down plugin 'CSV'
2020-10-29T21:29:34.320555Z 0 [Note] Shutting down plugin 'sha256_password'
2020-10-29T21:29:34.320561Z 0 [Note] Shutting down plugin 'mysql_native_password'
2020-10-29T21:29:34.320738Z 0 [Note] Shutting down plugin 'binlog'
2020-10-29T21:29:34.321167Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2020-10-29T21:29:34.430534Z 0 [Warning] Changed limits: max_open_files: 5000 (requested 5120)
2020-10-29T21:29:34.430817Z 0 [Warning] Changed limits: table_open_cache: 1983 (requested 2000)
2020-10-29T21:29:34.637438Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-10-29T21:29:34.639567Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.32-0ubuntu0.18.04.1) starting as process 63466 ...
2020-10-29T21:29:34.645861Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-10-29T21:29:34.645895Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-10-29T21:29:34.645904Z 0 [Note] InnoDB: Uses event mutexes
2020-10-29T21:29:34.645912Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-10-29T21:29:34.645920Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-10-29T21:29:34.645927Z 0 [Note] InnoDB: Using Linux native AIO
2020-10-29T21:29:34.646719Z 0 [Note] InnoDB: Number of pools: 1
2020-10-29T21:29:34.646865Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-10-29T21:29:34.649589Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-10-29T21:29:34.661643Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-10-29T21:29:34.664590Z 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-29T21:29:34.676732Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-10-29T21:29:34.695883Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-10-29T21:29:34.695979Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-10-29T21:29:34.720888Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-10-29T21:29:34.721968Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-10-29T21:29:34.721986Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-10-29T21:29:34.722825Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 2747117
2020-10-29T21:29:34.723067Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-10-29T21:29:34.723369Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-10-29T21:29:34.725110Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201029 21:29:34
2020-10-29T21:29:34.731193Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2020-10-29T21:29:34.731215Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2020-10-29T21:29:34.732064Z 0 [Warning] CA certificate ca.pem is self signed.
2020-10-29T21:29:34.732116Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2020-10-29T21:29:34.732226Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
2020-10-29T21:29:34.732245Z 0 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
2020-10-29T21:29:34.732281Z 0 [Note] Server socket created on IP: '0.0.0.0'.
2020-10-29T21:29:34.745216Z 0 [Note] Event Scheduler: Loaded 0 events
2020-10-29T21:29:34.745663Z 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-29T21:29:56.632748Z 4 [Note] Aborted connection 4 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T21:30:10.374132Z 5 [Note] Aborted connection 5 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T21:37:16.827222Z 10 [Note] Aborted connection 10 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T21:37:16.827430Z 11 [Note] Aborted connection 11 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T21:37:21.265397Z 12 [Note] Aborted connection 12 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T21:38:58.762258Z 19 [Note] Aborted connection 19 to db: 'cinder' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T21:39:03.622271Z 22 [Note] Aborted connection 22 to db: 'placement' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T21:39:48.478653Z 25 [Note] Aborted connection 25 to db: 'nova_api' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T21:39:52.721435Z 28 [Note] Aborted connection 28 to db: 'nova_api' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T21:40:07.866295Z 7 [Note] Aborted connection 7 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T21:40:07.867411Z 6 [Note] Aborted connection 6 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T21:44:58.485106Z 32 [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-29T21:44:58.743581Z 0 [Note] Giving 0 client threads a chance to die gracefully
2020-10-29T21:44:58.743624Z 0 [Note] Shutting down slave threads
2020-10-29T21:44:58.743637Z 0 [Note] Forcefully disconnecting 0 remaining clients
2020-10-29T21:44:58.743648Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2020-10-29T21:44:58.743727Z 0 [Note] Binlog end
2020-10-29T21:44:58.745999Z 0 [Note] Shutting down plugin 'ngram'
2020-10-29T21:44:58.746017Z 0 [Note] Shutting down plugin 'partition'
2020-10-29T21:44:58.746025Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2020-10-29T21:44:58.746033Z 0 [Note] Shutting down plugin 'ARCHIVE'
2020-10-29T21:44:58.746039Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2020-10-29T21:44:58.746077Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2020-10-29T21:44:58.746085Z 0 [Note] Shutting down plugin 'MyISAM'
2020-10-29T21:44:58.746094Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2020-10-29T21:44:58.746101Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2020-10-29T21:44:58.746107Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2020-10-29T21:44:58.746113Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2020-10-29T21:44:58.746119Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2020-10-29T21:44:58.746125Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2020-10-29T21:44:58.746131Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2020-10-29T21:44:58.746137Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2020-10-29T21:44:58.746143Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2020-10-29T21:44:58.746149Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2020-10-29T21:44:58.746155Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2020-10-29T21:44:58.746161Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2020-10-29T21:44:58.746166Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2020-10-29T21:44:58.746172Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2020-10-29T21:44:58.746178Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2020-10-29T21:44:58.746184Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2020-10-29T21:44:58.746190Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2020-10-29T21:44:58.746196Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2020-10-29T21:44:58.746201Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2020-10-29T21:44:58.746207Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2020-10-29T21:44:58.746213Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2020-10-29T21:44:58.746219Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2020-10-29T21:44:58.746224Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2020-10-29T21:44:58.746230Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2020-10-29T21:44:58.746236Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2020-10-29T21:44:58.746241Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2020-10-29T21:44:58.746247Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2020-10-29T21:44:58.746253Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2020-10-29T21:44:58.746259Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2020-10-29T21:44:58.746264Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2020-10-29T21:44:58.746270Z 0 [Note] Shutting down plugin 'InnoDB'
2020-10-29T21:44:58.746373Z 0 [Note] InnoDB: FTS optimize thread exiting.
2020-10-29T21:44:58.746524Z 0 [Note] InnoDB: Starting shutdown...
2020-10-29T21:44:58.846758Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2020-10-29T21:44:58.847356Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 201029 21:44:58
2020-10-29T21:45:00.564581Z 0 [Note] InnoDB: Shutdown completed; log sequence number 14100045
2020-10-29T21:45:00.566767Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-10-29T21:45:00.566787Z 0 [Note] Shutting down plugin 'MEMORY'
2020-10-29T21:45:00.566796Z 0 [Note] Shutting down plugin 'CSV'
2020-10-29T21:45:00.566805Z 0 [Note] Shutting down plugin 'sha256_password'
2020-10-29T21:45:00.566811Z 0 [Note] Shutting down plugin 'mysql_native_password'
2020-10-29T21:45:00.566988Z 0 [Note] Shutting down plugin 'binlog'
2020-10-29T21:45:00.567709Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2020-10-29T21:45:00.679629Z 0 [Warning] Changed limits: max_open_files: 5000 (requested 5120)
2020-10-29T21:45:00.679931Z 0 [Warning] Changed limits: table_open_cache: 1983 (requested 2000)
2020-10-29T21:45:00.896599Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-10-29T21:45:00.898698Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.32-0ubuntu0.18.04.1) starting as process 107363 ...
2020-10-29T21:45:00.905540Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-10-29T21:45:00.905581Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-10-29T21:45:00.905589Z 0 [Note] InnoDB: Uses event mutexes
2020-10-29T21:45:00.905597Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-10-29T21:45:00.905604Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-10-29T21:45:00.905612Z 0 [Note] InnoDB: Using Linux native AIO
2020-10-29T21:45:00.906411Z 0 [Note] InnoDB: Number of pools: 1
2020-10-29T21:45:00.906562Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-10-29T21:45:00.909431Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-10-29T21:45:00.922572Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-10-29T21:45:00.925522Z 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-29T21:45:00.937888Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-10-29T21:45:00.974916Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-10-29T21:45:00.975041Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-10-29T21:45:00.999672Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-10-29T21:45:01.000838Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-10-29T21:45:01.000860Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-10-29T21:45:01.001638Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 14100045
2020-10-29T21:45:01.001891Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-10-29T21:45:01.002120Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-10-29T21:45:01.012001Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2020-10-29T21:45:01.012060Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2020-10-29T21:45:01.028931Z 0 [Warning] CA certificate ca.pem is self signed.
2020-10-29T21:45:01.028993Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2020-10-29T21:45:01.029105Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
2020-10-29T21:45:01.029124Z 0 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
2020-10-29T21:45:01.029182Z 0 [Note] Server socket created on IP: '0.0.0.0'.
2020-10-29T21:45:01.056313Z 0 [Note] Event Scheduler: Loaded 0 events
2020-10-29T21:45:01.056873Z 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-29T21:45:01.060239Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201029 21:45:01
2020-10-29T21:45:24.408785Z 4 [Note] Aborted connection 4 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T21:45:38.248410Z 5 [Note] Aborted connection 5 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T21:52:50.242240Z 10 [Note] Aborted connection 10 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T21:52:50.242445Z 11 [Note] Aborted connection 11 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T21:52:54.716811Z 12 [Note] Aborted connection 12 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T21:54:35.540820Z 19 [Note] Aborted connection 19 to db: 'cinder' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T21:54:40.576812Z 22 [Note] Aborted connection 22 to db: 'placement' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T21:55:25.992975Z 25 [Note] Aborted connection 25 to db: 'nova_api' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T21:55:30.014128Z 28 [Note] Aborted connection 28 to db: 'nova_api' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T21:55:44.313427Z 7 [Note] Aborted connection 7 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T21:55:44.314611Z 6 [Note] Aborted connection 6 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T22:00:29.187017Z 32 [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-29T22:00:29.445244Z 0 [Note] Giving 0 client threads a chance to die gracefully
2020-10-29T22:00:29.445281Z 0 [Note] Shutting down slave threads
2020-10-29T22:00:29.445293Z 0 [Note] Forcefully disconnecting 0 remaining clients
2020-10-29T22:00:29.445304Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2020-10-29T22:00:29.445455Z 0 [Note] Binlog end
2020-10-29T22:00:29.447855Z 0 [Note] Shutting down plugin 'ngram'
2020-10-29T22:00:29.447872Z 0 [Note] Shutting down plugin 'partition'
2020-10-29T22:00:29.447880Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2020-10-29T22:00:29.447887Z 0 [Note] Shutting down plugin 'ARCHIVE'
2020-10-29T22:00:29.447893Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2020-10-29T22:00:29.447931Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2020-10-29T22:00:29.447938Z 0 [Note] Shutting down plugin 'MyISAM'
2020-10-29T22:00:29.447948Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2020-10-29T22:00:29.447955Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2020-10-29T22:00:29.447961Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2020-10-29T22:00:29.447967Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2020-10-29T22:00:29.447972Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2020-10-29T22:00:29.447978Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2020-10-29T22:00:29.447984Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2020-10-29T22:00:29.447989Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2020-10-29T22:00:29.447995Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2020-10-29T22:00:29.448001Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2020-10-29T22:00:29.448006Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2020-10-29T22:00:29.448012Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2020-10-29T22:00:29.448018Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2020-10-29T22:00:29.448072Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2020-10-29T22:00:29.448081Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2020-10-29T22:00:29.448087Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2020-10-29T22:00:29.448092Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2020-10-29T22:00:29.448097Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2020-10-29T22:00:29.448102Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2020-10-29T22:00:29.448107Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2020-10-29T22:00:29.448112Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2020-10-29T22:00:29.448117Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2020-10-29T22:00:29.448122Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2020-10-29T22:00:29.448127Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2020-10-29T22:00:29.448132Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2020-10-29T22:00:29.448137Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2020-10-29T22:00:29.448142Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2020-10-29T22:00:29.448148Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2020-10-29T22:00:29.448153Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2020-10-29T22:00:29.448158Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2020-10-29T22:00:29.448163Z 0 [Note] Shutting down plugin 'InnoDB'
2020-10-29T22:00:29.448240Z 0 [Note] InnoDB: FTS optimize thread exiting.
2020-10-29T22:00:29.448384Z 0 [Note] InnoDB: Starting shutdown...
2020-10-29T22:00:29.548639Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2020-10-29T22:00:29.549396Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 201029 22:00:29
2020-10-29T22:00:30.869278Z 0 [Note] InnoDB: Shutdown completed; log sequence number 26369597
2020-10-29T22:00:30.871580Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-10-29T22:00:30.871601Z 0 [Note] Shutting down plugin 'MEMORY'
2020-10-29T22:00:30.871611Z 0 [Note] Shutting down plugin 'CSV'
2020-10-29T22:00:30.871619Z 0 [Note] Shutting down plugin 'sha256_password'
2020-10-29T22:00:30.871625Z 0 [Note] Shutting down plugin 'mysql_native_password'
2020-10-29T22:00:30.871804Z 0 [Note] Shutting down plugin 'binlog'
2020-10-29T22:00:30.872526Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2020-10-29T22:00:30.985628Z 0 [Warning] Changed limits: max_open_files: 5000 (requested 5120)
2020-10-29T22:00:30.986071Z 0 [Warning] Changed limits: table_open_cache: 1983 (requested 2000)
2020-10-29T22:00:31.197294Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-10-29T22:00:31.199442Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.32-0ubuntu0.18.04.1) starting as process 20479 ...
2020-10-29T22:00:31.206413Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-10-29T22:00:31.206449Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-10-29T22:00:31.206458Z 0 [Note] InnoDB: Uses event mutexes
2020-10-29T22:00:31.206466Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-10-29T22:00:31.206474Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-10-29T22:00:31.206481Z 0 [Note] InnoDB: Using Linux native AIO
2020-10-29T22:00:31.207281Z 0 [Note] InnoDB: Number of pools: 1
2020-10-29T22:00:31.207431Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-10-29T22:00:31.210413Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-10-29T22:00:31.222692Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-10-29T22:00:31.225709Z 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-29T22:00:31.237925Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-10-29T22:00:31.274423Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-10-29T22:00:31.274548Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-10-29T22:00:31.300893Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-10-29T22:00:31.302016Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-10-29T22:00:31.302035Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-10-29T22:00:31.302555Z 0 [Note] InnoDB: Waiting for purge to start
2020-10-29T22:00:31.352726Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 26369597
2020-10-29T22:00:31.352979Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-10-29T22:00:31.353182Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-10-29T22:00:31.362172Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2020-10-29T22:00:31.362202Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2020-10-29T22:00:31.380814Z 0 [Warning] CA certificate ca.pem is self signed.
2020-10-29T22:00:31.380874Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2020-10-29T22:00:31.380986Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
2020-10-29T22:00:31.381005Z 0 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
2020-10-29T22:00:31.381059Z 0 [Note] Server socket created on IP: '0.0.0.0'.
2020-10-29T22:00:31.419665Z 0 [Note] Event Scheduler: Loaded 0 events
2020-10-29T22:00:31.419985Z 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-29T22:00:32.362807Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201029 22:00:32
2020-10-29T22:00:54.429799Z 4 [Note] Aborted connection 4 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T22:01:08.417261Z 5 [Note] Aborted connection 5 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T22:08:22.922951Z 10 [Note] Aborted connection 10 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T22:08:22.923191Z 11 [Note] Aborted connection 11 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T22:08:27.340939Z 12 [Note] Aborted connection 12 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T22:10:09.580713Z 19 [Note] Aborted connection 19 to db: 'cinder' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T22:10:14.607065Z 22 [Note] Aborted connection 22 to db: 'placement' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T22:11:00.485086Z 25 [Note] Aborted connection 25 to db: 'nova_api' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T22:11:04.573639Z 28 [Note] Aborted connection 28 to db: 'nova_api' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T22:11:18.992471Z 6 [Note] Aborted connection 6 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T22:11:18.992565Z 7 [Note] Aborted connection 7 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T22:16:01.458843Z 32 [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-29T22:16:01.703493Z 0 [Note] Giving 0 client threads a chance to die gracefully
2020-10-29T22:16:01.703528Z 0 [Note] Shutting down slave threads
2020-10-29T22:16:01.703540Z 0 [Note] Forcefully disconnecting 0 remaining clients
2020-10-29T22:16:01.703554Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2020-10-29T22:16:01.703672Z 0 [Note] Binlog end
2020-10-29T22:16:01.706077Z 0 [Note] Shutting down plugin 'ngram'
2020-10-29T22:16:01.706095Z 0 [Note] Shutting down plugin 'partition'
2020-10-29T22:16:01.706102Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2020-10-29T22:16:01.706109Z 0 [Note] Shutting down plugin 'ARCHIVE'
2020-10-29T22:16:01.706114Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2020-10-29T22:16:01.706151Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2020-10-29T22:16:01.706157Z 0 [Note] Shutting down plugin 'MyISAM'
2020-10-29T22:16:01.706166Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2020-10-29T22:16:01.706173Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2020-10-29T22:16:01.706178Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2020-10-29T22:16:01.706183Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2020-10-29T22:16:01.706188Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2020-10-29T22:16:01.706193Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2020-10-29T22:16:01.706198Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2020-10-29T22:16:01.706203Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2020-10-29T22:16:01.706209Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2020-10-29T22:16:01.706214Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2020-10-29T22:16:01.706219Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2020-10-29T22:16:01.706224Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2020-10-29T22:16:01.706229Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2020-10-29T22:16:01.706234Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2020-10-29T22:16:01.706239Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2020-10-29T22:16:01.706244Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2020-10-29T22:16:01.706249Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2020-10-29T22:16:01.706254Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2020-10-29T22:16:01.706259Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2020-10-29T22:16:01.706264Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2020-10-29T22:16:01.706269Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2020-10-29T22:16:01.706274Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2020-10-29T22:16:01.706279Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2020-10-29T22:16:01.706284Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2020-10-29T22:16:01.706289Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2020-10-29T22:16:01.706294Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2020-10-29T22:16:01.706299Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2020-10-29T22:16:01.706304Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2020-10-29T22:16:01.706309Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2020-10-29T22:16:01.706314Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2020-10-29T22:16:01.706319Z 0 [Note] Shutting down plugin 'InnoDB'
2020-10-29T22:16:01.706401Z 0 [Note] InnoDB: FTS optimize thread exiting.
2020-10-29T22:16:01.706543Z 0 [Note] InnoDB: Starting shutdown...
2020-10-29T22:16:01.806767Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2020-10-29T22:16:01.807446Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 201029 22:16:01
2020-10-29T22:16:03.227179Z 0 [Note] InnoDB: Shutdown completed; log sequence number 38482054
2020-10-29T22:16:03.229605Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-10-29T22:16:03.229627Z 0 [Note] Shutting down plugin 'MEMORY'
2020-10-29T22:16:03.229636Z 0 [Note] Shutting down plugin 'CSV'
2020-10-29T22:16:03.229644Z 0 [Note] Shutting down plugin 'sha256_password'
2020-10-29T22:16:03.229650Z 0 [Note] Shutting down plugin 'mysql_native_password'
2020-10-29T22:16:03.229825Z 0 [Note] Shutting down plugin 'binlog'
2020-10-29T22:16:03.230535Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2020-10-29T22:16:03.338106Z 0 [Warning] Changed limits: max_open_files: 5000 (requested 5120)
2020-10-29T22:16:03.338386Z 0 [Warning] Changed limits: table_open_cache: 1983 (requested 2000)
2020-10-29T22:16:03.544604Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-10-29T22:16:03.546719Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.32-0ubuntu0.18.04.1) starting as process 64404 ...
2020-10-29T22:16:03.552878Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-10-29T22:16:03.552908Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-10-29T22:16:03.552916Z 0 [Note] InnoDB: Uses event mutexes
2020-10-29T22:16:03.552924Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-10-29T22:16:03.552932Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-10-29T22:16:03.552939Z 0 [Note] InnoDB: Using Linux native AIO
2020-10-29T22:16:03.553897Z 0 [Note] InnoDB: Number of pools: 1
2020-10-29T22:16:03.554049Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-10-29T22:16:03.556928Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-10-29T22:16:03.569943Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-10-29T22:16:03.572815Z 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-29T22:16:03.585599Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-10-29T22:16:03.621097Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-10-29T22:16:03.621206Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-10-29T22:16:03.646260Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-10-29T22:16:03.647969Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-10-29T22:16:03.647993Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-10-29T22:16:03.648802Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 38482054
2020-10-29T22:16:03.649087Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-10-29T22:16:03.649379Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-10-29T22:16:03.688643Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2020-10-29T22:16:03.688673Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2020-10-29T22:16:03.689491Z 0 [Warning] CA certificate ca.pem is self signed.
2020-10-29T22:16:03.689535Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2020-10-29T22:16:03.689643Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
2020-10-29T22:16:03.689661Z 0 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
2020-10-29T22:16:03.689698Z 0 [Note] Server socket created on IP: '0.0.0.0'.
2020-10-29T22:16:03.716208Z 0 [Note] Event Scheduler: Loaded 0 events
2020-10-29T22:16:03.716714Z 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-29T22:16:04.694408Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201029 22:16:04
2020-10-29T22:16:26.347931Z 4 [Note] Aborted connection 4 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T22:16:39.983634Z 5 [Note] Aborted connection 5 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T22:23:45.742936Z 10 [Note] Aborted connection 10 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T22:23:45.743143Z 11 [Note] Aborted connection 11 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T22:23:50.103287Z 12 [Note] Aborted connection 12 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T22:25:31.363826Z 19 [Note] Aborted connection 19 to db: 'cinder' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T22:25:36.564518Z 22 [Note] Aborted connection 22 to db: 'placement' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T22:26:22.678977Z 25 [Note] Aborted connection 25 to db: 'nova_api' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T22:26:26.847327Z 28 [Note] Aborted connection 28 to db: 'nova_api' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T22:26:48.430732Z 7 [Note] Aborted connection 7 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T22:26:48.444982Z 6 [Note] Aborted connection 6 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)