Re: problem with postgresql backend

Hi,

there has been a regression in PostgreSQL support in Akonadi 1.10.0 and 
1.10.1. It has been fixed 1.10.2, which is already in [extra].

Please update to 1.10.2 and see whether it still happens.

Cheers,
Dan

On Friday 26 of July 2013 11:03:37 Shridhar Daithankar wrote:
> Hello,
> 
> I have been facing some strange problems lately. I was using postgresql
> backend(version 9.2.4)
> 
> First, all the mails were marked as unread with errors such as
> -------
> (22P02) QPSQL: Unable to create query"
> Error during executing query "SELECT id, name FROM FlagTable WHERE ( name =
> (
> :0 ) )" :  "ERROR:  invalid input syntax for type bytea
> 
> LINE 1: EXECUTE qpsqlpstmt_2f ('\SEEN')
> -------
> 
> logged all over in .xsession-error and akonadi logs. Googling tells me that
> its a problem with qt4 4.8.5 postgresql driver.
> 
> Not a show stopper, I can live with it till its fixed.
> 
> but since last two days, I was unable to download any mails from one of the
> pop accounts, nor send it using the smtp account for the same. The error was
> "unable to store downloaded item." while downloading the same.
> 
> Strangely my gmail pop account was working fine.
> 
> Finally since I could not afford to lose access to mail, I switched to mysql
> backend, everything is working fine.
> 
> how can I debug this and turn it into a reasonable bug report?
> 
> environment
> archlinux : 3.9.9/3.10.2
> KDE : 4.10.5
> kmail : 4.10.5
> Postgresql : 9.2.4
> 
> Thanks

-- 
Daniel Vrátil
Associate Software Engineer, KDE Desktop Team
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)

iQEcBAABAgAGBQJR8jjUAAoJEMWdYU9vSuNIJkwH/3kD1i4HnGoZYScapzZvqO1P
qvR54jtz51/gUSmhTob9GglD8+/sINCcX4YseIFU8mQpG7/VCbblSL6l8M45Zw8p
q+hwRn0t/TprssFsSOhr6RiPUc/aQaPotRJLWtNi94tCCFtDt0RIL1YwH1MRy5/9
Otr4f59oMFgXr74d9IivLJyUr7FWR6GuoGhF6rQFERwX2tt/WCt+aBXafhUliUZA
x2I0oZgMO/0c5ihIwkTBZPEEmecFmE9mF2HmbG6mhljM6HQfkXzazNafCUqufWwy
zIp6Vqc6qJjUoekG2+UR5s/M/RB/yQxLBjrhX/mPkzf9yX4NseFWgxPzn5ZXuiA=
=6p3e
-----END PGP SIGNATURE-----