Hi, There is a known issue where DSpace doesn't (yet) automatically clean up the old database-based browse tables. These tables are no longer needed if you are using the Discovery Search/Browse (which is default). See step #11 of the Upgrade process for DSpace 5 for details on how to remove them via a commandline script:
https://wiki.duraspace.org/display/DSDOC5x/Upgrading+DSpace Specifically, you'd want to run: [dspace]/bin/dspace index-db-browse -f -d - Tim On 6/6/2015 12:50 PM, IdeaFix wrote: > Hi. I try to delete temporary collection on my test repository and get > an error. Here is the log: > > 2015-06-06 22:48:25,125 ERROR org.dspace.storage.rdbms.DatabaseManager @ > SQL query updateQuery Error - > > org.postgresql.util.PSQLException: ОШИБКА: UPDATE или DELETE в таблице > "item" нарушает ограничение внешнего ключа "bi_item_item_id_fkey" > таблицы "bi_item" > > Подробности: На ключ (item_id)=(36298) всё ещё есть ссылки в таблице > "bi_item". > > 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: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.content.Collection.delete(Collection.java:1257) > > at > org.dspace.content.Community.removeCollection(Community.java:1107) > > at > org.dspace.app.webui.servlet.admin.EditCommunitiesServlet.doDSPost(EditCommunitiesServlet.java:251) > > 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:641) > > at > javax.servlet.http.HttpServlet.service(HttpServlet.java:722) > > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) > > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) > > at > org.dspace.app.webui.filter.RegisteredOnlyFilter.doFilter(RegisteredOnlyFilter.java:66) > > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) > > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) > > at > org.dspace.utils.servlet.DSpaceWebappServletFilter.doFilter(DSpaceWebappServletFilter.java:78) > > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) > > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) > > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:225) > > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169) > > at > org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) > > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) > > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) > > at > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927) > > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) > > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) > > at > org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:999) > > at > org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:565) > > at > org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309) > > at > java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) > > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) > > at java.lang.Thread.run(Unknown Source) > > > > ------------------------------------------------------------------------------ > > > > _______________________________________________ > DSpace-tech mailing list > DSpace-tech@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/dspace-tech > List Etiquette: > https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette > ------------------------------------------------------------------------------ _______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
