2020-10-27T22:05:55.285136Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-10-27T22:05:55.479503Z 0 [Warning] InnoDB: New log files created, LSN=45790
2020-10-27T22:05:55.525172Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2020-10-27T22:05:55.539661Z 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: 9600bb8f-18a0-11eb-ab6a-fa163e710818.
2020-10-27T22:05:55.540956Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2020-10-27T22:05:56.049357Z 0 [Warning] CA certificate ca.pem is self signed.
2020-10-27T22:05:56.469218Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
2020-10-27T22:06:03.472470Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-10-27T22:06:03.475213Z 0 [Note] mysqld (mysqld 5.7.32-0ubuntu0.18.04.1) starting as process 41541 ...
2020-10-27T22:06:03.481568Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-10-27T22:06:03.481606Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-10-27T22:06:03.481614Z 0 [Note] InnoDB: Uses event mutexes
2020-10-27T22:06:03.481622Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-10-27T22:06:03.481629Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-10-27T22:06:03.481637Z 0 [Note] InnoDB: Using Linux native AIO
2020-10-27T22:06:03.481973Z 0 [Note] InnoDB: Number of pools: 1
2020-10-27T22:06:03.482126Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-10-27T22:06:03.484677Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-10-27T22:06:03.498133Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-10-27T22:06:03.501269Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-10-27T22:06:03.513421Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-10-27T22:06:03.523759Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-10-27T22:06:03.523864Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-10-27T22:06:03.548987Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-10-27T22:06:03.550082Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-10-27T22:06:03.550101Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-10-27T22:06:03.550984Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 2747070
2020-10-27T22:06:03.551573Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-10-27T22:06:03.551821Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-10-27T22:06:03.554216Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201027 22:06:03
2020-10-27T22:06:03.560566Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2020-10-27T22:06:03.560589Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2020-10-27T22:06:03.561398Z 0 [Warning] CA certificate ca.pem is self signed.
2020-10-27T22:06:03.561445Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2020-10-27T22:06:03.563057Z 0 [Warning] Insecure configuration for --pid-file: Location '/tmp' in the path is accessible to all OS users. Consider choosing a different directory.
2020-10-27T22:06:03.575097Z 0 [Note] Event Scheduler: Loaded 0 events
2020-10-27T22:06:03.575407Z 0 [Note] mysqld: ready for connections.
Version: '5.7.32-0ubuntu0.18.04.1'  socket: '/tmp/tmp.S3RRFQ3cSR/mysqld.sock'  port: 0  (Ubuntu)
2020-10-27T22:06:03.583844Z 2 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2020-10-27T22:06:03.586511Z 0 [Note] Giving 0 client threads a chance to die gracefully
2020-10-27T22:06:03.586536Z 0 [Note] Shutting down slave threads
2020-10-27T22:06:03.586547Z 0 [Note] Forcefully disconnecting 0 remaining clients
2020-10-27T22:06:03.586556Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2020-10-27T22:06:03.586628Z 0 [Note] Binlog end
2020-10-27T22:06:03.587134Z 0 [Note] Shutting down plugin 'ngram'
2020-10-27T22:06:03.587149Z 0 [Note] Shutting down plugin 'partition'
2020-10-27T22:06:03.587156Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2020-10-27T22:06:03.587163Z 0 [Note] Shutting down plugin 'ARCHIVE'
2020-10-27T22:06:03.587168Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2020-10-27T22:06:03.587201Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2020-10-27T22:06:03.587207Z 0 [Note] Shutting down plugin 'MyISAM'
2020-10-27T22:06:03.587216Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2020-10-27T22:06:03.587223Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2020-10-27T22:06:03.587228Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2020-10-27T22:06:03.587233Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2020-10-27T22:06:03.587238Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2020-10-27T22:06:03.587243Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2020-10-27T22:06:03.587248Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2020-10-27T22:06:03.587253Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2020-10-27T22:06:03.587258Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2020-10-27T22:06:03.587263Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2020-10-27T22:06:03.587268Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2020-10-27T22:06:03.587273Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2020-10-27T22:06:03.587277Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2020-10-27T22:06:03.587282Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2020-10-27T22:06:03.587287Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2020-10-27T22:06:03.587292Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2020-10-27T22:06:03.587297Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2020-10-27T22:06:03.587302Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2020-10-27T22:06:03.587307Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2020-10-27T22:06:03.587312Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2020-10-27T22:06:03.587317Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2020-10-27T22:06:03.587322Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2020-10-27T22:06:03.587327Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2020-10-27T22:06:03.587332Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2020-10-27T22:06:03.587337Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2020-10-27T22:06:03.587342Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2020-10-27T22:06:03.587347Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2020-10-27T22:06:03.587351Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2020-10-27T22:06:03.587356Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2020-10-27T22:06:03.587361Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2020-10-27T22:06:03.587366Z 0 [Note] Shutting down plugin 'InnoDB'
2020-10-27T22:06:03.587446Z 0 [Note] InnoDB: FTS optimize thread exiting.
2020-10-27T22:06:03.587575Z 0 [Note] InnoDB: Starting shutdown...
2020-10-27T22:06:03.687833Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2020-10-27T22:06:03.688141Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 201027 22:06:03
2020-10-27T22:06:05.195949Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2747089
2020-10-27T22:06:05.198131Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-10-27T22:06:05.198152Z 0 [Note] Shutting down plugin 'MEMORY'
2020-10-27T22:06:05.198161Z 0 [Note] Shutting down plugin 'CSV'
2020-10-27T22:06:05.198169Z 0 [Note] Shutting down plugin 'sha256_password'
2020-10-27T22:06:05.198188Z 0 [Note] Shutting down plugin 'mysql_native_password'
2020-10-27T22:06:05.198386Z 0 [Note] Shutting down plugin 'binlog'
2020-10-27T22:06:05.198814Z 0 [Note] mysqld: Shutdown complete

2020-10-27T22:06:07.143861Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-10-27T22:06:07.145999Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.32-0ubuntu0.18.04.1) starting as process 41679 ...
2020-10-27T22:06:07.152082Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-10-27T22:06:07.152124Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-10-27T22:06:07.152133Z 0 [Note] InnoDB: Uses event mutexes
2020-10-27T22:06:07.152141Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-10-27T22:06:07.152149Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-10-27T22:06:07.152156Z 0 [Note] InnoDB: Using Linux native AIO
2020-10-27T22:06:07.152481Z 0 [Note] InnoDB: Number of pools: 1
2020-10-27T22:06:07.152626Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-10-27T22:06:07.155344Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-10-27T22:06:07.168426Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-10-27T22:06:07.171421Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-10-27T22:06:07.183587Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-10-27T22:06:07.194729Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-10-27T22:06:07.194837Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-10-27T22:06:07.218458Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-10-27T22:06:07.219545Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-10-27T22:06:07.219564Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-10-27T22:06:07.220687Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 2747089
2020-10-27T22:06:07.220922Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-10-27T22:06:07.221217Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-10-27T22:06:07.223725Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201027 22:06:07
2020-10-27T22:06:07.229441Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2020-10-27T22:06:07.229465Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2020-10-27T22:06:07.230285Z 0 [Warning] CA certificate ca.pem is self signed.
2020-10-27T22:06:07.230333Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2020-10-27T22:06:07.230529Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2020-10-27T22:06:07.230551Z 0 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
2020-10-27T22:06:07.230602Z 0 [Note] Server socket created on IP: '127.0.0.1'.
2020-10-27T22:06:07.242120Z 0 [Note] Event Scheduler: Loaded 0 events
2020-10-27T22:06:07.242461Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.32-0ubuntu0.18.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
2020-10-27T22:12:28.233853Z 0 [Note] Giving 0 client threads a chance to die gracefully
2020-10-27T22:12:28.233890Z 0 [Note] Shutting down slave threads
2020-10-27T22:12:28.233903Z 0 [Note] Forcefully disconnecting 0 remaining clients
2020-10-27T22:12:28.233913Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2020-10-27T22:12:28.233961Z 0 [Note] Binlog end
2020-10-27T22:12:28.234632Z 0 [Note] Shutting down plugin 'ngram'
2020-10-27T22:12:28.234647Z 0 [Note] Shutting down plugin 'partition'
2020-10-27T22:12:28.234654Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2020-10-27T22:12:28.234661Z 0 [Note] Shutting down plugin 'ARCHIVE'
2020-10-27T22:12:28.234678Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2020-10-27T22:12:28.234716Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2020-10-27T22:12:28.234722Z 0 [Note] Shutting down plugin 'MyISAM'
2020-10-27T22:12:28.234732Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2020-10-27T22:12:28.234738Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2020-10-27T22:12:28.234743Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2020-10-27T22:12:28.234748Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2020-10-27T22:12:28.234753Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2020-10-27T22:12:28.234758Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2020-10-27T22:12:28.234763Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2020-10-27T22:12:28.234768Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2020-10-27T22:12:28.234773Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2020-10-27T22:12:28.234778Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2020-10-27T22:12:28.234783Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2020-10-27T22:12:28.234788Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2020-10-27T22:12:28.234793Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2020-10-27T22:12:28.234798Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2020-10-27T22:12:28.234803Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2020-10-27T22:12:28.234808Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2020-10-27T22:12:28.234813Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2020-10-27T22:12:28.234818Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2020-10-27T22:12:28.234823Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2020-10-27T22:12:28.234828Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2020-10-27T22:12:28.234833Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2020-10-27T22:12:28.234838Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2020-10-27T22:12:28.234843Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2020-10-27T22:12:28.234848Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2020-10-27T22:12:28.234853Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2020-10-27T22:12:28.234858Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2020-10-27T22:12:28.234863Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2020-10-27T22:12:28.234868Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2020-10-27T22:12:28.234873Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2020-10-27T22:12:28.234878Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2020-10-27T22:12:28.234883Z 0 [Note] Shutting down plugin 'InnoDB'
2020-10-27T22:12:28.234959Z 0 [Note] InnoDB: FTS optimize thread exiting.
2020-10-27T22:12:28.235107Z 0 [Note] InnoDB: Starting shutdown...
2020-10-27T22:12:28.335315Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2020-10-27T22:12:28.335585Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 201027 22:12:28
2020-10-27T22:12:29.944723Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2747117
2020-10-27T22:12:29.946941Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-10-27T22:12:29.946963Z 0 [Note] Shutting down plugin 'MEMORY'
2020-10-27T22:12:29.946972Z 0 [Note] Shutting down plugin 'CSV'
2020-10-27T22:12:29.946980Z 0 [Note] Shutting down plugin 'sha256_password'
2020-10-27T22:12:29.946986Z 0 [Note] Shutting down plugin 'mysql_native_password'
2020-10-27T22:12:29.947162Z 0 [Note] Shutting down plugin 'binlog'
2020-10-27T22:12:29.947584Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2020-10-27T22:12:30.053655Z 0 [Warning] Changed limits: max_open_files: 5000 (requested 5120)
2020-10-27T22:12:30.053955Z 0 [Warning] Changed limits: table_open_cache: 1983 (requested 2000)
2020-10-27T22:12:30.264814Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-10-27T22:12:30.266912Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.32-0ubuntu0.18.04.1) starting as process 63206 ...
2020-10-27T22:12:30.273278Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-10-27T22:12:30.273316Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-10-27T22:12:30.273325Z 0 [Note] InnoDB: Uses event mutexes
2020-10-27T22:12:30.273333Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-10-27T22:12:30.273341Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-10-27T22:12:30.273349Z 0 [Note] InnoDB: Using Linux native AIO
2020-10-27T22:12:30.274134Z 0 [Note] InnoDB: Number of pools: 1
2020-10-27T22:12:30.274280Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-10-27T22:12:30.277051Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-10-27T22:12:30.288774Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-10-27T22:12:30.292365Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-10-27T22:12:30.304552Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-10-27T22:12:30.324336Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-10-27T22:12:30.324446Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-10-27T22:12:30.348980Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-10-27T22:12:30.350087Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-10-27T22:12:30.350106Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-10-27T22:12:30.350890Z 0 [Note] InnoDB: Waiting for purge to start
2020-10-27T22:12:30.401099Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 2747117
2020-10-27T22:12:30.401435Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-10-27T22:12:30.401693Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-10-27T22:12:30.403509Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201027 22:12:30
2020-10-27T22:12:30.409550Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2020-10-27T22:12:30.409575Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2020-10-27T22:12:30.410402Z 0 [Warning] CA certificate ca.pem is self signed.
2020-10-27T22:12:30.410454Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2020-10-27T22:12:30.410567Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
2020-10-27T22:12:30.410586Z 0 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
2020-10-27T22:12:30.410640Z 0 [Note] Server socket created on IP: '0.0.0.0'.
2020-10-27T22:12:30.422723Z 0 [Note] Event Scheduler: Loaded 0 events
2020-10-27T22:12:30.423038Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.32-0ubuntu0.18.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
2020-10-27T22:12:52.711021Z 4 [Note] Aborted connection 4 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-27T22:13:06.359762Z 5 [Note] Aborted connection 5 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-27T22:20:07.100456Z 10 [Note] Aborted connection 10 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-27T22:20:07.100640Z 11 [Note] Aborted connection 11 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-27T22:20:11.500518Z 12 [Note] Aborted connection 12 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-27T22:21:49.781932Z 6 [Note] Aborted connection 6 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-27T22:21:49.792399Z 7 [Note] Aborted connection 7 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-27T22:26:35.889657Z 20 [Warning] Following users were specified in CREATE USER IF NOT EXISTS but they already exist. Corresponding entry in binary log used default authentication plugin 'mysql_native_password' to rewrite authentication information(if any) for them: 'root'@'%'

2020-10-27T22:26:36.142471Z 0 [Note] Giving 0 client threads a chance to die gracefully
2020-10-27T22:26:36.142506Z 0 [Note] Shutting down slave threads
2020-10-27T22:26:36.142517Z 0 [Note] Forcefully disconnecting 0 remaining clients
2020-10-27T22:26:36.142527Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2020-10-27T22:26:36.142603Z 0 [Note] Binlog end
2020-10-27T22:26:36.144385Z 0 [Note] Shutting down plugin 'ngram'
2020-10-27T22:26:36.144403Z 0 [Note] Shutting down plugin 'partition'
2020-10-27T22:26:36.144410Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2020-10-27T22:26:36.144417Z 0 [Note] Shutting down plugin 'ARCHIVE'
2020-10-27T22:26:36.144422Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2020-10-27T22:26:36.144458Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2020-10-27T22:26:36.144465Z 0 [Note] Shutting down plugin 'MyISAM'
2020-10-27T22:26:36.144474Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2020-10-27T22:26:36.144481Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2020-10-27T22:26:36.144486Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2020-10-27T22:26:36.144491Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2020-10-27T22:26:36.144496Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2020-10-27T22:26:36.144502Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2020-10-27T22:26:36.144507Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2020-10-27T22:26:36.144512Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2020-10-27T22:26:36.144517Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2020-10-27T22:26:36.144522Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2020-10-27T22:26:36.144527Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2020-10-27T22:26:36.144532Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2020-10-27T22:26:36.144537Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2020-10-27T22:26:36.144542Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2020-10-27T22:26:36.144547Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2020-10-27T22:26:36.144553Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2020-10-27T22:26:36.144558Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2020-10-27T22:26:36.144563Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2020-10-27T22:26:36.144568Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2020-10-27T22:26:36.144573Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2020-10-27T22:26:36.144578Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2020-10-27T22:26:36.144583Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2020-10-27T22:26:36.144588Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2020-10-27T22:26:36.144593Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2020-10-27T22:26:36.144598Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2020-10-27T22:26:36.144603Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2020-10-27T22:26:36.144609Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2020-10-27T22:26:36.144614Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2020-10-27T22:26:36.144619Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2020-10-27T22:26:36.144624Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2020-10-27T22:26:36.144629Z 0 [Note] Shutting down plugin 'InnoDB'
2020-10-27T22:26:36.144706Z 0 [Note] InnoDB: FTS optimize thread exiting.
2020-10-27T22:26:36.144861Z 0 [Note] InnoDB: Starting shutdown...
2020-10-27T22:26:36.245082Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2020-10-27T22:26:36.245667Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 201027 22:26:36
2020-10-27T22:26:37.160448Z 0 [Note] InnoDB: Shutdown completed; log sequence number 11955790
2020-10-27T22:26:37.163276Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-10-27T22:26:37.163313Z 0 [Note] Shutting down plugin 'MEMORY'
2020-10-27T22:26:37.163323Z 0 [Note] Shutting down plugin 'CSV'
2020-10-27T22:26:37.163331Z 0 [Note] Shutting down plugin 'sha256_password'
2020-10-27T22:26:37.163337Z 0 [Note] Shutting down plugin 'mysql_native_password'
2020-10-27T22:26:37.163514Z 0 [Note] Shutting down plugin 'binlog'
2020-10-27T22:26:37.164148Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2020-10-27T22:26:37.274574Z 0 [Warning] Changed limits: max_open_files: 5000 (requested 5120)
2020-10-27T22:26:37.274859Z 0 [Warning] Changed limits: table_open_cache: 1983 (requested 2000)
2020-10-27T22:26:37.485466Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-10-27T22:26:37.487599Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.32-0ubuntu0.18.04.1) starting as process 105718 ...
2020-10-27T22:26:37.493664Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-10-27T22:26:37.493696Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-10-27T22:26:37.493705Z 0 [Note] InnoDB: Uses event mutexes
2020-10-27T22:26:37.493712Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-10-27T22:26:37.493719Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-10-27T22:26:37.493727Z 0 [Note] InnoDB: Using Linux native AIO
2020-10-27T22:26:37.494546Z 0 [Note] InnoDB: Number of pools: 1
2020-10-27T22:26:37.494696Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-10-27T22:26:37.497429Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-10-27T22:26:37.510114Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-10-27T22:26:37.513026Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-10-27T22:26:37.525143Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-10-27T22:26:37.557561Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-10-27T22:26:37.557675Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-10-27T22:26:37.581618Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-10-27T22:26:37.582735Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-10-27T22:26:37.582755Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-10-27T22:26:37.583692Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 11955790
2020-10-27T22:26:37.584571Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-10-27T22:26:37.584966Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-10-27T22:26:37.626991Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2020-10-27T22:26:37.627021Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2020-10-27T22:26:37.627847Z 0 [Warning] CA certificate ca.pem is self signed.
2020-10-27T22:26:37.627897Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2020-10-27T22:26:37.628009Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
2020-10-27T22:26:37.628028Z 0 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
2020-10-27T22:26:37.628080Z 0 [Note] Server socket created on IP: '0.0.0.0'.
2020-10-27T22:26:37.629743Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201027 22:26:37
2020-10-27T22:26:37.641224Z 0 [Note] Event Scheduler: Loaded 0 events
2020-10-27T22:26:37.641548Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.32-0ubuntu0.18.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
2020-10-27T22:27:01.128392Z 4 [Note] Aborted connection 4 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-27T22:27:14.922507Z 5 [Note] Aborted connection 5 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-27T22:34:20.818186Z 10 [Note] Aborted connection 10 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-27T22:34:20.818397Z 11 [Note] Aborted connection 11 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-27T22:34:25.211552Z 12 [Note] Aborted connection 12 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-27T22:36:08.571736Z 7 [Note] Aborted connection 7 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-27T22:36:08.572673Z 6 [Note] Aborted connection 6 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-27T22:40:48.121115Z 20 [Warning] Following users were specified in CREATE USER IF NOT EXISTS but they already exist. Corresponding entry in binary log used default authentication plugin 'mysql_native_password' to rewrite authentication information(if any) for them: 'root'@'%'

2020-10-27T22:40:48.375144Z 0 [Note] Giving 0 client threads a chance to die gracefully
2020-10-27T22:40:48.375187Z 0 [Note] Shutting down slave threads
2020-10-27T22:40:48.375200Z 0 [Note] Forcefully disconnecting 0 remaining clients
2020-10-27T22:40:48.375214Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2020-10-27T22:40:48.375313Z 0 [Note] Binlog end
2020-10-27T22:40:48.377171Z 0 [Note] Shutting down plugin 'ngram'
2020-10-27T22:40:48.377190Z 0 [Note] Shutting down plugin 'partition'
2020-10-27T22:40:48.377198Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2020-10-27T22:40:48.377205Z 0 [Note] Shutting down plugin 'ARCHIVE'
2020-10-27T22:40:48.377211Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2020-10-27T22:40:48.377249Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2020-10-27T22:40:48.377256Z 0 [Note] Shutting down plugin 'MyISAM'
2020-10-27T22:40:48.377266Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2020-10-27T22:40:48.377273Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2020-10-27T22:40:48.377278Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2020-10-27T22:40:48.377284Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2020-10-27T22:40:48.377290Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2020-10-27T22:40:48.377295Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2020-10-27T22:40:48.377301Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2020-10-27T22:40:48.377307Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2020-10-27T22:40:48.377312Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2020-10-27T22:40:48.377318Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2020-10-27T22:40:48.377324Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2020-10-27T22:40:48.377329Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2020-10-27T22:40:48.377335Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2020-10-27T22:40:48.377340Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2020-10-27T22:40:48.377346Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2020-10-27T22:40:48.377352Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2020-10-27T22:40:48.377357Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2020-10-27T22:40:48.377363Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2020-10-27T22:40:48.377368Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2020-10-27T22:40:48.377374Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2020-10-27T22:40:48.377379Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2020-10-27T22:40:48.377385Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2020-10-27T22:40:48.377390Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2020-10-27T22:40:48.377396Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2020-10-27T22:40:48.377401Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2020-10-27T22:40:48.377407Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2020-10-27T22:40:48.377413Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2020-10-27T22:40:48.377433Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2020-10-27T22:40:48.377439Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2020-10-27T22:40:48.377445Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2020-10-27T22:40:48.377450Z 0 [Note] Shutting down plugin 'InnoDB'
2020-10-27T22:40:48.377546Z 0 [Note] InnoDB: FTS optimize thread exiting.
2020-10-27T22:40:48.377699Z 0 [Note] InnoDB: Starting shutdown...
2020-10-27T22:40:48.477942Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2020-10-27T22:40:48.478578Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 201027 22:40:48
2020-10-27T22:40:49.396453Z 0 [Note] InnoDB: Shutdown completed; log sequence number 22973425
2020-10-27T22:40:49.398784Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-10-27T22:40:49.398807Z 0 [Note] Shutting down plugin 'MEMORY'
2020-10-27T22:40:49.398817Z 0 [Note] Shutting down plugin 'CSV'
2020-10-27T22:40:49.398825Z 0 [Note] Shutting down plugin 'sha256_password'
2020-10-27T22:40:49.398831Z 0 [Note] Shutting down plugin 'mysql_native_password'
2020-10-27T22:40:49.399008Z 0 [Note] Shutting down plugin 'binlog'
2020-10-27T22:40:49.399667Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2020-10-27T22:40:49.515860Z 0 [Warning] Changed limits: max_open_files: 5000 (requested 5120)
2020-10-27T22:40:49.516144Z 0 [Warning] Changed limits: table_open_cache: 1983 (requested 2000)
2020-10-27T22:40:49.725701Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-10-27T22:40:49.727829Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.32-0ubuntu0.18.04.1) starting as process 17456 ...
2020-10-27T22:40:49.733917Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-10-27T22:40:49.733952Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-10-27T22:40:49.733961Z 0 [Note] InnoDB: Uses event mutexes
2020-10-27T22:40:49.733968Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-10-27T22:40:49.733975Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-10-27T22:40:49.733983Z 0 [Note] InnoDB: Using Linux native AIO
2020-10-27T22:40:49.734808Z 0 [Note] InnoDB: Number of pools: 1
2020-10-27T22:40:49.734956Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-10-27T22:40:49.737796Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-10-27T22:40:49.749357Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-10-27T22:40:49.752750Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-10-27T22:40:49.764895Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-10-27T22:40:49.797106Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-10-27T22:40:49.797214Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-10-27T22:40:49.821693Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-10-27T22:40:49.822874Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-10-27T22:40:49.822895Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-10-27T22:40:49.823782Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 22973425
2020-10-27T22:40:49.824016Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-10-27T22:40:49.824335Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-10-27T22:40:49.863018Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2020-10-27T22:40:49.863048Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2020-10-27T22:40:49.863886Z 0 [Warning] CA certificate ca.pem is self signed.
2020-10-27T22:40:49.863935Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2020-10-27T22:40:49.864063Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
2020-10-27T22:40:49.864088Z 0 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
2020-10-27T22:40:49.864127Z 0 [Note] Server socket created on IP: '0.0.0.0'.
2020-10-27T22:40:49.908087Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201027 22:40:49
2020-10-27T22:40:49.912032Z 0 [Note] Event Scheduler: Loaded 0 events
2020-10-27T22:40:49.912383Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.32-0ubuntu0.18.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
2020-10-27T22:41:12.827169Z 4 [Note] Aborted connection 4 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-27T22:41:26.486508Z 5 [Note] Aborted connection 5 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-27T22:48:33.880714Z 10 [Note] Aborted connection 10 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-27T22:48:33.880923Z 11 [Note] Aborted connection 11 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-27T22:48:38.266826Z 12 [Note] Aborted connection 12 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-27T22:50:21.474061Z 7 [Note] Aborted connection 7 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-27T22:50:21.474110Z 6 [Note] Aborted connection 6 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-27T22:55:07.212455Z 20 [Warning] Following users were specified in CREATE USER IF NOT EXISTS but they already exist. Corresponding entry in binary log used default authentication plugin 'mysql_native_password' to rewrite authentication information(if any) for them: 'root'@'%'

2020-10-27T22:55:07.497723Z 0 [Note] Giving 0 client threads a chance to die gracefully
2020-10-27T22:55:07.497774Z 0 [Note] Shutting down slave threads
2020-10-27T22:55:07.497792Z 0 [Note] Forcefully disconnecting 0 remaining clients
2020-10-27T22:55:07.497807Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2020-10-27T22:55:07.497918Z 0 [Note] Binlog end
2020-10-27T22:55:07.499930Z 0 [Note] Shutting down plugin 'ngram'
2020-10-27T22:55:07.499950Z 0 [Note] Shutting down plugin 'partition'
2020-10-27T22:55:07.499957Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2020-10-27T22:55:07.499965Z 0 [Note] Shutting down plugin 'ARCHIVE'
2020-10-27T22:55:07.499971Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2020-10-27T22:55:07.500009Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2020-10-27T22:55:07.500016Z 0 [Note] Shutting down plugin 'MyISAM'
2020-10-27T22:55:07.500026Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2020-10-27T22:55:07.500033Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2020-10-27T22:55:07.500039Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2020-10-27T22:55:07.500044Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2020-10-27T22:55:07.500050Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2020-10-27T22:55:07.500056Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2020-10-27T22:55:07.500061Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2020-10-27T22:55:07.500067Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2020-10-27T22:55:07.500073Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2020-10-27T22:55:07.500078Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2020-10-27T22:55:07.500084Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2020-10-27T22:55:07.500089Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2020-10-27T22:55:07.500094Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2020-10-27T22:55:07.500100Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2020-10-27T22:55:07.500105Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2020-10-27T22:55:07.500111Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2020-10-27T22:55:07.500117Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2020-10-27T22:55:07.500136Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2020-10-27T22:55:07.500142Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2020-10-27T22:55:07.500148Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2020-10-27T22:55:07.500153Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2020-10-27T22:55:07.500158Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2020-10-27T22:55:07.500163Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2020-10-27T22:55:07.500168Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2020-10-27T22:55:07.500173Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2020-10-27T22:55:07.500178Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2020-10-27T22:55:07.500183Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2020-10-27T22:55:07.500188Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2020-10-27T22:55:07.500193Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2020-10-27T22:55:07.500198Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2020-10-27T22:55:07.500203Z 0 [Note] Shutting down plugin 'InnoDB'
2020-10-27T22:55:07.500329Z 0 [Note] InnoDB: FTS optimize thread exiting.
2020-10-27T22:55:07.500501Z 0 [Note] InnoDB: Starting shutdown...
2020-10-27T22:55:07.600989Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2020-10-27T22:55:07.601695Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 201027 22:55:07
2020-10-27T22:55:08.620814Z 0 [Note] InnoDB: Shutdown completed; log sequence number 33982752
2020-10-27T22:55:08.623472Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-10-27T22:55:08.623498Z 0 [Note] Shutting down plugin 'MEMORY'
2020-10-27T22:55:08.623508Z 0 [Note] Shutting down plugin 'CSV'
2020-10-27T22:55:08.623516Z 0 [Note] Shutting down plugin 'sha256_password'
2020-10-27T22:55:08.623522Z 0 [Note] Shutting down plugin 'mysql_native_password'
2020-10-27T22:55:08.623700Z 0 [Note] Shutting down plugin 'binlog'
2020-10-27T22:55:08.624405Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2020-10-27T22:55:08.743850Z 0 [Warning] Changed limits: max_open_files: 5000 (requested 5120)
2020-10-27T22:55:08.744145Z 0 [Warning] Changed limits: table_open_cache: 1983 (requested 2000)
2020-10-27T22:55:08.956629Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-10-27T22:55:08.958796Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.32-0ubuntu0.18.04.1) starting as process 60030 ...
2020-10-27T22:55:08.965285Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-10-27T22:55:08.965321Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-10-27T22:55:08.965330Z 0 [Note] InnoDB: Uses event mutexes
2020-10-27T22:55:08.965338Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-10-27T22:55:08.965345Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-10-27T22:55:08.965353Z 0 [Note] InnoDB: Using Linux native AIO
2020-10-27T22:55:08.966154Z 0 [Note] InnoDB: Number of pools: 1
2020-10-27T22:55:08.966304Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-10-27T22:55:08.969227Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-10-27T22:55:08.982701Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-10-27T22:55:08.985527Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-10-27T22:55:08.997664Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-10-27T22:55:09.030495Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-10-27T22:55:09.030614Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-10-27T22:55:09.055994Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-10-27T22:55:09.057118Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-10-27T22:55:09.057152Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-10-27T22:55:09.058171Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 33982752
2020-10-27T22:55:09.058429Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-10-27T22:55:09.058894Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-10-27T22:55:09.083076Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2020-10-27T22:55:09.083107Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2020-10-27T22:55:09.084228Z 0 [Warning] CA certificate ca.pem is self signed.
2020-10-27T22:55:09.084302Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2020-10-27T22:55:09.085046Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
2020-10-27T22:55:09.085089Z 0 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
2020-10-27T22:55:09.085166Z 0 [Note] Server socket created on IP: '0.0.0.0'.
2020-10-27T22:55:09.118644Z 0 [Note] Event Scheduler: Loaded 0 events
2020-10-27T22:55:09.119264Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.32-0ubuntu0.18.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
2020-10-27T22:55:09.123322Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201027 22:55:09
2020-10-27T22:55:32.114099Z 4 [Note] Aborted connection 4 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-27T22:55:46.098842Z 5 [Note] Aborted connection 5 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-27T23:02:56.814997Z 10 [Note] Aborted connection 10 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-27T23:02:56.815253Z 11 [Note] Aborted connection 11 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-27T23:03:01.215127Z 12 [Note] Aborted connection 12 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-27T23:04:51.644372Z 7 [Note] Aborted connection 7 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)
2020-10-27T23:04:51.648477Z 6 [Note] Aborted connection 6 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)