Bug#932916: gerbera mysql interface buggy: duplicate entry bug for primary key in database

[Thomas Korimort]

Package: gerbera

Version: 1.1.0

Severity: critical

Hi! I have tried to use gerbera 1.1.0 on my new Raspberry Pi 4 4GB as
slimlined media server. Since i have already used Mariadb before, i
configured gerbera for Mysql and as a systemd service. I got that
working, but when gerbera started to fill the database with my media
library, after a small while the web interface for gerbera reported a
database error: Duplicate entry 62001 in primary key. To me it seems
that the primary key field is of size short int and after some 62000
data records it had an overflow. I did not feel like digging too deep
into the problem, thus i changed to rygel media server, which uses
sqlite only.