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

H2 data file gets locked during rollout deployment strategy in authoring templates

    XMLWordPrintable

Details

    • Bug
    • Status: Verified (View Workflow)
    • Major
    • Resolution: Done
    • 7.3.0.GA, 7.3.1.GA
    • 7.4.0.GA
    • Cloud
    • Openshift with authoring template

    • 2019 Week 20-22

    Description

      Today, when using the rhpam-authoring.yaml template to create a BC + Kieserver environment, the database H2 data file gets locked if the Kieserver pod needs to rollout for some reason (like a env variable update):

              Caused by: java.lang.IllegalStateException: The file is locked: nio:/opt/eap/standalone/data/rhpam.mv.db [1.4.193/7]
      
          	at com.h2database.h2@1.4.193.redhat-2//org.h2.mvstore.DataUtils.newIllegalStateException(DataUtils.java:766)
          	at com.h2database.h2@1.4.193.redhat-2//org.h2.mvstore.FileStore.open(FileStore.java:173)
          	at com.h2database.h2@1.4.193.redhat-2//org.h2.mvstore.MVStore.<init>(MVStore.java:348)
          	at com.h2database.h2@1.4.193.redhat-2//org.h2.mvstore.MVStore$Builder.open(MVStore.java:2923)
          	at com.h2database.h2@1.4.193.redhat-2//org.h2.mvstore.db.MVTableEngine$Store.open(MVTableEngine.java:154)
          	... 37 more
      

      This happens because:

      1) The JDBC connection URL is opening for local use only, locking the file for a single process use
      2) The /opt/eap/standalone/data directory is being used to mount the H2 data file. This directory is not supposed to be used for any reason, since it's used by the Artemis ActiveMQ and is locked by it.

      We need to address this bug by implementing the H2 Mixed Mode into the URL for every datasource using this database in the template (rhpam and rhpam_EJB_Timer).

      Attachments

        Issue Links

          Activity

            People

              rhn-support-zanini Ricardo Zanini Fernandes
              rhn-support-zanini Ricardo Zanini Fernandes
              Jakub Schwan Jakub Schwan
              Jakub Schwan Jakub Schwan
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: