Arch Linux

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.

graysky

Wiki Maintainer

From: :wq

Registered: 2008-12-01

Posts: 10,650

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 packages • Zsh and other configs

ewaller

Administrator

From: Pasadena, CA

Registered: 2009-07-13

Posts: 20,260

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

graysky

Wiki Maintainer

From: :wq

Registered: 2008-12-01

Posts: 10,650

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 packages • Zsh and other configs

hek

Member

Registered: 2013-12-01

Posts: 5

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

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.

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

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