[Bug 252120] New: Akonadi fails to start with postgres backend. Possibly due to wrong escape '\\ANSWERED'

[Esben Mose Hansen]

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

           Summary: Akonadi fails to start with postgres backend. Possibly
                    due to wrong escape '\\ANSWERED'
           Product: Akonadi
           Version: 4.5
          Platform: Unlisted Binaries
        OS/Version: Linux
            Status: NEW
          Severity: crash
          Priority: NOR
         Component: general
        AssignedTo: kdepim-bugs at kde.org
        ReportedBy: kde at mosehansen.dk


Version:           4.5 (using KDE 4.5.1) 
OS:                Linux

Akonadi stopped working with postgres backend. I get this when I drop akonadi

Reproducible: Always

Steps to Reproduce:
just set up postgresql backend and run akonadictl start. If not the first time,
drop the akonadi database first.

Actual Results:  
[akonadiserver] "INSERT INTO FlagTable (name) VALUES ('has_attachment')"
[akonadiserver] "INSERT INTO FlagTable (name) VALUES ('spam')"
[akonadiserver] "INSERT INTO FlagTable (name) VALUES ('\\ANSWERED')"
[akonadiserver] WARNING:  nonstandard use of \\ in a string literal
[akonadiserver] LINE 1: INSERT INTO FlagTable (name) VALUES ('\\ANSWERED')
[akonadiserver] ^
[akonadiserver] HINT:  Use the escape string syntax for backslashes, e.g.,
E'\\'.
[akonadiserver] "Unable to add initial data to table 'FlagTable'.
[akonadiserver] Query error: 'ERROR:  invalid input syntax for type bytea
[akonadiserver] LINE 1: INSERT INTO FlagTable (name) VALUES ('\\ANSWERED')
[akonadiserver] ^
[akonadiserver] QPSQL: Unable to create query'
[akonadiserver] Query was: INSERT INTO FlagTable (name) VALUES ('\\ANSWERED')"
[akonadiserver] Unable to initialize database.
[akonadiserver] "[
[akonadiserver] 0: akonadiserver(_Z11akBacktracev+0x39) [0x40b679]
[akonadiserver] 1: akonadiserver() [0x40bba2]
[akonadiserver] 2: /lib/libc.so.6(+0x321e0) [0x7fe616fd41e0]
[akonadiserver] 3: /lib/libc.so.6(gsignal+0x35) [0x7fe616fd4165]
[akonadiserver] 4: /lib/libc.so.6(abort+0x180) [0x7fe616fd6f70]
[akonadiserver] 5:
/usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x6f)
[0x7fe6181b6c7f]
[akonadiserver] 6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xa8)
[0x40cc98]
[akonadiserver] 7: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x77)
[0x7fe618245017]
[akonadiserver] 8: /usr/lib/libQtCore.so.4(+0x11d969) [0x7fe618252969]
[akonadiserver] 9: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x39)
[0x7fe618253b69]
[akonadiserver] 10:
/usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x6c1)
[0x7fe6186297c1]
[akonadiserver] 11:
/usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x4a)
[0x7fe61862ab7a]
[akonadiserver] 12: akonadiserver(main+0x404) [0x4064e4]
[akonadiserver] 13: /lib/libc.so.6(__libc_start_main+0xfd) [0x7fe616fc0c4d]
[akonadiserver] 14: akonadiserver() [0x405fe9]
[

Later on it loops a few times trying to alter the database but failing since
the columns are already there.

Expected Results:  
Well, starting would be nice.

-- 
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.