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?
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
Looking for more Windows Networking info?
Sign up to the WindowsNetworking.com Monthly Newsletter, written by Enterprise Security MVP Deb Shinder, containing news, the hottest tips, Networking links of the month and much more. Subscribe today and don't miss a thing! View a sample newsletter.
Become a WindowsNetworking.com member!
Discuss your Windows Networking issues with thousands of other Windows Newtorking experts. Click here to join!