Skip to main content

The "mysql" service appears to be down.

hostprime
When MySQL crashes I get these emails...
  • Service status failed ?
Notification The "mysql" service appears to be down. Service Check Method Failed system command to check or restart this service. Number of restart attempts 1 Service Check Raw Output (XID bqdn4j) The "mysql" service is disabled. The "mysql" service is down. The subprocess "/usr/local/cpanel/scripts/restartsrv_mysql" reported error number 2 when it terminated. Startup log No startup log
  • Service Status recovered ?
Notification The "mysql" service is operational. Raw Service Check Output The 'mysql' service passed the check: mysqld (/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid) is running as mysql with PID 12822 (systemd+/proc check method). Startup log No startup log Log messages 2022-06-07T12:24:57.135188Z 0 [Note] /usr/sbin/mysqld: ready for connections. 2022-06-07T12:23:34.891827Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

Comments

3 comments

Date Votes
  • cPRex Jurassic Moderator
    Hey there! That seems like a normal email notification to me. You'll want to check the MySQL error log to see if that provides more details about the cause of the crash. Typically the error log is located at /var/log/mysqld.log unless the server's configuration has been customized.
    0
  • hostprime
    In the log I found this... and it always happens at the same time 2022-06-07T12:17:23.494608Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2022-06-07T12:17:23.496424Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set. 2022-06-07T12:17:23.535654Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.38) starting as process 7901 ... 2022-06-07T12:17:23.680766Z 0 [Note] InnoDB: PUNCH HOLE support available 2022-06-07T12:17:23.680815Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2022-06-07T12:17:23.680821Z 0 [Note] InnoDB: Uses event mutexes 2022-06-07T12:17:23.680826Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2022-06-07T12:17:23.680833Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2022-06-07T12:17:23.680837Z 0 [Note] InnoDB: Using Linux native AIO 2022-06-07T12:17:23.683249Z 0 [Note] InnoDB: Number of pools: 1 2022-06-07T12:17:23.717626Z 0 [Note] InnoDB: Using CPU crc32 instructions 2022-06-07T12:17:23.730365Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2022-06-07T12:17:23.807405Z 0 [Note] InnoDB: Completed initialization of buffer pool 2022-06-07T12:17:23.828981Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2022-06-07T12:17:23.905828Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2022-06-07T12:17:24.677056Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 18997003534 2022-06-07T12:17:24.677094Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 18997003543 2022-06-07T12:17:24.677102Z 0 [Note] InnoDB: Database was not shutdown normally! 2022-06-07T12:17:24.677108Z 0 [Note] InnoDB: Starting crash recovery. 2022-06-07T12:23:32.079862Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2022-06-07T12:23:32.079895Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-06-07T12:23:32.080057Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-06-07T12:23:32.164315Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2022-06-07T12:23:32.223873Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2022-06-07T12:23:32.223905Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2022-06-07T12:23:32.241711Z 0 [Note] InnoDB: Waiting for purge to start 2022-06-07T12:23:32.291963Z 0 [Note] InnoDB: 5.7.38 started; log sequence number 18997003543 2022-06-07T12:23:32.294177Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 368465ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.) 2022-06-07T12:23:32.298322Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2022-06-07T12:23:32.318552Z 0 [Note] Plugin 'FEDERATED' is disabled. 2022-06-07T12:23:32.412559Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220607 9:23:32 2022-06-07T12:23:32.578377Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2022-06-07T12:23:32.578422Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2022-06-07T12:23:32.578430Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher. 2022-06-07T12:23:32.578434Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher. 2022-06-07T12:23:32.583570Z 0 [Warning] CA certificate ca.pem is self signed. 2022-06-07T12:23:32.583659Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2022-06-07T12:23:32.591861Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2022-06-07T12:23:32.593849Z 0 [Note] IPv6 is available. 2022-06-07T12:23:32.593876Z 0 [Note] - '::' resolves to '::'; 2022-06-07T12:23:32.593910Z 0 [Note] Server socket created on IP: '::'. 2022-06-07T12:23:32.966335Z 0 [Note] Event Scheduler: Loaded 0 events 2022-06-07T12:23:32.967468Z 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.7.38' socket: '/var/lib/mysql/mysql.sock' port: xxx MySQL Community Server (GPL) 2022-06-07T12:23:33.007492Z 0 [Note] Giving 0 client threads a chance to die gracefully 2022-06-07T12:23:33.007527Z 0 [Note] Shutting down slave threads 2022-06-07T12:23:33.007538Z 0 [Note] Forcefully disconnecting 0 remaining clients 2022-06-07T12:23:33.007548Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2022-06-07T12:23:33.007608Z 0 [Note] Binlog end 2022-06-07T12:23:33.008976Z 0 [Note] Shutting down plugin 'ngram' 2022-06-07T12:23:33.008997Z 0 [Note] Shutting down plugin 'partition' 2022-06-07T12:23:33.009002Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2022-06-07T12:23:33.009007Z 0 [Note] Shutting down plugin 'ARCHIVE' 2022-06-07T12:23:33.009010Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2022-06-07T12:23:33.009047Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2022-06-07T12:23:33.009054Z 0 [Note] Shutting down plugin 'MyISAM' 2022-06-07T12:23:33.009064Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2022-06-07T12:23:33.009068Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2022-06-07T12:23:33.009071Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2022-06-07T12:23:33.009085Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2022-06-07T12:23:33.009089Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2022-06-07T12:23:33.009092Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2022-06-07T12:23:33.009096Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2022-06-07T12:23:33.009099Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2022-06-07T12:23:33.009102Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2022-06-07T12:23:33.009105Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2022-06-07T12:23:33.009108Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2022-06-07T12:23:33.009111Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2022-06-07T12:23:33.009114Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2022-06-07T12:23:33.009118Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2022-06-07T12:23:33.009121Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2022-06-07T12:23:33.009124Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2022-06-07T12:23:33.009127Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2022-06-07T12:23:33.009130Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2022-06-07T12:23:33.009134Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2022-06-07T12:23:33.009137Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2022-06-07T12:23:33.009140Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2022-06-07T12:23:33.009143Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2022-06-07T12:23:33.009146Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2022-06-07T12:23:33.009150Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2022-06-07T12:23:33.009153Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2022-06-07T12:23:33.009156Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2022-06-07T12:23:33.009159Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2022-06-07T12:23:33.009163Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2022-06-07T12:23:33.009166Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2022-06-07T12:23:33.009169Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2022-06-07T12:23:33.009172Z 0 [Note] Shutting down plugin 'InnoDB' 2022-06-07T12:23:33.009270Z 0 [Note] InnoDB: FTS optimize thread exiting. 2022-06-07T12:23:33.009409Z 0 [Note] InnoDB: Starting shutdown... 2022-06-07T12:23:33.109711Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2022-06-07T12:23:33.110309Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 220607 9:23:33 2022-06-07T12:23:34.871795Z 0 [Note] InnoDB: Shutdown completed; log sequence number 18997003562 2022-06-07T12:23:34.891026Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2022-06-07T12:23:34.891072Z 0 [Note] Shutting down plugin 'MEMORY' 2022-06-07T12:23:34.891086Z 0 [Note] Shutting down plugin 'CSV' 2022-06-07T12:23:34.891093Z 0 [Note] Shutting down plugin 'sha256_password' 2022-06-07T12:23:34.891097Z 0 [Note] Shutting down plugin 'mysql_native_password' 2022-06-07T12:23:34.891246Z 0 [Note] Shutting down plugin 'binlog' 2022-06-07T12:23:34.891827Z 0 [Note] /usr/sbin/mysqld: Shutdown complete 2022-06-07T12:23:48.150457Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2022-06-07T12:23:48.162850Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set. 2022-06-07T12:23:48.207416Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.38) starting as process 12822 ... 2022-06-07T12:23:48.329436Z 0 [Note] InnoDB: PUNCH HOLE support available 2022-06-07T12:23:48.329481Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2022-06-07T12:23:48.329486Z 0 [Note] InnoDB: Uses event mutexes 2022-06-07T12:23:48.329491Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2022-06-07T12:23:48.329498Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2022-06-07T12:23:48.329506Z 0 [Note] InnoDB: Using Linux native AIO 2022-06-07T12:23:48.329862Z 0 [Note] InnoDB: Number of pools: 1 2022-06-07T12:23:48.330006Z 0 [Note] InnoDB: Using CPU crc32 instructions 2022-06-07T12:23:48.332530Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2022-06-07T12:23:48.431382Z 0 [Note] InnoDB: Completed initialization of buffer pool 2022-06-07T12:23:48.445407Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2022-06-07T12:23:48.653624Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2022-06-07T12:24:56.736874Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-06-07T12:24:56.737077Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-06-07T12:24:56.835338Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2022-06-07T12:24:56.865879Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2022-06-07T12:24:56.865915Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2022-06-07T12:24:56.880319Z 0 [Note] InnoDB: Waiting for purge to start 2022-06-07T12:24:56.930534Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 68485ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.) 2022-06-07T12:24:56.930550Z 0 [Note] InnoDB: 5.7.38 started; log sequence number 18997003562 2022-06-07T12:24:56.930791Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2022-06-07T12:24:56.931826Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220607 9:24:56 2022-06-07T12:24:56.937883Z 0 [Note] Plugin 'FEDERATED' is disabled. 2022-06-07T12:24:56.964076Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2022-06-07T12:24:56.964102Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2022-06-07T12:24:56.964108Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher. 2022-06-07T12:24:56.964112Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher. 2022-06-07T12:24:56.965048Z 0 [Warning] CA certificate ca.pem is self signed. 2022-06-07T12:24:56.965128Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2022-06-07T12:24:56.980666Z 0 [Note] Server hostname (bind-address): '*'; port: xxx 2022-06-07T12:24:56.981407Z 0 [Note] IPv6 is available. 2022-06-07T12:24:56.981430Z 0 [Note] - '::' resolves to '::'; 2022-06-07T12:24:56.981464Z 0 [Note] Server socket created on IP: '::'. 2022-06-07T12:24:57.134991Z 0 [Note] Event Scheduler: Loaded 0 events 2022-06-07T12:24:57.135188Z 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.7.38' socket: '/var/lib/mysql/mysql.sock' port: xxx MySQL Community Server (GPL) 2022-06-07T12:24:58.644760Z 2 [Warning] Hostname 'xxx' does not resolve to 'xxx'. 2022-06-07T12:24:58.644802Z 2 [Note] Hostname 'xxx' has the following IP addresses: 2022-06-07T12:24:58.644808Z 2 [Note] - xxx 2022-06-07T12:24:59.643793Z 4 [Note] Access denied for user 'Cpanel::MysqlUtils::Unprivileged'@'localhost' (using password: NO) 2022-06-07T12:25:13.739581Z 148 [Note] Access denied for user 'primesaa_lista'@'localhost' to database 'primesaa_lista' 2022-06-07T12:25:15.787912Z 149 [Note] Access denied for user ''@'localhost' (using password: NO) 2022-06-07T12:25:15.807109Z 150 [Note] Access denied for user ''@'localhost' (using password: NO) 2022-06-07T12:26:46.378592Z 877 [Note] Access denied for user 'Cpanel::MysqlUtils::Unprivileged'@'localhost' (using password: NO) 2022-06-07T12:26:48.383188Z 878 [Note] Got an error reading communication packets
    0
  • cPRex Jurassic Moderator
    Thanks for posting that - most of that looks like a normal restart except for the "access denied" section at the very end. However, although those look concerning, they can be ignored:
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post