[Bug 238773] New: akonadi-server can not create sqlite DB, "INSERT INTO ResourceTable (name, isVirtual) VALUES ('akonadi_search_resource', true)" does not work

Nikoli nikoli at lavabit.com
Tue May 25 10:14:54 BST 2010 

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

           Summary: akonadi-server can not create sqlite DB, "INSERT INTO
                    ResourceTable (name,isVirtual) VALUES
                    ('akonadi_search_resource',true)" does not work
           Product: Akonadi
           Version: 1.3.50
          Platform: Gentoo Packages
        OS/Version: Linux
            Status: UNCONFIRMED
          Severity: crash
          Priority: NOR
         Component: server
        AssignedTo: vkrause at kde.org
        ReportedBy: nikoli at lavabit.com
                CC: kdepim-bugs at kde.org


Version:           1.3.50 (using KDE 4.4.3) 
OS:                Linux

Current akonadi-server can not create akonadi.db properly when using sqlite
backend, for me helped this suggestion
http://forums.gentoo.org/viewtopic-t-815342-start-0.html
sqlite backend works fine after doing:
$ cd ~/.local/share/akonadi
$ sqlite3 akonadi.db
sqlite> INSERT INTO ResourceTable (name,isVirtual) VALUES
('akonadi_search_resource',1);
sqlite> .exit 

sqlite3 does not like ('akonadi_search_resource',true), but
('akonadi_search_resource',1) works.

My versions:
dev-db/sqlite-3.6.22-r2
x11-libs/qt-sql-4.6.2
app-office/akonadi-server-1.3.1
kde-base/akonadi-4.4.3

Reproducible: Always

Steps to Reproduce:
Build qt-sql and akonadi-server with sqlite backend only, create new user with
empty home dir, start kmail from KDE 4.4.3.



$ akonadictl start
Connecting to deprecated signal
QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
Starting Akonadi Server...
   done.
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/nikoli/.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) [0x40bb09]
[akonadiserver] 1: akonadiserver [0x40c04a]
[akonadiserver] 2: /lib/libc.so.6 [0x7f9c7a31a3a0]
[akonadiserver] 3: /lib/libc.so.6(gsignal+0x35) [0x7f9c7a31a315]
[akonadiserver] 4: /lib/libc.so.6(abort+0x181) [0x7f9c7a31b811]
[akonadiserver] 5:
/usr/lib64/qt4/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x85)
[0x7f9c7c1ffb75]
[akonadiserver] 6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xab)
[0x40cecb]
[akonadiserver] 7: /usr/lib64/qt4/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x80)
[0x7f9c7c28ed50]
[akonadiserver] 8: /usr/lib64/qt4/libQtCore.so.4 [0x7f9c7c29eb9a]
[akonadiserver] 9: /usr/lib64/qt4/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x39)
[0x7f9c7c2a0999]
[akonadiserver] 10: akonadiserver(_ZN6QDebugD1Ev+0x4a) [0x40749a]
[akonadiserver] 11:
/usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x5fa)
[0x7f9c7c675c1a]
[akonadiserver] 12:
/usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x47)
[0x7f9c7c6769d7]
[akonadiserver] 13: akonadiserver(main+0x2df) [0x406b2f]
[akonadiserver] 14: /lib/libc.so.6(__libc_start_main+0xe6) [0x7f9c7a306a26]
[akonadiserver] 15: akonadiserver(_ZNSt8ios_base4InitD1Ev+0x39) [0x406759]
[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/nikoli/.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) [0x40bb09]
[akonadiserver] 1: akonadiserver [0x40c04a]
[akonadiserver] 2: /lib/libc.so.6 [0x7f0ce70123a0]
[akonadiserver] 3: /lib/libc.so.6(gsignal+0x35) [0x7f0ce7012315]
[akonadiserver] 4: /lib/libc.so.6(abort+0x181) [0x7f0ce7013811]
[akonadiserver] 5:
/usr/lib64/qt4/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x85)
[0x7f0ce8ef7b75]
[akonadiserver] 6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xab)
[0x40cecb]
[akonadiserver] 7: /usr/lib64/qt4/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x80)
[0x7f0ce8f86d50]
[akonadiserver] 8: /usr/lib64/qt4/libQtCore.so.4 [0x7f0ce8f96b9a]
[akonadiserver] 9: /usr/lib64/qt4/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x39)
[0x7f0ce8f98999]
[akonadiserver] 10: akonadiserver(_ZN6QDebugD1Ev+0x4a) [0x40749a]
[akonadiserver] 11:
/usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x5fa)
[0x7f0ce936dc1a]
[akonadiserver] 12:
/usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x47)
[0x7f0ce936e9d7]
[akonadiserver] 13: akonadiserver(main+0x2df) [0x406b2f]
[akonadiserver] 14: /lib/libc.so.6(__libc_start_main+0xe6) [0x7f0ce6ffea26]
[akonadiserver] 15: akonadiserver(_ZNSt8ios_base4InitD1Ev+0x39) [0x406759]
[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/nikoli/.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) [0x40bb09]
[akonadiserver] 1: akonadiserver [0x40c04a]
[akonadiserver] 2: /lib/libc.so.6 [0x7f945d1553a0]
[akonadiserver] 3: /lib/libc.so.6(gsignal+0x35) [0x7f945d155315]
[akonadiserver] 4: /lib/libc.so.6(abort+0x181) [0x7f945d156811]
[akonadiserver] 5:
/usr/lib64/qt4/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x85)
[0x7f945f03ab75]
[akonadiserver] 6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xab)
[0x40cecb]
[akonadiserver] 7: /usr/lib64/qt4/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x80)
[0x7f945f0c9d50]
[akonadiserver] 8: /usr/lib64/qt4/libQtCore.so.4 [0x7f945f0d9b9a]
[akonadiserver] 9: /usr/lib64/qt4/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x39)
[0x7f945f0db999]
[akonadiserver] 10: akonadiserver(_ZN6QDebugD1Ev+0x4a) [0x40749a]
[akonadiserver] 11:
/usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x5fa)
[0x7f945f4b0c1a]
[akonadiserver] 12:
/usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x47)
[0x7f945f4b19d7]
[akonadiserver] 13: akonadiserver(main+0x2df) [0x406b2f]
[akonadiserver] 14: /lib/libc.so.6(__libc_start_main+0xe6) [0x7f945d141a26]
[akonadiserver] 15: akonadiserver(_ZNSt8ios_base4InitD1Ev+0x39) [0x406759]
[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/nikoli/.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) [0x40bb09]
[akonadiserver] 1: akonadiserver [0x40c04a]
[akonadiserver] 2: /lib/libc.so.6 [0x7f73002973a0]
[akonadiserver] 3: /lib/libc.so.6(gsignal+0x35) [0x7f7300297315]
[akonadiserver] 4: /lib/libc.so.6(abort+0x181) [0x7f7300298811]
[akonadiserver] 5:
/usr/lib64/qt4/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x85)
[0x7f730217cb75]
[akonadiserver] 6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xab)
[0x40cecb]
[akonadiserver] 7: /usr/lib64/qt4/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x80)
[0x7f730220bd50]
[akonadiserver] 8: /usr/lib64/qt4/libQtCore.so.4 [0x7f730221bb9a]
[akonadiserver] 9: /usr/lib64/qt4/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x39)
[0x7f730221d999]
[akonadiserver] 10: akonadiserver(_ZN6QDebugD1Ev+0x4a) [0x40749a]
[akonadiserver] 11:
/usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x5fa)
[0x7f73025f2c1a]
[akonadiserver] 12:
/usr/lib64/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x47)
[0x7f73025f39d7]
[akonadiserver] 13: akonadiserver(main+0x2df) [0x406b2f]
[akonadiserver] 14: /lib/libc.so.6(__libc_start_main+0xe6) [0x7f7300283a26]
[akonadiserver] 15: akonadiserver(_ZNSt8ios_base4InitD1Ev+0x39) [0x406759]
[akonadiserver] ]
[akonadiserver] "
ProcessControl: Application 'akonadiserver' returned with exit code 255
(Unknown error)
"akonadiserver" crashed too often and will not be restarted!

-- 
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.

More information about the Kdepim-bugs mailing list