Форум Сайтостроение Администрирование серверов

Can't create/write to file '/var/tmp/#sql3b7_7f_0.MYI

12
rtyug
На сайте с 13.05.2009
Offline
263
rtyug
4691

есть странная ошибка, как я понимаю тут mysql пытается создать временную таблицу для себя(tmp таблицу)

Can't execute select:
Can't create/write to file '/var/tmp/#sql3b7_7f_0.MYI' (Errcode: 28) at Modules/DataBase.pm line 82

посмотрел иноды

df -i
Filesystem  1K-blocks     Used     Avail Capacity iused    ifree %iused  Mounted on
/dev/ad1s1a 301718990 28009414 249572058    10%  210838 38791272    1%   /
devfs               1        1         0   100%       0        0  100%   /dev

вроде бы все нормально?

такая ошибка может быть из-за отсутствия памяти в mysql сервере? (если не хватает)

Спалил тему: Pokerstars вывод WMZ, etc на VISA 0% или SWIFT + Конверт USD/GBP,etc (net profit $0,5 млрд) (https://minfin.com.ua/blogs/94589307/115366/) Monobank - 50₴ на счет при рег. тут (https://clck.ru/DLX4r) | Номер SIP АТС Москва 7(495) - 0Ꝑ, 8(800) - 800Ꝑ/0Ꝑ (http://goo.gl/XOrCSn)
N
На сайте с 06.05.2007
Offline
419
netwind
#1

Найди глазами номер ошибки . у тебя тут Errcode: 28

Запусти perror 28 и увидишь сообщение.

В линуксе сообщение будет такое "OS error code 28: No space left on device". Но похоже и на freebsd имеет тот же смысл.

сколько места в /tmp ? может там специальная небольшая файловая система.

Кнопка вызова админа ()
Google сообщит пользователям, если В Facebook Messenger появились Page Rank теперь продают
rtyug
На сайте с 13.05.2009
Offline
263
rtyug
#2

сори, не понял, что имеется ввиду?

такую проблему в первые вижу!

кстати, может fsck проверить

но он выдает

# fsck /dev/ad1s1a
Can't stat /dev/ad1s1a: No such file or directory
Can't stat /dev/ad1s1a: No such file or directory
N
На сайте с 06.05.2007
Offline
419
netwind
#3

rtyug, вероятно место кончилось в том разделе где /tmp.

Файловую систему да завсегда можно проверить, если все ведет себя странно.

rtyug
На сайте с 13.05.2009
Offline
263
rtyug
#4 

df -i
Filesystem  1K-blocks     Used     Avail Capacity iused    ifree %iused  Mounted on
/dev/ad1s1a 301718990 28009414 249572058    10%  210838 38791272    1%   /
devfs               1        1         0   100%       0        0  100%   /dev

df показывает что раздел один, и нагрузки большой нету :)

M
На сайте с 01.12.2009
Offline
235
madoff
#5

Выполните 

chown -R mysql:mysql /var/tmp

chmod 751 /var/tmp

Покажите 

ls -la  /var/tmp
Администратор Linux,Freebsd. построения крупных проектов.
rtyug
На сайте с 13.05.2009
Offline
263
rtyug
#6

я сейчас зашел в каталог с файлами в который идет закачка файлов, в этом каталога должно быть максимум 5000

мне выдает ошибку:

/: create/symlink failed, no inodes free

повторю: что на такой ошибки раньше не было никогда

на linux при 40Тб, но там ыла какая-то FastFS

в messages

Apr 15 19:47:58 unknown-7553 kernel: g_vfs_done():ad1s1a[WRITE(offset=293723832320, length=10240)]error = 6
Apr 15 19:47:58 unknown-7553 kernel: g_vfs_done():ad1s1a[WRITE(offset=293664686080, length=16384)]error = 6
Apr 15 19:47:58 unknown-7553 kernel: g_vfs_done():ad1s1a[WRITE(offset=293723832320, length=10240)]error = 6
Apr 15 19:47:58 unknown-7553 kernel: g_vfs_done():ad1s1a[WRITE(offset=293664686080, length=16384)]error = 6
Apr 15 19:47:58 unknown-7553 kernel: g_vfs_done():ad1s1a[WRITE(offset=293723832320, length=10240)]error = 6
Apr 15 19:47:58 unknown-7553 kernel: g_vfs_done():ad1s1a[WRITE(offset=293664686080, length=16384)]error = 6
Apr 15 19:47:58 unknown-7553 kernel: g_vfs_done():ad1s1a[WRITE(offset=293723832320, length=10240)]error = 6
Apr 15 19:47:58 unknown-7553 kernel: g_vfs_done():ad1s1a[WRITE(offset=293664686080, length=16384)]error = 6
Apr 15 19:47:58 unknown-7553 kernel: g_vfs_done():ad1s1a[WRITE(offset=293723832320, length=10240)]error = 6
Apr 15 19:47:58 unknown-7553 kernel: g_vfs_done():ad1s1a[WRITE(offset=293664686080, length=16384)]error = 6
Apr 15 19:47:58 unknown-7553 kernel: g_vfs_done():ad1s1a[WRITE(offset=293723832320, length=10240)]error = 6
Apr 15 19:47:58 unknown-7553 kernel: g_vfs_done():ad1s1a[WRITE(offset=293664686080, length=16384)]error = 6
Apr 15 19:47:58 unknown-7553 kernel: g_vfs_done():ad1s1a[WRITE(offset=293723832320, length=10240)]error = 6
Apr 15 19:47:58 unknown-7553 kernel: g_vfs_done():ad1s1a[WRITE(offset=293664686080, length=16384)]error = 6
Apr 15 19:47:58 unknown-7553 kernel: g_vfs_done():ad1s1a[WRITE(offset=293723832320, length=12288)]error = 6
Apr 15 19:47:58 unknown-7553 kernel: g_vfs_done():ad1s1a[WRITE(offset=293664686080, length=16384)]error = 6
Apr 15 19:47:58 unknown-7553 kernel: g_vfs_done():ad1s1a[WRITE(offset=293723832320, length=12288)]error = 6
Apr 15 19:47:58 unknown-7553 kernel: g_vfs_done():ad1s1a[WRITE(offset=293664686080, length=16384)]error = 6
Apr 15 19:47:58 unknown-7553 kernel: g_vfs_done():ad1s1a[WRITE(offset=293723832320, length=12288)]error = 6
Apr 15 19:47:58 unknown-7553 kernel: g_vfs_done():ad1s1a[WRITE(offset=293664686080, length=16384)]error = 6
Apr 15 19:47:58 unknown-7553 kernel: g_vfs_done():ad1s1a[WRITE(offset=293723832320, length=12288)]error = 6
Apr 15 19:47:58 unknown-7553 kernel: g_vfs_done():ad1s1a[WRITE(offset=293664686080, length=16384)]error = 6
Apr 15 19:47:58 unknown-7553 kernel: g_vfs_done():ad1s1a[WRITE(offset=293723832320, length=12288)]error = 6
Apr 15 19:47:58 unknown-7553 kernel: g_vfs_done():ad1s1a[WRITE(offset=293664686080, length=16384)]error = 6
Apr 15 19:47:58 unknown-7553 kernel: g_vfs_done():ad1s1a[WRITE(offset=293723832320, length=12288)]error = 6
Apr 15 19:47:58 unknown-7553 kernel: g_vfs_done():ad1s1a[WRITE(offset=293664686080, length=16384)]error = 6
Apr 15 19:47:58 unknown-7553 kernel: g_vfs_done():ad1s1a[WRITE(offset=293723832320, length=12288)]error = 6
Apr 15 19:47:58 unknown-7553 kernel: g_vfs_done():ad1s1a[WRITE(offset=293664686080, length=16384)]error = 6
Apr 15 19:47:58 unknown-7553 kernel: g_vfs_done():ad1s1a[WRITE(offset=293723832320, length=12288)]error = 6
Apr 15 19:47:58 unknown-7553 kernel: g_vfs_done():ad1s1a[WRITE(offset=293664686080, length=16384)]error = 6
Apr 15 19:47:58 unknown-7553 kernel: g_vfs_done():ad1s1a[WRITE(offset=293723832320, length=12288)]error = 6
Apr 15 19:47:58 unknown-7553 kernel: g_vfs_done():ad1s1a[WRITE(offset=293664686080, length=16384)]error = 6
Apr 15 19:48:25 unknown-7553 kernel: Device ad1s1a went missing before all of the data could be written to it; expect data loss.
Apr 15 19:48:48 unknown-7553 kernel: Device ad1s1a went missing before all of the data could be written to it; expect data loss.
Apr 15 19:49:25 unknown-7553 kernel: pid 1575 (perl5.12.4), uid 1000 inumber 16371767 on /: out of inodes
Apr 15 19:50:03 unknown-7553 kernel: pid 1099 (httpd), uid 80 inumber 15762275 on /: filesystem full
Apr 15 19:50:04 unknown-7553 kernel: pid 1099 (httpd), uid 80 inumber 15762275 on /: filesystem full
Apr 15 19:50:31 unknown-7553 kernel: pid 1584 (perl5.12.4), uid 1000 inumber 15785820 on /: out of inodes
Apr 15 19:50:31 unknown-7553 kernel: pid 1540 (httpd), uid 80 inumber 15762275 on /: filesystem full
Apr 15 19:50:46 unknown-7553 kernel: pid 1173 (httpd), uid 80 inumber 15762275 on /: filesystem full
Apr 15 19:50:50 unknown-7553 kernel: pid 1587 (perl5.12.4), uid 1000 inumber 16348425 on /: out of inodes
Apr 15 19:50:50 unknown-7553 kernel: pid 1534 (httpd), uid 80 inumber 15762275 on /: filesystem full
Apr 15 19:51:16 unknown-7553 kernel: pid 1527 (httpd), uid 80 inumber 15762275 on /: filesystem full
Apr 15 19:51:17 unknown-7553 kernel: pid 1527 (httpd), uid 80 inumber 15762275 on /: filesystem full
Apr 15 19:52:20 unknown-7553 kernel: pid 1589 (perl5.12.4), uid 1000 inumber 15809373 on /: out of inodes
Apr 15 19:52:20 unknown-7553 kernel: pid 1088 (httpd), uid 80 inumber 15762275 on /: filesystem full
Apr 15 19:54:04 unknown-7553 kernel: pid 1533 (httpd), uid 80 inumber 15762275 on /: filesystem full
Apr 15 19:54:06 unknown-7553 kernel: pid 1099 (httpd), uid 80 inumber 15762275 on /: filesystem full
Apr 15 19:54:12 unknown-7553 kernel: pid 1534 (httpd), uid 80 inumber 15762275 on /: filesystem full
Apr 15 19:54:14 unknown-7553 kernel: pid 1534 (httpd), uid 80 inumber 15762275 on /: filesystem full
Apr 15 19:54:23 unknown-7553 kernel: pid 1532 (httpd), uid 80 inumber 15762275 on /: filesystem full
Apr 15 19:54:25 unknown-7553 kernel: pid 1532 (httpd), uid 80 inumber 15762275 on /: filesystem full


---------- Добавлено 15.04.2012 в 20:21 ----------

Покажите 
ls -la  /var/tmp

ls -la  /var/tmp
ls: packlist.072307: Device not configured
ls: packlist.113999: Device not configured
ls: packlist.119671: Device not configured
ls: packlist.136109: Device not configured
ls: packlist.169712: Device not configured
ls: packlist.223114: Device not configured
ls: packlist.255125: Device not configured
ls: packlist.255161: Device not configured
ls: packlist.281160: Device not configured
ls: packlist.283587: Device not configured
ls: packlist.301322: Device not configured
ls: packlist.348087: Device not configured
ls: packlist.386338: Device not configured
ls: packlist.397780: Device not configured
ls: packlist.412443: Device not configured
ls: packlist.413529: Device not configured
ls: packlist.432146: Device not configured
ls: packlist.434132: Device not configured
ls: packlist.476214: Device not configured
ls: packlist.493679: Device not configured
ls: packlist.523360: Device not configured
ls: packlist.551018: Device not configured
ls: packlist.625863: Device not configured
ls: packlist.634126: Device not configured
ls: packlist.648104: Device not configured
ls: packlist.659480: Device not configured
ls: packlist.705232: Device not configured
ls: packlist.745023: Device not configured
ls: packlist.745317: Device not configured
ls: packlist.764398: Device not configured
ls: packlist.827603: Device not configured
ls: packlist.834549: Device not configured
ls: packlist.857248: Device not configured
ls: packlist.860152: Device not configured
ls: packlist.861670: Device not configured
ls: packlist.882728: Device not configured
ls: packlist.890997: Device not configured
ls: packlist.909469: Device not configured
ls: packlist.933758: Device not configured
ls: packlist.936238: Device not configured
ls: packlist.971040: Device not configured
ls: packlist.974903: Device not configured
total 6
drwxrwxrwt   3 root  wheel  1536 Apr 15 19:06 .
drwxr-xr-x  22 root  wheel   512 Apr 15 22:29 ..
drwxrwxrwt   2 root  wheel   512 Feb 20 08:41 vi.recover
M
На сайте с 01.12.2009
Offline
235
madoff
#7

Выполните 

mkdir /var/tmp


chown -R mysql:mysql /var/tmp

chmod 751 /var/tmp

покажите 

ls -la /var/tmp
rtyug
На сайте с 13.05.2009
Offline
263
rtyug
#8
madoff:
Выполните 
mkdir /var/tmp


chown -R mysql:mysql /var/tmp


chmod 751 /var/tmp


покажите 
ls -la /var/tmp

unknown-7553# mkdir /var/tmp

mkdir: /var/tmp: File exists

unknown-7553# chown -R mysql:mysql /var/tmp

/usr/sbin/chown: Device not configured.

unknown-7553# chmod 751 /var/tmp

unknown-7553# ls -la /var/tmp

ls: packlist.072307: Device not configured

ls: packlist.113999: Device not configured

ls: packlist.119671: Device not configured

ls: packlist.136109: Device not configured

ls: packlist.169712: Device not configured

ls: packlist.223114: Device not configured

ls: packlist.255125: Device not configured

ls: packlist.255161: Device not configured

ls: packlist.281160: Device not configured

ls: packlist.283587: Device not configured

ls: packlist.301322: Device not configured

ls: packlist.348087: Device not configured

ls: packlist.386338: Device not configured

ls: packlist.397780: Device not configured

ls: packlist.412443: Device not configured

ls: packlist.413529: Device not configured

ls: packlist.432146: Device not configured

ls: packlist.434132: Device not configured

ls: packlist.476214: Device not configured

ls: packlist.493679: Device not configured

ls: packlist.523360: Device not configured

ls: packlist.551018: Device not configured

ls: packlist.625863: Device not configured

ls: packlist.634126: Device not configured

ls: packlist.648104: Device not configured

ls: packlist.659480: Device not configured

ls: packlist.705232: Device not configured

ls: packlist.745023: Device not configured

ls: packlist.745317: Device not configured

ls: packlist.764398: Device not configured

ls: packlist.827603: Device not configured

ls: packlist.834549: Device not configured

ls: packlist.857248: Device not configured

ls: packlist.860152: Device not configured

ls: packlist.861670: Device not configured

ls: packlist.882728: Device not configured

ls: packlist.890997: Device not configured

ls: packlist.909469: Device not configured

ls: packlist.933758: Device not configured

ls: packlist.936238: Device not configured

ls: packlist.971040: Device not configured

ls: packlist.974903: Device not configured

total 6

drwxr-x--x   3 root  wheel  1536 Apr 15 19:06 .

drwxr-xr-x  22 root  wheel   512 Apr 15 22:29 ..

drwxrwxrwt   2 root  wheel   512 Feb 20 08:41 vi.recover
M
На сайте с 01.12.2009
Offline
235
madoff
#9

Странные ошибки пишите мне в icq надо смотреть.

N
На сайте с 06.05.2007
Offline
419
netwind
#10

Жду сообщения "засуньте пальцы в розетку" и отчета о выполнении...

12

Авторизуйтесь или зарегистрируйтесь, чтобы оставить комментарий