• RSS
  • Twitter
  • FaceBook

Security Forums

Log in

FAQ | Usergroups | Profile | Register | RSS | Posting Guidelines | Recent Posts

mysql on redhat - Errcode: 28

Users browsing this topic:0 Security Fans, 0 Stealth Security Fans
Registered Security Fans: None
Post new topic   Reply to topic   Printer-friendly version    Networking/Security Forums Index -> Databases

View previous topic :: View next topic  
Author Message
_._._._._
Just Arrived
Just Arrived


Joined: 27 Sep 2005
Posts: 0
Location: Ontario, Canada

Offline

PostPosted: Thu Aug 23, 2007 1:47 am    Post subject: mysql on redhat - Errcode: 28 Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   

Post new topic   Reply to topic   Printer-friendly version    Networking/Security Forums Index -> Databases All times are GMT + 2 Hours
Page 1 of 1


 
Jump to:  
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!

Community Area

Log in | Register

Readers' Choice

Which is your preferred data recovery solution?

Follow TechGenix on Twitter