TV Freezes Database login failures?? (1 Viewer)

[burthold]

TV-Server Version: 1.0.0.0 RC4
MediaPortal Version: 1.0.0.0 RC4
MediaPortal Skin: Blue3 Wide
Windows Version: Vista Business SP1
CPU Type: AMD x64 4600+
HDD: Maxtor 500GB x 2
Memory: 2GB 512x4 DDR
Motherboard:
Video Card: Nvidia 9500GT
Video Card Driver: 180.48
Sound Card: on board
Sound Card AC3: none
Sound Card Driver:
1. TV Card: ATI Theatere 550
1. TV Card Type: analog,ATSC
1. TV Card Driver: latest
2. TV Card: ATI Theatere 650
2. TV Card Type: analog,ATSC
2. TV Card Driver: latest
3. TV Card: Hauppage 1800
3. TV Card Type: analog, ATSC
3. TV Card Driver:
4. TV Card:
4. TV Card Type:
4. TV Card Driver:
MPEG2 Video Codec: Arcserve
MPEG2 Audio Codec: Arcserve
h.264 Video Codec: Arcserve
Satelite/CableTV Provider:
HTPC Case:
Cooling:
Power Supply: 380W Antec
Remote: Gyration MCE Remote
TV: Panasonic TH-42PZ85U
TV - HTPC Connection: DVI to HDMI

I have seen alot of threads around database login errors for the tv service and TV problems.

I've done some reading and I happen to be a SQL Server DBA so I've got some experience there.

What I noticed was when I start the My TV plugin I don't get more than a few hours of guide data.

TV runs for a few minutes as little as 5 and as much as 30 before it freezes up completely.

The error log from the TV service is filled with complaints about not being able to login as sa/MediaPortal.

I confirmed that you can login using sa.

I checked the database settings and found that the mediaportal database was set to autoclose. I turned that off.

Secondly, I saw in the log where sqlexpress was "waking up" after inactivity. I looks like it closes all connections and closes the databases as well to save system resources.

As a work around I've got a little tool that runs a query against the express instance to keep it alive.

Also, this problem doesn't seem to happen on my other server that has a dedicated back end with a full copy of SQL Server installed on it.

I don't have any experience with the Gentle ORM layer to know if that is having any real effect on the timeouts ether. I doubt it the connection string looks clean.

I would put in a try on error 17187 server is not ready to accept connections. It may deal with this problem all together.

cheers,
Wes

Any thoughts?

 

[burthold]

Also, the computer completely freezes up and requires a hard reboot.

The only thing in the logs is reboot at xx was unexpected.

 

[magaplask]

I have the same problem. But my computer do not freezes up and requires a hard reboot.
I can manually start and stop service in tvserver config under manual control. And it works again until the problem appers.

 

[burthold]

I updated all the drivers and now it locks up two or three times a day. I'm moving back to snapstream until the 1.0 is released.