Uploaded image for project: 'Red Hat Fuse'
  1. Red Hat Fuse
  2. ENTESB-4160

BPEL - Domain mode - Deployment throws MySQLIntegrityConstraintViolationException

    XMLWordPrintable

Details

    • 6.3 Sprint 2 (1-Feb - 26-Feb)

    Description

      When you deploy a BPEL application in domain mode to several servers you will get ConstraintViolationException exception:

      09:54:23,182 ERROR [org.apache.ode.store.ProcessStoreImpl] (ProcessStoreImpl-1) Error persisting deployment record for {http://www.jboss.org/bpel/examples}SayHello-0; process will not be available after restart!: javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute batch
      ...
      Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'switchyard-bpel-say-hello_SayHello-0' for key 'PRIMARY'
      

      This is caused by the following command which is executed once for each server.

      11:31:34,828 INFO  [stdout] (ProcessStoreImpl-1) Hibernate: insert into STORE_DU (DEPLOYDT, DEPLOYER, DIR, NAME) values (?, ?, ?, ?)
      

      Attachments

        Issue Links

          Activity

            People

              tcunning@redhat.com Thomas Cunningham
              mbasovni Martin Basovnik (Inactive)
              Martin Basovnik Martin Basovnik (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: