org.hsqldb.HsqlException: integrity constraint violation: unique constraint or index violation; SYS_PK_10030 table: DATA

hsqldb | disbj | 5 years ago
  1. 0

    MVCC rollback issue: readExistingData failed

    hsqldb | 5 years ago | disbj
    org.hsqldb.HsqlException: integrity constraint violation: unique constraint or index violation; SYS_PK_10030 table: DATA
  2. 0

    Endeca CAS service not running.

    Oracle Community | 3 years ago | GK MISHRA
    com.endeca.itl.ItlRuntimeException: org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [UPDATE MODULE_SPECS SET OBJECT_XML = ? WHERE OBJECT_ID = ?]; integrity constraint violation: unique constraint or index violation; SYS_PK_10040 table: MODULE_SPECS; nested exception is java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: unique constraint or index violation; SYS_PK_10040 table: MODULE_SPECS
  3. 0

    JPA persist fails with new compound key existing relation entities

    Stack Overflow | 3 years ago | anterosalonen
    org.springframework.orm.jpa.JpaSystemException: org.hibernate.exception.ConstraintViolationException: could not execute statement; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute statement
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Using embedded database with Flyway and jOOQ in Maven for continuous integration

    Stack Overflow | 2 years ago | user2957009
    org.hsqldb.HsqlException: Database lock acquisition failure: lockFile: org.hsqldb.persist.LockFile@1096ec89[file =...db/db.lck, exists=true, locked=false, valid=false, ] method: checkHeartbeat read: 2015-02-09 03:56:15 heartbeat - read: -863 ms.
  6. 0

    User lacks privilege or object not found WITH JUnit

    codedmi.com | 12 months ago
    java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: GROUP

  1. andyglick 2 times, last 3 weeks ago
  2. marcbouvierdav 1 times, last 1 month ago
  3. WoodenDoors 67 times, last 7 months ago
87 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.hsqldb.HsqlException

    integrity constraint violation: unique constraint or index violation; SYS_PK_10030 table: DATA

    at org.hsqldb.error.Error.error()
  2. HyperSQL Database
    Error.error
    1. org.hsqldb.error.Error.error(Error.java:134)
    1 frame
  3. HSQLDB
    JDBCStatement.execute
    1. org.hsqldb.Constraint.getException(Constraint.java:872)
    2. org.hsqldb.index.IndexAVLMemory.insert(IndexAVLMemory.java:236)
    3. org.hsqldb.persist.RowStoreAVL.indexRow(RowStoreAVL.java:171)
    4. org.hsqldb.Table.insertData(Table.java:2669)
    5. org.hsqldb.Table.insertFromScript(Table.java:2658)
    6. org.hsqldb.scriptio.ScriptReaderText.readExistingData(ScriptReaderText.java:186)
    7. org.hsqldb.scriptio.ScriptReaderBase.readAll(ScriptReaderBase.java:64)
    8. org.hsqldb.persist.Log.processScript(Log.java:744)
    9. org.hsqldb.persist.Log.open(Log.java:171)
    10. org.hsqldb.persist.Logger.openPersistence(Logger.java:364)
    11. org.hsqldb.Database.reopen(Database.java:227)
    12. org.hsqldb.Database.close(Database.java:574)
    13. org.hsqldb.StatementCommand.getResult(StatementCommand.java:854)
    14. org.hsqldb.StatementCommand.execute(StatementCommand.java:211)
    15. org.hsqldb.Session.executeCompiledStatement(Session.java:1282)
    16. org.hsqldb.Session.executeDirectStatement(Session.java:1214)
    17. org.hsqldb.Session.execute(Session.java:1000)
    18. org.hsqldb.jdbc.JDBCStatement.fetchResult(JDBCStatement.java:1830)
    19. org.hsqldb.jdbc.JDBCStatement.execute(JDBCStatement.java:636)
    19 frames
  4. Unknown
    TestHSQLDB.main
    1. TestHSQLDB.main(TestHSQLDB.java:123)
    1 frame