2012-11-10, 20:00
Hi,
I upgraded to alpha 7 with MySQL this morning, and now upon accessing Music Videos, XBMC crashes.
Going into recently added music videos is OK, its just the full listing of Music Videos, where XBMC tries to do some work creating thumbs, and updating them in the MySQL database, but loses the connection for some reason then crashes. Have tried it again about 20 times, so its easily reproducible.
Here’s the log:
or
or
etc
It seems to happen on random videos. Its definitely not a network issue. Alpha 6 is fine, as are all the other video types in alpha 7. Also tried upgrading to the latest MySQL 5.5.x with no joy.
Regards
I upgraded to alpha 7 with MySQL this morning, and now upon accessing Music Videos, XBMC crashes.
Going into recently added music videos is OK, its just the full listing of Music Videos, where XBMC tries to do some work creating thumbs, and updating them in the MySQL database, but loses the connection for some reason then crashes. Have tried it again about 20 times, so its easily reproducible.
Here’s the log:
Code:
13:01:26 T:2172 NOTICE: Thread Background Loader start, auto delete: false
13:01:26 T:896 DEBUG: CThumbExtractor::DoWork - trying to extract thumb from video file smb://xxx/Axxx.mpg
13:01:26 T:896 DEBUG: CDVDFileInfo::ExtractThumb - measured 375 ms to extract thumb from file <smb://xxx/Axxx.mpg> in 28 packets.
13:01:26 T:896 DEBUG: Mysql execute: UPDATE art SET url='special://masterprofile/Thumbnails/2/2997beb1.jpg' where art_id=475
13:01:26 T:2172 INFO: MYSQL server has gone. Will try 4 more attempt(s) to reconnect.
13:01:26 T:2172 ERROR: Unable to open database: xbmc_video72 [2003](Can't connect to MySQL server on '10.0.0.1' (10038))
13:01:26 T:2172 INFO: MYSQL server has gone. Will try 3 more attempt(s) to reconnect.
13:01:26 T:896 INFO: MYSQL server has gone. Will try 4 more attempt(s) to reconnect.
13:01:26 T:896 ERROR: Unable to open database: xbmc_video72 [1159](Protocol mismatch; server version = 0, client version = 10)
13:01:26 T:896 INFO: MYSQL server has gone. Will try 3 more attempt(s) to reconnect.
13:01:26 T:896 ERROR: Unable to open database: xbmc_video72 (0)
13:01:26 T:896 INFO: MYSQL server has gone. Will try 2 more attempt(s) to reconnect.
13:01:26 T:896 ERROR: Unable to open database: xbmc_video72 (0)
13:01:26 T:896 INFO: MYSQL server has gone. Will try 1 more attempt(s) to reconnect.
13:01:26 T:896 ERROR: Unable to open database: xbmc_video72 (0)
13:01:26 T:896 INFO: MYSQL server has gone. Will try 0 more attempt(s) to reconnect.
13:01:26 T:896 ERROR: Unable to open database: xbmc_video72 (0)
13:01:26 T:896 ERROR: SQL: The MySQL server has gone away
Query: UPDATE art SET url='special://masterprofile/Thumbnails/2/2997beb1.jpg' where art_id=475
13:01:26 T:896 ERROR: CVideoDatabase::SetArtForItem(1, 'musicvideo', 'thumb', 'special://masterprofile/Thumbnails/2/2997beb1.jpg') failed
13:01:26 T:896 ERROR: Unable to open database: xbmc_video72 (0)
13:01:26 T:896 DEBUG: CThumbExtractor::DoWork - trying to extract thumb from video file smb://xxx/Cxxx.mov
13:01:26 T:896 DEBUG: CDVDDemuxFFmpeg::Open - probing detected format [mov,mp4,m4a,3gp,3g2,mj2]
13:01:26 T:3016 DEBUG: Clearing cached fileitems [videodb://3/2/]
or
Code:
13:00:15 T:2844 DEBUG: cached image 'special://masterprofile/Thumbnails/d/d603384d.jpg' size 360x202
13:00:15 T:2844 DEBUG: CDVDFileInfo::ExtractThumb - measured 427 ms to extract thumb from file <smb://xxx/Hxxx.flv> in 1 packets.
13:00:15 T:2556 INFO: MYSQL server has gone. Will try 4 more attempt(s) to reconnect.
13:00:15 T:2556 ERROR: Unable to open database: xbmc_video72 [2003](Can't connect to MySQL server on '10.0.0.1' (10038))
13:00:15 T:2556 INFO: MYSQL server has gone. Will try 3 more attempt(s) to reconnect.
13:00:15 T:2844 INFO: MYSQL server has gone. Will try 4 more attempt(s) to reconnect.
13:00:15 T:2844 ERROR: Unable to open database: xbmc_video72 [1159](Protocol mismatch; server version = 0, client version = 10)
13:00:15 T:2844 INFO: MYSQL server has gone. Will try 3 more attempt(s) to reconnect.
13:00:15 T:2844 ERROR: Unable to open database: xbmc_video72 (0)
13:00:15 T:2844 INFO: MYSQL server has gone. Will try 2 more attempt(s) to reconnect.
or
Code:
12:55:58 T:2944 DEBUG: CDVDFileInfo::ExtractThumb - measured 241 ms to extract thumb from file <smb://xxx/Dxxx.mpg> in 43 packets.
12:55:58 T:1836 INFO: MYSQL server has gone. Will try 4 more attempt(s) to reconnect.
12:55:58 T:1836 INFO: Previous line repeats 1 times.
12:55:58 T:1836 ERROR: CBackgroundInfoLoader::Run::LoadItem - Unhandled exception for item videodb://3/2/1112
12:55:58 T:1836 INFO: MYSQL server has gone. Will try 4 more attempt(s) to reconnect.
12:55:58 T:1836 ERROR: Unable to open database: xbmc_video72 [2003](Can't connect to MySQL server on '10.0.0.1' (10038))
12:55:58 T:1836 INFO: MYSQL server has gone. Will try 3 more attempt(s) to reconnect.
12:55:58 T:2944 ERROR: Unable to open database: xbmc_video72 [0]()
12:55:58 T:2944 INFO: MYSQL server has gone. Will try 3 more attempt(s) to reconnect.
12:55:58 T:1836 ERROR: Unable to open database: xbmc_video72 [2047](Wrong or unknown protocol)
12:55:58 T:1836 INFO: MYSQL server has gone. Will try 2 more attempt(s) to reconnect.
12:55:58 T:2944 ERROR: Unable to open database: xbmc_video72 [1159](Protocol mismatch; server version = 0, client version = 10)
12:55:58 T:2944 INFO: MYSQL server has gone. Will try 2 more attempt(s) to reconnect.
12:55:58 T:2944 ERROR: Unable to open database: xbmc_video72 [2003](Can't connect to MySQL server on '10.0.0.1' (10038))
12:55:58 T:2944 INFO: MYSQL server has gone. Will try 1 more attempt(s) to reconnect.
12:55:58 T:1836 ERROR: Unable to set utf8 charset: xbmc_video72 [2013](Lost connection to MySQL server during query)
12:55:58 T:1836 ERROR: Not connected to database, test of existence is not possible.
12:55:58 T:1836 INFO: MYSQL server has gone. Will try 4 more attempt(s) to reconnect.
12:55:58 T:2944 ERROR: Unable to open database: xbmc_video72 [1159](Protocol mismatch; server version = 0, client version = 10)
12:55:58 T:2944 INFO: MYSQL server has gone. Will try 0 more attempt(s) to reconnect.
12:55:58 T:2944 ERROR: Unable to open database: xbmc_video72 [2003](Can't connect to MySQL server on '10.0.0.1' (10038))
12:55:58 T:2944 ERROR: SQL: The MySQL server has gone away
Query: SELECT art_id FROM art WHERE media_id=32 AND media_type='musicvideo' AND type='thumb'
12:55:58 T:2944 ERROR: CVideoDatabase::SetArtForItem(32, 'musicvideo', 'thumb', 'special://masterprofile/Thumbnails/0/0c1a83c3.jpg') failed
12:55:58 T:1836 ERROR: Unable to set utf8 charset: xbmc_video72 [2013](Lost connection to MySQL server during query)
12:55:58 T:1836 ERROR: Not connected to database, test of existence is not possible.
12:55:58 T:1836 INFO: MYSQL server has gone. Will try 4 more attempt(s) to reconnect.
12:55:58 T:1836 ERROR: SQL: Can't create new database: 'xbmc_video72' (1007)
12:55:58 T:1836 ERROR: Unable to open database: xbmc_video72 (0)
12:55:58 T:1836 ERROR: SQL: Can't create new database: 'xbmc_video72' (1007)
12:55:58 T:1836 ERROR: Unable to open database: xbmc_video72 (0)
etc
It seems to happen on random videos. Its definitely not a network issue. Alpha 6 is fine, as are all the other video types in alpha 7. Also tried upgrading to the latest MySQL 5.5.x with no joy.
Regards