2020-08-11, 00:14
Hey all, hoping someone might be able to help me pinpoint an error in my network here.
Lately I've noticed a video will stop playing randomly and boot me back to the files section in Kodi. I can always start the video back up but the database won't remember where I left off so it's almost as if the MySQL server just shuts down completely and restarts itself within a second, just long enough to halt playback. It's weird because it always seems to resolve itself without user correction but annoyingly stops any video I'm watching. Sometimes I can go days without it happening and when it does happen it's always random. Unsure how needed this info is but this only started happening when I installed Kodi on my Nvidia Shield and has never happened to me on a windows install.
At any rate, I captured a log a few weeks ago but nothing happened since then until last night so I figured I would post here to get some direction.
http://paste.kodi.tv/idoraqujej
It has happened on both Nvidia Sheild's so I can narrow it down to a server issue, specifically because around line 3780 is where it start's to get into the MySQL errors. Line 3838 states "ERROR: Unable to open database: MyVideos116 [2002](Can't connect to MySQL server on '192.168.2.66' (101))" so in theory I'm dealing with a database that isn't running however 5 seconds later it is up and running again. Then I see the following in the MySQL log found in /var/log/mysql/error.log
[Warning] Hostname 'osmc' does not resolve to '192.168.2.66'.
[Note] Hostname 'osmc' has the following IP addresses:
[Note] - ::1
[Note] - 127.0.1.1
I've looked at these errors and haven't really gotten a firm answer on the why or the how. It looks like it's a MySQL specific error also, not exactly Kodi related but since it's happening watching my library in Kodi this seems appropriate. Might be helpful to add IP listed above to the hosts file in my server system?
So if anyone can lend me a hand here so I can put a stop to this I would be quite grateful. I can update with any more needed info if I've missed anything important.
Lately I've noticed a video will stop playing randomly and boot me back to the files section in Kodi. I can always start the video back up but the database won't remember where I left off so it's almost as if the MySQL server just shuts down completely and restarts itself within a second, just long enough to halt playback. It's weird because it always seems to resolve itself without user correction but annoyingly stops any video I'm watching. Sometimes I can go days without it happening and when it does happen it's always random. Unsure how needed this info is but this only started happening when I installed Kodi on my Nvidia Shield and has never happened to me on a windows install.
At any rate, I captured a log a few weeks ago but nothing happened since then until last night so I figured I would post here to get some direction.
http://paste.kodi.tv/idoraqujej
It has happened on both Nvidia Sheild's so I can narrow it down to a server issue, specifically because around line 3780 is where it start's to get into the MySQL errors. Line 3838 states "ERROR: Unable to open database: MyVideos116 [2002](Can't connect to MySQL server on '192.168.2.66' (101))" so in theory I'm dealing with a database that isn't running however 5 seconds later it is up and running again. Then I see the following in the MySQL log found in /var/log/mysql/error.log
[Warning] Hostname 'osmc' does not resolve to '192.168.2.66'.
[Note] Hostname 'osmc' has the following IP addresses:
[Note] - ::1
[Note] - 127.0.1.1
I've looked at these errors and haven't really gotten a firm answer on the why or the how. It looks like it's a MySQL specific error also, not exactly Kodi related but since it's happening watching my library in Kodi this seems appropriate. Might be helpful to add IP listed above to the hosts file in my server system?
So if anyone can lend me a hand here so I can put a stop to this I would be quite grateful. I can update with any more needed info if I've missed anything important.