Thanks
Yes the hoster fixed it by cleaning the temp files
Jacques Brignon
> -Message d'origine-
> De : Sander Smeenk [mailto:[EMAIL PROTECTED]
> Envoyé : lundi 3 avril 2006 10:32
> À : mysql@lists.mysql.com
> Objet : Re: error 28 from table handler
>
> Quoti
then the table would have been corrupted
> - Original Message -
> From: "Jacques Brignon" <[EMAIL PROTECTED]>
> To:
> Sent: Monday, April 03, 2006 1:58 AM
> Subject: error 28 from table handler
>
>
> > Hi,
> >
> > I am getting the fol
Oops forgot to include the list
- Message transféré de Jacques Brignon <[EMAIL PROTECTED]> -
Date : Mon, 03 Apr 2006 10:07:58 +0200
De : Jacques Brignon <[EMAIL PROTECTED]>
Adresse de retour :Jacques Brignon <[EMAIL PROTECTED]>
Sujet : Re: error 28 from tab
Quoting Jacques Brignon ([EMAIL PROTECTED]):
> "1030 : Got error 28 from table handler"
% perror 28
OS error code 28: No space left on device
> Any idea of what might cause that, and what should be done to correct
> this situation?
Aparently the disk that stores your MyS
Hi,
I am getting the following error when executing a simple SELECT query
which used to work:
"1030 : Got error 28 from table handler"
I did not found that in the manual. When googleing it it seems it may be
related to disk space ...
The server hosting my application is running My
Hi Sebastian,
If the new cds_catalog is created with primary key, this should
produce a duplicate key error for the second iteration of the second
table, as the data selected is from cds_catalog alone, but joining two
tables causing cartisian joint to be formed(n*(m-
t1.field<>t2.field)),
each tim
Sebastian Geib wrote:
Hi!
I have a huge problem with the following insert statement:
INSERT INTO cds_catalog
SELECT cds_stage.cds_catalog.*
FROM cds.cds_catalog, cds_stage.cds_catalog
WHERE cds_stage.cds_catalog.prodid<>cds.cds_catalog.prodid;
Whenever I'm running it, it pro
Hi!
I have a huge problem with the following insert statement:
INSERT INTO cds_catalog
SELECT cds_stage.cds_catalog.*
FROM cds.cds_catalog, cds_stage.cds_catalog
WHERE cds_stage.cds_catalog.prodid<>cds.cds_catalog.prodid;
Whenever I'm running it, it produces the error mentio
[EMAIL PROTECTED] wrote:
> qual o significado da seguinte menssagem de erro do MySQL:
> "Got error 28 from table handler"?
[EMAIL PROTECTED] egor]$ perror 28
Error code 28: No space left on device
--
For technical support contracts, goto https://order.mysql.com/?ref=e
MySQL:
> "Got error 28 from table handler"?
>
> Obrigado,
> Paulo.
>
> ---
> Inscreva-se na Maratona iBest para concorrer a prêmios!
> São 2 casas, 11 Ford EcoSport e 60 computadores.
> Participe já: http://maratona.ibest.com.br
>
> --
> MySQL Gene
Olá,
qual o significado da seguinte menssagem de erro do MySQL:
"Got error 28 from table handler"?
Obrigado,
Paulo.
---
Inscreva-se na Maratona iBest para concorrer a prêmios!
São 2 casas, 11 Ford EcoSport e 60 computadores.
Participe já: http://maratona.ibest.com.br
--
MyS
Hello,
I get the a table handler error (ERROR 1030: Got error 28 from table
handler), when using mySQL to evaluate numerious queries in a loop (from
Java), after a certain number of successfully evaluated queries.
My impression is that it is caused by the appearance of large files in
/tmp
Hello.
shell> perror 28
Error code 28: No space left on device
in other words: to process the query, MySQL creates a temporary table
on disk and you are running out of disk space.
You may want to consider to change the location of the directory used
for temporary files.
Bye,
Benjami
On 29-May-01 Griff Hamlin wrote:
> Hello,
>
>
> I have tried the set SQL_BIG_TABLES flag set to 1, but that did not help
> and now I'm out of ideas. Any suggestions would be appreciated.
>
localhost.dread$ perror 28
Error code 28: No space left on device
put --tmpdir on a bigger disc.
Hello,
When trying to do a large select statement like the following this error
is returned:
select account.username,person.firstname,person.lastname,
person.company_name, person.street,person.city,person.state,
person.zip,person.franchise,
person.card_number,person.expires,account.date,tran
15 matches
Mail list logo