[jira] [Created] (JAMES-2828) JDBC Mail Repository fails to save message into PostgreSQL when per recipient headers are absent

["Sergey B. (JIRA)" <se...@james.apache.org>]

Sergey B. created JAMES-2828:
--------------------------------

             Summary: JDBC Mail Repository fails to save message into PostgreSQL when per recipient headers are absent
                 Key: JAMES-2828
                 URL: https://issues.apache.org/jira/browse/JAMES-2828
             Project: James Server
          Issue Type: Bug
          Components: JDBC, MailStore & MailRepository
    Affects Versions: 3.3.0, 3.4.0
         Environment: PostgreSQL 9.6.8 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-16), 64-bit

PostgreSQL JDBC Driver 42.2.6

docker images:
linagora/james-jpa-spring:latest
linagora/james-jpa-spring:3.3.x
            Reporter: Sergey B.


If a message doesn't contain per recipient headers it is not saved into repository in PostgreSQL. The exception message is

 
{code:java}
org.postgresql.util.PSQLException: ERROR: column "per_recipient_headers" is of type bytea but expression is of type oid
    Hint: You will need to rewrite or cast the expression.{code}
 

There is a workaround changing the type of per_recipient_headers from bytea to oid. But it certainly will fail, when per recipient headers show up.



--
This message was sent by Atlassian JIRA
(v7.6.14#76016)

---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org