exists.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)

Google Groups | Emmanuel Wilson | 4 months ago
  1. 1

    Internal System Error on dspace 5.2

    Google Groups | 4 months ago | Emmanuel Wilson
    exists.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)

    Root Cause Analysis

    1. exists.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()
    2. PostgreSQL JDBC Driver
      AbstractJdbc2Statement.executeQuery
      1. org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
      2. org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
      3. org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
      4. org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
      5. org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
      5 frames
    3. Commons DBCP
      DelegatingPreparedStatement.executeQuery
      1. org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
      2. org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
      3. org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
      3 frames
    4. DSpace Kernel :: API and Implementation
      Bitstream.update
      1. org.dspace.storage.rdbms.DatabaseManager.doInsertPostgres(DatabaseManager.java:1743)
      2. org.dspace.storage.rdbms.DatabaseManager.insert(DatabaseManager.java:711)
      3. org.dspace.content.MetadataValue.create(MetadataValue.java:293)
      4. org.dspace.content.DSpaceObject.updateMetadata(DSpaceObject.java:256)
      5. org.dspace.content.Bitstream.update(Bitstream.java:502)
      5 frames
    5. org.dspace.app
      DSpaceServlet.doPost
      1. org.dspace.app.webui.servlet.admin.EditItemServlet.processUpdateItem(EditItemServlet.java:752)
      2. org.dspace.app.webui.servlet.admin.EditItemServlet.doDSPost(EditItemServlet.java:231)
      3. org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServlet.java:115)
      4. org.dspace.app.webui.servlet.DSpaceServlet.doPost(DSpaceServlet.java:73)
      4 frames
    6. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
      2 frames
    7. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
      2 frames
    8. org.dspace.app
      RegisteredOnlyFilter.doFilter
      1. org.dspace.app.webui.filter.RegisteredOnlyFilter.doFilter(RegisteredOnlyFilter.java:66)
      1 frame
    9. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
      2 frames
    10. DSpace Services Framework :: API and Implementation
      DSpaceWebappServletFilter.doFilter
      1. org.dspace.utils.servlet.DSpaceWebappServletFilter.doFilter(DSpaceWebappServletFilter.java:78)
      1 frame
    11. Glassfish Core
      CoyoteAdapter.service
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
      3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
      4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
      5. org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:503)
      6. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
      7. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
      8. org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
      9. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
      10. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)
      10 frames
    12. Grizzly HTTP
      JIoEndpoint$SocketProcessor.run
      1. org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070)
      2. org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)
      3. org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
      3 frames
    13. Java RT
      ThreadPoolExecutor$Worker.run
      1. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
      2. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
      2 frames
    14. Tomcat Util
      TaskThread$WrappingRunnable.run
      1. org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
      1 frame
    15. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:745)
      1 frame