MySQL Forums :: InnoDB :: Temporary table - Error recovery failure (9001)


Advanced Search

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


Subject Views Written By Posted
Temporary table - Error recovery failure (9001) 287 Marek Kolman 01/05/2017 09:55AM
Re: Temporary table - Error recovery failure (9001) 157 Peter Brawley 01/05/2017 11:52AM


Sorry, only registered users may post in this forum.

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.