title: MySQL Cluster Error: Lock wait timeout exceeded
body: <p>I was trying to load a ~200G file into MySQL cluster having 4 data nodes, and my DDL for the target table is like this:</p>
  
  <pre><code>CREATE TABLE  XXXXXX
  (
       ID BIGINT AUTO_INCREMENT PRIMARY KEY,
       COL1...,
       COL2...,
       .......
  )
  ENGINE = NDB PARTITION BY KEY();
  </code></pre>
  
  <p>after few minutes of loading, I received following error:</p>
  
  <pre><code>ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
  </code></pre>
  
  <p>and I found some records loaded into the target table. what should I do to overcome this issue?</p>
  
  <p>some of the variables values which might be helpful:</p>
  
  <pre><code>wait_timeout      : 28800
  ndb_wait_connected: 30
  ndb_wait_setup    : 30
  </code></pre>