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
General Support
MP1-4502 - ChannelState.DoSetChannelStates: An unknown error occured while setting channel states
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="Wiedmann" data-source="post: 1062949" data-attributes="member: 52725"><p><a href="http://www.dict.cc/englisch-deutsch/You%27re.html" target="_blank">You're</a> <a href="http://www.dict.cc/englisch-deutsch/not.html" target="_blank">not</a> <a href="http://www.dict.cc/englisch-deutsch/serious.html" target="_blank">serious,</a> <a href="http://www.dict.cc/englisch-deutsch/are.html" target="_blank">are</a> <a href="http://www.dict.cc/englisch-deutsch/you%3F.html" target="_blank">you?</a></p><p><a href="http://www.dict.cc/englisch-deutsch/you%3F.html" target="_blank"></a></p><p><a href="http://www.dict.cc/englisch-deutsch/you%3F.html" target="_blank">An exception isn't harmless in any way.</a> And if you read through the forum you can recognise: This (or similar) exceptions regarding database connections happens with or without a server crash.</p><p></p><p>And of course:</p><p></p><p>It's not a problem with the MySQL daemon or the network connection (in my case I use a local pipe). It's just something in TV service is dropping the connection (or destroying the connection object) even the connection is still in use by some other part.</p><p></p><p>Every time this happens, MySQL is also counting this as aborted client.</p><p></p><p><a href="https://forum.team-mediaportal.com/threads/channelstate-dosetchannelstates-an-unknown-error-occured-while-setting-channel-states.124083/page-2#post-1062898" target="_blank">This guy</a> is having this problem if he is using channel groups, but not without groups.</p><p></p><p>BTW database usage. Can you explain this:</p><p><span style="font-size: 12px"></span></p><p><span style="font-size: 12px">Connections from TV Service to MySQL:</span></p><p><span style="font-size: 12px"><span style="font-family: 'Courier New'"><span style="font-size: 12px">ø per second: 58</span></span></span></p><p><span style="font-size: 12px"><span style="font-family: 'Courier New'"><span style="font-size: 12px">ø per minute: 3454</span></span></span></p><p><span style="font-size: 12px"><span style="font-family: 'Courier New'">ø per hour : 207265</span></span></p><p></p><p>Statements:</p><p><span style="font-family: 'Courier New'">change db: 102900 / hour = 49.64 %</span></p><p><span style="font-family: 'Courier New'">select : 56600 / hour = 27,31 %</span></p><p><span style="font-family: 'Courier New'">update : 46100 / hour = 22,26 %</span></p><p><span style="font-family: 'Courier New'">other : 1665 / hour = 0,79 %</span></p><p></p><p><span style="font-family: 'Courier New'"><span style="font-family: 'Arial'">Half the time (29/second) TV Server is doing a "useless" command, because connection and setting default database is already done. And don't you think a lot of db usage for a single-seat system?</span></span></p><p>If you look at the other statistics, even a couple of indexes seem to be missing. Or some queries should be rewritten.</p></blockquote><p></p>
[QUOTE="Wiedmann, post: 1062949, member: 52725"] [URL='http://www.dict.cc/englisch-deutsch/You%27re.html']You're[/URL] [URL='http://www.dict.cc/englisch-deutsch/not.html']not[/URL] [URL='http://www.dict.cc/englisch-deutsch/serious.html']serious,[/URL] [URL='http://www.dict.cc/englisch-deutsch/are.html']are[/URL] [URL='http://www.dict.cc/englisch-deutsch/you%3F.html']you? An exception isn't harmless in any way.[/URL] And if you read through the forum you can recognise: This (or similar) exceptions regarding database connections happens with or without a server crash. And of course: It's not a problem with the MySQL daemon or the network connection (in my case I use a local pipe). It's just something in TV service is dropping the connection (or destroying the connection object) even the connection is still in use by some other part. Every time this happens, MySQL is also counting this as aborted client. [URL='https://forum.team-mediaportal.com/threads/channelstate-dosetchannelstates-an-unknown-error-occured-while-setting-channel-states.124083/page-2#post-1062898']This guy[/URL] is having this problem if he is using channel groups, but not without groups. BTW database usage. Can you explain this: [SIZE=3] Connections from TV Service to MySQL: [FONT=Courier New][SIZE=3]ø per second: 58 ø per minute: 3454[/SIZE] ø per hour : 207265[/FONT][/SIZE] Statements: [FONT=Courier New]change db: 102900 / hour = 49.64 % select : 56600 / hour = 27,31 % update : 46100 / hour = 22,26 % other : 1665 / hour = 0,79 %[/FONT] [FONT=Courier New][FONT=Arial]Half the time (29/second) TV Server is doing a "useless" command, because connection and setting default database is already done. And don't you think a lot of db usage for a[B] [/B]single-seat system?[/FONT][/FONT] If you look at the other statistics, even a couple of indexes seem to be missing. Or some queries should be rewritten. [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
Support
General Support
MP1-4502 - ChannelState.DoSetChannelStates: An unknown error occured while setting channel states
Contact us
RSS
Top
Bottom