does MP-TVSeries close it's database properly on an shutdown event? (2 Viewers)

[disaster123]

Hi!

I'm not shure if this is my problem. But i get a corrupt mptvseries db very often. Especialy after shutting down one client and starting up the other one. I'm using a centralized DB on an external system.

In the MP Log i can see that MP closes all it's databases when a shutdown happens - but i do not see the mp-tvseries DB.

2009-08-26 18:12:16.534145 [Debug][38]: WindowsController: Performing ExitWindows Suspend, force: False
2009-08-26 18:12:17.206184 [Info.][MPMain]: Main: WM_POWERBROADCAST: 4
2009-08-26 18:12:17.206184 [Info.][MPMain]: Main: Windows is suspending
2009-08-26 18:12:17.207184 [Debug][MPMain]: Main: SaveLastActiveModule - enabled False
2009-08-26 18:12:17.207184 [Info.][MPMain]: Main: Stopping playback
2009-08-26 18:12:17.207184 [Info.][MPMain]: Main: Stopping AutoPlay
2009-08-26 18:12:17.208184 [Info.][MPMain]: Main: disposing FolderDatabase3 sqllite database.
2009-08-26 18:12:17.208184 [Info.][MPMain]: open folderdatabase
2009-08-26 18:12:17.214184 [Info.][MPMain]: SQLiteClient: Closing database: FolderDatabase3.db3
2009-08-26 18:12:17.215184 [Info.][MPMain]: Main: disposing PictureDatabase sqllite database.
2009-08-26 18:12:17.221185 [Info.][MPMain]: picture database opened
2009-08-26 18:12:17.221185 [Info.][MPMain]: SQLiteClient: Closing database: PictureDatabase.db3
2009-08-26 18:12:17.222185 [Info.][MPMain]: Main: disposing VideoDatabaseV5.db3 sqllite database.
2009-08-26 18:12:17.222185 [Info.][MPMain]: opening video database
2009-08-26 18:12:17.239186 [Info.][MPMain]: video database opened
2009-08-26 18:12:17.239186 [Info.][MPMain]: SQLiteClient: Closing database: VideoDatabaseV5.db3
2009-08-26 18:12:17.240186 [Info.][MPMain]: Main: OnSuspend - Done

Stefan

 

[tourettes]

I'm not shure if this is my problem. But i get a corrupt mptvseries db very often. Especialy after shutting down one client and starting up the other one. I'm using a centralized DB on an external system.

I would assume that is the root of all evil. SQLite cannot share multiple clients to the same database. So, if you have two clients accessing (maybe not even needing to write, who knows) the database simultaneous there is nothing going to be quaranteening the database would stay non-corrupted.

Closing the database might help preventing the corruption, but it wont fix it completely.

 

[disaster123]

mhm but when i shutdown client 1 and then start client 2 there are not two simultanious accesses.

But as i understand this faq entry - it should work. The reading client simply has to wait till the writing one is ready.
SQLite Frequently Asked Questions

Or do i misunderstand this faq?