org.postgresql.util.PSQLException: ERROR: update or delete on table "item" violates foreign key constraint "communities2item_item_id_fkey" on table "communities2item" Detail: Key (item_id)=(32459) is still referenced from table "communities2item".

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

,
Expert tip

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>

Solutions on the web

via Sakai JIRA by Ivan Masár, 1 year ago
ERROR: update or delete on table "item" violates foreign key constraint "communities2item_item_id_fkey" on table "communities2item" Detail: Key (item_id)=(32459) is still referenced from table "communities2item".
via Sakai JIRA by Ivan Masár, 1 year ago
ERROR: update or delete on table "item" violates foreign key constraint "communities2item_item_id_fkey" on table "communities2item" Detail: Key (item_id)=(32459) is still referenced from table "communities2item".
via Sakai JIRA by Ivan Masár, 1 year ago
ERROR: update or delete on table "item" violates foreign key constraint "bi_5_dmap_item_id_fkey" on table "bi_5_dmap" Detail: Key (item_id)=(4742) is still referenced from table "bi_5_dmap".
via Sakai JIRA by Ivan Masár, 1 year ago
ERROR: update or delete on table "item" violates foreign key constraint "bi_5_dmap_item_id_fkey" on table "bi_5_dmap" Detail: Key (item_id)=(4742) is still referenced from table "bi_5_dmap".
via Google Groups by Mark Ludwig, 2 months ago
ERROR: duplicate key value violates unique constraint "handle_handle_key"
via Google Groups by Kiran Kumar V, 2 months ago
ERROR: duplicate key value violat es unique constraint "bitstreamformatregistry_short_description_key" Detail: Key (short_description)=(Unknown) already exists.
org.postgresql.util.PSQLException: ERROR: update or delete on table "item" violates foreign key constraint "communities2item_item_id_fkey" on table "communities2item" Detail: Key (item_id)=(32459) is still referenced from table "communities2item".
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.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:441)
at org.dspace.storage.rdbms.DatabaseManager.deleteByValue(DatabaseManager.java:612)
at org.dspace.storage.rdbms.DatabaseManager.delete(DatabaseManager.java:571)
at org.dspace.storage.rdbms.DatabaseManager.delete(DatabaseManager.java:796)
at org.dspace.content.Item.delete(Item.java:1308)
at org.dspace.content.Collection.removeItem(Collection.java:1126)
at org.dspace.app.bulkedit.MetadataImport.runImport(MetadataImport.java:195)
at org.dspace.app.bulkedit.MetadataImport.main(MetadataImport.java:1396)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.dspace.app.launcher.ScriptLauncher.runOneCommand(ScriptLauncher.java:226)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.