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

**URL:** https://forums.percona.com/t/loading-two-csv-files-from-two-sessions-into-tokudb-timeout-exceeded/4711
**Category:** Other MySQL® Questions
**Created:** [February 8, 2016, 2:39pm UTC](https://forums.percona.com/t/loading-two-csv-files-from-two-sessions-into-tokudb-timeout-exceeded/4711 "2016-02-08T14:39:42Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![andycolx](https://avatars.discourse-cdn.com/v4/letter/a/4491bb/32.png) [@andycolx](https://forums.percona.com/u/andycolx)
#### Post date: [February 8, 2016, 2:39pm UTC](https://forums.percona.com/t/loading-two-csv-files-from-two-sessions-into-tokudb-timeout-exceeded/4711/1 "2016-02-08T14:39:42Z")

</div>

Hi,

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?

Thanks,

Andy.

---

<div class="post-metadata">

### Author: ![George\_Lorch](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/george_lorch/32/1108_2.png) [@George\_Lorch](https://forums.percona.com/u/George_Lorch)
#### Post date: [February 23, 2016, 11:40am UTC](https://forums.percona.com/t/loading-two-csv-files-from-two-sessions-into-tokudb-timeout-exceeded/4711/2 "2016-02-23T11:40:57Z")

</div>

Hello Andy,  
You are running into the TokuDB bulk loader lock. Please see [url][TokuDB Variables](https://www.percona.com/doc/percona-server/5.6/tokudb/tokudb_variables.html#tokudb_prelock_empty%5B/url%5D)

–  
George O. Lorch III  
Software Engineer, Percona