1

When I try to do a large query (such as found here: https://stackoverflow.com/a/23381855/1070958 ) Im getting this:

Error Code: 3. Error writing file '/tmp/MYYQVeZr' (Errcode: 28)

Its not a space issue or a permission issue either:

proof

What is wrong?

Community
  • 1
  • 1
riahc3
  • 857
  • 4
  • 10
  • 23
  • Well, the error message is pretty clear. There is a problem writing an intermediate temporary result. This would be a space issue, a permissions issue, or a network issue. There really isn't enough information to tell which it is. – Gordon Linoff Apr 30 '14 at 13:39
  • uname -a says: Linux DiskStationVM 3.2.40 #34 SMP Sat Mar 8 17:08:43 CET 2014 x86_64 GNU/Linux synology_bromolow_3612xs – riahc3 Apr 30 '14 at 14:53
  • I stated space available and also permission. I think there is more than enough information to discard at least 2 out of 3. And I can do your basic show tables so it isn't a network issue either. – riahc3 Apr 30 '14 at 14:54

1 Answers1

0

Turshija here tells that:

If you have too many small files you may have inodes full. Check it with df -i in "IFree" or "IUse%" fields.

Isn't it your case?

Community
  • 1
  • 1
Andrey Regentov
  • 3,687
  • 4
  • 34
  • 40