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:

>Hi,
>
>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 t0.sport='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?
>
>Cheers
>John Wards
>SportNetwork.net
>
>
>
>---------------------------------------------------------------------
>Before posting, please check:
>   http://www.mysql.com/manual.php   (the manual)
>   http://lists.mysql.com/           (the list archive)
>
>To request this thread, e-mail <mysql-thread118778@stripped>
>To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>


Thread
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