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
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  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

    Spring Data JPA deleteInBatch

    Stack Overflow | 2 years ago
    org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; constraint [DEPT_DETAILS_F_KEY1]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Exception when selecting unaliased functions in queries

    GitHub | 5 years ago | lukaseder
    java.sql.SQLException: Column not found: count
  6. 0

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

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

  1. marcbouvierdav 6 times, last 1 week ago
  2. jpvee 4 times, last 3 months ago
  3. kjhdofjosvs 1 times, last 4 months ago
  4. andyglick 2 times, last 4 months ago
  5. WoodenDoors 67 times, last 11 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