java.sql.SQLIntegrityConstraintViolationException

integrity constraint violation: unique constraint or index violation; CONST RAINT_RESOURCE_EVENTS_UNIQUE table: RESOURCE_EVENTS

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 jon yeargers,
  • via Unknown by jon yeargers,
  • Stack trace

    • java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: unique constraint or index violation; CONST RAINT_RESOURCE_EVENTS_UNIQUE table: RESOURCE_EVENTS at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.JDBCPreparedStatement.executeUpdate(Unknown Source) at com.jolbox.bonecp.PreparedStatementHandle.executeUpdate(PreparedStatementHandle.java:203) at clojure.java.jdbc.internal$do_prepared_return_keys_STAR_$fn__2133.invoke(internal.clj:337) at clojure.java.jdbc.internal$transaction_STAR_.invoke(internal.clj:223) at clojure.java.jdbc.internal$do_prepared_return_keys_STAR_.invoke(internal.clj:337) at clojure.lang.AFn.applyToHelper(AFn.java:163) at clojure.lang.AFn.applyTo(AFn.java:151) at clojure.core$apply.invoke(core.clj:619) at clojure.java.jdbc$insert_values.doInvoke(jdbc.clj:263) at clojure.lang.RestFn.invoke(RestFn.java:442) at clojure.java.jdbc$insert_records$ins_v__2201.invoke(jdbc.clj:278) at clojure.core$map$fn__4207.invoke(core.clj:2485) at clojure.lang.LazySeq.sval(LazySeq.java:42) at clojure.lang.LazySeq.seq(LazySeq.java:60) at clojure.lang.RT.seq(RT.java:484) at clojure.core$seq.invoke(core.clj:133) at clojure.core$dorun.invoke(core.clj:2780) at clojure.core$doall.invoke(core.clj:2796) at clojure.java.jdbc$insert_records.doInvoke(jdbc.clj:279) at clojure.lang.RestFn.applyTo(RestFn.java:139) at clojure.core$apply.invoke(core.clj:619) at com.puppetlabs.puppetdb.scf.storage$add_report_BANG__STAR_$fn__3922$fn__3923.invoke(storage.clj:823) at clojure.java.jdbc.internal$transaction_STAR_.invoke(internal.clj:223) at com.puppetlabs.puppetdb.scf.storage$add_report_BANG__STAR_$fn__3922.invoke(storage.clj:812) at com.puppetlabs.puppetdb.scf.storage.proxy$java.lang.Object$Callable$f8c5758f.call(Unknown Source) at com.yammer.metrics.core.Timer.time(Timer.java:91) at com.puppetlabs.puppetdb.scf.storage$add_report_BANG__STAR_.invoke(storage.clj:811) at com.puppetlabs.puppetdb.scf.storage$eval4096$add_report_BANG___4097$fn__4098.invoke(storage.clj:929) at com.puppetlabs.puppetdb.scf.storage$eval4096$add_report_BANG___4097.invoke(storage.clj:925) at com.puppetlabs.puppetdb.command$store_report_STAR_$fn__5566.invoke(command.clj:376) at com.puppetlabs.jdbc$with_transacted_connection_fn$fn__2278$fn__2279.invoke(jdbc.clj:229) at clojure.java.jdbc.internal$transaction_STAR_.invoke(internal.clj:204) at com.puppetlabs.jdbc$with_transacted_connection_fn$fn__2278.invoke(jdbc.clj:228) at clojure.java.jdbc.internal$with_connection_STAR_.invoke(internal.clj:186) at com.puppetlabs.jdbc$with_transacted_connection_fn.invoke(jdbc.clj:225) at com.puppetlabs.puppetdb.command$store_report_STAR_.invoke(command.clj:374) at com.puppetlabs.puppetdb.command$eval5578$fn__5581.invoke(command.clj:389) at clojure.lang.MultiFn.invoke(MultiFn.java:231) at com.puppetlabs.puppetdb.command$produce_message_handler$fn__5662.invoke(command.clj:603) at com.puppetlabs.puppetdb.command$wrap_with_discard$fn__5611$fn__5615.invoke(command.clj:509) at com.puppetlabs.puppetdb.command.proxy$java.lang.Object$Callable$f8c5758f.call(Unknown Source) at com.yammer.metrics.core.Timer.time(Timer.java:91) at com.puppetlabs.puppetdb.command$wrap_with_exception_handling$fn__5596.invoke(command.clj:461) at com.puppetlabs.puppetdb.command$wrap_with_command_parser$fn__5606.invoke(command.clj:484) at com.puppetlabs.puppetdb.command$wrap_with_meter$fn__5586.invoke(command.clj:422) at com.puppetlabs.puppetdb.command$wrap_with_thread_name$fn__5620.invoke(command.clj:524) at clamq.jms$jms_consumer$fn__4656.invoke(jms.clj:38) at clamq.jms.proxy$java.lang.Object$MessageListener$ce893c05.onMessage(Unknown Source) at org.springframework.jms.listener.AbstractMessageListenerContainer.doInvokeListener(AbstractMessageListenerContainer.java:560) at org.springframework.jms.listener.AbstractMessageListenerContainer.invokeListener(AbstractMessageListenerContainer.java:498) at org.springframework.jms.listener.AbstractMessageListenerContainer.doExecuteListener(AbstractMessageListenerContainer.java:467) at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.doReceiveAndExecute(AbstractPollingMessageListenerContainer.java:325) at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.receiveAndExecute(AbstractPollingMessageListenerContainer.java:263) at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.invokeListener(DefaultMessageListenerContainer.java:1058) at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.executeOngoingLoop(DefaultMessageListenerContainer.java:1050) at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.run(DefaultMessageListenerContainer.java:947) at java.lang.Thread.run(Thread.java:744) Caused by: org.hsqldb.HsqlException: integrity constraint violation: unique constraint or index violation; CONSTRAINT_RESOURCE_EVENTS_UNIQUE table: RESOURCE_EVENTS at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.Constraint.getException(Unknown Source) at org.hsqldb.index.IndexAVLMemory.insert(Unknown Source) at org.hsqldb.persist.RowStoreAVL.indexRow(Unknown Source) at org.hsqldb.TransactionManagerMVCC.addInsertAction(Unknown Source) at org.hsqldb.Session.addInsertAction(Unknown Source) at org.hsqldb.Table.insertSingleRow(Unknown Source) at org.hsqldb.StatementDML.insertSingleRow(Unknown Source) at org.hsqldb.StatementInsert.getResult(Unknown Source) at org.hsqldb.StatementDMQL.execute(Unknown Source) at org.hsqldb.Session.executeCompiledStatement(Unknown Source) at org.hsqldb.Session.execute(Unknown Source) ... 60 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

    AxeloAxelo
    2 times, last one
    jpveejpvee
    4 times, last one
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    92 more bugmates