IT外包:解决客户呼叫中心系统MYSQL No space left on device错误
发布时间:2015-12-19 12:01:54 浏览量:1998 【字体:大 中 小】
客户紧急报修,呼叫中心系统瘫痪,无法呼出呼进。高级工程师远程连接系统后台检查:
[root@CallCenter ~]# service mysql start
Starting MySQL................................... [FAILED]
touch: cannot touch `/var/lock/subsys/mysql': No space left on device
[root@CallCenter ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
4.3G 3.4G 726M 83% /
/dev/sda1 99M 14M 80M 15% /boot
none 196M 0 196M 0% /dev/shm
发现磁盘空间正常,数据库无法启动,可能是inode用完了,真的是inode用完了,磁盘没法再写入新的内容了,这个是某些临时的小文件太多了,把inode用完了,把它删掉就行了。
[root@CallCenter subsys]# df -i
Filesystem Inodes IUsed IFree IUse% Mounted on
/dev/mapper/VolGroup00-LogVol00
570080 570080 0 100% /
/dev/sda1 26104 39 26065 1% /boot
none 50009 1 50008 1% /dev/shm
[root@CallCenter subsys]# cd /var/spool/
[root@CallCenter spool]# ls
anacron asterisk at clientmqueue cron cups lpd mail mqueue repackage up2date vbox
[root@CallCenter spool]# cd clientmqueue/
[root@CallCenter clientmqueue]# ls |xargs rm -rf
[root@CallCenter clientmqueue]# df -i
Filesystem Inodes IUsed IFree IUse% Mounted on
/dev/mapper/VolGroup00-LogVol00
570080 314446 255634 56% /
/dev/sda1 26104 39 26065 1% /boot
none 50009 1 50008 1% /dev/shm
[root@CallCenter ~]# service mysql start
Starting MySQL................................. [ OK ]
搞定