title: Infobright/MySQL load data infile deadlock
body: <p>I am experiencing a deadlock when using multiple concurrent LOAD DATA INFILE comamnds. Here is the background:</p>
  
  <p>I have developed a Java-based ETL tool which loads flat files into Infobright databases (Infobright is a columnar database based on MySQL). At the end of the processing, the load is executed using a LOAD DATA INFILE command. This process can handle loading into multiple tables and each load is done in parallel using a separate connection (for performance reasons).</p>
  
  <p>I also have written a bash script which runs this tool in parallel for multiple files (to save time on the processing part, since the LOAD commands will be serialized anyway by the DB server). This means i can have multiple LOAD DATA commands for the same target table (from different processes). </p>
  
  <p>What i was expecting was that the LOAD DATA command would be executed in a serial fashion, but would eventually finish. However, i am experiencing a deadlock. If i execute a "show processlist" i can see that all my LOAD DATA commands are in the "System locked" state. </p>
  
  <p>Has anyone experienced such a problem before and found a solution? </p>
  
  <p>Details:
  I'm using Infobright Enterprise Edition v3.5.2. This is based on<br>
     MySQL 5.1.40.
  My ETL application uses java 1.5.0_08 and Mysql<br>
     Connector Java v5.1.12. 
  OS: Centos 5.6 64 bit (Linux
        2.6.18-238.12.1.el5)</p>