| Summary: | Can't get new e-mail with postgresql backend | ||
|---|---|---|---|
| Product: | [Frameworks and Libraries] Akonadi | Reporter: | Ferry <ferry.toth> |
| Component: | IMAP resource | Assignee: | Kevin Ottens <ervin> |
| Status: | RESOLVED UPSTREAM | ||
| Severity: | normal | CC: | dvratil, kdepim-bugs, vectro, vkrause |
| Priority: | NOR | ||
| Version: | 4.11 | ||
| Target Milestone: | --- | ||
| Platform: | Kubuntu | ||
| OS: | Linux | ||
| Latest Commit: | Version Fixed In: | ||
| Sentry Crash Report: | |||
probably this Qt-4.8.5 bug [1] [1]http://cgbdx.wordpress.com/2013/07/17/note-for-the-akonadi-pgsql-users/ 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 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.
The importance of this bug should also be raised to "Grave", since Akonadi is almost useless without a fix. What version of PostgreSQL (pg_ctl --version) and Akonadi (akonadictl --version) do you have? 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 Seems like this is an akonadi problem, fixed in 1.10.3. |
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.