Uploaded image for project: 'Red Hat Process Automation Manager'
  1. Red Hat Process Automation Manager
  2. RHPAM-740

Kie server with PostgreSQL 9.6 fails when its pod is restarted

    XMLWordPrintable

Details

    • CR1
    • Hide
      • Run execution server with PostgreSQL 9.6 using "bpmsuite70-executionserver-externaldb" template
      • Scale number of execution server pods to 0
      • Scale number of execution server pods back to 1
      • Execution server will not be able to correctly connect to the database
      Show
      Run execution server with PostgreSQL 9.6 using "bpmsuite70-executionserver-externaldb" template Scale number of execution server pods to 0 Scale number of execution server pods back to 1 Execution server will not be able to correctly connect to the database

    Description

      KIE server fails when its pod is restarted. Following exception can be found in log:
      org.postgresql.util.PSQLException: ERROR: column am.amcanorder does not exist
      Position: 407

      This bug appears only when Kie server uses PostgreSQL 9.6 database. It works correctly with PostgreSQL 9.3 and MySQL 5.7. Problem is probably caused by old version of PostgreSQL driver in our images: 9.2-1002. See folder: /opt/eap/modules/system/layers/openshift/org/postgresql/main/META-INF/maven

      Attachments

        Issue Links

          Activity

            People

              czhu_jira calvin zhu (Inactive)
              jpetrlik@redhat.com Jiri Petrlik
              Jiri Petrlik Jiri Petrlik
              Votes:
              0 Vote for this issue
              Watchers:
              10 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: