org.postgresql.util.PSQLException

ERROR: duplicate key value violates unique constraint "metadatavalue_pkey" Detail: Key (metadata_value_id)=(125069) already exists.

Samebug tips1

Try downgrading PostgresSQL server to 9.5 or update your PostgresSQL driver to 9.4-1211 with the following command: <postgresql.version>9.4.1211</postgresql.version>

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

Solutions on the web3102

  • via Stack Overflow by eml
    , 11 months ago
    ERROR: duplicate key value violates unique constraint "metadatavalue_pkey" Detail: Key (metadata_value_id)=(125069) already exists.
  • via Google Groups by Emmanuel Wilson, 1 week ago
    ERROR: duplicate key value violates unique constraint "metadatavalue_pkey" Detail: Key (metadata_value_id)=(125069) already exists.
  • ERROR: duplicate key value violates unique constraint "type_pkey" Detail: Key (typeid)=(DETAIL) already exists.
  • Stack trace

    • org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "metadatavalue_pkey" Detail: Key (metadata_value_id)=(125069) already exists. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.dspace.storage.rdbms.DatabaseManager.doInsertPostgres(DatabaseManager.java:1743) at org.dspace.storage.rdbms.DatabaseManager.insert(DatabaseManager.java:711) at org.dspace.content.MetadataValue.create(MetadataValue.java:293) at org.dspace.content.DSpaceObject.updateMetadata(DSpaceObject.java:256) at org.dspace.content.Bitstream.update(Bitstream.java:502) at org.dspace.app.webui.servlet.admin.EditItemServlet.processUpdateItem(EditItemServlet.java:752) at org.dspace.app.webui.servlet.admin.EditItemServlet.doDSPost(EditItemServlet.java:231) at org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServlet.java:115) at org.dspace.app.webui.servlet.DSpaceServlet.doPost(DSpaceServlet.java:73) at javax.servlet.http.HttpServlet.service(HttpServlet.java:646) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.dspace.app.webui.filter.RegisteredOnlyFilter.doFilter(RegisteredOnlyFilter.java:66) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.dspace.utils.servlet.DSpaceWebappServletFilter.doFilter(DSpaceWebappServletFilter.java:78) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:503) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745)

    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

    Unknown user
    Once, 11 months ago
    10 times, 1 year ago
    4 times, 10 months ago
    Unknown user
    Once, 1 year ago
    Once, 1 month ago
    94 more bugmates