MP2 - Spring'16 TV3/XMLTV Plugin - Number of connections (1 Viewer)

[Jay_UK]

Hi all,

I'm not sure if this is specific to MP2, or whether the actual issue is present in MP1 (code differences between the two?)

I thought I would give the XMLTV plugin a try, but encountered a slight issue.

It appears it's getting carried away with the number of connections to my MySQL database.

I have tried up'ing the max number of connections (to 500), but I still encounter the issue.

Please see the attached logfile(s)

Thanks,

J.

 

[HTPCSourcer]

Hi J.

It could be that data from one single TV channel that are not getting written and the import then hangs. Unfortunately log level is INFO, which doesn't show all details. Could you set your log level to ALL and repeat the operation to see if more information about a possibly blocking channel (if any) is logged?

 

[Jay_UK]

Hi there,

It might be an issue with the data, all I know is that when I try and connect with Workbench, it reports too many connections.

I'm being thick, where do I set the debug level in MP2 Server (The TVServer plugin config tool is set to debug)?

Thanks,

J.

 

[HTPCSourcer]

It's described in the Wiki: http://wiki.team-mediaportal.com/2_MEDIAPORTAL_2/6_Support/4_Bug_reports_and_log_files.

But your server log is also in INFO, so apply both changes.

 

[morpheus_xx]

Please check this wiki page for adjusting log levels: http://wiki.team-mediaportal.com/2_MEDIAPORTAL_2/6_Support/4_Bug_reports_and_log_files

Is there a reason why to prefer MySQL over Sqlite?

 

[Jay_UK]

Typical.... The only time I don't check the Wiki *doh*

Log level set to debug and I re-ran the import via the TVServer Config tool.

The use of MySQL was historical, as I already had it installed. I'm more than happy to switch to SQLLite.

J.

 

[Jay_UK]

Hi all,

SQLLite works fine and the import process runs ok.

Appears the issue is with the MySQL code/setup.

J.

 

[HTPCSourcer]

Set to "No Bug"

 

[Jay_UK]

Hi there,

But surely there is a bug with the MySQL code? (Or is that not supported with MP2 and TV3?)

J.

 

[HTPCSourcer]

But surely there is a bug with the MySQL code? (Or is that not supported with MP2 and TV3?)

Well, the MP2 package comes with SQLite, hence this is what is in focus.

What I don't know is the system's behavior if you already have a local SQL installation. Does the MP2 installer actively use this then?