problem after upgrade mysql to 5.6.17

ArabNewTech

• September 02, 2014 15:18

After upgrade MySql to 5.6.17 it always down and give my Error establishing a database connection and when i log in cpanel show this error The MySQL server is currently offline. Error while connecting to MySQL: Cpanel::DBI::Mysql connect('','root',...) failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) at /usr/local/cpanel/Cpanel/MysqlUtils/Connect.pm line 136 Error while connecting to MySQL: Cpanel::DBI::Mysql connect('','root',...) failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) at /usr/local/cpanel/Cpanel/MysqlUtils/Connect.pm line 136 ...caught

• 

  triantech

  • September 03, 2014 02:55

  hey Can you check if your system memory is on the fuller side when mysql does run?

  0
• 

  server9host

  • September 03, 2014 06:01

  Hello, This may be because, somehow the /tmp partition has been cleared and the MySQL server is looking for the PID file there. So easy-peasy just create a new pid file and restart the server. touch /tmp/mysql.sock service mysqld restart
  If this not work then you need to kill current mysql process from server using below steps : ps -aufx | grep mysql
  You get all process of mysql with process ID. You need to kill all PID for mysql using below command kill -9 PID1 PD2...
  then restart mysql service service mysql restart
  

  0
• 

  ArabNewTech

  • September 03, 2014 10:32

  this is output for command : root@host [~]# ps -aufx | grep mysql Warning: bad syntax, perhaps a bogus '-'? See /usr/share/doc/procps-3.2.8/FAQ root 19671 0.0 0.0 103248 828 pts/0 S+ 13:10 0:00 \_ gre p mysql root 14624 0.3 0.0 16100 5964 ? S 02:16 2:01 /bin/sh /usr/bi n/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/host.arabnewtec h.com.pid mysql 19633 52.8 30.3 4180656 2193884 ? Sl 13:10 0:02 \_ /usr/sbin/m ysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plug in --user=mysql --log-error=/var/lib/mysql/host.arabnewtech.com.err --open-files -limit=150000 --pid-file=/var/lib/mysql/host.arabnewtech.com.pid root@host [~]# ps ax | grep mysqld 14624 ? S 2:04 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/host.arabnewtech.com.pid 21843 ? R 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/my sql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql /host.arabnewtech.com.err --open-files-limit=150000 --pid-file=/var/lib/mysql/ho st.arabnewtech.com.pid 21852 pts/0 S+ 0:00 grep mysqld root@host [~]# pico /etc/my.cnf root@host [~]# pico /etc/my.cnf root@host [~]# /scripts/restartsrv mysql Waiting for mysql to restart...........finished. mysqld_safe (/bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/host.arabnewtech.com.pid) running as root with PID 27616 (process table check method) mysqld (/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/host.arabnewtech.com.err --open-files-limit=100000 --pid-file=/var/lib/mysql/host.arabnewtech.com.pid) running as mysql with PID 28010 (pidfile check method)
  

  0
• 

  cPanelPeter cPanel Staff

  • September 03, 2014 12:29

  Hello, Please open a ticket on this issue using the link within my signature. Our development team would like to take a look at this issue as soon as possible.

  0
• 

  cPanelMichael

  • September 03, 2014 16:21

  Hello :) Ticket number 5417259 was opened to address this issue. It looks like this issue was the result of the /tmp partition reaching 100% of it's disk space capacity. Thank you.

  0

Please sign in to leave a comment.