2020-10-29T21:21:37.367915Z 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:21:37.595884Z 0 [Warning] InnoDB: New log files created, LSN=45790
2020-10-29T21:21:37.640622Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2020-10-29T21:21:37.712803Z 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: baa409e1-1a2c-11eb-9fab-fa163ed7a0a4.
2020-10-29T21:21:37.714253Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2020-10-29T21:21:38.342108Z 0 [Warning] CA certificate ca.pem is self signed.
2020-10-29T21:21:38.496909Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
2020-10-29T21:21:45.520531Z 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:21:45.522636Z 0 [Note] mysqld (mysqld 5.7.32-0ubuntu0.18.04.1) starting as process 41543 ...
2020-10-29T21:21:45.528902Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-10-29T21:21:45.528936Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-10-29T21:21:45.528945Z 0 [Note] InnoDB: Uses event mutexes
2020-10-29T21:21:45.528953Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-10-29T21:21:45.528961Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-10-29T21:21:45.528969Z 0 [Note] InnoDB: Using Linux native AIO
2020-10-29T21:21:45.529298Z 0 [Note] InnoDB: Number of pools: 1
2020-10-29T21:21:45.529442Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-10-29T21:21:45.531987Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-10-29T21:21:45.544810Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-10-29T21:21:45.547619Z 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:21:45.559676Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-10-29T21:21:45.570143Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-10-29T21:21:45.570231Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-10-29T21:21:45.595208Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-10-29T21:21:45.596859Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-10-29T21:21:45.596881Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-10-29T21:21:45.597757Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 2747070
2020-10-29T21:21:45.598037Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-10-29T21:21:45.598299Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-10-29T21:21:45.600132Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201029 21:21:45
2020-10-29T21:21:45.606370Z 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:21:45.606393Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2020-10-29T21:21:45.607186Z 0 [Warning] CA certificate ca.pem is self signed.
2020-10-29T21:21:45.607232Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2020-10-29T21:21:45.608878Z 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:21:45.621862Z 0 [Note] Event Scheduler: Loaded 0 events
2020-10-29T21:21:45.622181Z 0 [Note] mysqld: ready for connections.
Version: '5.7.32-0ubuntu0.18.04.1'  socket: '/tmp/tmp.B6cVc7FJLd/mysqld.sock'  port: 0  (Ubuntu)
2020-10-29T21:21:45.631160Z 2 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2020-10-29T21:21:45.636806Z 0 [Note] Giving 0 client threads a chance to die gracefully
2020-10-29T21:21:45.636830Z 0 [Note] Shutting down slave threads
2020-10-29T21:21:45.636842Z 0 [Note] Forcefully disconnecting 0 remaining clients
2020-10-29T21:21:45.636852Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2020-10-29T21:21:45.636926Z 0 [Note] Binlog end
2020-10-29T21:21:45.637587Z 0 [Note] Shutting down plugin 'ngram'
2020-10-29T21:21:45.637610Z 0 [Note] Shutting down plugin 'partition'
2020-10-29T21:21:45.637625Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2020-10-29T21:21:45.637639Z 0 [Note] Shutting down plugin 'ARCHIVE'
2020-10-29T21:21:45.637650Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2020-10-29T21:21:45.637698Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2020-10-29T21:21:45.637709Z 0 [Note] Shutting down plugin 'MyISAM'
2020-10-29T21:21:45.637719Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2020-10-29T21:21:45.637726Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2020-10-29T21:21:45.637732Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2020-10-29T21:21:45.637738Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2020-10-29T21:21:45.637744Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2020-10-29T21:21:45.637749Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2020-10-29T21:21:45.637755Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2020-10-29T21:21:45.637760Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2020-10-29T21:21:45.637766Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2020-10-29T21:21:45.637771Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2020-10-29T21:21:45.637777Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2020-10-29T21:21:45.637783Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2020-10-29T21:21:45.637788Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2020-10-29T21:21:45.637794Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2020-10-29T21:21:45.637799Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2020-10-29T21:21:45.637805Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2020-10-29T21:21:45.637810Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2020-10-29T21:21:45.637816Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2020-10-29T21:21:45.637821Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2020-10-29T21:21:45.637827Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2020-10-29T21:21:45.637832Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2020-10-29T21:21:45.637838Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2020-10-29T21:21:45.637843Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2020-10-29T21:21:45.637848Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2020-10-29T21:21:45.637854Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2020-10-29T21:21:45.637859Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2020-10-29T21:21:45.637865Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2020-10-29T21:21:45.637875Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2020-10-29T21:21:45.637885Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2020-10-29T21:21:45.637895Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2020-10-29T21:21:45.637906Z 0 [Note] Shutting down plugin 'InnoDB'
2020-10-29T21:21:45.637997Z 0 [Note] InnoDB: FTS optimize thread exiting.
2020-10-29T21:21:45.638161Z 0 [Note] InnoDB: Starting shutdown...
2020-10-29T21:21:45.738386Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2020-10-29T21:21:45.738727Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 201029 21:21:45
2020-10-29T21:21:47.246573Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2747089
2020-10-29T21:21:47.248780Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-10-29T21:21:47.248801Z 0 [Note] Shutting down plugin 'MEMORY'
2020-10-29T21:21:47.248811Z 0 [Note] Shutting down plugin 'CSV'
2020-10-29T21:21:47.248819Z 0 [Note] Shutting down plugin 'sha256_password'
2020-10-29T21:21:47.248838Z 0 [Note] Shutting down plugin 'mysql_native_password'
2020-10-29T21:21:47.249015Z 0 [Note] Shutting down plugin 'binlog'
2020-10-29T21:21:47.249439Z 0 [Note] mysqld: Shutdown complete

2020-10-29T21:21:49.316498Z 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:21:49.318667Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.32-0ubuntu0.18.04.1) starting as process 41684 ...
2020-10-29T21:21:49.324971Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-10-29T21:21:49.325010Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-10-29T21:21:49.325019Z 0 [Note] InnoDB: Uses event mutexes
2020-10-29T21:21:49.325027Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-10-29T21:21:49.325034Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-10-29T21:21:49.325041Z 0 [Note] InnoDB: Using Linux native AIO
2020-10-29T21:21:49.325362Z 0 [Note] InnoDB: Number of pools: 1
2020-10-29T21:21:49.325503Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-10-29T21:21:49.328173Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-10-29T21:21:49.340844Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-10-29T21:21:49.343684Z 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:21:49.355896Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-10-29T21:21:49.366733Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-10-29T21:21:49.366834Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-10-29T21:21:49.392948Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-10-29T21:21:49.394116Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-10-29T21:21:49.394136Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-10-29T21:21:49.394805Z 0 [Note] InnoDB: Waiting for purge to start
2020-10-29T21:21:49.445021Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 2747089
2020-10-29T21:21:49.445333Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-10-29T21:21:49.445729Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-10-29T21:21:49.448707Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201029 21:21:49
2020-10-29T21:21:49.455761Z 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:21:49.455784Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2020-10-29T21:21:49.456586Z 0 [Warning] CA certificate ca.pem is self signed.
2020-10-29T21:21:49.456636Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2020-10-29T21:21:49.456746Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2020-10-29T21:21:49.456764Z 0 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
2020-10-29T21:21:49.456818Z 0 [Note] Server socket created on IP: '127.0.0.1'.
2020-10-29T21:21:49.467735Z 0 [Note] Event Scheduler: Loaded 0 events
2020-10-29T21:21:49.468034Z 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:28:37.664709Z 0 [Note] Giving 0 client threads a chance to die gracefully
2020-10-29T21:28:37.664745Z 0 [Note] Shutting down slave threads
2020-10-29T21:28:37.664758Z 0 [Note] Forcefully disconnecting 0 remaining clients
2020-10-29T21:28:37.664768Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2020-10-29T21:28:37.664842Z 0 [Note] Binlog end
2020-10-29T21:28:37.665470Z 0 [Note] Shutting down plugin 'ngram'
2020-10-29T21:28:37.665483Z 0 [Note] Shutting down plugin 'partition'
2020-10-29T21:28:37.665491Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2020-10-29T21:28:37.665511Z 0 [Note] Shutting down plugin 'ARCHIVE'
2020-10-29T21:28:37.665518Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2020-10-29T21:28:37.665554Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2020-10-29T21:28:37.665561Z 0 [Note] Shutting down plugin 'MyISAM'
2020-10-29T21:28:37.665569Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2020-10-29T21:28:37.665576Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2020-10-29T21:28:37.665581Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2020-10-29T21:28:37.665586Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2020-10-29T21:28:37.665591Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2020-10-29T21:28:37.665596Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2020-10-29T21:28:37.665601Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2020-10-29T21:28:37.665606Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2020-10-29T21:28:37.665611Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2020-10-29T21:28:37.665616Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2020-10-29T21:28:37.665621Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2020-10-29T21:28:37.665626Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2020-10-29T21:28:37.665631Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2020-10-29T21:28:37.665636Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2020-10-29T21:28:37.665641Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2020-10-29T21:28:37.665646Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2020-10-29T21:28:37.665651Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2020-10-29T21:28:37.665656Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2020-10-29T21:28:37.665661Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2020-10-29T21:28:37.665666Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2020-10-29T21:28:37.665671Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2020-10-29T21:28:37.665676Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2020-10-29T21:28:37.665681Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2020-10-29T21:28:37.665686Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2020-10-29T21:28:37.665691Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2020-10-29T21:28:37.665696Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2020-10-29T21:28:37.665701Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2020-10-29T21:28:37.665706Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2020-10-29T21:28:37.665710Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2020-10-29T21:28:37.665715Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2020-10-29T21:28:37.665720Z 0 [Note] Shutting down plugin 'InnoDB'
2020-10-29T21:28:37.665802Z 0 [Note] InnoDB: FTS optimize thread exiting.
2020-10-29T21:28:37.665945Z 0 [Note] InnoDB: Starting shutdown...
2020-10-29T21:28:37.766856Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2020-10-29T21:28:37.767195Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 201029 21:28:37
2020-10-29T21:28:39.276252Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2747117
2020-10-29T21:28:39.278896Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-10-29T21:28:39.278918Z 0 [Note] Shutting down plugin 'MEMORY'
2020-10-29T21:28:39.278928Z 0 [Note] Shutting down plugin 'CSV'
2020-10-29T21:28:39.278936Z 0 [Note] Shutting down plugin 'sha256_password'
2020-10-29T21:28:39.278942Z 0 [Note] Shutting down plugin 'mysql_native_password'
2020-10-29T21:28:39.279120Z 0 [Note] Shutting down plugin 'binlog'
2020-10-29T21:28:39.279552Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2020-10-29T21:28:39.399425Z 0 [Warning] Changed limits: max_open_files: 5000 (requested 5120)
2020-10-29T21:28:39.399775Z 0 [Warning] Changed limits: table_open_cache: 1983 (requested 2000)
2020-10-29T21:28:39.609659Z 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:28:39.612381Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.32-0ubuntu0.18.04.1) starting as process 63443 ...
2020-10-29T21:28:39.618779Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-10-29T21:28:39.618815Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-10-29T21:28:39.618824Z 0 [Note] InnoDB: Uses event mutexes
2020-10-29T21:28:39.618832Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-10-29T21:28:39.618839Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-10-29T21:28:39.618847Z 0 [Note] InnoDB: Using Linux native AIO
2020-10-29T21:28:39.619636Z 0 [Note] InnoDB: Number of pools: 1
2020-10-29T21:28:39.619818Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-10-29T21:28:39.622598Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-10-29T21:28:39.637755Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-10-29T21:28:39.640589Z 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:28:39.652838Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-10-29T21:28:39.671264Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-10-29T21:28:39.671375Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-10-29T21:28:39.695993Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-10-29T21:28:39.697098Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-10-29T21:28:39.697118Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-10-29T21:28:39.698042Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 2747117
2020-10-29T21:28:39.698226Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-10-29T21:28:39.698500Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-10-29T21:28:39.700248Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201029 21:28:39
2020-10-29T21:28:39.706354Z 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:28:39.706383Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2020-10-29T21:28:39.707186Z 0 [Warning] CA certificate ca.pem is self signed.
2020-10-29T21:28:39.707233Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2020-10-29T21:28:39.707342Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
2020-10-29T21:28:39.707359Z 0 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
2020-10-29T21:28:39.707413Z 0 [Note] Server socket created on IP: '0.0.0.0'.
2020-10-29T21:28:39.718627Z 0 [Note] Event Scheduler: Loaded 0 events
2020-10-29T21:28:39.718958Z 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:02.002113Z 4 [Note] Aborted connection 4 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T21:29:16.055405Z 5 [Note] Aborted connection 5 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T21:36:20.539742Z 10 [Note] Aborted connection 10 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T21:36:20.539936Z 11 [Note] Aborted connection 11 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T21:36:24.935881Z 12 [Note] Aborted connection 12 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T21:38:00.479625Z 19 [Note] Aborted connection 19 to db: 'cinder' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T21:38:05.449354Z 22 [Note] Aborted connection 22 to db: 'placement' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T21:38:50.669587Z 25 [Note] Aborted connection 25 to db: 'nova_api' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T21:38:54.681671Z 28 [Note] Aborted connection 28 to db: 'nova_api' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T21:39:09.463143Z 6 [Note] Aborted connection 6 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T21:39:09.464409Z 7 [Note] Aborted connection 7 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T21:43:57.369913Z 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:43:57.619728Z 0 [Note] Giving 0 client threads a chance to die gracefully
2020-10-29T21:43:57.619766Z 0 [Note] Shutting down slave threads
2020-10-29T21:43:57.619787Z 0 [Note] Forcefully disconnecting 0 remaining clients
2020-10-29T21:43:57.619799Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2020-10-29T21:43:57.619915Z 0 [Note] Binlog end
2020-10-29T21:43:57.622337Z 0 [Note] Shutting down plugin 'ngram'
2020-10-29T21:43:57.622354Z 0 [Note] Shutting down plugin 'partition'
2020-10-29T21:43:57.622362Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2020-10-29T21:43:57.622369Z 0 [Note] Shutting down plugin 'ARCHIVE'
2020-10-29T21:43:57.622375Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2020-10-29T21:43:57.622412Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2020-10-29T21:43:57.622420Z 0 [Note] Shutting down plugin 'MyISAM'
2020-10-29T21:43:57.622429Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2020-10-29T21:43:57.622436Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2020-10-29T21:43:57.622442Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2020-10-29T21:43:57.622447Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2020-10-29T21:43:57.622453Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2020-10-29T21:43:57.622459Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2020-10-29T21:43:57.622464Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2020-10-29T21:43:57.622470Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2020-10-29T21:43:57.622475Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2020-10-29T21:43:57.622481Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2020-10-29T21:43:57.622486Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2020-10-29T21:43:57.622492Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2020-10-29T21:43:57.622497Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2020-10-29T21:43:57.622502Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2020-10-29T21:43:57.622508Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2020-10-29T21:43:57.622513Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2020-10-29T21:43:57.622519Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2020-10-29T21:43:57.622525Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2020-10-29T21:43:57.622530Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2020-10-29T21:43:57.622536Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2020-10-29T21:43:57.622541Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2020-10-29T21:43:57.622547Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2020-10-29T21:43:57.622553Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2020-10-29T21:43:57.622558Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2020-10-29T21:43:57.622564Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2020-10-29T21:43:57.622570Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2020-10-29T21:43:57.622575Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2020-10-29T21:43:57.622581Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2020-10-29T21:43:57.622586Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2020-10-29T21:43:57.622592Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2020-10-29T21:43:57.622611Z 0 [Note] Shutting down plugin 'InnoDB'
2020-10-29T21:43:57.622745Z 0 [Note] InnoDB: FTS optimize thread exiting.
2020-10-29T21:43:57.622889Z 0 [Note] InnoDB: Starting shutdown...
2020-10-29T21:43:57.723135Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2020-10-29T21:43:57.723795Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 201029 21:43:57
2020-10-29T21:43:58.640558Z 0 [Note] InnoDB: Shutdown completed; log sequence number 14363949
2020-10-29T21:43:58.642821Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-10-29T21:43:58.642850Z 0 [Note] Shutting down plugin 'MEMORY'
2020-10-29T21:43:58.642867Z 0 [Note] Shutting down plugin 'CSV'
2020-10-29T21:43:58.642882Z 0 [Note] Shutting down plugin 'sha256_password'
2020-10-29T21:43:58.642889Z 0 [Note] Shutting down plugin 'mysql_native_password'
2020-10-29T21:43:58.643066Z 0 [Note] Shutting down plugin 'binlog'
2020-10-29T21:43:58.643815Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2020-10-29T21:43:58.757431Z 0 [Warning] Changed limits: max_open_files: 5000 (requested 5120)
2020-10-29T21:43:58.757724Z 0 [Warning] Changed limits: table_open_cache: 1983 (requested 2000)
2020-10-29T21:43:58.961784Z 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:43:58.963934Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.32-0ubuntu0.18.04.1) starting as process 107355 ...
2020-10-29T21:43:58.969969Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-10-29T21:43:58.970008Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-10-29T21:43:58.970016Z 0 [Note] InnoDB: Uses event mutexes
2020-10-29T21:43:58.970024Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-10-29T21:43:58.970031Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-10-29T21:43:58.970038Z 0 [Note] InnoDB: Using Linux native AIO
2020-10-29T21:43:58.970862Z 0 [Note] InnoDB: Number of pools: 1
2020-10-29T21:43:58.971008Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-10-29T21:43:58.973931Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-10-29T21:43:58.986179Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-10-29T21:43:58.989741Z 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:43:59.001916Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-10-29T21:43:59.039626Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-10-29T21:43:59.039758Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-10-29T21:43:59.064119Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-10-29T21:43:59.065942Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-10-29T21:43:59.065963Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-10-29T21:43:59.066483Z 0 [Note] InnoDB: Waiting for purge to start
2020-10-29T21:43:59.116651Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 14363949
2020-10-29T21:43:59.117005Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-10-29T21:43:59.117245Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-10-29T21:43:59.125932Z 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:43:59.125961Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2020-10-29T21:43:59.148495Z 0 [Warning] CA certificate ca.pem is self signed.
2020-10-29T21:43:59.148548Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2020-10-29T21:43:59.148661Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
2020-10-29T21:43:59.148686Z 0 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
2020-10-29T21:43:59.148754Z 0 [Note] Server socket created on IP: '0.0.0.0'.
2020-10-29T21:43:59.179879Z 0 [Note] Event Scheduler: Loaded 0 events
2020-10-29T21:43:59.180399Z 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:43:59.182949Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201029 21:43:59
2020-10-29T21:44:22.217378Z 4 [Note] Aborted connection 4 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T21:44:35.945340Z 5 [Note] Aborted connection 5 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T21:51:41.435619Z 10 [Note] Aborted connection 10 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T21:51:41.435806Z 11 [Note] Aborted connection 11 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T21:51:45.792721Z 12 [Note] Aborted connection 12 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T21:53:25.932648Z 19 [Note] Aborted connection 19 to db: 'cinder' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T21:53:30.910330Z 22 [Note] Aborted connection 22 to db: 'placement' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T21:54:16.038552Z 25 [Note] Aborted connection 25 to db: 'nova_api' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T21:54:20.015484Z 28 [Note] Aborted connection 28 to db: 'nova_api' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T21:54:34.531776Z 6 [Note] Aborted connection 6 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T21:54:34.547861Z 7 [Note] Aborted connection 7 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T21:59:18.318209Z 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:59:18.582914Z 0 [Note] Giving 0 client threads a chance to die gracefully
2020-10-29T21:59:18.582958Z 0 [Note] Shutting down slave threads
2020-10-29T21:59:18.582971Z 0 [Note] Forcefully disconnecting 0 remaining clients
2020-10-29T21:59:18.582982Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2020-10-29T21:59:18.583082Z 0 [Note] Binlog end
2020-10-29T21:59:18.585540Z 0 [Note] Shutting down plugin 'ngram'
2020-10-29T21:59:18.585560Z 0 [Note] Shutting down plugin 'partition'
2020-10-29T21:59:18.585567Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2020-10-29T21:59:18.585574Z 0 [Note] Shutting down plugin 'ARCHIVE'
2020-10-29T21:59:18.585580Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2020-10-29T21:59:18.585617Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2020-10-29T21:59:18.585624Z 0 [Note] Shutting down plugin 'MyISAM'
2020-10-29T21:59:18.585634Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2020-10-29T21:59:18.585641Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2020-10-29T21:59:18.585647Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2020-10-29T21:59:18.585653Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2020-10-29T21:59:18.585659Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2020-10-29T21:59:18.585665Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2020-10-29T21:59:18.585670Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2020-10-29T21:59:18.585676Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2020-10-29T21:59:18.585682Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2020-10-29T21:59:18.585687Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2020-10-29T21:59:18.585693Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2020-10-29T21:59:18.585713Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2020-10-29T21:59:18.585719Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2020-10-29T21:59:18.585724Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2020-10-29T21:59:18.585729Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2020-10-29T21:59:18.585734Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2020-10-29T21:59:18.585739Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2020-10-29T21:59:18.585745Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2020-10-29T21:59:18.585750Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2020-10-29T21:59:18.585755Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2020-10-29T21:59:18.585760Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2020-10-29T21:59:18.585765Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2020-10-29T21:59:18.585770Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2020-10-29T21:59:18.585775Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2020-10-29T21:59:18.585780Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2020-10-29T21:59:18.585786Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2020-10-29T21:59:18.585790Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2020-10-29T21:59:18.585795Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2020-10-29T21:59:18.585800Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2020-10-29T21:59:18.585806Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2020-10-29T21:59:18.585811Z 0 [Note] Shutting down plugin 'InnoDB'
2020-10-29T21:59:18.585937Z 0 [Note] InnoDB: FTS optimize thread exiting.
2020-10-29T21:59:18.586083Z 0 [Note] InnoDB: Starting shutdown...
2020-10-29T21:59:18.686348Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2020-10-29T21:59:18.687003Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 201029 21:59:18
2020-10-29T21:59:19.906153Z 0 [Note] InnoDB: Shutdown completed; log sequence number 26654394
2020-10-29T21:59:19.908469Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-10-29T21:59:19.908491Z 0 [Note] Shutting down plugin 'MEMORY'
2020-10-29T21:59:19.908500Z 0 [Note] Shutting down plugin 'CSV'
2020-10-29T21:59:19.908508Z 0 [Note] Shutting down plugin 'sha256_password'
2020-10-29T21:59:19.908514Z 0 [Note] Shutting down plugin 'mysql_native_password'
2020-10-29T21:59:19.909192Z 0 [Note] Shutting down plugin 'binlog'
2020-10-29T21:59:19.910002Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2020-10-29T21:59:20.018851Z 0 [Warning] Changed limits: max_open_files: 5000 (requested 5120)
2020-10-29T21:59:20.019133Z 0 [Warning] Changed limits: table_open_cache: 1983 (requested 2000)
2020-10-29T21:59:20.223252Z 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:59:20.225385Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.32-0ubuntu0.18.04.1) starting as process 20466 ...
2020-10-29T21:59:20.231434Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-10-29T21:59:20.231470Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-10-29T21:59:20.231478Z 0 [Note] InnoDB: Uses event mutexes
2020-10-29T21:59:20.231486Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-10-29T21:59:20.231493Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-10-29T21:59:20.231501Z 0 [Note] InnoDB: Using Linux native AIO
2020-10-29T21:59:20.232320Z 0 [Note] InnoDB: Number of pools: 1
2020-10-29T21:59:20.232499Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-10-29T21:59:20.235451Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-10-29T21:59:20.247915Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-10-29T21:59:20.250735Z 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:59:20.262877Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-10-29T21:59:20.298828Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-10-29T21:59:20.298945Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-10-29T21:59:20.323271Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-10-29T21:59:20.324438Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-10-29T21:59:20.324458Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-10-29T21:59:20.325526Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 26654394
2020-10-29T21:59:20.325802Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-10-29T21:59:20.326057Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-10-29T21:59:20.335412Z 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:59:20.335440Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2020-10-29T21:59:20.352483Z 0 [Warning] CA certificate ca.pem is self signed.
2020-10-29T21:59:20.352535Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2020-10-29T21:59:20.352645Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
2020-10-29T21:59:20.352670Z 0 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
2020-10-29T21:59:20.352708Z 0 [Note] Server socket created on IP: '0.0.0.0'.
2020-10-29T21:59:20.387161Z 0 [Note] Event Scheduler: Loaded 0 events
2020-10-29T21:59:20.387471Z 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:59:21.357299Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201029 21:59:21
2020-10-29T21:59:43.390474Z 4 [Note] Aborted connection 4 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T21:59:57.004308Z 5 [Note] Aborted connection 5 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T22:07:04.161796Z 10 [Note] Aborted connection 10 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T22:07:04.162007Z 11 [Note] Aborted connection 11 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T22:07:08.585118Z 12 [Note] Aborted connection 12 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T22:08:49.122923Z 19 [Note] Aborted connection 19 to db: 'cinder' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T22:08:54.205549Z 22 [Note] Aborted connection 22 to db: 'placement' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T22:09:39.613879Z 25 [Note] Aborted connection 25 to db: 'nova_api' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T22:09:43.576595Z 28 [Note] Aborted connection 28 to db: 'nova_api' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T22:09:57.930051Z 6 [Note] Aborted connection 6 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T22:09:57.935161Z 7 [Note] Aborted connection 7 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T22:14:39.742275Z 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:14:39.994313Z 0 [Note] Giving 0 client threads a chance to die gracefully
2020-10-29T22:14:39.994358Z 0 [Note] Shutting down slave threads
2020-10-29T22:14:39.994372Z 0 [Note] Forcefully disconnecting 0 remaining clients
2020-10-29T22:14:39.994386Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2020-10-29T22:14:39.994503Z 0 [Note] Binlog end
2020-10-29T22:14:39.997064Z 0 [Note] Shutting down plugin 'ngram'
2020-10-29T22:14:39.997081Z 0 [Note] Shutting down plugin 'partition'
2020-10-29T22:14:39.997088Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2020-10-29T22:14:39.997095Z 0 [Note] Shutting down plugin 'ARCHIVE'
2020-10-29T22:14:39.997100Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2020-10-29T22:14:39.997136Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2020-10-29T22:14:39.997142Z 0 [Note] Shutting down plugin 'MyISAM'
2020-10-29T22:14:39.997151Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2020-10-29T22:14:39.997157Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2020-10-29T22:14:39.997163Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2020-10-29T22:14:39.997168Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2020-10-29T22:14:39.997173Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2020-10-29T22:14:39.997178Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2020-10-29T22:14:39.997183Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2020-10-29T22:14:39.997189Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2020-10-29T22:14:39.997194Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2020-10-29T22:14:39.997199Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2020-10-29T22:14:39.997204Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2020-10-29T22:14:39.997210Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2020-10-29T22:14:39.997215Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2020-10-29T22:14:39.997220Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2020-10-29T22:14:39.997225Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2020-10-29T22:14:39.997230Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2020-10-29T22:14:39.997235Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2020-10-29T22:14:39.997241Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2020-10-29T22:14:39.997246Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2020-10-29T22:14:39.997251Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2020-10-29T22:14:39.997256Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2020-10-29T22:14:39.997261Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2020-10-29T22:14:39.997266Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2020-10-29T22:14:39.997271Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2020-10-29T22:14:39.997276Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2020-10-29T22:14:39.997282Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2020-10-29T22:14:39.997287Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2020-10-29T22:14:39.997292Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2020-10-29T22:14:39.997297Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2020-10-29T22:14:39.997302Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2020-10-29T22:14:39.997307Z 0 [Note] Shutting down plugin 'InnoDB'
2020-10-29T22:14:39.997433Z 0 [Note] InnoDB: FTS optimize thread exiting.
2020-10-29T22:14:39.997577Z 0 [Note] InnoDB: Starting shutdown...
2020-10-29T22:14:40.097790Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2020-10-29T22:14:40.098534Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 201029 22:14:40
2020-10-29T22:14:41.318513Z 0 [Note] InnoDB: Shutdown completed; log sequence number 38871346
2020-10-29T22:14:41.320959Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-10-29T22:14:41.320981Z 0 [Note] Shutting down plugin 'MEMORY'
2020-10-29T22:14:41.320990Z 0 [Note] Shutting down plugin 'CSV'
2020-10-29T22:14:41.320998Z 0 [Note] Shutting down plugin 'sha256_password'
2020-10-29T22:14:41.321004Z 0 [Note] Shutting down plugin 'mysql_native_password'
2020-10-29T22:14:41.321176Z 0 [Note] Shutting down plugin 'binlog'
2020-10-29T22:14:41.321878Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2020-10-29T22:14:41.437232Z 0 [Warning] Changed limits: max_open_files: 5000 (requested 5120)
2020-10-29T22:14:41.437519Z 0 [Warning] Changed limits: table_open_cache: 1983 (requested 2000)
2020-10-29T22:14:41.651292Z 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:14:41.653429Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.32-0ubuntu0.18.04.1) starting as process 64408 ...
2020-10-29T22:14:41.660470Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-10-29T22:14:41.660507Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-10-29T22:14:41.660517Z 0 [Note] InnoDB: Uses event mutexes
2020-10-29T22:14:41.660524Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-10-29T22:14:41.660532Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-10-29T22:14:41.660540Z 0 [Note] InnoDB: Using Linux native AIO
2020-10-29T22:14:41.661331Z 0 [Note] InnoDB: Number of pools: 1
2020-10-29T22:14:41.661476Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-10-29T22:14:41.664326Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-10-29T22:14:41.677161Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-10-29T22:14:41.679976Z 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:14:41.692230Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-10-29T22:14:41.728907Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-10-29T22:14:41.729021Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-10-29T22:14:41.753224Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-10-29T22:14:41.754316Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-10-29T22:14:41.754334Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-10-29T22:14:41.755307Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 38871346
2020-10-29T22:14:41.755497Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-10-29T22:14:41.756079Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-10-29T22:14:41.764901Z 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:14:41.764929Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2020-10-29T22:14:41.780504Z 0 [Warning] CA certificate ca.pem is self signed.
2020-10-29T22:14:41.780560Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2020-10-29T22:14:41.780672Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
2020-10-29T22:14:41.780691Z 0 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
2020-10-29T22:14:41.780727Z 0 [Note] Server socket created on IP: '0.0.0.0'.
2020-10-29T22:14:41.819254Z 0 [Note] Event Scheduler: Loaded 0 events
2020-10-29T22:14:41.819582Z 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:14:42.784518Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201029 22:14:42
2020-10-29T22:15:05.136942Z 4 [Note] Aborted connection 4 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T22:15:18.843548Z 5 [Note] Aborted connection 5 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T22:22:27.074522Z 10 [Note] Aborted connection 10 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T22:22:27.074703Z 11 [Note] Aborted connection 11 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T22:22:31.435920Z 12 [Note] Aborted connection 12 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T22:24:12.212391Z 19 [Note] Aborted connection 19 to db: 'cinder' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T22:24:17.210554Z 22 [Note] Aborted connection 22 to db: 'placement' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T22:25:02.575006Z 25 [Note] Aborted connection 25 to db: 'nova_api' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T22:25:06.594841Z 28 [Note] Aborted connection 28 to db: 'nova_api' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T22:25:27.916703Z 6 [Note] Aborted connection 6 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-29T22:25:27.931841Z 7 [Note] Aborted connection 7 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)