java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: unique constraint or index violation; SYS_PK_10092 table: DS_MESSAGES in statement [DROP INDEX IF EXISTS ds_messages_nextmsg]

hsqldb | sstijn | 3 years ago
  1. 0

    MVCC checkpoint/defrag triggers CONSTRAINT VIOLATION

    hsqldb | 3 years ago | sstijn
    java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: unique constraint or index violation; SYS_PK_10092 table: DS_MESSAGES in statement [DROP INDEX IF EXISTS ds_messages_nextmsg]
  2. 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
  3. 0

    Exception when selecting unaliased functions in queries

    GitHub | 4 years ago | lukaseder
    java.sql.SQLException: Column not found: count
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Integrity issue in database and repo(?): in table MULTICHUNK and 'Cannot determine file content for checksum '

    GitHub | 2 years ago | binwiederhier
    java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: unique constraint or index violation; SYS_PK_10190 table: MULTICHUNK
  6. 0

    After DIRTY: integrity constraint violation: unique constraint or index violation; SYS_PK_10180 table: MULTICHUNK

    GitHub | 3 years ago | binwiederhier
    java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: unique constraint or index violation; SYS_PK_10180 table: MULTICHUNK

  1. andyglick 2 times, last 3 weeks ago
  2. marcbouvierdav 1 times, last 1 month ago
  3. WoodenDoors 67 times, last 8 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_10092 table: DS_MESSAGES

    at org.hsqldb.error.Error.error()
  2. HyperSQL Database
    Error.error
    1. org.hsqldb.error.Error.error(Unknown Source)
    1 frame
  3. HSQLDB
    DatabaseManagerSwing$StatementExecRunnable.run
    1. org.hsqldb.Constraint.getException(Unknown Source)
    2. org.hsqldb.index.IndexAVL.insert(Unknown Source)
    3. org.hsqldb.persist.RowStoreAVL.indexRow(Unknown Source)
    4. org.hsqldb.persist.RowStoreAVLDisk.indexRow(Unknown Source)
    5. org.hsqldb.persist.RowStoreAVL.moveData(Unknown Source)
    6. org.hsqldb.TableWorks.moveData(Unknown Source)
    7. org.hsqldb.TableWorks.dropIndex(Unknown Source)
    8. org.hsqldb.SchemaManager.dropIndex(Unknown Source)
    9. org.hsqldb.StatementSchema.getResult(Unknown Source)
    10. org.hsqldb.StatementSchema.execute(Unknown Source)
    11. org.hsqldb.Session.executeCompiledStatement(Unknown Source)
    12. org.hsqldb.Session.executeDirectStatement(Unknown Source)
    13. org.hsqldb.Session.execute(Unknown Source)
    14. org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
    15. org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
    16. org.hsqldb.util.DatabaseManagerSwing.executeSQL(Unknown Source)
    17. org.hsqldb.util.DatabaseManagerSwing.access$1000(Unknown Source)
    18. org.hsqldb.util.DatabaseManagerSwing$StatementExecRunnable.run(Unknown Source)
    18 frames
  4. Java RT
    EventDispatchThread.run
    1. java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:251)
    2. java.awt.EventQueue.dispatchEventImpl(EventQueue.java:733)
    3. java.awt.EventQueue.access$200(EventQueue.java:103)
    4. java.awt.EventQueue$3.run(EventQueue.java:694)
    5. java.awt.EventQueue$3.run(EventQueue.java:692)
    6. java.security.AccessController.doPrivileged(Native Method)
    7. java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
    8. java.awt.EventQueue.dispatchEvent(EventQueue.java:703)
    9. java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:242)
    10. java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:161)
    11. java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:150)
    12. java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:146)
    13. java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:138)
    14. java.awt.EventDispatchThread.run(EventDispatchThread.java:91)
    14 frames