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 ** Summary changed: - Large numbers of bibles causes issues with web download bible + Web download bible db's getting locked ** Changed in: openlp/2.0 Status: New => Confirmed ** Changed in: openlp/trunk Status: New => Confirmed -- 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 _______________________________________________ Mailing list: https://launchpad.net/~openlp-core Post to : openlp-core@lists.launchpad.net Unsubscribe : https://launchpad.net/~openlp-core More help : https://help.launchpad.net/ListHelp