[Akonadi] [Bug 409753] New: Duplicate column name 'version' QMYSQL

[Matthijs Tijink]

https://bugs.kde.org/show_bug.cgi?id=409753

            Bug ID: 409753
           Summary: Duplicate column name 'version' QMYSQL
           Product: Akonadi
           Version: 5.11.3
          Platform: Archlinux Packages
                OS: Linux
            Status: REPORTED
          Severity: normal
          Priority: NOR
         Component: server
          Assignee: kdepim-bugs at kde.org
          Reporter: matthijstijink at gmail.com
  Target Milestone: ---

SUMMARY

Akonadi does not start anymore, using either the GUI or "akonadictl start".
It shows the following messages when trying to start with "akonadictl start":

org.kde.pim.akonadiserver: Running DB initializer
org.kde.pim.akonadiserver: "\nSql error: Duplicate column name 'version'
QMYSQL: Unable to execute query\nQuery: ALTER TABLE SchemaVersionTable ADD
COLUMN version INTEGER NOT NULL DEFAULT 0"
org.kde.pim.akonadiserver: Unable to initialize database.
org.kde.pim.akonadiserver: Shutting down AkonadiServer...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadiserver' exited
normally...

And then exits immediately (without error code, but I don't know if that's
expected or not).

The database (MariaDB) is running, I can connect to it, and indeed the
"version" field of "SchemaVersionTable" already exists.


SOFTWARE/OS VERSIONS
Qt Version: 5.13.0
MariaDB version: 10.4.6

ADDITIONAL INFORMATION
I'm not sure when it stopped working, but sometime in the last week. My akonadi
updated yesterday (11-07-2019) from version 5.11.2 to 5.11.3, that might be
related.

-- 
You are receiving this mail because:
You are the assignee for the bug.