mysql on redhat - Errcode: 28

Networking/Security Forums -> Databases

Author: _._._._._Location: Ontario, Canada PostPosted: Thu Aug 23, 2007 1:47 am    Post subject: mysql on redhat - Errcode: 28
    ----
I seem to be having difficulties on my Snort management server (BASE 1.2.2).

when running the query for the top 5 frequent alerts from the web interface, I get the message:

Database ERROR:Database ERROR:Error writing file '/tmp/MYxxxxxx' (Errcode: 28 ) where xxxxxx is almost any string

Through a little digging, I've come to the conclusion that most people seem to agree that errcode: 28 means there is insufficient disk space.

My /tmp/ is ~1gb, ~940mb free with 777 permissions.

one thing to take note of is that my acid_event.MYI is rather large (942306304). Just thinking up possibilities here, but I wouldn't imagine it would copy the entire thing to the /tmp/ to run this, would it?

any suggestions as to a resolution?

=====================================
edit
----
For those intersted, after cutting the database down to 1/10 the size, the problem was resolved.



Networking/Security Forums -> Databases


output generated using printer-friendly topic mod, All times are GMT + 2 Hours

Page 1 of 1

Powered by phpBB 2.0.x © 2001 phpBB Group