Jetspeed 2
  1. Jetspeed 2
  2. JS2-666

Clustered Environment: constraint violation if clones are started at the same time

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 2.1
    • Fix Version/s: 2.1.3, 2.2.0
    • Component/s: Portlet Registry
    • Labels:
      None
    • Environment:
      Websphere Application Server 6.0
      Database DB2 8.2

      Description

      Clustered Environment: constraint violation if clones are started at the same time.

      Exception thrown:

      com.ibm.websphere.ce.cm.DuplicateKeyException: [IBM][CLI Driver][DB2/6000] SQL0803N One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because the primary key, unique constraint or unique index identified by "2" constrains table "PORTLET_APPLICATION" from having duplicate rows for those columns. SQLSTATE=23505

      at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java(Compiled Code))
      at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java(Compiled Code))
      at java.lang.reflect.Constructor.newInstance(Constructor.java(Compiled Code))
      at com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapExceptionHelper(GenericDataStoreHelper.java:502)
      at com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapException(GenericDataStoreHelper.java:545)
      at com.ibm.ws.rsadapter.jdbc.WSJdbcUtil.mapException(WSJdbcUtil.java:902)
      at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeUpdate(WSJdbcPreparedStatement.java:555)
      at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(JdbcAccessImpl.java:216)
      at org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(PersistenceBrokerImpl.java:1754)
      at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImpl.java:813)
      at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(PersistenceBrokerImpl.java:726)

      1. jetspeed-JS2-666-patch.diff
        21 kB
        Joachim Müller
      2. jetspeed-JS2-666-patch2.diff
        23 kB
        Ate Douma

        Activity

        Frank Stalherm created issue -
        Frank Stalherm made changes -
        Field Original Value New Value
        Issue Type Improvement [ 4 ] Bug [ 1 ]
        Joachim Müller made changes -
        Attachment jetspeed-JS2-666-patch.diff [ 12366090 ]
        David Sean Taylor made changes -
        Assignee David Sean Taylor [ taylor ]
        David Sean Taylor made changes -
        Status Open [ 1 ] In Progress [ 3 ]
        Ate Douma made changes -
        Attachment jetspeed-JS2-666-patch2.diff [ 12371302 ]
        Ate Douma made changes -
        Assignee David Sean Taylor [ taylor ] Ate Douma [ adouma ]
        Ate Douma made changes -
        Attachment jetspeed-JS2-666-patch2.diff [ 12371321 ]
        Ate Douma made changes -
        Attachment jetspeed-JS2-666-patch2.diff [ 12371302 ]
        Ate Douma made changes -
        Fix Version/s 2.1.3 [ 12312573 ]
        Ate Douma made changes -
        Status In Progress [ 3 ] Resolved [ 5 ]
        Resolution Fixed [ 1 ]
        Ate Douma made changes -
        Status Resolved [ 5 ] Closed [ 6 ]

          People

          • Assignee:
            Ate Douma
            Reporter:
            Frank Stalherm
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development