Community Packages

Please read this before reporting a bug:
https://wiki.archlinux.org/title/Bug_reporting_guidelines

Do NOT report bugs when a package is just outdated, or it is in the AUR. Use the 'flag out of date' link on the package page, or the Mailing List.

REPEAT: Do NOT report bugs for outdated packages!
Tasklist

FS#45768 - [mariadb] kodi 15.0-1 crashes mariadb 10.0.20-1

Attached to Project: Community Packages
Opened by H. Cristiano Alves Machado (mccurly) - Saturday, 25 July 2015, 11:58 GMT
Last edited by Ike Devolder (BlackEagle) - Saturday, 26 December 2015, 05:56 GMT
Task Type Bug Report
Category Packages
Status Closed
Assigned To Ike Devolder (BlackEagle)
Bartłomiej Piotrowski (Barthalion)
Architecture All
Severity High
Priority Normal
Reported Version
Due in Version Undecided
Due Date Undecided
Percent Complete 100%
Votes 0
Private No

Details

Description:If using kodi with mysql, it simply breaks the new databases versions of MyMusic52 (reproducible always). Haven't tested with other db's (eg. MyVideos93)


Additional info:
* package version(s) -> community kodi (15.0.1) (happened also with the previous devel-15 version from aur) together with mariadb 10.0.20-1 from extra repo.
* config and/or log files etc.;

in my opinion the most relevant excerpt from kodi version 15 log are these lines:

09:49:24 T:140190814427136 ERROR: Initialise - failed to initialise bus cec
09:49:25 T:140190814427136 ERROR: Unable to open database: MyMusic52 [1049](Unknown database 'MyMusic52')
09:49:25 T:140190814427136 ERROR: Unable to open database: MyMusic51 [1049](Unknown database 'MyMusic51')
09:49:25 T:140190814427136 ERROR: Unable to open database: MyMusic50 [1049](Unknown database 'MyMusic50')
09:49:25 T:140190814427136 ERROR: Unable to open database: MyMusic49 [1049](Unknown database 'MyMusic49')
09:49:46 T:140190814427136 ERROR: Unable to open database: MyVideos93 [1049](Unknown database 'MyVideos93')
09:49:46 T:140190814427136 ERROR: Unable to open database: MyVideos92 [1049](Unknown database 'MyVideos92')
09:49:46 T:140190814427136 ERROR: Unable to open database: MyVideos91 [1049](Unknown database 'MyVideos91')
09:52:28 T:140190814427136 ERROR: Unable to open database: MyMusic52 [2002](Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (111))
09:52:28 T:140190814427136 ERROR: Previous line repeats 4 times.
09:52:28 T:140190814427136 ERROR: SQL: The MySQL server has gone away
09:52:28 T:140190814427136 ERROR: GetAlbum(1) failed




Steps to reproduce: bare Install/upgrade (happens on both) and search for string on library mode and then play the search result will hang kodi and not make him play the first items (if playing at all)


This task depends upon

Closed by  Ike Devolder (BlackEagle)
Saturday, 26 December 2015, 05:56 GMT
Reason for closing:  Fixed
Additional comments about closing:  This should be fixed upstream since kodi 15.2
Comment by Ike Devolder (BlackEagle) - Sunday, 26 July 2015, 07:15 GMT
Could you add mysql error logs ? or some additional logging from mysql that could indicate why it crashes ?
Comment by H. Cristiano Alves Machado (mccurly) - Sunday, 26 July 2015, 14:55 GMT
Here is the link pointing to those logs ---> http://sprunge.us/BBUi

I must say, I am currently using mysql from oracle, not from mariadb. With that version I am not having those issues.

Also it seems that this maybe a problem with mariadb ---> https://mariadb.atlassian.net/browse/MDEV-8525

I have also tried that 'front' as you may see for yourself, as well as kodi's own forum/channel ---> http://forum.kodi.tv/showthread.php?tid=232834&pid=2062607#pid2062607

For now, with oracle's mysql the problems seem to be delved...

Finally I must apologize for not being able to sustain with more detailed information.

Yours.

Loading...