We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
Mysql crash
Mysql crash
Hello, for a few days I have been struggling with mysql failures at morning hours and unfortunately I can not solve the problem myself.
Code: Select all
2019-07-31T04:52:21.167720Z 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 5000)
2019-07-31T04:52:21.381943Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-07-31T04:52:21.384449Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.27-0ubuntu0.16.04.1) starting as process 8542 ...
2019-07-31T04:52:21.391678Z 0 [Note] InnoDB: PUNCH HOLE support available
2019-07-31T04:52:21.391722Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-07-31T04:52:21.391728Z 0 [Note] InnoDB: Uses event mutexes
2019-07-31T04:52:21.391733Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2019-07-31T04:52:21.391741Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2019-07-31T04:52:21.391747Z 0 [Note] InnoDB: Using Linux native AIO
2019-07-31T04:52:21.392181Z 0 [Note] InnoDB: Number of pools: 1
2019-07-31T04:52:21.392337Z 0 [Note] InnoDB: Using CPU crc32 instructions
2019-07-31T04:52:21.394586Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-07-31T04:52:21.409390Z 0 [Note] InnoDB: Completed initialization of buffer pool
2019-07-31T04:52:21.412852Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-07-31T04:52:21.429271Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2019-07-31T04:52:21.470833Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-07-31T04:52:21.470950Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-07-31T04:52:21.656559Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2019-07-31T04:52:21.658568Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2019-07-31T04:52:21.658603Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2019-07-31T04:52:21.659053Z 0 [Note] InnoDB: Waiting for purge to start
2019-07-31T04:52:21.709353Z 0 [Note] InnoDB: 5.7.27 started; log sequence number 780369815
2019-07-31T04:52:21.709866Z 0 [Note] Plugin 'FEDERATED' is disabled.
2019-07-31T04:52:21.718690Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2019-07-31T04:52:21.728801Z 0 [Note] InnoDB: Buffer pool(s) load completed at 190731 6:52:21
2019-07-31T04:52:21.732432Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2019-07-31T04:52:21.732462Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2019-07-31T04:52:21.732528Z 0 [Note] IPv6 is available.
2019-07-31T04:52:21.732541Z 0 [Note] - '::' resolves to '::';
2019-07-31T04:52:21.732582Z 0 [Note] Server socket created on IP: '::'.
2019-07-31T04:52:21.743417Z 0 [Note] Event Scheduler: Loaded 0 events
2019-07-31T04:52:21.743592Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.27-0ubuntu0.16.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
2019-07-31T04:52:22.189532Z 2 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2019-07-31T04:52:22.210926Z 3 [Note] Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)
2019-07-31T04:52:22.385031Z 0 [Note] Giving 0 client threads a chance to die gracefully
2019-07-31T04:52:22.385067Z 0 [Note] Shutting down slave threads
2019-07-31T04:52:22.385071Z 0 [Note] Forcefully disconnecting 0 remaining clients
2019-07-31T04:52:22.385079Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2019-07-31T04:52:22.385116Z 0 [Note] Binlog end
2019-07-31T04:52:22.385481Z 0 [Note] Shutting down plugin 'ngram'
2019-07-31T04:52:22.385491Z 0 [Note] Shutting down plugin 'partition'
2019-07-31T04:52:22.385495Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2019-07-31T04:52:22.385499Z 0 [Note] Shutting down plugin 'ARCHIVE'
2019-07-31T04:52:22.385501Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2019-07-31T04:52:22.385505Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2019-07-31T04:52:22.385517Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2019-07-31T04:52:22.385520Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2019-07-31T04:52:22.385523Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2019-07-31T04:52:22.385525Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2019-07-31T04:52:22.385528Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2019-07-31T04:52:22.385531Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2019-07-31T04:52:22.385533Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2019-07-31T04:52:22.385536Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2019-07-31T04:52:22.385538Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2019-07-31T04:52:22.385541Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2019-07-31T04:52:22.385543Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2019-07-31T04:52:22.385546Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2019-07-31T04:52:22.385549Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2019-07-31T04:52:22.385551Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2019-07-31T04:52:22.385554Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2019-07-31T04:52:22.385556Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2019-07-31T04:52:22.385559Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2019-07-31T04:52:22.385561Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2019-07-31T04:52:22.385564Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2019-07-31T04:52:22.385566Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2019-07-31T04:52:22.385569Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2019-07-31T04:52:22.385572Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2019-07-31T04:52:22.385574Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2019-07-31T04:52:22.385577Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2019-07-31T04:52:22.385579Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2019-07-31T04:52:22.385582Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2019-07-31T04:52:22.385584Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2019-07-31T04:52:22.385587Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2019-07-31T04:52:22.385589Z 0 [Note] Shutting down plugin 'InnoDB'
2019-07-31T04:52:22.385651Z 0 [Note] InnoDB: FTS optimize thread exiting.
2019-07-31T04:52:22.386213Z 0 [Note] InnoDB: Starting shutdown...
2019-07-31T04:52:22.486617Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2019-07-31T04:52:22.486847Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 190731 6:52:22
2019-07-31T04:52:23.305093Z 0 [Note] InnoDB: Shutdown completed; log sequence number 780369834
2019-07-31T04:52:23.311101Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-07-31T04:52:23.311146Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2019-07-31T04:52:23.311156Z 0 [Note] Shutting down plugin 'MEMORY'
2019-07-31T04:52:23.311163Z 0 [Note] Shutting down plugin 'CSV'
2019-07-31T04:52:23.311171Z 0 [Note] Shutting down plugin 'MyISAM'
2019-07-31T04:52:23.311184Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2019-07-31T04:52:23.311234Z 0 [Note] Shutting down plugin 'sha256_password'
2019-07-31T04:52:23.311239Z 0 [Note] Shutting down plugin 'mysql_native_password'
2019-07-31T04:52:23.311567Z 0 [Note] Shutting down plugin 'binlog'
2019-07-31T04:52:23.312262Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
2019-07-31T04:52:23.571321Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-07-31T04:52:23.575054Z 0 [Note] mysqld (mysqld 5.7.27-0ubuntu0.16.04.1) starting as process 8627 ...
2019-07-31T04:52:23.583080Z 0 [Note] InnoDB: PUNCH HOLE support available
2019-07-31T04:52:23.583118Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-07-31T04:52:23.583127Z 0 [Note] InnoDB: Uses event mutexes
2019-07-31T04:52:23.583132Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2019-07-31T04:52:23.583146Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2019-07-31T04:52:23.583151Z 0 [Note] InnoDB: Using Linux native AIO
2019-07-31T04:52:23.583446Z 0 [Note] InnoDB: Number of pools: 1
2019-07-31T04:52:23.583599Z 0 [Note] InnoDB: Using CPU crc32 instructions
2019-07-31T04:52:23.586850Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-07-31T04:52:23.598598Z 0 [Note] InnoDB: Completed initialization of buffer pool
2019-07-31T04:52:23.601777Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-07-31T04:52:23.614942Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2019-07-31T04:52:23.636255Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-07-31T04:52:23.636348Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-07-31T04:52:23.786357Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2019-07-31T04:52:23.788487Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2019-07-31T04:52:23.788553Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2019-07-31T04:52:23.789076Z 0 [Note] InnoDB: Waiting for purge to start
2019-07-31T04:52:23.839348Z 0 [Note] InnoDB: 5.7.27 started; log sequence number 780369834
2019-07-31T04:52:23.839754Z 0 [Note] Plugin 'FEDERATED' is disabled.
2019-07-31T04:52:23.847885Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2019-07-31T04:52:23.850493Z 0 [Note] InnoDB: Buffer pool(s) load completed at 190731 6:52:23
2019-07-31T04:52:23.857546Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2019-07-31T04:52:23.857577Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2019-07-31T04:52:23.857619Z 0 [Note] IPv6 is available.
2019-07-31T04:52:23.857624Z 0 [Note] - '::' resolves to '::';
2019-07-31T04:52:23.857655Z 0 [Note] Server socket created on IP: '::'.
2019-07-31T04:52:23.861105Z 0 [Warning] Insecure configuration for --pid-file: Location '/tmp' in the path is accessible to all OS users. Consider choosing a different directory.
2019-07-31T04:52:23.871760Z 0 [Note] Event Scheduler: Loaded 0 events
2019-07-31T04:52:23.872051Z 0 [Note] Execution of init_file '/var/lib/mysql-files/tmp.cU2bIwrmWZ' started.
2019-07-31T04:52:23.875274Z 0 [Note] Execution of init_file '/var/lib/mysql-files/tmp.cU2bIwrmWZ' ended.
2019-07-31T04:52:23.875359Z 0 [Note] mysqld: ready for connections.
Version: '5.7.27-0ubuntu0.16.04.1' socket: '/tmp/tmp.ranaPHcsgM/mysqld.sock' port: 3306 (Ubuntu)
2019-07-31T04:52:23.875583Z 0 [Note] Giving 0 client threads a chance to die gracefully
2019-07-31T04:52:23.875596Z 0 [Note] Shutting down slave threads
2019-07-31T04:52:23.875601Z 0 [Note] Forcefully disconnecting 0 remaining clients
2019-07-31T04:52:23.875607Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2019-07-31T04:52:23.875641Z 0 [Note] Binlog end
2019-07-31T04:52:23.876081Z 0 [Note] Shutting down plugin 'ngram'
2019-07-31T04:52:23.876092Z 0 [Note] Shutting down plugin 'partition'
2019-07-31T04:52:23.876096Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2019-07-31T04:52:23.876101Z 0 [Note] Shutting down plugin 'ARCHIVE'
2019-07-31T04:52:23.876104Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2019-07-31T04:52:23.876108Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2019-07-31T04:52:23.876110Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2019-07-31T04:52:23.876113Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2019-07-31T04:52:23.876116Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2019-07-31T04:52:23.876119Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2019-07-31T04:52:23.876122Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2019-07-31T04:52:23.876125Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2019-07-31T04:52:23.876137Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2019-07-31T04:52:23.876140Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2019-07-31T04:52:23.876143Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2019-07-31T04:52:23.876146Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2019-07-31T04:52:23.876148Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2019-07-31T04:52:23.876151Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2019-07-31T04:52:23.876153Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2019-07-31T04:52:23.876156Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2019-07-31T04:52:23.876159Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2019-07-31T04:52:23.876162Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2019-07-31T04:52:23.876164Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2019-07-31T04:52:23.876167Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2019-07-31T04:52:23.876169Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2019-07-31T04:52:23.876172Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2019-07-31T04:52:23.876174Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2019-07-31T04:52:23.876177Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2019-07-31T04:52:23.876180Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2019-07-31T04:52:23.876183Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2019-07-31T04:52:23.876185Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2019-07-31T04:52:23.876188Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2019-07-31T04:52:23.876190Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2019-07-31T04:52:23.876193Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2019-07-31T04:52:23.876195Z 0 [Note] Shutting down plugin 'InnoDB'
2019-07-31T04:52:23.876252Z 0 [Note] InnoDB: FTS optimize thread exiting.
2019-07-31T04:52:23.876353Z 0 [Note] InnoDB: Starting shutdown...
2019-07-31T04:52:23.976740Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2019-07-31T04:52:23.976970Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 190731 6:52:23
2019-07-31T04:52:25.489235Z 0 [Note] InnoDB: Shutdown completed; log sequence number 780369853
2019-07-31T04:52:25.491904Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-07-31T04:52:25.491944Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2019-07-31T04:52:25.491954Z 0 [Note] Shutting down plugin 'MEMORY'
2019-07-31T04:52:25.491960Z 0 [Note] Shutting down plugin 'CSV'
2019-07-31T04:52:25.491968Z 0 [Note] Shutting down plugin 'MyISAM'
2019-07-31T04:52:25.491981Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2019-07-31T04:52:25.492140Z 0 [Note] Shutting down plugin 'sha256_password'
2019-07-31T04:52:25.492151Z 0 [Note] Shutting down plugin 'mysql_native_password'
2019-07-31T04:52:25.492352Z 0 [Note] Shutting down plugin 'binlog'
2019-07-31T04:52:25.493812Z 0 [Note] mysqld: Shutdown complete
2019-07-31T04:52:25.813556Z 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 5000)
2019-07-31T04:52:26.024547Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-07-31T04:52:26.028588Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.27-0ubuntu0.16.04.1) starting as process 8713 ...
2019-07-31T04:52:26.034710Z 0 [Note] InnoDB: PUNCH HOLE support available
2019-07-31T04:52:26.034755Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-07-31T04:52:26.034764Z 0 [Note] InnoDB: Uses event mutexes
2019-07-31T04:52:26.034772Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2019-07-31T04:52:26.034781Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2019-07-31T04:52:26.034788Z 0 [Note] InnoDB: Using Linux native AIO
2019-07-31T04:52:26.035217Z 0 [Note] InnoDB: Number of pools: 1
2019-07-31T04:52:26.035370Z 0 [Note] InnoDB: Using CPU crc32 instructions
2019-07-31T04:52:26.038744Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-07-31T04:52:26.051154Z 0 [Note] InnoDB: Completed initialization of buffer pool
2019-07-31T04:52:26.055691Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-07-31T04:52:26.068542Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2019-07-31T04:52:26.108129Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-07-31T04:52:26.108234Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-07-31T04:52:26.278765Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2019-07-31T04:52:26.282183Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2019-07-31T04:52:26.282283Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2019-07-31T04:52:26.285420Z 0 [Note] InnoDB: Waiting for purge to start
2019-07-31T04:52:26.335863Z 0 [Note] InnoDB: 5.7.27 started; log sequence number 780369853
2019-07-31T04:52:26.336329Z 0 [Note] Plugin 'FEDERATED' is disabled.
2019-07-31T04:52:26.340264Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2019-07-31T04:52:26.343238Z 0 [Note] InnoDB: Buffer pool(s) load completed at 190731 6:52:26
2019-07-31T04:52:26.350890Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2019-07-31T04:52:26.350915Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2019-07-31T04:52:26.350962Z 0 [Note] IPv6 is available.
2019-07-31T04:52:26.350967Z 0 [Note] - '::' resolves to '::';
2019-07-31T04:52:26.350997Z 0 [Note] Server socket created on IP: '::'.
2019-07-31T04:52:26.359932Z 0 [Note] Event Scheduler: Loaded 0 events
2019-07-31T04:52:26.360132Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.27-0ubuntu0.16.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
2019-07-31T04:52:26.838141Z 2 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2019-07-31T04:52:27.067398Z 3 [Note] Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)
2019-07-31T04:57:59.473427Z 6 [Warning] Host name 'hostby.fcloud.biz' could not be resolved: Name or service not known
2019-07-31T04:57:59.520326Z 6 [Note] Access denied for user 'root'@'88.214.26.17' (using password: YES)
2019-07-31T05:19:42.011617Z 15 [Warning] IP address '217.182.74.157' has been resolved to the host name '157.ip-217-182-74.eu', which resembles IPv4-address itself.
2019-07-31T05:19:42.012190Z 15 [Note] Access denied for user 'admin_onesms'@'217.182.74.157' (using password: YES)
2019-07-31T05:52:21.419286Z 31 [Note] Access denied for user 'admin_onesms'@'217.182.74.157' (using password: YES)
2019-07-31T05:54:13.903085Z 32 [Note] Access denied for user 'root'@'88.214.26.17' (using password: YES)
2019-07-31T06:50:58.573090Z 57 [Note] Access denied for user 'root'@'88.214.26.17' (using password: YES)
2019-07-31T07:47:19.057958Z 80 [Note] Access denied for user 'root'@'88.214.26.17' (using password: YES)
2019-07-31T07:51:50.146835Z 83 [Note] Aborted connection 83 to db: 'admin_onerankme' user: 'admin_stats' host: 'o14.1sk.pl' (Got timeout reading communication packets)
2019-07-31T07:54:26.656988Z 84 [Note] Aborted connection 84 to db: 'admin_onerankme' user: 'admin_stats' host: 'o14.1sk.pl' (Got timeout reading communication packets)
2019-07-31T08:43:31.331281Z 105 [Note] Access denied for user 'root'@'88.214.26.17' (using password: YES)
2019-07-31T09:29:09.244634Z 124 [Note] Aborted connection 124 to db: 'admin_onerankme' user: 'admin_stats' host: 'o22.1sk.pl' (Got timeout reading communication packets)
2019-07-31T09:39:03.904706Z 140 [Note] Access denied for user 'root'@'88.214.26.17' (using password: YES)
2019-07-31T09:41:01.000030Z 135 [Note] Aborted connection 135 to db: 'admin_onerankme' user: 'admin_stats' host: 'o22.1sk.pl' (Got timeout reading communication packets)
2019-07-31T10:26:22.478051Z 159 [Note] Aborted connection 159 to db: 'admin_onerankme' user: 'admin_stats' host: 'o22.1sk.pl' (Got timeout reading communication packets)
2019-07-31T10:35:11.242758Z 172 [Note] Access denied for user 'root'@'88.214.26.17' (using password: YES)
2019-07-31T10:49:17.251925Z 177 [Note] Aborted connection 177 to db: 'admin_onerankme' user: 'admin_stats' host: 'o14.1sk.pl' (Got timeout reading communication packets)
2019-07-31T10:51:25.377333Z 178 [Note] Aborted connection 178 to db: 'admin_onerankme' user: 'admin_stats' host: 'o14.1sk.pl' (Got timeout reading communication packets)
2019-07-31T11:02:36.595963Z 185 [Note] Aborted connection 185 to db: 'admin_onerankme' user: 'admin_stats' host: 'o22.1sk.pl' (Got timeout reading communication packets)
2019-07-31T11:06:07.110811Z 192 [Note] Aborted connection 192 to db: 'admin_onerankme' user: 'admin_stats' host: 'o14.1sk.pl' (Got timeout reading communication packets)
2019-07-31T11:08:01.193101Z 195 [Note] Aborted connection 195 to db: 'admin_onerankme' user: 'admin_stats' host: 'o14.1sk.pl' (Got timeout reading communication packets)
2019-07-31T11:30:46.819226Z 206 [Note] Access denied for user 'root'@'88.214.26.17' (using password: YES)
2019-07-31T11:42:31.417079Z 211 [Warning] IP address '218.60.67.89' could not be resolved: Name or service not known
2019-07-31T11:58:56.148512Z 236 [Note] Aborted connection 236 to db: 'admin_onerankme' user: 'admin_stats' host: 'o14.1sk.pl' (Got timeout reading communication packets)
2019-07-31T12:03:58.355154Z 239 [Note] Aborted connection 239 to db: 'admin_onerankme' user: 'admin_stats' host: 'o14.1sk.pl' (Got timeout reading communication packets)
2019-07-31T12:09:27.692826Z 242 [Note] Aborted connection 242 to db: 'admin_onerankme' user: 'admin_stats' host: 'o22.1sk.pl' (Got timeout reading communication packets)
2019-07-31T12:12:03.327934Z 247 [Note] Aborted connection 247 to db: 'admin_onerankme' user: 'admin_stats' host: 'o14.1sk.pl' (Got timeout reading communication packets)
2019-07-31T12:26:06.379434Z 256 [Note] Access denied for user 'root'@'88.214.26.17' (using password: YES)
2019-07-31T12:41:04.169274Z 262 [Note] Aborted connection 262 to db: 'admin_robot' user: 'admin_teamspeak' host: 'localhost' (Got timeout reading communication packets)
2019-07-31T12:41:13.309357Z 265 [Note] Aborted connection 265 to db: 'admin_robot' user: 'admin_teamspeak' host: 'localhost' (Got timeout reading communication packets)
2019-07-31T12:41:16.373380Z 266 [Note] Aborted connection 266 to db: 'admin_robot' user: 'admin_teamspeak' host: 'localhost' (Got timeout reading communication packets)
Re: Mysql crash
Could you solve it? please inform us.