[Akonadi] [Bug 409234] New: akonadi with qt5 5.13 is unable to initialize database when using the PostgreSQL backend

[bugzilla_noreply at kde.org]

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

            Bug ID: 409234
           Summary: akonadi with qt5 5.13 is unable to initialize database
                    when using the PostgreSQL backend
           Product: Akonadi
           Version: unspecified
          Platform: Archlinux Packages
                OS: Linux
            Status: REPORTED
          Severity: normal
          Priority: NOR
         Component: server
          Assignee: kdepim-bugs at kde.org
          Reporter: nl6720 at gmail.com
  Target Milestone: ---

SUMMARY

After upgrading qt5 packages to 5.13, akonadiserver is "Unable to initialize
database" when using PostgreSQL.

The issue appears to be caused by
https://github.com/qt/qtbase/commit/461ef575bcf778ba24b0be6b775098d4b80ae5e1 .

STEPS TO REPRODUCE
1. Configure akonadi to use PostgreSQL.
2. run `akonadictl start`.

OBSERVED RESULT

Connecting to deprecated signal
QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
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
org.kde.pim.akonadiserver: Shutting down AkonadiServer...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadiserver' exited
normally...

EXPECTED RESULT

org.kde.pim.akonadiserver: Starting up the Akonadi Server...                    
org.kde.pim.akonadiserver: Running DB initializer
org.kde.pim.akonadiserver: DB initializer done
...

SOFTWARE/OS VERSIONS
Operating System: Arch Linux 
KDE Plasma Version: 5.16.2
KDE Frameworks Version: 5.59.0
Qt Version: 5.13.0

akonadi 19.04.2-3
qt5-base 5.13.0-4
postgresql 11.4-1

ADDITIONAL INFORMATION

Arch Linux bug: https://bugs.archlinux.org/task/62997

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