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:	general	Assignee:	kdepim bugs <pim-bugs-null>
Status:	RESOLVED DOWNSTREAM
Severity:	grave
Priority:	NOR
Version First Reported In:	5.14.2
Target Milestone:	---
Platform:	openSUSE
OS:	Linux
Latest Commit:		Version Fixed/Implemented In:
Sentry Crash Report:

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