2018-08-03T14:38:14.494460Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-08-03T14:38:16.778526Z 0 [Warning] InnoDB: New log files created, LSN=45790 2018-08-03T14:38:17.129011Z 0 [Warning] InnoDB: Creating foreign key constraint system tables. 2018-08-03T14:38:17.296900Z 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: dc2a1f41-972a-11e8-a97b-74867a34c021. 2018-08-03T14:38:17.322848Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2018-08-03T14:38:17.323941Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option. 2018-08-03T14:38:39.776329Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2018-08-03T14:38:39.776402Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000) 2018-08-03T14:38:39.929385Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-08-03T14:38:39.930651Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.23-0ubuntu0.16.04.1) starting as process 20497 ... 2018-08-03T14:38:39.947460Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-08-03T14:38:39.947492Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-08-03T14:38:39.947496Z 0 [Note] InnoDB: Uses event mutexes 2018-08-03T14:38:39.947500Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2018-08-03T14:38:39.947504Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2018-08-03T14:38:39.947507Z 0 [Note] InnoDB: Using Linux native AIO 2018-08-03T14:38:39.947713Z 0 [Note] InnoDB: Number of pools: 1 2018-08-03T14:38:39.947794Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-08-03T14:38:39.949017Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-08-03T14:38:39.955911Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-08-03T14:38:39.957754Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-08-03T14:38:39.969689Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-08-03T14:38:40.029482Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-08-03T14:38:40.029550Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-08-03T14:38:40.230613Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-08-03T14:38:40.232226Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2018-08-03T14:38:40.232251Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-08-03T14:38:40.233052Z 0 [Note] InnoDB: 5.7.23 started; log sequence number 2589888 2018-08-03T14:38:40.233323Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-08-03T14:38:40.233493Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-08-03T14:38:40.236566Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180803 20:08:40 2018-08-03T14:38:40.243767Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2018-08-03T14:38:40.243789Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 2018-08-03T14:38:40.243800Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 2018-08-03T14:38:40.243835Z 0 [Note] Server socket created on IP: '127.0.0.1'. 2018-08-03T14:38:40.243851Z 0 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use 2018-08-03T14:38:40.243855Z 0 [ERROR] Do you already have another mysqld server running on port: 3306 ? 2018-08-03T14:38:40.243871Z 0 [ERROR] Aborting 2018-08-03T14:38:40.243881Z 0 [Note] Binlog end 2018-08-03T14:38:40.243934Z 0 [Note] Shutting down plugin 'ngram' 2018-08-03T14:38:40.243941Z 0 [Note] Shutting down plugin 'partition' 2018-08-03T14:38:40.243958Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2018-08-03T14:38:40.243962Z 0 [Note] Shutting down plugin 'ARCHIVE' 2018-08-03T14:38:40.243966Z 0 [Note] Shutting down plugin 'MEMORY' 2018-08-03T14:38:40.243971Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2018-08-03T14:38:40.243975Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2018-08-03T14:38:40.243979Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2018-08-03T14:38:40.243983Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2018-08-03T14:38:40.243996Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2018-08-03T14:38:40.244000Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2018-08-03T14:38:40.244003Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2018-08-03T14:38:40.244006Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2018-08-03T14:38:40.244010Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2018-08-03T14:38:40.244013Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2018-08-03T14:38:40.244017Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2018-08-03T14:38:40.244020Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2018-08-03T14:38:40.244023Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2018-08-03T14:38:40.244027Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2018-08-03T14:38:40.244030Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2018-08-03T14:38:40.244033Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2018-08-03T14:38:40.244037Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2018-08-03T14:38:40.244040Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2018-08-03T14:38:40.244044Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2018-08-03T14:38:40.244047Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2018-08-03T14:38:40.244050Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2018-08-03T14:38:40.244054Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2018-08-03T14:38:40.244057Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2018-08-03T14:38:40.244060Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2018-08-03T14:38:40.244064Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2018-08-03T14:38:40.244067Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2018-08-03T14:38:40.244070Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2018-08-03T14:38:40.244074Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2018-08-03T14:38:40.244077Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2018-08-03T14:38:40.244080Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2018-08-03T14:38:40.244084Z 0 [Note] Shutting down plugin 'InnoDB' 2018-08-03T14:38:40.244188Z 0 [Note] InnoDB: FTS optimize thread exiting. 2018-08-03T14:38:40.244286Z 0 [Note] InnoDB: Starting shutdown... 2018-08-03T14:38:40.344740Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2018-08-03T14:38:40.345253Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180803 20:08:40 2018-08-03T14:38:42.084254Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2589907 2018-08-03T14:38:42.088234Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-08-03T14:38:42.088261Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2018-08-03T14:38:42.088267Z 0 [Note] Shutting down plugin 'MyISAM' 2018-08-03T14:38:42.088282Z 0 [Note] Shutting down plugin 'CSV' 2018-08-03T14:38:42.088287Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2018-08-03T14:38:42.088334Z 0 [Note] Shutting down plugin 'sha256_password' 2018-08-03T14:38:42.088338Z 0 [Note] Shutting down plugin 'mysql_native_password' 2018-08-03T14:38:42.088483Z 0 [Note] Shutting down plugin 'binlog' 2018-08-03T14:38:42.088727Z 0 [Note] /usr/sbin/mysqld: Shutdown complete 2018-08-03T14:39:10.373034Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2018-08-03T14:39:10.373112Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000) 2018-08-03T14:39:10.540103Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-08-03T14:39:10.541759Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.23-0ubuntu0.16.04.1) starting as process 20674 ... 2018-08-03T14:39:10.547754Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-08-03T14:39:10.547789Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-08-03T14:39:10.547798Z 0 [Note] InnoDB: Uses event mutexes 2018-08-03T14:39:10.547806Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2018-08-03T14:39:10.547813Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2018-08-03T14:39:10.547823Z 0 [Note] InnoDB: Using Linux native AIO 2018-08-03T14:39:10.548109Z 0 [Note] InnoDB: Number of pools: 1 2018-08-03T14:39:10.548216Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-08-03T14:39:10.550087Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-08-03T14:39:10.557292Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-08-03T14:39:10.559432Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-08-03T14:39:10.571602Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-08-03T14:39:10.709550Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-08-03T14:39:10.709645Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-08-03T14:39:11.092541Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-08-03T14:39:11.094091Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2018-08-03T14:39:11.094116Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-08-03T14:39:11.094633Z 0 [Note] InnoDB: 5.7.23 started; log sequence number 2589907 2018-08-03T14:39:11.094772Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-08-03T14:39:11.094918Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-08-03T14:39:11.096324Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180803 20:09:11 2018-08-03T14:39:11.100965Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2018-08-03T14:39:11.100987Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 2018-08-03T14:39:11.100996Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 2018-08-03T14:39:11.101024Z 0 [Note] Server socket created on IP: '127.0.0.1'. 2018-08-03T14:39:11.101038Z 0 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use 2018-08-03T14:39:11.101041Z 0 [ERROR] Do you already have another mysqld server running on port: 3306 ? 2018-08-03T14:39:11.101053Z 0 [ERROR] Aborting 2018-08-03T14:39:11.101061Z 0 [Note] Binlog end 2018-08-03T14:39:11.101104Z 0 [Note] Shutting down plugin 'ngram' 2018-08-03T14:39:11.101109Z 0 [Note] Shutting down plugin 'partition' 2018-08-03T14:39:11.101113Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2018-08-03T14:39:11.101116Z 0 [Note] Shutting down plugin 'ARCHIVE' 2018-08-03T14:39:11.101119Z 0 [Note] Shutting down plugin 'MEMORY' 2018-08-03T14:39:11.101122Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2018-08-03T14:39:11.101125Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2018-08-03T14:39:11.101128Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2018-08-03T14:39:11.101131Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2018-08-03T14:39:11.101133Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2018-08-03T14:39:11.101136Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2018-08-03T14:39:11.101139Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2018-08-03T14:39:11.101141Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2018-08-03T14:39:11.101144Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2018-08-03T14:39:11.101147Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2018-08-03T14:39:11.101149Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2018-08-03T14:39:11.101160Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2018-08-03T14:39:11.101163Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2018-08-03T14:39:11.101166Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2018-08-03T14:39:11.101169Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2018-08-03T14:39:11.101171Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2018-08-03T14:39:11.101174Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2018-08-03T14:39:11.101177Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2018-08-03T14:39:11.101180Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2018-08-03T14:39:11.101182Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2018-08-03T14:39:11.101185Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2018-08-03T14:39:11.101188Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2018-08-03T14:39:11.101191Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2018-08-03T14:39:11.101193Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2018-08-03T14:39:11.101196Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2018-08-03T14:39:11.101199Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2018-08-03T14:39:11.101202Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2018-08-03T14:39:11.101204Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2018-08-03T14:39:11.101207Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2018-08-03T14:39:11.101210Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2018-08-03T14:39:11.101212Z 0 [Note] Shutting down plugin 'InnoDB' 2018-08-03T14:39:11.101272Z 0 [Note] InnoDB: FTS optimize thread exiting. 2018-08-03T14:39:11.101349Z 0 [Note] InnoDB: Starting shutdown... 2018-08-03T14:39:11.201522Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2018-08-03T14:39:11.201786Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180803 20:09:11 2018-08-03T14:39:12.959178Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2589926 2018-08-03T14:39:12.962209Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-08-03T14:39:12.962231Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2018-08-03T14:39:12.962239Z 0 [Note] Shutting down plugin 'MyISAM' 2018-08-03T14:39:12.962257Z 0 [Note] Shutting down plugin 'CSV' 2018-08-03T14:39:12.962264Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2018-08-03T14:39:12.962330Z 0 [Note] Shutting down plugin 'sha256_password' 2018-08-03T14:39:12.962335Z 0 [Note] Shutting down plugin 'mysql_native_password' 2018-08-03T14:39:12.962530Z 0 [Note] Shutting down plugin 'binlog' 2018-08-03T14:39:12.962852Z 0 [Note] /usr/sbin/mysqld: Shutdown complete 2018-08-03T14:39:40.886951Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2018-08-03T14:39:40.887005Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000) 2018-08-03T14:39:41.046286Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-08-03T14:39:41.047611Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.23-0ubuntu0.16.04.1) starting as process 20895 ... 2018-08-03T14:39:41.051488Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-08-03T14:39:41.051518Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-08-03T14:39:41.051524Z 0 [Note] InnoDB: Uses event mutexes 2018-08-03T14:39:41.051527Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2018-08-03T14:39:41.051531Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2018-08-03T14:39:41.051534Z 0 [Note] InnoDB: Using Linux native AIO 2018-08-03T14:39:41.051740Z 0 [Note] InnoDB: Number of pools: 1 2018-08-03T14:39:41.051823Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-08-03T14:39:41.053075Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-08-03T14:39:41.061285Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-08-03T14:39:41.063057Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-08-03T14:39:41.075275Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-08-03T14:39:41.113886Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-08-03T14:39:41.113953Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-08-03T14:39:41.308387Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-08-03T14:39:41.310565Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2018-08-03T14:39:41.310594Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-08-03T14:39:41.311853Z 0 [Note] InnoDB: 5.7.23 started; log sequence number 2589926 2018-08-03T14:39:41.312177Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-08-03T14:39:41.312521Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-08-03T14:39:41.315399Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180803 20:09:41 2018-08-03T14:39:41.323188Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2018-08-03T14:39:41.323216Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 2018-08-03T14:39:41.323228Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 2018-08-03T14:39:41.323255Z 0 [Note] Server socket created on IP: '127.0.0.1'. 2018-08-03T14:39:41.323271Z 0 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use 2018-08-03T14:39:41.323276Z 0 [ERROR] Do you already have another mysqld server running on port: 3306 ? 2018-08-03T14:39:41.323292Z 0 [ERROR] Aborting 2018-08-03T14:39:41.323300Z 0 [Note] Binlog end 2018-08-03T14:39:41.323352Z 0 [Note] Shutting down plugin 'ngram' 2018-08-03T14:39:41.323360Z 0 [Note] Shutting down plugin 'partition' 2018-08-03T14:39:41.323364Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2018-08-03T14:39:41.323369Z 0 [Note] Shutting down plugin 'ARCHIVE' 2018-08-03T14:39:41.323373Z 0 [Note] Shutting down plugin 'MEMORY' 2018-08-03T14:39:41.323378Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2018-08-03T14:39:41.323382Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2018-08-03T14:39:41.323386Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2018-08-03T14:39:41.323390Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2018-08-03T14:39:41.323394Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2018-08-03T14:39:41.323398Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2018-08-03T14:39:41.323401Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2018-08-03T14:39:41.323405Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2018-08-03T14:39:41.323409Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2018-08-03T14:39:41.323413Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2018-08-03T14:39:41.323417Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2018-08-03T14:39:41.323421Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2018-08-03T14:39:41.323425Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2018-08-03T14:39:41.323429Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2018-08-03T14:39:41.323433Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2018-08-03T14:39:41.323436Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2018-08-03T14:39:41.323440Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2018-08-03T14:39:41.323444Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2018-08-03T14:39:41.323448Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2018-08-03T14:39:41.323452Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2018-08-03T14:39:41.323456Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2018-08-03T14:39:41.323460Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2018-08-03T14:39:41.323464Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2018-08-03T14:39:41.323468Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2018-08-03T14:39:41.323472Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2018-08-03T14:39:41.323487Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2018-08-03T14:39:41.323491Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2018-08-03T14:39:41.323495Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2018-08-03T14:39:41.323499Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2018-08-03T14:39:41.323503Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2018-08-03T14:39:41.323507Z 0 [Note] Shutting down plugin 'InnoDB' 2018-08-03T14:39:41.323616Z 0 [Note] InnoDB: FTS optimize thread exiting. 2018-08-03T14:39:41.323714Z 0 [Note] InnoDB: Starting shutdown... 2018-08-03T14:39:41.424084Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2018-08-03T14:39:41.424638Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180803 20:09:41 2018-08-03T14:39:43.271755Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2589945 2018-08-03T14:39:43.276025Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-08-03T14:39:43.276044Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2018-08-03T14:39:43.276051Z 0 [Note] Shutting down plugin 'MyISAM' 2018-08-03T14:39:43.276069Z 0 [Note] Shutting down plugin 'CSV' 2018-08-03T14:39:43.276076Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2018-08-03T14:39:43.276141Z 0 [Note] Shutting down plugin 'sha256_password' 2018-08-03T14:39:43.276146Z 0 [Note] Shutting down plugin 'mysql_native_password' 2018-08-03T14:39:43.276305Z 0 [Note] Shutting down plugin 'binlog' 2018-08-03T14:39:43.276568Z 0 [Note] /usr/sbin/mysqld: Shutdown complete 2018-08-03T14:40:11.376771Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2018-08-03T14:40:11.376866Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000) 2018-08-03T14:40:11.530398Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-08-03T14:40:11.532033Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.23-0ubuntu0.16.04.1) starting as process 21053 ... 2018-08-03T14:40:11.536228Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-08-03T14:40:11.536253Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-08-03T14:40:11.536258Z 0 [Note] InnoDB: Uses event mutexes 2018-08-03T14:40:11.536262Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2018-08-03T14:40:11.536265Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2018-08-03T14:40:11.536269Z 0 [Note] InnoDB: Using Linux native AIO 2018-08-03T14:40:11.536474Z 0 [Note] InnoDB: Number of pools: 1 2018-08-03T14:40:11.536557Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-08-03T14:40:11.538023Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-08-03T14:40:11.545644Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-08-03T14:40:11.547431Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-08-03T14:40:11.559573Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-08-03T14:40:11.598620Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-08-03T14:40:11.598689Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-08-03T14:40:11.782494Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-08-03T14:40:11.783633Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2018-08-03T14:40:11.783649Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-08-03T14:40:11.784072Z 0 [Note] InnoDB: Waiting for purge to start 2018-08-03T14:40:11.834317Z 0 [Note] InnoDB: 5.7.23 started; log sequence number 2589945 2018-08-03T14:40:11.834540Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-08-03T14:40:11.834712Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-08-03T14:40:11.836367Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180803 20:10:11 2018-08-03T14:40:11.839173Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2018-08-03T14:40:11.839194Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 2018-08-03T14:40:11.839202Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 2018-08-03T14:40:11.839228Z 0 [Note] Server socket created on IP: '127.0.0.1'. 2018-08-03T14:40:11.839239Z 0 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use 2018-08-03T14:40:11.839242Z 0 [ERROR] Do you already have another mysqld server running on port: 3306 ? 2018-08-03T14:40:11.839253Z 0 [ERROR] Aborting 2018-08-03T14:40:11.839259Z 0 [Note] Binlog end 2018-08-03T14:40:11.839295Z 0 [Note] Shutting down plugin 'ngram' 2018-08-03T14:40:11.839299Z 0 [Note] Shutting down plugin 'partition' 2018-08-03T14:40:11.839302Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2018-08-03T14:40:11.839305Z 0 [Note] Shutting down plugin 'ARCHIVE' 2018-08-03T14:40:11.839307Z 0 [Note] Shutting down plugin 'MEMORY' 2018-08-03T14:40:11.839310Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2018-08-03T14:40:11.839313Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2018-08-03T14:40:11.839315Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2018-08-03T14:40:11.839318Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2018-08-03T14:40:11.839320Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2018-08-03T14:40:11.839322Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2018-08-03T14:40:11.839325Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2018-08-03T14:40:11.839327Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2018-08-03T14:40:11.839330Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2018-08-03T14:40:11.839332Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2018-08-03T14:40:11.839334Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2018-08-03T14:40:11.839337Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2018-08-03T14:40:11.839339Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2018-08-03T14:40:11.839341Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2018-08-03T14:40:11.839344Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2018-08-03T14:40:11.839346Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2018-08-03T14:40:11.839349Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2018-08-03T14:40:11.839351Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2018-08-03T14:40:11.839353Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2018-08-03T14:40:11.839356Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2018-08-03T14:40:11.839358Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2018-08-03T14:40:11.839360Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2018-08-03T14:40:11.839363Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2018-08-03T14:40:11.839365Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2018-08-03T14:40:11.839367Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2018-08-03T14:40:11.839370Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2018-08-03T14:40:11.839372Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2018-08-03T14:40:11.839375Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2018-08-03T14:40:11.839377Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2018-08-03T14:40:11.839379Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2018-08-03T14:40:11.839382Z 0 [Note] Shutting down plugin 'InnoDB' 2018-08-03T14:40:11.839454Z 0 [Note] InnoDB: FTS optimize thread exiting. 2018-08-03T14:40:11.839535Z 0 [Note] InnoDB: Starting shutdown... 2018-08-03T14:40:11.939891Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2018-08-03T14:40:11.940428Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180803 20:10:11 2018-08-03T14:40:13.678981Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2589964 2018-08-03T14:40:13.681519Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-08-03T14:40:13.681543Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2018-08-03T14:40:13.681557Z 0 [Note] Shutting down plugin 'MyISAM' 2018-08-03T14:40:13.681573Z 0 [Note] Shutting down plugin 'CSV' 2018-08-03T14:40:13.681578Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2018-08-03T14:40:13.681621Z 0 [Note] Shutting down plugin 'sha256_password' 2018-08-03T14:40:13.681624Z 0 [Note] Shutting down plugin 'mysql_native_password' 2018-08-03T14:40:13.681753Z 0 [Note] Shutting down plugin 'binlog' 2018-08-03T14:40:13.682000Z 0 [Note] /usr/sbin/mysqld: Shutdown complete 2018-08-03T14:40:41.876592Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2018-08-03T14:40:41.876650Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000) 2018-08-03T14:40:42.029223Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-08-03T14:40:42.030930Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.23-0ubuntu0.16.04.1) starting as process 21308 ... 2018-08-03T14:40:42.035543Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-08-03T14:40:42.035571Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-08-03T14:40:42.035575Z 0 [Note] InnoDB: Uses event mutexes 2018-08-03T14:40:42.035579Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2018-08-03T14:40:42.035582Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2018-08-03T14:40:42.035586Z 0 [Note] InnoDB: Using Linux native AIO 2018-08-03T14:40:42.035794Z 0 [Note] InnoDB: Number of pools: 1 2018-08-03T14:40:42.035877Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-08-03T14:40:42.037399Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-08-03T14:40:42.044434Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-08-03T14:40:42.046642Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-08-03T14:40:42.058722Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-08-03T14:40:42.106180Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-08-03T14:40:42.106318Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-08-03T14:40:42.294393Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-08-03T14:40:42.295576Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2018-08-03T14:40:42.295596Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-08-03T14:40:42.295967Z 0 [Note] InnoDB: Waiting for purge to start 2018-08-03T14:40:42.346254Z 0 [Note] InnoDB: 5.7.23 started; log sequence number 2589964 2018-08-03T14:40:42.346704Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-08-03T14:40:42.346866Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-08-03T14:40:42.350231Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180803 20:10:42 2018-08-03T14:40:42.355273Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2018-08-03T14:40:42.355608Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 2018-08-03T14:40:42.355624Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 2018-08-03T14:40:42.355668Z 0 [Note] Server socket created on IP: '127.0.0.1'. 2018-08-03T14:40:42.355688Z 0 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use 2018-08-03T14:40:42.355693Z 0 [ERROR] Do you already have another mysqld server running on port: 3306 ? 2018-08-03T14:40:42.355712Z 0 [ERROR] Aborting 2018-08-03T14:40:42.355724Z 0 [Note] Binlog end 2018-08-03T14:40:42.355788Z 0 [Note] Shutting down plugin 'ngram' 2018-08-03T14:40:42.355798Z 0 [Note] Shutting down plugin 'partition' 2018-08-03T14:40:42.355803Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2018-08-03T14:40:42.355809Z 0 [Note] Shutting down plugin 'ARCHIVE' 2018-08-03T14:40:42.355814Z 0 [Note] Shutting down plugin 'MEMORY' 2018-08-03T14:40:42.355832Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2018-08-03T14:40:42.355837Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2018-08-03T14:40:42.355842Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2018-08-03T14:40:42.355846Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2018-08-03T14:40:42.355850Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2018-08-03T14:40:42.355855Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2018-08-03T14:40:42.355859Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2018-08-03T14:40:42.355863Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2018-08-03T14:40:42.355868Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2018-08-03T14:40:42.355872Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2018-08-03T14:40:42.355876Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2018-08-03T14:40:42.355880Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2018-08-03T14:40:42.355885Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2018-08-03T14:40:42.355889Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2018-08-03T14:40:42.355893Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2018-08-03T14:40:42.355897Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2018-08-03T14:40:42.355902Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2018-08-03T14:40:42.355906Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2018-08-03T14:40:42.355910Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2018-08-03T14:40:42.355915Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2018-08-03T14:40:42.355919Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2018-08-03T14:40:42.355923Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2018-08-03T14:40:42.355928Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2018-08-03T14:40:42.355932Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2018-08-03T14:40:42.355936Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2018-08-03T14:40:42.355941Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2018-08-03T14:40:42.355945Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2018-08-03T14:40:42.355949Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2018-08-03T14:40:42.355953Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2018-08-03T14:40:42.355958Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2018-08-03T14:40:42.355962Z 0 [Note] Shutting down plugin 'InnoDB' 2018-08-03T14:40:42.356045Z 0 [Note] InnoDB: FTS optimize thread exiting. 2018-08-03T14:40:42.356153Z 0 [Note] InnoDB: Starting shutdown... 2018-08-03T14:40:42.456577Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2018-08-03T14:40:42.457080Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180803 20:10:42 2018-08-03T14:40:44.212159Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2589983 2018-08-03T14:40:44.213929Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-08-03T14:40:44.213939Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2018-08-03T14:40:44.213943Z 0 [Note] Shutting down plugin 'MyISAM' 2018-08-03T14:40:44.213955Z 0 [Note] Shutting down plugin 'CSV' 2018-08-03T14:40:44.213959Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2018-08-03T14:40:44.213997Z 0 [Note] Shutting down plugin 'sha256_password' 2018-08-03T14:40:44.214000Z 0 [Note] Shutting down plugin 'mysql_native_password' 2018-08-03T14:40:44.214121Z 0 [Note] Shutting down plugin 'binlog' 2018-08-03T14:40:44.214308Z 0 [Note] /usr/sbin/mysqld: Shutdown complete 2018-08-03T14:41:12.380264Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2018-08-03T14:41:12.380310Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000) 2018-08-03T14:41:12.537990Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-08-03T14:41:12.539668Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.23-0ubuntu0.16.04.1) starting as process 21553 ... 2018-08-03T14:41:12.544038Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-08-03T14:41:12.544073Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-08-03T14:41:12.544078Z 0 [Note] InnoDB: Uses event mutexes 2018-08-03T14:41:12.544081Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2018-08-03T14:41:12.544085Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2018-08-03T14:41:12.544088Z 0 [Note] InnoDB: Using Linux native AIO 2018-08-03T14:41:12.544293Z 0 [Note] InnoDB: Number of pools: 1 2018-08-03T14:41:12.544373Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-08-03T14:41:12.545813Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-08-03T14:41:12.552929Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-08-03T14:41:12.554702Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-08-03T14:41:12.566673Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-08-03T14:41:12.612536Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-08-03T14:41:12.612614Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-08-03T14:41:12.781205Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-08-03T14:41:12.782314Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2018-08-03T14:41:12.782327Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-08-03T14:41:12.782808Z 0 [Note] InnoDB: Waiting for purge to start 2018-08-03T14:41:12.833113Z 0 [Note] InnoDB: 5.7.23 started; log sequence number 2589983 2018-08-03T14:41:12.833445Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-08-03T14:41:12.833730Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-08-03T14:41:12.836735Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180803 20:11:12 2018-08-03T14:41:12.843347Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2018-08-03T14:41:12.843376Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 2018-08-03T14:41:12.843387Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 2018-08-03T14:41:12.843422Z 0 [Note] Server socket created on IP: '127.0.0.1'. 2018-08-03T14:41:12.843439Z 0 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use 2018-08-03T14:41:12.843443Z 0 [ERROR] Do you already have another mysqld server running on port: 3306 ? 2018-08-03T14:41:12.843460Z 0 [ERROR] Aborting 2018-08-03T14:41:12.843468Z 0 [Note] Binlog end 2018-08-03T14:41:12.843521Z 0 [Note] Shutting down plugin 'ngram' 2018-08-03T14:41:12.843529Z 0 [Note] Shutting down plugin 'partition' 2018-08-03T14:41:12.843533Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2018-08-03T14:41:12.843538Z 0 [Note] Shutting down plugin 'ARCHIVE' 2018-08-03T14:41:12.843542Z 0 [Note] Shutting down plugin 'MEMORY' 2018-08-03T14:41:12.843546Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2018-08-03T14:41:12.843550Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2018-08-03T14:41:12.843554Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2018-08-03T14:41:12.843558Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2018-08-03T14:41:12.843562Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2018-08-03T14:41:12.843566Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2018-08-03T14:41:12.843570Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2018-08-03T14:41:12.843573Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2018-08-03T14:41:12.843577Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2018-08-03T14:41:12.843581Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2018-08-03T14:41:12.843585Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2018-08-03T14:41:12.843588Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2018-08-03T14:41:12.843592Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2018-08-03T14:41:12.843607Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2018-08-03T14:41:12.843612Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2018-08-03T14:41:12.843615Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2018-08-03T14:41:12.843619Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2018-08-03T14:41:12.843623Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2018-08-03T14:41:12.843627Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2018-08-03T14:41:12.843631Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2018-08-03T14:41:12.843635Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2018-08-03T14:41:12.843638Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2018-08-03T14:41:12.843642Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2018-08-03T14:41:12.843646Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2018-08-03T14:41:12.843650Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2018-08-03T14:41:12.843654Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2018-08-03T14:41:12.843657Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2018-08-03T14:41:12.843661Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2018-08-03T14:41:12.843665Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2018-08-03T14:41:12.843669Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2018-08-03T14:41:12.843673Z 0 [Note] Shutting down plugin 'InnoDB' 2018-08-03T14:41:12.843787Z 0 [Note] InnoDB: FTS optimize thread exiting. 2018-08-03T14:41:12.843893Z 0 [Note] InnoDB: Starting shutdown... 2018-08-03T14:41:12.944359Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2018-08-03T14:41:12.944822Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180803 20:11:12 2018-08-03T14:41:14.685425Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2590002 2018-08-03T14:41:14.687321Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-08-03T14:41:14.687333Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2018-08-03T14:41:14.687337Z 0 [Note] Shutting down plugin 'MyISAM' 2018-08-03T14:41:14.687350Z 0 [Note] Shutting down plugin 'CSV' 2018-08-03T14:41:14.687354Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2018-08-03T14:41:14.687393Z 0 [Note] Shutting down plugin 'sha256_password' 2018-08-03T14:41:14.687396Z 0 [Note] Shutting down plugin 'mysql_native_password' 2018-08-03T14:41:14.687511Z 0 [Note] Shutting down plugin 'binlog' 2018-08-03T14:41:14.687695Z 0 [Note] /usr/sbin/mysqld: Shutdown complete 2018-08-03T14:41:42.873651Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2018-08-03T14:41:42.873707Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000) 2018-08-03T14:41:43.030116Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-08-03T14:41:43.031876Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.23-0ubuntu0.16.04.1) starting as process 21815 ... 2018-08-03T14:41:43.035964Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-08-03T14:41:43.035988Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-08-03T14:41:43.035994Z 0 [Note] InnoDB: Uses event mutexes 2018-08-03T14:41:43.035998Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2018-08-03T14:41:43.036001Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2018-08-03T14:41:43.036005Z 0 [Note] InnoDB: Using Linux native AIO 2018-08-03T14:41:43.036208Z 0 [Note] InnoDB: Number of pools: 1 2018-08-03T14:41:43.036290Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-08-03T14:41:43.037815Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-08-03T14:41:43.044953Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-08-03T14:41:43.046842Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-08-03T14:41:43.059300Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-08-03T14:41:43.110788Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-08-03T14:41:43.110953Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-08-03T14:41:43.279467Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-08-03T14:41:43.280945Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2018-08-03T14:41:43.280963Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-08-03T14:41:43.281782Z 0 [Note] InnoDB: Waiting for purge to start 2018-08-03T14:41:43.332072Z 0 [Note] InnoDB: 5.7.23 started; log sequence number 2590002 2018-08-03T14:41:43.332502Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-08-03T14:41:43.332707Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-08-03T14:41:43.556271Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2018-08-03T14:41:43.556299Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 2018-08-03T14:41:43.556310Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 2018-08-03T14:41:43.556346Z 0 [Note] Server socket created on IP: '127.0.0.1'. 2018-08-03T14:41:43.556363Z 0 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use 2018-08-03T14:41:43.556367Z 0 [ERROR] Do you already have another mysqld server running on port: 3306 ? 2018-08-03T14:41:43.556383Z 0 [ERROR] Aborting 2018-08-03T14:41:43.556394Z 0 [Note] Binlog end 2018-08-03T14:41:43.556460Z 0 [Note] Shutting down plugin 'ngram' 2018-08-03T14:41:43.556467Z 0 [Note] Shutting down plugin 'partition' 2018-08-03T14:41:43.556472Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2018-08-03T14:41:43.556476Z 0 [Note] Shutting down plugin 'ARCHIVE' 2018-08-03T14:41:43.556480Z 0 [Note] Shutting down plugin 'MEMORY' 2018-08-03T14:41:43.556485Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2018-08-03T14:41:43.556489Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2018-08-03T14:41:43.556493Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2018-08-03T14:41:43.556497Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2018-08-03T14:41:43.556501Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2018-08-03T14:41:43.556505Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2018-08-03T14:41:43.556509Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2018-08-03T14:41:43.556513Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2018-08-03T14:41:43.556516Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2018-08-03T14:41:43.556520Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2018-08-03T14:41:43.556524Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2018-08-03T14:41:43.556528Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2018-08-03T14:41:43.556532Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2018-08-03T14:41:43.556536Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2018-08-03T14:41:43.556540Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2018-08-03T14:41:43.556544Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2018-08-03T14:41:43.556548Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2018-08-03T14:41:43.556552Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2018-08-03T14:41:43.556555Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2018-08-03T14:41:43.556559Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2018-08-03T14:41:43.556563Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2018-08-03T14:41:43.556567Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2018-08-03T14:41:43.556571Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2018-08-03T14:41:43.556575Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2018-08-03T14:41:43.556579Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2018-08-03T14:41:43.556583Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2018-08-03T14:41:43.556586Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2018-08-03T14:41:43.556599Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2018-08-03T14:41:43.556603Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2018-08-03T14:41:43.556607Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2018-08-03T14:41:43.556611Z 0 [Note] Shutting down plugin 'InnoDB' 2018-08-03T14:41:43.556679Z 0 [Note] InnoDB: FTS optimize thread exiting. 2018-08-03T14:41:43.556776Z 0 [Note] InnoDB: Starting shutdown... 2018-08-03T14:41:43.565964Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180803 20:11:43 2018-08-03T14:41:43.566001Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2018-08-03T14:41:43.566152Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180803 20:11:43 2018-08-03T14:41:45.196160Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2590021 2018-08-03T14:41:45.199743Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-08-03T14:41:45.199759Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2018-08-03T14:41:45.199765Z 0 [Note] Shutting down plugin 'MyISAM' 2018-08-03T14:41:45.199782Z 0 [Note] Shutting down plugin 'CSV' 2018-08-03T14:41:45.199787Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2018-08-03T14:41:45.199854Z 0 [Note] Shutting down plugin 'sha256_password' 2018-08-03T14:41:45.199858Z 0 [Note] Shutting down plugin 'mysql_native_password' 2018-08-03T14:41:45.200025Z 0 [Note] Shutting down plugin 'binlog' 2018-08-03T14:41:45.200268Z 0 [Note] /usr/sbin/mysqld: Shutdown complete 2018-08-03T14:42:13.430347Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2018-08-03T14:42:13.430394Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000) 2018-08-03T14:42:13.589876Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-08-03T14:42:13.591138Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.23-0ubuntu0.16.04.1) starting as process 21975 ... 2018-08-03T14:42:13.610525Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-08-03T14:42:13.610550Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-08-03T14:42:13.610554Z 0 [Note] InnoDB: Uses event mutexes 2018-08-03T14:42:13.610558Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2018-08-03T14:42:13.610562Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2018-08-03T14:42:13.610565Z 0 [Note] InnoDB: Using Linux native AIO 2018-08-03T14:42:13.610771Z 0 [Note] InnoDB: Number of pools: 1 2018-08-03T14:42:13.610854Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-08-03T14:42:13.612137Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-08-03T14:42:13.619050Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-08-03T14:42:13.620793Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-08-03T14:42:13.632713Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-08-03T14:42:13.687052Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-08-03T14:42:13.687116Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-08-03T14:42:13.837474Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-08-03T14:42:13.838572Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2018-08-03T14:42:13.838585Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-08-03T14:42:13.839122Z 0 [Note] InnoDB: 5.7.23 started; log sequence number 2590021 2018-08-03T14:42:13.839379Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-08-03T14:42:13.843299Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-08-03T14:42:13.843522Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2018-08-03T14:42:13.843536Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 2018-08-03T14:42:13.843554Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 2018-08-03T14:42:13.843580Z 0 [Note] Server socket created on IP: '127.0.0.1'. 2018-08-03T14:42:13.843593Z 0 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use 2018-08-03T14:42:13.843597Z 0 [ERROR] Do you already have another mysqld server running on port: 3306 ? 2018-08-03T14:42:13.843610Z 0 [ERROR] Aborting 2018-08-03T14:42:13.843616Z 0 [Note] Binlog end 2018-08-03T14:42:13.843662Z 0 [Note] Shutting down plugin 'ngram' 2018-08-03T14:42:13.843668Z 0 [Note] Shutting down plugin 'partition' 2018-08-03T14:42:13.843671Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2018-08-03T14:42:13.843675Z 0 [Note] Shutting down plugin 'ARCHIVE' 2018-08-03T14:42:13.843677Z 0 [Note] Shutting down plugin 'MEMORY' 2018-08-03T14:42:13.843680Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2018-08-03T14:42:13.843683Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2018-08-03T14:42:13.843686Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2018-08-03T14:42:13.843689Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2018-08-03T14:42:13.843691Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2018-08-03T14:42:13.843694Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2018-08-03T14:42:13.843697Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2018-08-03T14:42:13.843699Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2018-08-03T14:42:13.843702Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2018-08-03T14:42:13.843705Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2018-08-03T14:42:13.843707Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2018-08-03T14:42:13.843710Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2018-08-03T14:42:13.843712Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2018-08-03T14:42:13.843715Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2018-08-03T14:42:13.843718Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2018-08-03T14:42:13.843720Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2018-08-03T14:42:13.843723Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2018-08-03T14:42:13.843726Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2018-08-03T14:42:13.843728Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2018-08-03T14:42:13.843731Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2018-08-03T14:42:13.843734Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2018-08-03T14:42:13.843736Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2018-08-03T14:42:13.843739Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2018-08-03T14:42:13.843742Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2018-08-03T14:42:13.843744Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2018-08-03T14:42:13.843747Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2018-08-03T14:42:13.843749Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2018-08-03T14:42:13.843752Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2018-08-03T14:42:13.843755Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2018-08-03T14:42:13.843757Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2018-08-03T14:42:13.843760Z 0 [Note] Shutting down plugin 'InnoDB' 2018-08-03T14:42:13.843821Z 0 [Note] InnoDB: FTS optimize thread exiting. 2018-08-03T14:42:13.843876Z 0 [Note] InnoDB: Starting shutdown... 2018-08-03T14:42:13.843918Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180803 20:12:13 2018-08-03T14:42:13.843941Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2018-08-03T14:42:13.844045Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180803 20:12:13 2018-08-03T14:42:15.787589Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2590040 2018-08-03T14:42:15.791661Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-08-03T14:42:15.791679Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2018-08-03T14:42:15.791685Z 0 [Note] Shutting down plugin 'MyISAM' 2018-08-03T14:42:15.791702Z 0 [Note] Shutting down plugin 'CSV' 2018-08-03T14:42:15.791708Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2018-08-03T14:42:15.791776Z 0 [Note] Shutting down plugin 'sha256_password' 2018-08-03T14:42:15.791781Z 0 [Note] Shutting down plugin 'mysql_native_password' 2018-08-03T14:42:15.791963Z 0 [Note] Shutting down plugin 'binlog' 2018-08-03T14:42:15.792208Z 0 [Note] /usr/sbin/mysqld: Shutdown complete 2018-08-03T14:42:43.877088Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2018-08-03T14:42:43.877142Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000) 2018-08-03T14:42:44.029384Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-08-03T14:42:44.031001Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.23-0ubuntu0.16.04.1) starting as process 22149 ... 2018-08-03T14:42:44.035243Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-08-03T14:42:44.035275Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-08-03T14:42:44.035282Z 0 [Note] InnoDB: Uses event mutexes 2018-08-03T14:42:44.035286Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2018-08-03T14:42:44.035292Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2018-08-03T14:42:44.035297Z 0 [Note] InnoDB: Using Linux native AIO 2018-08-03T14:42:44.035534Z 0 [Note] InnoDB: Number of pools: 1 2018-08-03T14:42:44.035620Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-08-03T14:42:44.037193Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-08-03T14:42:44.044491Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-08-03T14:42:44.046193Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-08-03T14:42:44.058648Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-08-03T14:42:44.161397Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-08-03T14:42:44.161467Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-08-03T14:42:44.356296Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-08-03T14:42:44.357449Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2018-08-03T14:42:44.357466Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-08-03T14:42:44.357840Z 0 [Note] InnoDB: Waiting for purge to start 2018-08-03T14:42:44.408074Z 0 [Note] InnoDB: 5.7.23 started; log sequence number 2590040 2018-08-03T14:42:44.408392Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-08-03T14:42:44.408639Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-08-03T14:42:44.410330Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180803 20:12:44 2018-08-03T14:42:44.418355Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2018-08-03T14:42:44.418406Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 2018-08-03T14:42:44.418426Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 2018-08-03T14:42:44.418474Z 0 [Note] Server socket created on IP: '127.0.0.1'. 2018-08-03T14:42:44.418504Z 0 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use 2018-08-03T14:42:44.418513Z 0 [ERROR] Do you already have another mysqld server running on port: 3306 ? 2018-08-03T14:42:44.418542Z 0 [ERROR] Aborting 2018-08-03T14:42:44.418557Z 0 [Note] Binlog end 2018-08-03T14:42:44.418646Z 0 [Note] Shutting down plugin 'ngram' 2018-08-03T14:42:44.418660Z 0 [Note] Shutting down plugin 'partition' 2018-08-03T14:42:44.418669Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2018-08-03T14:42:44.418677Z 0 [Note] Shutting down plugin 'ARCHIVE' 2018-08-03T14:42:44.418685Z 0 [Note] Shutting down plugin 'MEMORY' 2018-08-03T14:42:44.418694Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2018-08-03T14:42:44.418702Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2018-08-03T14:42:44.418730Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2018-08-03T14:42:44.418738Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2018-08-03T14:42:44.418745Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2018-08-03T14:42:44.418752Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2018-08-03T14:42:44.418759Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2018-08-03T14:42:44.418766Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2018-08-03T14:42:44.418773Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2018-08-03T14:42:44.418779Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2018-08-03T14:42:44.418786Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2018-08-03T14:42:44.418793Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2018-08-03T14:42:44.418800Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2018-08-03T14:42:44.418807Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2018-08-03T14:42:44.418814Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2018-08-03T14:42:44.418821Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2018-08-03T14:42:44.418828Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2018-08-03T14:42:44.418835Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2018-08-03T14:42:44.418842Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2018-08-03T14:42:44.418849Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2018-08-03T14:42:44.418855Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2018-08-03T14:42:44.418862Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2018-08-03T14:42:44.418869Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2018-08-03T14:42:44.418876Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2018-08-03T14:42:44.418883Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2018-08-03T14:42:44.418890Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2018-08-03T14:42:44.418897Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2018-08-03T14:42:44.418904Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2018-08-03T14:42:44.418911Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2018-08-03T14:42:44.418918Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2018-08-03T14:42:44.418925Z 0 [Note] Shutting down plugin 'InnoDB' 2018-08-03T14:42:44.419085Z 0 [Note] InnoDB: FTS optimize thread exiting. 2018-08-03T14:42:44.419278Z 0 [Note] InnoDB: Starting shutdown... 2018-08-03T14:42:44.519756Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2018-08-03T14:42:44.520214Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180803 20:12:44 2018-08-03T14:42:46.259495Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2590059 2018-08-03T14:42:46.263312Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-08-03T14:42:46.263357Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2018-08-03T14:42:46.263369Z 0 [Note] Shutting down plugin 'MyISAM' 2018-08-03T14:42:46.263397Z 0 [Note] Shutting down plugin 'CSV' 2018-08-03T14:42:46.263407Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2018-08-03T14:42:46.263509Z 0 [Note] Shutting down plugin 'sha256_password' 2018-08-03T14:42:46.263518Z 0 [Note] Shutting down plugin 'mysql_native_password' 2018-08-03T14:42:46.263775Z 0 [Note] Shutting down plugin 'binlog' 2018-08-03T14:42:46.264383Z 0 [Note] /usr/sbin/mysqld: Shutdown complete 2018-08-03T14:43:14.380218Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2018-08-03T14:43:14.380271Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000) 2018-08-03T14:43:14.536870Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-08-03T14:43:14.538503Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.23-0ubuntu0.16.04.1) starting as process 22312 ... 2018-08-03T14:43:14.542556Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-08-03T14:43:14.542581Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-08-03T14:43:14.542586Z 0 [Note] InnoDB: Uses event mutexes 2018-08-03T14:43:14.542598Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2018-08-03T14:43:14.542601Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2018-08-03T14:43:14.542605Z 0 [Note] InnoDB: Using Linux native AIO 2018-08-03T14:43:14.542810Z 0 [Note] InnoDB: Number of pools: 1 2018-08-03T14:43:14.542891Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-08-03T14:43:14.544472Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-08-03T14:43:14.551723Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-08-03T14:43:14.553437Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-08-03T14:43:14.565485Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-08-03T14:43:14.616756Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-08-03T14:43:14.616845Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-08-03T14:43:14.766769Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-08-03T14:43:14.767948Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2018-08-03T14:43:14.767965Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-08-03T14:43:14.768369Z 0 [Note] InnoDB: 5.7.23 started; log sequence number 2590059 2018-08-03T14:43:14.768465Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-08-03T14:43:14.768602Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-08-03T14:43:14.769438Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180803 20:13:14 2018-08-03T14:43:14.772743Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2018-08-03T14:43:14.772764Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 2018-08-03T14:43:14.772773Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 2018-08-03T14:43:14.772799Z 0 [Note] Server socket created on IP: '127.0.0.1'. 2018-08-03T14:43:14.772812Z 0 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use 2018-08-03T14:43:14.772815Z 0 [ERROR] Do you already have another mysqld server running on port: 3306 ? 2018-08-03T14:43:14.772828Z 0 [ERROR] Aborting 2018-08-03T14:43:14.772834Z 0 [Note] Binlog end 2018-08-03T14:43:14.772872Z 0 [Note] Shutting down plugin 'ngram' 2018-08-03T14:43:14.772877Z 0 [Note] Shutting down plugin 'partition' 2018-08-03T14:43:14.772880Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2018-08-03T14:43:14.772883Z 0 [Note] Shutting down plugin 'ARCHIVE' 2018-08-03T14:43:14.772886Z 0 [Note] Shutting down plugin 'MEMORY' 2018-08-03T14:43:14.772889Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2018-08-03T14:43:14.772892Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2018-08-03T14:43:14.772895Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2018-08-03T14:43:14.772897Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2018-08-03T14:43:14.772900Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2018-08-03T14:43:14.772903Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2018-08-03T14:43:14.772906Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2018-08-03T14:43:14.772908Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2018-08-03T14:43:14.772911Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2018-08-03T14:43:14.772913Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2018-08-03T14:43:14.772916Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2018-08-03T14:43:14.772919Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2018-08-03T14:43:14.772921Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2018-08-03T14:43:14.772924Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2018-08-03T14:43:14.772927Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2018-08-03T14:43:14.772929Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2018-08-03T14:43:14.772941Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2018-08-03T14:43:14.772943Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2018-08-03T14:43:14.772946Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2018-08-03T14:43:14.772949Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2018-08-03T14:43:14.772951Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2018-08-03T14:43:14.772954Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2018-08-03T14:43:14.772957Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2018-08-03T14:43:14.772959Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2018-08-03T14:43:14.772962Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2018-08-03T14:43:14.772965Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2018-08-03T14:43:14.772967Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2018-08-03T14:43:14.772970Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2018-08-03T14:43:14.772972Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2018-08-03T14:43:14.772975Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2018-08-03T14:43:14.772978Z 0 [Note] Shutting down plugin 'InnoDB' 2018-08-03T14:43:14.773032Z 0 [Note] InnoDB: FTS optimize thread exiting. 2018-08-03T14:43:14.773087Z 0 [Note] InnoDB: Starting shutdown... 2018-08-03T14:43:14.873426Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2018-08-03T14:43:14.873865Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180803 20:13:14 2018-08-03T14:43:16.717567Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2590078 2018-08-03T14:43:16.720904Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-08-03T14:43:16.720917Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2018-08-03T14:43:16.720923Z 0 [Note] Shutting down plugin 'MyISAM' 2018-08-03T14:43:16.720938Z 0 [Note] Shutting down plugin 'CSV' 2018-08-03T14:43:16.720943Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2018-08-03T14:43:16.720992Z 0 [Note] Shutting down plugin 'sha256_password' 2018-08-03T14:43:16.720996Z 0 [Note] Shutting down plugin 'mysql_native_password' 2018-08-03T14:43:16.721146Z 0 [Note] Shutting down plugin 'binlog' 2018-08-03T14:43:16.721374Z 0 [Note] /usr/sbin/mysqld: Shutdown complete 2018-08-03T14:43:44.874145Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2018-08-03T14:43:44.874228Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000) 2018-08-03T14:43:45.029809Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-08-03T14:43:45.031435Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.23-0ubuntu0.16.04.1) starting as process 22494 ... 2018-08-03T14:43:45.035827Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-08-03T14:43:45.035853Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-08-03T14:43:45.035858Z 0 [Note] InnoDB: Uses event mutexes 2018-08-03T14:43:45.035862Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2018-08-03T14:43:45.035866Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2018-08-03T14:43:45.035870Z 0 [Note] InnoDB: Using Linux native AIO 2018-08-03T14:43:45.036103Z 0 [Note] InnoDB: Number of pools: 1 2018-08-03T14:43:45.036197Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-08-03T14:43:45.037866Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-08-03T14:43:45.044854Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-08-03T14:43:45.046710Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-08-03T14:43:45.058915Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-08-03T14:43:45.105039Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-08-03T14:43:45.105106Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-08-03T14:43:45.255440Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-08-03T14:43:45.256544Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2018-08-03T14:43:45.256558Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-08-03T14:43:45.257057Z 0 [Note] InnoDB: Waiting for purge to start 2018-08-03T14:43:45.307374Z 0 [Note] InnoDB: 5.7.23 started; log sequence number 2590078 2018-08-03T14:43:45.307659Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-08-03T14:43:45.307968Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-08-03T14:43:45.309792Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180803 20:13:45 2018-08-03T14:43:45.317223Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2018-08-03T14:43:45.317265Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 2018-08-03T14:43:45.317283Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 2018-08-03T14:43:45.317337Z 0 [Note] Server socket created on IP: '127.0.0.1'. 2018-08-03T14:43:45.317364Z 0 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use 2018-08-03T14:43:45.317371Z 0 [ERROR] Do you already have another mysqld server running on port: 3306 ? 2018-08-03T14:43:45.317395Z 0 [ERROR] Aborting 2018-08-03T14:43:45.317409Z 0 [Note] Binlog end 2018-08-03T14:43:45.317488Z 0 [Note] Shutting down plugin 'ngram' 2018-08-03T14:43:45.317499Z 0 [Note] Shutting down plugin 'partition' 2018-08-03T14:43:45.317506Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2018-08-03T14:43:45.317514Z 0 [Note] Shutting down plugin 'ARCHIVE' 2018-08-03T14:43:45.317520Z 0 [Note] Shutting down plugin 'MEMORY' 2018-08-03T14:43:45.317527Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2018-08-03T14:43:45.317533Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2018-08-03T14:43:45.317539Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2018-08-03T14:43:45.317545Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2018-08-03T14:43:45.317551Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2018-08-03T14:43:45.317557Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2018-08-03T14:43:45.317563Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2018-08-03T14:43:45.317569Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2018-08-03T14:43:45.317575Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2018-08-03T14:43:45.317581Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2018-08-03T14:43:45.317587Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2018-08-03T14:43:45.317593Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2018-08-03T14:43:45.317599Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2018-08-03T14:43:45.317605Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2018-08-03T14:43:45.317611Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2018-08-03T14:43:45.317617Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2018-08-03T14:43:45.317623Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2018-08-03T14:43:45.317629Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2018-08-03T14:43:45.317635Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2018-08-03T14:43:45.317641Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2018-08-03T14:43:45.317647Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2018-08-03T14:43:45.317653Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2018-08-03T14:43:45.317659Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2018-08-03T14:43:45.317665Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2018-08-03T14:43:45.317671Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2018-08-03T14:43:45.317677Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2018-08-03T14:43:45.317683Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2018-08-03T14:43:45.317689Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2018-08-03T14:43:45.317695Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2018-08-03T14:43:45.317717Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2018-08-03T14:43:45.317724Z 0 [Note] Shutting down plugin 'InnoDB' 2018-08-03T14:43:45.317841Z 0 [Note] InnoDB: FTS optimize thread exiting. 2018-08-03T14:43:45.317944Z 0 [Note] InnoDB: Starting shutdown... 2018-08-03T14:43:45.418361Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2018-08-03T14:43:45.418988Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180803 20:13:45 2018-08-03T14:43:47.169430Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2590097 2018-08-03T14:43:47.172197Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-08-03T14:43:47.172218Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2018-08-03T14:43:47.172225Z 0 [Note] Shutting down plugin 'MyISAM' 2018-08-03T14:43:47.172243Z 0 [Note] Shutting down plugin 'CSV' 2018-08-03T14:43:47.172249Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2018-08-03T14:43:47.172309Z 0 [Note] Shutting down plugin 'sha256_password' 2018-08-03T14:43:47.172314Z 0 [Note] Shutting down plugin 'mysql_native_password' 2018-08-03T14:43:47.172501Z 0 [Note] Shutting down plugin 'binlog' 2018-08-03T14:43:47.172800Z 0 [Note] /usr/sbin/mysqld: Shutdown complete 2018-08-03T14:44:15.379681Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2018-08-03T14:44:15.379756Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000) 2018-08-03T14:44:15.528813Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-08-03T14:44:15.530858Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.23-0ubuntu0.16.04.1) starting as process 22659 ... 2018-08-03T14:44:15.535251Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-08-03T14:44:15.535280Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-08-03T14:44:15.535285Z 0 [Note] InnoDB: Uses event mutexes 2018-08-03T14:44:15.535289Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2018-08-03T14:44:15.535293Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2018-08-03T14:44:15.535297Z 0 [Note] InnoDB: Using Linux native AIO 2018-08-03T14:44:15.535525Z 0 [Note] InnoDB: Number of pools: 1 2018-08-03T14:44:15.535620Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-08-03T14:44:15.537547Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-08-03T14:44:15.544674Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-08-03T14:44:15.546413Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-08-03T14:44:15.558514Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-08-03T14:44:15.603425Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-08-03T14:44:15.603491Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-08-03T14:44:15.753838Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-08-03T14:44:15.754942Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2018-08-03T14:44:15.754955Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-08-03T14:44:15.755316Z 0 [Note] InnoDB: Waiting for purge to start 2018-08-03T14:44:15.805601Z 0 [Note] InnoDB: 5.7.23 started; log sequence number 2590097 2018-08-03T14:44:15.805966Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-08-03T14:44:15.806041Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-08-03T14:44:15.807522Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180803 20:14:15 2018-08-03T14:44:15.813405Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2018-08-03T14:44:15.813435Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 2018-08-03T14:44:15.813448Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 2018-08-03T14:44:15.813498Z 0 [Note] Server socket created on IP: '127.0.0.1'. 2018-08-03T14:44:15.813516Z 0 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use 2018-08-03T14:44:15.813521Z 0 [ERROR] Do you already have another mysqld server running on port: 3306 ? 2018-08-03T14:44:15.813538Z 0 [ERROR] Aborting 2018-08-03T14:44:15.813547Z 0 [Note] Binlog end 2018-08-03T14:44:15.813602Z 0 [Note] Shutting down plugin 'ngram' 2018-08-03T14:44:15.813610Z 0 [Note] Shutting down plugin 'partition' 2018-08-03T14:44:15.813615Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2018-08-03T14:44:15.813620Z 0 [Note] Shutting down plugin 'ARCHIVE' 2018-08-03T14:44:15.813624Z 0 [Note] Shutting down plugin 'MEMORY' 2018-08-03T14:44:15.813628Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2018-08-03T14:44:15.813633Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2018-08-03T14:44:15.813637Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2018-08-03T14:44:15.813641Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2018-08-03T14:44:15.813645Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2018-08-03T14:44:15.813649Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2018-08-03T14:44:15.813653Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2018-08-03T14:44:15.813657Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2018-08-03T14:44:15.813661Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2018-08-03T14:44:15.813665Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2018-08-03T14:44:15.813669Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2018-08-03T14:44:15.813673Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2018-08-03T14:44:15.813677Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2018-08-03T14:44:15.813681Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2018-08-03T14:44:15.813685Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2018-08-03T14:44:15.813689Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2018-08-03T14:44:15.813694Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2018-08-03T14:44:15.813698Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2018-08-03T14:44:15.813702Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2018-08-03T14:44:15.813706Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2018-08-03T14:44:15.813710Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2018-08-03T14:44:15.813714Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2018-08-03T14:44:15.813718Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2018-08-03T14:44:15.813722Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2018-08-03T14:44:15.813726Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2018-08-03T14:44:15.813730Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2018-08-03T14:44:15.813734Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2018-08-03T14:44:15.813738Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2018-08-03T14:44:15.813742Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2018-08-03T14:44:15.813746Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2018-08-03T14:44:15.813750Z 0 [Note] Shutting down plugin 'InnoDB' 2018-08-03T14:44:15.813828Z 0 [Note] InnoDB: FTS optimize thread exiting. 2018-08-03T14:44:15.813928Z 0 [Note] InnoDB: Starting shutdown... 2018-08-03T14:44:15.914311Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2018-08-03T14:44:15.914916Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180803 20:14:15 2018-08-03T14:44:17.671229Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2590116 2018-08-03T14:44:17.673706Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-08-03T14:44:17.673723Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2018-08-03T14:44:17.673728Z 0 [Note] Shutting down plugin 'MyISAM' 2018-08-03T14:44:17.673742Z 0 [Note] Shutting down plugin 'CSV' 2018-08-03T14:44:17.673746Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2018-08-03T14:44:17.673792Z 0 [Note] Shutting down plugin 'sha256_password' 2018-08-03T14:44:17.673805Z 0 [Note] Shutting down plugin 'mysql_native_password' 2018-08-03T14:44:17.673929Z 0 [Note] Shutting down plugin 'binlog' 2018-08-03T14:44:17.674119Z 0 [Note] /usr/sbin/mysqld: Shutdown complete 2018-08-03T14:44:45.876439Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2018-08-03T14:44:45.876513Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000) 2018-08-03T14:44:46.029027Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-08-03T14:44:46.030656Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.23-0ubuntu0.16.04.1) starting as process 22865 ... 2018-08-03T14:44:46.034932Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-08-03T14:44:46.034957Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-08-03T14:44:46.034961Z 0 [Note] InnoDB: Uses event mutexes 2018-08-03T14:44:46.034965Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2018-08-03T14:44:46.034970Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2018-08-03T14:44:46.034973Z 0 [Note] InnoDB: Using Linux native AIO 2018-08-03T14:44:46.035219Z 0 [Note] InnoDB: Number of pools: 1 2018-08-03T14:44:46.035305Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-08-03T14:44:46.036886Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-08-03T14:44:46.044163Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-08-03T14:44:46.045978Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-08-03T14:44:46.057954Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-08-03T14:44:46.105720Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-08-03T14:44:46.105805Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-08-03T14:44:46.255859Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-08-03T14:44:46.258125Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2018-08-03T14:44:46.258173Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-08-03T14:44:46.259111Z 0 [Note] InnoDB: Waiting for purge to start 2018-08-03T14:44:46.309411Z 0 [Note] InnoDB: 5.7.23 started; log sequence number 2590116 2018-08-03T14:44:46.309835Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-08-03T14:44:46.310006Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-08-03T14:44:46.311603Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180803 20:14:46 2018-08-03T14:44:46.319291Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2018-08-03T14:44:46.319322Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 2018-08-03T14:44:46.319338Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 2018-08-03T14:44:46.319385Z 0 [Note] Server socket created on IP: '127.0.0.1'. 2018-08-03T14:44:46.319409Z 0 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use 2018-08-03T14:44:46.319416Z 0 [ERROR] Do you already have another mysqld server running on port: 3306 ? 2018-08-03T14:44:46.319437Z 0 [ERROR] Aborting 2018-08-03T14:44:46.319450Z 0 [Note] Binlog end 2018-08-03T14:44:46.319509Z 0 [Note] Shutting down plugin 'ngram' 2018-08-03T14:44:46.319517Z 0 [Note] Shutting down plugin 'partition' 2018-08-03T14:44:46.319522Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2018-08-03T14:44:46.319529Z 0 [Note] Shutting down plugin 'ARCHIVE' 2018-08-03T14:44:46.319535Z 0 [Note] Shutting down plugin 'MEMORY' 2018-08-03T14:44:46.319541Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2018-08-03T14:44:46.319548Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2018-08-03T14:44:46.319554Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2018-08-03T14:44:46.319560Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2018-08-03T14:44:46.319582Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2018-08-03T14:44:46.319588Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2018-08-03T14:44:46.319594Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2018-08-03T14:44:46.319600Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2018-08-03T14:44:46.319605Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2018-08-03T14:44:46.319610Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2018-08-03T14:44:46.319615Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2018-08-03T14:44:46.319621Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2018-08-03T14:44:46.319626Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2018-08-03T14:44:46.319631Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2018-08-03T14:44:46.319637Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2018-08-03T14:44:46.319642Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2018-08-03T14:44:46.319649Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2018-08-03T14:44:46.319654Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2018-08-03T14:44:46.319660Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2018-08-03T14:44:46.319666Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2018-08-03T14:44:46.319671Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2018-08-03T14:44:46.319676Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2018-08-03T14:44:46.319682Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2018-08-03T14:44:46.319687Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2018-08-03T14:44:46.319693Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2018-08-03T14:44:46.319698Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2018-08-03T14:44:46.319704Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2018-08-03T14:44:46.319709Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2018-08-03T14:44:46.319714Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2018-08-03T14:44:46.319719Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2018-08-03T14:44:46.319725Z 0 [Note] Shutting down plugin 'InnoDB' 2018-08-03T14:44:46.319823Z 0 [Note] InnoDB: FTS optimize thread exiting. 2018-08-03T14:44:46.319906Z 0 [Note] InnoDB: Starting shutdown... 2018-08-03T14:44:46.420218Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2018-08-03T14:44:46.420590Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180803 20:14:46 2018-08-03T14:44:48.195786Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2590135 2018-08-03T14:44:48.199254Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-08-03T14:44:48.199280Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2018-08-03T14:44:48.199288Z 0 [Note] Shutting down plugin 'MyISAM' 2018-08-03T14:44:48.199305Z 0 [Note] Shutting down plugin 'CSV' 2018-08-03T14:44:48.199311Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2018-08-03T14:44:48.199369Z 0 [Note] Shutting down plugin 'sha256_password' 2018-08-03T14:44:48.199374Z 0 [Note] Shutting down plugin 'mysql_native_password' 2018-08-03T14:44:48.199578Z 0 [Note] Shutting down plugin 'binlog' 2018-08-03T14:44:48.199914Z 0 [Note] /usr/sbin/mysqld: Shutdown complete 2018-08-03T14:45:16.377159Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2018-08-03T14:45:16.377201Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000) 2018-08-03T14:45:16.529204Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-08-03T14:45:16.530933Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.23-0ubuntu0.16.04.1) starting as process 23048 ... 2018-08-03T14:45:16.535118Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-08-03T14:45:16.535173Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-08-03T14:45:16.535182Z 0 [Note] InnoDB: Uses event mutexes 2018-08-03T14:45:16.535187Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2018-08-03T14:45:16.535200Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2018-08-03T14:45:16.535214Z 0 [Note] InnoDB: Using Linux native AIO 2018-08-03T14:45:16.535419Z 0 [Note] InnoDB: Number of pools: 1 2018-08-03T14:45:16.535501Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-08-03T14:45:16.537113Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-08-03T14:45:16.544383Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-08-03T14:45:16.546132Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-08-03T14:45:16.557996Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-08-03T14:45:16.609758Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-08-03T14:45:16.609823Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-08-03T14:45:16.759841Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-08-03T14:45:16.761572Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2018-08-03T14:45:16.761594Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-08-03T14:45:16.762366Z 0 [Note] InnoDB: Waiting for purge to start 2018-08-03T14:45:16.812676Z 0 [Note] InnoDB: 5.7.23 started; log sequence number 2590135 2018-08-03T14:45:16.813113Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-08-03T14:45:16.813490Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-08-03T14:45:16.816226Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180803 20:15:16 2018-08-03T14:45:16.824387Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2018-08-03T14:45:16.824416Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 2018-08-03T14:45:16.824428Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 2018-08-03T14:45:16.824464Z 0 [Note] Server socket created on IP: '127.0.0.1'. 2018-08-03T14:45:16.824481Z 0 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use 2018-08-03T14:45:16.824486Z 0 [ERROR] Do you already have another mysqld server running on port: 3306 ? 2018-08-03T14:45:16.824502Z 0 [ERROR] Aborting 2018-08-03T14:45:16.824510Z 0 [Note] Binlog end 2018-08-03T14:45:16.824563Z 0 [Note] Shutting down plugin 'ngram' 2018-08-03T14:45:16.824567Z 0 [Note] Shutting down plugin 'partition' 2018-08-03T14:45:16.824570Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2018-08-03T14:45:16.824573Z 0 [Note] Shutting down plugin 'ARCHIVE' 2018-08-03T14:45:16.824575Z 0 [Note] Shutting down plugin 'MEMORY' 2018-08-03T14:45:16.824578Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2018-08-03T14:45:16.824581Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2018-08-03T14:45:16.824583Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2018-08-03T14:45:16.824585Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2018-08-03T14:45:16.824588Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2018-08-03T14:45:16.824590Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2018-08-03T14:45:16.824592Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2018-08-03T14:45:16.824595Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2018-08-03T14:45:16.824597Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2018-08-03T14:45:16.824599Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2018-08-03T14:45:16.824602Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2018-08-03T14:45:16.824604Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2018-08-03T14:45:16.824606Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2018-08-03T14:45:16.824609Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2018-08-03T14:45:16.824611Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2018-08-03T14:45:16.824613Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2018-08-03T14:45:16.824616Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2018-08-03T14:45:16.824618Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2018-08-03T14:45:16.824628Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2018-08-03T14:45:16.824631Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2018-08-03T14:45:16.824633Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2018-08-03T14:45:16.824635Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2018-08-03T14:45:16.824638Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2018-08-03T14:45:16.824640Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2018-08-03T14:45:16.824642Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2018-08-03T14:45:16.824645Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2018-08-03T14:45:16.824647Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2018-08-03T14:45:16.824649Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2018-08-03T14:45:16.824652Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2018-08-03T14:45:16.824654Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2018-08-03T14:45:16.824656Z 0 [Note] Shutting down plugin 'InnoDB' 2018-08-03T14:45:16.824738Z 0 [Note] InnoDB: FTS optimize thread exiting. 2018-08-03T14:45:16.824822Z 0 [Note] InnoDB: Starting shutdown... 2018-08-03T14:45:16.925127Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2018-08-03T14:45:16.925385Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180803 20:15:16 2018-08-03T14:45:18.664725Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2590154 2018-08-03T14:45:18.667062Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-08-03T14:45:18.667086Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2018-08-03T14:45:18.667091Z 0 [Note] Shutting down plugin 'MyISAM' 2018-08-03T14:45:18.667107Z 0 [Note] Shutting down plugin 'CSV' 2018-08-03T14:45:18.667111Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2018-08-03T14:45:18.667173Z 0 [Note] Shutting down plugin 'sha256_password' 2018-08-03T14:45:18.667180Z 0 [Note] Shutting down plugin 'mysql_native_password' 2018-08-03T14:45:18.667349Z 0 [Note] Shutting down plugin 'binlog' 2018-08-03T14:45:18.667609Z 0 [Note] /usr/sbin/mysqld: Shutdown complete 2018-08-03T14:45:46.877422Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2018-08-03T14:45:46.877486Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000) 2018-08-03T14:45:47.029466Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-08-03T14:45:47.031216Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.23-0ubuntu0.16.04.1) starting as process 23221 ... 2018-08-03T14:45:47.035590Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-08-03T14:45:47.035612Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-08-03T14:45:47.035617Z 0 [Note] InnoDB: Uses event mutexes 2018-08-03T14:45:47.035620Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2018-08-03T14:45:47.035625Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2018-08-03T14:45:47.035628Z 0 [Note] InnoDB: Using Linux native AIO 2018-08-03T14:45:47.035843Z 0 [Note] InnoDB: Number of pools: 1 2018-08-03T14:45:47.035971Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-08-03T14:45:47.037804Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-08-03T14:45:47.045388Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-08-03T14:45:47.047102Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-08-03T14:45:47.059264Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-08-03T14:45:47.097053Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-08-03T14:45:47.097133Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-08-03T14:45:47.247419Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-08-03T14:45:47.248501Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2018-08-03T14:45:47.248524Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-08-03T14:45:47.249117Z 0 [Note] InnoDB: 5.7.23 started; log sequence number 2590154 2018-08-03T14:45:47.249277Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-08-03T14:45:47.249373Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-08-03T14:45:47.250184Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180803 20:15:47 2018-08-03T14:45:47.253552Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2018-08-03T14:45:47.253577Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 2018-08-03T14:45:47.253587Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 2018-08-03T14:45:47.253622Z 0 [Note] Server socket created on IP: '127.0.0.1'. 2018-08-03T14:45:47.253638Z 0 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use 2018-08-03T14:45:47.253642Z 0 [ERROR] Do you already have another mysqld server running on port: 3306 ? 2018-08-03T14:45:47.253659Z 0 [ERROR] Aborting 2018-08-03T14:45:47.253669Z 0 [Note] Binlog end 2018-08-03T14:45:47.253734Z 0 [Note] Shutting down plugin 'ngram' 2018-08-03T14:45:47.253742Z 0 [Note] Shutting down plugin 'partition' 2018-08-03T14:45:47.253747Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2018-08-03T14:45:47.253751Z 0 [Note] Shutting down plugin 'ARCHIVE' 2018-08-03T14:45:47.253755Z 0 [Note] Shutting down plugin 'MEMORY' 2018-08-03T14:45:47.253760Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2018-08-03T14:45:47.253764Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2018-08-03T14:45:47.253768Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2018-08-03T14:45:47.253772Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2018-08-03T14:45:47.253775Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2018-08-03T14:45:47.253777Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2018-08-03T14:45:47.253780Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2018-08-03T14:45:47.253782Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2018-08-03T14:45:47.253785Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2018-08-03T14:45:47.253787Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2018-08-03T14:45:47.253789Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2018-08-03T14:45:47.253792Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2018-08-03T14:45:47.253794Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2018-08-03T14:45:47.253796Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2018-08-03T14:45:47.253799Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2018-08-03T14:45:47.253801Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2018-08-03T14:45:47.253803Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2018-08-03T14:45:47.253806Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2018-08-03T14:45:47.253808Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2018-08-03T14:45:47.253810Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2018-08-03T14:45:47.253813Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2018-08-03T14:45:47.253815Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2018-08-03T14:45:47.253818Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2018-08-03T14:45:47.253820Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2018-08-03T14:45:47.253822Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2018-08-03T14:45:47.253825Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2018-08-03T14:45:47.253827Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2018-08-03T14:45:47.253830Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2018-08-03T14:45:47.253832Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2018-08-03T14:45:47.253834Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2018-08-03T14:45:47.253837Z 0 [Note] Shutting down plugin 'InnoDB' 2018-08-03T14:45:47.253908Z 0 [Note] InnoDB: FTS optimize thread exiting. 2018-08-03T14:45:47.253969Z 0 [Note] InnoDB: Starting shutdown... 2018-08-03T14:45:47.354216Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2018-08-03T14:45:47.354668Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180803 20:15:47 2018-08-03T14:45:49.199787Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2590173 2018-08-03T14:45:49.203992Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-08-03T14:45:49.204013Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2018-08-03T14:45:49.204019Z 0 [Note] Shutting down plugin 'MyISAM' 2018-08-03T14:45:49.204036Z 0 [Note] Shutting down plugin 'CSV' 2018-08-03T14:45:49.204041Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2018-08-03T14:45:49.204099Z 0 [Note] Shutting down plugin 'sha256_password' 2018-08-03T14:45:49.204104Z 0 [Note] Shutting down plugin 'mysql_native_password' 2018-08-03T14:45:49.204277Z 0 [Note] Shutting down plugin 'binlog' 2018-08-03T14:45:49.204537Z 0 [Note] /usr/sbin/mysqld: Shutdown complete 2018-08-03T14:46:17.375028Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2018-08-03T14:46:17.375101Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000) 2018-08-03T14:46:17.529089Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-08-03T14:46:17.530973Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.23-0ubuntu0.16.04.1) starting as process 23390 ... 2018-08-03T14:46:17.535328Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-08-03T14:46:17.535350Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-08-03T14:46:17.535356Z 0 [Note] InnoDB: Uses event mutexes 2018-08-03T14:46:17.535360Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2018-08-03T14:46:17.535364Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2018-08-03T14:46:17.535368Z 0 [Note] InnoDB: Using Linux native AIO 2018-08-03T14:46:17.535572Z 0 [Note] InnoDB: Number of pools: 1 2018-08-03T14:46:17.535658Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-08-03T14:46:17.537547Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-08-03T14:46:17.544612Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-08-03T14:46:17.546482Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-08-03T14:46:17.558589Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-08-03T14:46:17.606533Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-08-03T14:46:17.606600Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-08-03T14:46:17.767895Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-08-03T14:46:17.769145Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2018-08-03T14:46:17.769167Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-08-03T14:46:17.769576Z 0 [Note] InnoDB: Waiting for purge to start 2018-08-03T14:46:17.819806Z 0 [Note] InnoDB: 5.7.23 started; log sequence number 2590173 2018-08-03T14:46:17.820150Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-08-03T14:46:17.820454Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-08-03T14:46:17.822535Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180803 20:16:17 2018-08-03T14:46:17.831596Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2018-08-03T14:46:17.831626Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 2018-08-03T14:46:17.831637Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 2018-08-03T14:46:17.831673Z 0 [Note] Server socket created on IP: '127.0.0.1'. 2018-08-03T14:46:17.831691Z 0 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use 2018-08-03T14:46:17.831708Z 0 [ERROR] Do you already have another mysqld server running on port: 3306 ? 2018-08-03T14:46:17.831725Z 0 [ERROR] Aborting 2018-08-03T14:46:17.831734Z 0 [Note] Binlog end 2018-08-03T14:46:17.831785Z 0 [Note] Shutting down plugin 'ngram' 2018-08-03T14:46:17.831792Z 0 [Note] Shutting down plugin 'partition' 2018-08-03T14:46:17.831797Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2018-08-03T14:46:17.831801Z 0 [Note] Shutting down plugin 'ARCHIVE' 2018-08-03T14:46:17.831805Z 0 [Note] Shutting down plugin 'MEMORY' 2018-08-03T14:46:17.831809Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2018-08-03T14:46:17.831813Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2018-08-03T14:46:17.831817Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2018-08-03T14:46:17.831821Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2018-08-03T14:46:17.831825Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2018-08-03T14:46:17.831829Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2018-08-03T14:46:17.831833Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2018-08-03T14:46:17.831837Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2018-08-03T14:46:17.831841Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2018-08-03T14:46:17.831844Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2018-08-03T14:46:17.831848Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2018-08-03T14:46:17.831852Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2018-08-03T14:46:17.831856Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2018-08-03T14:46:17.831860Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2018-08-03T14:46:17.831864Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2018-08-03T14:46:17.831868Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2018-08-03T14:46:17.831871Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2018-08-03T14:46:17.831875Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2018-08-03T14:46:17.831879Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2018-08-03T14:46:17.831883Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2018-08-03T14:46:17.831887Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2018-08-03T14:46:17.831891Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2018-08-03T14:46:17.831894Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2018-08-03T14:46:17.831898Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2018-08-03T14:46:17.831902Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2018-08-03T14:46:17.831906Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2018-08-03T14:46:17.831910Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2018-08-03T14:46:17.831914Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2018-08-03T14:46:17.831917Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2018-08-03T14:46:17.831921Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2018-08-03T14:46:17.831925Z 0 [Note] Shutting down plugin 'InnoDB' 2018-08-03T14:46:17.832019Z 0 [Note] InnoDB: FTS optimize thread exiting. 2018-08-03T14:46:17.832092Z 0 [Note] InnoDB: Starting shutdown... 2018-08-03T14:46:17.932460Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2018-08-03T14:46:17.932770Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180803 20:16:17 2018-08-03T14:46:19.673692Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2590192 2018-08-03T14:46:19.675650Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-08-03T14:46:19.675672Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2018-08-03T14:46:19.675677Z 0 [Note] Shutting down plugin 'MyISAM' 2018-08-03T14:46:19.675691Z 0 [Note] Shutting down plugin 'CSV' 2018-08-03T14:46:19.675695Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2018-08-03T14:46:19.675739Z 0 [Note] Shutting down plugin 'sha256_password' 2018-08-03T14:46:19.675742Z 0 [Note] Shutting down plugin 'mysql_native_password' 2018-08-03T14:46:19.675897Z 0 [Note] Shutting down plugin 'binlog' 2018-08-03T14:46:19.676171Z 0 [Note] /usr/sbin/mysqld: Shutdown complete 2018-08-03T14:46:47.877713Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2018-08-03T14:46:47.877766Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000) 2018-08-03T14:46:48.037398Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-08-03T14:46:48.039160Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.23-0ubuntu0.16.04.1) starting as process 23553 ... 2018-08-03T14:46:48.043218Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-08-03T14:46:48.043238Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-08-03T14:46:48.043243Z 0 [Note] InnoDB: Uses event mutexes 2018-08-03T14:46:48.043247Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2018-08-03T14:46:48.043251Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2018-08-03T14:46:48.043255Z 0 [Note] InnoDB: Using Linux native AIO 2018-08-03T14:46:48.043464Z 0 [Note] InnoDB: Number of pools: 1 2018-08-03T14:46:48.043547Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-08-03T14:46:48.045033Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-08-03T14:46:48.052599Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-08-03T14:46:48.054398Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-08-03T14:46:48.066873Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-08-03T14:46:48.237211Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-08-03T14:46:48.237281Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-08-03T14:46:48.388099Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-08-03T14:46:48.389196Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2018-08-03T14:46:48.389210Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-08-03T14:46:48.389609Z 0 [Note] InnoDB: Waiting for purge to start 2018-08-03T14:46:48.439906Z 0 [Note] InnoDB: 5.7.23 started; log sequence number 2590192 2018-08-03T14:46:48.440197Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-08-03T14:46:48.440385Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-08-03T14:46:48.441736Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180803 20:16:48 2018-08-03T14:46:48.448811Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2018-08-03T14:46:48.448854Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 2018-08-03T14:46:48.448872Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 2018-08-03T14:46:48.448927Z 0 [Note] Server socket created on IP: '127.0.0.1'. 2018-08-03T14:46:48.448953Z 0 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use 2018-08-03T14:46:48.448961Z 0 [ERROR] Do you already have another mysqld server running on port: 3306 ? 2018-08-03T14:46:48.448985Z 0 [ERROR] Aborting 2018-08-03T14:46:48.448999Z 0 [Note] Binlog end 2018-08-03T14:46:48.449090Z 0 [Note] Shutting down plugin 'ngram' 2018-08-03T14:46:48.449110Z 0 [Note] Shutting down plugin 'partition' 2018-08-03T14:46:48.449122Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2018-08-03T14:46:48.449134Z 0 [Note] Shutting down plugin 'ARCHIVE' 2018-08-03T14:46:48.449145Z 0 [Note] Shutting down plugin 'MEMORY' 2018-08-03T14:46:48.449156Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2018-08-03T14:46:48.449168Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2018-08-03T14:46:48.449179Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2018-08-03T14:46:48.449186Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2018-08-03T14:46:48.449193Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2018-08-03T14:46:48.449200Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2018-08-03T14:46:48.449207Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2018-08-03T14:46:48.449231Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2018-08-03T14:46:48.449238Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2018-08-03T14:46:48.449244Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2018-08-03T14:46:48.449250Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2018-08-03T14:46:48.449257Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2018-08-03T14:46:48.449263Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2018-08-03T14:46:48.449269Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2018-08-03T14:46:48.449275Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2018-08-03T14:46:48.449281Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2018-08-03T14:46:48.449287Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2018-08-03T14:46:48.449293Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2018-08-03T14:46:48.449300Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2018-08-03T14:46:48.449306Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2018-08-03T14:46:48.449312Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2018-08-03T14:46:48.449318Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2018-08-03T14:46:48.449324Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2018-08-03T14:46:48.449330Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2018-08-03T14:46:48.449337Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2018-08-03T14:46:48.449343Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2018-08-03T14:46:48.449349Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2018-08-03T14:46:48.449355Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2018-08-03T14:46:48.449361Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2018-08-03T14:46:48.449367Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2018-08-03T14:46:48.449373Z 0 [Note] Shutting down plugin 'InnoDB' 2018-08-03T14:46:48.449478Z 0 [Note] InnoDB: FTS optimize thread exiting. 2018-08-03T14:46:48.449595Z 0 [Note] InnoDB: Starting shutdown... 2018-08-03T14:46:48.549911Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2018-08-03T14:46:48.550385Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180803 20:16:48 2018-08-03T14:46:50.294954Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2590227 2018-08-03T14:46:50.297361Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-08-03T14:46:50.297371Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2018-08-03T14:46:50.297375Z 0 [Note] Shutting down plugin 'MyISAM' 2018-08-03T14:46:50.297388Z 0 [Note] Shutting down plugin 'CSV' 2018-08-03T14:46:50.297391Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2018-08-03T14:46:50.297431Z 0 [Note] Shutting down plugin 'sha256_password' 2018-08-03T14:46:50.297434Z 0 [Note] Shutting down plugin 'mysql_native_password' 2018-08-03T14:46:50.297554Z 0 [Note] Shutting down plugin 'binlog' 2018-08-03T14:46:50.297738Z 0 [Note] /usr/sbin/mysqld: Shutdown complete 2018-08-03T14:47:18.378500Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2018-08-03T14:47:18.378544Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000) 2018-08-03T14:47:18.537369Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-08-03T14:47:18.539368Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.23-0ubuntu0.16.04.1) starting as process 23722 ... 2018-08-03T14:47:18.543943Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-08-03T14:47:18.543968Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-08-03T14:47:18.543972Z 0 [Note] InnoDB: Uses event mutexes 2018-08-03T14:47:18.543975Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2018-08-03T14:47:18.543979Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2018-08-03T14:47:18.543982Z 0 [Note] InnoDB: Using Linux native AIO 2018-08-03T14:47:18.544194Z 0 [Note] InnoDB: Number of pools: 1 2018-08-03T14:47:18.544288Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-08-03T14:47:18.546287Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-08-03T14:47:18.553199Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-08-03T14:47:18.555030Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-08-03T14:47:18.567240Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-08-03T14:47:18.623192Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-08-03T14:47:18.623279Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-08-03T14:47:19.050657Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-08-03T14:47:19.051774Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2018-08-03T14:47:19.051783Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-08-03T14:47:19.052263Z 0 [Note] InnoDB: 5.7.23 started; log sequence number 2590227 2018-08-03T14:47:19.052398Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-08-03T14:47:19.052498Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-08-03T14:47:19.053167Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180803 20:17:19 2018-08-03T14:47:19.056456Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2018-08-03T14:47:19.056478Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 2018-08-03T14:47:19.056486Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 2018-08-03T14:47:19.056507Z 0 [Note] Server socket created on IP: '127.0.0.1'. 2018-08-03T14:47:19.056520Z 0 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use 2018-08-03T14:47:19.056523Z 0 [ERROR] Do you already have another mysqld server running on port: 3306 ? 2018-08-03T14:47:19.056536Z 0 [ERROR] Aborting 2018-08-03T14:47:19.056543Z 0 [Note] Binlog end 2018-08-03T14:47:19.056582Z 0 [Note] Shutting down plugin 'ngram' 2018-08-03T14:47:19.056587Z 0 [Note] Shutting down plugin 'partition' 2018-08-03T14:47:19.056590Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2018-08-03T14:47:19.056593Z 0 [Note] Shutting down plugin 'ARCHIVE' 2018-08-03T14:47:19.056596Z 0 [Note] Shutting down plugin 'MEMORY' 2018-08-03T14:47:19.056599Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2018-08-03T14:47:19.056601Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2018-08-03T14:47:19.056604Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2018-08-03T14:47:19.056607Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2018-08-03T14:47:19.056609Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2018-08-03T14:47:19.056612Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2018-08-03T14:47:19.056614Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2018-08-03T14:47:19.056617Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2018-08-03T14:47:19.056620Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2018-08-03T14:47:19.056622Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2018-08-03T14:47:19.056625Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2018-08-03T14:47:19.056627Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2018-08-03T14:47:19.056630Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2018-08-03T14:47:19.056633Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2018-08-03T14:47:19.056635Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2018-08-03T14:47:19.056638Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2018-08-03T14:47:19.056640Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2018-08-03T14:47:19.056643Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2018-08-03T14:47:19.056645Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2018-08-03T14:47:19.056648Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2018-08-03T14:47:19.056660Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2018-08-03T14:47:19.056662Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2018-08-03T14:47:19.056665Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2018-08-03T14:47:19.056667Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2018-08-03T14:47:19.056669Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2018-08-03T14:47:19.056672Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2018-08-03T14:47:19.056674Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2018-08-03T14:47:19.056676Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2018-08-03T14:47:19.056679Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2018-08-03T14:47:19.056681Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2018-08-03T14:47:19.056683Z 0 [Note] Shutting down plugin 'InnoDB' 2018-08-03T14:47:19.056760Z 0 [Note] InnoDB: FTS optimize thread exiting. 2018-08-03T14:47:19.056817Z 0 [Note] InnoDB: Starting shutdown... 2018-08-03T14:47:19.157440Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2018-08-03T14:47:19.157838Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180803 20:17:19 2018-08-03T14:47:20.801977Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2590246 2018-08-03T14:47:20.804908Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-08-03T14:47:20.804925Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2018-08-03T14:47:20.804929Z 0 [Note] Shutting down plugin 'MyISAM' 2018-08-03T14:47:20.804941Z 0 [Note] Shutting down plugin 'CSV' 2018-08-03T14:47:20.804945Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2018-08-03T14:47:20.804984Z 0 [Note] Shutting down plugin 'sha256_password' 2018-08-03T14:47:20.804987Z 0 [Note] Shutting down plugin 'mysql_native_password' 2018-08-03T14:47:20.805105Z 0 [Note] Shutting down plugin 'binlog' 2018-08-03T14:47:20.805315Z 0 [Note] /usr/sbin/mysqld: Shutdown complete 2018-08-03T14:47:48.877058Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2018-08-03T14:47:48.877134Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000) 2018-08-03T14:47:49.029963Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-08-03T14:47:49.031635Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.23-0ubuntu0.16.04.1) starting as process 23881 ... 2018-08-03T14:47:49.035827Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-08-03T14:47:49.035851Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-08-03T14:47:49.035857Z 0 [Note] InnoDB: Uses event mutexes 2018-08-03T14:47:49.035861Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2018-08-03T14:47:49.035864Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2018-08-03T14:47:49.035868Z 0 [Note] InnoDB: Using Linux native AIO 2018-08-03T14:47:49.036073Z 0 [Note] InnoDB: Number of pools: 1 2018-08-03T14:47:49.036157Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-08-03T14:47:49.037781Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-08-03T14:47:49.044923Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-08-03T14:47:49.046732Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-08-03T14:47:49.058695Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-08-03T14:47:49.096162Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-08-03T14:47:49.096227Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-08-03T14:47:49.258958Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-08-03T14:47:49.260064Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2018-08-03T14:47:49.260077Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-08-03T14:47:49.260413Z 0 [Note] InnoDB: Waiting for purge to start 2018-08-03T14:47:49.310710Z 0 [Note] InnoDB: 5.7.23 started; log sequence number 2590246 2018-08-03T14:47:49.311024Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-08-03T14:47:49.311256Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-08-03T14:47:49.312842Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180803 20:17:49 2018-08-03T14:47:49.319961Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2018-08-03T14:47:49.320005Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 2018-08-03T14:47:49.320031Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 2018-08-03T14:47:49.320087Z 0 [Note] Server socket created on IP: '127.0.0.1'. 2018-08-03T14:47:49.320113Z 0 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use 2018-08-03T14:47:49.320120Z 0 [ERROR] Do you already have another mysqld server running on port: 3306 ? 2018-08-03T14:47:49.320144Z 0 [ERROR] Aborting 2018-08-03T14:47:49.320158Z 0 [Note] Binlog end 2018-08-03T14:47:49.320236Z 0 [Note] Shutting down plugin 'ngram' 2018-08-03T14:47:49.320247Z 0 [Note] Shutting down plugin 'partition' 2018-08-03T14:47:49.320254Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2018-08-03T14:47:49.320261Z 0 [Note] Shutting down plugin 'ARCHIVE' 2018-08-03T14:47:49.320267Z 0 [Note] Shutting down plugin 'MEMORY' 2018-08-03T14:47:49.320274Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2018-08-03T14:47:49.320281Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2018-08-03T14:47:49.320287Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2018-08-03T14:47:49.320293Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2018-08-03T14:47:49.320299Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2018-08-03T14:47:49.320305Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2018-08-03T14:47:49.320311Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2018-08-03T14:47:49.320317Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2018-08-03T14:47:49.320323Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2018-08-03T14:47:49.320329Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2018-08-03T14:47:49.320335Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2018-08-03T14:47:49.320341Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2018-08-03T14:47:49.320347Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2018-08-03T14:47:49.320353Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2018-08-03T14:47:49.320359Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2018-08-03T14:47:49.320365Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2018-08-03T14:47:49.320371Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2018-08-03T14:47:49.320377Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2018-08-03T14:47:49.320383Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2018-08-03T14:47:49.320390Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2018-08-03T14:47:49.320395Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2018-08-03T14:47:49.320402Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2018-08-03T14:47:49.320408Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2018-08-03T14:47:49.320414Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2018-08-03T14:47:49.320420Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2018-08-03T14:47:49.320426Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2018-08-03T14:47:49.320432Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2018-08-03T14:47:49.320438Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2018-08-03T14:47:49.320444Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2018-08-03T14:47:49.320450Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2018-08-03T14:47:49.320456Z 0 [Note] Shutting down plugin 'InnoDB' 2018-08-03T14:47:49.320590Z 0 [Note] InnoDB: FTS optimize thread exiting. 2018-08-03T14:47:49.320751Z 0 [Note] InnoDB: Starting shutdown... 2018-08-03T14:47:49.421150Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2018-08-03T14:47:49.421571Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180803 20:17:49 2018-08-03T14:47:51.165502Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2590265 2018-08-03T14:47:51.170010Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-08-03T14:47:51.170045Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2018-08-03T14:47:51.170056Z 0 [Note] Shutting down plugin 'MyISAM' 2018-08-03T14:47:51.170084Z 0 [Note] Shutting down plugin 'CSV' 2018-08-03T14:47:51.170095Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2018-08-03T14:47:51.170192Z 0 [Note] Shutting down plugin 'sha256_password' 2018-08-03T14:47:51.170200Z 0 [Note] Shutting down plugin 'mysql_native_password' 2018-08-03T14:47:51.170494Z 0 [Note] Shutting down plugin 'binlog' 2018-08-03T14:47:51.170960Z 0 [Note] /usr/sbin/mysqld: Shutdown complete 2018-08-03T14:48:19.378012Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2018-08-03T14:48:19.378053Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000) 2018-08-03T14:48:19.529737Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-08-03T14:48:19.531498Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.23-0ubuntu0.16.04.1) starting as process 24045 ... 2018-08-03T14:48:19.535681Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-08-03T14:48:19.535706Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-08-03T14:48:19.535712Z 0 [Note] InnoDB: Uses event mutexes 2018-08-03T14:48:19.535716Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2018-08-03T14:48:19.535719Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2018-08-03T14:48:19.535723Z 0 [Note] InnoDB: Using Linux native AIO 2018-08-03T14:48:19.535950Z 0 [Note] InnoDB: Number of pools: 1 2018-08-03T14:48:19.536033Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-08-03T14:48:19.537647Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-08-03T14:48:19.545173Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-08-03T14:48:19.546966Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-08-03T14:48:19.559528Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-08-03T14:48:19.608869Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-08-03T14:48:19.608987Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-08-03T14:48:19.765093Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-08-03T14:48:19.767020Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2018-08-03T14:48:19.767045Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-08-03T14:48:19.767938Z 0 [Note] InnoDB: Waiting for purge to start 2018-08-03T14:48:19.818297Z 0 [Note] InnoDB: 5.7.23 started; log sequence number 2590265 2018-08-03T14:48:19.818644Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-08-03T14:48:19.818956Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-08-03T14:48:19.821060Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180803 20:18:19 2018-08-03T14:48:19.829969Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2018-08-03T14:48:19.830014Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 2018-08-03T14:48:19.830032Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 2018-08-03T14:48:19.830078Z 0 [Note] Server socket created on IP: '127.0.0.1'. 2018-08-03T14:48:19.830105Z 0 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use 2018-08-03T14:48:19.830113Z 0 [ERROR] Do you already have another mysqld server running on port: 3306 ? 2018-08-03T14:48:19.830139Z 0 [ERROR] Aborting 2018-08-03T14:48:19.830154Z 0 [Note] Binlog end 2018-08-03T14:48:19.830259Z 0 [Note] Shutting down plugin 'ngram' 2018-08-03T14:48:19.830273Z 0 [Note] Shutting down plugin 'partition' 2018-08-03T14:48:19.830280Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2018-08-03T14:48:19.830288Z 0 [Note] Shutting down plugin 'ARCHIVE' 2018-08-03T14:48:19.830295Z 0 [Note] Shutting down plugin 'MEMORY' 2018-08-03T14:48:19.830303Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2018-08-03T14:48:19.830311Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2018-08-03T14:48:19.830317Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2018-08-03T14:48:19.830324Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2018-08-03T14:48:19.830331Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2018-08-03T14:48:19.830338Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2018-08-03T14:48:19.830345Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2018-08-03T14:48:19.830351Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2018-08-03T14:48:19.830358Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2018-08-03T14:48:19.830365Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2018-08-03T14:48:19.830371Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2018-08-03T14:48:19.830378Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2018-08-03T14:48:19.830385Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2018-08-03T14:48:19.830392Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2018-08-03T14:48:19.830399Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2018-08-03T14:48:19.830405Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2018-08-03T14:48:19.830412Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2018-08-03T14:48:19.830419Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2018-08-03T14:48:19.830426Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2018-08-03T14:48:19.830433Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2018-08-03T14:48:19.830439Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2018-08-03T14:48:19.830446Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2018-08-03T14:48:19.830453Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2018-08-03T14:48:19.830460Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2018-08-03T14:48:19.830466Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2018-08-03T14:48:19.830473Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2018-08-03T14:48:19.830480Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2018-08-03T14:48:19.830487Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2018-08-03T14:48:19.830493Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2018-08-03T14:48:19.830500Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2018-08-03T14:48:19.830507Z 0 [Note] Shutting down plugin 'InnoDB' 2018-08-03T14:48:19.830610Z 0 [Note] InnoDB: FTS optimize thread exiting. 2018-08-03T14:48:19.830686Z 0 [Note] InnoDB: Starting shutdown... 2018-08-03T14:48:19.931221Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2018-08-03T14:48:19.931670Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180803 20:18:19 2018-08-03T14:48:21.671404Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2590284 2018-08-03T14:48:21.674900Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-08-03T14:48:21.674929Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2018-08-03T14:48:21.674938Z 0 [Note] Shutting down plugin 'MyISAM' 2018-08-03T14:48:21.674962Z 0 [Note] Shutting down plugin 'CSV' 2018-08-03T14:48:21.674970Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2018-08-03T14:48:21.675047Z 0 [Note] Shutting down plugin 'sha256_password' 2018-08-03T14:48:21.675054Z 0 [Note] Shutting down plugin 'mysql_native_password' 2018-08-03T14:48:21.675313Z 0 [Note] Shutting down plugin 'binlog' 2018-08-03T14:48:21.675694Z 0 [Note] /usr/sbin/mysqld: Shutdown complete 2018-08-03T14:48:49.877069Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2018-08-03T14:48:49.877114Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000) 2018-08-03T14:48:50.029524Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-08-03T14:48:50.031188Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.23-0ubuntu0.16.04.1) starting as process 24219 ... 2018-08-03T14:48:50.035466Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-08-03T14:48:50.035490Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-08-03T14:48:50.035494Z 0 [Note] InnoDB: Uses event mutexes 2018-08-03T14:48:50.035498Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2018-08-03T14:48:50.035501Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2018-08-03T14:48:50.035505Z 0 [Note] InnoDB: Using Linux native AIO 2018-08-03T14:48:50.035712Z 0 [Note] InnoDB: Number of pools: 1 2018-08-03T14:48:50.035796Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-08-03T14:48:50.037471Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-08-03T14:48:50.044580Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-08-03T14:48:50.046323Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-08-03T14:48:50.058907Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-08-03T14:48:50.099323Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-08-03T14:48:50.099412Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-08-03T14:48:50.260768Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-08-03T14:48:50.261875Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2018-08-03T14:48:50.261888Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-08-03T14:48:50.262307Z 0 [Note] InnoDB: 5.7.23 started; log sequence number 2590284 2018-08-03T14:48:50.262414Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-08-03T14:48:50.262537Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-08-03T14:48:50.263311Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180803 20:18:50 2018-08-03T14:48:50.266735Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2018-08-03T14:48:50.266756Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 2018-08-03T14:48:50.266764Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 2018-08-03T14:48:50.266789Z 0 [Note] Server socket created on IP: '127.0.0.1'. 2018-08-03T14:48:50.266801Z 0 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use 2018-08-03T14:48:50.266803Z 0 [ERROR] Do you already have another mysqld server running on port: 3306 ? 2018-08-03T14:48:50.266815Z 0 [ERROR] Aborting 2018-08-03T14:48:50.266821Z 0 [Note] Binlog end 2018-08-03T14:48:50.266856Z 0 [Note] Shutting down plugin 'ngram' 2018-08-03T14:48:50.266860Z 0 [Note] Shutting down plugin 'partition' 2018-08-03T14:48:50.266863Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2018-08-03T14:48:50.266866Z 0 [Note] Shutting down plugin 'ARCHIVE' 2018-08-03T14:48:50.266868Z 0 [Note] Shutting down plugin 'MEMORY' 2018-08-03T14:48:50.266871Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2018-08-03T14:48:50.266873Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2018-08-03T14:48:50.266876Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2018-08-03T14:48:50.266878Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2018-08-03T14:48:50.266880Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2018-08-03T14:48:50.266883Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2018-08-03T14:48:50.266885Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2018-08-03T14:48:50.266887Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2018-08-03T14:48:50.266890Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2018-08-03T14:48:50.266892Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2018-08-03T14:48:50.266902Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2018-08-03T14:48:50.266905Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2018-08-03T14:48:50.266907Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2018-08-03T14:48:50.266909Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2018-08-03T14:48:50.266912Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2018-08-03T14:48:50.266914Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2018-08-03T14:48:50.266916Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2018-08-03T14:48:50.266919Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2018-08-03T14:48:50.266921Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2018-08-03T14:48:50.266923Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2018-08-03T14:48:50.266925Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2018-08-03T14:48:50.266928Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2018-08-03T14:48:50.266930Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2018-08-03T14:48:50.266932Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2018-08-03T14:48:50.266935Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2018-08-03T14:48:50.266937Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2018-08-03T14:48:50.266939Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2018-08-03T14:48:50.266942Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2018-08-03T14:48:50.266944Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2018-08-03T14:48:50.266946Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2018-08-03T14:48:50.266949Z 0 [Note] Shutting down plugin 'InnoDB' 2018-08-03T14:48:50.267022Z 0 [Note] InnoDB: FTS optimize thread exiting. 2018-08-03T14:48:50.267075Z 0 [Note] InnoDB: Starting shutdown... 2018-08-03T14:48:50.367314Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2018-08-03T14:48:50.367653Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180803 20:18:50 2018-08-03T14:48:52.212257Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2590303 2018-08-03T14:48:52.216306Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-08-03T14:48:52.216328Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2018-08-03T14:48:52.216334Z 0 [Note] Shutting down plugin 'MyISAM' 2018-08-03T14:48:52.216351Z 0 [Note] Shutting down plugin 'CSV' 2018-08-03T14:48:52.216358Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2018-08-03T14:48:52.216424Z 0 [Note] Shutting down plugin 'sha256_password' 2018-08-03T14:48:52.216427Z 0 [Note] Shutting down plugin 'mysql_native_password' 2018-08-03T14:48:52.216577Z 0 [Note] Shutting down plugin 'binlog' 2018-08-03T14:48:52.216794Z 0 [Note] /usr/sbin/mysqld: Shutdown complete 2018-08-03T14:49:20.376732Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2018-08-03T14:49:20.376808Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000) 2018-08-03T14:49:20.529475Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-08-03T14:49:20.531115Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.23-0ubuntu0.16.04.1) starting as process 24423 ... 2018-08-03T14:49:20.535313Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-08-03T14:49:20.535338Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-08-03T14:49:20.535343Z 0 [Note] InnoDB: Uses event mutexes 2018-08-03T14:49:20.535347Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2018-08-03T14:49:20.535351Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2018-08-03T14:49:20.535355Z 0 [Note] InnoDB: Using Linux native AIO 2018-08-03T14:49:20.535560Z 0 [Note] InnoDB: Number of pools: 1 2018-08-03T14:49:20.535643Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-08-03T14:49:20.537244Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-08-03T14:49:20.544967Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-08-03T14:49:20.546844Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-08-03T14:49:20.558343Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-08-03T14:49:20.608354Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-08-03T14:49:20.608424Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-08-03T14:49:20.769949Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-08-03T14:49:20.771048Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2018-08-03T14:49:20.771060Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-08-03T14:49:20.771731Z 0 [Note] InnoDB: 5.7.23 started; log sequence number 2590303 2018-08-03T14:49:20.772008Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-08-03T14:49:20.775284Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-08-03T14:49:20.776092Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180803 20:19:20 2018-08-03T14:49:20.776254Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2018-08-03T14:49:20.776269Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 2018-08-03T14:49:20.776277Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 2018-08-03T14:49:20.776299Z 0 [Note] Server socket created on IP: '127.0.0.1'. 2018-08-03T14:49:20.776312Z 0 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use 2018-08-03T14:49:20.776315Z 0 [ERROR] Do you already have another mysqld server running on port: 3306 ? 2018-08-03T14:49:20.776328Z 0 [ERROR] Aborting 2018-08-03T14:49:20.776334Z 0 [Note] Binlog end 2018-08-03T14:49:20.776376Z 0 [Note] Shutting down plugin 'ngram' 2018-08-03T14:49:20.776381Z 0 [Note] Shutting down plugin 'partition' 2018-08-03T14:49:20.776385Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2018-08-03T14:49:20.776388Z 0 [Note] Shutting down plugin 'ARCHIVE' 2018-08-03T14:49:20.776391Z 0 [Note] Shutting down plugin 'MEMORY' 2018-08-03T14:49:20.776394Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2018-08-03T14:49:20.776397Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2018-08-03T14:49:20.776400Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2018-08-03T14:49:20.776403Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2018-08-03T14:49:20.776406Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2018-08-03T14:49:20.776408Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2018-08-03T14:49:20.776411Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2018-08-03T14:49:20.776414Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2018-08-03T14:49:20.776417Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2018-08-03T14:49:20.776419Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2018-08-03T14:49:20.776422Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2018-08-03T14:49:20.776424Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2018-08-03T14:49:20.776427Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2018-08-03T14:49:20.776430Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2018-08-03T14:49:20.776432Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2018-08-03T14:49:20.776435Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2018-08-03T14:49:20.776438Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2018-08-03T14:49:20.776441Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2018-08-03T14:49:20.776443Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2018-08-03T14:49:20.776446Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2018-08-03T14:49:20.776449Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2018-08-03T14:49:20.776451Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2018-08-03T14:49:20.776454Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2018-08-03T14:49:20.776466Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2018-08-03T14:49:20.776469Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2018-08-03T14:49:20.776472Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2018-08-03T14:49:20.776475Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2018-08-03T14:49:20.776477Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2018-08-03T14:49:20.776480Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2018-08-03T14:49:20.776483Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2018-08-03T14:49:20.776485Z 0 [Note] Shutting down plugin 'InnoDB' 2018-08-03T14:49:20.776536Z 0 [Note] InnoDB: FTS optimize thread exiting. 2018-08-03T14:49:20.776585Z 0 [Note] InnoDB: Starting shutdown... 2018-08-03T14:49:20.876901Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2018-08-03T14:49:20.877311Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180803 20:19:20 2018-08-03T14:49:22.720193Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2590322 2018-08-03T14:49:22.724125Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-08-03T14:49:22.724146Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2018-08-03T14:49:22.724152Z 0 [Note] Shutting down plugin 'MyISAM' 2018-08-03T14:49:22.724170Z 0 [Note] Shutting down plugin 'CSV' 2018-08-03T14:49:22.724176Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2018-08-03T14:49:22.724238Z 0 [Note] Shutting down plugin 'sha256_password' 2018-08-03T14:49:22.724241Z 0 [Note] Shutting down plugin 'mysql_native_password' 2018-08-03T14:49:22.724355Z 0 [Note] Shutting down plugin 'binlog' 2018-08-03T14:49:22.724554Z 0 [Note] /usr/sbin/mysqld: Shutdown complete 2018-08-03T14:49:50.878578Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2018-08-03T14:49:50.878658Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000) 2018-08-03T14:49:51.037859Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-08-03T14:49:51.039585Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.23-0ubuntu0.16.04.1) starting as process 24587 ... 2018-08-03T14:49:51.043757Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-08-03T14:49:51.043781Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-08-03T14:49:51.043786Z 0 [Note] InnoDB: Uses event mutexes 2018-08-03T14:49:51.043790Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2018-08-03T14:49:51.043793Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2018-08-03T14:49:51.043798Z 0 [Note] InnoDB: Using Linux native AIO 2018-08-03T14:49:51.044006Z 0 [Note] InnoDB: Number of pools: 1 2018-08-03T14:49:51.044114Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-08-03T14:49:51.045664Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-08-03T14:49:51.053441Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-08-03T14:49:51.055189Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-08-03T14:49:51.067450Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-08-03T14:49:51.193828Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-08-03T14:49:51.193894Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-08-03T14:49:51.355420Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-08-03T14:49:51.356514Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2018-08-03T14:49:51.356528Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-08-03T14:49:51.356992Z 0 [Note] InnoDB: 5.7.23 started; log sequence number 2590322 2018-08-03T14:49:51.357150Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-08-03T14:49:51.357224Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-08-03T14:49:51.357995Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180803 20:19:51 2018-08-03T14:49:51.361403Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2018-08-03T14:49:51.361423Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 2018-08-03T14:49:51.361431Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 2018-08-03T14:49:51.361457Z 0 [Note] Server socket created on IP: '127.0.0.1'. 2018-08-03T14:49:51.361468Z 0 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use 2018-08-03T14:49:51.361471Z 0 [ERROR] Do you already have another mysqld server running on port: 3306 ? 2018-08-03T14:49:51.361482Z 0 [ERROR] Aborting 2018-08-03T14:49:51.361489Z 0 [Note] Binlog end 2018-08-03T14:49:51.361526Z 0 [Note] Shutting down plugin 'ngram' 2018-08-03T14:49:51.361531Z 0 [Note] Shutting down plugin 'partition' 2018-08-03T14:49:51.361534Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2018-08-03T14:49:51.361536Z 0 [Note] Shutting down plugin 'ARCHIVE' 2018-08-03T14:49:51.361539Z 0 [Note] Shutting down plugin 'MEMORY' 2018-08-03T14:49:51.361541Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2018-08-03T14:49:51.361544Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2018-08-03T14:49:51.361546Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2018-08-03T14:49:51.361549Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2018-08-03T14:49:51.361551Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2018-08-03T14:49:51.361553Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2018-08-03T14:49:51.361556Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2018-08-03T14:49:51.361558Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2018-08-03T14:49:51.361560Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2018-08-03T14:49:51.361562Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2018-08-03T14:49:51.361565Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2018-08-03T14:49:51.361567Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2018-08-03T14:49:51.361570Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2018-08-03T14:49:51.361572Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2018-08-03T14:49:51.361574Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2018-08-03T14:49:51.361577Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2018-08-03T14:49:51.361579Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2018-08-03T14:49:51.361581Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2018-08-03T14:49:51.361584Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2018-08-03T14:49:51.361586Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2018-08-03T14:49:51.361588Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2018-08-03T14:49:51.361590Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2018-08-03T14:49:51.361593Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2018-08-03T14:49:51.361595Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2018-08-03T14:49:51.361598Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2018-08-03T14:49:51.361600Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2018-08-03T14:49:51.361602Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2018-08-03T14:49:51.361604Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2018-08-03T14:49:51.361607Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2018-08-03T14:49:51.361609Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2018-08-03T14:49:51.361611Z 0 [Note] Shutting down plugin 'InnoDB' 2018-08-03T14:49:51.361660Z 0 [Note] InnoDB: FTS optimize thread exiting. 2018-08-03T14:49:51.361730Z 0 [Note] InnoDB: Starting shutdown... 2018-08-03T14:49:51.462162Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2018-08-03T14:49:51.462374Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180803 20:19:51 2018-08-03T14:49:53.306963Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2590341 2018-08-03T14:49:53.311541Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-08-03T14:49:53.311567Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2018-08-03T14:49:53.311574Z 0 [Note] Shutting down plugin 'MyISAM' 2018-08-03T14:49:53.311590Z 0 [Note] Shutting down plugin 'CSV' 2018-08-03T14:49:53.311596Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2018-08-03T14:49:53.311657Z 0 [Note] Shutting down plugin 'sha256_password' 2018-08-03T14:49:53.311662Z 0 [Note] Shutting down plugin 'mysql_native_password' 2018-08-03T14:49:53.311836Z 0 [Note] Shutting down plugin 'binlog' 2018-08-03T14:49:53.312120Z 0 [Note] /usr/sbin/mysqld: Shutdown complete 2018-08-03T14:50:21.371050Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2018-08-03T14:50:21.371130Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000) 2018-08-03T14:50:21.529210Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-08-03T14:50:21.530824Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.23-0ubuntu0.16.04.1) starting as process 24752 ... 2018-08-03T14:50:21.535204Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-08-03T14:50:21.535228Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-08-03T14:50:21.535232Z 0 [Note] InnoDB: Uses event mutexes 2018-08-03T14:50:21.535236Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2018-08-03T14:50:21.535240Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2018-08-03T14:50:21.535244Z 0 [Note] InnoDB: Using Linux native AIO 2018-08-03T14:50:21.535452Z 0 [Note] InnoDB: Number of pools: 1 2018-08-03T14:50:21.535535Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-08-03T14:50:21.537099Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-08-03T14:50:21.544368Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-08-03T14:50:21.546113Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-08-03T14:50:21.558086Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-08-03T14:50:21.610987Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-08-03T14:50:21.611059Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-08-03T14:50:21.772496Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-08-03T14:50:21.773597Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2018-08-03T14:50:21.773610Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-08-03T14:50:21.774000Z 0 [Note] InnoDB: Waiting for purge to start 2018-08-03T14:50:21.824250Z 0 [Note] InnoDB: 5.7.23 started; log sequence number 2590341 2018-08-03T14:50:21.824552Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-08-03T14:50:21.824860Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-08-03T14:50:21.826719Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180803 20:20:21 2018-08-03T14:50:21.834238Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2018-08-03T14:50:21.834298Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 2018-08-03T14:50:21.834316Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 2018-08-03T14:50:21.834374Z 0 [Note] Server socket created on IP: '127.0.0.1'. 2018-08-03T14:50:21.834401Z 0 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use 2018-08-03T14:50:21.834408Z 0 [ERROR] Do you already have another mysqld server running on port: 3306 ? 2018-08-03T14:50:21.834432Z 0 [ERROR] Aborting 2018-08-03T14:50:21.834446Z 0 [Note] Binlog end 2018-08-03T14:50:21.834549Z 0 [Note] Shutting down plugin 'ngram' 2018-08-03T14:50:21.834568Z 0 [Note] Shutting down plugin 'partition' 2018-08-03T14:50:21.834580Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2018-08-03T14:50:21.834592Z 0 [Note] Shutting down plugin 'ARCHIVE' 2018-08-03T14:50:21.834626Z 0 [Note] Shutting down plugin 'MEMORY' 2018-08-03T14:50:21.834639Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2018-08-03T14:50:21.834651Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2018-08-03T14:50:21.834662Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2018-08-03T14:50:21.834673Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2018-08-03T14:50:21.834682Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2018-08-03T14:50:21.834689Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2018-08-03T14:50:21.834696Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2018-08-03T14:50:21.834702Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2018-08-03T14:50:21.834709Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2018-08-03T14:50:21.834716Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2018-08-03T14:50:21.834723Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2018-08-03T14:50:21.834729Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2018-08-03T14:50:21.834736Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2018-08-03T14:50:21.834743Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2018-08-03T14:50:21.834749Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2018-08-03T14:50:21.834756Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2018-08-03T14:50:21.834763Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2018-08-03T14:50:21.834770Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2018-08-03T14:50:21.834776Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2018-08-03T14:50:21.834783Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2018-08-03T14:50:21.834790Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2018-08-03T14:50:21.834796Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2018-08-03T14:50:21.834803Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2018-08-03T14:50:21.834810Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2018-08-03T14:50:21.834816Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2018-08-03T14:50:21.834823Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2018-08-03T14:50:21.834830Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2018-08-03T14:50:21.834837Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2018-08-03T14:50:21.834843Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2018-08-03T14:50:21.834851Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2018-08-03T14:50:21.834858Z 0 [Note] Shutting down plugin 'InnoDB' 2018-08-03T14:50:21.834974Z 0 [Note] InnoDB: FTS optimize thread exiting. 2018-08-03T14:50:21.835194Z 0 [Note] InnoDB: Starting shutdown... 2018-08-03T14:50:21.935414Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2018-08-03T14:50:21.935756Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180803 20:20:21 2018-08-03T14:50:23.677304Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2590360 2018-08-03T14:50:23.679642Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-08-03T14:50:23.679669Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2018-08-03T14:50:23.679674Z 0 [Note] Shutting down plugin 'MyISAM' 2018-08-03T14:50:23.679689Z 0 [Note] Shutting down plugin 'CSV' 2018-08-03T14:50:23.679694Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2018-08-03T14:50:23.679737Z 0 [Note] Shutting down plugin 'sha256_password' 2018-08-03T14:50:23.679741Z 0 [Note] Shutting down plugin 'mysql_native_password' 2018-08-03T14:50:23.679873Z 0 [Note] Shutting down plugin 'binlog' 2018-08-03T14:50:23.680121Z 0 [Note] /usr/sbin/mysqld: Shutdown complete 2018-08-03T14:50:51.878297Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2018-08-03T14:50:51.878338Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000) 2018-08-03T14:50:52.030933Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-08-03T14:50:52.032572Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.23-0ubuntu0.16.04.1) starting as process 24931 ... 2018-08-03T14:50:52.036573Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-08-03T14:50:52.036599Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-08-03T14:50:52.036603Z 0 [Note] InnoDB: Uses event mutexes 2018-08-03T14:50:52.036607Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2018-08-03T14:50:52.036611Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2018-08-03T14:50:52.036614Z 0 [Note] InnoDB: Using Linux native AIO 2018-08-03T14:50:52.036819Z 0 [Note] InnoDB: Number of pools: 1 2018-08-03T14:50:52.036903Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-08-03T14:50:52.038543Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-08-03T14:50:52.046055Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-08-03T14:50:52.047884Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-08-03T14:50:52.059964Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-08-03T14:50:52.109119Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-08-03T14:50:52.109203Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-08-03T14:50:52.270477Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-08-03T14:50:52.271608Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2018-08-03T14:50:52.271624Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-08-03T14:50:52.272208Z 0 [Note] InnoDB: 5.7.23 started; log sequence number 2590360 2018-08-03T14:50:52.272322Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-08-03T14:50:52.272460Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-08-03T14:50:52.273305Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180803 20:20:52 2018-08-03T14:50:52.276569Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2018-08-03T14:50:52.276591Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 2018-08-03T14:50:52.276599Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 2018-08-03T14:50:52.276627Z 0 [Note] Server socket created on IP: '127.0.0.1'. 2018-08-03T14:50:52.276641Z 0 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use 2018-08-03T14:50:52.276644Z 0 [ERROR] Do you already have another mysqld server running on port: 3306 ? 2018-08-03T14:50:52.276656Z 0 [ERROR] Aborting 2018-08-03T14:50:52.276663Z 0 [Note] Binlog end 2018-08-03T14:50:52.276701Z 0 [Note] Shutting down plugin 'ngram' 2018-08-03T14:50:52.276707Z 0 [Note] Shutting down plugin 'partition' 2018-08-03T14:50:52.276709Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2018-08-03T14:50:52.276712Z 0 [Note] Shutting down plugin 'ARCHIVE' 2018-08-03T14:50:52.276715Z 0 [Note] Shutting down plugin 'MEMORY' 2018-08-03T14:50:52.276718Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2018-08-03T14:50:52.276721Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2018-08-03T14:50:52.276723Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2018-08-03T14:50:52.276726Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2018-08-03T14:50:52.276728Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2018-08-03T14:50:52.276731Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2018-08-03T14:50:52.276733Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2018-08-03T14:50:52.276736Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2018-08-03T14:50:52.276738Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2018-08-03T14:50:52.276740Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2018-08-03T14:50:52.276743Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2018-08-03T14:50:52.276745Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2018-08-03T14:50:52.276748Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2018-08-03T14:50:52.276750Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2018-08-03T14:50:52.276761Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2018-08-03T14:50:52.276763Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2018-08-03T14:50:52.276766Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2018-08-03T14:50:52.276768Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2018-08-03T14:50:52.276770Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2018-08-03T14:50:52.276773Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2018-08-03T14:50:52.276775Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2018-08-03T14:50:52.276778Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2018-08-03T14:50:52.276780Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2018-08-03T14:50:52.276782Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2018-08-03T14:50:52.276785Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2018-08-03T14:50:52.276787Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2018-08-03T14:50:52.276790Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2018-08-03T14:50:52.276792Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2018-08-03T14:50:52.276795Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2018-08-03T14:50:52.276797Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2018-08-03T14:50:52.276800Z 0 [Note] Shutting down plugin 'InnoDB' 2018-08-03T14:50:52.276875Z 0 [Note] InnoDB: FTS optimize thread exiting. 2018-08-03T14:50:52.276935Z 0 [Note] InnoDB: Starting shutdown... 2018-08-03T14:50:52.377288Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2018-08-03T14:50:52.377814Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180803 20:20:52 2018-08-03T14:50:54.222630Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2590379 2018-08-03T14:50:54.225177Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-08-03T14:50:54.225192Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2018-08-03T14:50:54.225196Z 0 [Note] Shutting down plugin 'MyISAM' 2018-08-03T14:50:54.225209Z 0 [Note] Shutting down plugin 'CSV' 2018-08-03T14:50:54.225213Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2018-08-03T14:50:54.225252Z 0 [Note] Shutting down plugin 'sha256_password' 2018-08-03T14:50:54.225255Z 0 [Note] Shutting down plugin 'mysql_native_password' 2018-08-03T14:50:54.225370Z 0 [Note] Shutting down plugin 'binlog' 2018-08-03T14:50:54.225581Z 0 [Note] /usr/sbin/mysqld: Shutdown complete 2018-08-03T14:51:22.377038Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2018-08-03T14:51:22.377094Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000) 2018-08-03T14:51:22.529353Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-08-03T14:51:22.531092Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.23-0ubuntu0.16.04.1) starting as process 25111 ... 2018-08-03T14:51:22.535241Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-08-03T14:51:22.535265Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-08-03T14:51:22.535269Z 0 [Note] InnoDB: Uses event mutexes 2018-08-03T14:51:22.535272Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2018-08-03T14:51:22.535276Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2018-08-03T14:51:22.535279Z 0 [Note] InnoDB: Using Linux native AIO 2018-08-03T14:51:22.535510Z 0 [Note] InnoDB: Number of pools: 1 2018-08-03T14:51:22.535593Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-08-03T14:51:22.537290Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-08-03T14:51:22.544416Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-08-03T14:51:22.546187Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-08-03T14:51:22.558257Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-08-03T14:51:22.607274Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-08-03T14:51:22.607347Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-08-03T14:51:22.779406Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-08-03T14:51:22.780528Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2018-08-03T14:51:22.780547Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-08-03T14:51:22.780904Z 0 [Note] InnoDB: Waiting for purge to start 2018-08-03T14:51:22.831072Z 0 [Note] InnoDB: 5.7.23 started; log sequence number 2590379 2018-08-03T14:51:22.831256Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-08-03T14:51:22.831355Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-08-03T14:51:22.832316Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180803 20:21:22 2018-08-03T14:51:22.835393Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2018-08-03T14:51:22.835415Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 2018-08-03T14:51:22.835424Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 2018-08-03T14:51:22.835450Z 0 [Note] Server socket created on IP: '127.0.0.1'. 2018-08-03T14:51:22.835463Z 0 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use 2018-08-03T14:51:22.835466Z 0 [ERROR] Do you already have another mysqld server running on port: 3306 ? 2018-08-03T14:51:22.835478Z 0 [ERROR] Aborting 2018-08-03T14:51:22.835484Z 0 [Note] Binlog end 2018-08-03T14:51:22.835523Z 0 [Note] Shutting down plugin 'ngram' 2018-08-03T14:51:22.835528Z 0 [Note] Shutting down plugin 'partition' 2018-08-03T14:51:22.835531Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2018-08-03T14:51:22.835534Z 0 [Note] Shutting down plugin 'ARCHIVE' 2018-08-03T14:51:22.835537Z 0 [Note] Shutting down plugin 'MEMORY' 2018-08-03T14:51:22.835540Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2018-08-03T14:51:22.835543Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2018-08-03T14:51:22.835546Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2018-08-03T14:51:22.835548Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2018-08-03T14:51:22.835551Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2018-08-03T14:51:22.835554Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2018-08-03T14:51:22.835556Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2018-08-03T14:51:22.835559Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2018-08-03T14:51:22.835561Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2018-08-03T14:51:22.835564Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2018-08-03T14:51:22.835567Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2018-08-03T14:51:22.835569Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2018-08-03T14:51:22.835572Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2018-08-03T14:51:22.835574Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2018-08-03T14:51:22.835577Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2018-08-03T14:51:22.835580Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2018-08-03T14:51:22.835582Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2018-08-03T14:51:22.835585Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2018-08-03T14:51:22.835588Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2018-08-03T14:51:22.835590Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2018-08-03T14:51:22.835593Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2018-08-03T14:51:22.835595Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2018-08-03T14:51:22.835598Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2018-08-03T14:51:22.835601Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2018-08-03T14:51:22.835603Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2018-08-03T14:51:22.835606Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2018-08-03T14:51:22.835609Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2018-08-03T14:51:22.835620Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2018-08-03T14:51:22.835622Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2018-08-03T14:51:22.835625Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2018-08-03T14:51:22.835628Z 0 [Note] Shutting down plugin 'InnoDB' 2018-08-03T14:51:22.835678Z 0 [Note] InnoDB: FTS optimize thread exiting. 2018-08-03T14:51:22.835727Z 0 [Note] InnoDB: Starting shutdown... 2018-08-03T14:51:22.935924Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2018-08-03T14:51:22.936157Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180803 20:21:22 2018-08-03T14:51:24.675234Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2590398 2018-08-03T14:51:24.676997Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-08-03T14:51:24.677008Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2018-08-03T14:51:24.677012Z 0 [Note] Shutting down plugin 'MyISAM' 2018-08-03T14:51:24.677024Z 0 [Note] Shutting down plugin 'CSV' 2018-08-03T14:51:24.677028Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2018-08-03T14:51:24.677068Z 0 [Note] Shutting down plugin 'sha256_password' 2018-08-03T14:51:24.677070Z 0 [Note] Shutting down plugin 'mysql_native_password' 2018-08-03T14:51:24.677186Z 0 [Note] Shutting down plugin 'binlog' 2018-08-03T14:51:24.677394Z 0 [Note] /usr/sbin/mysqld: Shutdown complete 2018-08-03T14:51:52.884156Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2018-08-03T14:51:52.884235Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000) 2018-08-03T14:51:53.043992Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-08-03T14:51:53.046225Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.23-0ubuntu0.16.04.1) starting as process 25434 ... 2018-08-03T14:51:53.051674Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-08-03T14:51:53.051698Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-08-03T14:51:53.051704Z 0 [Note] InnoDB: Uses event mutexes 2018-08-03T14:51:53.051708Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2018-08-03T14:51:53.051713Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2018-08-03T14:51:53.051717Z 0 [Note] InnoDB: Using Linux native AIO 2018-08-03T14:51:53.051987Z 0 [Note] InnoDB: Number of pools: 1 2018-08-03T14:51:53.052087Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-08-03T14:51:53.054013Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-08-03T14:51:53.062717Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-08-03T14:51:53.064936Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-08-03T14:51:53.077528Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-08-03T14:51:53.136123Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-08-03T14:51:53.136273Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-08-03T14:51:53.304272Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-08-03T14:51:53.305382Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2018-08-03T14:51:53.305397Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-08-03T14:51:53.305786Z 0 [Note] InnoDB: Waiting for purge to start 2018-08-03T14:51:53.356082Z 0 [Note] InnoDB: 5.7.23 started; log sequence number 2590398 2018-08-03T14:51:53.356413Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-08-03T14:51:53.356657Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-08-03T14:51:53.358329Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180803 20:21:53 2018-08-03T14:51:53.366342Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2018-08-03T14:51:53.366402Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 2018-08-03T14:51:53.366420Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 2018-08-03T14:51:53.366462Z 0 [Note] Server socket created on IP: '127.0.0.1'. 2018-08-03T14:51:53.688303Z 0 [Note] Event Scheduler: Loaded 0 events 2018-08-03T14:51:53.688512Z 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.7.23-0ubuntu0.16.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu) 2018-08-03T14:53:25.221989Z 0 [Note] Giving 1 client threads a chance to die gracefully 2018-08-03T14:53:25.222025Z 0 [Note] Shutting down slave threads 2018-08-03T14:53:27.222133Z 0 [Note] Forcefully disconnecting 0 remaining clients 2018-08-03T14:53:27.222204Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2018-08-03T14:53:27.222329Z 0 [Note] Binlog end 2018-08-03T14:53:27.222999Z 0 [Note] Shutting down plugin 'ngram' 2018-08-03T14:53:27.223019Z 0 [Note] Shutting down plugin 'partition' 2018-08-03T14:53:27.223029Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2018-08-03T14:53:27.223040Z 0 [Note] Shutting down plugin 'ARCHIVE' 2018-08-03T14:53:27.223049Z 0 [Note] Shutting down plugin 'MEMORY' 2018-08-03T14:53:27.223059Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2018-08-03T14:53:27.223069Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2018-08-03T14:53:27.223077Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2018-08-03T14:53:27.223086Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2018-08-03T14:53:27.223095Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2018-08-03T14:53:27.223103Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2018-08-03T14:53:27.223112Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2018-08-03T14:53:27.223120Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2018-08-03T14:53:27.223129Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2018-08-03T14:53:27.223138Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2018-08-03T14:53:27.223188Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2018-08-03T14:53:27.223197Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2018-08-03T14:53:27.223205Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2018-08-03T14:53:27.223214Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2018-08-03T14:53:27.223223Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2018-08-03T14:53:27.223231Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2018-08-03T14:53:27.223240Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2018-08-03T14:53:27.223248Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2018-08-03T14:53:27.223257Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2018-08-03T14:53:27.223266Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2018-08-03T14:53:27.223274Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2018-08-03T14:53:27.223283Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2018-08-03T14:53:27.223292Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2018-08-03T14:53:27.223300Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2018-08-03T14:53:27.223309Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2018-08-03T14:53:27.223317Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2018-08-03T14:53:27.223326Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2018-08-03T14:53:27.223334Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2018-08-03T14:53:27.223343Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2018-08-03T14:53:27.223352Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2018-08-03T14:53:27.223360Z 0 [Note] Shutting down plugin 'InnoDB' 2018-08-03T14:53:27.223474Z 0 [Note] InnoDB: FTS optimize thread exiting. 2018-08-03T14:53:27.223715Z 0 [Note] InnoDB: Starting shutdown... 2018-08-03T14:53:27.324059Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2018-08-03T14:53:27.324571Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180803 20:23:27 2018-08-03T14:53:28.905239Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2590426 2018-08-03T14:53:28.906959Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-08-03T14:53:28.906970Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2018-08-03T14:53:28.906974Z 0 [Note] Shutting down plugin 'MyISAM' 2018-08-03T14:53:28.906980Z 0 [Note] Shutting down plugin 'CSV' 2018-08-03T14:53:28.906984Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2018-08-03T14:53:28.907005Z 0 [Note] Shutting down plugin 'sha256_password' 2018-08-03T14:53:28.907008Z 0 [Note] Shutting down plugin 'mysql_native_password' 2018-08-03T14:53:28.907122Z 0 [Note] Shutting down plugin 'binlog' 2018-08-03T14:53:28.907455Z 0 [Note] /usr/sbin/mysqld: Shutdown complete 2018-08-03T14:54:11.586709Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2018-08-03T14:54:11.586762Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000) 2018-08-03T14:54:11.737526Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-08-03T14:54:11.739262Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.23-0ubuntu0.16.04.1) starting as process 25823 ... 2018-08-03T14:54:11.743550Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-08-03T14:54:11.743577Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-08-03T14:54:11.743582Z 0 [Note] InnoDB: Uses event mutexes 2018-08-03T14:54:11.743587Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2018-08-03T14:54:11.743591Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2018-08-03T14:54:11.743596Z 0 [Note] InnoDB: Using Linux native AIO 2018-08-03T14:54:11.743828Z 0 [Note] InnoDB: Number of pools: 1 2018-08-03T14:54:11.743920Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-08-03T14:54:11.745447Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-08-03T14:54:11.752785Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-08-03T14:54:11.754624Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-08-03T14:54:11.766555Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-08-03T14:54:11.808018Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-08-03T14:54:11.808101Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-08-03T14:54:11.969717Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-08-03T14:54:11.970810Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2018-08-03T14:54:11.970824Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-08-03T14:54:11.971240Z 0 [Note] InnoDB: Waiting for purge to start 2018-08-03T14:54:12.021534Z 0 [Note] InnoDB: 5.7.23 started; log sequence number 2590426 2018-08-03T14:54:12.021836Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-08-03T14:54:12.022096Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-08-03T14:54:12.025194Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180803 20:24:12 2018-08-03T14:54:12.031212Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2018-08-03T14:54:12.031254Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 2018-08-03T14:54:12.031271Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 2018-08-03T14:54:12.031313Z 0 [Note] Server socket created on IP: '127.0.0.1'. 2018-08-03T14:54:12.039772Z 0 [Note] Event Scheduler: Loaded 0 events 2018-08-03T14:54:12.039915Z 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.7.23-0ubuntu0.16.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu) 2018-08-03T15:29:44.308560Z 0 [Note] Giving 0 client threads a chance to die gracefully 2018-08-03T15:29:45.054159Z 0 [Note] Shutting down slave threads 2018-08-03T15:29:45.054186Z 0 [Note] Forcefully disconnecting 0 remaining clients 2018-08-03T15:29:45.054207Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2018-08-03T15:29:45.054271Z 0 [Note] Binlog end 2018-08-03T15:29:45.054657Z 0 [Note] Shutting down plugin 'ngram' 2018-08-03T15:29:45.054668Z 0 [Note] Shutting down plugin 'partition' 2018-08-03T15:29:45.054673Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2018-08-03T15:29:45.054678Z 0 [Note] Shutting down plugin 'ARCHIVE' 2018-08-03T15:29:45.054682Z 0 [Note] Shutting down plugin 'MEMORY' 2018-08-03T15:29:45.054687Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2018-08-03T15:29:45.054692Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2018-08-03T15:29:45.054696Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2018-08-03T15:29:45.054700Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2018-08-03T15:29:45.054703Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2018-08-03T15:29:45.054707Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2018-08-03T15:29:45.054711Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2018-08-03T15:29:45.054715Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2018-08-03T15:29:45.054719Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2018-08-03T15:29:45.054723Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2018-08-03T15:29:45.054727Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2018-08-03T15:29:45.054731Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2018-08-03T15:29:45.054734Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2018-08-03T15:29:45.054738Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2018-08-03T15:29:45.054742Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2018-08-03T15:29:45.054746Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2018-08-03T15:29:45.054750Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2018-08-03T15:29:45.054754Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2018-08-03T15:29:45.054758Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2018-08-03T15:29:45.054762Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2018-08-03T15:29:45.054765Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2018-08-03T15:29:45.054769Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2018-08-03T15:29:45.054773Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2018-08-03T15:29:45.054777Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2018-08-03T15:29:45.054781Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2018-08-03T15:29:45.054785Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2018-08-03T15:29:45.054789Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2018-08-03T15:29:45.054793Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2018-08-03T15:29:45.054796Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2018-08-03T15:29:45.054800Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2018-08-03T15:29:45.054804Z 0 [Note] Shutting down plugin 'InnoDB' 2018-08-03T15:29:45.054877Z 0 [Note] InnoDB: FTS optimize thread exiting. 2018-08-03T15:29:45.054941Z 0 [Note] InnoDB: Starting shutdown... 2018-08-03T15:29:45.155132Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2018-08-03T15:29:47.359156Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180803 20:59:47 2018-08-03T15:29:50.462659Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2590454 2018-08-03T15:29:50.464629Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-08-03T15:29:50.464656Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2018-08-03T15:29:50.464664Z 0 [Note] Shutting down plugin 'MyISAM' 2018-08-03T15:29:50.464674Z 0 [Note] Shutting down plugin 'CSV' 2018-08-03T15:29:50.464681Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2018-08-03T15:29:50.464715Z 0 [Note] Shutting down plugin 'sha256_password' 2018-08-03T15:29:50.464722Z 0 [Note] Shutting down plugin 'mysql_native_password' 2018-08-03T15:29:50.464901Z 0 [Note] Shutting down plugin 'binlog' 2018-08-03T15:29:50.465459Z 0 [Note] /usr/sbin/mysqld: Shutdown complete 2018-08-04T05:31:12.093057Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2018-08-04T05:31:12.093137Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000) 2018-08-04T05:31:12.552471Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-08-04T05:31:12.659666Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.23-0ubuntu0.16.04.1) starting as process 1420 ... 2018-08-04T05:31:13.641511Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-08-04T05:31:13.641546Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-08-04T05:31:13.641553Z 0 [Note] InnoDB: Uses event mutexes 2018-08-04T05:31:13.641559Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2018-08-04T05:31:13.641566Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2018-08-04T05:31:13.641572Z 0 [Note] InnoDB: Using Linux native AIO 2018-08-04T05:31:13.656828Z 0 [Note] InnoDB: Number of pools: 1 2018-08-04T05:31:13.664006Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-08-04T05:31:13.665752Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-08-04T05:31:13.673857Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-08-04T05:31:13.860789Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-08-04T05:31:14.143223Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-08-04T05:31:14.830909Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-08-04T05:31:14.831017Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-08-04T05:31:15.453900Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-08-04T05:31:15.454982Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2018-08-04T05:31:15.454996Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-08-04T05:31:15.455377Z 0 [Note] InnoDB: Waiting for purge to start 2018-08-04T05:31:15.505583Z 0 [Note] InnoDB: 5.7.23 started; log sequence number 2590454 2018-08-04T05:31:15.505774Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2018-08-04T05:31:15.505948Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-08-04T05:31:16.850023Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2018-08-04T05:31:16.850056Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 2018-08-04T05:31:16.850069Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 2018-08-04T05:31:16.850097Z 0 [Note] Server socket created on IP: '127.0.0.1'. 2018-08-04T05:31:17.329384Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180804 11:01:17 2018-08-04T05:31:18.448409Z 0 [Note] Event Scheduler: Loaded 0 events 2018-08-04T05:31:18.448564Z 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.7.23-0ubuntu0.16.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)