org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "unique_document_id_rows_order" Detail: Key (document_id, rows_order)=(113306, 2) already exists. Error Code: 0

Stack Overflow | lucash | 3 months ago
  1. 0

    Moving entity between two ordered lists in eclipselink

    Stack Overflow | 3 months ago | lucash
    org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "unique_document_id_rows_order" Detail: Key (document_id, rows_order)=(113306, 2) already exists. Error Code: 0
  2. 0

    Issue removing and re-adding the components in Ambari

    ambari-user | 1 year ago | Darpan Patel
    org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "clusterservices_pkey"* * Detail: Key (service_name, cluster_id)=(KNOX, 2) already exists.*
  3. 0

    To reproduce, blast messages at a channel with source queueing turned on and let messages queue up on the source. Then go to the message browser and remove results. This error should appear after at least a few tries. {noformat} ERROR 2014-12-03 10:29:31,148 [Thread-23] com.mirth.connect.donkey.server.channel.Channel: An error occurred in channel TCP Listener 1 (57bd25e4-1142-4f3d-86be-490e57dad496) while processing message ID 1578 from the source queue com.mirth.connect.donkey.server.data.DonkeyDaoException: Failed to insert connector message meta data at com.mirth.connect.donkey.server.data.jdbc.JdbcDao.insertMetaData(JdbcDao.java:507) at com.mirth.connect.donkey.server.data.buffered.BufferedDao.executeTasks(BufferedDao.java:102) at com.mirth.connect.donkey.server.data.buffered.BufferedDao.commit(BufferedDao.java:74) at com.mirth.connect.donkey.server.data.buffered.BufferedDao.commit(BufferedDao.java:56) at com.mirth.connect.donkey.server.channel.Channel.process(Channel.java:1604) at com.mirth.connect.donkey.server.channel.Channel.processSourceQueue(Channel.java:1738) at com.mirth.connect.donkey.server.channel.Channel.run(Channel.java:1725) at java.lang.Thread.run(Thread.java:745) Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "d_mcm3_pkey" Detail: Key (message_id, metadata_id)=(1578, 0) already exists. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:419) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:365) at com.zaxxer.hikari.proxy.PreparedStatementJavassistProxy.executeUpdate(PreparedStatementJavassistProxy.java) at com.mirth.connect.donkey.server.data.jdbc.JdbcDao.insertMetaData(JdbcDao.java:504) ... 7 more {noformat}

    Mirth Project | 2 years ago | Brent Moen
    com.mirth.connect.donkey.server.data.DonkeyDaoException: Failed to insert connector message meta data
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Hibernate and PostgreSQL Sequences

    Stack Overflow | 1 month ago | mah454
    javax.persistence.RollbackException: Error while committing the transaction
  6. 0

    To reproduce, blast messages at a channel with source queueing turned on and let messages queue up on the source. Then go to the message browser and remove results. This error should appear after at least a few tries. {noformat} ERROR 2014-12-03 10:29:31,148 [Thread-23] com.mirth.connect.donkey.server.channel.Channel: An error occurred in channel TCP Listener 1 (57bd25e4-1142-4f3d-86be-490e57dad496) while processing message ID 1578 from the source queue com.mirth.connect.donkey.server.data.DonkeyDaoException: Failed to insert connector message meta data at com.mirth.connect.donkey.server.data.jdbc.JdbcDao.insertMetaData(JdbcDao.java:507) at com.mirth.connect.donkey.server.data.buffered.BufferedDao.executeTasks(BufferedDao.java:102) at com.mirth.connect.donkey.server.data.buffered.BufferedDao.commit(BufferedDao.java:74) at com.mirth.connect.donkey.server.data.buffered.BufferedDao.commit(BufferedDao.java:56) at com.mirth.connect.donkey.server.channel.Channel.process(Channel.java:1604) at com.mirth.connect.donkey.server.channel.Channel.processSourceQueue(Channel.java:1738) at com.mirth.connect.donkey.server.channel.Channel.run(Channel.java:1725) at java.lang.Thread.run(Thread.java:745) Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "d_mcm3_pkey" Detail: Key (message_id, metadata_id)=(1578, 0) already exists. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:419) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:365) at com.zaxxer.hikari.proxy.PreparedStatementJavassistProxy.executeUpdate(PreparedStatementJavassistProxy.java) at com.mirth.connect.donkey.server.data.jdbc.JdbcDao.insertMetaData(JdbcDao.java:504) ... 7 more {noformat}

    Mirth Project | 2 years ago | Brent Moen
    com.mirth.connect.donkey.server.data.DonkeyDaoException: Failed to insert connector message meta data

    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.postgresql.util.PSQLException

      ERROR: duplicate key value violates unique constraint "unique_document_id_rows_order" Detail: Key (document_id, rows_order)=(113306, 2) already exists. Error Code: 0

      at org.springframework.orm.jpa.JpaTransactionManager.doCommit()
    2. Spring ORM
      JpaTransactionManager.doCommit
      1. org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:526)
      1 frame
    3. Spring Tx
      TransactionAspectSupport.invokeWithinTransaction
      1. org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:761)
      2. org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:730)
      3. org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:485)
      4. org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:291)
      4 frames
    4. Spring Aspects
      AbstractTransactionAspect.ajc$around$org_springframework_transaction_aspectj_AbstractTransactionAspect$1$2a73e96c
      1. org.springframework.transaction.aspectj.AbstractTransactionAspect.ajc$around$org_springframework_transaction_aspectj_AbstractTransactionAspect$1$2a73e96c(AbstractTransactionAspect.aj:70)
      1 frame
    5. com.dbcentral.service
      DocumentService.addRow
      1. com.dbcentral.service.DocumentService.addRow(DocumentService.java:100)
      1 frame