Posted: 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.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum