2020-10-28T15:35:55.136337Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-10-28T15:35:55.338227Z 0 [Warning] InnoDB: New log files created, LSN=45790
2020-10-28T15:35:55.383165Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2020-10-28T15:35:55.388786Z 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: 44d6d207-1933-11eb-a3cb-fa163e1e2dd7.
2020-10-28T15:35:55.390098Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2020-10-28T15:35:55.920510Z 0 [Warning] CA certificate ca.pem is self signed.
2020-10-28T15:35:55.941275Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
2020-10-28T15:36:02.561532Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-10-28T15:36:02.564377Z 0 [Note] mysqld (mysqld 5.7.32-0ubuntu0.18.04.1) starting as process 41500 ...
2020-10-28T15:36:02.570688Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-10-28T15:36:02.570723Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-10-28T15:36:02.570732Z 0 [Note] InnoDB: Uses event mutexes
2020-10-28T15:36:02.570740Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-10-28T15:36:02.570747Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-10-28T15:36:02.570755Z 0 [Note] InnoDB: Using Linux native AIO
2020-10-28T15:36:02.571088Z 0 [Note] InnoDB: Number of pools: 1
2020-10-28T15:36:02.571238Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-10-28T15:36:02.573767Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-10-28T15:36:02.587106Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-10-28T15:36:02.590018Z 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-28T15:36:02.602086Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-10-28T15:36:02.612120Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-10-28T15:36:02.612204Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-10-28T15:36:02.638483Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-10-28T15:36:02.639559Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-10-28T15:36:02.639577Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-10-28T15:36:02.640561Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 2747070
2020-10-28T15:36:02.641173Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-10-28T15:36:02.648141Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-10-28T15:36:02.649923Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2020-10-28T15:36:02.649941Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2020-10-28T15:36:02.650091Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201028 15:36:02
2020-10-28T15:36:02.650738Z 0 [Warning] CA certificate ca.pem is self signed.
2020-10-28T15:36:02.650785Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2020-10-28T15:36:02.652490Z 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-28T15:36:02.664447Z 0 [Note] Event Scheduler: Loaded 0 events
2020-10-28T15:36:02.664751Z 0 [Note] mysqld: ready for connections.
Version: '5.7.32-0ubuntu0.18.04.1'  socket: '/tmp/tmp.Z5QeP1CTKU/mysqld.sock'  port: 0  (Ubuntu)
2020-10-28T15:36:02.673989Z 2 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2020-10-28T15:36:02.676489Z 0 [Note] Giving 0 client threads a chance to die gracefully
2020-10-28T15:36:02.676515Z 0 [Note] Shutting down slave threads
2020-10-28T15:36:02.676525Z 0 [Note] Forcefully disconnecting 0 remaining clients
2020-10-28T15:36:02.676534Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2020-10-28T15:36:02.676606Z 0 [Note] Binlog end
2020-10-28T15:36:02.677086Z 0 [Note] Shutting down plugin 'ngram'
2020-10-28T15:36:02.677102Z 0 [Note] Shutting down plugin 'partition'
2020-10-28T15:36:02.677108Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2020-10-28T15:36:02.677115Z 0 [Note] Shutting down plugin 'ARCHIVE'
2020-10-28T15:36:02.677121Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2020-10-28T15:36:02.677151Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2020-10-28T15:36:02.677157Z 0 [Note] Shutting down plugin 'MyISAM'
2020-10-28T15:36:02.677166Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2020-10-28T15:36:02.677172Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2020-10-28T15:36:02.677177Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2020-10-28T15:36:02.677182Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2020-10-28T15:36:02.677187Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2020-10-28T15:36:02.677192Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2020-10-28T15:36:02.677197Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2020-10-28T15:36:02.677203Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2020-10-28T15:36:02.677208Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2020-10-28T15:36:02.677213Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2020-10-28T15:36:02.677218Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2020-10-28T15:36:02.677223Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2020-10-28T15:36:02.677228Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2020-10-28T15:36:02.677233Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2020-10-28T15:36:02.677238Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2020-10-28T15:36:02.677243Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2020-10-28T15:36:02.677249Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2020-10-28T15:36:02.677254Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2020-10-28T15:36:02.677259Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2020-10-28T15:36:02.677264Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2020-10-28T15:36:02.677269Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2020-10-28T15:36:02.677274Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2020-10-28T15:36:02.677278Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2020-10-28T15:36:02.677283Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2020-10-28T15:36:02.677288Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2020-10-28T15:36:02.677293Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2020-10-28T15:36:02.677298Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2020-10-28T15:36:02.677303Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2020-10-28T15:36:02.677308Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2020-10-28T15:36:02.677313Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2020-10-28T15:36:02.677318Z 0 [Note] Shutting down plugin 'InnoDB'
2020-10-28T15:36:02.677392Z 0 [Note] InnoDB: FTS optimize thread exiting.
2020-10-28T15:36:02.677521Z 0 [Note] InnoDB: Starting shutdown...
2020-10-28T15:36:02.777738Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2020-10-28T15:36:02.778006Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 201028 15:36:02
2020-10-28T15:36:04.285742Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2747089
2020-10-28T15:36:04.287926Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-10-28T15:36:04.287947Z 0 [Note] Shutting down plugin 'MEMORY'
2020-10-28T15:36:04.287956Z 0 [Note] Shutting down plugin 'CSV'
2020-10-28T15:36:04.287964Z 0 [Note] Shutting down plugin 'sha256_password'
2020-10-28T15:36:04.287982Z 0 [Note] Shutting down plugin 'mysql_native_password'
2020-10-28T15:36:04.288179Z 0 [Note] Shutting down plugin 'binlog'
2020-10-28T15:36:04.288603Z 0 [Note] mysqld: Shutdown complete

2020-10-28T15:36:06.262002Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-10-28T15:36:06.264268Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.32-0ubuntu0.18.04.1) starting as process 41644 ...
2020-10-28T15:36:06.270315Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-10-28T15:36:06.270357Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-10-28T15:36:06.270365Z 0 [Note] InnoDB: Uses event mutexes
2020-10-28T15:36:06.270373Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-10-28T15:36:06.270380Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-10-28T15:36:06.270388Z 0 [Note] InnoDB: Using Linux native AIO
2020-10-28T15:36:06.270710Z 0 [Note] InnoDB: Number of pools: 1
2020-10-28T15:36:06.270853Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-10-28T15:36:06.273556Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-10-28T15:36:06.285529Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-10-28T15:36:06.288599Z 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-28T15:36:06.300884Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-10-28T15:36:06.319719Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-10-28T15:36:06.319818Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-10-28T15:36:06.344131Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-10-28T15:36:06.345756Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-10-28T15:36:06.345775Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-10-28T15:36:06.346504Z 0 [Note] InnoDB: Waiting for purge to start
2020-10-28T15:36:06.396679Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 2747089
2020-10-28T15:36:06.396974Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-10-28T15:36:06.397236Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-10-28T15:36:06.399180Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201028 15:36:06
2020-10-28T15:36:06.405339Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2020-10-28T15:36:06.405359Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2020-10-28T15:36:06.406175Z 0 [Warning] CA certificate ca.pem is self signed.
2020-10-28T15:36:06.406220Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2020-10-28T15:36:06.406329Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2020-10-28T15:36:06.406347Z 0 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
2020-10-28T15:36:06.406382Z 0 [Note] Server socket created on IP: '127.0.0.1'.
2020-10-28T15:36:06.418189Z 0 [Note] Event Scheduler: Loaded 0 events
2020-10-28T15:36:06.418497Z 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-28T15:42:24.033931Z 0 [Note] Giving 0 client threads a chance to die gracefully
2020-10-28T15:42:24.033969Z 0 [Note] Shutting down slave threads
2020-10-28T15:42:24.033981Z 0 [Note] Forcefully disconnecting 0 remaining clients
2020-10-28T15:42:24.033991Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2020-10-28T15:42:24.034054Z 0 [Note] Binlog end
2020-10-28T15:42:24.034667Z 0 [Note] Shutting down plugin 'ngram'
2020-10-28T15:42:24.034680Z 0 [Note] Shutting down plugin 'partition'
2020-10-28T15:42:24.034686Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2020-10-28T15:42:24.034706Z 0 [Note] Shutting down plugin 'ARCHIVE'
2020-10-28T15:42:24.034711Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2020-10-28T15:42:24.034748Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2020-10-28T15:42:24.034755Z 0 [Note] Shutting down plugin 'MyISAM'
2020-10-28T15:42:24.034764Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2020-10-28T15:42:24.034770Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2020-10-28T15:42:24.034775Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2020-10-28T15:42:24.034780Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2020-10-28T15:42:24.034785Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2020-10-28T15:42:24.034790Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2020-10-28T15:42:24.034795Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2020-10-28T15:42:24.034800Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2020-10-28T15:42:24.034805Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2020-10-28T15:42:24.034810Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2020-10-28T15:42:24.034815Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2020-10-28T15:42:24.034820Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2020-10-28T15:42:24.034825Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2020-10-28T15:42:24.034830Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2020-10-28T15:42:24.034835Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2020-10-28T15:42:24.034840Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2020-10-28T15:42:24.034845Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2020-10-28T15:42:24.034850Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2020-10-28T15:42:24.034855Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2020-10-28T15:42:24.034860Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2020-10-28T15:42:24.034865Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2020-10-28T15:42:24.034870Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2020-10-28T15:42:24.034875Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2020-10-28T15:42:24.034880Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2020-10-28T15:42:24.034885Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2020-10-28T15:42:24.034890Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2020-10-28T15:42:24.034895Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2020-10-28T15:42:24.034900Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2020-10-28T15:42:24.034905Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2020-10-28T15:42:24.034910Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2020-10-28T15:42:24.034915Z 0 [Note] Shutting down plugin 'InnoDB'
2020-10-28T15:42:24.034996Z 0 [Note] InnoDB: FTS optimize thread exiting.
2020-10-28T15:42:24.035141Z 0 [Note] InnoDB: Starting shutdown...
2020-10-28T15:42:24.135376Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2020-10-28T15:42:24.135651Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 201028 15:42:24
2020-10-28T15:42:25.243692Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2747117
2020-10-28T15:42:25.245893Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-10-28T15:42:25.245914Z 0 [Note] Shutting down plugin 'MEMORY'
2020-10-28T15:42:25.245923Z 0 [Note] Shutting down plugin 'CSV'
2020-10-28T15:42:25.245932Z 0 [Note] Shutting down plugin 'sha256_password'
2020-10-28T15:42:25.245937Z 0 [Note] Shutting down plugin 'mysql_native_password'
2020-10-28T15:42:25.246112Z 0 [Note] Shutting down plugin 'binlog'
2020-10-28T15:42:25.246534Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2020-10-28T15:42:25.356873Z 0 [Warning] Changed limits: max_open_files: 5000 (requested 5120)
2020-10-28T15:42:25.357142Z 0 [Warning] Changed limits: table_open_cache: 1983 (requested 2000)
2020-10-28T15:42:25.561129Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-10-28T15:42:25.563222Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.32-0ubuntu0.18.04.1) starting as process 63169 ...
2020-10-28T15:42:25.569825Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-10-28T15:42:25.569861Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-10-28T15:42:25.569869Z 0 [Note] InnoDB: Uses event mutexes
2020-10-28T15:42:25.569877Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-10-28T15:42:25.569885Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-10-28T15:42:25.569893Z 0 [Note] InnoDB: Using Linux native AIO
2020-10-28T15:42:25.570671Z 0 [Note] InnoDB: Number of pools: 1
2020-10-28T15:42:25.570813Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-10-28T15:42:25.573559Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-10-28T15:42:25.586950Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-10-28T15:42:25.591262Z 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-28T15:42:25.603361Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-10-28T15:42:25.622016Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-10-28T15:42:25.622104Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-10-28T15:42:25.646636Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-10-28T15:42:25.647777Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-10-28T15:42:25.647796Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-10-28T15:42:25.648796Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 2747117
2020-10-28T15:42:25.649061Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-10-28T15:42:25.649211Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-10-28T15:42:25.651248Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201028 15:42:25
2020-10-28T15:42:25.656847Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2020-10-28T15:42:25.656869Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2020-10-28T15:42:25.657689Z 0 [Warning] CA certificate ca.pem is self signed.
2020-10-28T15:42:25.657737Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2020-10-28T15:42:25.657845Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
2020-10-28T15:42:25.657864Z 0 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
2020-10-28T15:42:25.657899Z 0 [Note] Server socket created on IP: '0.0.0.0'.
2020-10-28T15:42:25.669602Z 0 [Note] Event Scheduler: Loaded 0 events
2020-10-28T15:42:25.670047Z 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-28T15:42:48.193237Z 4 [Note] Aborted connection 4 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T15:43:01.920542Z 5 [Note] Aborted connection 5 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T15:50:13.346138Z 10 [Note] Aborted connection 10 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T15:50:13.346343Z 11 [Note] Aborted connection 11 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T15:50:17.807980Z 12 [Note] Aborted connection 12 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T15:51:58.144984Z 7 [Note] Aborted connection 7 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T15:51:58.149907Z 6 [Note] Aborted connection 6 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T15:56:45.050695Z 20 [Warning] Following users were specified in CREATE USER IF NOT EXISTS but they already exist. Corresponding entry in binary log used default authentication plugin 'mysql_native_password' to rewrite authentication information(if any) for them: 'root'@'%'

2020-10-28T15:56:45.299595Z 0 [Note] Giving 0 client threads a chance to die gracefully
2020-10-28T15:56:45.299634Z 0 [Note] Shutting down slave threads
2020-10-28T15:56:45.299648Z 0 [Note] Forcefully disconnecting 0 remaining clients
2020-10-28T15:56:45.299659Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2020-10-28T15:56:45.299752Z 0 [Note] Binlog end
2020-10-28T15:56:45.301567Z 0 [Note] Shutting down plugin 'ngram'
2020-10-28T15:56:45.301587Z 0 [Note] Shutting down plugin 'partition'
2020-10-28T15:56:45.301593Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2020-10-28T15:56:45.301600Z 0 [Note] Shutting down plugin 'ARCHIVE'
2020-10-28T15:56:45.301606Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2020-10-28T15:56:45.301643Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2020-10-28T15:56:45.301649Z 0 [Note] Shutting down plugin 'MyISAM'
2020-10-28T15:56:45.301658Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2020-10-28T15:56:45.301664Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2020-10-28T15:56:45.301670Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2020-10-28T15:56:45.301675Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2020-10-28T15:56:45.301680Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2020-10-28T15:56:45.301685Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2020-10-28T15:56:45.301690Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2020-10-28T15:56:45.301695Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2020-10-28T15:56:45.301700Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2020-10-28T15:56:45.301705Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2020-10-28T15:56:45.301710Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2020-10-28T15:56:45.301715Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2020-10-28T15:56:45.301720Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2020-10-28T15:56:45.301725Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2020-10-28T15:56:45.301730Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2020-10-28T15:56:45.301735Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2020-10-28T15:56:45.301740Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2020-10-28T15:56:45.301745Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2020-10-28T15:56:45.301750Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2020-10-28T15:56:45.301755Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2020-10-28T15:56:45.301760Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2020-10-28T15:56:45.301765Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2020-10-28T15:56:45.301770Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2020-10-28T15:56:45.301775Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2020-10-28T15:56:45.301780Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2020-10-28T15:56:45.301785Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2020-10-28T15:56:45.301790Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2020-10-28T15:56:45.301795Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2020-10-28T15:56:45.301800Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2020-10-28T15:56:45.301805Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2020-10-28T15:56:45.301810Z 0 [Note] Shutting down plugin 'InnoDB'
2020-10-28T15:56:45.301899Z 0 [Note] InnoDB: FTS optimize thread exiting.
2020-10-28T15:56:45.302040Z 0 [Note] InnoDB: Starting shutdown...
2020-10-28T15:56:45.402281Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2020-10-28T15:56:45.402802Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 201028 15:56:45
2020-10-28T15:56:46.418316Z 0 [Note] InnoDB: Shutdown completed; log sequence number 11944397
2020-10-28T15:56:46.420763Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-10-28T15:56:46.420799Z 0 [Note] Shutting down plugin 'MEMORY'
2020-10-28T15:56:46.420808Z 0 [Note] Shutting down plugin 'CSV'
2020-10-28T15:56:46.420816Z 0 [Note] Shutting down plugin 'sha256_password'
2020-10-28T15:56:46.420822Z 0 [Note] Shutting down plugin 'mysql_native_password'
2020-10-28T15:56:46.420998Z 0 [Note] Shutting down plugin 'binlog'
2020-10-28T15:56:46.421628Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2020-10-28T15:56:46.545939Z 0 [Warning] Changed limits: max_open_files: 5000 (requested 5120)
2020-10-28T15:56:46.546225Z 0 [Warning] Changed limits: table_open_cache: 1983 (requested 2000)
2020-10-28T15:56:46.751314Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-10-28T15:56:46.753487Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.32-0ubuntu0.18.04.1) starting as process 105684 ...
2020-10-28T15:56:46.760088Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-10-28T15:56:46.760127Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-10-28T15:56:46.760136Z 0 [Note] InnoDB: Uses event mutexes
2020-10-28T15:56:46.760144Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-10-28T15:56:46.760151Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-10-28T15:56:46.760159Z 0 [Note] InnoDB: Using Linux native AIO
2020-10-28T15:56:46.760938Z 0 [Note] InnoDB: Number of pools: 1
2020-10-28T15:56:46.761083Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-10-28T15:56:46.763884Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-10-28T15:56:46.775957Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-10-28T15:56:46.778800Z 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-28T15:56:46.791040Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-10-28T15:56:46.823576Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-10-28T15:56:46.823683Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-10-28T15:56:46.848232Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-10-28T15:56:46.849364Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-10-28T15:56:46.849383Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-10-28T15:56:46.850147Z 0 [Note] InnoDB: Waiting for purge to start
2020-10-28T15:56:46.900359Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 11944397
2020-10-28T15:56:46.900664Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-10-28T15:56:46.900940Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-10-28T15:56:46.928634Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2020-10-28T15:56:46.928665Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2020-10-28T15:56:46.929560Z 0 [Warning] CA certificate ca.pem is self signed.
2020-10-28T15:56:46.929731Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2020-10-28T15:56:46.929854Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
2020-10-28T15:56:46.929880Z 0 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
2020-10-28T15:56:46.929918Z 0 [Note] Server socket created on IP: '0.0.0.0'.
2020-10-28T15:56:46.931315Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201028 15:56:46
2020-10-28T15:56:46.942769Z 0 [Note] Event Scheduler: Loaded 0 events
2020-10-28T15:56:46.943072Z 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-28T15:57:09.906872Z 4 [Note] Aborted connection 4 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T15:57:23.642684Z 5 [Note] Aborted connection 5 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T16:04:29.020918Z 10 [Note] Aborted connection 10 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T16:04:29.021102Z 11 [Note] Aborted connection 11 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T16:04:33.427260Z 12 [Note] Aborted connection 12 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T16:06:16.906177Z 6 [Note] Aborted connection 6 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T16:06:16.907302Z 7 [Note] Aborted connection 7 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T16:10:57.113267Z 20 [Warning] Following users were specified in CREATE USER IF NOT EXISTS but they already exist. Corresponding entry in binary log used default authentication plugin 'mysql_native_password' to rewrite authentication information(if any) for them: 'root'@'%'

2020-10-28T16:10:57.363463Z 0 [Note] Giving 0 client threads a chance to die gracefully
2020-10-28T16:10:57.363506Z 0 [Note] Shutting down slave threads
2020-10-28T16:10:57.363520Z 0 [Note] Forcefully disconnecting 0 remaining clients
2020-10-28T16:10:57.363531Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2020-10-28T16:10:57.363636Z 0 [Note] Binlog end
2020-10-28T16:10:57.365614Z 0 [Note] Shutting down plugin 'ngram'
2020-10-28T16:10:57.365633Z 0 [Note] Shutting down plugin 'partition'
2020-10-28T16:10:57.365641Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2020-10-28T16:10:57.365648Z 0 [Note] Shutting down plugin 'ARCHIVE'
2020-10-28T16:10:57.365655Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2020-10-28T16:10:57.365692Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2020-10-28T16:10:57.365700Z 0 [Note] Shutting down plugin 'MyISAM'
2020-10-28T16:10:57.365710Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2020-10-28T16:10:57.365716Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2020-10-28T16:10:57.365722Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2020-10-28T16:10:57.365729Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2020-10-28T16:10:57.365734Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2020-10-28T16:10:57.365740Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2020-10-28T16:10:57.365746Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2020-10-28T16:10:57.365752Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2020-10-28T16:10:57.365758Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2020-10-28T16:10:57.365764Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2020-10-28T16:10:57.365770Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2020-10-28T16:10:57.365776Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2020-10-28T16:10:57.365782Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2020-10-28T16:10:57.365788Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2020-10-28T16:10:57.365793Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2020-10-28T16:10:57.365799Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2020-10-28T16:10:57.365805Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2020-10-28T16:10:57.365811Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2020-10-28T16:10:57.365817Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2020-10-28T16:10:57.365822Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2020-10-28T16:10:57.365828Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2020-10-28T16:10:57.365834Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2020-10-28T16:10:57.365840Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2020-10-28T16:10:57.365846Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2020-10-28T16:10:57.365851Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2020-10-28T16:10:57.365857Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2020-10-28T16:10:57.365877Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2020-10-28T16:10:57.365883Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2020-10-28T16:10:57.365888Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2020-10-28T16:10:57.365893Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2020-10-28T16:10:57.365899Z 0 [Note] Shutting down plugin 'InnoDB'
2020-10-28T16:10:57.365984Z 0 [Note] InnoDB: FTS optimize thread exiting.
2020-10-28T16:10:57.366128Z 0 [Note] InnoDB: Starting shutdown...
2020-10-28T16:10:57.466378Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2020-10-28T16:10:57.467054Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 201028 16:10:57
2020-10-28T16:10:58.683670Z 0 [Note] InnoDB: Shutdown completed; log sequence number 23072546
2020-10-28T16:10:58.685977Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-10-28T16:10:58.685999Z 0 [Note] Shutting down plugin 'MEMORY'
2020-10-28T16:10:58.686008Z 0 [Note] Shutting down plugin 'CSV'
2020-10-28T16:10:58.686017Z 0 [Note] Shutting down plugin 'sha256_password'
2020-10-28T16:10:58.686023Z 0 [Note] Shutting down plugin 'mysql_native_password'
2020-10-28T16:10:58.686200Z 0 [Note] Shutting down plugin 'binlog'
2020-10-28T16:10:58.686837Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2020-10-28T16:10:58.792481Z 0 [Warning] Changed limits: max_open_files: 5000 (requested 5120)
2020-10-28T16:10:58.792817Z 0 [Warning] Changed limits: table_open_cache: 1983 (requested 2000)
2020-10-28T16:10:59.003374Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-10-28T16:10:59.005518Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.32-0ubuntu0.18.04.1) starting as process 17388 ...
2020-10-28T16:10:59.011687Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-10-28T16:10:59.011728Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-10-28T16:10:59.011743Z 0 [Note] InnoDB: Uses event mutexes
2020-10-28T16:10:59.011755Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-10-28T16:10:59.011768Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-10-28T16:10:59.011781Z 0 [Note] InnoDB: Using Linux native AIO
2020-10-28T16:10:59.012623Z 0 [Note] InnoDB: Number of pools: 1
2020-10-28T16:10:59.012772Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-10-28T16:10:59.015626Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-10-28T16:10:59.028818Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-10-28T16:10:59.031601Z 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-28T16:10:59.044405Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-10-28T16:10:59.070016Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-10-28T16:10:59.070122Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-10-28T16:10:59.094903Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-10-28T16:10:59.096060Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-10-28T16:10:59.096081Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-10-28T16:10:59.096884Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 23072546
2020-10-28T16:10:59.097178Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-10-28T16:10:59.097425Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-10-28T16:10:59.120627Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2020-10-28T16:10:59.120655Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2020-10-28T16:10:59.121464Z 0 [Warning] CA certificate ca.pem is self signed.
2020-10-28T16:10:59.121514Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2020-10-28T16:10:59.121637Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
2020-10-28T16:10:59.121656Z 0 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
2020-10-28T16:10:59.121709Z 0 [Note] Server socket created on IP: '0.0.0.0'.
2020-10-28T16:10:59.148185Z 0 [Note] Event Scheduler: Loaded 0 events
2020-10-28T16:10:59.148710Z 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-28T16:10:59.156533Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201028 16:10:59
2020-10-28T16:11:21.665984Z 4 [Note] Aborted connection 4 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T16:11:35.339604Z 5 [Note] Aborted connection 5 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T16:18:41.537375Z 10 [Note] Aborted connection 10 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T16:18:41.537553Z 11 [Note] Aborted connection 11 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T16:18:45.900898Z 12 [Note] Aborted connection 12 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T16:20:29.312768Z 7 [Note] Aborted connection 7 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T16:20:29.320216Z 6 [Note] Aborted connection 6 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T16:25:09.377963Z 20 [Warning] Following users were specified in CREATE USER IF NOT EXISTS but they already exist. Corresponding entry in binary log used default authentication plugin 'mysql_native_password' to rewrite authentication information(if any) for them: 'root'@'%'

2020-10-28T16:25:09.641175Z 0 [Note] Giving 0 client threads a chance to die gracefully
2020-10-28T16:25:09.641209Z 0 [Note] Shutting down slave threads
2020-10-28T16:25:09.641232Z 0 [Note] Forcefully disconnecting 0 remaining clients
2020-10-28T16:25:09.641243Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2020-10-28T16:25:09.641350Z 0 [Note] Binlog end
2020-10-28T16:25:09.643194Z 0 [Note] Shutting down plugin 'ngram'
2020-10-28T16:25:09.643211Z 0 [Note] Shutting down plugin 'partition'
2020-10-28T16:25:09.643218Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2020-10-28T16:25:09.643226Z 0 [Note] Shutting down plugin 'ARCHIVE'
2020-10-28T16:25:09.643232Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2020-10-28T16:25:09.643269Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2020-10-28T16:25:09.643277Z 0 [Note] Shutting down plugin 'MyISAM'
2020-10-28T16:25:09.643286Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2020-10-28T16:25:09.643293Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2020-10-28T16:25:09.643299Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2020-10-28T16:25:09.643305Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2020-10-28T16:25:09.643310Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2020-10-28T16:25:09.643316Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2020-10-28T16:25:09.643322Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2020-10-28T16:25:09.643327Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2020-10-28T16:25:09.643333Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2020-10-28T16:25:09.643339Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2020-10-28T16:25:09.643344Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2020-10-28T16:25:09.643350Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2020-10-28T16:25:09.643355Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2020-10-28T16:25:09.643361Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2020-10-28T16:25:09.643366Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2020-10-28T16:25:09.643372Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2020-10-28T16:25:09.643393Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2020-10-28T16:25:09.643399Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2020-10-28T16:25:09.643404Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2020-10-28T16:25:09.643409Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2020-10-28T16:25:09.643414Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2020-10-28T16:25:09.643419Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2020-10-28T16:25:09.643424Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2020-10-28T16:25:09.643429Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2020-10-28T16:25:09.643434Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2020-10-28T16:25:09.643440Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2020-10-28T16:25:09.643445Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2020-10-28T16:25:09.643450Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2020-10-28T16:25:09.643455Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2020-10-28T16:25:09.643459Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2020-10-28T16:25:09.643465Z 0 [Note] Shutting down plugin 'InnoDB'
2020-10-28T16:25:09.643556Z 0 [Note] InnoDB: FTS optimize thread exiting.
2020-10-28T16:25:09.643704Z 0 [Note] InnoDB: Starting shutdown...
2020-10-28T16:25:09.744042Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2020-10-28T16:25:09.744668Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 201028 16:25:09
2020-10-28T16:25:10.861098Z 0 [Note] InnoDB: Shutdown completed; log sequence number 34228339
2020-10-28T16:25:10.865977Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-10-28T16:25:10.866002Z 0 [Note] Shutting down plugin 'MEMORY'
2020-10-28T16:25:10.866012Z 0 [Note] Shutting down plugin 'CSV'
2020-10-28T16:25:10.866020Z 0 [Note] Shutting down plugin 'sha256_password'
2020-10-28T16:25:10.866026Z 0 [Note] Shutting down plugin 'mysql_native_password'
2020-10-28T16:25:10.866203Z 0 [Note] Shutting down plugin 'binlog'
2020-10-28T16:25:10.867909Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2020-10-28T16:25:10.982606Z 0 [Warning] Changed limits: max_open_files: 5000 (requested 5120)
2020-10-28T16:25:10.982892Z 0 [Warning] Changed limits: table_open_cache: 1983 (requested 2000)
2020-10-28T16:25:11.193570Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-10-28T16:25:11.195709Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.32-0ubuntu0.18.04.1) starting as process 59977 ...
2020-10-28T16:25:11.201774Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-10-28T16:25:11.201809Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-10-28T16:25:11.201818Z 0 [Note] InnoDB: Uses event mutexes
2020-10-28T16:25:11.201826Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-10-28T16:25:11.201833Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-10-28T16:25:11.201841Z 0 [Note] InnoDB: Using Linux native AIO
2020-10-28T16:25:11.202641Z 0 [Note] InnoDB: Number of pools: 1
2020-10-28T16:25:11.202784Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-10-28T16:25:11.205703Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-10-28T16:25:11.217959Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-10-28T16:25:11.220887Z 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-28T16:25:11.233072Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-10-28T16:25:11.265575Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-10-28T16:25:11.265688Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-10-28T16:25:11.290414Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-10-28T16:25:11.291495Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-10-28T16:25:11.291525Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-10-28T16:25:11.292159Z 0 [Note] InnoDB: Waiting for purge to start
2020-10-28T16:25:11.342346Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 34228339
2020-10-28T16:25:11.342660Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-10-28T16:25:11.342931Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-10-28T16:25:11.368648Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2020-10-28T16:25:11.368676Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2020-10-28T16:25:11.369507Z 0 [Warning] CA certificate ca.pem is self signed.
2020-10-28T16:25:11.369556Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2020-10-28T16:25:11.369666Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
2020-10-28T16:25:11.369689Z 0 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
2020-10-28T16:25:11.369725Z 0 [Note] Server socket created on IP: '0.0.0.0'.
2020-10-28T16:25:11.396184Z 0 [Note] Event Scheduler: Loaded 0 events
2020-10-28T16:25:11.396645Z 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-28T16:25:11.401781Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201028 16:25:11
2020-10-28T16:25:34.311417Z 4 [Note] Aborted connection 4 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T16:25:48.068613Z 5 [Note] Aborted connection 5 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T16:32:57.020899Z 10 [Note] Aborted connection 10 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T16:32:57.021130Z 11 [Note] Aborted connection 11 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T16:33:01.469624Z 12 [Note] Aborted connection 12 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T16:34:54.804296Z 7 [Note] Aborted connection 7 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T16:34:54.818958Z 6 [Note] Aborted connection 6 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)