2020-10-28T16:03:27.299326Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2020-10-28T16:03:27.508531Z 0 [Warning] InnoDB: New log files created, LSN=45790 2020-10-28T16:03:27.553967Z 0 [Warning] InnoDB: Creating foreign key constraint system tables. 2020-10-28T16:03:27.568467Z 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: 1d9d6ec2-1937-11eb-852d-fa163e9ead81. 2020-10-28T16:03:27.569880Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2020-10-28T16:03:28.240374Z 0 [Warning] CA certificate ca.pem is self signed. 2020-10-28T16:03:28.348091Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option. 2020-10-28T16:03:34.761485Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2020-10-28T16:03:34.763694Z 0 [Note] mysqld (mysqld 5.7.32-0ubuntu0.18.04.1) starting as process 41466 ... 2020-10-28T16:03:34.770379Z 0 [Note] InnoDB: PUNCH HOLE support available 2020-10-28T16:03:34.770415Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2020-10-28T16:03:34.770424Z 0 [Note] InnoDB: Uses event mutexes 2020-10-28T16:03:34.770432Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2020-10-28T16:03:34.770439Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2020-10-28T16:03:34.770447Z 0 [Note] InnoDB: Using Linux native AIO 2020-10-28T16:03:34.770779Z 0 [Note] InnoDB: Number of pools: 1 2020-10-28T16:03:34.770960Z 0 [Note] InnoDB: Using CPU crc32 instructions 2020-10-28T16:03:34.773625Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2020-10-28T16:03:34.787090Z 0 [Note] InnoDB: Completed initialization of buffer pool 2020-10-28T16:03:34.790087Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2020-10-28T16:03:34.802423Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2020-10-28T16:03:34.813388Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2020-10-28T16:03:34.813476Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2020-10-28T16:03:34.839610Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2020-10-28T16:03:34.840781Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2020-10-28T16:03:34.840801Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2020-10-28T16:03:34.841719Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 2747070 2020-10-28T16:03:34.841980Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2020-10-28T16:03:34.842294Z 0 [Note] Plugin 'FEDERATED' is disabled. 2020-10-28T16:03:34.844802Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201028 16:03:34 2020-10-28T16:03:34.851333Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2020-10-28T16:03:34.851356Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2020-10-28T16:03:34.852165Z 0 [Warning] CA certificate ca.pem is self signed. 2020-10-28T16:03:34.852207Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2020-10-28T16:03:34.854199Z 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-28T16:03:34.867765Z 0 [Note] Event Scheduler: Loaded 0 events 2020-10-28T16:03:34.868075Z 0 [Note] mysqld: ready for connections. Version: '5.7.32-0ubuntu0.18.04.1' socket: '/tmp/tmp.57P21XSxCi/mysqld.sock' port: 0 (Ubuntu) 2020-10-28T16:03:34.877114Z 2 [Note] Access denied for user 'root'@'localhost' (using password: NO) 2020-10-28T16:03:34.879699Z 0 [Note] Giving 0 client threads a chance to die gracefully 2020-10-28T16:03:34.879729Z 0 [Note] Shutting down slave threads 2020-10-28T16:03:34.879745Z 0 [Note] Forcefully disconnecting 0 remaining clients 2020-10-28T16:03:34.879758Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2020-10-28T16:03:34.879850Z 0 [Note] Binlog end 2020-10-28T16:03:34.880464Z 0 [Note] Shutting down plugin 'ngram' 2020-10-28T16:03:34.880482Z 0 [Note] Shutting down plugin 'partition' 2020-10-28T16:03:34.880489Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2020-10-28T16:03:34.880496Z 0 [Note] Shutting down plugin 'ARCHIVE' 2020-10-28T16:03:34.880502Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2020-10-28T16:03:34.880536Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2020-10-28T16:03:34.880542Z 0 [Note] Shutting down plugin 'MyISAM' 2020-10-28T16:03:34.880551Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2020-10-28T16:03:34.880557Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2020-10-28T16:03:34.880562Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2020-10-28T16:03:34.880567Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2020-10-28T16:03:34.880572Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2020-10-28T16:03:34.880577Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2020-10-28T16:03:34.880582Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2020-10-28T16:03:34.880587Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2020-10-28T16:03:34.880592Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2020-10-28T16:03:34.880597Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2020-10-28T16:03:34.880602Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2020-10-28T16:03:34.880607Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2020-10-28T16:03:34.880612Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2020-10-28T16:03:34.880617Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2020-10-28T16:03:34.880622Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2020-10-28T16:03:34.880627Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2020-10-28T16:03:34.880632Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2020-10-28T16:03:34.880636Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2020-10-28T16:03:34.880641Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2020-10-28T16:03:34.880646Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2020-10-28T16:03:34.880651Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2020-10-28T16:03:34.880656Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2020-10-28T16:03:34.880661Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2020-10-28T16:03:34.880666Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2020-10-28T16:03:34.880671Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2020-10-28T16:03:34.880676Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2020-10-28T16:03:34.880680Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2020-10-28T16:03:34.880685Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2020-10-28T16:03:34.880690Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2020-10-28T16:03:34.880695Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2020-10-28T16:03:34.880700Z 0 [Note] Shutting down plugin 'InnoDB' 2020-10-28T16:03:34.880776Z 0 [Note] InnoDB: FTS optimize thread exiting. 2020-10-28T16:03:34.880967Z 0 [Note] InnoDB: Starting shutdown... 2020-10-28T16:03:34.981200Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2020-10-28T16:03:34.981551Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 201028 16:03:34 2020-10-28T16:03:36.489183Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2747089 2020-10-28T16:03:36.491387Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2020-10-28T16:03:36.491408Z 0 [Note] Shutting down plugin 'MEMORY' 2020-10-28T16:03:36.491417Z 0 [Note] Shutting down plugin 'CSV' 2020-10-28T16:03:36.491425Z 0 [Note] Shutting down plugin 'sha256_password' 2020-10-28T16:03:36.491443Z 0 [Note] Shutting down plugin 'mysql_native_password' 2020-10-28T16:03:36.491614Z 0 [Note] Shutting down plugin 'binlog' 2020-10-28T16:03:36.492044Z 0 [Note] mysqld: Shutdown complete 2020-10-28T16:03:38.582106Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2020-10-28T16:03:38.584381Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.32-0ubuntu0.18.04.1) starting as process 41607 ... 2020-10-28T16:03:38.590472Z 0 [Note] InnoDB: PUNCH HOLE support available 2020-10-28T16:03:38.590508Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2020-10-28T16:03:38.590517Z 0 [Note] InnoDB: Uses event mutexes 2020-10-28T16:03:38.590525Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2020-10-28T16:03:38.590532Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2020-10-28T16:03:38.590540Z 0 [Note] InnoDB: Using Linux native AIO 2020-10-28T16:03:38.590870Z 0 [Note] InnoDB: Number of pools: 1 2020-10-28T16:03:38.591015Z 0 [Note] InnoDB: Using CPU crc32 instructions 2020-10-28T16:03:38.594477Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2020-10-28T16:03:38.606682Z 0 [Note] InnoDB: Completed initialization of buffer pool 2020-10-28T16:03:38.610213Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2020-10-28T16:03:38.622471Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2020-10-28T16:03:38.642463Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2020-10-28T16:03:38.642572Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2020-10-28T16:03:38.668671Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2020-10-28T16:03:38.669978Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2020-10-28T16:03:38.669999Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2020-10-28T16:03:38.671027Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 2747089 2020-10-28T16:03:38.671898Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2020-10-28T16:03:38.672228Z 0 [Note] Plugin 'FEDERATED' is disabled. 2020-10-28T16:03:38.674514Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201028 16:03:38 2020-10-28T16:03:38.680642Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2020-10-28T16:03:38.680671Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2020-10-28T16:03:38.681561Z 0 [Warning] CA certificate ca.pem is self signed. 2020-10-28T16:03:38.681608Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2020-10-28T16:03:38.681720Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 2020-10-28T16:03:38.681739Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 2020-10-28T16:03:38.681777Z 0 [Note] Server socket created on IP: '127.0.0.1'. 2020-10-28T16:03:38.694130Z 0 [Note] Event Scheduler: Loaded 0 events 2020-10-28T16:03:38.694472Z 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.7.32-0ubuntu0.18.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu) 2020-10-28T16:10:26.014673Z 0 [Note] Giving 0 client threads a chance to die gracefully 2020-10-28T16:10:26.014712Z 0 [Note] Shutting down slave threads 2020-10-28T16:10:26.014725Z 0 [Note] Forcefully disconnecting 0 remaining clients 2020-10-28T16:10:26.014736Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2020-10-28T16:10:26.014817Z 0 [Note] Binlog end 2020-10-28T16:10:26.015443Z 0 [Note] Shutting down plugin 'ngram' 2020-10-28T16:10:26.015457Z 0 [Note] Shutting down plugin 'partition' 2020-10-28T16:10:26.015464Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2020-10-28T16:10:26.015472Z 0 [Note] Shutting down plugin 'ARCHIVE' 2020-10-28T16:10:26.015491Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2020-10-28T16:10:26.015529Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2020-10-28T16:10:26.015536Z 0 [Note] Shutting down plugin 'MyISAM' 2020-10-28T16:10:26.015545Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2020-10-28T16:10:26.015552Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2020-10-28T16:10:26.015557Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2020-10-28T16:10:26.015562Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2020-10-28T16:10:26.015568Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2020-10-28T16:10:26.015573Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2020-10-28T16:10:26.015578Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2020-10-28T16:10:26.015583Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2020-10-28T16:10:26.015588Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2020-10-28T16:10:26.015593Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2020-10-28T16:10:26.015598Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2020-10-28T16:10:26.015603Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2020-10-28T16:10:26.015609Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2020-10-28T16:10:26.015614Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2020-10-28T16:10:26.015619Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2020-10-28T16:10:26.015624Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2020-10-28T16:10:26.015629Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2020-10-28T16:10:26.015634Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2020-10-28T16:10:26.015639Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2020-10-28T16:10:26.015645Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2020-10-28T16:10:26.015650Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2020-10-28T16:10:26.015655Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2020-10-28T16:10:26.015660Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2020-10-28T16:10:26.015665Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2020-10-28T16:10:26.015670Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2020-10-28T16:10:26.015675Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2020-10-28T16:10:26.015681Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2020-10-28T16:10:26.015686Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2020-10-28T16:10:26.015691Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2020-10-28T16:10:26.015696Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2020-10-28T16:10:26.015701Z 0 [Note] Shutting down plugin 'InnoDB' 2020-10-28T16:10:26.015781Z 0 [Note] InnoDB: FTS optimize thread exiting. 2020-10-28T16:10:26.015918Z 0 [Note] InnoDB: Starting shutdown... 2020-10-28T16:10:26.116171Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2020-10-28T16:10:26.116620Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 201028 16:10:26 2020-10-28T16:10:27.628976Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2747117 2020-10-28T16:10:27.631264Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2020-10-28T16:10:27.631286Z 0 [Note] Shutting down plugin 'MEMORY' 2020-10-28T16:10:27.631296Z 0 [Note] Shutting down plugin 'CSV' 2020-10-28T16:10:27.631304Z 0 [Note] Shutting down plugin 'sha256_password' 2020-10-28T16:10:27.631310Z 0 [Note] Shutting down plugin 'mysql_native_password' 2020-10-28T16:10:27.631484Z 0 [Note] Shutting down plugin 'binlog' 2020-10-28T16:10:27.631916Z 0 [Note] /usr/sbin/mysqld: Shutdown complete 2020-10-28T16:10:27.741835Z 0 [Warning] Changed limits: max_open_files: 5000 (requested 5120) 2020-10-28T16:10:27.742148Z 0 [Warning] Changed limits: table_open_cache: 1983 (requested 2000) 2020-10-28T16:10:27.949741Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2020-10-28T16:10:27.951885Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.32-0ubuntu0.18.04.1) starting as process 63119 ... 2020-10-28T16:10:27.958585Z 0 [Note] InnoDB: PUNCH HOLE support available 2020-10-28T16:10:27.958629Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2020-10-28T16:10:27.958638Z 0 [Note] InnoDB: Uses event mutexes 2020-10-28T16:10:27.958645Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2020-10-28T16:10:27.958653Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2020-10-28T16:10:27.958660Z 0 [Note] InnoDB: Using Linux native AIO 2020-10-28T16:10:27.959448Z 0 [Note] InnoDB: Number of pools: 1 2020-10-28T16:10:27.959594Z 0 [Note] InnoDB: Using CPU crc32 instructions 2020-10-28T16:10:27.962335Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2020-10-28T16:10:27.974953Z 0 [Note] InnoDB: Completed initialization of buffer pool 2020-10-28T16:10:27.977798Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2020-10-28T16:10:27.990060Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2020-10-28T16:10:28.009344Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2020-10-28T16:10:28.009441Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2020-10-28T16:10:28.034791Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2020-10-28T16:10:28.035896Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2020-10-28T16:10:28.035914Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2020-10-28T16:10:28.036480Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 2747117 2020-10-28T16:10:28.037030Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2020-10-28T16:10:28.037372Z 0 [Note] Plugin 'FEDERATED' is disabled. 2020-10-28T16:10:28.040244Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201028 16:10:28 2020-10-28T16:10:28.045261Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2020-10-28T16:10:28.045284Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2020-10-28T16:10:28.046115Z 0 [Warning] CA certificate ca.pem is self signed. 2020-10-28T16:10:28.046165Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2020-10-28T16:10:28.046276Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 2020-10-28T16:10:28.046300Z 0 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 2020-10-28T16:10:28.046336Z 0 [Note] Server socket created on IP: '0.0.0.0'. 2020-10-28T16:10:28.057890Z 0 [Note] Event Scheduler: Loaded 0 events 2020-10-28T16:10:28.058200Z 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.7.32-0ubuntu0.18.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu) 2020-10-28T16:10:51.693389Z 4 [Note] Aborted connection 4 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets) 2020-10-28T16:11:06.321072Z 5 [Note] Aborted connection 5 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets) 2020-10-28T16:18:35.289190Z 10 [Note] Aborted connection 10 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets) 2020-10-28T16:18:35.289435Z 11 [Note] Aborted connection 11 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets) 2020-10-28T16:18:39.794587Z 12 [Note] Aborted connection 12 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets) 2020-10-28T16:20:21.772989Z 7 [Note] Aborted connection 7 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets) 2020-10-28T16:20:21.886677Z 6 [Note] Aborted connection 6 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets) 2020-10-28T16:25:17.731874Z 20 [Warning] Following users were specified in CREATE USER IF NOT EXISTS but they already exist. Corresponding entry in binary log used default authentication plugin 'mysql_native_password' to rewrite authentication information(if any) for them: 'root'@'%' 2020-10-28T16:25:18.008869Z 0 [Note] Giving 0 client threads a chance to die gracefully 2020-10-28T16:25:18.008917Z 0 [Note] Shutting down slave threads 2020-10-28T16:25:18.008936Z 0 [Note] Forcefully disconnecting 0 remaining clients 2020-10-28T16:25:18.008949Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2020-10-28T16:25:18.009054Z 0 [Note] Binlog end 2020-10-28T16:25:18.011569Z 0 [Note] Shutting down plugin 'ngram' 2020-10-28T16:25:18.011588Z 0 [Note] Shutting down plugin 'partition' 2020-10-28T16:25:18.011595Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2020-10-28T16:25:18.011602Z 0 [Note] Shutting down plugin 'ARCHIVE' 2020-10-28T16:25:18.011607Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2020-10-28T16:25:18.011645Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2020-10-28T16:25:18.011652Z 0 [Note] Shutting down plugin 'MyISAM' 2020-10-28T16:25:18.011661Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2020-10-28T16:25:18.011668Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2020-10-28T16:25:18.011673Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2020-10-28T16:25:18.011678Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2020-10-28T16:25:18.011684Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2020-10-28T16:25:18.011689Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2020-10-28T16:25:18.011694Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2020-10-28T16:25:18.011699Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2020-10-28T16:25:18.011704Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2020-10-28T16:25:18.011709Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2020-10-28T16:25:18.011714Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2020-10-28T16:25:18.011719Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2020-10-28T16:25:18.011725Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2020-10-28T16:25:18.011730Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2020-10-28T16:25:18.011735Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2020-10-28T16:25:18.011740Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2020-10-28T16:25:18.011745Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2020-10-28T16:25:18.011750Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2020-10-28T16:25:18.011755Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2020-10-28T16:25:18.011760Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2020-10-28T16:25:18.011765Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2020-10-28T16:25:18.011770Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2020-10-28T16:25:18.011775Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2020-10-28T16:25:18.011780Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2020-10-28T16:25:18.011785Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2020-10-28T16:25:18.011790Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2020-10-28T16:25:18.011795Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2020-10-28T16:25:18.011801Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2020-10-28T16:25:18.011806Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2020-10-28T16:25:18.011811Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2020-10-28T16:25:18.011816Z 0 [Note] Shutting down plugin 'InnoDB' 2020-10-28T16:25:18.011980Z 0 [Note] InnoDB: FTS optimize thread exiting. 2020-10-28T16:25:18.012150Z 0 [Note] InnoDB: Starting shutdown... 2020-10-28T16:25:18.112370Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2020-10-28T16:25:18.112954Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 201028 16:25:18 2020-10-28T16:25:19.828994Z 0 [Note] InnoDB: Shutdown completed; log sequence number 11953918 2020-10-28T16:25:19.831395Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2020-10-28T16:25:19.831417Z 0 [Note] Shutting down plugin 'MEMORY' 2020-10-28T16:25:19.831439Z 0 [Note] Shutting down plugin 'CSV' 2020-10-28T16:25:19.831448Z 0 [Note] Shutting down plugin 'sha256_password' 2020-10-28T16:25:19.831454Z 0 [Note] Shutting down plugin 'mysql_native_password' 2020-10-28T16:25:19.831630Z 0 [Note] Shutting down plugin 'binlog' 2020-10-28T16:25:19.832327Z 0 [Note] /usr/sbin/mysqld: Shutdown complete 2020-10-28T16:25:19.951294Z 0 [Warning] Changed limits: max_open_files: 5000 (requested 5120) 2020-10-28T16:25:19.951569Z 0 [Warning] Changed limits: table_open_cache: 1983 (requested 2000) 2020-10-28T16:25:20.161493Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2020-10-28T16:25:20.163655Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.32-0ubuntu0.18.04.1) starting as process 105628 ... 2020-10-28T16:25:20.169861Z 0 [Note] InnoDB: PUNCH HOLE support available 2020-10-28T16:25:20.169894Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2020-10-28T16:25:20.169904Z 0 [Note] InnoDB: Uses event mutexes 2020-10-28T16:25:20.169912Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2020-10-28T16:25:20.169919Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2020-10-28T16:25:20.169927Z 0 [Note] InnoDB: Using Linux native AIO 2020-10-28T16:25:20.170728Z 0 [Note] InnoDB: Number of pools: 1 2020-10-28T16:25:20.170875Z 0 [Note] InnoDB: Using CPU crc32 instructions 2020-10-28T16:25:20.173653Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2020-10-28T16:25:20.187499Z 0 [Note] InnoDB: Completed initialization of buffer pool 2020-10-28T16:25:20.190387Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2020-10-28T16:25:20.202590Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2020-10-28T16:25:20.235323Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2020-10-28T16:25:20.235425Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2020-10-28T16:25:20.253676Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2020-10-28T16:25:20.254816Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2020-10-28T16:25:20.254834Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2020-10-28T16:25:20.255730Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 11953918 2020-10-28T16:25:20.256000Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2020-10-28T16:25:20.256436Z 0 [Note] Plugin 'FEDERATED' is disabled. 2020-10-28T16:25:20.288958Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2020-10-28T16:25:20.288989Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2020-10-28T16:25:20.289817Z 0 [Warning] CA certificate ca.pem is self signed. 2020-10-28T16:25:20.289865Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2020-10-28T16:25:20.289974Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 2020-10-28T16:25:20.289992Z 0 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 2020-10-28T16:25:20.290031Z 0 [Note] Server socket created on IP: '0.0.0.0'. 2020-10-28T16:25:20.292030Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201028 16:25:20 2020-10-28T16:25:20.303186Z 0 [Note] Event Scheduler: Loaded 0 events 2020-10-28T16:25:20.303568Z 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.7.32-0ubuntu0.18.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu) 2020-10-28T16:25:43.933383Z 4 [Note] Aborted connection 4 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets) 2020-10-28T16:25:58.667518Z 5 [Note] Aborted connection 5 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets) 2020-10-28T16:33:27.108405Z 10 [Note] Aborted connection 10 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets) 2020-10-28T16:33:27.108696Z 11 [Note] Aborted connection 11 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets) 2020-10-28T16:33:31.591899Z 12 [Note] Aborted connection 12 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets) 2020-10-28T16:35:18.786493Z 7 [Note] Aborted connection 7 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets) 2020-10-28T16:35:18.786987Z 6 [Note] Aborted connection 6 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets) 2020-10-28T16:40:35.896004Z 20 [Warning] Following users were specified in CREATE USER IF NOT EXISTS but they already exist. Corresponding entry in binary log used default authentication plugin 'mysql_native_password' to rewrite authentication information(if any) for them: 'root'@'%' 2020-10-28T16:40:36.185683Z 0 [Note] Giving 0 client threads a chance to die gracefully 2020-10-28T16:40:36.185815Z 0 [Note] Shutting down slave threads 2020-10-28T16:40:36.185843Z 0 [Note] Forcefully disconnecting 0 remaining clients 2020-10-28T16:40:36.185864Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2020-10-28T16:40:36.186064Z 0 [Note] Binlog end 2020-10-28T16:40:36.188251Z 0 [Note] Shutting down plugin 'ngram' 2020-10-28T16:40:36.188271Z 0 [Note] Shutting down plugin 'partition' 2020-10-28T16:40:36.188279Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2020-10-28T16:40:36.188313Z 0 [Note] Shutting down plugin 'ARCHIVE' 2020-10-28T16:40:36.188324Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2020-10-28T16:40:36.188373Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2020-10-28T16:40:36.188388Z 0 [Note] Shutting down plugin 'MyISAM' 2020-10-28T16:40:36.188403Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2020-10-28T16:40:36.188414Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2020-10-28T16:40:36.188425Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2020-10-28T16:40:36.188436Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2020-10-28T16:40:36.188447Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2020-10-28T16:40:36.188458Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2020-10-28T16:40:36.188468Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2020-10-28T16:40:36.188479Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2020-10-28T16:40:36.188492Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2020-10-28T16:40:36.188503Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2020-10-28T16:40:36.188513Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2020-10-28T16:40:36.188523Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2020-10-28T16:40:36.188535Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2020-10-28T16:40:36.188544Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2020-10-28T16:40:36.188552Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2020-10-28T16:40:36.188562Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2020-10-28T16:40:36.188572Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2020-10-28T16:40:36.188584Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2020-10-28T16:40:36.188594Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2020-10-28T16:40:36.188605Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2020-10-28T16:40:36.188615Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2020-10-28T16:40:36.188626Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2020-10-28T16:40:36.188637Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2020-10-28T16:40:36.188647Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2020-10-28T16:40:36.188658Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2020-10-28T16:40:36.188668Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2020-10-28T16:40:36.188679Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2020-10-28T16:40:36.188690Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2020-10-28T16:40:36.188720Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2020-10-28T16:40:36.188730Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2020-10-28T16:40:36.188740Z 0 [Note] Shutting down plugin 'InnoDB' 2020-10-28T16:40:36.188875Z 0 [Note] InnoDB: FTS optimize thread exiting. 2020-10-28T16:40:36.189075Z 0 [Note] InnoDB: Starting shutdown... 2020-10-28T16:40:36.289376Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2020-10-28T16:40:36.290086Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 201028 16:40:36 2020-10-28T16:40:38.008147Z 0 [Note] InnoDB: Shutdown completed; log sequence number 23097435 2020-10-28T16:40:38.010458Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2020-10-28T16:40:38.010480Z 0 [Note] Shutting down plugin 'MEMORY' 2020-10-28T16:40:38.010490Z 0 [Note] Shutting down plugin 'CSV' 2020-10-28T16:40:38.010498Z 0 [Note] Shutting down plugin 'sha256_password' 2020-10-28T16:40:38.010504Z 0 [Note] Shutting down plugin 'mysql_native_password' 2020-10-28T16:40:38.010682Z 0 [Note] Shutting down plugin 'binlog' 2020-10-28T16:40:38.011317Z 0 [Note] /usr/sbin/mysqld: Shutdown complete 2020-10-28T16:40:38.131285Z 0 [Warning] Changed limits: max_open_files: 5000 (requested 5120) 2020-10-28T16:40:38.131585Z 0 [Warning] Changed limits: table_open_cache: 1983 (requested 2000) 2020-10-28T16:40:38.342075Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2020-10-28T16:40:38.344203Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.32-0ubuntu0.18.04.1) starting as process 17372 ... 2020-10-28T16:40:38.351248Z 0 [Note] InnoDB: PUNCH HOLE support available 2020-10-28T16:40:38.351291Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2020-10-28T16:40:38.351300Z 0 [Note] InnoDB: Uses event mutexes 2020-10-28T16:40:38.351308Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2020-10-28T16:40:38.351316Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2020-10-28T16:40:38.351324Z 0 [Note] InnoDB: Using Linux native AIO 2020-10-28T16:40:38.352118Z 0 [Note] InnoDB: Number of pools: 1 2020-10-28T16:40:38.352265Z 0 [Note] InnoDB: Using CPU crc32 instructions 2020-10-28T16:40:38.355090Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2020-10-28T16:40:38.367313Z 0 [Note] InnoDB: Completed initialization of buffer pool 2020-10-28T16:40:38.370155Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2020-10-28T16:40:38.382508Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2020-10-28T16:40:38.417199Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2020-10-28T16:40:38.417317Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2020-10-28T16:40:38.441432Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2020-10-28T16:40:38.442560Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2020-10-28T16:40:38.442598Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2020-10-28T16:40:38.443343Z 0 [Note] InnoDB: Waiting for purge to start 2020-10-28T16:40:38.493543Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 23097435 2020-10-28T16:40:38.493885Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2020-10-28T16:40:38.494153Z 0 [Note] Plugin 'FEDERATED' is disabled. 2020-10-28T16:40:38.525099Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2020-10-28T16:40:38.525131Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2020-10-28T16:40:38.525971Z 0 [Warning] CA certificate ca.pem is self signed. 2020-10-28T16:40:38.526022Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2020-10-28T16:40:38.526150Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 2020-10-28T16:40:38.526170Z 0 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 2020-10-28T16:40:38.526224Z 0 [Note] Server socket created on IP: '0.0.0.0'. 2020-10-28T16:40:38.549919Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201028 16:40:38 2020-10-28T16:40:38.554287Z 0 [Note] Event Scheduler: Loaded 0 events 2020-10-28T16:40:38.554630Z 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.7.32-0ubuntu0.18.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu) 2020-10-28T16:41:02.198355Z 4 [Note] Aborted connection 4 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets) 2020-10-28T16:41:16.850550Z 5 [Note] Aborted connection 5 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets) 2020-10-28T16:48:46.101092Z 10 [Note] Aborted connection 10 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets) 2020-10-28T16:48:46.101317Z 11 [Note] Aborted connection 11 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets) 2020-10-28T16:48:50.640912Z 12 [Note] Aborted connection 12 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets) 2020-10-28T16:50:35.595900Z 6 [Note] Aborted connection 6 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets) 2020-10-28T16:50:35.597744Z 7 [Note] Aborted connection 7 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets) 2020-10-28T16:55:25.890331Z 20 [Warning] Following users were specified in CREATE USER IF NOT EXISTS but they already exist. Corresponding entry in binary log used default authentication plugin 'mysql_native_password' to rewrite authentication information(if any) for them: 'root'@'%' 2020-10-28T16:55:26.165387Z 0 [Note] Giving 0 client threads a chance to die gracefully 2020-10-28T16:55:26.165441Z 0 [Note] Shutting down slave threads 2020-10-28T16:55:26.165464Z 0 [Note] Forcefully disconnecting 0 remaining clients 2020-10-28T16:55:26.165478Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2020-10-28T16:55:26.165582Z 0 [Note] Binlog end 2020-10-28T16:55:26.167539Z 0 [Note] Shutting down plugin 'ngram' 2020-10-28T16:55:26.167556Z 0 [Note] Shutting down plugin 'partition' 2020-10-28T16:55:26.167564Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2020-10-28T16:55:26.167571Z 0 [Note] Shutting down plugin 'ARCHIVE' 2020-10-28T16:55:26.167578Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2020-10-28T16:55:26.167615Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2020-10-28T16:55:26.167622Z 0 [Note] Shutting down plugin 'MyISAM' 2020-10-28T16:55:26.167632Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2020-10-28T16:55:26.167639Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2020-10-28T16:55:26.167646Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2020-10-28T16:55:26.167651Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2020-10-28T16:55:26.167657Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2020-10-28T16:55:26.167663Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2020-10-28T16:55:26.167668Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2020-10-28T16:55:26.167674Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2020-10-28T16:55:26.167679Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2020-10-28T16:55:26.167685Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2020-10-28T16:55:26.167690Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2020-10-28T16:55:26.167696Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2020-10-28T16:55:26.167702Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2020-10-28T16:55:26.167707Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2020-10-28T16:55:26.167713Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2020-10-28T16:55:26.167718Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2020-10-28T16:55:26.167724Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2020-10-28T16:55:26.167744Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2020-10-28T16:55:26.167750Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2020-10-28T16:55:26.167755Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2020-10-28T16:55:26.167760Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2020-10-28T16:55:26.167765Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2020-10-28T16:55:26.167770Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2020-10-28T16:55:26.167776Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2020-10-28T16:55:26.167781Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2020-10-28T16:55:26.167786Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2020-10-28T16:55:26.167791Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2020-10-28T16:55:26.167796Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2020-10-28T16:55:26.167801Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2020-10-28T16:55:26.167806Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2020-10-28T16:55:26.167811Z 0 [Note] Shutting down plugin 'InnoDB' 2020-10-28T16:55:26.167895Z 0 [Note] InnoDB: FTS optimize thread exiting. 2020-10-28T16:55:26.168030Z 0 [Note] InnoDB: Starting shutdown... 2020-10-28T16:55:26.268331Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2020-10-28T16:55:26.269011Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 201028 16:55:26 2020-10-28T16:55:27.286632Z 0 [Note] InnoDB: Shutdown completed; log sequence number 34182429 2020-10-28T16:55:27.289526Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2020-10-28T16:55:27.289549Z 0 [Note] Shutting down plugin 'MEMORY' 2020-10-28T16:55:27.289558Z 0 [Note] Shutting down plugin 'CSV' 2020-10-28T16:55:27.289566Z 0 [Note] Shutting down plugin 'sha256_password' 2020-10-28T16:55:27.289572Z 0 [Note] Shutting down plugin 'mysql_native_password' 2020-10-28T16:55:27.289748Z 0 [Note] Shutting down plugin 'binlog' 2020-10-28T16:55:27.290408Z 0 [Note] /usr/sbin/mysqld: Shutdown complete 2020-10-28T16:55:27.404088Z 0 [Warning] Changed limits: max_open_files: 5000 (requested 5120) 2020-10-28T16:55:27.404408Z 0 [Warning] Changed limits: table_open_cache: 1983 (requested 2000) 2020-10-28T16:55:27.621435Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2020-10-28T16:55:27.623536Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.32-0ubuntu0.18.04.1) starting as process 59946 ... 2020-10-28T16:55:27.629655Z 0 [Note] InnoDB: PUNCH HOLE support available 2020-10-28T16:55:27.629688Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2020-10-28T16:55:27.629697Z 0 [Note] InnoDB: Uses event mutexes 2020-10-28T16:55:27.629704Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2020-10-28T16:55:27.629712Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2020-10-28T16:55:27.629720Z 0 [Note] InnoDB: Using Linux native AIO 2020-10-28T16:55:27.630521Z 0 [Note] InnoDB: Number of pools: 1 2020-10-28T16:55:27.630671Z 0 [Note] InnoDB: Using CPU crc32 instructions 2020-10-28T16:55:27.633628Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2020-10-28T16:55:27.645905Z 0 [Note] InnoDB: Completed initialization of buffer pool 2020-10-28T16:55:27.649390Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2020-10-28T16:55:27.661567Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2020-10-28T16:55:27.696461Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2020-10-28T16:55:27.696576Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2020-10-28T16:55:27.722058Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2020-10-28T16:55:27.723188Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2020-10-28T16:55:27.723221Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2020-10-28T16:55:27.724528Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 34182429 2020-10-28T16:55:27.724891Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2020-10-28T16:55:27.725032Z 0 [Note] Plugin 'FEDERATED' is disabled. 2020-10-28T16:55:27.756937Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2020-10-28T16:55:27.756967Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2020-10-28T16:55:27.757781Z 0 [Warning] CA certificate ca.pem is self signed. 2020-10-28T16:55:27.757825Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2020-10-28T16:55:27.757932Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 2020-10-28T16:55:27.757950Z 0 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 2020-10-28T16:55:27.758004Z 0 [Note] Server socket created on IP: '0.0.0.0'. 2020-10-28T16:55:27.790192Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201028 16:55:27 2020-10-28T16:55:27.793415Z 0 [Note] Event Scheduler: Loaded 0 events 2020-10-28T16:55:27.793726Z 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.7.32-0ubuntu0.18.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu) 2020-10-28T16:55:50.782885Z 4 [Note] Aborted connection 4 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets) 2020-10-28T16:56:04.771706Z 5 [Note] Aborted connection 5 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets) 2020-10-28T17:03:20.284430Z 10 [Note] Aborted connection 10 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets) 2020-10-28T17:03:20.284622Z 11 [Note] Aborted connection 11 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets) 2020-10-28T17:03:24.780894Z 12 [Note] Aborted connection 12 to db: 'glance' user: 'root' host: 'localhost' (Got an error reading communication packets) 2020-10-28T17:05:19.313317Z 6 [Note] Aborted connection 6 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets) 2020-10-28T17:05:19.316676Z 7 [Note] Aborted connection 7 to db: 'keystone' user: 'root' host: 'localhost' (Got an error reading communication packets)