[confirm] - MP2-TVE3 : XMLTV lead to MP2 Server crash

Discussion in 'Older releases' started by azzuro, January 25, 2016.

  1. azzuro
    • Team MediaPortal

    azzuro Test Group

    Joined:
    May 10, 2007
    Messages:
    8,425
    Likes Received:
    2,504
    Occupation:
    technician HVAC
    Location:
    France - IDF
    Ratings:
    +4,168 / 13
    Home Country:
    France France
    Show System Specs
    Hello,
    since few days, i can't have all my EPG displayed.

    on XML import, the MP2-Server + TVE crash with this message :

    Code (Text):
    1. [2016-01-25 20:53:32,277] [507473 ] [SQL EPG importer] [INFO ] - BusinessLayer: InsertMySql caused an Exception - The database backend (provider MySQL) could not be reached.
    2. Check the connection string: Server=TVE-SRV;Database=mp2tvdb2;User ID=root;Password=MediaPortal;charset=utf8;Connection Timeout=30;,    à Gentle.Common.Check.FailWith(Severity severity, Error error, Exception e, String msg)
    3.    à Gentle.Common.Check.Fail(Exception e, Error error, Object[] args)
    4.    à Gentle.Provider.MySQL.MySQLProvider.GetConnection()
    5.    à TvDatabase.TvBusinessLayer.InsertProgramsMySql(ImportParams aImportParam)
    6. [2016-01-25 20:53:32,279] [507475 ] [SQL EPG importer] [DEBUG] - BusinessLayer: Inserted 829 programs to the database
    7. [2016-01-25 20:53:32,281] [507477 ] [scheduler thread] [DEBUG] - scheduler: SchedulerWorker inner exception Error: DatabaseUnavailableUnclassified
    8. Gentle.Common.GentleException: The database backend (provider MySQL) could not be reached.
    9. Check the connection string: Server=TVE-SRV;Database=mp2tvdb2;User ID=root;Password=MediaPortal;charset=utf8;Connection Timeout=30; ---> MySql.Data.MySqlClient.MySqlException: error connecting: Timeout expired.  The timeout period elapsed prior to obtaining a connection from the pool.  This may have occurred because all pooled connections were in use and max pool size was reached.
    10.    à MySql.Data.MySqlClient.MySqlPool.GetConnection()
    11.    à MySql.Data.MySqlClient.MySqlConnection.Open()
    12.    à Gentle.Provider.MySQL.MySQLProvider.GetConnection()
    13.    --- Fin de la trace de la pile d'exception interne ---
    14.    à Gentle.Common.Check.FailWith(Severity severity, Error error, Exception e, String msg)
    15.    à Gentle.Common.Check.Fail(Exception e, Error error, Object[] args)
    16.    à Gentle.Provider.MySQL.MySQLProvider.GetConnection()
    17.    à Gentle.Framework.PersistenceBroker.RetrieveList[T](Key key, IList`1 result, IDbConnection conn, IDbTransaction tr)
    18.    à Gentle.Framework.PersistenceBroker.RetrieveList[T](Key key, IList`1 result)
    19.    à Gentle.Framework.Broker.RetrieveList[T](Key key, IList`1 result)
    20.    à TvDatabase.CanceledSchedule.DeleteAllCancelledSeries()
    21.    à TvService.Scheduler.DoScheduleWork()
    22.    à TvService.Scheduler.SchedulerWorker()MySql.Data.MySqlClient.MySqlException (0x80004005): error connecting: Timeout expired.  The timeout period elapsed prior to obtaining a connection from the pool.  This may have occurred because all pooled connections were in use and max pool size was reached.
    23.    à MySql.Data.MySqlClient.MySqlPool.GetConnection()
    24.    à MySql.Data.MySqlClient.MySqlConnection.Open()
    25.    à Gentle.Provider.MySQL.MySQLProvider.GetConnection()
    26.  
    i don't know where is the problem.
    i use the Tvguide.lst as method for import 2 epg files.
    i think the culprit come with the EPG1.xml.



    The log files : .1 .2 .3 are from the same thread, only 10mb split files

    if you need i can share the MYSQLdump & TVE export of my TVE.

    @mm1352000 : i tag you, i think you are alone with @morpheus_xx to know where is the problem.
     

    Attached Files:

    • EPG.zip
      File size:
      11.9 MB
      Uploaded:
      January 25, 2016
      Views:
      89
  2. Google AdSense Guest Advertisement



    to hide all adverts.
  3. azzuro
    • Team MediaPortal

    azzuro Test Group

    Joined:
    May 10, 2007
    Messages:
    8,425
    Likes Received:
    2,504
    Occupation:
    technician HVAC
    Location:
    France - IDF
    Ratings:
    +4,168 / 13
    Home Country:
    France France
    Show System Specs
    maybe this is the culprit :
    Code (Text):
    1. This may have occurred because all pooled connections were in use and max pool size was reached.
     
  4. azzuro
    • Team MediaPortal

    azzuro Test Group

    Joined:
    May 10, 2007
    Messages:
    8,425
    Likes Received:
    2,504
    Occupation:
    technician HVAC
    Location:
    France - IDF
    Ratings:
    +4,168 / 13
    Home Country:
    France France
    Show System Specs
    Maybe an solution is to increase the number of pool request :
    check how many request are set :
    Code (Text):
    1. mysql> SHOW VARIABLES LIKE "max_connections";
    2. +-----------------+-------+
    3. | Variable_name   | Value |
    4. +-----------------+-------+
    5. | max_connections | 151   |
    6. +-----------------+-------+
    7. 1 row in set (0.02 sec)
    So, 151 request max. maybe too small for my EPG import, but worked previously

    For increase request :
    Code (Text):
    1. mysql>SET GLOBAL max_connections=300;
    i will set 300 for testing.
     
  5. azzuro
    • Team MediaPortal

    azzuro Test Group

    Joined:
    May 10, 2007
    Messages:
    8,425
    Likes Received:
    2,504
    Occupation:
    technician HVAC
    Location:
    France - IDF
    Ratings:
    +4,168 / 13
    Home Country:
    France France
    Show System Specs
  6. azzuro
    • Team MediaPortal

    azzuro Test Group

    Joined:
    May 10, 2007
    Messages:
    8,425
    Likes Received:
    2,504
    Occupation:
    technician HVAC
    Location:
    France - IDF
    Ratings:
    +4,168 / 13
    Home Country:
    France France
    Show System Specs
    For information :
    Lot of pool are identified as "sleep" in MySQL Workbench, i don't know if this info can help.
     
  7. azzuro
    • Team MediaPortal

    azzuro Test Group

    Joined:
    May 10, 2007
    Messages:
    8,425
    Likes Received:
    2,504
    Occupation:
    technician HVAC
    Location:
    France - IDF
    Ratings:
    +4,168 / 13
    Home Country:
    France France
    Show System Specs
    So, after modify :
    max_connection to 1000

    Set .Host file with
    127.0.0.1 localhos
    ::1 localhost

    MP2-server crash always, i'm back on MP1-TVE3.

    On MP1. i can have few error during xmltv import " Get_lock" message . but at least don't crash anymore.
     
Loading...

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

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice
  • About The Project

    The vision of the MediaPortal project is to create a free open source media centre application, which supports all advanced media centre functions, and is accessible to all Windows users.

    In reaching this goal we are working every day to make sure our software is one of the best.

             

  • Support MediaPortal!

    The team works very hard to make sure the community is running the best HTPC-software. We give away MediaPortal for free but hosting and software is not for us.

    Care to support our work with a few bucks? We'd really appreciate it!