TV Series causing MP to crash on startup (1 Viewer)

[kiwijunglist]

Hi

On my main HTPC TV-Series is causing MP to crash on startup.

I have disabled most of the other plugins in order to make the logs easier to read. If I enable the other plugins and disable tv series then I don't get a crash. If think this is caused by a database error, possible caused by MPExtended Service @Oxan accessing the tvseries database. Restoring the backed up database fixes the problem.

Log excerpt:

Spoiler

[2013-06-28 19:05:46,375] [Log ] [MPMain ] [DEBUG] - PluginManager: End loading '\windows\Dialogs.dll' (306.0175 ms running time)
[2013-06-28 19:05:46,375] [Log ] [MPMain ] [DEBUG] - PluginManager: Begin loading '\windows\IMDb+.dll' (non threaded)
[2013-06-28 19:05:46,375] [Log ] [MPMain ] [DEBUG] - PluginManager: End loading '\windows\IMDb+.dll' (0 ms running time)
[2013-06-28 19:05:46,375] [Log ] [MPMain ] [DEBUG] - PluginManager: Begin loading '\windows\MovingPictures.dll' (non threaded)
[2013-06-28 19:05:46,375] [Log ] [MPMain ] [DEBUG] - PluginManager: End loading '\windows\MovingPictures.dll' (0 ms running time)
[2013-06-28 19:05:46,375] [Log ] [MPMain ] [DEBUG] - PluginManager: Begin loading '\windows\MPEIPlugin.dll' (non threaded)
[2013-06-28 19:05:46,375] [Log ] [MPMain ] [DEBUG] - PluginManager: End loading '\windows\MPEIPlugin.dll' (0 ms running time)
[2013-06-28 19:05:46,375] [Log ] [MPMain ] [DEBUG] - PluginManager: Begin loading '\windows\MP-TVSeries.dll' (non threaded)
[2013-06-28 19:05:46,378] [Log ] [MPMain ] [INFO ] - PluginManager: 'C:\Program Files (x86)\Team MediaPortal\MediaPortal\Plugins\windows\MP-TVSeries.dll' file version: 3.5.0.2028
[2013-06-28 19:05:46,602] [Log ] [MPMain ] [INFO ] - SQLiteClient: Closing database: TVSeriesDatabase4.db3
[2013-06-28 19:05:46,603] [Log ] [MPMain ] [INFO ] - SQLiteClient: Closing database:
[2013-06-28 19:05:46,604] [Log ] [MPMain ] [INFO ] - SQLiteClient: Closing database: (Repeats 1000x times)

 

[Django.edwards]

Hi kiwijunglist, it seems that your TV-Series database is corrupt. You could try to delete it, so it will be rebuilded. Don't think thats causes by mpextended.

 

[kiwijunglist]

Restoring the backed up database fixes the problem.

you skimmed my post too quickly btw no need to delete tv series database as it always backs itself up in a subdirectory of the database directory.

 

[Django.edwards]

 

[RoChess]

@kiwijunglist, that 'backup' folder is only made during upgrades of MP-TVSeries. Of course this happens often, but a new upgrade could backup a corrupted dbase. Using the actual MPEI backup plugin might be of more use.

SQLite supports multi-usage scenarios, but only if both apps truly support it by checking if another app has a lock first/etc. Not many MePo apps are written like that, so dbase corruption can occur quick.

 

[kiwijunglist]

I'm now using MPsync plugin to make a copy of the databases (one way sync). MPsync is read only so i'm pretty sure it can't corrupt anything. Then I let mpextended access the copy only. Hopefully this should make it impossible to corrupt the database by having 2x programs write to the database at the same time.