Bug 323856 - Can't get new e-mail with postgresql backend
Summary: Can't get new e-mail with postgresql backend
Status: RESOLVED UPSTREAM
Alias: None
Product: Akonadi
Classification: Frameworks and Libraries
Component: IMAP resource (show other bugs)
Version: 4.11
Platform: Kubuntu Linux
: NOR normal
Target Milestone: ---
Assignee: Kevin Ottens
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-08-21 19:21 UTC by Ferry
Modified: 2013-10-16 01:03 UTC (History)
4 users (show)

See Also:
Latest Commit:
Version Fixed In:

Attachments
Add an attachment

Note You need to log in before you can comment on or make changes to this bug.
Description Ferry 2013-08-21 19:21:25 UTC 
When using the postgresql backend (either internal or external) Akonadi Console records "NO Unable to add item flags. " and stops updating the list of messages. This is regardless of setting the "standard_conforming_strings = on" option. Other usefull messages:
* 52228 FETCH (UID 52228 REV 2 REMOTEID "1" MIMETYPE "message/rfc822" COLLECTIONID 4443 SIZE 18092 FLAGS (\SEEN \ANSWERED)) 
3610 OK FETCH completed 
3611 BEGIN 
3611 OK Begin completed 
3612 UID STORE 98278 NOREV SIZE 0 (REMOTEID "2" +FLAGS ($ATTACHMENT \SEEN) PLD:HEAD[1] {649} 
3612 NO Unable to add item flags. 
3614 ROLLBACK 
3614 OK Rollback completed 

Note this occurs after updating to 4.11, before the update I had the postgresql backend working fine (and better then the mysql backend. 

Dropping the akonadi database in my external sql server and rebuilding new did not solve the problem.

Only switching back to mysql get my e-mail functioning for now.

Reproducible: Always

Steps to Reproduce:
1.In Akonadi server configuration switch to postgresql backend (internal) - make sure the backend is installed first.
2.In Akonadi Console enable the debugger
3.
Comment 1 Jekyll Wu 2013-08-22 10:25:57 UTC 
probably this Qt-4.8.5  bug [1]

[1]http://cgbdx.wordpress.com/2013/07/17/note-for-the-akonadi-pgsql-users/
Comment 2 Ferry 2013-08-22 13:27:46 UTC 
I think not.

I am on Quantal which has libqt4-* 4.8.3. Also I experienced the same problem on raring which has 4.8.4. The article you reference recommends to stay at or downgrade to 4.8.4.

Don't forget before updating to kde 4.11 I had 4.10 which worked fine.

I left the status resolved upstream, but can you confirm this is really the case (i.e. did you check)?

Ferry
Comment 3 Ian Turner 2013-10-15 02:18:13 UTC 
I'm seeing this issue using libqt4-sql-psql 4:4.8.2+dfsg-2. The Akonadi console output has messages like:

Error during executing query "INSERT INTO PimItemFlagRelation (PimItem_id, Flag_id) VALUES (:0, :1) RETURNING id" :  "ERROR:  syntax error at or near "("
LINE 1: EXECUTE  (121022, 9)
                 ^
QPSQL: Unable to create query"

This does not seem to match the linked upstream bug.
Comment 4 Ian Turner 2013-10-15 02:19:44 UTC 
The importance of this bug should also be raised to "Grave", since Akonadi is almost useless without a fix.
Comment 5 Daniel Vrátil 2013-10-15 05:55:50 UTC 
What version of PostgreSQL (pg_ctl --version) and Akonadi (akonadictl --version) do you have?
Comment 6 Ian Turner 2013-10-15 10:10:06 UTC 
postgresql: 9.1.9-0ubuntu12.04
akonadi: 1.10.1-0ubuntu1~ubuntu12.04~ppa1
libqt4-sql-psql: 4:4.8.2+dfsg-2ubuntu1~precise1~ppa5
Comment 7 Ian Turner 2013-10-16 01:03:29 UTC 
Seems like this is an akonadi problem, fixed in 1.10.3.