title: ERROR 1878 (HY000): Temporary file write failure
body: <p>I am executing a query</p>
  
  <blockquote>
    <p>ALTER TABLE <code>message</code> ADD COLUMN <code>syncid</code>  int(10) NOT NULL DEFAULT 0;</p>
  </blockquote>
  
  <p>MySQL returned error:</p>
  
  <pre><code>ERROR 1878 (HY000): Temporary file write failure.
  </code></pre>
  
  <hr>
  
  <blockquote>
    <p>message table info:</p>
    
    <p>engine type:InnoDB</p>
    
    <p>rows:15786772</p>
    
    <p>index length:1006.89 MB</p>
    
    <p>data length:11.25 GB</p>
  </blockquote>
  
  <p>How to fix it?</p>