https://bugs.kde.org/show_bug.cgi?id=311185
Bug ID: 311185 Severity: normal Version: 4.10 Priority: NOR Assignee: kdepim-bugs@kde.org Summary: Akonadi/postgresql fail to start due to isVirtual column type Classification: Unclassified OS: Linux Reporter: yne...@gmail.com Hardware: Archlinux Packages Status: UNCONFIRMED Component: general Product: Akonadi Hi, I've tried to use postgresql as database for akonadi. I've created user, base an started akonadi. Table was created but i think column 'isvirtual' in table 'collectiontable' has wrong type, when akonadi start: Sql error: ERROR: column "isvirtual" is of type boolean but expression is of type integer LIGNE 1 : ...sourceId,name,parentId,isVirtual) VALUES (1,'Search',NULL,1) ^ ASTUCE : You will need to rewrite or cast the expression. QPSQL: Unable to create query Query: INSERT INTO CollectionTable (resourceId,name,parentId,isVirtual) VALUES (1,'Search',NULL,1)" Unable to initialize database. "[ 0: akonadiserver(_Z11akBacktracev+0x34) [0x454584] 1: akonadiserver() [0x4548c1] 2: /usr/lib/libc.so.6(+0x35050) [0x7f852cfb9050] 3: /usr/lib/libc.so.6(gsignal+0x35) [0x7f852cfb8fd5] 4: /usr/lib/libc.so.6(abort+0x148) [0x7f852cfba458] 5: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x74) [0x7f852ea70414] 6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0x9b) [0x45663b] 7: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xb4) [0x7f852eb0ab54] 8: /usr/lib/libQtCore.so.4(+0x1167ff) [0x7f852eb157ff] 9: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x3b) [0x7f852eb1ddfb] 10: akonadiserver(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x5e5) [0x4586e5] 11: akonadiserver(_ZN7Akonadi13AkonadiServer8instanceEv+0x47) [0x459897] 12: akonadiserver(main+0x1a0) [0x44d170] 13: /usr/lib/libc.so.6(__libc_start_main+0xf5) [0x7f852cfa5725] 14: akonadiserver() [0x44d971] ] I've tried to manually change type with psql but then: Error during executing query "INSERT INTO CollectionTable (remoteId, remoteRevision, name, resourceId, cachePolicyInherit, cachePolicyCheckInterval, cachePolicyCacheTimeout, cachePolicySyncOnDemand, cachePolicyLocalParts, isVirtual) VALUES (:0, :1, :2, :3, :4, :5, :6, :7, :8, :9) RETURNING id" : "ERROR: parameter $10 of type boolean cannot be coerced to the expected type smallint Reproducible: Always Steps to Reproduce: 1. create pgql base with user. Configure akonadi to use it 2. start akonadi 3. Actual Results: in akonadi logs: Sql error: ERROR: column "isvirtual" is of type boolean but expression is of type integer LIGNE 1 : ...sourceId,name,parentId,isVirtual) VALUES (1,'Search',NULL,1) ^ ASTUCE : You will need to rewrite or cast the expression. QPSQL: Unable to create query Query: INSERT INTO CollectionTable (resourceId,name,parentId,isVirtual) VALUES (1,'Search',NULL,1)" Unable to initialize database. "[ 0: akonadiserver(_Z11akBacktracev+0x34) [0x454584] 1: akonadiserver() [0x4548c1] 2: /usr/lib/libc.so.6(+0x35050) [0x7f852cfb9050] 3: /usr/lib/libc.so.6(gsignal+0x35) [0x7f852cfb8fd5] 4: /usr/lib/libc.so.6(abort+0x148) [0x7f852cfba458] 5: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x74) [0x7f852ea70414] 6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0x9b) [0x45663b] 7: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xb4) [0x7f852eb0ab54] 8: /usr/lib/libQtCore.so.4(+0x1167ff) [0x7f852eb157ff] 9: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x3b) [0x7f852eb1ddfb] 10: akonadiserver(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x5e5) [0x4586e5] 11: akonadiserver(_ZN7Akonadi13AkonadiServer8instanceEv+0x47) [0x459897] 12: akonadiserver(main+0x1a0) [0x44d170] 13: /usr/lib/libc.so.6(__libc_start_main+0xf5) [0x7f852cfa5725] 14: akonadiserver() [0x44d971] ] Expected Results: akonadi should start -- You are receiving this mail because: You are the assignee for the bug. _______________________________________________ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs