Re: Problems with postgresql akonadi after upgrade

On Tuesday 15 of October 2013 09:44:26 Shridhar Daithankar wrote:
> On Monday, October 14, 2013 10:25:09 PM [email protected] wrote:
> > Hi all,
> > 
> > After upgrading to KDE 4.11.2, kmail no longer works. I can't update any
> > folders (including sending mail). The message I get from kmail is "Unable
> > to append item flags" (when sending) or "Unable to add item flags" (for
> > other operations). However, in all cases, Akonadi prints something like
> > this on the console:
> > 
> > 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  (121352, 7)
> > 
> >                  ^
> > 
> > QPSQL: Unable to create query"
> > 
> > This seems similar to Bug 323856
> > https://bugs.kde.org/show_bug.cgi?id=323856, although it's hard to say
> > since that one hasn't been diagnosed.
> > 
> > The consequences of this are pretty grave, as it makes kmail nearly
> > useless for me. Any advice on how to proceed?
> 
> Only problem I had with postgresql backend was messages were not marked as
> read. For about 3-4 months, I had to live with all messages being unread.
> 
> And with akonadi 1.10.3, it got fixed. At no point, kmail was unable to
> send/receive email.
> 
> Is it feasible for you to upgrade akonadi?
> 
> I have kmail 4.11.2/akonadi 1.10.3/postgresql 9.3.1 happily working here on
> archlinux.

Note that Qt 4.8.5 is needed to work properly with the configuration above.

> 
> HTH.

-- 
Daniel Vrátil
KDE Desktop Team
Associate Software Engineer, Red Hat, Inc.

GPG Key: 0xC59D614F6F4AE348
Fingerprint: 4EC1 86E3 C54E 0B39 5FDD B5FB C59D 614F 6F4A E348

_______________________________________________
KDE PIM users mailing list
Subscription management: https://mail.kde.org/mailman/listinfo/kdepim-users

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.19 (GNU/Linux)

iQEcBAABAgAGBQJSXNtcAAoJEMWdYU9vSuNIp1EIAK0t6ZA1Czpqy9YdN8mAT84N
8l7PHXnTO8mX31ckKiXkkYvlTVC54Ip4CbLXdywXOk236hN4BPkqK7wadMG2IpyE
Mk/wU+Od7oQ4O84ORqDUuIjPRZl9yX+qt7hNS6/JLk8CVR+ChKiicyB4K+NBFiw+
XNj4nnpcT/b2NF0xM/5sRS4mvBXd67lUHtM0Qgu43ZpxFJqRvJgMdCGqs9Br25AJ
NtCOyN2erBgymcltoKnngl9KL1z6ESl8tT6JRgNBgB8b8DniSbSQM5QFHo5ilgl1
ryunXTpxhCcK2XvQP19NosDMrnCF4klO5iCrCOKlIDeKLyTt+jVgBDv3vFVREKE=
=aoHC
-----END PGP SIGNATURE-----