Mysql issue

[onlive-server]

Hello,

I have faced this log message, whenever i start the MySQL service, it is restarted but after all of website show database connection error, then i have to restarted it again and again alternative then website work and after some time it has again show same error. If there is any solutions please update me, i have also repair MySQL database but same thing happened.
----------------------------------------------------------------------------------------------------------------------------


[2018-02-27 13:48:24 +0530] warn [restartsrv_mysql] Unable to write datastore file: /root/.cpanel/datastore/_usr_bin_mysqladmin_variables: target directory: /root/.cpanel/datastore does not match uid 0 at /usr/local/cpanel/Cpanel/CachedCommand/Save.pm line 31. Cpanel::CachedCommand::Save::_savefile(__CPANEL_HI DDEN_, _CPANEL_HIDDEN_) called at /usr/local/cpanel/Cpanel/CachedCommand.pm line 144 Cpanel::CachedCommand::_cached_cmd("binary", "/usr/bin/mysqladmin", "args", ARRAY(0x25cf680), "mtime", 1518265033, "ttl", 86400, ...) called at /usr/local/cpanel/Cpanel/MysqlUtils/Dir.pm line 36 Cpanel::MysqlUtils:ir::__ANON_() called at /usr/local/cpanel/3rdparty/perl/524/lib64/perl5/cpanel_lib/Try/Tiny.pm line 97 eval {...} called at /usr/local/cpanel/3rdparty/perl/524/lib64/perl5/cpanel_lib/Try/Tiny.pm line 90 Try::Tiny::try(CODE(0x25cf7b8)) called at /usr/local/cpanel/Cpanel/MysqlUtils/Dir.pm line 43 Cpanel::MysqlUtils:ir::getmysqldir() called at /usr/local/cpanel/Cpanel/MysqlUtils/Service.pm line 131 Cpanel::MysqlUtils::Service::get_mysql_hostname_pi d_file() called at /usr/local/cpanel/Cpanel/MysqlUtils/Service.pm line 59 Cpanel::MysqlUtils::Service::get_mysql_pid_file() called at /usr/local/cpanel/Cpanel/ServiceManager/Services/Mysql.pm line 40 Cpanel::ServiceManager::Services::Mysql:idfile(Cpanel::ServiceManager::Services::Mysql=HAS H(0x20e3128)) called at /usr/local/cpanel/Cpanel/ServiceManager/Base.pm line 824 Cpanel::ServiceManager::Base::start(Cpanel::Servic eManager::Services::Mysql=HASH(0x20e3128)) called at /usr/local/cpanel/Cpanel/ServiceManager/Services/Mysql.pm line 56 Cpanel::ServiceManager::Services::Mysql::start(Cpa nel::ServiceManager::Services::Mysql=HASH(0x20e312 8)) called at /usr/local/cpanel/Cpanel/ServiceManager/Base.pm line 703 Cpanel::ServiceManager::Base::restart(Cpanel::Serv iceManager::Services::Mysql=HASH(0x20e3128), "graceful", undef) called at /usr/local/cpanel/Cpanel/ServiceManager/Base.pm line 537 Cpanel::ServiceManager::Base::run_from_argv(Cpanel ::ServiceManager::Services::Mysql=HASH(0x20e3128), "--verbose", "--html", "--wait", "--verbose") called at bin/restartsrv_base.pl line 74 main::__ANON__() called at /usr/local/cpanel/3rdparty/perl/524/lib64/perl5/cpanel_lib/Try/Tiny.pm line 99 eval {...} called at /usr/local/cpanel/3rdparty/perl/524/lib64/perl5/cpanel_lib/Try/Tiny.pm line 90 Try::Tiny::try(CODE(0xbf3fc0), Try::Tiny::Catch=REF(0x2174318)) called at bin/restartsrv_base.pl line 109 warn [restartsrv_mysql] Unable to write datastore file: /root/.cpanel/datastore/_usr_bin_mysqladmin_variables: target directory: /root/.cpanel/datastore does not match uid 0 Waiting for “mysql” to start ……waiting for “mysql” to initialize ………finished.


Service Status
mysql (/bin/sh /usr/bin/mysqld_safe) is running as mysql with PID 7192 (systemd+/proc check method).
mysql (/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=host.********.err --pid-file=host.********.pid) is running as mysql with PID 7365 (systemd+/proc check method).


Startup Log
Feb 13:48:24 host.******** systemd[1]: Started MySQL Server.
Feb 27 13:48:24 host.******** systemd[1]: Starting MySQL Server...
Feb 27 13:48:24 host.******** mysqld_safe[7192]: 180210 17:48:24 mysqld_safe Logging to '/var/lib/mysql/host.********.err'.
Feb 27 13:48:24 host.******** mysqld_safe[7192]: 180210 17:48:24 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql


Log Messages
2018-02-10 17:48:24 7365 [Note] /usr/sbin/mysqld: ready for connections.
180210 17:48:24 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
180210 17:48:24 mysqld_safe Logging to '/var/lib/mysql/host.********.err'.
180210 17:46:21 mysqld_safe mysqld from pid file /var/lib/mysql/host.****************.pid ended
2018-02-10 17:46:21 4363 [Note] /usr/sbin/mysqld: Shutdown complete
2018-02-10 17:46:19 4363 [Warning] /usr/sbin/mysqld: Forcing close of thread 351 user: ''
2018-02-10 17:46:17 4363 [Note] /usr/sbin/mysqld: Normal shutdown
2018-02-10 17:43:25 4363 [Note] /usr/sbin/mysqld: ready for connections.
---------------------------------------------------------------------

[Matt]

Hello,

If you have an account with GlowHost, please open a support ticket and we can assist you by logging into your server and fixing it for you.