Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!

Bug 681658

Summary: kde-apps/akonadi-18.12.3[sqlite] - org.kde.pim.akonadiserver: Error: table PartTable_new has 7 columns but 8 values were supplied Unable to execute statement
Product: Gentoo Linux Reporter: Stefan Huber <shuber>
Component: Current packagesAssignee: Gentoo KDE team <kde>
Status: RESOLVED UPSTREAM    
Severity: normal Keywords: UPSTREAM
Priority: Normal    
Version: unspecified   
Hardware: All   
OS: Linux   
See Also: https://bugs.kde.org/show_bug.cgi?id=402229
Whiteboard: tracking upstream
Package list:
Runtime testing required: ---

Description Stefan Huber 2019-03-24 13:02:56 UTC
After upgrading to kde-apps to 18.12.3, korganizer does not start because akonadi could not be started. This again fails as follows:

$ akonadictl start
[...]
org.kde.pim.akonadiserver: Starting up the Akonadi Server...
[...]
org.kde.pim.akonadiserver: Running DB initializer
org.kde.pim.akonadiserver: DB initializer done
org.kde.pim.akonadiserver: SQL error when updating table PartTable
org.kde.pim.akonadiserver: Query: DROP TABLE PartTable_new
org.kde.pim.akonadiserver: Error: table PartTable_new has 7 columns but 8 values were supplied Unable to execute statement
org.kde.pim.akonadiserver: Update failed
org.kde.pim.akonadiserver: Failed to commit transaction for database update
org.kde.pim.akonadiserver: Unable to initialize database.
org.kde.pim.akonadiserver: Shutting down AkonadiServer...
[...]

Similar references:
[1] https://bugzilla.redhat.com/show_bug.cgi?id=1687071
[2] https://www.mail-archive.com/kdepim-bugs@kde.org/msg121018.html
Comment 1 Andreas Sturmlechner gentoo-dev 2019-03-24 19:02:32 UTC
The partial fix from linked bug is already in 18.12.3, so I'm not sure what issue they really fixed.

Please note that using sqlite backend is strongly discouraged.
Comment 2 Stefan Huber 2019-03-24 19:24:10 UTC
I changed the mysql by setting
  Driver=QMYSQL
in the ~.config/akonadi/akonadiserverrc configuration file. Restarting akonadiserver works again. (Of course, calendar entries have been fetched from the davcal server again...)


(In reply to Andreas Sturmlechner from comment #1)
> Please note that using sqlite backend is strongly discouraged.

Hence, the sqlite use-flag should be masked?
Comment 3 Andreas Sturmlechner gentoo-dev 2019-03-24 21:31:16 UTC
(In reply to Stefan Huber from comment #2)
> Hence, the sqlite use-flag should be masked?
I would do that in a heartbeat, but it is unpopular.

Instead, each akonadi[sqlite] pkg_setup warns:

 * We strongly recommend you change your Akonadi database backend to either MySQL
 * or PostgreSQL in your user configuration.
 * In particular, kde-apps/kmail does not work properly with the sqlite backend.