SUMMARY After upgrading PostgreSQL to version 12, and migrating the database according to https://userbase.kde.org/Akonadi/Postgres_update, trying to start Akonadi fails with: org.kde.pim.akonadiserver: Starting up the Akonadi Server... org.kde.pim.akonadiserver: Running DB initializer 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. waiting for server to shut down.... done server stopped This is the same error message as in bug 409234, but not the same bug, since that one is about Qt 5.13 and I am on Qt 5.12.5. I tried deleting $HOME/.local/share/akonadi/db_data/ and restarting Akonadi, which works, creating a new database. But I would prefer not having to re-download several GB of IMAP mailboxes. SOFTWARE/OS VERSIONS Linux/KDE Plasma: 19.08.1 (available in About System) KDE Plasma Version: 5.16.5 KDE Frameworks Version: 5.62.0 Qt Version: 5.12.5
*** Bug 412818 has been marked as a duplicate of this bug. ***
Keep in mind, that even Qt does not support Postgres 12 atm, so in first glance there needs to be a bug filed against Qt: https://code.qt.io/cgit/qt/qtbase.git/tree/src/plugins/sqldrivers/psql/qsql_psql.cpp#n1080 also in Debian this bug is reported: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=941763
Created attachment 123136 [details] attachment-29246-0.html Ok, I didn't suspect that since it is communicating with the database. Just that the query fails and Akonadi shuts down. On Thu, Oct 10, 2019 at 9:20 PM Sandro Knauß <bugzilla_noreply@kde.org> wrote: > https://bugs.kde.org/show_bug.cgi?id=412629 > > Sandro Knauß <sknauss@kde.org> changed: > > What |Removed |Added > > ---------------------------------------------------------------------------- > CC| |sknauss@kde.org > Status|REPORTED |CONFIRMED > Ever confirmed|0 |1 > > --- Comment #2 from Sandro Knauß <sknauss@kde.org> --- > Keep in mind, that even Qt does not support Postgres 12 atm, so in first > glance > there needs to be a bug filed against Qt: > > > https://code.qt.io/cgit/qt/qtbase.git/tree/src/plugins/sqldrivers/psql/qsql_psql.cpp#n1080 > > also in Debian this bug is reported: > https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=941763 > > -- > You are receiving this mail because: > You are on the CC list for the bug.
FTR: https://codereview.qt-project.org/c/qt/qtbase/+/277205
Does the fix in libqt5sql5-psql: basic support postgresql-12 https://bugs.debian.org/941763 fix this issue or not? Or in other words: Has this been fixed or is it still an issue? I am asking, cause this bug report is still open.
(In reply to Martin Steigerwald from comment #5) > Does the fix in > > libqt5sql5-psql: basic support postgresql-12 > https://bugs.debian.org/941763 > > fix this issue or not? > > Or in other words: Has this been fixed or is it still > an issue? I am asking, cause this bug report is still open. This looks like the upstream patch we have in Gentoo[1], so I think the issue is fixed, yes. As this bugtracker seems to allow me to close this bug I’ll give it a try. In case someone still has issues please re-open it. [1] https://bugs.gentoo.org/696870, see second patch