org.h2.jdbc.JdbcSQLException: Unique index or primary key violation: "ACT_UNIQ_PROCDEF_INDEX_6 ON PUBLIC.ACT_RE_PROCDEF(KEY_, VERSION_, TENANT_ID_) VALUES ( /* key:7 */ 'tasktestid:5:69', 1, 'http://www.activiti.org/test', 'tasktestname', 'tasktestid', 5, '53', 'com/jsits/bpm/activiti/test/task/taskTest.bpmn', 'com/jsits/bpm/activiti/test/task/taskTest.tasktestid.png', NULL, FALSE, TRUE, 1, '')"; SQL statement: insert into ACT_RE_PROCDEF(ID_, REV_, CATEGORY_, NAME_, KEY_, VERSION_, DEPLOYMENT_ID_, RESOURCE_NAME_, DGRM_RESOURCE_NAME_, DESCRIPTION_, HAS_START_FORM_KEY_, HAS_GRAPHICAL_NOTATION_ , SUSPENSION_STATE_, TENANT_ID_) values (?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [23505-176]

Stack Overflow | huhu | 8 months ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    I had some big problems for test activiti deployment with testng

    Stack Overflow | 8 months ago | huhu
    org.h2.jdbc.JdbcSQLException: Unique index or primary key violation: "ACT_UNIQ_PROCDEF_INDEX_6 ON PUBLIC.ACT_RE_PROCDEF(KEY_, VERSION_, TENANT_ID_) VALUES ( /* key:7 */ 'tasktestid:5:69', 1, 'http://www.activiti.org/test', 'tasktestname', 'tasktestid', 5, '53', 'com/jsits/bpm/activiti/test/task/taskTest.bpmn', 'com/jsits/bpm/activiti/test/task/taskTest.tasktestid.png', NULL, FALSE, TRUE, 1, '')"; SQL statement: insert into ACT_RE_PROCDEF(ID_, REV_, CATEGORY_, NAME_, KEY_, VERSION_, DEPLOYMENT_ID_, RESOURCE_NAME_, DGRM_RESOURCE_NAME_, DESCRIPTION_, HAS_START_FORM_KEY_, HAS_GRAPHICAL_NOTATION_ , SUSPENSION_STATE_, TENANT_ID_) values (?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [23505-176]
  2. 0

    h2 truncate may fail

    GitHub | 4 years ago | ben-manes
    org.jooq.exception.DataAccessException: SQL [truncate table file_metadata]; Cannot truncate """file_vault"".FILE_METADATA"; SQL statement: truncate table file_metadata [90106-167]
  3. 0

    Clock crashed

    GitHub | 2 years ago | phxql
    org.h2.jdbc.JdbcSQLException: Eindeutiger Index oder Primärschlüssel verletzt: "CONSTRAINT_INDEX_B ON PUBLIC.TECHNOLOGY(PLAYER_ID, TYPE) VALUES ( /* key:2 */ null, 1, null, '2d821735-a30f-49b1-b7b1-519a00630131')" Unique index or primary key violation: "CONSTRAINT_INDEX_B ON PUBLIC.TECHNOLOGY(PLAYER_ID, TYPE) VALUES ( /* key:2 */ null, 1, null, '2d821735-a30f-49b1-b7b1-519a00630131')"; SQL statement: insert into "PUBLIC"."TECHNOLOGY" ("ID", "TYPE", "PLAYER_ID", "LEVEL") values (cast(? as uuid), cast(? as int), cast(? as uuid), cast(? as int)) [23505-176]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Database deadlock

    GitHub | 2 years ago | phxql
    org.h2.jdbc.JdbcSQLException: Eine Verklemmung (Deadlock) ist aufgetreten. Die aktuelle Transaktion wurde rückgängig gemacht. Details: " Session #11 (user: ) on thread dw-89 - POST /v1/planet/8.4.2/ship-in-construction is waiting to lock PUBLIC.ROUND while locking PUBLIC.PLANET (exclusive). Session #12 (user: ) on thread pool-2-thread-1 is waiting to lock PUBLIC.PLANET while locking PUBLIC.ROUND (exclusive), PUBLIC.BUILDING (exclusive), PUBLIC.EVENT (exclusive)." Deadlock detected. The current transaction was rolled back. Details: " Session #11 (user: ) on thread dw-89 - POST /v1/planet/8.4.2/ship-in-construction is waiting to lock PUBLIC.ROUND while locking PUBLIC.PLANET (exclusive). Session #12 (user: ) on thread pool-2-thread-1 is waiting to lock PUBLIC.PLANET while locking PUBLIC.ROUND (exclusive), PUBLIC.BUILDING (exclusive), PUBLIC.EVENT (exclusive)."; SQL statement: insert into "PUBLIC"."EVENT" ("ID", "PLAYER_ID", "PLANET_ID", "TYPE", "ROUND", "FIGHT_ID") values (cast(? as uuid), cast(? as uuid), cast(? as uuid), cast(? as int), cast(? as bigint), cast(? as uuid)) [40001-176]
  6. 0

    Issue 307 - h2database - Null Pointer exception while executing a Select - Java SQL database - Google Project Hosting

    google.com | 2 years ago
    org.h2.jdbc.JdbcSQLException: General error: "java.lang.NullPointerException" [50000-136]

  1. kjhdofjosvs 1 times, last 2 months ago
1 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. org.h2.jdbc.JdbcSQLException

    Unique index or primary key violation: "ACT_UNIQ_PROCDEF_INDEX_6 ON PUBLIC.ACT_RE_PROCDEF(KEY_, VERSION_, TENANT_ID_) VALUES ( /* key:7 */ 'tasktestid:5:69', 1, 'http://www.activiti.org/test', 'tasktestname', 'tasktestid', 5, '53', 'com/jsits/bpm/activiti/test/task/taskTest.bpmn', 'com/jsits/bpm/activiti/test/task/taskTest.tasktestid.png', NULL, FALSE, TRUE, 1, '')"; SQL statement: insert into ACT_RE_PROCDEF(ID_, REV_, CATEGORY_, NAME_, KEY_, VERSION_, DEPLOYMENT_ID_, RESOURCE_NAME_, DGRM_RESOURCE_NAME_, DESCRIPTION_, HAS_START_FORM_KEY_, HAS_GRAPHICAL_NOTATION_ , SUSPENSION_STATE_, TENANT_ID_) values (?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [23505-176]

    at org.h2.message.DbException.getJdbcSQLException()
  2. H2 Database Engine
    JdbcPreparedStatement.execute
    1. org.h2.message.DbException.getJdbcSQLException(DbException.java:344)
    2. org.h2.message.DbException.get(DbException.java:178)
    3. org.h2.message.DbException.get(DbException.java:154)
    4. org.h2.index.BaseIndex.getDuplicateKeyException(BaseIndex.java:103)
    5. org.h2.index.TreeIndex.add(TreeIndex.java:69)
    6. org.h2.table.RegularTable.addRow(RegularTable.java:120)
    7. org.h2.command.dml.Insert.insertRows(Insert.java:157)
    8. org.h2.command.dml.Insert.update(Insert.java:115)
    9. org.h2.command.CommandContainer.update(CommandContainer.java:79)
    10. org.h2.command.Command.executeUpdate(Command.java:254)
    11. org.h2.jdbc.JdbcPreparedStatement.execute(JdbcPreparedStatement.java:199)
    11 frames
  3. MyBatis
    DefaultSqlSession.update
    1. org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:41)
    2. org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:66)
    3. org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:45)
    4. org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:100)
    5. org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:75)
    6. org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:148)
    6 frames