Bug 423918 - akonadi migration to postgres12 was OK, but akonadi does not start
Summary: akonadi migration to postgres12 was OK, but akonadi does not start
Status: RESOLVED DOWNSTREAM
Alias: None
Product: Akonadi
Classification: Frameworks and Libraries
Component: general (show other bugs)
Version: 5.14.2
Platform: openSUSE Linux
: NOR grave
Target Milestone: ---
Assignee: kdepim bugs
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-07-06 06:45 UTC by Axel Braun
Modified: 2020-10-26 13:31 UTC (History)
0 users

See Also:
Latest Commit:
Version Fixed In:

Attachments
Add an attachment

Note You need to log in before you can comment on or make changes to this bug.
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