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

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.3.0, 3.4.0
• Fix Version/s: 3.5.0
• Component/s: JDBC, MailStore & MailRepository
• Labels: postgresql
• 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
• Assignee: Unassigned
• Reporter: Sergey B.
• Created: 15/Jul/19 01:29
• Updated: 31/Oct/19 09:59
• Resolved: 31/Oct/19 09:59

Description

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

 

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.

 

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.

Issue Links

• links to: GitHub Pull Request #173