org.dspace.browse.BrowseException

org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "communities2item_pkey"

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 web6

  • via Sakai JIRA by Hafeez Qazi, 1 year ago
    org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "communities2item_pkey"
  • via Sakai JIRA by Hafeez Qazi, 1 year ago
    org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "communities2item_pkey"
  • via Sakai JIRA by Claudia Jürgen, 1 year ago
    org.dspace.discovery.SearchServiceException: parsing error
  • Stack trace

    • org.dspace.browse.BrowseException: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "communities2item_pkey" at org.dspace.browse.BrowseCreateDAOPostgres.updateCommunityMappings(BrowseCreateDAOPostgres.java:661) at org.dspace.browse.IndexBrowse.indexItem(IndexBrowse.java:402) at org.dspace.browse.IndexBrowse.createIndex(IndexBrowse.java:1148) at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:703) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:212) Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "communities2item_pkey" at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1531) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1313) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:308) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102) at org.dspace.storage.rdbms.DatabaseManager.execute(DatabaseManager.java:1429) at org.dspace.storage.rdbms.DatabaseManager.insert(DatabaseManager.java:736) at org.dspace.storage.rdbms.DatabaseManager.create(DatabaseManager.java:490) at org.dspace.browse.BrowseCreateDAOPostgres.updateCommunityMappings(BrowseCreateDAOPostgres.java:651) ... 8 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

    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    2 times, 1 month ago
    25 times, 7 months ago
    Unknown user
    Once, 11 months ago
    92 more bugmates