Dear all,
I had sent this message to the list about ten days ago but did not receive
any reply so far. I would really like to delete this community and
collection so I am sending this message once again. I am also attaching
the logfile fragment to help analyse the problem.
Please help.
Thanks a lot.
Girija
-------------------------------------------------------------------------------
Girija Srinivasan,
Raman Research Institute Library, Tel: +91 80 2361 0122 C V Raman Avenue,
Sadashivanagar, Fax: +91 80 2361 0492 Bangalore 560 080, India. Email: [EMAIL
PROTECTED]
---------- Forwarded message ----------
Date: Fri, 13 Jul 2007 11:27:04 +0530 (IST)
From: Girija S <[EMAIL PROTECTED]>
To: [email protected]
Cc: Y M Patil <[EMAIL PROTECTED]>, Jacob Rajan <[EMAIL PROTECTED]> Subject:
Error when deleting a community and a collection
Dear all,
We are using Dspace 1.3.2. and have a repository at
http://dspace.rri.res.in/
We would like to delete a community and the collections under it. All the collections showed zero items. I was able to delete all but one of them. The
one that is left gives an error message when I try to delete it. Then I remembered that this one had an item entered by mistake some time ago which was
withdrawn later(hence zero items). So I expunged the withdrawn item hoping
this would solve the problem. But I am still not able to delete this collection or the community which hosts it.
Can anyone tell me how to delete this remaining collection and its community?
I checked the archives but could not find any clear solution. Should we do some
cleanup? Can anyone give me some detailed instructions on this process?
Thanks a lot.
Girija
-------------------------------------------------------------------------------
Girija Srinivasan,
Raman Research Institute Library, Tel: +91 80 2361 0122 C V
Raman Avenue, Sadashivanagar, Fax: +91 80 2361 0492 Bangalore
560 080, India. Email: [EMAIL PROTECTED]
2007-07-17 15:23:42,756 INFO org.dspace.app.webui.servlet.BrowseServlet @
anonymous:session_id=D82F549B315F8F61131EBB4C00726310:browse_date:top=2289/194,results=21
2007-07-17 15:23:45,379 INFO org.dspace.app.webui.servlet.DSpaceServlet @
[EMAIL
PROTECTED]:session_id=E3D2D9677362B86D78BC7E255977105C:view_community:community_id=24
2007-07-17 15:23:50,080 INFO org.dspace.app.webui.servlet.RetrieveServlet @
anonymous:session_id=B23B0D6F4BDEEF8D3BDEAE4F4E715475:view_bitstream:bitstream_id=6037
2007-07-17 15:23:55,338 INFO org.dspace.content.Community @ [EMAIL
PROTECTED]:session_id=E3D2D9677362B86D78BC7E255977105C:delete_community:community_id=24
2007-07-17 15:23:55,488 INFO org.dspace.content.Community @ [EMAIL
PROTECTED]:session_id=E3D2D9677362B86D78BC7E255977105C:remove_collection:community_id=24,collection_id=49
2007-07-17 15:23:55,492 INFO org.dspace.content.Collection @ [EMAIL
PROTECTED]:session_id=E3D2D9677362B86D78BC7E255977105C:delete_collection:collection_id=49
2007-07-17 15:23:55,607 INFO org.dspace.content.Collection @ [EMAIL
PROTECTED]:session_id=E3D2D9677362B86D78BC7E255977105C:remove_logo:collection_id=49
2007-07-17 15:23:55,637 WARN org.dspace.app.webui.servlet.DSpaceServlet @
[EMAIL
PROTECTED]:session_id=E3D2D9677362B86D78BC7E255977105C:database_error:java.sql.SQLException:
ERROR: update or delete on "collection" violates foreign key constraint
"collection2item_collection_id_fkey" on "collection2item"
java.sql.SQLException: ERROR: update or delete on "collection" violates foreign
key constraint "collection2item_collection_id_fkey" on "collection2item"
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1471)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1256)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:175)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:389)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:314)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:264)
at
org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:225)
at
org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:284)
at
org.dspace.storage.rdbms.DatabaseManager.deleteByValue(DatabaseManager.java:431)
at
org.dspace.storage.rdbms.DatabaseManager.delete(DatabaseManager.java:400)
at
org.dspace.storage.rdbms.DatabaseManager.delete(DatabaseManager.java:591)
at org.dspace.content.Collection.delete(Collection.java:946)
at org.dspace.content.Community.removeCollection(Community.java:742)
at org.dspace.content.Community.delete(Community.java:842)
at
org.dspace.app.webui.servlet.admin.EditCommunitiesServlet.doDSPost(EditCommunitiesServlet.java:240)
at
org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServlet.java:147)
at
org.dspace.app.webui.servlet.DSpaceServlet.doPost(DSpaceServlet.java:105)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
org.dspace.app.webui.filter.RegisteredOnlyFilter.doFilter(RegisteredOnlyFilter.java:100)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
2007-07-17 15:24:34,631 INFO org.dspace.app.webui.servlet.BrowseServlet @
anonymous:session_id=6ECDCD1FAF1DA94B7FB2C92698E39E4D:browse_date:top=2289/1600,results=21
2007-07-17 15:25:00,801 INFO org.dspace.app.webui.servlet.BrowseServlet @
anonymous:session_id=0100B25EB2E2DBE1F44D4D142DF844E8:browse_date:top=2289/1251,results=21
2007-07-17 15:25:04,866 INFO org.dspace.app.webui.servlet.BrowseServlet @
anonymous:session_id=3EECEBB19A77AF78FD28EE1BC78BD62E:browse_author:starts_with=Ramesha,
S.,results=21
2007-07-17 15:25:20,307 INFO org.dspace.app.webui.servlet.CommunityListServlet
@ [EMAIL
PROTECTED]:session_id=E3D2D9677362B86D78BC7E255977105C:view_community_list:
2007-07-17 15:25:24,142 INFO org.dspace.app.webui.servlet.DSpaceServlet @
[EMAIL
PROTECTED]:session_id=E3D2D9677362B86D78BC7E255977105C:view_community:community_id=24
2007-07-17 15:25:26,128 INFO org.dspace.app.webui.servlet.DSpaceServlet @
[EMAIL
PROTECTED]:session_id=E3D2D9677362B86D78BC7E255977105C:view_collection:collection_id=49
2007-07-17 15:25:33,090 INFO org.dspace.content.Community @ [EMAIL
PROTECTED]:session_id=E3D2D9677362B86D78BC7E255977105C:remove_collection:community_id=24,collection_id=49
2007-07-17 15:25:33,097 INFO org.dspace.content.Collection @ [EMAIL
PROTECTED]:session_id=E3D2D9677362B86D78BC7E255977105C:delete_collection:collection_id=49
2007-07-17 15:25:33,202 INFO org.dspace.content.Collection @ [EMAIL
PROTECTED]:session_id=E3D2D9677362B86D78BC7E255977105C:remove_logo:collection_id=49
2007-07-17 15:25:33,209 WARN org.dspace.app.webui.servlet.DSpaceServlet @
[EMAIL
PROTECTED]:session_id=E3D2D9677362B86D78BC7E255977105C:database_error:java.sql.SQLException:
ERROR: update or delete on "collection" violates foreign key constraint
"collection2item_collection_id_fkey" on "collection2item"
java.sql.SQLException: ERROR: update or delete on "collection" violates foreign
key constraint "collection2item_collection_id_fkey" on "collection2item"
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1471)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1256)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:175)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:389)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:314)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:264)
at
org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:225)
at
org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:284)
at
org.dspace.storage.rdbms.DatabaseManager.deleteByValue(DatabaseManager.java:431)
at
org.dspace.storage.rdbms.DatabaseManager.delete(DatabaseManager.java:400)
at
org.dspace.storage.rdbms.DatabaseManager.delete(DatabaseManager.java:591)
at org.dspace.content.Collection.delete(Collection.java:946)
at org.dspace.content.Community.removeCollection(Community.java:742)
at
org.dspace.app.webui.servlet.admin.EditCommunitiesServlet.doDSPost(EditCommunitiesServlet.java:275)
at
org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServlet.java:147)
at
org.dspace.app.webui.servlet.DSpaceServlet.doPost(DSpaceServlet.java:105)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
org.dspace.app.webui.filter.RegisteredOnlyFilter.doFilter(RegisteredOnlyFilter.java:100)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
2007-07-17 15:26:15,091 INFO org.dspace.app.webui.servlet.BrowseServlet @
anonymous:session_id=70305F832B17FD8E2B9F68BC5BCA5E11:browse_date:bottom=2289/2139,results=21
2007-07-17 15:26:20,020 INFO org.dspace.app.webui.servlet.DSpaceServlet @
anonymous:session_id=6CCE98D422FC16AEED76F26B6ECD54F6:view_item:handle=2289/3027
2007-07-17 15:26:30,010 INFO org.dspace.app.webui.servlet.RetrieveServlet @
anonymous:session_id=AABAEB426288EED4A5B4EC8A70CABD50:view_bitstream:bitstream_id=6035
2007-07-17 15:26:35,437 INFO org.dspace.app.webui.servlet.LogoutServlet @
[EMAIL PROTECTED]:session_id=E3D2D9677362B86D78BC7E255977105C:logout:
2007-07-17 15:27:11,310 INFO org.dspace.app.webui.servlet.RetrieveServlet @
anonymous:session_id=105BC24B61E8E7716EAE56547BF2B0DE:view_bitstream:bitstream_id=5395
2007-07-17 15:27:32,535 INFO org.dspace.app.webui.servlet.BrowseServlet @
anonymous:session_id=60F0567E6F665FBBB4EDA3B92F1DFDA3:browse_date:bottom=2289/2364,results=21
2007-07-17 15:27:35,016 INFO org.dspace.app.webui.servlet.BrowseServlet @
anonymous:session_id=EFAC5F50EE751B5CD5E37001EDC4A7E9:browse_author:top=Dodson,
R.,results=21
2007-07-17 15:28:26,254 INFO org.dspace.app.webui.servlet.BrowseServlet @
anonymous:session_id=CB15B44B6782D1F52174625737C567B2:browse_date:bottom=2289/2132,results=21
2007-07-17 15:28:32,367 INFO org.dspace.app.webui.servlet.BrowseServlet @
anonymous:session_id=8FF904A4D5926EB7873600CDBB5E2AE5:browse_author:top=Goodby,
J.M.,results=21
2007-07-17 15:29:43,575 INFO org.dspace.app.webui.servlet.BrowseServlet @
anonymous:session_id=C5A90CE35E7ACEFA44CB3878147C5889:browse_date:top=2289/997,results=21
2007-07-17 15:29:53,476 INFO org.dspace.app.webui.servlet.BrowseServlet @
anonymous:session_id=07A7489DED5CE72052D37B34659BB984:browse_date:bottom=2289/3127,results=21
2007-07-17 15:30:03,140 INFO org.dspace.app.webui.servlet.BrowseServlet @
anonymous:session_id=BA917E0A8E682DA524B75E6F8F7FA0CA:browse_date:bottom=2289/2248,results=21
2007-07-17 15:30:12,732 INFO org.dspace.app.webui.servlet.BrowseServlet @
anonymous:session_id=74F77AA51F06DC1D4A975DB2B4A5CDCD:browse_author:top=Samuel,
J.,results=21
2007-07-17 15:30:21,106 INFO org.dspace.app.webui.servlet.RetrieveServlet @
anonymous:session_id=57E587612F9C01F5BBC1FD1FD457ACCD:view_bitstream:bitstream_id=6308
2007-07-17 15:30:42,834 INFO org.dspace.app.webui.servlet.BrowseServlet @
anonymous:session_id=A7D1730CDB22F1217F2AF027A00ABA56:browse_author:bottom=Markandeyulu,
G.,results=21
2007-07-17 15:30:51,224 INFO org.dspace.app.webui.servlet.BrowseServlet @
anonymous:session_id=D00E71CD1EB8A76E912DE24E0C54FB78:browse_title:top=2289/634,results=21
2007-07-17 15:31:00,515 INFO org.dspace.app.webui.servlet.ItemsByAuthorServlet
@
anonymous:session_id=0E498229F57EF0ED31A16C82032565D8:items_by_author:order=date,result_count=1
2007-07-17 15:31:08,274 INFO org.dspace.app.webui.servlet.RetrieveServlet @
anonymous:session_id=AA4096ED9AF7EBE25C7260ED91CBCD32:view_bitstream:bitstream_id=3683
2007-07-17 15:31:09,747 INFO org.dspace.app.webui.servlet.DSpaceServlet @
anonymous:session_id=83CB6F6B554748EF0D3D615111190FC1:view_item:handle=2289/868
2007-07-17 15:32:13,702 INFO org.dspace.app.webui.servlet.BrowseServlet @
anonymous:session_id=47027140DF1FADDA161455B68F7B1938:browse_date:top=2289/415,results=21
2007-07-17 15:32:46,277 INFO org.dspace.app.webui.servlet.DSpaceServlet @
anonymous:session_id=BC4189C9DE6D5EA00549119EA60A734C:view_collection:collection_id=41
2007-07-17 15:32:55,708 INFO org.dspace.app.webui.servlet.BrowseServlet @
anonymous:session_id=EBAE4E7D82335F9F8465DDD259E07AC8:browse_date:bottom=2289/2550,results=21
2007-07-17 15:33:03,758 INFO org.dspace.app.webui.servlet.BrowseServlet @
anonymous:session_id=365276706030C44345F6DB0414F3DB5C:browse_author:starts_with=Edwards,
S.F.,results=21
2007-07-17 15:33:25,936 INFO org.dspace.app.webui.servlet.ItemsByAuthorServlet
@
anonymous:session_id=080CC513D769539E5913620A2976B1DD:items_by_author:order=date,result_count=1
2007-07-17 15:33:32,173 INFO org.dspace.app.webui.servlet.BrowseServlet @
anonymous:session_id=5EC4CABAA38AE8FF1141C09F34B11695:browse_date:bottom=2289/2119,results=21
2007-07-17 15:33:49,008 INFO org.dspace.app.webui.servlet.ItemsByAuthorServlet
@
anonymous:session_id=5D6D7484EE7C84398A7A16304B973433:items_by_author:order=date,result_count=1
2007-07-17 15:34:27,641 INFO org.dspace.app.webui.servlet.BrowseServlet @
anonymous:session_id=6FA31041B6E768E77D2C60D72F2380A3:browse_date:bottom=2289/1259,results=21
2007-07-17 15:34:30,594 INFO org.dspace.app.webui.servlet.BrowseServlet @
anonymous:session_id=C6B1BD544747E5A14B9DF69B8C14B084:browse_date:bottom=2289/1049,results=21
2007-07-17 15:34:43,627 INFO org.dspace.app.webui.servlet.BrowseServlet @
anonymous:session_id=9749EC12F4C8C88A02CC7D670CD5E03D:browse_author:top=Bhatt,
B.C.,results=21
2007-07-17 15:34:51,476 INFO org.dspace.app.webui.servlet.BrowseServlet @
anonymous:session_id=E371204CFDB422F219430C9C051483B0:browse_date:top=2289/1583,results=21
2007-07-17 15:35:17,344 INFO org.dspace.app.webui.servlet.BrowseServlet @
anonymous:session_id=E54CFA8E82586E5F817327D08F4E10E5:browse_author:bottom=Bremer,
M.,results=21
2007-07-17 15:36:54,156 INFO org.dspace.app.webui.servlet.BrowseServlet @
anonymous:session_id=F6F778C8BC116C209C51BF827C9C0A42:browse_author:top=Vudayagiri,
A.,results=21
2007-07-17 15:38:04,065 INFO org.dspace.app.webui.servlet.BrowseServlet @
anonymous:session_id=355BD45460F6BC7F8298421052790ACE:browse_author:bottom=Venkatesh,
G.,results=21
2007-07-17 15:38:32,162 INFO org.dspace.app.webui.servlet.BrowseServlet @
anonymous:session_id=C563855EEF0ADFA9E18FD6ED26472503:browse_author:bottom=Raveendran,
P.,results=21
2007-07-17 15:38:39,466 INFO org.dspace.app.webui.servlet.BrowseServlet @
anonymous:session_id=14A256F1369D16587089D846AD6EEF52:browse_title:bottom=2289/3172,results=21
2007-07-17 15:38:54,325 INFO org.dspace.app.webui.servlet.BrowseServlet @
anonymous:session_id=BBA3BA8281F32FB91FC410DF48199037:browse_author:top=Chandrasekhar,
S.,results=21
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
