[ 
https://issues.apache.org/jira/browse/JAMES-2828?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Benoit Tellier closed JAMES-2828.
---------------------------------
    Fix Version/s: 3.5.0
       Resolution: Fixed

> 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.
>            Priority: Major
>              Labels: postgresql
>             Fix For: 3.5.0
>
>         Attachments: stacktrace.txt
>
>          Time Spent: 1h 50m
>  Remaining Estimate: 0h
>
> 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
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to