Re: "Incorrect key file for table XXXX" try to repair it
Ingo,
my apologies, the problem below was due to insufficient file space.
Best
George Herlin
Ingo,
Are you still interested in a test case for this?
I can replicate this case in a few seconds... However, the underlying tables are fairly large and my upstream capacity is not good (I am at home).
MySQL 5.0.27-log
fc6
no replication or anything like that. Query below
I am backing up in case. backup is roughly 280MB. Could send a CD.
Might I guess that the engine is constructing a temporary index?
Best
George Herlin
==========================QUERY============================
select host, 0, 0 as NoAnn, 0 as IbmEmpty, 0 as IbmNotEmpty, sum(HasNoLocF) as HasNoLoc, sum(HasLocF) as HasLoc from (
select HostFromUrl(parsed_url) as host, parsed_url, a.annotation_value IS NULL as HasNoLocF, a.annotation_value!='' as HasLocF
from parsed_urls p
left join annotations a on p.parsed_url=a.annotation_url
where a.annotation_name='xml-locations'
) t group by host
===========================================================
Andrew Hanna Wrote:
-------------------------------------------------------
> I ran into this problem recently, but I was not
> using binary logging or replication at all. The
> real fun with this error message was that it was
> for a temporary table that didn't exist, ie.
> '/tmp/#sql_2044_1.MYI'. No such file existed.
> Also, I stopped all other processes and it was
> still there. Anyway, when I saw the other
> messages about this problem and people referring
> to replication, I decided to run a "RESET MASTER;"
> since I was not using replication. That seemed to
> have fixed it.
>
> I'm not quite sure how to duplicate this bug, but
> Ingo, if that gives you an idea of where it might,
> then maybe that will help. I am running
> 5.0.27-standard-log 64-bit build from CentOS Plus
> (4.4). I was running a long script that was
> basically running multiple CREATE TABLEs and
> INSERT INTO ... SELECT.
Edited 1 time(s). Last edit at 05/19/2007 05:34AM by George Herlin.