[confirm] MP2-TVE3 : XMLTV lead to MP2 Server crash (1 Viewer)

[azzuro]

Hello,
since few days, i can't have all my EPG displayed.

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

[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.
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)
   à Gentle.Common.Check.Fail(Exception e, Error error, Object[] args)
   à Gentle.Provider.MySQL.MySQLProvider.GetConnection()
   à TvDatabase.TvBusinessLayer.InsertProgramsMySql(ImportParams aImportParam)
[2016-01-25 20:53:32,279] [507475 ] [SQL EPG importer] [DEBUG] - BusinessLayer: Inserted 829 programs to the database
[2016-01-25 20:53:32,281] [507477 ] [scheduler thread] [DEBUG] - scheduler: SchedulerWorker inner exception Error: DatabaseUnavailableUnclassified
Gentle.Common.GentleException: The database backend (provider MySQL) could not be reached.
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.
   à MySql.Data.MySqlClient.MySqlPool.GetConnection()
   à MySql.Data.MySqlClient.MySqlConnection.Open()
   à Gentle.Provider.MySQL.MySQLProvider.GetConnection()
   --- Fin de la trace de la pile d'exception interne ---
   à Gentle.Common.Check.FailWith(Severity severity, Error error, Exception e, String msg)
   à Gentle.Common.Check.Fail(Exception e, Error error, Object[] args)
   à Gentle.Provider.MySQL.MySQLProvider.GetConnection()
   à Gentle.Framework.PersistenceBroker.RetrieveList[T](Key key, IList`1 result, IDbConnection conn, IDbTransaction tr)
   à Gentle.Framework.PersistenceBroker.RetrieveList[T](Key key, IList`1 result)
   à Gentle.Framework.Broker.RetrieveList[T](Key key, IList`1 result)
   à TvDatabase.CanceledSchedule.DeleteAllCancelledSeries()
   à TvService.Scheduler.DoScheduleWork()
   à 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.
   à MySql.Data.MySqlClient.MySqlPool.GetConnection()
   à MySql.Data.MySqlClient.MySqlConnection.Open()
   à Gentle.Provider.MySQL.MySQLProvider.GetConnection()

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.

 

[azzuro]

maybe this is the culprit :

This may have occurred because all pooled connections were in use and max pool size was reached.

 

[azzuro]

Maybe an solution is to increase the number of pool request :
check how many request are set :

mysql> SHOW VARIABLES LIKE "max_connections";
+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| max_connections | 151   |
+-----------------+-------+
1 row in set (0.02 sec)

So, 151 request max. maybe too small for my EPG import, but worked previously

For increase request :

mysql>SET GLOBAL max_connections=300;

i will set 300 for testing.

 

[azzuro]

300 don't solve the problem.
i have set 1000. wait & see

 

[azzuro]

For information :
Lot of pool are identified as "sleep" in MySQL Workbench, i don't know if this info can help.

 

[azzuro]

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.