AnsweredAssumed Answered

MySQL DB is full with ERROR 2002

Question asked by Ashutosh Singh on Feb 1, 2018
Latest reply on Feb 5, 2018 by Ashutosh Singh

Hello All,

 

Recently we upgraded our gateway t 9.3 version and OTK to 4.2. However after the upgrade, we ran an endurance test on the environment and seeing that SQL has stopped working.

 

Whenever we try to open MYSQL, we get error like below.

 

[root@xxxxxxxxxxxxtmp]# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

 

Below is a snippet of df -kh...

 

[root@************ tmp]# df -kh
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/vg00-lv_root
7.9G 2.0G 5.6G 27% /
tmpfs 16G 0 16G 0% /dev/shm
/dev/sda1 1008M 58M 900M 7% /boot
/dev/mapper/vg00-lv_home
5.0G 222M 4.5G 5% /home
/dev/mapper/vg00-lv_opt
6.9G 3.4G 3.3G 51% /opt
/dev/mapper/vg00-lv_tmp
6.9G 4.4G 2.3G 67% /tmp
/dev/mapper/vg00-lv_var
3.0G 115M 2.7G 4% /var
/dev/mapper/vg00-lv_db
21G 20G 12M 100% /var/lib/mysql
/dev/mapper/vg00-lv_log
2.0G 1.9G 70M 97% /var/log
/dev/mapper/vg00-lv_audit
2.0G 92M 1.8G 5% /var/log/audit

 

And below is the snippet of /var/lib/mysql location where ibdata can be seen as a very huge file.

 

drwxr-xr-x 2 mysql mysql 4096 Dec 14 2016 test
drwx------ 2 mysql mysql 4096 Dec 14 2016 lost@002bfound
-rw-rw---- 1 mysql mysql 1428 Jun 6 2017 localhost-slow.log
-rw-r--r-- 1 mysql mysql 276 Jan 28 20:56 RPM_UPGRADE_MARKER-LAST
-rw-r--r-- 1 mysql mysql 1188 Jan 28 20:56 RPM_UPGRADE_HISTORY
-rw-rw---- 1 mysql mysql 56 Jan 28 20:57 auto.cnf
drwxr-x--- 2 mysql mysql 4096 Jan 28 20:57 performance_schema
drwxr-x--- 2 mysql mysql 12288 Jan 28 20:57 sys
-rw-r--r-- 1 mysql mysql 6 Jan 28 20:57 mysql_upgrade_info
drwx--x--x 2 mysql mysql 4096 Jan 28 20:57 mysql
-rw-r----- 1 mysql mysql 6289 Jan 31 21:59 ib_buffer_pool
-rw------- 1 mysql mysql 6 Feb 1 06:56 mysql.sock.lock
-rw-rw---- 1 mysql mysql 43036 Feb 1 06:56 las2app2448arv-slow.log
-rw-rw---- 1 mysql mysql 16620978176 Feb 1 09:28 ibdata
drwx------ 2 mysql mysql 4096 Feb 1 09:28 ssg
-rw-r----- 1 mysql mysql 16777216 Feb 1 09:28 ib_logfile1
-rw-r----- 1 mysql mysql 16777216 Feb 1 14:31 ib_logfile0

Outcomes