openlp-core team mailing list archive

[Phill <1154467@xxxxxxxxxxxxxxxxxx>]

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)

-- 
You received this bug notification because you are a member of OpenLP
Core, which is subscribed to OpenLP.
https://bugs.launchpad.net/bugs/1154467

Title:
  Web download bible db's getting locked

Status in OpenLP - Worship Presentation Software:
  Confirmed
Status in OpenLP 2.0 series:
  Confirmed
Status in OpenLP trunk series:
  Confirmed

Bug description:
  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.')

To manage notifications about this bug go to:
https://bugs.launchpad.net/openlp/+bug/1154467/+subscriptions