Bug 2388218 - gerbera 2.6.0-1 fails to start with MariaDB enabled
Summary: gerbera 2.6.0-1 fails to start with MariaDB enabled
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Fedora
Classification: Fedora
Component: gerbera
Version: 42
Hardware: x86_64
OS: Linux
unspecified
urgent
Target Milestone: ---
Assignee: Gwyn Ciesla
QA Contact: Fedora Extras Quality Assurance
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2025-08-13 12:18 UTC by Matthias
Modified: 2025-08-27 01:24 UTC (History)
1 user (show)

Fixed In Version: gerbera-2.6.0-3.fc41 gerbera-2.6.1-1.fc42
Clone Of:
Environment:
Last Closed: 2025-08-16 01:05:50 UTC
Type: ---
Embargoed:


Attachments (Terms of Use)

Description Matthias 2025-08-13 12:18:42 UTC
Gerbera 2.5.0-1 works as expected with MariaDB (MariaDB 3:10.11.11-6 from Updates repo). I use these setting in the config.xml:

<mysql enabled="yes">
  <host>localhost</host>
  <port>0</port>
  <username>gerbera_user</username>
  <password>password</password>
  <database>gerbera_db</database>
</mysql>

Once upgraded to 2.6.0-1 Gerbera will not start anymore.

I find these messages in the journal:

info: Gerbera UPnP Server 2.6.0 - https://gerbera.io/
info: Copyright 2016-2025 Gerbera Contributors.
info: Gerbera is free software, covered by the GNU General Public License version 2
info: Loading configuration from: /etc/gerbera/config.xml
info: Parsing configuration...
info: Configuration load succeeded.
nfo: Validating configuration...
warning: Option /import/scripting/common-script is deprecated, see https://docs.gerbera.io/en/stable//config-import.html#common-script and update your config.xml
warning: Option /import/scripting/playlist-script is deprecated, see https://docs.gerbera.io/en/stable//config-import.html#playlist-script and update your config.xml
warning: Option /import/scripting/virtual-layout/import-script is deprecated, see https://docs.gerbera.io/en/stable//config-import.html#scripting and update your config.xml
info: Running an automatic database upgrade from database version 23 to version 24...
error: Run: runtime error Mysql: error while updating db: mysql_error (1060): "Duplicate column name 'sort_key'"; query: ALTER TABLE `mt_cds_object` ADD `sort_key` varchar(255) default NULL COLLATE utf8_general_ci: Error: mysql_error (1060): "Duplicate column name 'sort_key'"
systemd	gerbera.service: Main process exited, code=exited, status=1/FAILURE
systemd	gerbera.service: Failed with result 'exit-code'.

Reproducible: Always

Steps to Reproduce:
1. Upgrade running system to gerbera-2.6.0-1

Actual Results:
Gerbera will not start with the error messages mentioned in Details.

Expected Results:
Gerbera starts, any data conversion (if necessary) happens in the background without user intervention.

Additional Information:
I threw the problem at ChatGPT. It suggested to manually remove the column sort_key from the database. That doesn't help.

Downgrading back to 2.5.0-1 will make everything work again.

Comment 1 Gwyn Ciesla 2025-08-14 14:39:05 UTC
Looks like upstream already fixed this, I'll push a patched update ASAP.

Comment 2 Fedora Update System 2025-08-14 15:27:17 UTC
FEDORA-2025-3e2823604e (gerbera-2.6.0-3.fc41) has been submitted as an update to Fedora 41.
https://bodhi.fedoraproject.org/updates/FEDORA-2025-3e2823604e

Comment 3 Fedora Update System 2025-08-14 15:27:17 UTC
FEDORA-2025-57e2bc40c9 (gerbera-2.6.0-3.fc42) has been submitted as an update to Fedora 42.
https://bodhi.fedoraproject.org/updates/FEDORA-2025-57e2bc40c9

Comment 4 Fedora Update System 2025-08-15 01:52:47 UTC
FEDORA-2025-57e2bc40c9 has been pushed to the Fedora 42 testing repository.
Soon you'll be able to install the update with the following command:
`sudo dnf upgrade --enablerepo=updates-testing --refresh --advisory=FEDORA-2025-57e2bc40c9`
You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2025-57e2bc40c9

See also https://fedoraproject.org/wiki/QA:Updates_Testing for more information on how to test updates.

Comment 5 Fedora Update System 2025-08-15 01:53:52 UTC
FEDORA-2025-3e2823604e has been pushed to the Fedora 41 testing repository.
Soon you'll be able to install the update with the following command:
`sudo dnf upgrade --enablerepo=updates-testing --refresh --advisory=FEDORA-2025-3e2823604e`
You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2025-3e2823604e

See also https://fedoraproject.org/wiki/QA:Updates_Testing for more information on how to test updates.

Comment 6 Fedora Update System 2025-08-16 01:05:50 UTC
FEDORA-2025-3e2823604e (gerbera-2.6.0-3.fc41) has been pushed to the Fedora 41 stable repository.
If problem still persists, please make note of it in this bug report.

Comment 7 Fedora Update System 2025-08-19 05:14:15 UTC
FEDORA-2025-b2a504a571 has been pushed to the Fedora 42 testing repository.
Soon you'll be able to install the update with the following command:
`sudo dnf upgrade --enablerepo=updates-testing --refresh --advisory=FEDORA-2025-b2a504a571`
You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2025-b2a504a571

See also https://fedoraproject.org/wiki/QA:Updates_Testing for more information on how to test updates.

Comment 8 Fedora Update System 2025-08-27 01:24:03 UTC
FEDORA-2025-b2a504a571 (gerbera-2.6.1-1.fc42) has been pushed to the Fedora 42 stable repository.
If problem still persists, please make note of it in this bug report.


Note You need to log in before you can comment on or make changes to this bug.