Bug Alpha7 crash when accessing music videos
#1
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:

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
Reply
#2
don't post in development and always post the full Debug Log on pastebin.com and never on the forum
Read/follow the forum rules.
For troubleshooting and bug reporting, read this first
Interested in seeing some YouTube videos about Kodi? Go here and subscribe
Reply
#3
Apologies, the other bug I posted in development, but I knew where the issue was in code.

Anyway, log is up at http://pastebin.com/daeWVcM6

Forgot to mention, there was no crash dump created either.

Regards
Reply
#4
I believe this issue has already been fixed in master - the problem was re-use of a database connection from separate threads:

https://github.com/xbmc/xbmc/commit/a5de...c9c978b248

Cheers,
Jonathan
Always read the XBMC online-manual, FAQ and search the forum before posting.
Do not e-mail XBMC-Team members directly asking for support. Read/follow the forum rules.
For troubleshooting and bug reporting please make sure you read this first.


Image
Reply

Logout Mark Read Team Forum Stats Members Help
Alpha7 crash when accessing music videos0