Results 1 to 2 of 2

Thread: Mysql issue

  1. #1
    onlive-server is offline Newbie
    Join Date
    Feb 2018
    Posts
    2

    Default Mysql issue

    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.
    ---------------------------------------------------------------------
    Last edited by GlowHost-Daniel; 02-27-2018 at 06:08 PM.

  2. #2
    Matt's Avatar
    Matt is offline GlowHost Administrator
    Join Date
    Jan 2005
    Location
    Behind your monitor
    Posts
    5,013

    Default

    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.
    Send your friends and site visitors to GlowHost and get $125 plus bonus!
    GlowHost Affiliate Program | Read our Blog | GlowHost's Facebook | Follow us on Twitter | GlowHost on Google+

Similar Threads

  1. Replies: 26
    Last Post: 02-01-2008, 09:17 PM
  2. Replies: 0
    Last Post: 04-21-2005, 10:13 PM
  3. Replies: 0
    Last Post: 04-21-2005, 10:13 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16