2020-10-28T18:36:01.616632Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-10-28T18:36:01.824225Z 0 [Warning] InnoDB: New log files created, LSN=45790
2020-10-28T18:36:01.868004Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2020-10-28T18:36:01.881609Z 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: 6e02c3bb-194c-11eb-bfcc-fa163ef2c053.
2020-10-28T18:36:01.883450Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2020-10-28T18:36:02.229751Z 0 [Warning] CA certificate ca.pem is self signed.
2020-10-28T18:36:02.514279Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
2020-10-28T18:36:09.013264Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-10-28T18:36:09.015488Z 0 [Note] mysqld (mysqld 5.7.32-0ubuntu0.18.04.1) starting as process 41508 ...
2020-10-28T18:36:09.022218Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-10-28T18:36:09.022255Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-10-28T18:36:09.022264Z 0 [Note] InnoDB: Uses event mutexes
2020-10-28T18:36:09.022272Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-10-28T18:36:09.022279Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-10-28T18:36:09.022287Z 0 [Note] InnoDB: Using Linux native AIO
2020-10-28T18:36:09.022623Z 0 [Note] InnoDB: Number of pools: 1
2020-10-28T18:36:09.022774Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-10-28T18:36:09.025293Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-10-28T18:36:09.038491Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-10-28T18:36:09.041455Z 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-28T18:36:09.054170Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-10-28T18:36:09.064542Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-10-28T18:36:09.064633Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-10-28T18:36:09.089050Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-10-28T18:36:09.090139Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-10-28T18:36:09.090159Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-10-28T18:36:09.090791Z 0 [Note] InnoDB: Waiting for purge to start
2020-10-28T18:36:09.141036Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 2747070
2020-10-28T18:36:09.141483Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-10-28T18:36:09.141629Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-10-28T18:36:09.147331Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201028 18:36:09
2020-10-28T18:36:09.150940Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2020-10-28T18:36:09.150961Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2020-10-28T18:36:09.151967Z 0 [Warning] CA certificate ca.pem is self signed.
2020-10-28T18:36:09.152028Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2020-10-28T18:36:09.153657Z 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-28T18:36:09.176536Z 0 [Note] Event Scheduler: Loaded 0 events
2020-10-28T18:36:09.177036Z 0 [Note] mysqld: ready for connections.
Version: '5.7.32-0ubuntu0.18.04.1'  socket: '/tmp/tmp.cp4jdvXusR/mysqld.sock'  port: 0  (Ubuntu)
2020-10-28T18:36:09.186609Z 2 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2020-10-28T18:36:09.189104Z 0 [Note] Giving 0 client threads a chance to die gracefully
2020-10-28T18:36:09.189127Z 0 [Note] Shutting down slave threads
2020-10-28T18:36:09.189138Z 0 [Note] Forcefully disconnecting 0 remaining clients
2020-10-28T18:36:09.189148Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2020-10-28T18:36:09.189219Z 0 [Note] Binlog end
2020-10-28T18:36:09.189760Z 0 [Note] Shutting down plugin 'ngram'
2020-10-28T18:36:09.189777Z 0 [Note] Shutting down plugin 'partition'
2020-10-28T18:36:09.189783Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2020-10-28T18:36:09.189790Z 0 [Note] Shutting down plugin 'ARCHIVE'
2020-10-28T18:36:09.189796Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2020-10-28T18:36:09.189831Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2020-10-28T18:36:09.189837Z 0 [Note] Shutting down plugin 'MyISAM'
2020-10-28T18:36:09.189846Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2020-10-28T18:36:09.189852Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2020-10-28T18:36:09.189857Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2020-10-28T18:36:09.189862Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2020-10-28T18:36:09.189867Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2020-10-28T18:36:09.189872Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2020-10-28T18:36:09.189878Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2020-10-28T18:36:09.189883Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2020-10-28T18:36:09.189887Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2020-10-28T18:36:09.189893Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2020-10-28T18:36:09.189898Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2020-10-28T18:36:09.189903Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2020-10-28T18:36:09.189907Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2020-10-28T18:36:09.189912Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2020-10-28T18:36:09.189917Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2020-10-28T18:36:09.189922Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2020-10-28T18:36:09.189927Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2020-10-28T18:36:09.189932Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2020-10-28T18:36:09.189937Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2020-10-28T18:36:09.189942Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2020-10-28T18:36:09.189946Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2020-10-28T18:36:09.189951Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2020-10-28T18:36:09.189956Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2020-10-28T18:36:09.189961Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2020-10-28T18:36:09.189966Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2020-10-28T18:36:09.189971Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2020-10-28T18:36:09.189976Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2020-10-28T18:36:09.189981Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2020-10-28T18:36:09.189986Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2020-10-28T18:36:09.189990Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2020-10-28T18:36:09.189995Z 0 [Note] Shutting down plugin 'InnoDB'
2020-10-28T18:36:09.190072Z 0 [Note] InnoDB: FTS optimize thread exiting.
2020-10-28T18:36:09.190202Z 0 [Note] InnoDB: Starting shutdown...
2020-10-28T18:36:09.290453Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2020-10-28T18:36:09.290759Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 201028 18:36:09
2020-10-28T18:36:10.698275Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2747089
2020-10-28T18:36:10.700471Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-10-28T18:36:10.700492Z 0 [Note] Shutting down plugin 'MEMORY'
2020-10-28T18:36:10.700501Z 0 [Note] Shutting down plugin 'CSV'
2020-10-28T18:36:10.700520Z 0 [Note] Shutting down plugin 'sha256_password'
2020-10-28T18:36:10.700526Z 0 [Note] Shutting down plugin 'mysql_native_password'
2020-10-28T18:36:10.700704Z 0 [Note] Shutting down plugin 'binlog'
2020-10-28T18:36:10.701135Z 0 [Note] mysqld: Shutdown complete

2020-10-28T18:36:12.835547Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-10-28T18:36:12.837926Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.32-0ubuntu0.18.04.1) starting as process 41648 ...
2020-10-28T18:36:12.844693Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-10-28T18:36:12.844728Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-10-28T18:36:12.844737Z 0 [Note] InnoDB: Uses event mutexes
2020-10-28T18:36:12.844745Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-10-28T18:36:12.844753Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-10-28T18:36:12.844761Z 0 [Note] InnoDB: Using Linux native AIO
2020-10-28T18:36:12.845111Z 0 [Note] InnoDB: Number of pools: 1
2020-10-28T18:36:12.845275Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-10-28T18:36:12.848173Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-10-28T18:36:12.863344Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-10-28T18:36:12.866926Z 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-28T18:36:12.879661Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-10-28T18:36:12.899301Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-10-28T18:36:12.899396Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-10-28T18:36:12.923722Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-10-28T18:36:12.925015Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-10-28T18:36:12.925035Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-10-28T18:36:12.926118Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 2747089
2020-10-28T18:36:12.926364Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-10-28T18:36:12.926666Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-10-28T18:36:12.929256Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201028 18:36:12
2020-10-28T18:36:12.935177Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2020-10-28T18:36:12.935203Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2020-10-28T18:36:12.936008Z 0 [Warning] CA certificate ca.pem is self signed.
2020-10-28T18:36:12.936057Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2020-10-28T18:36:12.936168Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2020-10-28T18:36:12.936192Z 0 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
2020-10-28T18:36:12.936246Z 0 [Note] Server socket created on IP: '127.0.0.1'.
2020-10-28T18:36:12.948087Z 0 [Note] Event Scheduler: Loaded 0 events
2020-10-28T18:36:12.948411Z 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-28T18:42:37.151738Z 0 [Note] Giving 0 client threads a chance to die gracefully
2020-10-28T18:42:37.151774Z 0 [Note] Shutting down slave threads
2020-10-28T18:42:37.151787Z 0 [Note] Forcefully disconnecting 0 remaining clients
2020-10-28T18:42:37.151797Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2020-10-28T18:42:37.151877Z 0 [Note] Binlog end
2020-10-28T18:42:37.152504Z 0 [Note] Shutting down plugin 'ngram'
2020-10-28T18:42:37.152518Z 0 [Note] Shutting down plugin 'partition'
2020-10-28T18:42:37.152525Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2020-10-28T18:42:37.152546Z 0 [Note] Shutting down plugin 'ARCHIVE'
2020-10-28T18:42:37.152552Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2020-10-28T18:42:37.152589Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2020-10-28T18:42:37.152596Z 0 [Note] Shutting down plugin 'MyISAM'
2020-10-28T18:42:37.152605Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2020-10-28T18:42:37.152611Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2020-10-28T18:42:37.152617Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2020-10-28T18:42:37.152622Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2020-10-28T18:42:37.152627Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2020-10-28T18:42:37.152632Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2020-10-28T18:42:37.152637Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2020-10-28T18:42:37.152642Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2020-10-28T18:42:37.152647Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2020-10-28T18:42:37.152652Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2020-10-28T18:42:37.152657Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2020-10-28T18:42:37.152662Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2020-10-28T18:42:37.152667Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2020-10-28T18:42:37.152672Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2020-10-28T18:42:37.152677Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2020-10-28T18:42:37.152682Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2020-10-28T18:42:37.152687Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2020-10-28T18:42:37.152692Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2020-10-28T18:42:37.152697Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2020-10-28T18:42:37.152702Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2020-10-28T18:42:37.152708Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2020-10-28T18:42:37.152713Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2020-10-28T18:42:37.152718Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2020-10-28T18:42:37.152723Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2020-10-28T18:42:37.152728Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2020-10-28T18:42:37.152733Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2020-10-28T18:42:37.152738Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2020-10-28T18:42:37.152743Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2020-10-28T18:42:37.152748Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2020-10-28T18:42:37.152753Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2020-10-28T18:42:37.152758Z 0 [Note] Shutting down plugin 'InnoDB'
2020-10-28T18:42:37.152837Z 0 [Note] InnoDB: FTS optimize thread exiting.
2020-10-28T18:42:37.152984Z 0 [Note] InnoDB: Starting shutdown...
2020-10-28T18:42:37.253235Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2020-10-28T18:42:37.253656Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 201028 18:42:37
2020-10-28T18:42:38.862869Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2747117
2020-10-28T18:42:38.865081Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-10-28T18:42:38.865104Z 0 [Note] Shutting down plugin 'MEMORY'
2020-10-28T18:42:38.865114Z 0 [Note] Shutting down plugin 'CSV'
2020-10-28T18:42:38.865122Z 0 [Note] Shutting down plugin 'sha256_password'
2020-10-28T18:42:38.865128Z 0 [Note] Shutting down plugin 'mysql_native_password'
2020-10-28T18:42:38.865309Z 0 [Note] Shutting down plugin 'binlog'
2020-10-28T18:42:38.865782Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2020-10-28T18:42:38.987673Z 0 [Warning] Changed limits: max_open_files: 5000 (requested 5120)
2020-10-28T18:42:38.987980Z 0 [Warning] Changed limits: table_open_cache: 1983 (requested 2000)
2020-10-28T18:42:39.192532Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-10-28T18:42:39.194670Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.32-0ubuntu0.18.04.1) starting as process 63175 ...
2020-10-28T18:42:39.201110Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-10-28T18:42:39.201147Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-10-28T18:42:39.201155Z 0 [Note] InnoDB: Uses event mutexes
2020-10-28T18:42:39.201163Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-10-28T18:42:39.201170Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-10-28T18:42:39.201178Z 0 [Note] InnoDB: Using Linux native AIO
2020-10-28T18:42:39.201977Z 0 [Note] InnoDB: Number of pools: 1
2020-10-28T18:42:39.202130Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-10-28T18:42:39.204832Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-10-28T18:42:39.216313Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-10-28T18:42:39.219297Z 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-28T18:42:39.231566Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-10-28T18:42:39.251316Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-10-28T18:42:39.251429Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-10-28T18:42:39.276002Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-10-28T18:42:39.277120Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-10-28T18:42:39.277138Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-10-28T18:42:39.278169Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 2747117
2020-10-28T18:42:39.278519Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-10-28T18:42:39.278943Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-10-28T18:42:39.281567Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201028 18:42:39
2020-10-28T18:42:39.287094Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2020-10-28T18:42:39.287116Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2020-10-28T18:42:39.287922Z 0 [Warning] CA certificate ca.pem is self signed.
2020-10-28T18:42:39.287965Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2020-10-28T18:42:39.288072Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
2020-10-28T18:42:39.288090Z 0 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
2020-10-28T18:42:39.288125Z 0 [Note] Server socket created on IP: '0.0.0.0'.
2020-10-28T18:42:39.300274Z 0 [Note] Event Scheduler: Loaded 0 events
2020-10-28T18:42:39.300591Z 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-28T18:43:02.265303Z 4 [Note] Aborted connection 4 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T18:43:16.201274Z 5 [Note] Aborted connection 5 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T18:50:31.227222Z 10 [Note] Aborted connection 10 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T18:50:31.227516Z 11 [Note] Aborted connection 11 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T18:50:35.711940Z 12 [Note] Aborted connection 12 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T18:52:16.807554Z 6 [Note] Aborted connection 6 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T18:52:16.807902Z 7 [Note] Aborted connection 7 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T18:57:12.002533Z 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-28T18:57:12.266999Z 0 [Note] Giving 0 client threads a chance to die gracefully
2020-10-28T18:57:12.267038Z 0 [Note] Shutting down slave threads
2020-10-28T18:57:12.267053Z 0 [Note] Forcefully disconnecting 0 remaining clients
2020-10-28T18:57:12.267063Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2020-10-28T18:57:12.267161Z 0 [Note] Binlog end
2020-10-28T18:57:12.268964Z 0 [Note] Shutting down plugin 'ngram'
2020-10-28T18:57:12.268982Z 0 [Note] Shutting down plugin 'partition'
2020-10-28T18:57:12.268989Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2020-10-28T18:57:12.268996Z 0 [Note] Shutting down plugin 'ARCHIVE'
2020-10-28T18:57:12.269001Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2020-10-28T18:57:12.269038Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2020-10-28T18:57:12.269045Z 0 [Note] Shutting down plugin 'MyISAM'
2020-10-28T18:57:12.269054Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2020-10-28T18:57:12.269060Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2020-10-28T18:57:12.269065Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2020-10-28T18:57:12.269070Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2020-10-28T18:57:12.269075Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2020-10-28T18:57:12.269080Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2020-10-28T18:57:12.269085Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2020-10-28T18:57:12.269090Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2020-10-28T18:57:12.269095Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2020-10-28T18:57:12.269100Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2020-10-28T18:57:12.269104Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2020-10-28T18:57:12.269109Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2020-10-28T18:57:12.269114Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2020-10-28T18:57:12.269119Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2020-10-28T18:57:12.269123Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2020-10-28T18:57:12.269128Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2020-10-28T18:57:12.269133Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2020-10-28T18:57:12.269138Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2020-10-28T18:57:12.269143Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2020-10-28T18:57:12.269147Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2020-10-28T18:57:12.269152Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2020-10-28T18:57:12.269157Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2020-10-28T18:57:12.269162Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2020-10-28T18:57:12.269167Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2020-10-28T18:57:12.269172Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2020-10-28T18:57:12.269176Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2020-10-28T18:57:12.269181Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2020-10-28T18:57:12.269186Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2020-10-28T18:57:12.269191Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2020-10-28T18:57:12.269196Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2020-10-28T18:57:12.269200Z 0 [Note] Shutting down plugin 'InnoDB'
2020-10-28T18:57:12.269288Z 0 [Note] InnoDB: FTS optimize thread exiting.
2020-10-28T18:57:12.269499Z 0 [Note] InnoDB: Starting shutdown...
2020-10-28T18:57:12.369762Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2020-10-28T18:57:12.370332Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 201028 18:57:12
2020-10-28T18:57:13.987723Z 0 [Note] InnoDB: Shutdown completed; log sequence number 11895598
2020-10-28T18:57:13.989946Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-10-28T18:57:13.989982Z 0 [Note] Shutting down plugin 'MEMORY'
2020-10-28T18:57:13.989991Z 0 [Note] Shutting down plugin 'CSV'
2020-10-28T18:57:13.989999Z 0 [Note] Shutting down plugin 'sha256_password'
2020-10-28T18:57:13.990005Z 0 [Note] Shutting down plugin 'mysql_native_password'
2020-10-28T18:57:13.990183Z 0 [Note] Shutting down plugin 'binlog'
2020-10-28T18:57:13.990852Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2020-10-28T18:57:14.118941Z 0 [Warning] Changed limits: max_open_files: 5000 (requested 5120)
2020-10-28T18:57:14.119316Z 0 [Warning] Changed limits: table_open_cache: 1983 (requested 2000)
2020-10-28T18:57:14.334239Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-10-28T18:57:14.336436Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.32-0ubuntu0.18.04.1) starting as process 105685 ...
2020-10-28T18:57:14.343165Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-10-28T18:57:14.343200Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-10-28T18:57:14.343208Z 0 [Note] InnoDB: Uses event mutexes
2020-10-28T18:57:14.343216Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-10-28T18:57:14.343223Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-10-28T18:57:14.343231Z 0 [Note] InnoDB: Using Linux native AIO
2020-10-28T18:57:14.344029Z 0 [Note] InnoDB: Number of pools: 1
2020-10-28T18:57:14.344181Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-10-28T18:57:14.347019Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-10-28T18:57:14.359212Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-10-28T18:57:14.362216Z 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-28T18:57:14.374435Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-10-28T18:57:14.407191Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-10-28T18:57:14.407301Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-10-28T18:57:14.431953Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-10-28T18:57:14.433093Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-10-28T18:57:14.433111Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-10-28T18:57:14.434111Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 11895598
2020-10-28T18:57:14.434376Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-10-28T18:57:14.434743Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-10-28T18:57:14.466169Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2020-10-28T18:57:14.466202Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2020-10-28T18:57:14.467054Z 0 [Warning] CA certificate ca.pem is self signed.
2020-10-28T18:57:14.467104Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2020-10-28T18:57:14.467216Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
2020-10-28T18:57:14.467240Z 0 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
2020-10-28T18:57:14.467278Z 0 [Note] Server socket created on IP: '0.0.0.0'.
2020-10-28T18:57:14.469075Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201028 18:57:14
2020-10-28T18:57:14.480703Z 0 [Note] Event Scheduler: Loaded 0 events
2020-10-28T18:57:14.481048Z 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-28T18:57:38.102819Z 4 [Note] Aborted connection 4 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T18:57:52.322224Z 5 [Note] Aborted connection 5 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T19:05:19.904067Z 10 [Note] Aborted connection 10 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T19:05:19.904282Z 11 [Note] Aborted connection 11 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T19:05:24.336158Z 12 [Note] Aborted connection 12 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T19:07:09.627384Z 7 [Note] Aborted connection 7 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T19:07:09.630147Z 6 [Note] Aborted connection 6 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T19:11:56.061466Z 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-28T19:11:56.322907Z 0 [Note] Giving 0 client threads a chance to die gracefully
2020-10-28T19:11:56.322939Z 0 [Note] Shutting down slave threads
2020-10-28T19:11:56.322952Z 0 [Note] Forcefully disconnecting 0 remaining clients
2020-10-28T19:11:56.322963Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2020-10-28T19:11:56.323058Z 0 [Note] Binlog end
2020-10-28T19:11:56.325633Z 0 [Note] Shutting down plugin 'ngram'
2020-10-28T19:11:56.325653Z 0 [Note] Shutting down plugin 'partition'
2020-10-28T19:11:56.325660Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2020-10-28T19:11:56.325667Z 0 [Note] Shutting down plugin 'ARCHIVE'
2020-10-28T19:11:56.325673Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2020-10-28T19:11:56.325711Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2020-10-28T19:11:56.325718Z 0 [Note] Shutting down plugin 'MyISAM'
2020-10-28T19:11:56.325728Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2020-10-28T19:11:56.325735Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2020-10-28T19:11:56.325740Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2020-10-28T19:11:56.325746Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2020-10-28T19:11:56.325752Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2020-10-28T19:11:56.325757Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2020-10-28T19:11:56.325763Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2020-10-28T19:11:56.325769Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2020-10-28T19:11:56.325775Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2020-10-28T19:11:56.325780Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2020-10-28T19:11:56.325786Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2020-10-28T19:11:56.325791Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2020-10-28T19:11:56.325797Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2020-10-28T19:11:56.325802Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2020-10-28T19:11:56.325807Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2020-10-28T19:11:56.325813Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2020-10-28T19:11:56.325818Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2020-10-28T19:11:56.325824Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2020-10-28T19:11:56.325829Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2020-10-28T19:11:56.325835Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2020-10-28T19:11:56.325840Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2020-10-28T19:11:56.325846Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2020-10-28T19:11:56.325851Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2020-10-28T19:11:56.325856Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2020-10-28T19:11:56.325862Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2020-10-28T19:11:56.325867Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2020-10-28T19:11:56.325873Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2020-10-28T19:11:56.325893Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2020-10-28T19:11:56.325899Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2020-10-28T19:11:56.325904Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2020-10-28T19:11:56.325909Z 0 [Note] Shutting down plugin 'InnoDB'
2020-10-28T19:11:56.326041Z 0 [Note] InnoDB: FTS optimize thread exiting.
2020-10-28T19:11:56.326190Z 0 [Note] InnoDB: Starting shutdown...
2020-10-28T19:11:56.426448Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2020-10-28T19:11:56.427065Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 201028 19:11:56
2020-10-28T19:11:57.344759Z 0 [Note] InnoDB: Shutdown completed; log sequence number 22808785
2020-10-28T19:11:57.347063Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-10-28T19:11:57.347084Z 0 [Note] Shutting down plugin 'MEMORY'
2020-10-28T19:11:57.347094Z 0 [Note] Shutting down plugin 'CSV'
2020-10-28T19:11:57.347102Z 0 [Note] Shutting down plugin 'sha256_password'
2020-10-28T19:11:57.347108Z 0 [Note] Shutting down plugin 'mysql_native_password'
2020-10-28T19:11:57.347285Z 0 [Note] Shutting down plugin 'binlog'
2020-10-28T19:11:57.347924Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2020-10-28T19:11:57.462235Z 0 [Warning] Changed limits: max_open_files: 5000 (requested 5120)
2020-10-28T19:11:57.462556Z 0 [Warning] Changed limits: table_open_cache: 1983 (requested 2000)
2020-10-28T19:11:57.674925Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-10-28T19:11:57.677083Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.32-0ubuntu0.18.04.1) starting as process 17418 ...
2020-10-28T19:11:57.683206Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-10-28T19:11:57.683244Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-10-28T19:11:57.683252Z 0 [Note] InnoDB: Uses event mutexes
2020-10-28T19:11:57.683260Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-10-28T19:11:57.683267Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-10-28T19:11:57.683275Z 0 [Note] InnoDB: Using Linux native AIO
2020-10-28T19:11:57.684114Z 0 [Note] InnoDB: Number of pools: 1
2020-10-28T19:11:57.684263Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-10-28T19:11:57.687132Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-10-28T19:11:57.700874Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-10-28T19:11:57.703759Z 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-28T19:11:57.716612Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-10-28T19:11:57.749295Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-10-28T19:11:57.749467Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-10-28T19:11:57.774452Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-10-28T19:11:57.775738Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-10-28T19:11:57.775759Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-10-28T19:11:57.776705Z 0 [Note] InnoDB: Waiting for purge to start
2020-10-28T19:11:57.826937Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 22808785
2020-10-28T19:11:57.827208Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-10-28T19:11:57.827632Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-10-28T19:11:57.857715Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2020-10-28T19:11:57.857745Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2020-10-28T19:11:57.858577Z 0 [Warning] CA certificate ca.pem is self signed.
2020-10-28T19:11:57.858626Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2020-10-28T19:11:57.858752Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
2020-10-28T19:11:57.858771Z 0 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
2020-10-28T19:11:57.858826Z 0 [Note] Server socket created on IP: '0.0.0.0'.
2020-10-28T19:11:57.882058Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201028 19:11:57
2020-10-28T19:11:57.888821Z 0 [Note] Event Scheduler: Loaded 0 events
2020-10-28T19:11:57.889156Z 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-28T19:12:20.721556Z 4 [Note] Aborted connection 4 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T19:12:34.696505Z 5 [Note] Aborted connection 5 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T19:19:45.942605Z 10 [Note] Aborted connection 10 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T19:19:45.942813Z 11 [Note] Aborted connection 11 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T19:19:50.358612Z 12 [Note] Aborted connection 12 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T19:21:34.240741Z 7 [Note] Aborted connection 7 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T19:21:34.255212Z 6 [Note] Aborted connection 6 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T19:26:26.805373Z 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-28T19:26:27.089245Z 0 [Note] Giving 0 client threads a chance to die gracefully
2020-10-28T19:26:27.089287Z 0 [Note] Shutting down slave threads
2020-10-28T19:26:27.089302Z 0 [Note] Forcefully disconnecting 0 remaining clients
2020-10-28T19:26:27.089312Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2020-10-28T19:26:27.089453Z 0 [Note] Binlog end
2020-10-28T19:26:27.091951Z 0 [Note] Shutting down plugin 'ngram'
2020-10-28T19:26:27.091970Z 0 [Note] Shutting down plugin 'partition'
2020-10-28T19:26:27.091977Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2020-10-28T19:26:27.091985Z 0 [Note] Shutting down plugin 'ARCHIVE'
2020-10-28T19:26:27.091991Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2020-10-28T19:26:27.092029Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2020-10-28T19:26:27.092036Z 0 [Note] Shutting down plugin 'MyISAM'
2020-10-28T19:26:27.092046Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2020-10-28T19:26:27.092053Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2020-10-28T19:26:27.092059Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2020-10-28T19:26:27.092065Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2020-10-28T19:26:27.092071Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2020-10-28T19:26:27.092076Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2020-10-28T19:26:27.092082Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2020-10-28T19:26:27.092088Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2020-10-28T19:26:27.092094Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2020-10-28T19:26:27.092100Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2020-10-28T19:26:27.092106Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2020-10-28T19:26:27.092111Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2020-10-28T19:26:27.092117Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2020-10-28T19:26:27.092123Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2020-10-28T19:26:27.092129Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2020-10-28T19:26:27.092135Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2020-10-28T19:26:27.092154Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2020-10-28T19:26:27.092161Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2020-10-28T19:26:27.092166Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2020-10-28T19:26:27.092172Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2020-10-28T19:26:27.092177Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2020-10-28T19:26:27.092183Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2020-10-28T19:26:27.092188Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2020-10-28T19:26:27.092194Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2020-10-28T19:26:27.092199Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2020-10-28T19:26:27.092204Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2020-10-28T19:26:27.092210Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2020-10-28T19:26:27.092215Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2020-10-28T19:26:27.092220Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2020-10-28T19:26:27.092225Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2020-10-28T19:26:27.092230Z 0 [Note] Shutting down plugin 'InnoDB'
2020-10-28T19:26:27.092332Z 0 [Note] InnoDB: FTS optimize thread exiting.
2020-10-28T19:26:27.092477Z 0 [Note] InnoDB: Starting shutdown...
2020-10-28T19:26:27.192767Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2020-10-28T19:26:27.193617Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 201028 19:26:27
2020-10-28T19:26:28.510926Z 0 [Note] InnoDB: Shutdown completed; log sequence number 33864663
2020-10-28T19:26:28.513330Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-10-28T19:26:28.513352Z 0 [Note] Shutting down plugin 'MEMORY'
2020-10-28T19:26:28.513361Z 0 [Note] Shutting down plugin 'CSV'
2020-10-28T19:26:28.513370Z 0 [Note] Shutting down plugin 'sha256_password'
2020-10-28T19:26:28.513375Z 0 [Note] Shutting down plugin 'mysql_native_password'
2020-10-28T19:26:28.513607Z 0 [Note] Shutting down plugin 'binlog'
2020-10-28T19:26:28.514319Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2020-10-28T19:26:28.627171Z 0 [Warning] Changed limits: max_open_files: 5000 (requested 5120)
2020-10-28T19:26:28.627464Z 0 [Warning] Changed limits: table_open_cache: 1983 (requested 2000)
2020-10-28T19:26:28.832960Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-10-28T19:26:28.835109Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.32-0ubuntu0.18.04.1) starting as process 59996 ...
2020-10-28T19:26:28.841816Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-10-28T19:26:28.841851Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-10-28T19:26:28.841860Z 0 [Note] InnoDB: Uses event mutexes
2020-10-28T19:26:28.841867Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-10-28T19:26:28.841875Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-10-28T19:26:28.841883Z 0 [Note] InnoDB: Using Linux native AIO
2020-10-28T19:26:28.842675Z 0 [Note] InnoDB: Number of pools: 1
2020-10-28T19:26:28.842824Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-10-28T19:26:28.845727Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-10-28T19:26:28.857317Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-10-28T19:26:28.860165Z 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-28T19:26:28.872308Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-10-28T19:26:28.905191Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-10-28T19:26:28.905303Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-10-28T19:26:28.930317Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-10-28T19:26:28.931445Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-10-28T19:26:28.931478Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-10-28T19:26:28.932141Z 0 [Note] InnoDB: Waiting for purge to start
2020-10-28T19:26:28.982346Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 33864663
2020-10-28T19:26:28.982667Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-10-28T19:26:28.983008Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-10-28T19:26:29.010084Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2020-10-28T19:26:29.010114Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2020-10-28T19:26:29.010950Z 0 [Warning] CA certificate ca.pem is self signed.
2020-10-28T19:26:29.011000Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2020-10-28T19:26:29.011110Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
2020-10-28T19:26:29.011134Z 0 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
2020-10-28T19:26:29.011187Z 0 [Note] Server socket created on IP: '0.0.0.0'.
2020-10-28T19:26:29.045974Z 0 [Note] Event Scheduler: Loaded 0 events
2020-10-28T19:26:29.046307Z 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-28T19:26:29.994080Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201028 19:26:29
2020-10-28T19:26:52.483116Z 4 [Note] Aborted connection 4 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T19:27:06.300717Z 5 [Note] Aborted connection 5 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T19:34:15.797754Z 10 [Note] Aborted connection 10 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T19:34:15.797961Z 11 [Note] Aborted connection 11 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T19:34:20.199961Z 12 [Note] Aborted connection 12 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T19:36:10.822889Z 6 [Note] Aborted connection 6 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-28T19:36:10.823888Z 7 [Note] Aborted connection 7 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)