You are not logged in.

#1 2015-10-29 06:46:59

hek
Member
Registered: 2013-12-01
Posts: 5

mariadb 10.1.8 and kodi 15.2

After upgrading to mariadb 10.1.8, I've ran into some issues using Kodi. I have Kodi setup to use mysql for it's database.

The Kodi database has a table called "tvshowcounts" with an interger called "totalCount" which specifies how many episodes of a specific show you have in your library. With 10.1.8, this value is duplicated-1. For example, if I have 50 episodes of a show, the "totalCount" value will be 99 (50*2-1). This happens to all shows, and only with 10.1.8.

I'm not sure if it's a bug with Kodi, or with mariadb, but downgrading to 10.0.21 has solved the problem for the time being.

Offline

#2 2015-10-29 09:34:14

graysky
Wiki Maintainer
From: :wq
Registered: 2008-12-01
Posts: 10,595
Website

Re: mariadb 10.1.8 and kodi 15.2

Probably want to post this upstream too.


CPU-optimized Linux-ck packages @ Repo-ck  • AUR packagesZsh and other configs

Offline

#3 2015-10-29 14:37:52

ewaller
Administrator
From: Pasadena, CA
Registered: 2009-07-13
Posts: 19,739

Re: mariadb 10.1.8 and kodi 15.2

Hek:  Congratulations on one of the most refreshing posts I have seen on "Testing" in a long time.   Well researched.  Well stated.  Exactly what this subforum is all about.

Thank You


Nothing is too wonderful to be true, if it be consistent with the laws of nature -- Michael Faraday
Sometimes it is the people no one can imagine anything of who do the things no one can imagine. -- Alan Turing
---
How to Ask Questions the Smart Way

Offline

#4 2015-10-30 12:33:47

graysky
Wiki Maintainer
From: :wq
Registered: 2008-12-01
Posts: 10,595
Website

Re: mariadb 10.1.8 and kodi 15.2

@OP - Did you update the database for the new version after you both upgraded the packages and restarted mysqld?  https://wiki.archlinux.org/index.php/My … de_MariaDB


CPU-optimized Linux-ck packages @ Repo-ck  • AUR packagesZsh and other configs

Offline

#5 2015-10-31 03:39:05

hek
Member
Registered: 2013-12-01
Posts: 5

Re: mariadb 10.1.8 and kodi 15.2

graysky wrote:

@OP - Did you update the database for the new version after you both upgraded the packages and restarted mysqld?  https://wiki.archlinux.org/index.php/My … de_MariaDB

I did not. However, I did drop all the databases, uninstalled mariadb, and deleted the /var/lib/mysql folder in order to perform a "clean install" of mariadb. The issue persisted.

Offline

#6 2015-12-05 10:54:27

ptk
Member
Registered: 2013-05-16
Posts: 3

Re: mariadb 10.1.8 and kodi 15.2

Hi,

do you have any news regarding this issue?
Has it been fixed?

Seems that I've the same problem when using the packages from the actual production repo.

kodi-rbp 15.2-1
mariadb 10.1.9-2
mariadb-clients 10.1.9-2

I already did the mysql_upgrade but the problem persists.

regards Phil

Offline

#7 2015-12-08 23:45:15

aronymous
Member
Registered: 2015-12-08
Posts: 1

Re: mariadb 10.1.8 and kodi 15.2

Downgrading mariadb to version 10.0.22-1 fixed the problem for me.

I believe its related to this bug

https://mariadb.atlassian.net/browse/MDEV-9181

Offline

Board footer

Powered by FluxBB