Skip to main content

MySQL is missing!

Jcats
Hello, I wanted to see if anyone has run into this recently. Over the past 2 ~ weeks or so, I've had to completely reinstall mysql on about 10 different servers because it just magically disappeared. There is nothing at all out of the ordinary at the time mysql vanished.
150709 6:02:32 [Note] /usr/sbin/mysqld: Normal shutdown 150709 6:02:32 [Note] Event Scheduler: Purging the queue. 0 events 150709 6:02:32 InnoDB: Starting shutdown... 150709 6:02:33 InnoDB: Shutdown completed; log sequence number 110126486 150709 6:02:33 [Note] /usr/sbin/mysqld: Shutdown complete 150709 06:02:33 mysqld_safe mysqld from pid file /var/lib/mysql/vps.domain.com.pid ended root@vps [/]# service mysql status mysql: unrecognized service
This only started happening since 11.50 UPCP ran right around that time: -rw------- 1 root root 2.1M Jul 9 06:05 update.1436436901.log Some related instances in the log show:
[2015-07-09 06:02:30 -0500] Updating / Removing RPMS. [2015-07-09 06:02:31 -0500] Uninstalling unneeded rpms: MySQL55-test MySQL55-server MySQL55-client MySQL55-shared MySQL55-devel [2015-07-09 06:03:09 -0500] 38% complete [2015-07-09 06:03:09 -0500] - Processing command `/usr/local/cpanel/scripts/purge_old_config_caches` [2015-07-09 06:03:09 -0500] - Processing command `/usr/local/cpanel/scripts/cleansessions` [2015-07-09 06:03:09 -0500] - Processing command `/usr/local/cpanel/scripts/checkbashshell` [2015-07-09 06:03:09 -0500] - Processing command `/usr/local/cpanel/scripts/purge_modsec_log` [2015-07-09 06:03:09 -0500] [14061] Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) /usr/local/bin/php: error while loading shared libraries: libmysqlclient.so.18: cannot open shared object file: No such file or directory /usr/local/bin/php: error while loading shared libraries: libmysqlclient.so.18: cannot open shared object file: No such file or directory /usr/local/bin/php: error while loading shared libraries: libmysqlclient.so.18: cannot open shared object file: No such file or directory /usr/local/bin/php: error while loading shared libraries: libmysqlclient.so.18: cannot open shared object file: No such file or directory /usr/local/bin/php: error while loading shared libraries: libmysqlclient.so.18: cannot open shared object file: No such file or directory /usr/local/bin/php: error while loading shared libraries: libmysqlclient.so.18: cannot open shared object file: No such file or directory /usr/local/bin/php: error while loading shared libraries: libmysqlclient.so.18: cannot open shared object file: No such file or directory /usr/local/bin/php: error while loading shared libraries: libmysqlclient.so.18: cannot open shared object file: No such file or directory /usr/local/bin/php: error while loading shared libraries: libmysqlclient.so.18: cannot open shared object file: No such file or directory /usr/local/bin/php: error while loading shared libraries: libmysqlclient.so.18: cannot open shared object file: No such file or directory
I think its clear that cPanel uninstalled an RPM that shouldn't have been? This happened to ~ 10 servers now, anyone else?

Comments

15 comments

Date Votes
  • cPanelMichael
    Hello :) Please post the output from the following commands on a server where this occurred:
    grep mysql-version /var/cpanel/cpanel.config rpm -qa|grep MySQL cat /var/cpanel/rpm.versions.d/local.versions
    Thank you.
    0
  • Jcats
    This might not help now because I had installed mariadb using:
    0
  • Jcats
    Just to be clear though,
    0
  • Jcats
    This just happened again on a dedicated. MySQL is gone. [Tue Jul 28 10:33:39.280719 2015] [:error] [pid 6700] [client x.x.x.x:53034] /usr/bin/php: error while loading shared libraries: libmysqlclient.so.18: cannot open shared object file: No such file or directory root@server [~]# whereis mysql mysql: /usr/lib64/mysql /usr/local/lib/mysql.sock I removed mysql* from /etc/yum.conf, used yum to install mysql mysql-server then ran the mariaupgrade in WHM which resolved it, but I don't understand what could possibly be causing this to keep happening to random servers.
    0
  • ModServ
    After switching to MariaDB, did you perform an EasyApache?
    0
  • Jcats
    Yes, I had to run /scripts/easyapache --build as the mariadb upgrade failed at some point even though it did actually install mariadb successfully.
    0
  • cPanelMichael
    Could you verify if you are using Cloud Linux with the MySQL Governor plugin? Thank you.
    0
  • Jcats
    We are not. This is still happening by the way, both to VPS and dedicated server installs. I've had to reinstall MySQL on 5 completely different servers within the past 2 days, all new installs. I have to go into /etc/yum.conf remove mysql*, then yum -y install mysql mysql-server then run the mariadb upgrade twice because it fails the first time.
    0
  • Jcats
    I am doing one now as we speak: root@server [~]# php -v php: error while loading shared libraries: libmysqlclient.so.18: cannot open shared object file: No such file or directory root@server [~]# mysql -bash: mysql: command not found
    0
  • cPanelMichael
    Could you open a support ticket using the link in my signature before resolving the issue next time? Post the ticket number here so we can update this thread with the outcome. Thank you.
    0
  • Jcats
    Ill do a fresh install on a test server only because I cannot have a customer wait for you to resolve it, I am not saying your response times are slow by any means because you guys are awesome anytime we need to open a ticket but every second counts :) Ill open a ticket once the issue comes about which usually occurs after a cPanel update. Thanks!
    0
  • Jcats
    Ah fail on my part :( For the longest time I ran a bash script I created to install csf, configure tweak settings, etc, etc. I just noticed in my cpanel.config: mysql-version=10.0 I am assuming when upcp runs it sees that and is removing the rpm's that are currently installed which are not 10. Is there a way we can install MariaDB by default when running the cPanel installer?
    0
  • cPanelMichael
    Is there a way we can install MariaDB by default when running the cPanel installer?

    Yes, this is possible via the instructions at:
    Thank you.
    0
  • Jcats
    Yeah that's what I was doing but without thinking I was pulling cpanel.config AFTER cPanel was already installed, dumb mistake on my part which was causing cPanel to uninstall MySQL when upcp was ran. Thanks for the info.
    0
  • cPanelMichael
    I am happy to see you were able to address the issue. Thank you for updating us with the outcome.
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post