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

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

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

Solutions on the web3172

  • 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
  • ERROR: duplicate key value violates unique constraint "resourceuser_pk" Detail: Key (id)=(2) already exists.
  • via Stack Overflow by mah454
    , 8 months ago
    ERROR: duplicate key value violates unique constraint "persons_pkey" Detail: Key (id)=(0) already exists.
  • Stack trace

    • 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(JpaTransactionManager.java:526) at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:761) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:730) at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:485) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:291) at org.springframework.transaction.aspectj.AbstractTransactionAspect.ajc$around$org_springframework_transaction_aspectj_AbstractTransactionAspect$1$2a73e96c(AbstractTransactionAspect.aj:70) at com.dbcentral.service.DocumentService.addRow(DocumentService.java:100)

    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

    You’re the first here who have seen this exception.