Web download bible db's getting locked

[Phill]

See: http://support.openlp.org/issues/1885

The user had 8 bibles, and when trying to download some verses (to an already registered web bible) the user recieved a traceback stating that the database was locked.

OperationalError: (OperationalError) database is locked u'INSERT INTO verse (book_id, chapter, verse, text) VALUES (?, ?, ?, ?)' (24, 17, 1, u'"The sin of Judah is inscribed with an iron chisel - engraved with a diamond point on their stony hearts and on the corners of their altars.')

The user found that removing some of the other bibles he could download new verses to the web bible.

I have been unable to recreate the error.

 --- Exception Traceback ---
Traceback (most recent call last):
  File "D:\OpenLP_Code\release-2.0.1\build\pyi.win32\OpenLP\out00-PYZ.pyz\openlp.plugins.bibles.lib.mediaitem", line 763, in onQuickSearchButton
  File "D:\OpenLP_Code\release-2.0.1\build\pyi.win32\OpenLP\out00-PYZ.pyz\openlp.plugins.bibles.lib.manager", line 333, in get_verses
  File "D:\OpenLP_Code\release-2.0.1\build\pyi.win32\OpenLP\out00-PYZ.pyz\openlp.plugins.bibles.lib.http", line 621, in get_verses
  File "D:\OpenLP_Code\release-2.0.1\build\pyi.win32\OpenLP\out00-PYZ.pyz\openlp.plugins.bibles.lib.db", line 260, in create_chapter
  File "C:\Program Files (x86)\OpenLP\eggs\sqlalchemy-0.7.7-py2.7-win32.egg\sqlalchemy\orm\scoping.py", line 114, in do
  File "C:\Program Files (x86)\OpenLP\eggs\sqlalchemy-0.7.7-py2.7-win32.egg\sqlalchemy\orm\session.py", line 655, in commit
  File "C:\Program Files (x86)\OpenLP\eggs\sqlalchemy-0.7.7-py2.7-win32.egg\sqlalchemy\orm\session.py", line 313, in commit
  File "C:\Program Files (x86)\OpenLP\eggs\sqlalchemy-0.7.7-py2.7-win32.egg\sqlalchemy\orm\session.py", line 297, in _prepare_impl
  File "C:\Program Files (x86)\OpenLP\eggs\sqlalchemy-0.7.7-py2.7-win32.egg\sqlalchemy\orm\session.py", line 1587, in flush
  File "C:\Program Files (x86)\OpenLP\eggs\sqlalchemy-0.7.7-py2.7-win32.egg\sqlalchemy\orm\session.py", line 1658, in _flush
  File "C:\Program Files (x86)\OpenLP\eggs\sqlalchemy-0.7.7-py2.7-win32.egg\sqlalchemy\orm\unitofwork.py", line 331, in execute
  File "C:\Program Files (x86)\OpenLP\eggs\sqlalchemy-0.7.7-py2.7-win32.egg\sqlalchemy\orm\unitofwork.py", line 475, in execute
  File "C:\Program Files (x86)\OpenLP\eggs\sqlalchemy-0.7.7-py2.7-win32.egg\sqlalchemy\orm\persistence.py", line 64, in save_obj
  File "C:\Program Files (x86)\OpenLP\eggs\sqlalchemy-0.7.7-py2.7-win32.egg\sqlalchemy\orm\persistence.py", line 558, in _emit_insert_statements
  File "C:\Program Files (x86)\OpenLP\eggs\sqlalchemy-0.7.7-py2.7-win32.egg\sqlalchemy\engine\base.py", line 1450, in execute
  File "C:\Program Files (x86)\OpenLP\eggs\sqlalchemy-0.7.7-py2.7-win32.egg\sqlalchemy\engine\base.py", line 1583, in _execute_clauseelement
  File "C:\Program Files (x86)\OpenLP\eggs\sqlalchemy-0.7.7-py2.7-win32.egg\sqlalchemy\engine\base.py", line 1697, in _execute_context
  File "C:\Program Files (x86)\OpenLP\eggs\sqlalchemy-0.7.7-py2.7-win32.egg\sqlalchemy\engine\base.py", line 1690, in _execute_context
  File "C:\Program Files (x86)\OpenLP\eggs\sqlalchemy-0.7.7-py2.7-win32.egg\sqlalchemy\engine\default.py", line 331, in do_execute
OperationalError: (OperationalError) database is locked u'INSERT INTO verse (book_id, chapter, verse, text) VALUES (?, ?, ?, ?)' (24, 17, 1, u'"The sin of Judah is inscribed with an iron chisel - engraved with a diamond point on their stony hearts and on the corners of their altars.')

[Phill (phill-ridout)]

This has been reported several times since, however, I now think that it may be just a coincidence with regards to the number of bibles.

http://support.openlp.org/issues/1919
http://support.openlp.org/issues/1927
http://support.openlp.org/issues/1871

[Phill (phill-ridout)]

See also:
http://support.openlp.org/issues/1947

[Phill (phill-ridout)]

http://support.openlp.org/issues/2085

[Phill (phill-ridout)]

http://support.openlp.org/issues/2090

[Phill (phill-ridout)]

Possibly a fix for this bug in here: http://beets.radbox.org/blog/sqlite-nightmare.html
However, it may take me several more reads to understand it. (If I ever)