Export to GitHub

fofix - issue #939

Song cache and album art no longer works (database locked)


Posted on Aug 21, 2009 by Happy Rabbit

Enter the setlist, receive "connection lost" and "database is locked". Here it's the log:

(D) Song.getAvailableLibraries function call...library = C:\Songs\Various Songs (D) Dialogs.libraryListLoaded() function call... (E) Loading error: Traceback (most recent call last): File "GameEngine.pyo", line 1004, in main File "Engine.pyo", line 136, in run File "Engine.pyo", line 124, in _runTask File "SongChoosingScene.pyo", line 171, in run File "Dialogs.pyo", line 5335, in chooseSong File "Dialogs.pyo", line 776, in init File "Dialogs.pyo", line 914, in loadCollection File "Resource.pyo", line 246, in load File "Resource.pyo", line 133, in finish File "Dialogs.pyo", line 923, in libraryListLoaded File "Resource.pyo", line 246, in load File "Resource.pyo", line 113, in load File "Dialogs.pyo", line 923, in <lambda> File "Song.pyo", line 4401, in getAvailableSongsAndTitles File "Song.pyo", line 4207, in getAvailableSongs OperationalError: database is locked

(E) OperationalError, <class 'sqlite3.OperationalError'>: database is lockedTraceback (most recent call last): File "GameEngine.pyo", line 1031, in run File "GameEngine.pyo", line 1004, in main File "Engine.pyo", line 136, in run File "Engine.pyo", line 124, in _runTask File "SongChoosingScene.pyo", line 171, in run File "Dialogs.pyo", line 5335, in chooseSong File "Dialogs.pyo", line 776, in init File "Dialogs.pyo", line 914, in loadCollection File "Resource.pyo", line 246, in load File "Resource.pyo", line 133, in finish File "Dialogs.pyo", line 923, in libraryListLoaded File "Resource.pyo", line 246, in load File "Resource.pyo", line 113, in load File "Dialogs.pyo", line 923, in <lambda> File "Song.pyo", line 4401, in getAvailableSongsAndTitles File "Song.pyo", line 4207, in getAvailableSongs OperationalError: database is locked

Deleting cache doesn't solve the problem. In addiction if a new cache is created, album covers are no longer dispayed (with the old cache yes). When choosing a "fresh" folder with an old cache, it works regularly, but when the song is finished gives that error and makes that folder unplayable. (also tried choosing again setlist path and cleaning fofix.ini)

I'm using Py 2.6 with pygame 1.9.1 stable under Win 7

Comment #1

Posted on Aug 24, 2009 by Happy Rabbit

Does anyone has this issue? Otherwise I'll try to format my pc and upgrade win7 to RTM (It's time for a deep cleaning... :P)

Comment #2

Posted on Aug 24, 2009 by Massive Lion

At least, i don't have this...

Comment #3

Posted on Aug 24, 2009 by Happy Rabbit

Ok so I'll reinstall everything and check how it works. The strange thing is that about a month ago (before leaving for holydays) everything worked great, and now this happens without having used this pc or installed anything... But the album art problem when recreating cache happens also to a friend with latest releases... maybe it should better to check it out. :)

Comment #4

Posted on Aug 25, 2009 by Massive Lion

This looks like 699 alot! Looks like this isn't new. I still wonder what i'm missing to reproduce this.

Status: Duplicate

Labels:
Type-Defect Priority-Medium