Re: mysql crash during large insert from MYIASM to INNODB table.

2002-02-04 Thread Heikki Tuuri
Johannes, which version of MySQL you are running? From http://www.innodb.com/bugfixes.html : November 17, 2001: The insert buffer tree can get into an inconsistent state, causing a crash, and also crashing the recovery. This bug may appear especially in large table imports or

Re: mysql crash during large insert from MYIASM to INNODB table.

2002-02-04 Thread Johannes B. Ullrich
which version of MySQL you are running? 3.23.39 :-(... sorry for not including this earlier. I will try and move to .47 Thanks! From http://www.innodb.com/bugfixes.html : November 17, 2001: The insert buffer tree can get into an inconsistent state, causing a crash,

mysql crash during large insert from MYIASM to INNODB table.

2002-02-03 Thread Johannes B. Ullrich
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I just started using innodb tables to help with some locking problems. The table I am trying to convert is large (100 Million rows, 23 GigByte). I setup 20 2Gig ibdata files. (I choose a size of 2 Gig as this is the maximum size I can easily