Not the answer you need?
Register and ask your own question!

Loading two CSV files from two sessions into TokuDB / Timeout exceeded

andycolxandycolx EntrantCurrent User Role Beginner

I am playing with Percona Server 5.6.27 and TokuDB engine.

I tried to load two (different) CSV files into the same table with LOAD DATA INFILE from two separate 'mysql' sessions. It worked with InnoDB (XtraDB) and MyISAM, but not with TokuDB. The session that starts loading first succeeds, but the other doesn't and returns: "ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction."

Besides increasing the timeout value, is there a way to do this with TokuDB?




Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.