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

    • 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

      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

            [RHPAM-740] Kie server with PostgreSQL 9.6 fails when its pod is restarted

            Marek Novotny added a comment -

            Closing as issue was Verified/Release Pending

            Marek Novotny added a comment - Closing as issue was Verified/Release Pending

            RH Bugzilla Integration added a comment -

            Oneata Mircea Teodor <toneata@redhat.com> changed the Status of bug 1547424 from MODIFIED to CLOSED

            RH Bugzilla Integration added a comment - Oneata Mircea Teodor <toneata@redhat.com> changed the Status of bug 1547424 from MODIFIED to CLOSED

            Jiri Petrlik added a comment -

            Verified using images for RHPAM 7.0.CR1.

            Jiri Petrlik added a comment - Verified using images for RHPAM 7.0.CR1.

            RH Bugzilla Integration added a comment -

            errata-xmlrpc <errata-xmlrpc@redhat.com> changed the Status of bug 1572682 from RELEASE_PENDING to CLOSED

            RH Bugzilla Integration added a comment - errata-xmlrpc <errata-xmlrpc@redhat.com> changed the Status of bug 1572682 from RELEASE_PENDING to CLOSED

            David Ward added a comment - - edited

            czhu_jira The new jdbc driver is now available here, so we don't need any code changes anymore - just a new build (and the latest version of the driver should be picked up). Can you please re-test with just a normal build (no code changes).

            David Ward added a comment - - edited czhu_jira The new jdbc driver is now available here , so we don't need any code changes anymore - just a new build (and the latest version of the driver should be picked up). Can you please re-test with just a normal build (no code changes).

            calvin zhu (Inactive) added a comment -

            I built with the new repo, and tested it, works fine after redeploy or scale up/ down the kie server, no exception found in the log.

            I rsh to the pod, compare the jar,

            this is the new one:
            rw-rr-. 1 root root 446317 Apr 20 10:40 postgresql-jdbc.jar

            this is the old one:
            rw-rr-. 1 root root 446067 Dec 28 2013 postgresql-jdbc.jar

            calvin zhu (Inactive) added a comment - I built with the new repo, and tested it, works fine after redeploy or scale up/ down the kie server, no exception found in the log. I rsh to the pod, compare the jar, this is the new one: rw-r r -. 1 root root 446317 Apr 20 10:40 postgresql-jdbc.jar this is the old one: rw-r r -. 1 root root 446067 Dec 28 2013 postgresql-jdbc.jar

            calvin zhu (Inactive) added a comment -

            sure.

            calvin zhu (Inactive) added a comment - sure.

            RH Bugzilla Integration added a comment -

            Pavel Raiskup <praiskup@redhat.com> changed the Status of bug 1547424 from NEW to ASSIGNED

            RH Bugzilla Integration added a comment - Pavel Raiskup <praiskup@redhat.com> changed the Status of bug 1547424 from NEW to ASSIGNED

            Lukáš Petrovický (Inactive) added a comment -

            KrisVerlaenen Can we please get the ACK here?

            Lukáš Petrovický (Inactive) added a comment - KrisVerlaenen Can we please get the ACK here?

            calvin zhu (Inactive) added a comment -

            Hi Filppe,
            Yeah, Babak sent email to Pavel asking for new rpm, not reply yet.

            calvin zhu (Inactive) added a comment - Hi Filppe, Yeah, Babak sent email to Pavel asking for new rpm, not reply yet.

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

                Created:
                Updated:
                Resolved: