openlp-core team mailing list archive

[Phill <1154467@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

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.')

** Affects: openlp
     Importance: Low
         Status: New

** Affects: openlp/2.0
     Importance: Low
         Status: New

** Affects: openlp/trunk
     Importance: Low
         Status: New

** Also affects: openlp/2.0
   Importance: Undecided
       Status: New

** Also affects: openlp/trunk
   Importance: Undecided
       Status: New

** Changed in: openlp/2.0
   Importance: Undecided => Low

** Changed in: openlp/trunk
   Importance: Undecided => Low

-- 
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:
  Large numbers of bibles causes issues with web download bible

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

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