Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 681658 - kde-apps/akonadi-18.12.3 - org.kde.pim.akonadiserver: Error: table PartTable_new has 7 columns but 8 values were supplied Unable to execute statement
Summary: kde-apps/akonadi-18.12.3 - org.kde.pim.akonadiserver: Error: table PartTable_...
Status: UNCONFIRMED
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: Current packages (show other bugs)
Hardware: All Linux
: Normal normal (vote)
Assignee: Gentoo KDE team
URL:
Whiteboard: tracking upstream
Keywords: UPSTREAM
Depends on:
Blocks:
 
Reported: 2019-03-24 13:02 UTC by Stefan Huber
Modified: 2019-04-01 09:50 UTC (History)
0 users

See Also:
Package list:
Runtime testing required: ---


Attachments

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