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

[Tobias Asplund]

On Mon, 27 Sep 2004, Sebastian Geib wrote:

> >> 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;
> >>


Look at this query, it will create a huge table as a result, as an
approximisation the table created will have the number of rows in both tables
multiplied with eachother.


> Has anyone else any idea? I tried all Google resources I could get hands
> on, but they were all about disk space on the tmp partition or repairing
> the db which both isn't the problem here.

Are you sure 60GB is enough? Look above, say you have 1000 rows in each
table, the result could be up to 1000000 rows.