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
Hi List
I got an "no space left on device" error.
Is there a way to drop an index without having MySQL create a temporary table?
Can I delete the .myi file directly from the operating system?
Thanks in advance
Oswaldo Castro
I am using mysql 3.23.54 and am trying to repair the index, using
myisamchk -o tablename.MY and am getting the following error:
- recovering (with keycache) MyISAM-table 'msg.MYI'
Data records: 498802
myisamchk: Error writing file 'msg.TMD' (Errcode: 28)
myisamchk: error
and am trying to repair the index, using
> myisamchk -o tablename.MY and am getting the following error:
>
> - recovering (with keycache) MyISAM-table 'msg.MYI'
> Data records: 498802
> myisamchk: Error writing file 'msg.TMD' (Errcode: 28)
> myisamchk: error: 2
On 01-Apr-2003 Hutterer wrote:
> DO not know what I have changed, but afte mmonths of using mysql without
> problems -
> NOW I get ERROR 28 ( (errno: 28) and cannot create new databases.
>
> Does anybody know how to fix this
> Thanks Robert
>
>
localhost.dread$
Perhaps it's this...
C:\>perror 28
Error code 28: No space left on device
David
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
DO not know what I have changed, but afte mmonths of using mysql without
problems -
NOW I get ERROR 28 ( (errno: 28) and cannot create new databases.
Does anybody know how to fix this
Thanks Robert
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
Yes, it builds a new index file before deleteing the old.
Oswaldo Castro wrote:
>Hi List
>
>I have a table with 90 Millions records and 8 indexes (75GB). I am
>trying to drop one of them but I get an errorcode 28 (no space left on
>device). df- v gives me an extra 27% of free space.
>
>My questi
Hi List
I have a table with 90 Millions records and 8 indexes (75GB). I am
trying to drop one of them but I get an errorcode 28 (no space left on
device). df- v gives me an extra 27% of free space.
My questions:
Does MySQL use temporary areas to drop indexes and for what ?
Is there a way to te
> What the hell is error 28? Where can I find description?
> mysqlcheck --all-databases # says everything is ok
mysql does come with a little utiltiy, perror, which can be
used to translate error numbers into readable messages:
$ perror 28
Error code 28: No space left on device
D
cal/mysql/var to
recommended values
shell> safe_mysqld --user=mysql
shell> mysqladmin -u root password 'mypassword'
shell> mysqladmin -p create SomeDatabase
** failed: errno=28
What the hell is error 28? Where can I find description?
mysqlcheck --all-databases # says everything is ok
AIL PROTECTED]
Subject: Error 28
I'm using DBTools Table Manager to make table changes in Mysql 3.23... I'm
trying to add an auto_increment ID field to 2 tables that already have data
in
them.. 1 table worked fine, the other table I get "Got Error 28 from Table
Handler"
can anyone
I'm using DBTools Table Manager to make table changes in Mysql 3.23... I'm
trying to add an auto_increment ID field to 2 tables that already have data in
them.. 1 table worked fine, the other table I get "Got Error 28 from Table
Handler"
can anyone tell me
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
27 matches
Mail list logo
