[Bug 311185] New: Akonadi/postgresql fail to start due to isVirtual column type

[Yann Neveu]

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

            Bug ID: 311185
          Severity: normal
           Version: 4.10
          Priority: NOR
          Assignee: kdepim-bugs at kde.org
           Summary: Akonadi/postgresql fail to start due to isVirtual
                    column type
    Classification: Unclassified
                OS: Linux
          Reporter: yneveu at 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.