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

BPEL - Domain mode - Deployment throws MySQLIntegrityConstraintViolationException

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: jboss-fuse-6.2.1
    • Fix Version/s: jboss-fuse-6.3
    • Component/s: Fuse EAP, SwitchYard
    • Labels:
      None

      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 (?, ?, ?, ?)
      

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  tcunning Thomas Cunningham
                  Reporter:
                  mbasovni Martin Basovnik
                  Tester:
                  Martin Basovnik
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  4 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: