Search the web
Sign In
New User? Sign Up
chiPHPug · Agent for the Chicago PHP users group, ChiPHPug. Pronounced [CHIF pug].
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Want to share photos of your group with the world? Add a group photo to Flickr.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
Error 28   Message List  
Reply | Forward Message #775 of 1638 |
Re: [chiPHPug] Error 28

> >Error 28 on my OS X (Darwin Server) with MySQL is a 'No Space Left on
> >Device' error.
> >Maybe your table has gotten larger than the space alotted for it on the
> >device??(Maybe?)
>
> How can that happen? There's less than 300 records.

If you can telnet/SSH in, do this:

df -h

This will tell you which drives/partitions are how full and whatnot.

If any of them are over 90% full, you should worry...

It's unlikely that your database of 300 is the real culprit, but it's
possible that the partition is full of other crap...

--
WARNING richard@... address is an endangered species -- Use
ceo@...
Wanna help me out? Like Music? Buy a CD: http://l-i-e.com/artists.htm
Volunteer a little time: http://chatmusic.com/volunteer.htm






Sat Oct 27, 2001 10:18 am

richardatzen...
Offline Offline
Send Email Send Email

Forward
Message #775 of 1638 |
Expand Messages Author Sort by Date

What OS and database? Anyway - Error 28 on my OS X (Darwin Server) with MySQL is a 'No Space Left on Device' error. Maybe your table has gotten larger than the...
Jonathan Hawkins
jhawkins@...
Send Email
Oct 26, 2001
7:47 pm

... Linux MySQL ... How can that happen? There's less than 300 records. ... No, but at least it's a reply and that helps a lot since I'm going a little crazy ...
tamara
abbeyink
Offline Send Email
Oct 26, 2001
7:55 pm

Now it's working again. All I did was take out DISTINCT from the SELECT. Was it me? Or, did the host have a problem?? Oh well, another thing settled anyway. <t...
tamara
abbeyink
Offline Send Email
Oct 26, 2001
7:59 pm

Tamara, Well if you were for example doing a join - if you weren't careful you might have in removing the distinct made it into a many to many join - which...
Shannon J. Clark
shannonclark
Offline Send Email
Oct 26, 2001
8:02 pm

I promise -- this really is the last post on this. It was the DISTINCT -- I went to the admin area where I hadn't done any changes, got the same error and when...
tamara
abbeyink
Offline Send Email
Oct 26, 2001
8:02 pm

Keep in mind that a DISTINCT attempts to sort the data and remove duplicates. This is a time/memory intensive operation. MySQL has to go through every returned...
Richard Lynch
richardatzen...
Offline Send Email
Oct 27, 2001
10:25 am

... If you can telnet/SSH in, do this: df -h This will tell you which drives/partitions are how full and whatnot. If any of them are over 90% full, you should...
Richard Lynch
richardatzen...
Offline Send Email
Oct 27, 2001
10:25 am
Advanced

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help