Update 1.2.2 to 1.2.3 -> SQLite Out of Memory Exception in Multiseat Mode

Discussion in '1.2.x' started by azimek, April 14, 2012.

    • Premium Supporter

    azimek MP Donator

    MediaPortal Version: 1.2.2

    Description
    After updating my 1.2.2Installation to 1.2.3 I get an Out of Memory Exception from my Multiseat clients. Everything works fine so far on the server but my clients fail to start MePo. Clients will not start at all!

    Steps to Reproduce:
    My databases are located on the server. Look at the MP config file of the client.

    Attached Files:

    • Premium Supporter

    azimek Thread Starter MP Donator

    It seams to be a problem with the 1.2.2 databases. If I delete all the old databases and start MePo database files are created newly and MePo starts.
    I tried to copy back the old databases one by one and fanart database got me back to the problem.
    No problem with the other databases (Moving Pictures / TV Series and so on)
    By the way - all extensions are up to date!
    • Team MediaPortal

    elliottmc Release Manager

    System Specs
    Are you using the same database for all clients? This is not recommended, although hopefully it will actually be better with the new sqlite.

    I would suspect that the database in question is corrupted, and the new version is more sensitive to such issues.
    • Premium Supporter

    azimek Thread Starter MP Donator

    OK - it is not recommended - but what would be the better solution? In a multiseat environment where all clients should share the same datasources it would be best if the data was stores in the MSSQl server that is already available for the TV server. As this would be ab bigger change for all pulgin developers I guess this solution will not happen within the next year or two.
    What would be your advice to share all the plugin data in a multiseat setup?
    4 or 5 years ago I followed a thread that described exactly the setup that I am now running (all databases on a single share on the server)

    Thx André
    • Team MediaPortal

    elliottmc Release Manager

    System Specs
    The best situation is to have databases on each computer, even if they access the same media files.

    If two clients are trying to access the database at the same time, some corruption is almost inevitable.

    We know that this is not a perfect situation. That is one of the reasons for the development of MediaPortal 2. I don't think this will be 'fixed' for MediaPortal 1, since it is the way it was designed to work and is therefore not considered a bug.

    Some people do share the databases and find that things work okay. They are the lucky ones!
    • Premium Supporter

    azimek Thread Starter MP Donator

    Thanks for your help. I am running this setup for about 4 years without bigger issues in the past. So I guess it really is a problem with the new SQLite version.
    After resetting the Fanart database everything looks fine again. I just hope it will stay this way :)
    André
    • Team MediaPortal

    elliottmc Release Manager

    System Specs
    The fanart database is a 3rd party plugin, so maybe it has issues with the new sqlite. I fully understand that you have been using a shared database setup for a long time. Perhaps now that you have reset the database, it will all be okay again. However, with the number of known issues that the team have to fix, making changes to help with shared databases is not going to be high on the list of priorities.
    • Like Like x 1
  1. juro Portal Pro

    System Specs
    I have an identical problem after an update of tv series and latest media handler plug in in my single seat environment. after update mp does not start anymore, c++ runtime error and there are milions of entries in the log with sql lite out of memory messages

    don't know what to do ...
    • Premium Supporter

    bribbon MP Donator

    System Specs
    Ive got today the same problem here in SingleSeat Mode. I've deinstalled the InfoServices Plugin, After a reboot I can't start MePo anymore and get an Out of Memory Exception from SQLite. I will attach my Logs later.
    • Team MediaPortal

    elliottmc Release Manager

    System Specs
    In general, first try deleting the various media databases is

    C:\ProgramData\Team MediaPortal\MediaPortal\database

    and then reconfigure the databases.

Share This Page

Users Viewing Thread (Users: 0, Guests: 0)

Running the latest version?

V1.4.0 FINAL - released June 2013
Releasenews | Download
Changelog
 | Requirements
HTPC
Team-MediaPortal
 
About
Contact |  Press
Partners