cPanel reports MySQL down but sites work

asdcxz@1239

• August 06, 2018 08:39

Hi, cpanel is showing mysql is down but all my sites using database are working fine. but clients are not able to open phpmyadmin. [QUOTE]mysql 10.2.16 down
/scripts/restartsrv_mysql --status output [QUOTE]mysql (/usr/sbin/mysqld) is running as mysql with PID 3098 (systemd+/proc check method).
System info [QUOTE] /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

  • August 06, 2018 17:42

  Hello @asdcxz@1239, 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: mysql --version
  Thank you.

  0
• 

  asdcxz@1239

  • August 06, 2018 17:49

  Hi, Thank you for your reply please check the below output [QUOTE] mysql Ver 15.1 Distrib 10.2.16-MariaDB, for Linux (x86_64) using readline 5.1
  /var/lib/mysql/$hostname.err output [QUOTE] 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
  

  0
• 

  cPanelMichael

  • August 06, 2018 18:37

  [QUOTE="asdcxz@1239, post: 2584421, member: 927957"> 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 @asdcxz@1239, Can you try forcing an upgrade of the MySQL tables by running the below command? mysql_upgrade --force
  Then, restart MySQL to see if the same errors are logged to the MySQL error log. Thank you.

  0
• 

  asdcxz@1239

  • August 06, 2018 18:40

  Hi, Getting this error access denied [QUOTE] Version check failed. Got the following error when calling the 'mysql' command line client ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) FATAL ERROR: Upgrade failed
  

  0
• 

  cPanelMichael

  • August 06, 2018 19:20

  Hello @asdcxz@1239, Can you open a

  0
• 

  asdcxz@1239

  • August 06, 2018 19:34

  Hi, Opened ticket #10062365 Thank you

  0
• 

  cPanelMichael

  • August 07, 2018 14:49

  Hello @asdcxz@1239, I see the authentication details were provided, but the required information for the ticket is not yet completed. Can you follow "Step 6" on the document below? Create Support Ticket - Version 74 Documentation - cPanel Documentation Thank you.

  0

Please sign in to leave a comment.