openlp-core team mailing list archive
-
openlp-core team
-
Mailing list archive
-
Message #22472
[Bug 1154467] Re: Web download bible db's getting locked
** Changed in: openlp/2.0
Status: In Progress => Fix Committed
--
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:
Fix Committed
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
References