https://bugs.kde.org/show_bug.cgi?id=226978
Summary: akonadi-server fails to start upon creating initial
SQLite db
Product: Akonadi
Version: 4.4
Platform: Gentoo Packages
OS/Version: Linux
Status: UNCONFIRMED
Severity: crash
Priority: NOR
Component: general
AssignedTo: [email protected]
ReportedBy: [email protected]
CC: [email protected]
Version: (using KDE 4.4.0)
Compiler: gcc 4.4.3 gcc (Gentoo 4.4.3 p1.0) 4.4.3
OS: Linux
Installed from: Gentoo Packages
I know sqlite is not recommended for use by akonadi-server, but I don't want to
use MySQL for the
PIM storage (at least not currently), so I'm falling back to sqlite.
When there's no sqlite database and you try to start akonadi-server by using
the akonadictl tool,
akonadi-server crashes because of a mispelled SQL instruction. Details:
Connecting to deprecated signal
QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
[akonadiserver] QSqlDatabasePrivate::removeDatabase: connection
'initConnection' is still in use,
all queries will cease to work.
[akonadiserver] Database "/home/xxxxx/.local/share/akonadi/akonadi.db" opened
using driver
"QSQLITE"
[akonadiserver] DbInitializer::run()
[akonadiserver] checking table "SchemaVersionTable"
[akonadiserver] "CREATE TABLE SchemaVersionTable (version INTEGER NOT NULL);"
[akonadiserver] checking table "ResourceTable"
[akonadiserver] "CREATE TABLE ResourceTable (id INTEGER NOT NULL PRIMARY KEY
AUTOINCREMENT, name
VARCHAR(255) COLLATE BINARY NOT NULL UNIQUE, isVirtual BOOL DEFAULT false);"
[akonadiserver] "Unable to add initial data to table 'ResourceTable'.
[akonadiserver] Query error: 'no such column: true Unable to execute statement'
[akonadiserver] Query was: INSERT INTO ResourceTable (name,isVirtual) VALUES
('akonadi_search_resource',true)"
[akonadiserver] Unable to initialize database.
[akonadiserver] "[
[akonadiserver] 0: akonadiserver(_Z11akBacktracev+0x39) [0x40af69]
[akonadiserver] 1: akonadiserver [0x40b4b2]
[akonadiserver] 2: /lib/libc.so.6 [0x7fe9618d9100]
[akonadiserver] 3: /lib/libc.so.6(gsignal+0x35) [0x7fe9618d9085]
[akonadiserver] 4: /lib/libc.so.6(abort+0x180) [0x7fe9618da4b0]
[akonadiserver] 5:
/usr/lib64/qt4/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x74)
[0x7fe962a6a3a4]
[akonadiserver] 6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xa8)
[0x40c5b8]
[akonadiserver] 7: /usr/lib64/qt4/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x78)
[0x7fe962af8348]
[akonadiserver] 8: /usr/lib64/qt4/libQtCore.so.4 [0x7fe962b09699]
[akonadiserver] 9: /usr/lib64/qt4/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x39)
[0x7fe962b0a889]
[akonadiserver] 10: akonadiserver(_ZN6QDebugD1Ev+0x4d) [0x406b3d]
[akonadiserver] 11:
/usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x5f4)
[0x7fe962ed6524]
[akonadiserver] 12:
/usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x4a)
[0x7fe962ed72ca]
[akonadiserver] 13: akonadiserver(main+0x3aa) [0x40615a]
[akonadiserver] 14: /lib/libc.so.6(__libc_start_main+0xfd) [0x7fe9618c5a3d]
[akonadiserver] 15: akonadiserver(_ZNSt8ios_base4InitD1Ev+0x39) [0x405cb9]
[akonadiserver] ]
[akonadiserver] "
ProcessControl: Application 'akonadiserver' returned with exit code 255
(Unknown error)
[akonadiserver] QSqlDatabasePrivate::removeDatabase: connection
'initConnection' is still in use,
all queries will cease to work.
[akonadiserver] Database "/home/xxxxx/.local/share/akonadi/akonadi.db" opened
using driver
"QSQLITE"
[akonadiserver] DbInitializer::run()
[akonadiserver] checking table "SchemaVersionTable"
[akonadiserver] checking table "ResourceTable"
[akonadiserver] "Unable to add initial data to table 'ResourceTable'.
[akonadiserver] Query error: 'no such column: true Unable to execute statement'
[akonadiserver] Query was: INSERT INTO ResourceTable (name,isVirtual) VALUES
('akonadi_search_resource',true)"
[akonadiserver] Unable to initialize database.
[akonadiserver] "[
[akonadiserver] 0: akonadiserver(_Z11akBacktracev+0x39) [0x40af69]
[akonadiserver] 1: akonadiserver [0x40b4b2]
[akonadiserver] 2: /lib/libc.so.6 [0x7fdb60e0c100]
[akonadiserver] 3: /lib/libc.so.6(gsignal+0x35) [0x7fdb60e0c085]
[akonadiserver] 4: /lib/libc.so.6(abort+0x180) [0x7fdb60e0d4b0]
[akonadiserver] 5:
/usr/lib64/qt4/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x74)
[0x7fdb61f9d3a4]
[akonadiserver] 6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xa8)
[0x40c5b8]
[akonadiserver] 7: /usr/lib64/qt4/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x78)
[0x7fdb6202b348]
[akonadiserver] 8: /usr/lib64/qt4/libQtCore.so.4 [0x7fdb6203c699]
[akonadiserver] 9: /usr/lib64/qt4/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x39)
[0x7fdb6203d889]
[akonadiserver] 10: akonadiserver(_ZN6QDebugD1Ev+0x4d) [0x406b3d]
[akonadiserver] 11:
/usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x5f4)
[0x7fdb62409524]
[akonadiserver] 12:
/usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x4a)
[0x7fdb6240a2ca]
[akonadiserver] 13: akonadiserver(main+0x3aa) [0x40615a]
[akonadiserver] 14: /lib/libc.so.6(__libc_start_main+0xfd) [0x7fdb60df8a3d]
[akonadiserver] 15: akonadiserver(_ZNSt8ios_base4InitD1Ev+0x39) [0x405cb9]
[akonadiserver] ]
[akonadiserver] "
ProcessControl: Application 'akonadiserver' returned with exit code 255
(Unknown error)
[akonadiserver] QSqlDatabasePrivate::removeDatabase: connection
'initConnection' is still in use,
all queries will cease to work.
[akonadiserver] Database "/home/xxxxx/.local/share/akonadi/akonadi.db" opened
using driver
"QSQLITE"
[akonadiserver] DbInitializer::run()
[akonadiserver] checking table "SchemaVersionTable"
[akonadiserver] checking table "ResourceTable"
[akonadiserver] "Unable to add initial data to table 'ResourceTable'.
[akonadiserver] Query error: 'no such column: true Unable to execute statement'
[akonadiserver] Query was: INSERT INTO ResourceTable (name,isVirtual) VALUES
('akonadi_search_resource',true)"
[akonadiserver] Unable to initialize database.
[akonadiserver] "[
[akonadiserver] 0: akonadiserver(_Z11akBacktracev+0x39) [0x40af69]
[akonadiserver] 1: akonadiserver [0x40b4b2]
[akonadiserver] 2: /lib/libc.so.6 [0x7fa25dacc100]
[akonadiserver] 3: /lib/libc.so.6(gsignal+0x35) [0x7fa25dacc085]
[akonadiserver] 4: /lib/libc.so.6(abort+0x180) [0x7fa25dacd4b0]
[akonadiserver] 5:
/usr/lib64/qt4/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x74)
[0x7fa25ec5d3a4]
[akonadiserver] 6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xa8)
[0x40c5b8]
[akonadiserver] 7: /usr/lib64/qt4/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x78)
[0x7fa25eceb348]
[akonadiserver] 8: /usr/lib64/qt4/libQtCore.so.4 [0x7fa25ecfc699]
[akonadiserver] 9: /usr/lib64/qt4/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x39)
[0x7fa25ecfd889]
[akonadiserver] 10: akonadiserver(_ZN6QDebugD1Ev+0x4d) [0x406b3d]
[akonadiserver] 11:
/usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x5f4)
[0x7fa25f0c9524]
[akonadiserver] 12:
/usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x4a)
[0x7fa25f0ca2ca]
[akonadiserver] 13: akonadiserver(main+0x3aa) [0x40615a]
[akonadiserver] 14: /lib/libc.so.6(__libc_start_main+0xfd) [0x7fa25dab8a3d]
[akonadiserver] 15: akonadiserver(_ZNSt8ios_base4InitD1Ev+0x39) [0x405cb9]
[akonadiserver] ]
[akonadiserver] "
ProcessControl: Application 'akonadiserver' returned with exit code 255
(Unknown error)
[akonadiserver] QSqlDatabasePrivate::removeDatabase: connection
'initConnection' is still in use,
all queries will cease to work.
[akonadiserver] Database "/home/xxxxx/.local/share/akonadi/akonadi.db" opened
using driver
"QSQLITE"
[akonadiserver] DbInitializer::run()
[akonadiserver] checking table "SchemaVersionTable"
[akonadiserver] checking table "ResourceTable"
[akonadiserver] "Unable to add initial data to table 'ResourceTable'.
[akonadiserver] Query error: 'no such column: true Unable to execute statement'
[akonadiserver] Query was: INSERT INTO ResourceTable (name,isVirtual) VALUES
('akonadi_search_resource',true)"
[akonadiserver] Unable to initialize database.
[akonadiserver] "[
[akonadiserver] 0: akonadiserver(_Z11akBacktracev+0x39) [0x40af69]
[akonadiserver] 1: akonadiserver [0x40b4b2]
[akonadiserver] 2: /lib/libc.so.6 [0x7f1f2bbec100]
[akonadiserver] 3: /lib/libc.so.6(gsignal+0x35) [0x7f1f2bbec085]
[akonadiserver] 4: /lib/libc.so.6(abort+0x180) [0x7f1f2bbed4b0]
[akonadiserver] 5:
/usr/lib64/qt4/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x74)
[0x7f1f2cd7d3a4]
[akonadiserver] 6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xa8)
[0x40c5b8]
[akonadiserver] 7: /usr/lib64/qt4/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x78)
[0x7f1f2ce0b348]
[akonadiserver] 8: /usr/lib64/qt4/libQtCore.so.4 [0x7f1f2ce1c699]
[akonadiserver] 9: /usr/lib64/qt4/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x39)
[0x7f1f2ce1d889]
[akonadiserver] 10: akonadiserver(_ZN6QDebugD1Ev+0x4d) [0x406b3d]
[akonadiserver] 11:
/usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x5f4)
[0x7f1f2d1e9524]
[akonadiserver] 12:
/usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x4a)
[0x7f1f2d1ea2ca]
[akonadiserver] 13: akonadiserver(main+0x3aa) [0x40615a]
[akonadiserver] 14: /lib/libc.so.6(__libc_start_main+0xfd) [0x7f1f2bbd8a3d]
[akonadiserver] 15: akonadiserver(_ZNSt8ios_base4InitD1Ev+0x39) [0x405cb9]
[akonadiserver] ]
[akonadiserver] "
ProcessControl: Application 'akonadiserver' returned with exit code 255
(Unknown error)
"akonadiserver" crashed too often and will not be restarted!
The db file is created, simply the INSERT statement fails, because true needs
to be quoted. If you
connect manually using sqlite3 and issue the INSERT statement, the next
akonadictl start command
succeeds and akonadi-server starts. So, the workaround is to simply quote the
test value:
INSERT INTO ResourceTable (name,isVirtual) VALUES ('akonadi_search_resource',
'true')
--
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
_______________________________________________
Kdepim-bugs mailing list
[email protected]
https://mail.kde.org/mailman/listinfo/kdepim-bugs
