Bug 316002

Summary: akonadi fails to start with QSQLITE3 driver
Product: [Frameworks and Libraries] Akonadi Reporter: blaze
Component: serverAssignee: kdepim bugs <kdepim-bugs>
Status: RESOLVED INTENTIONAL    
Severity: grave CC: blaze, kdebugs, stupor_scurvy343
Priority: NOR    
Version: 4.10   
Target Milestone: ---   
Platform: Ubuntu   
OS: Linux   
Latest Commit: Version Fixed In:
Sentry Crash Report:

Description blaze 2013-03-02 11:10:50 UTC 
Akonadi server fails to start after upgrade to KDE 4.10.0 (akonadi server 1.9.0).

Reproducible: Always

Steps to Reproduce:
1. set the SQlite for database driver in Akonadi Server Configuration dialog
2. akonadictl start
3. see the output



actual output:

QSqlDatabase: QSQLITE3 driver not loaded
QSqlDatabase: available drivers: QSQLITE
ASSERT: "database.driver()->hasFeature( QSqlDriver::LastInsertId )" in file ../../server/src/storage/dbconfigsqlite.cpp, line 117
"[
0: akonadiserver() [0x805bee5]
1: akonadiserver() [0x805c22a]
2: [0xb773e400]
3: [0xb773e424]
4: /lib/i386-linux-gnu/libc.so.6(gsignal+0x4f) [0xb6e07b1f]
5: /lib/i386-linux-gnu/libc.so.6(abort+0x143) [0xb6e0b0b3]
6: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x13c) [0xb748c7fc]
7: /usr/lib/i386-linux-gnu/libQtCore.so.4(+0x5cc09) [0xb748cc09]
8: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z6qFatalPKcz+0x18) [0xb748cd28]
9: /usr/lib/i386-linux-gnu/libQtCore.so.4(_Z9qt_assertPKcS0_i+0x35) [0xb748cdb5]
10: akonadiserver() [0x80d86d4]
11: akonadiserver() [0x805f06d]
12: akonadiserver() [0x8060aa5]
13: akonadiserver() [0x8061566]
14: akonadiserver() [0x8055b6a]
15: /lib/i386-linux-gnu/libc.so.6(__libc_start_main+0xf5) [0xb6df2935]
16: akonadiserver() [0x8056681]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
Comment 1 Andrey 2013-03-17 22:17:57 UTC 
*** This bug has been confirmed by popular vote. ***
Comment 2 Christophe Marin 2013-03-17 22:53:04 UTC 
>QSqlDatabase: QSQLITE3 driver not loaded
>QSqlDatabase: available drivers: QSQLITE

Installation or packaging issue. Check with your distribution that the sqlite driver is built in Akonadi

looks like ubuntu has a akonadi-backend-sqlite package. make sure it's installed
Comment 3 Christophe Marin 2013-03-17 23:06:43 UTC 
what does 'qmake -query QT_INSTALL_PLUGINS' return ?

if it doesn't return /usr/lib/plugins, that's an Ubuntu issue, the akonadi-sqlite plugin is installed there: http://packages.ubuntu.com/raring/amd64/akonadi-backend-sqlite/filelist

If that's the case, ask your distribution to use -DINSTALL_QSQLITE_IN_QT_PREFIX when building Akonadi.
Comment 4 Christophe Marin 2013-03-18 13:56:10 UTC 
Changing status. The INSTALL files was updated with the build options: https://projects.kde.org/projects/kdesupport/akonadi/repository/revisions/073b53a491218c0c1770cd0f473180e37ba4a018/diff/INSTALL
Comment 5 stupor_scurvy343 2013-03-18 13:57:16 UTC 
Should the plugin not load anyway, even if QT_INSTALL_PLUGINS != /usr/lib/plugins given that:

$ kde4-config --path qtplugins
/home/michael/.kde4/lib/kde4/plugins/:/usr/lib/kde4/plugins/:/usr/lib/plugins/
Comment 6 Christophe Marin 2013-03-18 14:25:42 UTC 
The Akonadi server is pure Qt.
To load plugins from a custom prefix, setting QT_PLUGIN_PATH would be mandatory. That's why we suggest packagers to install the qsqlite3 plugin in the same directory as the Qt sqldriver plugins
Comment 7 stupor_scurvy343 2013-03-18 15:01:21 UTC 
(In reply to comment #6)
> The Akonadi server is pure Qt.
> To load plugins from a custom prefix, setting QT_PLUGIN_PATH would be
> mandatory. That's why we suggest packagers to install the qsqlite3 plugin in
> the same directory as the Qt sqldriver plugins

Thanks for the info.

(FWIW, I got that idea from the commit message http://quickgit.kde.org/?p=akonadi.git&a=commitdiff&h=ee3c4bb057da9dc78b7faf92740bd6eba65f8cf7)
Comment 8 Christophe Marin 2013-03-22 09:07:52 UTC 
No feedback from the reporter. Closing
Comment 9 blaze 2013-08-25 10:37:39 UTC 
KDE 4.11.0
$ akonadictl --version
Akonadi 1.10.1

Bug is still persistent. Akonadi is only operational when "QSQLITE" driver was set, but configurator uses "QSQLITE3".

It's NOT the packaging issue.
Comment 10 blaze 2013-08-25 11:35:03 UTC 
Oh well, now I get it.