Re: [Dspace-tech] Deleting a collection
Hi Fabio What browse-engine are you using? It seems that the collection is referenced from the lucene-index tables. try to delete it using ./dspace index-db-browse -fd and then try to delete the collection. then redo the browse only if you are using lucene browse indexing. regards I'm trying to delete a collection that was included for harvesting. An message error data integrity is appearing. org.postgresql.util.PSQLException: ERROR: update or delete on table item violates foreign key constraint bi_2_dmap_item_id_fkey on table bi_2_dmap Detail: Key (item_id)=(9707) is still referenced from table bi_2_dmap. This is a bug in 4.x ? Tks, Fabio Rosa -- ___ 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 -- --- Este mensaje no contiene virus ni malware porque la protección de avast! Antivirus está activa. http://www.avast.com -- ___ 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
Re: [Dspace-tech] Deleting a collection
Thanks Adam, I'm use XMLUI interface. This command deleted some tables but now still continue with an integrity error below. 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)=(9707) is still referenced from table communities2item. tks, Fabio Rosa - Mensagem original - De: Adan Roman aro...@arvo.es Para: dspace-tech@lists.sourceforge.net Enviadas: Sexta-feira, 24 de outubro de 2014 3:24:37 Assunto: Re: [Dspace-tech] Deleting a collection Hi Fabio What browse-engine are you using? It seems that the collection is referenced from the lucene-index tables. try to delete it using ./dspace index-db-browse -fd and then try to delete the collection. then redo the browse only if you are using lucene browse indexing. regards I'm trying to delete a collection that was included for harvesting. An message error data integrity is appearing. org.postgresql.util.PSQLException: ERROR: update or delete on table item violates foreign key constraint bi_2_dmap_item_id_fkey on table bi_2_dmap Detail: Key (item_id)=(9707) is still referenced from table bi_2_dmap. This is a bug in 4.x ? Tks, Fabio Rosa -- ___ 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 -- Este mensaje no contiene virus ni malware porque la protección de avast! Antivirus está activa. -- ___ 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
Re: [Dspace-tech] Deleting a collection
Drop the table, you can regenerate it later. regards Thanks Adam, I'm use XMLUI interface. This command deleted some tables but now still continue with an integrity error below. 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)=(9707) is still referenced from table communities2item. tks, Fabio Rosa *De: *Adan Roman aro...@arvo.es *Para: *dspace-tech@lists.sourceforge.net *Enviadas: *Sexta-feira, 24 de outubro de 2014 3:24:37 *Assunto: *Re: [Dspace-tech] Deleting a collection Hi Fabio What browse-engine are you using? It seems that the collection is referenced from the lucene-index tables. try to delete it using ./dspace index-db-browse -fd and then try to delete the collection. then redo the browse only if you are using lucene browse indexing. regards I'm trying to delete a collection that was included for harvesting. An message error data integrity is appearing. org.postgresql.util.PSQLException: ERROR: update or delete on table item violates foreign key constraint bi_2_dmap_item_id_fkey on table bi_2_dmap Detail: Key (item_id)=(9707) is still referenced from table bi_2_dmap. This is a bug in 4.x ? Tks, Fabio Rosa -- ___ 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 -- http://www.avast.com/ Este mensaje no contiene virus ni malware porque la protección de avast! Antivirus http://www.avast.com/ está activa. -- ___ 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 -- --- Este mensaje no contiene virus ni malware porque la protección de avast! Antivirus está activa. http://www.avast.com -- ___ 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
Re: [Dspace-tech] Deleting a collection
Analyzing the data model, I see a relationship between the entities item and community. Is this correct? Because there is already a relation item and collection. tks, Fabio Rosa - Mensagem original - De: FABIO ROSA fabio.r...@ufpe.br Para: Adan Roman aro...@arvo.es Cc: dspace-tech@lists.sourceforge.net Enviadas: Sexta-feira, 24 de outubro de 2014 8:30:55 Assunto: Re: [Dspace-tech] Deleting a collection Thanks Adam, I'm use XMLUI interface. This command deleted some tables but now still continue with an integrity error below. 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)=(9707) is still referenced from table communities2item. tks, Fabio Rosa - Mensagem original - De: Adan Roman aro...@arvo.es Para: dspace-tech@lists.sourceforge.net Enviadas: Sexta-feira, 24 de outubro de 2014 3:24:37 Assunto: Re: [Dspace-tech] Deleting a collection Hi Fabio What browse-engine are you using? It seems that the collection is referenced from the lucene-index tables. try to delete it using ./dspace index-db-browse -fd and then try to delete the collection. then redo the browse only if you are using lucene browse indexing. regards I'm trying to delete a collection that was included for harvesting. An message error data integrity is appearing. org.postgresql.util.PSQLException: ERROR: update or delete on table item violates foreign key constraint bi_2_dmap_item_id_fkey on table bi_2_dmap Detail: Key (item_id)=(9707) is still referenced from table bi_2_dmap. This is a bug in 4.x ? Tks, Fabio Rosa -- ___ 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 -- Este mensaje no contiene virus ni malware porque la protección de avast! Antivirus está activa. -- ___ 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 -- ___ 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] Deleting a collection
I'm trying to delete a collection that was included for harvesting. An message error data integrity is appearing. org.postgresql.util.PSQLException: ERROR: update or delete on table item violates foreign key constraint bi_2_dmap_item_id_fkey on table bi_2_dmap Detail: Key (item_id)=(9707) is still referenced from table bi_2_dmap. This is a bug in 4.x ? Tks, Fabio Rosa -- ___ 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
Re: [Dspace-tech] deleting a collection in dev
On Tue, Mar 5, 2013 at 8:18 PM, Jose Blanco blan...@umich.edu wrote: Today in my development environment I tried to delete a collection and got this error: org.postgresql.util.PSQLException: ERROR: update or delete on table item violates foreign key constraint $2 on table communities2item Detail: Key (item_id)=(216864) is still referenced from table communities2item. I looked at the item table and see that the contstraint is there, but if I look at the schema file in in 30, I see no constraint of the sort. Should I get rid of the constraint from the item table? Is communities2items updated every time the browse is update? How do entries get into communities2item? Hi Jose, AFAICT, communities2item is used only in these 2 places: https://github.com/DSpace/DSpace/blob/dspace-3.1/dspace-api/src/main/java/org/dspace/search/Harvest.java https://github.com/DSpace/DSpace/blob/dspace-3.1/dspace-api/src/main/java/org/dspace/browse/BrowseEngine.java So it seems the only thing it's used for is determining which items have been added/removed/changed within a community, which is implemented in the following use cases: * OAI server (only up to DSpace 1.8) * user's subscription notification * JSPUI feeds The table is not created staticaly, i.e. not in database_schema.sql. The class that seems to fill this table seems to be the BrowseDAO (e.g. BrowseDAOPostgres). I'm not sure how to forcibly invoke it, but index-update or index-init would be a safe bet. Regards, ~~helix84 Compulsory reading: DSpace Mailing List Etiquette https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette -- Symantec Endpoint Protection 12 positioned as A LEADER in The Forrester Wave(TM): Endpoint Security, Q1 2013 and remains a good choice in the endpoint security space. For insight on selecting the right partner to tackle endpoint security challenges, access the full report. http://p.sf.net/sfu/symantec-dev2dev ___ 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] deleting a collection in dev
Today in my development environment I tried to delete a collection and got this error: org.postgresql.util.PSQLException: ERROR: update or delete on table item violates foreign key constraint $2 on table communities2item Detail: Key (item_id)=(216864) is still referenced from table communities2item. I looked at the item table and see that the contstraint is there, but if I look at the schema file in in 30, I see no constraint of the sort. Should I get rid of the constraint from the item table? Is communities2items updated every time the browse is update? How do entries get into communities2item? Thanks! Jose -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_feb___ 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] Deleting a collection
Hi All, I just moved a collection under a community A. Then when I try to delete a community it brings internal system error Can you give a hint to figure out Thanks sisay -- What Every C/C++ and Fortran developer Should Know! Read this article and learn how Intel has extended the reach of its next-generation tools to help Windows* and Linux* C/C++ and Fortran developers boost performance applications - including clusters. http://p.sf.net/sfu/intel-dev2devmay___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
[Dspace-tech] Deleting a Collection
Hi! Using admin interface a collection with around 20,000 items were tasked to delete. After few minutes the system hangs (IMB RAM, 100 GB free disk space) and the web page is no longer accessible. Is there any way to delete this collection on the test system? Here we have dspace 1.4.1 on windows 2003/tomcat 6.0. I have given 500 MB in tomcat configure option - Java - Internal memory pool/ macimum memory pool/ thread stack size. Thanks, Jayan - 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 DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
