RE : error 28 from table handler

2006-04-04 Thread Jacques Brignon
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

Re: error 28 from table handler

2006-04-03 Thread Jacques Brignon
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

Trans.: Re: error 28 from table handler

2006-04-03 Thread Jacques Brignon
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

Re: error 28 from table handler

2006-04-03 Thread Sander Smeenk
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

error 28 from table handler

2006-04-02 Thread Jacques Brignon
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

Re: Problem with insert statement; ERROR 1030 at line 188: Got error 28 from table handler

2004-09-28 Thread Eldo Skaria
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

Re: Problem with insert statement; ERROR 1030 at line 188: Got error 28 from table handler

2004-09-24 Thread kernel
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

Problem with insert statement; ERROR 1030 at line 188: Got error 28 from table handler

2004-09-24 Thread Sebastian Geib
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

Re: Erro:Got error 28 from table handler!

2004-07-20 Thread Egor Egorov
[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

Re: Erro:Got error 28 from table handler!

2004-07-19 Thread Aman Raheja
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

Erro:Got error 28 from table handler!

2004-07-19 Thread paulo2rocha
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

ERROR 1030: Got error 28 from table handler

2003-02-07 Thread Alexandrin Popescul
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

Re: Error 1030: got error 28 from table handler

2001-05-30 Thread Benjamin Pflugmann
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

RE: Error 1030: got error 28 from table handler

2001-05-29 Thread Don Read
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.

Error 1030: got error 28 from table handler

2001-05-28 Thread Griff Hamlin
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