Uploaded image for project: 'James Server'
  1. James Server
  2. JAMES-2828

JDBC Mail Repository fails to save message into PostgreSQL when per recipient headers are absent

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.3.0, 3.4.0
    • Fix Version/s: 3.5.0
    • Labels:
    • 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

      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.

        Attachments

        1. stacktrace.txt
          7 kB
          Sergey B.

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                sergey-b Sergey B.
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 1h 50m
                  1h 50m