title: Sqlite drop table error: database or disk is full
body: <p>I have a SQLite db where I copied a table (~80gb) in order to add an autoincrement index to it. The resulting db has a size of 167GB. After successfully copying the table, I would now like to drop the original table. However, I get an error:</p>
  <blockquote>
  <p>sqlite3.OperationalError: database or disk is full</p>
  </blockquote>
  <p>This is my query:</p>
  <pre><code>drop table listens;
  </code></pre>
  <p>there is 18GB of space left on my disk and 32GB of RAM.
  As a newbie it seems unintuitive to me that the removal of a table would error out because of a lack of disk space. Any ideas what is happening and how I can fix it?</p>