title: Python SQLite: database is locked
body: <p>I'm trying this code:</p>
  
  <pre><code>import sqlite
  
  connection = sqlite.connect('cache.db')
  cur = connection.cursor()
  cur.execute('''create table item
    (id integer primary key, itemno text unique,
          scancode text, descr text, price real)''')
  
  connection.commit()
  cur.close()
  </code></pre>
  
  <p>I'm catching this exception:</p>
  
  <pre><code>Traceback (most recent call last):
    File "cache_storage.py", line 7, in &lt;module&gt;
      scancode text, descr text, price real)''')
    File "/usr/lib/python2.6/dist-packages/sqlite/main.py", line 237, in execute
      self.con._begin()
    File "/usr/lib/python2.6/dist-packages/sqlite/main.py", line 503, in _begin
      self.db.execute("BEGIN")
  _sqlite.OperationalError: database is locked
  </code></pre>
  
  <p>Permissions for cache.db are ok. Any ideas?</p>