Its takes ages to start tvservice after pc restart (1 Viewer)

[joostzilla]

MediaPortal Version: 1.1.0 rc4
MediaPortal Skin: Maya
Windows Version: XP PRO MCE sp3
CPU Type: 3.0 ghz
HDD: samsung total 3,3 TB
Memory: 2560 ddr3
Motherboard:
Video Card: Geforce 7600GT 256
Video Card Driver: 186.18
Sound Card: Soundblaster live 5.1
Sound Card AC3: Spdif
Sound Card Driver:
1. TV Card: FireTV FloppyDVT
1. TV Card Type: DVB-c
1. TV Card Driver: 5.7
2. TV Card:
2. TV Card Type:
2. TV Card Driver:
3. TV Card:
3. TV Card Type:
3. TV Card Driver:
4. TV Card:
4. TV Card Type:
4. TV Card Driver:
MPEG2 Video Codec: Powerdvd 10
MPEG2 Audio Codec: Powerdvd 10
h.264 Video Codec: Powerdvd 10
Satelite/CableTV Provider: Ziggo
HTPC Case: Coolermaster centurion 5
Cooling:
Power Supply: IBL 450 watt
Remote: Logitech Harmony One
TV: Samsung LE32N71
TV - HTPC Connection: D-sub

Since a couple of days it takes ages for the tv service to start. But only after pc restart. When coming out of S3 its always a surprise if the tv service starts and/or crashes the system.
I had no problems in 1.0.2.

 

[joostzilla]

No one?

 

[te3hpurp]

Hi.

It takes about 6 seconds.

2010-06-07 13:29:44.328125 [TVService(5)]: TVService v1.0.8.0 is starting up on Windows XP ( Service Pack 3 ) [5.1.2600.196608]
2010-06-07 13:29:50.593750 [TVService(5)]: TV service: Started


Br,

 

[joostzilla]

Hi.

It takes about 6 seconds.

2010-06-07 13:29:44.328125 [TVService(5)]: TVService v1.0.8.0 is starting up on Windows XP ( Service Pack 3 ) [5.1.2600.196608]
2010-06-07 13:29:50.593750 [TVService(5)]: TV service: Started


Br,

Okay. But why does the start up of MP take so long. On the splashscreen it says 'waiting for tvservice to start' for about a minute.

 

[te3hpurp]

Hi. I try to analyze the logs and I have no other explanation, than that In start up phase of computer there are
lot of services starting up, which delays the start up process. TvService depends for example Sql server service and
if it is not started, then TvService has to wait for Sql service to start.

From Mediaportal log we that request to start happens here
2010-06-07 13:45:02.359375 [Info.][MPMain(1)]: Main: TV service is stopped, so we try start it...

request arrives to server here: So its almost 90 seconds lated when server even tries to start
2010-06-07 13:46:49.093750 [(5)]: TV service: Starting

There is also some errors in Sql server start up in system event log:

7.6.2010 13:46 Service Control Manager 0 Error De MySQL-service is bij het starten vastgelopen.
7.6.2010 13:46 Service Control Manager 0 Error De TVService-service is afhankelijk van de MySQL-service, die vanwege de volgende fout niet kan worden gestart: %Na het starten is de service blijven hangen.


Allthough I do not understand the language.

So In your shoes, I'd check with service manager to stop and start Mysql service and see how long it takes and use some MySql tools to check database so that it's okay.

Br,

 

[joostzilla]

Hi. I try to analyze the logs and I have no other explanation, than that In start up phase of computer there are
lot of services starting up, which delays the start up process. TvService depends for example Sql server service and
if it is not started, then TvService has to wait for Sql service to start.

From Mediaportal log we that request to start happens here
2010-06-07 13:45:02.359375 [Info.][MPMain(1)]: Main: TV service is stopped, so we try start it...

request arrives to server here: So its almost 90 seconds lated when server even tries to start
2010-06-07 13:46:49.093750 [(5)]: TV service: Starting

There is also some errors in Sql server start up in system event log:

7.6.2010 13:46 Service Control Manager 0 Error De MySQL-service is bij het starten vastgelopen.
7.6.2010 13:46 Service Control Manager 0 Error De TVService-service is afhankelijk van de MySQL-service, die vanwege de volgende fout niet kan worden gestart: %Na het starten is de service blijven hangen.


Allthough I do not understand the language.

So In your shoes, I'd check with service manager to stop and start Mysql service and see how long it takes and use some MySql tools to check database so that it's okay.

Br,

Thanks for analyzing. Here is the translation:

7.6.2010 13:46 Service Control Manager 0 Error The MySQL-service hangs during startups
7.6.2010 13:46 Service Control Manager 0 Error The TVService-service is depending on MySQL-service, which due to the following error cant start: %After starting the service hangs

Before I upgraded to rc3 i always had to log in to windows sql server with ra - mediaportal
since rc3 the system logs in to MySql with root-mediaportal. I guess this has nothing to to with this but i have no idea this happened.

I will try some tools and check back later.

 

[jameson_uk]

could you just check your database
Open up a command prompt (as admin if Vista / Win7)
navigate to MySQL Bin folder (is C:\\Program Files\\MySQL\\MySQL Server 5.1\\bin for me) and enter

mysqlcheck --user=root --pass=MediaPortal --auto-repair MPTVDB

 

[joostzilla]

could you just check your database
Open up a command prompt (as admin if Vista / Win7)
navigate to MySQL Bin folder (is C:\\Program Files\\MySQL\\MySQL Server 5.1\\bin for me) and enter

mysqlcheck --user=root --pass=MediaPortal --auto-repair MPTVDB

I did what you suggested.

Did a restart and again had to wait a really long time on starting the tv service

edit: after a restart MySQL doesnt start. (under services it says: starting) When i cancel that and restart MySQL is start immediately.

 

[doornjoostje]

Run it in a dos box.

 

[joostzilla]

could you just check your database
Open up a command prompt (as admin if Vista / Win7)
navigate to MySQL Bin folder (is C:\\Program Files\\MySQL\\MySQL Server 5.1\\bin for me) and enter

mysqlcheck --user=root --pass=MediaPortal --auto-repair MPTVDB

Reinstalled MySQL. Connect with ip number. But nothing changed.
In short: firsttime connection to MySQL is f****d up.