On Wednesday, July 17, 2013 09:28:00 Pino Toscano wrote:
> Hi,
>
> Alle mercoledì 17 luglio 2013, Chris Knadle ha scritto:
> > After migrating to KMail2 at first I had this same issue (mail stuck
> > in local outbox and no attempt to send the email occurs), but
> > logging out and in again worked in my case when the akonadi backend
> > is MySQL.
> >
> > The behavior when using a akonadi backend of PosgreSQL (which
> > requires some manual setup to get working) seems different; email
> > can be sent on the first try, but I run into intolerable issues when
> > trying to _read_ email because the list of folders show up, but 90%
> > of the emails that they contain do not. Of the several thousand
> > emails I have in IMAP, about 200 of them show up after 2 days of
> > indexing, with lots of errors going to Postgresql log. :-( The
> > postgresql 9.1 log is 649 MiB and contains about 9 million lines of
> >
> > this:
> > 2013-07-16 17:51:52 EDT ERROR: invalid input syntax for type bytea
> >
> > at character 24 2013-07-16 17:51:52 EDT STATEMENT: EXECUTE
> > qpsqlpstmt_7d ('\SEEN') 2013-07-16 17:51:52 EDT ERROR: invalid
> > input syntax for type bytea at character 24 2013-07-16 17:51:52 EDT
> > STATEMENT: EXECUTE qpsqlpstmt_7d ('\SEEN') ...
>
> This is mostly caused by #716922.
I agree.
> > I'll open a separate bug report about the above; the only reason I'm
> > mentioning it here is in relation to differences in behavior I see
> > concerning sending email.
>
> Of course there is a difference in behaviour, considering the pgsql
> access if broken due to the regression in qt4-sql-pgsql, so I'm not sure
> what this bug would be about then, if you reported a new #717117 (which
> is a duplicate of #716922).
Sorry for the duplicate report. Thanks very much for letting me know about
#716922 ... I'm going to go run a test with standard_conforming_strings=off to
see if that's a possible workaround.
-- Chris
--
Chris Knadle
Chris.Knadle@coredump.usAttachment:
signature.asc
Description: This is a digitally signed message part.