List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:September 5 2002 1:21pm
Subject:Re: Weird error message
View as plain text  
perror 28

No space left on device.

I guess your disk is getting full.

John Wards wrote:

>I am getting a weird error message in mysql.
>I am doing this query
>SELECT t0.sid, t1.stid, t0.clubname, t1.longheadline FROM club t0, story t1
>WHERE t0.sid = t1.siteid  AND t1.hold='no' AND t0.test = 0 AND t1.synd = '1'
>AND'football' ORDER BY `stid` DESC LIMIT 10;
>and I am getting this error message
>ERROR 1030: Got error 28 from table handler
>I have figured out that it is t0.test that is causeing the problem as when i
>remove it the query works. This query has been working fine for months and
>we haven't done anything to the tables used.
>I have tried explain, check and analyse and everything seems normal.
>Any clues?
>John Wards
>Before posting, please check:
>   (the manual)
>           (the list archive)
>To request this thread, e-mail <mysql-thread118778@stripped>
>To unsubscribe, e-mail
> <>
>Trouble unsubscribing? Try:

urgent ...Sekhar.Thota4 Sep
  • MySql 4.0.3 Feature question.Dormition Skete4 Sep
  • Re: urgent ...walt5 Sep
  • Weird error messageJohn Wards5 Sep
    • Re: Weird error messageChris Wilson5 Sep
  • Re: Weird error messageJohn Wards5 Sep
  • Re: Weird error messageGerald Clark5 Sep