Out of memory on startup/config/enable (2 Viewers)

[Regis]

Hello,
I have been successfully running Mediaportal with Moving Pictures until this morning when we had a power outage while my HTPC was in sleep mode. After reboot I would get out of memory exception when Mediaportal was starting (during the loading extensions phase). Looking at task manager the Mediaportal was allocating 3GB of RAM and then crashing (32bit process).

So I randomly disabled plugins until I found Moving Pictures was the culprit - disabling it allows Mediaportal to start. I went to update the Moving pictures from the plugin manager which seemed to succeed but unfortunately did not help.

What is worse I now cannot enable the Moving Pictures plugin again to collect the logs using Mediaportal Debug mode because when I click Enable in the Mediaportal config plugin section the whole config application crashes. Also when I try to run the standalone Moving Pictures Configuration it again crashes.

Are there any logs I can collect manually without running the Mediaportal debug mode? Perhaps some logs for the Moving Pictures Configuration tool itself? Anything else I should try?

Thanks in advance.

 

[RoChess]

I have been successfully running Mediaportal with Moving Pictures until this morning when we had a power outage while my HTPC was in sleep mode. After reboot I would get out of memory exception when Mediaportal was starting (during the loading extensions phase). Looking at task manager the Mediaportal was allocating 3GB of RAM and then crashing (32bit process).

You more then likely corrupted the SQLite movingpictures.db3 database. Easy way to check/verify.

1. Download SQLite commandline tool at: https://sqlite.org/2014/sqlite-shell-win32-x86-3080300.zip
2. Unzip sqlite3.exe from the ZIP file
3. Start -> All Programs -> Team MediaPortal -> "User Files" shortcut
4. Hold down SHIFT key and right click on the "database" folder and select "Open command window here"
5. Double ckick to open the "database" folder inside Windows explorer
6. Move or copy sqlite3.exe into this folder (or place it in a folder accessible by PATH environment)
7. Go back to the command window and type in: sqlite3.exe movingpictures.db3 "PRAGMA integrity_check;" [ENTER]

If you do not get the simple response back of 'ok', but some error, then unless you made backups, start crying, wipe tears away and rename movingpictures.db3 to movingpictures.corrupt (or simply delete it) and start over fresh. Now if you have been smart and made backups simply restore the last one and resume. Each time you upgrade MovPic automatic backups are made, so be sure to check for subfolders inside the "database" folder (I just hope your 'upgrade' attempt to "fix" things did not overwrite a valid backup with a copy of the corrupted one).

With a lot of SQL knowledge and a lot of time you might be able to repair a corrupted database, but even Moving-Pictures developers suggest a fresh start is easier.

PS: For the future, start considering an automatic backup/restore system that scans for database corruption. I've made the script I use myself available at: https://forum.team-mediaportal.com/threads/corrupted-database.120376/#post-1014075

 

[Regis]

Thanks RoChess, turns out DB is corrupt (freelist leaf count too big, blah, blah) and the backup is from today 6 PM when I updated the Moving Pictures plugin. Oh well, lesson learned. Few hundred movies to reimport, not a big deal. Perhaps the update/installer can do an integrity check before backup at some point.

I am a bit surprised Google search for "Mediaportal Moving Pictures database check" did not turn up with anything because I did try that. Never mind.

 

[RoChess]

Thanks RoChess, turns out DB is corrupt (freelist leaf count too big, blah, blah) and the backup is from today 6 PM when I updated the Moving Pictures plugin. Oh well, lesson learned. Few hundred movies to reimport, not a big deal. Perhaps the update/installer can do an integrity check before backup at some point.

I am a bit surprised Google search for "Mediaportal Moving Pictures database check" did not turn up with anything because I did try that. Never mind.

Perfect time to try out IMDb+ if you are going to import fresh

And now that you have MovPic v1.6, you will get collections, release_date, and keyword support by scrapers that support it (IMDb+ and the integrated TMDb for example). To activate collections, open MovPic config, edit custom categories and add a new menu item for the dynamic category 'categories', although since you are starting with fresh setup, it might do that automatic now.

I mass-update my collection once every 3 or 4 months via IMDb+ plugin method (update score/rating/missing-info/etc), the only reason I make a lot of backups and would cry as well if mine got corrupt, is because I put in countless hours adding/tweaking custom categories that currently have no way to export/import.

 

[xadox]

...I mass-update my collection once every 3 or 4 months via IMDb+ plugin method...

How are you doing that? Since I am also interested in that, but I do not want to loose my custom setings in the movies?

 

[RoChess]

How are you doing that? Since I am also interested in that, but I do not want to loose my custom setings in the movies?

All my custom settings either match the default rename database, or I've added them to the custom one. So then once every 3-6 months (depends how often I remember), I use the IMDb+ plugin option to refresh my entire collection. There is also a seperate IMDb+ option for this that only updates certification/rating/missing-fields, to avoid messing with your custom adjustments on title/summary/etc.

Really need to update the wiki with new screenshots, but the method is still the same as per: http://code.google.com/p/imdbplus/wiki/InstallPlugin#Refreshing_your_collection_with_IMDb+

I just let it run while I'm asleep or watching other movies. You might need to tweak the Moving-Pictutres advanced settings if you want to refresh your collection while watching movies/etc, such as reducing the threads, as it does require a beefy system to do all at the same time. Actually with DXVA2 decoding it does not require much, but that all depends on how concurrent friendly your codecs are, as during import the same codecs are used to obtain all the MediaInfo data/etc. Having an SSD for all the database and artwork storage helps as well. Look for like a letter in your collection that you do not have many movies on, say Q or Z and refresh just those (option to do so inside IMDb+ refresh menu). Then quickly switch to MovPic and watch a movie, and see if you notice any stutter/issues, if not then you can just refresh all.

 

[xadox]

Thx for your Feedback.

 

[Regis]

Hi,
So I reimported all movies no problem. However Moving pictures now refuse to start paying movies - when I click the play button on the remote I get a click sound and that is all. I was going to blame Mediaportal itself (codecs etc.) however there is something strange going on with Moving pictures: after trying to play the first movie from my Moving pictures collection I went to standard Mediaportal videos section and started a random movie from there - the movie started fine but it the overlay it had the name and description of the movie which failed to start in Moving pictures! I was playing completely different file from different location mind you. Also the movie could not be stopped - I had to force close Mediaportal to get out.

So it looks like the information from Moving pictures somehow gets into the video player but it then fails to start... and it also gets knackered in the process preventing it from stopping if it eventually starts from outside of the plugin. I am really puzzled how this can be happening. Any suggestions?

(IMDB+ is weird BTW, offers tons of irrelevant matches and usually like 3 identical suggestions for one movie and same year).

 

[RoChess]

(IMDB+ is weird BTW, offers tons of irrelevant matches and usually like 3 identical suggestions for one movie and same year).

Without knowing the IMDb+ settings you used, Full Path + Filename of the culprit in question and any other relevant information, it will ALWAYS REMAIN weird, because I can only fix something if I can reproduce the problem or am provided proper log files that allow me to see what is going wrong.

I import about 10 movies a week on different names/methods to ensure IMDb+ is still working, aside from IMDb+ users reporting issues to me on the IMDb+ forum section. There are no issues as far as I'm aware with v4.9.30, but I'll be happy to fix if there are.

More then likely you have something else happening. Enable display of scaper-script name setting, more then likely IMDb+, IMDb (default) and TMDb were all offering you the 3 results you saw due to the import settings you are using. Ideally you disable all the scraper scripts you do not use/need to prevent false positives.

Without enabling the option to see the scraper-script name responsible for the result, it can indeed look confusing.

 

[Regis]

Sorry I did not mean to be overly critical. It was just a first impression of not very advanced user. Please don't take it as condemnation of the whole product.

I have managed to solve my "movies not playing" problem - apparently installing Moving Pictures manually and then installing them again using the extension manager is a really bad idea. Once I removed the plugin using the extension manager it started working again - I am now running the old 1.4 version I had before the DB crash. I think I'll stop mucking around before I break something else.