2011-03-24, 02:13
To start off, I have disabled all updates and can use my AppleTV for days on end without having any troubles.
When I navigate to a specific show through the video library, I am able to view all info about the episodes. The problem occurs when I either start to play an episode or try to go back to the main menu. XBMC hangs while the show stays on the screen. I am not able to perform any actions until I restart the AppleTV.
The problem doesn't occur on any other TV show. And remarkably, I can play episodes from the show in question without any problem if I don't start them in the video library, but navigate to the folder manually.
The situation has been the same for as long as I can remember.
When I look at the logs, it seems that the problem has something to do with the fact that I have an external database on my MySQL-server. The thing I can't get my head around is that there is no problem at all for other TV shows. Because the problem also occurs when I try to leave the screen, I am thinking maybe something is going wrong with some SQL-query about the series and that blocks any further SQL-queries? That would explain why I can navigate through the series fine, but when I try to play an episode or navigate back to another series (which both require another SQL-query) XBMC can't perform the new query and hangs.
I am not really basing that on any facts though
The XBMC log mentions:
(Similar errors keep repeating themselves for a while)
Anyone got any ideas?
When I navigate to a specific show through the video library, I am able to view all info about the episodes. The problem occurs when I either start to play an episode or try to go back to the main menu. XBMC hangs while the show stays on the screen. I am not able to perform any actions until I restart the AppleTV.
The problem doesn't occur on any other TV show. And remarkably, I can play episodes from the show in question without any problem if I don't start them in the video library, but navigate to the folder manually.
The situation has been the same for as long as I can remember.
When I look at the logs, it seems that the problem has something to do with the fact that I have an external database on my MySQL-server. The thing I can't get my head around is that there is no problem at all for other TV shows. Because the problem also occurs when I try to leave the screen, I am thinking maybe something is going wrong with some SQL-query about the series and that blocks any further SQL-queries? That would explain why I can navigate through the series fine, but when I try to play an episode or navigate back to another series (which both require another SQL-query) XBMC can't perform the new query and hangs.
I am not really basing that on any facts though
The XBMC log mentions:
Code:
18:04:24 T:186241024 M:116572160 ERROR: Read - Error( -1, 60, Operation timed out )
18:04:44 T:186241024 M:116711424 ERROR: Previous line repeats 2 times.
18:04:44 T:186241024 M:116711424 WARNING: could not find codec parameters for smb://****:****@192.168.0.105/Download/Series/****/****.S06.DivX/****.S06E15.S06E16.DVDrip.XviD-SAiNTS.avi
18:05:29 T:173928448 M:138096640 ERROR: Unable to open database: xbmc_video [2003](Can't connect to MySQL server on '192.168.0.105' (60))
18:05:29 T:173928448 M:138096640 ERROR: Unable to open database at host: 192.168.0.105 db: xbmc_video (old version?)
18:05:29 T:173928448 M:137961472 ERROR: SQL: The MySQL server has gone away
Query: select idPath from path where strPath like 'smb://****:****@192.168.0.105/Download/Series/****/****.S06.DivX/'
18:05:29 T:173928448 M:137953280 ERROR: GetPathId unable to getpath (select idPath from path where strPath like 'smb://****:****@192.168.0.105/Download/Series/****/****.S06.DivX/')
18:06:04 T:173928448 M:138063872 ERROR: SMBDirectory->GetDirectory: Unable to open directory : 'smb://****:****@192%2e168%2e0%2e105/Download/Series/****/****%2eS06%2eDivX'
unix_err:'3c' error : 'Operation timed out'
18:06:04 T:173928448 M:138063872 ERROR: GetDirectory - Error getting smb://****:****@192.168.0.105/Download/Series/****/****.S06.DivX/
18:06:08 T:148414464 M:138072064 ERROR: Unable to open database: xbmc_video [2003](Can't connect to MySQL server on '192.168.0.105' (60))
18:06:08 T:148414464 M:138072064 ERROR: Unable to open database at host: 192.168.0.105 db: xbmc_video (old version?)
18:07:19 T:173928448 M:114565120 ERROR: Unable to open database: xbmc_video [2003](Can't connect to MySQL server on '192.168.0.105' (60))
18:07:19 T:173928448 M:114565120 ERROR: Unable to open database at host: 192.168.0.105 db: xbmc_video (old version?)
18:07:19 T:173928448 M:114565120 ERROR: SQL: The MySQL server has gone away
(Similar errors keep repeating themselves for a while)
Anyone got any ideas?