[
https://jira.duraspace.org/browse/DS-1420?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ivan Masár updated DS-1420:
---------------------------
Description:
DS-12 fixed this problem long time ago in JSPUI.
But in XMLUI after deleting a metadata field that still has values present this
error page shows up:
org.postgresql.util.PSQLException: ERROR: update or delete on table
"metadatafieldregistry" violates foreign key constraint
"metadatavalue_metadata_field_id_fkey" on table "metadatavalue"
Detail: Key (metadata_field_id)=(90) is still referenced from table
"metadatavalue".
Here's the Java stacktrace:
rg.postgresql.util.PSQLException: ERROR: update or delete on table
"metadatafieldregistry" violates foreign key constraint
"metadatavalue_metadata_field_id_fkey" on table "metadatavalue"
Detail: Key (metadata_field_id)=(90) is still referenced from table
"metadatavalue".
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.executeUpdate(AbstractJdbc2Statement.java:334)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
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:421)
at
org.dspace.storage.rdbms.DatabaseManager.deleteByValue(DatabaseManager.java:572)
at
org.dspace.storage.rdbms.DatabaseManager.delete(DatabaseManager.java:536)
at
org.dspace.storage.rdbms.DatabaseManager.delete(DatabaseManager.java:760)
at org.dspace.content.MetadataField.delete(MetadataField.java:485)
at
org.dspace.app.xmlui.aspect.administrative.FlowRegistryUtils.processDeleteMetadataField(FlowRegistryUtils.java:398)
was:
I'm not sure if this is a duplicate of DS-12, which is marked as fix.
But in XMLUI after deleting a metadata field that still has values present this
error page shows up:
org.postgresql.util.PSQLException: ERROR: update or delete on table
"metadatafieldregistry" violates foreign key constraint
"metadatavalue_metadata_field_id_fkey" on table "metadatavalue"
Detail: Key (metadata_field_id)=(90) is still referenced from table
"metadatavalue".
Here's the Java stacktrace:
rg.postgresql.util.PSQLException: ERROR: update or delete on table
"metadatafieldregistry" violates foreign key constraint
"metadatavalue_metadata_field_id_fkey" on table "metadatavalue"
Detail: Key (metadata_field_id)=(90) is still referenced from table
"metadatavalue".
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.executeUpdate(AbstractJdbc2Statement.java:334)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
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:421)
at
org.dspace.storage.rdbms.DatabaseManager.deleteByValue(DatabaseManager.java:572)
at
org.dspace.storage.rdbms.DatabaseManager.delete(DatabaseManager.java:536)
at
org.dspace.storage.rdbms.DatabaseManager.delete(DatabaseManager.java:760)
at org.dspace.content.MetadataField.delete(MetadataField.java:485)
at
org.dspace.app.xmlui.aspect.administrative.FlowRegistryUtils.processDeleteMetadataField(FlowRegistryUtils.java:398)
> Exception handling for deleting a metadata field (XMLUI)
> --------------------------------------------------------
>
> Key: DS-1420
> URL: https://jira.duraspace.org/browse/DS-1420
> Project: DSpace
> Issue Type: Bug
> Components: XMLUI
> Affects Versions: 3.0
> Reporter: Ivan Masár
> Fix For: 3.1
>
>
> DS-12 fixed this problem long time ago in JSPUI.
> But in XMLUI after deleting a metadata field that still has values present
> this error page shows up:
> org.postgresql.util.PSQLException: ERROR: update or delete on table
> "metadatafieldregistry" violates foreign key constraint
> "metadatavalue_metadata_field_id_fkey" on table "metadatavalue"
> Detail: Key (metadata_field_id)=(90) is still referenced from table
> "metadatavalue".
> Here's the Java stacktrace:
> rg.postgresql.util.PSQLException: ERROR: update or delete on table
> "metadatafieldregistry" violates foreign key constraint
> "metadatavalue_metadata_field_id_fkey" on table "metadatavalue"
> Detail: Key (metadata_field_id)=(90) is still referenced from table
> "metadatavalue".
> 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.executeUpdate(AbstractJdbc2Statement.java:334)
> at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
> 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:421)
> at
> org.dspace.storage.rdbms.DatabaseManager.deleteByValue(DatabaseManager.java:572)
> at
> org.dspace.storage.rdbms.DatabaseManager.delete(DatabaseManager.java:536)
> at
> org.dspace.storage.rdbms.DatabaseManager.delete(DatabaseManager.java:760)
> at org.dspace.content.MetadataField.delete(MetadataField.java:485)
> at
> org.dspace.app.xmlui.aspect.administrative.FlowRegistryUtils.processDeleteMetadataField(FlowRegistryUtils.java:398)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add services
Discover what IT Professionals Know. Rescue delivers
http://p.sf.net/sfu/logmein_12329d2d
_______________________________________________
Dspace-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-devel
