MySQL Forums
Forum List  »  InnoDB

Temporary table - Error recovery failure (9001)
Posted by: Marek Kolman
Date: January 05, 2017 09:55AM

I have made temporary table like this:

CREATE TEMPORARY TABLE temp1 (towkod varchar(20), townaz varchar(40), wartnetto DECIMAL(9,2), wartzysk DECIMAL(9,2), ilotow DECIMAL(9,2)) ENGINE = InnoDB

and then insert 6 milions rows:

INSERT INTO temp1 (towkod, townaz, wartnetto, wartzysk, ilotow)
VALUES ('aaa', 'name aaa, 1.1, 2.2, 3.3)

but after insert 3 milions rows apear error:

Unrecoverable error 9001, Error recovery failure

what is wrong?

Options: ReplyQuote

Written By
Temporary table - Error recovery failure (9001)
January 05, 2017 09:55AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.