home
products
contribute
download
documentation
forum
Home
Forums
New posts
Search forums
What's new
New posts
All posts
Latest activity
Members
Registered members
Current visitors
Donate
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Search titles only
By:
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
MediaPortal 1
Support
Watch / Listen Media
Television (MyTV frontend and TV-Server)
TV Freezes Database login failures??
Contact us
RSS
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="burthold" data-source="post: 344293" data-attributes="member: 85657"><p><strong>TV-Server Version</strong>: 1.0.0.0 RC4</p><p><strong>MediaPortal Version</strong>: 1.0.0.0 RC4</p><p><strong>MediaPortal Skin</strong>: Blue3 Wide</p><p><strong>Windows Version</strong>: Vista Business SP1</p><p><strong>CPU Type</strong>: AMD x64 4600+</p><p><strong>HDD</strong>: Maxtor 500GB x 2</p><p><strong>Memory</strong>: 2GB 512x4 DDR</p><p><strong>Motherboard</strong>: </p><p><strong>Video Card</strong>: Nvidia 9500GT</p><p><strong>Video Card Driver</strong>: 180.48</p><p><strong>Sound Card</strong>: on board</p><p><strong>Sound Card AC3</strong>: none</p><p><strong>Sound Card Driver</strong>: </p><p><strong>1. TV Card</strong>: ATI Theatere 550</p><p><strong>1. TV Card Type</strong>: analog,ATSC</p><p><strong>1. TV Card Driver</strong>: latest</p><p><strong>2. TV Card</strong>: ATI Theatere 650</p><p><strong>2. TV Card Type</strong>: analog,ATSC</p><p><strong>2. TV Card Driver</strong>: latest</p><p><strong>3. TV Card</strong>: Hauppage 1800</p><p><strong>3. TV Card Type</strong>: analog, ATSC</p><p><strong>3. TV Card Driver</strong>: </p><p><strong>4. TV Card</strong>: </p><p><strong>4. TV Card Type</strong>: </p><p><strong>4. TV Card Driver</strong>: </p><p><strong>MPEG2 Video Codec</strong>: Arcserve</p><p><strong>MPEG2 Audio Codec</strong>: Arcserve</p><p><strong>h.264 Video Codec</strong>: Arcserve</p><p><strong>Satelite/CableTV Provider</strong>: </p><p><strong>HTPC Case</strong>: </p><p><strong>Cooling</strong>: </p><p><strong>Power Supply</strong>: 380W Antec</p><p><strong>Remote</strong>: Gyration MCE Remote</p><p><strong>TV</strong>: Panasonic TH-42PZ85U</p><p><strong>TV - HTPC Connection</strong>: DVI to HDMI</p><p></p><p>I have seen alot of threads around database login errors for the tv service and TV problems.</p><p></p><p>I've done some reading and I happen to be a SQL Server DBA so I've got some experience there.</p><p></p><p>What I noticed was when I start the My TV plugin I don't get more than a few hours of guide data.</p><p></p><p>TV runs for a few minutes as little as 5 and as much as 30 before it freezes up completely.</p><p></p><p>The error log from the TV service is filled with complaints about not being able to login as sa/MediaPortal.</p><p></p><p>I confirmed that you can login using sa.</p><p></p><p>I checked the database settings and found that the mediaportal database was set to autoclose. I turned that off.</p><p></p><p>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.</p><p></p><p>As a work around I've got a little tool that runs a query against the express instance to keep it alive.</p><p></p><p>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.</p><p></p><p>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.</p><p></p><p>I would put in a try on error 17187 server is not ready to accept connections. It may deal with this problem all together.</p><p></p><p>cheers,</p><p>Wes</p><p></p><p>Any thoughts?</p></blockquote><p></p>
[QUOTE="burthold, post: 344293, member: 85657"] [b]TV-Server Version[/b]: 1.0.0.0 RC4 [b]MediaPortal Version[/b]: 1.0.0.0 RC4 [b]MediaPortal Skin[/b]: Blue3 Wide [b]Windows Version[/b]: Vista Business SP1 [b]CPU Type[/b]: AMD x64 4600+ [b]HDD[/b]: Maxtor 500GB x 2 [b]Memory[/b]: 2GB 512x4 DDR [b]Motherboard[/b]: [b]Video Card[/b]: Nvidia 9500GT [b]Video Card Driver[/b]: 180.48 [b]Sound Card[/b]: on board [b]Sound Card AC3[/b]: none [b]Sound Card Driver[/b]: [b]1. TV Card[/b]: ATI Theatere 550 [b]1. TV Card Type[/b]: analog,ATSC [b]1. TV Card Driver[/b]: latest [b]2. TV Card[/b]: ATI Theatere 650 [b]2. TV Card Type[/b]: analog,ATSC [b]2. TV Card Driver[/b]: latest [b]3. TV Card[/b]: Hauppage 1800 [b]3. TV Card Type[/b]: analog, ATSC [b]3. TV Card Driver[/b]: [b]4. TV Card[/b]: [b]4. TV Card Type[/b]: [b]4. TV Card Driver[/b]: [b]MPEG2 Video Codec[/b]: Arcserve [b]MPEG2 Audio Codec[/b]: Arcserve [b]h.264 Video Codec[/b]: Arcserve [b]Satelite/CableTV Provider[/b]: [b]HTPC Case[/b]: [b]Cooling[/b]: [b]Power Supply[/b]: 380W Antec [b]Remote[/b]: Gyration MCE Remote [b]TV[/b]: Panasonic TH-42PZ85U [b]TV - HTPC Connection[/b]: 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? [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
Support
Watch / Listen Media
Television (MyTV frontend and TV-Server)
TV Freezes Database login failures??
Contact us
RSS
Top
Bottom
