Hi
I just got this error:
----- MySQL Error : Table './db_name/searchcore_text' is marked as crashed and last (automatic?) repair failed
So I start the repair feature under AdminCP -> Maintenance -> Repair/Optimize Tables, and being stuck for hours
When someone tries to do something in the forum, I also get this error:
---- MySQL Error : Can't create/write to file '/tmp/MYgPUht5' (Errcode: 28)
Disk space:
Temp folder gets full
I can change it to another folder with more space, basically to the root, but I need to restart the MySQL service, how bad or safe is it since its repairing the table, but maybe stuck since no space.
Those temp files are using all the space
NEEDING some help urgent
Thank you
I just got this error:
----- MySQL Error : Table './db_name/searchcore_text' is marked as crashed and last (automatic?) repair failed
So I start the repair feature under AdminCP -> Maintenance -> Repair/Optimize Tables, and being stuck for hours
When someone tries to do something in the forum, I also get this error:
---- MySQL Error : Can't create/write to file '/tmp/MYgPUht5' (Errcode: 28)
Disk space:
root@svr2 [/]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/md3 442G 45G 376G 11% /
tmpfs 7.8G 0 7.8G 0% /dev/shm
/dev/md0 477M 51M 401M 12% /boot
/usr/tmpDSK 4.0G 3.8G 0 100% /tmp
Filesystem Size Used Avail Use% Mounted on
/dev/md3 442G 45G 376G 11% /
tmpfs 7.8G 0 7.8G 0% /dev/shm
/dev/md0 477M 51M 401M 12% /boot
/usr/tmpDSK 4.0G 3.8G 0 100% /tmp
Temp folder gets full
root@svr2 [/]# mysqld --verbose --help | grep tmp
180731 7:55:27 [Note] mysqld (mysqld 5.5.52-cll) starting as process 25435 ...
180731 7:55:27 [Note] Plugin 'FEDERATED' is disabled.
--max-tmp-tables=# Maximum number of temporary tables a client can keep open
--slave-load-tmpdir=name
--tmp-table-size=# If an internal in-memory temporary table exceeds this
-t, --tmpdir=name Path for temporary files. Several paths may be specified,
max-tmp-tables 32
slave-load-tmpdir /tmp
tmp-table-size 268435456
tmpdir /tmp
180731 7:55:27 [Note] mysqld (mysqld 5.5.52-cll) starting as process 25435 ...
180731 7:55:27 [Note] Plugin 'FEDERATED' is disabled.
--max-tmp-tables=# Maximum number of temporary tables a client can keep open
--slave-load-tmpdir=name
--tmp-table-size=# If an internal in-memory temporary table exceeds this
-t, --tmpdir=name Path for temporary files. Several paths may be specified,
max-tmp-tables 32
slave-load-tmpdir /tmp
tmp-table-size 268435456
tmpdir /tmp
I can change it to another folder with more space, basically to the root, but I need to restart the MySQL service, how bad or safe is it since its repairing the table, but maybe stuck since no space.
root@svr2 [/]# lsof | egrep '^COMMAND|deleted'
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
init 1 root txt REG 9,3 150352 8781962 /sbin/init (deleted)
dovecot 2604 root 123u REG 9,3 0 2884562 /var/run/dovecot/login-master-notifyfdacd91a720156dc (deleted)
dovecot 2604 root 140u REG 9,3 0 2884570 /var/run/dovecot/login-master-notify609544a0c72c41dd (deleted)
dovecot 2604 root 143u REG 9,3 0 2884624 /var/run/dovecot/login-master-notify19dd2fce8eb704c0 (deleted)
pop3-logi 2615 dovenull 4u REG 9,3 0 2884562 /var/run/dovecot/login-master-notifyfdacd91a720156dc (deleted)
imap-logi 2616 dovenull 4u REG 9,3 0 2884624 /var/run/dovecot/login-master-notify19dd2fce8eb704c0 (deleted)
pop3-logi 2620 dovenull 4u REG 9,3 0 2884562 /var/run/dovecot/login-master-notifyfdacd91a720156dc (deleted)
imap-logi 2621 dovenull 4u REG 9,3 0 2884624 /var/run/dovecot/login-master-notify19dd2fce8eb704c0 (deleted)
httpd 2624 root 11w REG 9,3 0 10882019 /usr/local/apache/logs/ssl_mutex (deleted)
httpd 4312 nobody 11w REG 9,3 0 10882019 /usr/local/apache/logs/ssl_mutex (deleted)
httpd 8977 nobody 11w REG 9,3 0 10882019 /usr/local/apache/logs/ssl_mutex (deleted)
httpd 8978 nobody 11w REG 9,3 0 10882019 /usr/local/apache/logs/ssl_mutex (deleted)
httpd 8979 nobody 11w REG 9,3 0 10882019 /usr/local/apache/logs/ssl_mutex (deleted)
httpd 13611 nobody 11w REG 9,3 0 10882019 /usr/local/apache/logs/ssl_mutex (deleted)
httpd 13613 nobody 11w REG 9,3 0 10882019 /usr/local/apache/logs/ssl_mutex (deleted)
httpd 15645 nobody 11w REG 9,3 0 10882019 /usr/local/apache/logs/ssl_mutex (deleted)
httpd 18190 nobody 11w REG 9,3 0 10882019 /usr/local/apache/logs/ssl_mutex (deleted)
httpd 18191 nobody 11w REG 9,3 0 10882019 /usr/local/apache/logs/ssl_mutex (deleted)
mysqld 23070 mysql 4u REG 7,0 0 11 /tmp/ibcjJNBb (deleted)
mysqld 23070 mysql 5u REG 7,0 0 12 /tmp/ibIk2E7h (deleted)
mysqld 23070 mysql 6u REG 7,0 0 13 /tmp/ibOiDwDo (deleted)
mysqld 23070 mysql 7u REG 7,0 0 14 /tmp/ib2FfjpC (deleted)
mysqld 23070 mysql 11u REG 7,0 0 15 /tmp/ibjChTdK (deleted)
mysqld 23070 mysql 1120u REG 7,0 2477435882 18 /tmp/STbrwhd8 (deleted)
mysqld 23070 mysql 1122u REG 7,0 19529728 19 /tmp/STeqT6pV (deleted)
mysqld 23070 mysql 1128u REG 7,0 1369624576 20 /tmp/STVMcfDS (deleted)
httpd 23976 nobody 11w REG 9,3 0 10882019 /usr/local/apache/logs/ssl_mutex (deleted)
root@svr2 [/]#
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
init 1 root txt REG 9,3 150352 8781962 /sbin/init (deleted)
dovecot 2604 root 123u REG 9,3 0 2884562 /var/run/dovecot/login-master-notifyfdacd91a720156dc (deleted)
dovecot 2604 root 140u REG 9,3 0 2884570 /var/run/dovecot/login-master-notify609544a0c72c41dd (deleted)
dovecot 2604 root 143u REG 9,3 0 2884624 /var/run/dovecot/login-master-notify19dd2fce8eb704c0 (deleted)
pop3-logi 2615 dovenull 4u REG 9,3 0 2884562 /var/run/dovecot/login-master-notifyfdacd91a720156dc (deleted)
imap-logi 2616 dovenull 4u REG 9,3 0 2884624 /var/run/dovecot/login-master-notify19dd2fce8eb704c0 (deleted)
pop3-logi 2620 dovenull 4u REG 9,3 0 2884562 /var/run/dovecot/login-master-notifyfdacd91a720156dc (deleted)
imap-logi 2621 dovenull 4u REG 9,3 0 2884624 /var/run/dovecot/login-master-notify19dd2fce8eb704c0 (deleted)
httpd 2624 root 11w REG 9,3 0 10882019 /usr/local/apache/logs/ssl_mutex (deleted)
httpd 4312 nobody 11w REG 9,3 0 10882019 /usr/local/apache/logs/ssl_mutex (deleted)
httpd 8977 nobody 11w REG 9,3 0 10882019 /usr/local/apache/logs/ssl_mutex (deleted)
httpd 8978 nobody 11w REG 9,3 0 10882019 /usr/local/apache/logs/ssl_mutex (deleted)
httpd 8979 nobody 11w REG 9,3 0 10882019 /usr/local/apache/logs/ssl_mutex (deleted)
httpd 13611 nobody 11w REG 9,3 0 10882019 /usr/local/apache/logs/ssl_mutex (deleted)
httpd 13613 nobody 11w REG 9,3 0 10882019 /usr/local/apache/logs/ssl_mutex (deleted)
httpd 15645 nobody 11w REG 9,3 0 10882019 /usr/local/apache/logs/ssl_mutex (deleted)
httpd 18190 nobody 11w REG 9,3 0 10882019 /usr/local/apache/logs/ssl_mutex (deleted)
httpd 18191 nobody 11w REG 9,3 0 10882019 /usr/local/apache/logs/ssl_mutex (deleted)
mysqld 23070 mysql 4u REG 7,0 0 11 /tmp/ibcjJNBb (deleted)
mysqld 23070 mysql 5u REG 7,0 0 12 /tmp/ibIk2E7h (deleted)
mysqld 23070 mysql 6u REG 7,0 0 13 /tmp/ibOiDwDo (deleted)
mysqld 23070 mysql 7u REG 7,0 0 14 /tmp/ib2FfjpC (deleted)
mysqld 23070 mysql 11u REG 7,0 0 15 /tmp/ibjChTdK (deleted)
mysqld 23070 mysql 1120u REG 7,0 2477435882 18 /tmp/STbrwhd8 (deleted)
mysqld 23070 mysql 1122u REG 7,0 19529728 19 /tmp/STeqT6pV (deleted)
mysqld 23070 mysql 1128u REG 7,0 1369624576 20 /tmp/STVMcfDS (deleted)
httpd 23976 nobody 11w REG 9,3 0 10882019 /usr/local/apache/logs/ssl_mutex (deleted)
root@svr2 [/]#
Those temp files are using all the space
NEEDING some help urgent
Thank you
Comment