[Bug 267807] New: Message status cannot be changed to "read" with postgresql backend

[S.Trzmiel]

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

           Summary: Message status cannot be changed to "read" with
                    postgresql backend
           Product: Akonadi
           Version: 1.5.0
          Platform: Fedora RPMs
        OS/Version: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: NOR
         Component: server
        AssignedTo: kdepim-bugs at kde.org
        ReportedBy: xeno at bmp.net.pl


Version:           1.5.0 (using KDE 4.6.1) 
OS:                Linux

In last few days I experienced some problems with high memory usage of MySql
akonadi backend (mysql crossed 100MB of used ram) so decided to give Postgresql
backend a try.
I created user akonadi then database with sql query:

CREATE DATABASE akonadi
  WITH OWNER = akonadi

       TABLESPACE = pg_default
       CONNECTION LIMIT = -1;

Additional parameters were added ny postgresql as database default parameters:
       ENCODING = 'UTF8'
       LC_COLLATE = 'pl_PL.UTF-8'
       LC_CTYPE = 'pl_PL.UTF-8'

Akonadi serwer statred properly without any errors but, after db backed switch
KMail couldn't change message status. All the mails has "unread" status Also
empty folders shows they contain 1 unread message.
Marking messages/folders as read manually also doesn't work,.

That's example message from Akonadi konsole when I tried to manually mark the
message:
------------------------------------------
kmail2-876347754 (0x9964e88) 45 OK UID FETCH completed 
kmail2-876347754 (0x9964e88) 46 UID STORE 2599 REV 2 (REMOTEID
"1293633982.25466.emKPp:2,S" +FLAGS (\SEEN) ATR:MDNStateAttribute "I") 
kmail2-876347754 (0x9964e88) 46 NO Unable to create flag 
kmail2-876347754 (0x9964e88) 48 UID STORE 2599 REV 2 (REMOTEID
"1293633982.25466.emKPp:2,S" +FLAGS (\SEEN)) 
kmail2-876347754 (0x9964e88) 48 NO Unable to create flag 
-------------------------------------------------------------------------------------

Flags (as activity, important, tracked/ignored) works propeerly.
Also I believe unablility to set message status causes my imap folders fail to
synchronize.

------------------------------------------------------------------------
Version of related software:

Fedora 14
KDE 4.6.1

kdepim-4.5.94.1-4.fc14.i686
akonadi-1.5.0-0.1.fc14.i686
postgresql-server-8.4.7-1.fc14.i686

Reproducible: Always

Steps to Reproduce:
Create akonadi user and db in postgres.
Stop akonadi server, switch db backend, start akonadi again
Launch kmail2

Actual Results:  
Messages status cannot be changed, it's permanently set as "unread".

Expected Results:  
Maunal/automatic unread -> read status change is possible

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