Uploaded image for project: 'Syncope'
  1. Syncope
  2. SYNCOPE-21

ACT_HI_ACTINST:Unique index or primary key violation on non-empty database

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 1.0.0-incubating
    • Fix Version/s: 1.0.0-incubating
    • Component/s: core
    • Labels:
    • Environment:
      Console in embedded mode.

      Description

      When starting with an empty database, Activiti just creates its own tables and everything goes smooth: when, instead, the database is already populated (including Activiti tables), an exception is thrown, reported below.

      I can guess that this is happening because there is a sort of incremental mechanism for generating ids that does not take into account existing rows on ACT_HI_ACTINST table.

      org.apache.ibatis.exceptions.PersistenceException:

      Error updating database. Cause: org.apache.openjpa.lib.jdbc.ReportingSQLException: Unique index or primary key violation: "PRIMARY_KEY_FB0 ON PUBLIC.ACT_HI_ACTINST(ID_)"; SQL statement:
      insert into ACT_HI_ACTINST (
      ID_,
      PROC_DEF_ID_,
      PROC_INST_ID_,
      EXECUTION_ID_,
      ACT_ID_,
      ACT_NAME_,
      ACT_TYPE_,
      ASSIGNEE_,
      START_TIME_,
      END_TIME_,
      DURATION_
      ) values (
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?
      ) [23505-164]

      {prepstmnt 2118016446 insert into ACT_HI_ACTINST ( ID_, PROC_DEF_ID_, PROC_INST_ID_, EXECUTION_ID_, ACT_ID_, ACT_NAME_, ACT_TYPE_, ASSIGNEE_, START_TIME_, END_TIME_, DURATION_ ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) [params=?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?]}

      [code=23505, state=23505]
      at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:247) ~[openjpa-all-2.2.0.jar:2.2.0]
      at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:223) ~[openjpa-all-2.2.0.jar:2.2.0]
      at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$1000(LoggingConnectionDecorator.java:72) ~[openjpa-all-2.2.0.jar:2.2.0]
      at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.execute(LoggingConnectionDecorator.java:1258) ~[openjpa-all-2.2.0.jar:2.2.0]
      at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:367) ~[openjpa-all-2.2.0.jar:2.2.0]
      at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.execute(JDBCStoreManager.java:1768) ~[openjpa-all-2.2.0.jar:2.2.0]
      at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:367) ~[openjpa-all-2.2.0.jar:2.2.0]
      at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:22) ~[mybatis-3.0.6.jar:3.0.6]
      at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:51) ~[mybatis-3.0.6.jar:3.0.6]
      at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:29) ~[mybatis-3.0.6.jar:3.0.6]
      at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:88) ~[mybatis-3.0.6.jar:3.0.6]
      at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:43) ~[mybatis-3.0.6.jar:3.0.6]
      at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:122) ~[mybatis-3.0.6.jar:3.0.6]
      ... 90 common frames omitted
      16:46:49.775 ERROR

        Attachments

        1. issue-21.patch
          211 kB
          Massimiliano Perrone
        2. issue-21.patch
          3 kB
          Massimiliano Perrone
        3. issue-21.patch
          3 kB
          Massimiliano Perrone

          Issue Links

            Activity

              People

              • Assignee:
                massi Massimiliano Perrone
                Reporter:
                fmartelli fabio martelli
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: