| Summary: | Akonadi Crashes. Unable to create entire table | ||
|---|---|---|---|
| Product: | [Frameworks and Libraries] Akonadi | Reporter: | Javier Olaechea <pirata> |
| Component: | general | Assignee: | Volker Krause <vkrause> |
| Status: | RESOLVED WORKSFORME | ||
| Severity: | normal | CC: | christophe, kdepim-bugs, tokoe |
| Priority: | NOR | ||
| Version: | 4.4 | ||
| Target Milestone: | --- | ||
| Platform: | Arch Linux | ||
| OS: | Linux | ||
| Latest Commit: | Version Fixed In: | ||
| Sentry Crash Report: | |||
Does it work if you downgrade mysql to 5.1.42 ? Apparently I am using version 5.1.42 [pirata@myhost ~]$ mysql --version mysql Ver 14.14 Distrib 5.1.42, for unknown-linux-gnu (x86_64) using readline 6.1 Hope it helps. Hej, does it still happen with KDE 4.4.5? Ciao, Tobias I already fixed it a while ago, can't seem to remeber how. I think i had to create tables by hand. Anyhow I should have closed to the report. |
Version: (using KDE 4.4.0) OS: Linux Installed from: Archlinux Packages [pirata@myhost ~]$ akonadictl start Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString) Starting Akonadi Server... Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString) done. [akonadiserver] search paths: ("/opt/opencascade/bin", "/bin", "/usr/bin", "/sbin", "/usr/sbin", "/opt/kde/bin", "/usr/bin/perlbin/site", "/usr/bin/perlbin/vendor", "/usr/bin/perlbin/core", "/opt/qt/bin", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin") [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 CollectionTable(id) ON DELETE CASCADE ON UPDATE CASCADE, mimeTypeId BIGINT REFERENCES MimeTypeTable(id) ON DELETE CASCADE ON UPDATE CASCADE, 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' QMYSQL: Unable to execute query'" [akonadiserver] Unable to initialize database. [akonadiserver] "[ [akonadiserver] 0: akonadiserver(_Z11akBacktracev+0x39) [0x40b1c9] [akonadiserver] 1: akonadiserver() [0x40b712] [akonadiserver] 2: /lib/libc.so.6(+0x320b0) [0x7f89ed99a0b0] [akonadiserver] 3: /lib/libc.so.6(gsignal+0x35) [0x7f89ed99a035] [akonadiserver] 4: /lib/libc.so.6(abort+0x180) [0x7f89ed99b460] [akonadiserver] 5: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x6f) [0x7f89eeb4631f] [akonadiserver] 6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xa8) [0x40c758] [akonadiserver] 7: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x78) [0x7f89eebd5e38] [akonadiserver] 8: /usr/lib/libQtCore.so.4(+0x10b5d9) [0x7f89eebe65d9] [akonadiserver] 9: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x39) [0x7f89eebe77d9] [akonadiserver] 10: akonadiserver(_ZN6QDebugD1Ev+0x4e) [0x4067ce] [akonadiserver] 11: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x5f7) [0x7f89eefb4347] [akonadiserver] 12: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x4a) [0x7f89eefb50ba] [akonadiserver] 13: akonadiserver(main+0x3ac) [0x405dec] [akonadiserver] 14: /lib/libc.so.6(__libc_start_main+0xfd) [0x7f89ed986b6d] [akonadiserver] 15: akonadiserver() [0x405949] [akonadiserver] ] [akonadiserver] " ProcessControl: Application 'akonadiserver' returned with exit code 255 (Unknown error) I think The critical Part is " [akonadiserver] "CREATE TABLE PimItemTable (id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT, rev INTEGER NOT NULL DEFAULT 0, remoteId TEXT , collectionId BIGINT REFERENCES CollectionTable(id) ON DELETE CASCADE ON UPDATE CASCADE, mimeTypeId BIGINT REFERENCES MimeTypeTable(id) ON DELETE CASCADE ON UPDATE CASCADE, 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' QMYSQL: Unable to execute query'" "