The "mysql" service appears to be down.

Operating System & Version
CentOS v7.9.2009
cPanel & WHM Version
102.0.18

hostprime

Registered
Jun 7, 2022
2
0
1
brazil
cPanel Access Level
Root Administrator
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
 

cPRex

Jurassic Moderator
Staff member
Oct 19, 2014
12,499
1,971
363
cPanel Access Level
Root Administrator
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.
 
  • Like
Reactions: hostprime

hostprime

Registered
Jun 7, 2022
2
0
1
brazil
cPanel Access Level
Root Administrator
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
 

cPRex

Jurassic Moderator
Staff member
Oct 19, 2014
12,499
1,971
363
cPanel Access Level
Root Administrator
  • Like
Reactions: hostprime