Reply to thread

Message

<blockquote data-quote="mm1352000" data-source="post: 922640" data-attributes="member: 82144">Hi guys&nbsp;Indeed, initially it does look like a DB access issue, but I'm wondering if that is just the DB &quot;warming up&quot;.&nbsp;@<a href="https://forum.team-mediaportal.com/members/gonzo90017.129471/" target="_blank">gonzo90017</a>When you installed MP, did you install your own database, use an existing one, or let MP install one for you?&nbsp;I'm finding it difficult to be sure about my interpretation of what I see later on the logs...&nbsp;I see the server start at about 5 past 8 as Jay_UK said. Shortly after that, a couple of scheduled recordings start.Everything seems fine until 0812.It looks like what happens is that is when MP [on the server] attempts to connect to the server for the first time.The connection is not good - &quot;ping&quot; is up around 1 second.The issues continue until around 0817 when it looks like the connection drops entirely. That may or may not be when the server went down.The log goes silent between 0817 and 0828 when we see a client trying to connect again. At this point I think the server is still down.I note some interesting things in the system application log at about this time:[collapse]&quot;10/11/2012 8:28:18 AM&quot;;&quot;MSSQL$SQLEXPRESS&quot;;&quot;Server&quot;;&quot;Information&quot;;&quot;Starting up database 'MpTvDb'.&quot;;&quot;1073758961&quot; &quot;10/11/2012 8:29:19 AM&quot;;&quot;MSSQL$SQLEXPRESS&quot;;&quot;Server&quot;;&quot;Information&quot;;&quot;SQL Server has encountered 2 occurrence(s) of cachestore flush for the 'Object Plans' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.&quot;;&quot;1073744627&quot; &quot;10/11/2012 8:29:19 AM&quot;;&quot;MSSQL$SQLEXPRESS&quot;;&quot;Server&quot;;&quot;Information&quot;;&quot;SQL Server has encountered 2 occurrence(s) of cachestore flush for the 'SQL Plans' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.&quot;;&quot;1073744627&quot; &quot;10/11/2012 8:29:19 AM&quot;;&quot;MSSQL$SQLEXPRESS&quot;;&quot;Server&quot;;&quot;Information&quot;;&quot;SQL Server has encountered 2 occurrence(s) of cachestore flush for the 'Bound Trees' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.&quot;;&quot;1073744627&quot;[/collapse]&nbsp;Not sure exactly what that means...&nbsp;Alright, so what is the verdict (?).I'm not certain but I suspect possibly a concoction of network issues.&nbsp;I have two questions:1. Have you configured your server with a static IP address?2. Does your server have multiple network ports/adapters?&nbsp;mm</blockquote>

[QUOTE="mm1352000, post: 922640, member: 82144"] Hi guys Indeed, initially it does look like a DB access issue, but I'm wondering if that is just the DB "warming up". @[URL='https://forum.team-mediaportal.com/members/gonzo90017.129471/']gonzo90017[/URL] When you installed MP, did you install your own database, use an existing one, or let MP install one for you? I'm finding it difficult to be sure about my interpretation of what I see later on the logs... I see the server start at about 5 past 8 as Jay_UK said. Shortly after that, a couple of scheduled recordings start. Everything seems fine until 0812. It looks like what happens is that is when MP [on the server] attempts to connect to the server for the first time. The connection is not good - "ping" is up around 1 second. The issues continue until around 0817 when it looks like the connection drops entirely. That may or may not be when the server went down. The log goes silent between 0817 and 0828 when we see a client trying to connect again. At this point I think the server is still down. I note some interesting things in the system application log at about this time: [collapse]"10/11/2012 8:28:18 AM";"MSSQL$SQLEXPRESS";"Server";"Information";"Starting up database 'MpTvDb'.";"1073758961" "10/11/2012 8:29:19 AM";"MSSQL$SQLEXPRESS";"Server";"Information";"SQL Server has encountered 2 occurrence(s) of cachestore flush for the 'Object Plans' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.";"1073744627" "10/11/2012 8:29:19 AM";"MSSQL$SQLEXPRESS";"Server";"Information";"SQL Server has encountered 2 occurrence(s) of cachestore flush for the 'SQL Plans' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.";"1073744627" "10/11/2012 8:29:19 AM";"MSSQL$SQLEXPRESS";"Server";"Information";"SQL Server has encountered 2 occurrence(s) of cachestore flush for the 'Bound Trees' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.";"1073744627"[/collapse] Not sure exactly what that means... Alright, so what is the verdict (?). I'm not certain but I suspect possibly a concoction of network issues. I have two questions: 1. Have you configured your server with a static IP address? 2. Does your server have multiple network ports/adapters? mm [/QUOTE]

Verification