I think we've done a bunch of work around this, and are unlikely to get this again.
** Changed in: openlp/trunk Status: New => 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/1051890 Title: Gracefully handle database rollbacks Status in OpenLP - Worship Presentation Software: Fix Committed Status in OpenLP 2.0 series: Won't Fix Status in OpenLP trunk series: Fix Committed Bug description: Version: {u'full': u'1.9.11-bzr2039', u'version': u'1.9.11', u'build': u'bzr2039'} --- Details of the Exception. --- Clicking Save on a new song --- Exception Traceback --- Traceback (most recent call last): File "/Users/martin/Documents/openlp/trunk/build/pyi.darwin/OpenLP/out00-PYZ.pyz/openlp.plugins.songs.forms.editsongform", line 814, in accept File "/Users/martin/Documents/openlp/trunk/build/pyi.darwin/OpenLP/out00-PYZ.pyz/openlp.plugins.songs.forms.editsongform", line 852, in saveSong File "/Users/martin/Documents/openlp/trunk/build/pyi.darwin/OpenLP/out00-PYZ.pyz/openlp.core.lib.db", line 341, in get_object_filtered File "/Users/martin/Documents/openlp/trunk/build/pyi.darwin/OpenLP/out00-PYZ.pyz/sqlalchemy.orm.query", line 2155, in first File "/Users/martin/Documents/openlp/trunk/build/pyi.darwin/OpenLP/out00-PYZ.pyz/sqlalchemy.orm.query", line 2022, in getitem File "/Users/martin/Documents/openlp/trunk/build/pyi.darwin/OpenLP/out00-PYZ.pyz/sqlalchemy.orm.query", line 2223, in iter File "/Users/martin/Documents/openlp/trunk/build/pyi.darwin/OpenLP/out00-PYZ.pyz/sqlalchemy.orm.session", line 1011, in _autoflush File "/Users/martin/Documents/openlp/trunk/build/pyi.darwin/OpenLP/out00-PYZ.pyz/sqlalchemy.orm.session", line 1587, in flush File "/Users/martin/Documents/openlp/trunk/build/pyi.darwin/OpenLP/out00-PYZ.pyz/sqlalchemy.orm.session", line 1656, in _flush File "/Users/martin/Documents/openlp/trunk/build/pyi.darwin/OpenLP/out00-PYZ.pyz/sqlalchemy.orm.session", line 588, in begin File "/Users/martin/Documents/openlp/trunk/build/pyi.darwin/OpenLP/out00-PYZ.pyz/sqlalchemy.orm.session", line 196, in _begin File "/Users/martin/Documents/openlp/trunk/build/pyi.darwin/OpenLP/out00-PYZ.pyz/sqlalchemy.orm.session", line 173, in _assert_is_active InvalidRequestError: This Session's transaction has been rolled back due to a previous exception during flush. To begin a new transaction with this Session, first issue Session.rollback(). Original exception was: (IntegrityError) songs.lyrics may not be NULL u'INSERT INTO songs (song_book_id, title, alternate_title, lyrics, verse_order, copyright, comments, ccli_number, song_number, theme_name, search_title, search_lyrics, create_date, last_modified, "temporary") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, ?)' (None, u'Trading My Sorrows', u'', None, u'v1 v2 c1 b1 v1 v2 c1 c1', u'', u'', u'', u'', u'Blue Burst', u'', u'', 0) --- System information --- Platform: Darwin-11.4.0-i386-32bit --- Library Versions --- Python: 2.7.3 Qt4: 4.8.2 Phonon: 4.4.0 PyQt4: 4.9.1 QtWebkit: 534.34 SQLAlchemy: 0.7.7 SQLAlchemy Migrate: 0.7.2 BeautifulSoup: 3.2.1 lxml: 2.3.2 Chardet: 2.0.1 PyEnchant: - PySQLite: - Mako: 0.7.0 pyUNO bridge: - To manage notifications about this bug go to: https://bugs.launchpad.net/openlp/+bug/1051890/+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