Bug 423918

Summary: akonadi migration to postgres12 was OK, but akonadi does not start
Product: [Frameworks and Libraries] Akonadi Reporter: Axel Braun <axel.braun>
Component: generalAssignee: kdepim bugs <kdepim-bugs>
Status: RESOLVED DOWNSTREAM    
Severity: grave    
Priority: NOR    
Version: 5.14.2   
Target Milestone: ---   
Platform: openSUSE   
OS: Linux   
Latest Commit: Version Fixed In:

Description Axel Braun 2020-07-06 06:45:34 UTC
SUMMARY
Akonadi was migrated from postgres96 to postgres 12 (following https://userbase.kde.org/Akonadi/Postgres_update), migration went OK.

Afterwards it does not start with the following error:

org.kde.pim.akonadiserver: "\nSql error: ERROR:  column \"version\" of relation \"schemaversiontable\" already exists\n(42701) QPSQL: Unable to create query\nQuery: ALTER TABLE SchemaVersionTable ADD COLUMN version INTEGER NOT NULL DEFAULT 0"
org.kde.pim.akonadiserver: Unable to initialize database.

Operating System: openSUSE Leap 15.2
KDE Plasma Version: 5.18.5
KDE Frameworks Version: 5.71.0
Qt Version: 5.12.7
Comment 1 Axel Braun 2020-10-26 13:31:31 UTC
Looks like this was a qt issue:
https://bugzilla.opensuse.org/show_bug.cgi?id=1173758
As it worked with the above patch, I close the bug