You are viewing a plain text version of this content. The canonical link for it is here.
Posted to server-dev@james.apache.org by "Benoit Tellier (Jira)" <se...@james.apache.org> on 2019/10/31 10:00:04 UTC
[jira] [Closed] (JAMES-2828) JDBC Mail Repository fails to save
message into PostgreSQL when per recipient headers are absent
[ 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: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org