This forum has been archived. All content is frozen. Please use KDE Discuss instead.

Akonadi

Tags: None
(comma "," separated)
User avatar
PuercoPop
Registered Member
Posts
15
Karma
0
OS

Akonadi

Tue Dec 22, 2009 11:33 pm
Hi after searching around and fixing issues in order to get akonadi running ( some bad options, root permisions, etc)
I got down to this error: "Akonadi control process not registred at D-Bus".
so I tried runing 'akonadictl start' at the console and I think I've pin-pointed to this

[akonadiserver] "Unable to create entire table.
[akonadiserver] Query error: 'Invalid default value for 'atime' QMYSQL3: Unable to execute statement'"
[akonadiserver] Unable to initialize database.


I'll paste the full of the messages shown below. Any Ideas how to fix this? Thanks in Advance.

[pirata@myhost ~]$ akonadictl start
Starting Akonadi Server...
done.
[pirata@myhost ~]$ [akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[akonadiserver] DbInitializer::run()
[akonadiserver] checking table "SchemaVersionTable"
[akonadiserver] checking table "ResourceTable"
[akonadiserver] checking table "CollectionTable"
[akonadiserver] checking table "MimeTypeTable"
[akonadiserver] checking table "PimItemTable"
[akonadiserver] "CREATE TABLE PimItemTable (id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT, rev INTEGER NOT NULL DEFAULT 0, remoteId TEXT , collectionId BIGINT REFERENCES Collection(id), mimeTypeId BIGINT REFERENCES MimeType(id), datetime TIMESTAMP DEFAULT CURRENT_TIMESTAMP, atime TIMESTAMP , dirty BOOL , size BIGINT NOT NULL DEFAULT 0);"
[akonadiserver] "Unable to create entire table.
[akonadiserver] Query error: 'Invalid default value for 'atime' QMYSQL3: Unable to execute statement'"
[akonadiserver] Unable to initialize database.
[akonadiserver] "[
[akonadiserver] 0: akonadiserver(_Z11akBacktracev+0x39) [0x40b619]
[akonadiserver] 1: akonadiserver() [0x40bb62]
[akonadiserver] 2: /lib/libc.so.6(+0x320b0) [0x7f714d6020b0]
[akonadiserver] 3: /lib/libc.so.6(gsignal+0x35) [0x7f714d602035]
[akonadiserver] 4: /lib/libc.so.6(abort+0x180) [0x7f714d603460]
[akonadiserver] 5: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x6f) [0x7f714e57709f]
[akonadiserver] 6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xa8) [0x40c698]
[akonadiserver] 7: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x6e) [0x7f714e600d7e]
[akonadiserver] 8: /usr/lib/libQtCore.so.4(+0xe9b09) [0x7f714e60eb09]
[akonadiserver] 9: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x68) [0x7f714e60fb38]
[akonadiserver] 10: akonadiserver(_ZN6QDebugD1Ev+0x45) [0x406a95]
[akonadiserver] 11: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x5f1) [0x7f714ebc8701]
[akonadiserver] 12: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x4a) [0x7f714ebc939a]
[akonadiserver] 13: akonadiserver(main+0x3a4) [0x406154]
[akonadiserver] 14: /lib/libc.so.6(__libc_start_main+0xfd) [0x7f714d5eeb6d]
[akonadiserver] 15: akonadiserver() [0x405cb9]
[akonadiserver] ]
[akonadiserver] "
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[akonadiserver] DbInitializer::run()
[akonadiserver] checking table "SchemaVersionTable"
[akonadiserver] checking table "ResourceTable"
[akonadiserver] checking table "CollectionTable"
[akonadiserver] checking table "MimeTypeTable"
[akonadiserver] checking table "PimItemTable"
[akonadiserver] "CREATE TABLE PimItemTable (id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT, rev INTEGER NOT NULL DEFAULT 0, remoteId TEXT , collectionId BIGINT REFERENCES Collection(id), mimeTypeId BIGINT REFERENCES MimeType(id), datetime TIMESTAMP DEFAULT CURRENT_TIMESTAMP, atime TIMESTAMP , dirty BOOL , size BIGINT NOT NULL DEFAULT 0);"
[akonadiserver] "Unable to create entire table.
[akonadiserver] Query error: 'Invalid default value for 'atime' QMYSQL3: Unable to execute statement'"
[akonadiserver] Unable to initialize database.
[akonadiserver] "[
[akonadiserver] 0: akonadiserver(_Z11akBacktracev+0x39) [0x40b619]
[akonadiserver] 1: akonadiserver() [0x40bb62]
[akonadiserver] 2: /lib/libc.so.6(+0x320b0) [0x7f881ae5a0b0]
[akonadiserver] 3: /lib/libc.so.6(gsignal+0x35) [0x7f881ae5a035]
[akonadiserver] 4: /lib/libc.so.6(abort+0x180) [0x7f881ae5b460]
[akonadiserver] 5: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x6f) [0x7f881bdcf09f]
[akonadiserver] 6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xa8) [0x40c698]
[akonadiserver] 7: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x6e) [0x7f881be58d7e]
[akonadiserver] 8: /usr/lib/libQtCore.so.4(+0xe9b09) [0x7f881be66b09]
[akonadiserver] 9: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x68) [0x7f881be67b38]
[akonadiserver] 10: akonadiserver(_ZN6QDebugD1Ev+0x45) [0x406a95]
[akonadiserver] 11: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x5f1) [0x7f881c420701]
[akonadiserver] 12: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x4a) [0x7f881c42139a]
[akonadiserver] 13: akonadiserver(main+0x3a4) [0x406154]
[akonadiserver] 14: /lib/libc.so.6(__libc_start_main+0xfd) [0x7f881ae46b6d]
[akonadiserver] 15: akonadiserver() [0x405cb9]
[akonadiserver] ]
[akonadiserver] "
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[akonadiserver] DbInitializer::run()
[akonadiserver] checking table "SchemaVersionTable"
[akonadiserver] checking table "ResourceTable"
[akonadiserver] checking table "CollectionTable"
[akonadiserver] checking table "MimeTypeTable"
[akonadiserver] checking table "PimItemTable"
[akonadiserver] "CREATE TABLE PimItemTable (id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT, rev INTEGER NOT NULL DEFAULT 0, remoteId TEXT , collectionId BIGINT REFERENCES Collection(id), mimeTypeId BIGINT REFERENCES MimeType(id), datetime TIMESTAMP DEFAULT CURRENT_TIMESTAMP, atime TIMESTAMP , dirty BOOL , size BIGINT NOT NULL DEFAULT 0);"
[akonadiserver] "Unable to create entire table.
[akonadiserver] Query error: 'Invalid default value for 'atime' QMYSQL3: Unable to execute statement'"
[akonadiserver] Unable to initialize database.
[akonadiserver] "[
[akonadiserver] 0: akonadiserver(_Z11akBacktracev+0x39) [0x40b619]
[akonadiserver] 1: akonadiserver() [0x40bb62]
[akonadiserver] 2: /lib/libc.so.6(+0x320b0) [0x7f6d4d47c0b0]
[akonadiserver] 3: /lib/libc.so.6(gsignal+0x35) [0x7f6d4d47c035]
[akonadiserver] 4: /lib/libc.so.6(abort+0x180) [0x7f6d4d47d460]
[akonadiserver] 5: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x6f) [0x7f6d4e3f109f]
[akonadiserver] 6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xa8) [0x40c698]
[akonadiserver] 7: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x6e) [0x7f6d4e47ad7e]
[akonadiserver] 8: /usr/lib/libQtCore.so.4(+0xe9b09) [0x7f6d4e488b09]
[akonadiserver] 9: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x68) [0x7f6d4e489b38]
[akonadiserver] 10: akonadiserver(_ZN6QDebugD1Ev+0x45) [0x406a95]
[akonadiserver] 11: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x5f1) [0x7f6d4ea42701]
[akonadiserver] 12: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x4a) [0x7f6d4ea4339a]
[akonadiserver] 13: akonadiserver(main+0x3a4) [0x406154]
[akonadiserver] 14: /lib/libc.so.6(__libc_start_main+0xfd) [0x7f6d4d468b6d]
[akonadiserver] 15: akonadiserver() [0x405cb9]
[akonadiserver] ]
[akonadiserver] "
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[akonadiserver] DbInitializer::run()
[akonadiserver] checking table "SchemaVersionTable"
[akonadiserver] checking table "ResourceTable"
[akonadiserver] checking table "CollectionTable"
[akonadiserver] checking table "MimeTypeTable"
[akonadiserver] checking table "PimItemTable"
[akonadiserver] "CREATE TABLE PimItemTable (id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT, rev INTEGER NOT NULL DEFAULT 0, remoteId TEXT , collectionId BIGINT REFERENCES Collection(id), mimeTypeId BIGINT REFERENCES MimeType(id), datetime TIMESTAMP DEFAULT CURRENT_TIMESTAMP, atime TIMESTAMP , dirty BOOL , size BIGINT NOT NULL DEFAULT 0);"
[akonadiserver] "Unable to create entire table.
[akonadiserver] Query error: 'Invalid default value for 'atime' QMYSQL3: Unable to execute statement'"
[akonadiserver] Unable to initialize database.
[akonadiserver] "[
[akonadiserver] 0: akonadiserver(_Z11akBacktracev+0x39) [0x40b619]
[akonadiserver] 1: akonadiserver() [0x40bb62]
[akonadiserver] 2: /lib/libc.so.6(+0x320b0) [0x7fbf5796c0b0]
[akonadiserver] 3: /lib/libc.so.6(gsignal+0x35) [0x7fbf5796c035]
[akonadiserver] 4: /lib/libc.so.6(abort+0x180) [0x7fbf5796d460]
[akonadiserver] 5: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x6f) [0x7fbf588e109f]
[akonadiserver] 6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xa8) [0x40c698]
[akonadiserver] 7: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x6e) [0x7fbf5896ad7e]
[akonadiserver] 8: /usr/lib/libQtCore.so.4(+0xe9b09) [0x7fbf58978b09]
[akonadiserver] 9: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x68) [0x7fbf58979b38]
[akonadiserver] 10: akonadiserver(_ZN6QDebugD1Ev+0x45) [0x406a95]
[akonadiserver] 11: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x5f1) [0x7fbf58f32701]
[akonadiserver] 12: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x4a) [0x7fbf58f3339a]
[akonadiserver] 13: akonadiserver(main+0x3a4) [0x406154]
[akonadiserver] 14: /lib/libc.so.6(__libc_start_main+0xfd) [0x7fbf57958b6d]
[akonadiserver] 15: akonadiserver() [0x405cb9]
[akonadiserver] ]
[akonadiserver] "
ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error)
"akonadiserver" crashed too often and will not be restarted!
akonadictl stop


PuercoPop, proud to be a member of KDE forums since 2008-Oct.
User avatar
anda_skoa
KDE Developer
Posts
783
Karma
4
OS

Re: Akonadi

Thu Dec 24, 2009 9:38 pm
I haven't seen this particular error yet.

Which version of MySQL are you using?

Cheers,
_


anda_skoa, proud to be a member of KDE forums since 2008-Oct.
User avatar
PuercoPop
Registered Member
Posts
15
Karma
0
OS

Re: Akonadi

Fri Dec 25, 2009 12:14 am
I'm using MySQL version 5.1.41-3 with KDE SC 4.3.4 on Arch-Linux.

Btw, Happy Holidays!


PuercoPop, proud to be a member of KDE forums since 2008-Oct.


Bookmarks



Who is online

Registered users: abc72656, Bing [Bot], Google [Bot], lockheed, Yahoo [Bot]