Problem playing random music when library updating

[tkgafs]

Psycik,

I was playing a random stream on my mvp as usual last night, but it crashed when I suspect a new set of random tracks were about to be requested from the db, at the same time the daily scan for new tracks had just started.

below is an extract from the gbpvr log and I have attached extracts from the musiclibrary2 log as well

I'm using latest versions of gbpvr and musiclibrary2

Tkgafs


2007-03-16 03:03:07.843 VERBOSE [25] MVP request processed
2007-03-16 03:03:07.843 VERBOSE [26] Request 20000 bytes (file size:5018325 file location: 5018325)
2007-03-16 03:03:07.843 VERBOSE [26] Not all bytes read. Got:0 Filesize now:5018325
2007-03-16 03:03:07.843 VERBOSE [26] End of stream
2007-03-16 03:03:07.875 VERBOSE [25] MVP data read: 1 (9)
2007-03-16 03:03:07.875 VERBOSE [25] MVP request processed
2007-03-16 03:03:07.875 VERBOSE [26] MVP Streaming Server received STOP message
2007-03-16 03:03:07.875 VERBOSE [26] Song ended. Checking if there are more songs to play.
2007-03-16 03:03:07.875 VERBOSE [26] Playlist size: 39 current index: 37
2007-03-16 03:03:07.875 VERBOSE [26] About to start playback of Q:\Music\Include\Hugh Banton - Goldberg Variations\11 - Variation X (Fughetta).mp3
2007-03-16 03:03:08.843 ERROR [26] Media stream thread caught exception: System.Data.SQLite.SQLiteException: Library used incorrectly
library routine called out of sequence
at System.Data.SQLite.SQLite3.Close()
at System.Data.SQLite.SQLiteConnection.Close()
at MusicLibrary.MediaLibrary.GetTitles(String primary, String secondary, Boolean checkMissing, Boolean orderByTrack, Boolean keyByFilename, Boolean random)
at MusicLibrary.MediaLibrary.RandomPlaylist(String primary, String secondary, Int32 minutes)
at MusicLibrary.MediaLibrary.Notify(EventTypes eventType, String eventText)
at GBPVR.Backend.Common.xc4f12ec3a8a4c96b.x85b8d963f05ddf09(EventTypes x4f04899de3605e17, String xbc19b591abc4848a)
at GBPVR.x62b73fb0db4f3947.x826e5d374a1e5ab9(String x8b449efd64797843, Boolean x859a785ef30c9007, Boolean xe1ea8da9364d6bfb)
at GBPVR.x62b73fb0db4f3947.x2cf8d59067433309()
at GBPVR.xbb1566157f5f8b1f.xf9d81bb81f7c2ff0()
2007-03-16 03:03:08.843 VERBOSE [26] MVP Streaming Thread shutting down...
2007-03-16 03:03:08.921 VERBOSE [26] MVP Streaming Thread shutdown finished
2007-03-16 03:03:10.640 VERBOSE [1] videoInsetVisible = false
2007-03-16 03:03:10.718 VERBOSE [1] MusicPlaybackManager.stop()
2007-03-16 03:03:11.109 VERBOSE [25] MVP data read: 1 (7)
2007-03-16 03:03:11.109 VERBOSE [25] Got ACK
2007-03-16 03:03:11.375 VERBOSE [25] MVP request processed
2007-03-16 03:03:11.375 VERBOSE [25] MVP data read: 1 (3)
2007-03-16 03:03:11.375 VERBOSE [25] MVP request processed

[psycik]

hmm, not sure what could be done about this. I'm seriously thinking of "externalising" the library update part, because some other requests by users.

Does it happen often or has it just been a one off at this stage?

[tkgafs]

hmm, not sure what could be done about this. I'm seriously thinking of "externalising" the library update part, because some other requests by users.

Does it happen often or has it just been a one off at this stage?

Probably a one-off my normal update is scheduled for 03:00 in the morning and last night I happened to be working very late and was listening to ML2 at the same time. And presumably it just happened that the random playlist needed refreshed just as the daily update was taking place

presumably you could set a flag that the update was in progress and that no access to the library was available at this point, then have the playing code check every minute or so until it can get access again when the flag is unset.

It may have happened before but I have no actual idea

I'd be quite happy to have to manually update the library externally

tkgafs