MediaPortal startup time (1 Viewer)

[DragonQ]

Hi,

I have see this long startup too (but maybe not related here) about TVServer on server and MP on client (so related to connexion to TVServer).
My Server was rnning on SQL Server and it was related to firewall because MSSQL use random port in setting to connect, when i have fixed that connection port in MSSQL, the startup was really better .

How is this done?

 

[Sebastiii]

@DragonQ That a qood question i mean i have fix that a long time ago, i assume i can find it again
We need to start :
SQL Server Configuration Manager -> Network config (SQL) -> Protocol SQLEXPRESS -> TCP/IP and in IP address on bottom
We need to remove "0" from TCP Dynamics Ports.

There is a french page about it :
http://www.sqlfr.com/tutoriaux/CONNEXION-DISTANTE-SQL-SERVER-2005_644.aspx
Look for : 'Instances nommées avec port fixe' section there is some screenshot

 

[DragonQ]

Hmm, I use MySQL (I think I read it was preferred on the Wiki or something) and I can't see any way of changing its settings.

 

[Sebastiii]

Yep like i said it happen only for MSSQL

 

[Vasilich]

as i tuned start performance of my HTPC, i faced problem that MySQL will be started while main boot phase and thus caused delay of loading other services.
Moreover, TVServer started also at the same time, though MySQL wasn't ready yet.
What helped is to set start type of both tvserver and MySQL to delayed autostart, and set MySQL as "dependent on" for TVService.
It takes still long time for TVService to start, but remember - TVService is managed code, so all .NET runtimes must be loaded first.

 

[Terra]

Ok, so I have installed the 1.3RC version, however the delay is still there. The line after the delay is related to the TV-Server. You see that nothing is in the logs for 21 seconds.

I have a dedicated TV-Server using MySQL which is always on and connected.
Sidenote: I have all my sqllite databases remotely on the same server as the TV-Server, both TV-Server and the databases are located on a SSD.

Can I enable a verbose log level somewhere? There is no record for those 21 seconds in any logs (error.log, MediaPortal.log, MusicshareWatcher.log)

---------
2013-02-06 19:55:08.405554 [Info.][MPMain(1)]: get all groups from database
2013-02-06 19:55:08.745573 [Info.][MPMain(1)]: loaded 5 tv groups
2013-02-06 19:55:08.752573 [Info.][MPMain(1)]: ChannelNavigator::LoadSettings()
2013-02-06 19:55:08.772575 [Debug][MPMain(1)]: TVHome.LoadSettings(): Preferred Audio Languages: deu;ger;eng;
2013-02-06 19:55:08.775575 [Info.][MPMain(1)]: Prefered language 1 is deu
2013-02-06 19:55:08.775575 [Info.][MPMain(1)]: Prefered language 2 is ger
2013-02-06 19:55:08.776575 [Info.][MPMain(1)]: Prefered language 3 is eng
2013-02-06 19:55:29.786777 [Info.][MPMain(1)]: TvPlugin and TvServer don't have the same version.
TvServer Version: 1.2.200.0
TvPlugin Version: 1.2.300.0
2013-02-06 19:55:29.787777 [Info.][MPMain(1)]: TvNotify: start
2013-02-06 19:55:29.801777 [Info.][MPMain(1)]: newsearch ctor
2013-02-06 19:55:29.802777 [Info.][MPMain(1)]: newsearch init
2013-02-06 19:55:29.802777 [Info.][MPMain(1)]: newsearch init result:True
---------

 

[Vasilich]

that could be a result of that you have updated tvclient, but not server. as log says,

TvPlugin and TvServer don't have the same version.

and this isn't normal situation, so not really valuable test.

 

[Terra]

It seems to be related to the network, if I disconnect my HTPC it starts fast :/

that could be a result of that you have updated tvclient, but not server. as log says,

TvPlugin and TvServer don't have the same version.

and this isn't normal situation, so not really valuable test.

Just also updated the TV-Server. Same result. 20 seconds of nothing in the logs.
However I think it is related to the TV-Server. If I disconnect the HTPC from the network it starts pretty fast.

----------
2013-02-07 00:26:13.196270 [Debug][MPMain(1)]: TVHome.LoadSettings(): Preferred Audio Languages: deu;ger;eng;
2013-02-07 00:26:13.198270 [Info.][MPMain(1)]: Prefered language 1 is deu
2013-02-07 00:26:13.198270 [Info.][MPMain(1)]: Prefered language 2 is ger
2013-02-07 00:26:13.198270 [Info.][MPMain(1)]: Prefered language 3 is eng
2013-02-07 00:26:14.024317 [Info.][FilterChecker(5)]: FilterChecker: Found quartz.dll from 19.12.2009 located at C:\Windows\SysWOW64\quartz.dll
2013-02-07 00:26:14.027317 [Info.][FilterChecker(5)]: FilterChecker: Version of installed quartz.dll: 6.6.7600.16385
2013-02-07 00:26:34.205472 [Info.][MPMain(1)]: TVHome V1.2.300.0:ctor
2013-02-07 00:26:34.206472 [Info.][MPMain(1)]: TvNotify: start
2013-02-07 00:26:34.219472 [Info.][MPMain(1)]: newsearch ctor
2013-02-07 00:26:34.220472 [Info.][MPMain(1)]: newsearch init
----------


With unplugged network cable there is no delay:

----------
2013-02-07 00:32:18.149444 [Info.][MPMain(1)]: Prefered language 1 is deu
2013-02-07 00:32:18.149444 [Info.][MPMain(1)]: Prefered language 2 is ger
2013-02-07 00:32:18.150444 [Info.][MPMain(1)]: Prefered language 3 is eng
2013-02-07 00:32:18.173445 [Info.][MPMain(1)]: TVHome: Error occured in Init(): No such host is known, st at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
at System.Environment.get_StackTrace()
at TvPlugin.TVHome.OnAdded()
at MediaPortal.GUI.Library.GUIWindowManager.Add(GUIWindow& Window)
at MediaPortal.GUI.Library.PluginManager.LoadWindowPlugin(String strFile)
at MediaPortal.GUI.Library.PluginManager.LoadWindowPlugins()
at MediaPortalApp.InitializeDeviceObjects()
at MediaPortal.D3DApp.InitializeEnvironment()
at MediaPortal.D3DApp.CreateGraphicsSample()
at MediaPortalApp.Main(String[] args)
2013-02-07 00:32:18.174445 [Info.][MPMain(1)]: TvNotify: start
2013-02-07 00:32:18.189446 [Info.][MPMain(1)]: newsearch ctor
2013-02-07 00:32:18.189446 [Info.][MPMain(1)]: newsearch init
----------

btw. When I unplug the network cable I also get an exception in the log that the MySQL database could not be found and the password is written in plain text in the log.

 

[Vasilich]

can it be that host name resolution in your network takes so long?
there is my log

2013-02-04 07:55:37.598876 [Debug][MPMain(1)]: TVHome.LoadSettings(): Preferred Audio Languages:
2013-02-04 07:55:37.606876 [Debug][MPMain(1)]: Common.IsSingleSeat: HostName = W7 / Environment.MachineName = W7
2013-02-04 07:55:38.616934 [Info.][MPMain(1)]: TVHome V1.2.300.0:ctor

so that part took 1 second

 

[x4mer]

I had long startup times on the clients too. In the TV plugin settings on the client, changed it to use the TVserver IP instead of hostname, and now startups are fast. Odd, since I can ping machines on my network by hostname, with immediate response.