MP crashes on startup - please review log files (1 Viewer)

[Brett Coster]

Hi all.
MP has been crashing on every startup. Running 1.2.3 with no issues for months. Have attached the log files but I am not sure what to look for. Ran in debug mode, and it runs perfectly, so it has to be a plugin or database issue...but which one and where is it? Some steps to fixing this issue would be appreciated.

Thanks
ozcoz

 

[infinite.loop]

Need yous system specs.

2012-09-25 18:20:27.497839 [ERROR][MPMain(1)]: SQLiteClient: FanartHandler.db3 cmd:sqlite3_prepare16: pvm=null err:NOMEM detailed: out of memory query: PRAGMA synchronous=OFF

In addition to that:

2012-09-25 18:20:19.935406 [ERROR][MostRecents(26)]: SQLiteClient:  cmd:sqlite3_step err:ERROR detailed:bind or column index out of range query:select online_series.ID, online_series.Pretty_Name, online_series.SortName, online_series.origName, online_series.Status, online_series.Genre, online_series.BannerFileNames, online_series.CurrentBannerFileName, online_series.PosterFileNames, online_series.PosterBannerFileName, online_series.Summary, online_series.OnlineDataImported, online_series.AirsDay, online_series.AirsTime, online_series.Actors, online_series.EpisodeOrders, online_series.choosenOrder, online_series.EpisodeSortOrder, online_series.BannersDownloaded, online_series.HasLocalFiles, online_series.HasLocalFiles_Temp, online_series.GetEpisodesTimeStamp, online_series.UpdateBannersTimeStamp, online_series.WatchedFileTimeStamp, online_series.UnwatchedItems, online_series.EpisodeCount, online_series.EpisodesUnWatched, online_series.ViewTags, online_series.TraktIgnore, online_series.language, online_series.banner, online_series.FirstAired, online_series.IMDB_ID, online_series.zap2it_id, online_series.ContentRating, online_series.Network, online_series.NetworkID, online_series.Rating, online_series.RatingCount, online_series.Runtime, online_series.SeriesID, online_series.added, online_series.addedBy, online_series.fanart, online_series.lastupdated, online_series.poster, online_series.HasNewEpisodes, local_series.Parsed_Name, local_series.ID, local_series.ScanIgnore, local_series.DuplicateLocalName, local_series.Hidden from online_series left join local_series on local_series.ID==online_series.ID where local_series.ID = 74845 and local_series.DuplicateLocalName = 0 and local_series.Hidden = 0 and  online_series.id in( select distinct online_episodes.SeriesID from online_episodes left join local_episodes on (local_episodes.CompositeID=online_episodes.CompositeID)  where local_episodes.EpisodeFilename != '' and online_episodes.Hidden = 0 and online_episodes.CompositeID not in (select distinct local_episodes.CompositeID2 from local_episodes where local_episodes.CompositeID2 != '') union select distinct online_episodes.SeriesID from online_episodes left join local_episodes on (local_episodes.CompositeID2=online_episodes.CompositeID)  where local_episodes.EpisodeFilename != '' and online_episodes.Hidden = 0 and local_episodes.CompositeID2 != '' ) order by upper(online_series.Pretty_Name)

When I had this the last time the TvSeries DB was damaged. I even think to remember that this leads to a memory leak and MP will eat up all your free ram. Which would explain the "out of mem".

 

[Brett Coster]

Pretty old and basic -
4gig ddr2 800 ram
4850 gfx
980 series amd board
Athlon 64 X2 6000+

Hope this helps

 

[infinite.loop]

I'd recommend to try and disable the TvSeries plugin inside MediaPortal Configuration -> Plugins, and then start MP again.
If the issue is gone, the db problem I guess its there is the cause.

You can also try to move the Tvseries database file to an other folder and then start MP. First startup will take some time because there is a timeout it waits when it can't find the database and then creates a new one.

 

[Brett Coster]

So...my settings showing the location of my TVSeries will remain, it will just need to recreate the database?
Disabled the plugin > deleted the database file. Now working fine.

Guess it is safe to again enable the plugin?

Awesome help so far by the way !

 

[infinite.loop]

Yes, you can re-enable the plugin. Too bad that the database is corrupted.
But the importers in TvSeries are working very good, so that is something you can recover from very fast.

Still... I'd recommend doing at least a weekly backup of all Databases. In that case, it is as simple as copying the files to a other location.