cPanel reports MySQL down but sites work

[email protected]

Active Member
Aug 6, 2018
31
3
8
india
cPanel Access Level
Root Administrator
Hi,

cpanel is showing mysql is down but all my sites using database are working fine.

but clients are not able to open phpmyadmin.

mysql 10.2.16 down
/scripts/restartsrv_mysql --status output
mysql (/usr/sbin/mysqld) is running as mysql with PID 3098 (systemd+/proc check method).
System info
/etc/redhat-release:CentOS Linux release 7.5.1804 (Core)
/usr/local/cpanel/version:11.72.0.10
/var/cpanel/envtype:kvm
CPANEL=release
Thanks
 

cPanelMichael

Technical Support Community Manager
Staff member
Apr 11, 2011
47,910
2,233
363
cPanel Access Level
DataCenter Provider
Twitter
Hello @[email protected],

Can you let us know of any output to the MySQL error log (/var/lib/mysql/$hostname.err) upon restarting the MySQL server or when accessing phpMyAdmin? Also, please post the output from the following command:

Code:
mysql --version
Thank you.
 

[email protected]

Active Member
Aug 6, 2018
31
3
8
india
cPanel Access Level
Root Administrator
Hi,

Thank you for your reply please check the below output

mysql Ver 15.1 Distrib 10.2.16-MariaDB, for Linux (x86_64) using readline 5.1
/var/lib/mysql/$hostname.err output


2018-07-25 6:01:53 140567280888000 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-07-25 6:01:53 140567280888000 [Note] InnoDB: Uses event mutexes
2018-07-25 6:01:53 140567280888000 [Note] InnoDB: Compressed tables use zlib 1.2.7
2018-07-25 6:01:53 140567280888000 [Note] InnoDB: Using Linux native AIO
2018-07-25 6:01:53 140567280888000 [Note] InnoDB: Number of pools: 1
2018-07-25 6:01:53 140567280888000 [Note] InnoDB: Using generic crc32 instructions
2018-07-25 6:01:53 140567280888000 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2018-07-25 6:01:53 140567280888000 [Note] InnoDB: Completed initialization of buffer pool
2018-07-25 6:01:53 140566508357376 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2018-07-25 6:01:53 140567280888000 [Note] InnoDB: Highest supported file format is Barracuda.
2018-07-25 6:01:53 140567280888000 [Note] InnoDB: 128 out of 128 rollback segments are active.
2018-07-25 6:01:53 140567280888000 [Note] InnoDB: Creating shared tablespace for temporary tables
2018-07-25 6:01:53 140567280888000 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2018-07-25 6:01:53 140567280888000 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2018-07-25 6:01:53 140567280888000 [Note] InnoDB: Waiting for purge to start
2018-07-25 6:01:53 140567280888000 [Note] InnoDB: 5.7.22 started; log sequence number 2696356
2018-07-25 6:01:53 140566268462848 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2018-07-25 6:01:53 140567280888000 [Note] Plugin 'FEEDBACK' is disabled.
2018-07-25 6:01:53 140566268462848 [Note] InnoDB: Buffer pool(s) load completed at 180725 6:01:53
2018-07-25 6:01:53 140567280888000 [Note] Server socket created on IP: '::'.
2018-07-25 6:01:53 140567280888000 [ERROR] Missing system table mysql.roles_mapping; please run mysql_upgrade to create it
2018-07-25 6:01:53 140567280888000 [ERROR] mysql.user has no `Event_priv` column at position 29
2018-07-25 6:01:53 140567280888000 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14 to have type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH'), found type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_A
2018-07-25 6:01:53 140567280888000 [ERROR] mysqld: Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
2018-07-25 6:01:53 140567166678784 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist
2018-07-25 6:01:53 140567280888000 [Note] Reading of all Master_info entries succeded
2018-07-25 6:01:53 140567280888000 [Note] Added new Master_info '' to hash table
2018-07-25 6:01:53 140567280888000 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.2.16-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
 

cPanelMichael

Technical Support Community Manager
Staff member
Apr 11, 2011
47,910
2,233
363
cPanel Access Level
DataCenter Provider
Twitter
2018-07-25 6:01:53 140567280888000 [ERROR] Missing system table mysql.roles_mapping; please run mysql_upgrade to create it
2018-07-25 6:01:53 140567280888000 [ERROR] mysql.user has no `Event_priv` column at position 29
2018-07-25 6:01:53 140567280888000 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14 to have type
Hello @[email protected],

Can you try forcing an upgrade of the MySQL tables by running the below command?

Code:
mysql_upgrade --force
Then, restart MySQL to see if the same errors are logged to the MySQL error log.

Thank you.