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]

Samebug tips0

We couldn't find tips for this exception.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web408

  • via Unknown by Unknown author,
  • Stack trace

    • 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] at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source) at org.hsqldb.util.DatabaseManagerSwing.executeSQL(Unknown Source) at org.hsqldb.util.DatabaseManagerSwing.access$1000(Unknown Source) at org.hsqldb.util.DatabaseManagerSwing$StatementExecRunnable.run(Unknown Source) at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:251) at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:733) at java.awt.EventQueue.access$200(EventQueue.java:103) at java.awt.EventQueue$3.run(EventQueue.java:694) at java.awt.EventQueue$3.run(EventQueue.java:692) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76) at java.awt.EventQueue.dispatchEvent(EventQueue.java:703) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:242) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:161) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:150) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:146) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:138) at java.awt.EventDispatchThread.run(EventDispatchThread.java:91) Caused by: org.hsqldb.HsqlException: integrity constraint violation: unique constraint or index violation; SYS_PK_10092 table: DS_MESSAGES at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.Constraint.getException(Unknown Source) at org.hsqldb.index.IndexAVL.insert(Unknown Source) at org.hsqldb.persist.RowStoreAVL.indexRow(Unknown Source) at org.hsqldb.persist.RowStoreAVLDisk.indexRow(Unknown Source) at org.hsqldb.persist.RowStoreAVL.moveData(Unknown Source) at org.hsqldb.TableWorks.moveData(Unknown Source) at org.hsqldb.TableWorks.dropIndex(Unknown Source) at org.hsqldb.SchemaManager.dropIndex(Unknown Source) at org.hsqldb.StatementSchema.getResult(Unknown Source) at org.hsqldb.StatementSchema.execute(Unknown Source) at org.hsqldb.Session.executeCompiledStatement(Unknown Source) at org.hsqldb.Session.executeDirectStatement(Unknown Source) at org.hsqldb.Session.execute(Unknown Source) ... 19 more

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    marcbouvierdavmarcbouvierdav
    5 times, last one
    AxeloAxelo
    2 times, last one
    jpveejpvee
    1904 times, last one
    kjhdofjosvskjhdofjosvs
    Once,
    Unknown visitor
    Unknown visitorOnce,
    92 more bugmates