openlp-core team mailing list archive

[John Cegalis <1030965@xxxxxxxxxxxxxxxxxx>]

I checked the debug file and it showed my database was read only. I changed that and it imported fine. I can see how the database became read only when I restored the backup but I'm not sure if that was the original problem since I haven't touched the database file before that. 
I'm closing this bug since it shouldn't be here.

** Changed in: openlp
       Status: New => Invalid

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

Title:
  ccli import failed with traceback

Status in OpenLP - Worship Presentation Software:
  Invalid

Bug description:
  I was importing this song from ccli text and got this. I imported a
  first song without a problem and now this traceback keeps coming up.
  It did corrupt my database once with a different traceback and I had
  to restore my song database.

  
  Version: {u'full': u'1.9.11', u'version': u'1.9.11', u'build': None}

  --- Details of the Exception. ---


  --- Exception Traceback ---
  Traceback (most recent call last):
  File "/usr/lib/pymodules/python2.7/openlp/core/ui/mainwindow.py", line 1187, in closeEvent
  self.cleanUp()
  File "/usr/lib/pymodules/python2.7/openlp/core/ui/mainwindow.py", line 1209, in cleanUp
  self.pluginManager.finalise_plugins()
  File "/usr/lib/pymodules/python2.7/openlp/core/lib/pluginmanager.py", line 206, in finalise_plugins
  plugin.finalise()
  File "/usr/lib/pymodules/python2.7/openlp/plugins/songs/songsplugin.py", line 268, in finalise
  self.clearTemporarySongs()
  File "/usr/lib/pymodules/python2.7/openlp/plugins/songs/songsplugin.py", line 285, in clearTemporarySongs
  songs = self.manager.get_all_objects(Song, Song.temporary == True)
  File "/usr/lib/pymodules/python2.7/openlp/core/lib/db.py", line 376, in get_all_objects
  return query.all()
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 1947, in all
  return list(self)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2057, in __iter__
  return self._execute_and_instances(context)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2070, in _execute_and_instances
  close_with_result=True)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2061, in _connection_from_session
  **kw)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 719, in connection
  close_with_result=close_with_result)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 723, in _connection_for_bind
  return self.transaction._connection_for_bind(engine)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 249, in _connection_for_bind
  self._assert_is_active()
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 173, in _assert_is_active
  % self._rollback_exception
  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: (OperationalError) attempt to write a readonly database 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'You Never Let Go', u'', u'<?xml version=\'1.0\' encoding=\'UTF-8\'?>\n<song version="1.0"><lyrics><verse type="p" label="1"><![CDATA[And I will fear no evil\r\nFor my God is with me\r\nAnd if my God is with me\r\nWhom then shall I fear\r\nWhom then shall I fear]]></verse><verse type="c" label="1"><![CDATA[Oh no You never let go\r\nThrough the calm and through the storm\r\nOh no You never let go\r\nIn ev\'ry high and ev\'ry low\r\nOh no You never let go\r\nLord You never let go of me]]></verse><verse type="v" label="1"><![CDATA[Even though I walk\r\nThrough the valley of the shadow of death\r\nYour perfect love is casting out fear\r\nAnd even when I\'m caught\r\nIn the middle of the storms of this life\r\nI won\'t turn back I know You are near]]></verse><verse type="v" label="2"><![CDATA[And I can see a light that is coming\r\nFor the heart that holds on\r\nA glorious light beyond all compare\r\nAnd there will be an end to these troubles\r\nBut until that day comes\r\nWe\'ll live to know You here on the earth]]></verse><verse type="c" label="2"><![CDATA[Oh no You never let go\r\nThrough the calm and through the storm\r\nOh no You never let go\r\nIn ev\'ry high and ev\'ry low\r\nOh no You never let go\r\nLord You never let go of me\r\nYou keep on runnin\' and You never let go\r\nSingin\']]></verse><verse type="b" label="1"><![CDATA[Yes I can see a light\r\nThat is coming for the heart that holds on\r\nAnd there will be an end to these troubles\r\nBut until that day comes\r\nStill I will praise You\r\nStill I will praise You\r\n(REPEAT)]]></verse></lyrics></song>', u'', u'\xa9 2005 Thankyou Music (Admin. by EMI Christian Music Publishing)', u'For use solely with the SongSelect Terms of Use. All rights reserved. www.ccli.com', u'4674166', u'', u'', u'', u'', 0)

  --- System information ---
  Platform: Linux-3.2.0-27-generic-x86_64-with-Ubuntu-12.04-precise
  Desktop: KDE SC

  --- Library Versions ---
  Python: 2.7.3
  Qt4: 4.8.1
  Phonon: 4.6.0
  PyQt4: 4.9.1
  QtWebkit: 534.34
  SQLAlchemy: 0.7.4
  SQLAlchemy Migrate: 0.7.2
  BeautifulSoup: 3.2.0
  lxml: 2.3.2
  Chardet: 2.0.1
  PyEnchant: 1.6.5
  PySQLite: 1.0.1
  Mako: 0.5.0
  pyUNO bridge: 3.5

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