On 1/15/2011 02:07, Jørn Dahl-Stamnes wrote:
On Saturday 15 January 2011 00:28, Johnny Withers wrote:
The result of your query without the join
probably exceeded your tmp_table_size variable. When this
occurs, MySQL quit writing the temp table to disk thus producing an
incorrect table file. (I t
On Sat, Jan 15, 2011 at 8:07 AM, Jørn Dahl-Stamnes
wrote:
> On Saturday 15 January 2011 00:28, Johnny Withers wrote:
> > The result of your query without the join
> > probably exceeded your tmp_table_size variable. When this
> > occurs, MySQL quit writing the temp table to disk thus producing an
>
On Saturday 15 January 2011 00:28, Johnny Withers wrote:
> The result of your query without the join
> probably exceeded your tmp_table_size variable. When this
> occurs, MySQL quit writing the temp table to disk thus producing an
> incorrect table file. (I think).
Yes, part of this was my fault (
The result of your query without the join
probably exceeded your tmp_table_size variable. When this
occurs, MySQL quit writing the temp table to disk thus producing an
incorrect table file. (I think).
JW
On Fri, Jan 14, 2011 at 3:48 PM, Jørn Dahl-Stamnes
wrote:
> On Friday 14 January 2011 14:03
On Friday 14 January 2011 14:03, Johan De Meersman wrote:
> Check your free diskspace on your temp location.
About 900+ Mb free.
But I don't think that a full filesystem was the problem (I don't think the
mysqld server was able to fill the disk with 900 Mb in 1-2 seconds). After
some debugging
>-Original Message-
>From: Jørn Dahl-Stamnes [mailto:sq...@dahl-stamnes.net]
>Sent: Friday, January 14, 2011 7:31 AM
>To: mysql@lists.mysql.com
>Subject: Incorrect key file for table
>
>Hello,
>
>While doing a select query I got the following error in the error-log file:
>
>Incorrect
Check your free diskspace on your temp location.
On Fri, Jan 14, 2011 at 1:31 PM, Jørn Dahl-Stamnes
wrote:
> Hello,
>
> While doing a select query I got the following error in the error-log
> file:
>
>Incorrect key feil for table '/tmp/#sql_5f8_0.MYI'; try to repair it
>
> It seem rather mea
Per Jessen wrote:
> What does this error mean?
>
> mysql> select ipaddr,reverse,count(distinct domain) from mxdata,domain
> group by ipaddr;
> ERROR 126 (HY000): Incorrect key file for
> table '/var/lib/mysql/.tmp/#sql_d57_2.MYI'; try to repair it
Please ignore.
/Per Jessen, Zürich
--
MySQL
This is due to less space in your /tmp file system.
Change tmpdir parameter to point to a file system having more space and then
try the adding the constraint.
regards
anandkl
On Fri, Feb 26, 2010 at 5:14 AM, Yang Zhang wrote:
> I'm getting "Incorrect key file for table 'stock'; try to repair i
On 12/17/05, Gleb Paharenko <[EMAIL PROTECTED]> wrote:
> Hello.
>
>
>
> > and slave. Error on master: 'Incorrect key file for table '%-.64s
>
>
>
> Really, the name of the table is strange enough. Is it possible that
>
> you have non-latin symbols in table name, which are displayed
>
> incorrectly
Hello.
> and slave. Error on master: 'Incorrect key file for table '%-.64s
Really, the name of the table is strange enough. Is it possible that
you have non-latin symbols in table name, which are displayed
incorrectly on your terminal? If you're able check all your tables
on the master for
Renato,
Friday, October 18, 2002, 1:01:06 PM, you wrote:
RS> select id from usuario;
RS> ERROR 1034: Incorrect key file for table: 'usuario'. Try to repair it
RS> How can I solve this problem?
Repair your table:
http://www.mysql.com/doc/en/Repair.html
--
For technical support contracts
Renato Silveira wrote:
> I have this problem in MySQL
>
> select id from usuario;
> ERROR 1034: Incorrect key file for table: 'usuario'. Try to repair it
>
> How can I solve this problem?
>
Repair it ! ;)
See : http://www.mysql.com/doc/en/REPAIR_TABLE.html
> thks
>
>
--
Joseph Bueno
-
13 matches
Mail list logo
