Re: [Dspace-tech] Trouble deleting records online in DSpace 1.7.1
Hello Susan, persistent identifiers in the sense of http://www.ietf.org/rfc/rfc1737.txt should be persistent and unique. See section Requirements for Uniform Resource Names 2. Requirements for functional capabilities Global uniqueness: The same URN will never be assigned to two different resources. Persistence: It is intended that the lifetime of a URN be permanent. That is, the URN will be globally unique forever, and may well be used as a reference to a resource well beyond the lifetime of the resource it identifies or of any naming authority involved in the assignment of its name. If your repository serves as a OAI-PMH data provider the oai identifiers are required to confirm to rfc 1737 too, see http://www.openarchives.org/OAI/2.0/guidelines-oai-identifier.htm Hope that helps Claudia Jürgen Am 04.02.2012 19:55, schrieb Thornton, Susan M. (LARC-B702)[LITES]: Is the issue with withdrawing vs. deleting an Item primarily about not allowing its persistent identifier to be reassigned/reused? Sue Walker-Thornton Software Developer|Database Administrator NASA Langley Research Center SGT, Inc.|LITES Contract 130 Research Drive Hampton, VA 23666 Office: (757) 864-2368|Fax: (757) 224-4001|Mobile: (757) 506-9903 Email: susan.m.thorn...@nasa.gov From: Claudia Juergen [claudia.juer...@ub.tu-dortmund.de] Sent: Friday, February 03, 2012 6:00 PM To: Thornton, Susan M. (LARC-B702)[LITES] Cc: DSpace-tech@lists.sourceforge.net; Dedmond, Nicole K. (LARC-B702)[LITES] Subject: Re: [Dspace-tech] Trouble deleting records online in DSpace 1.7.1 Hello Susan, good, otherwise you wouldn't have been able to to delete a collection or communitiy. This will most likely occur less frequently, allthough with regards to persistent id's deleting an item shouldn't occur too, rather withdrawing it. cu Claudia Jürgen I did go ahead and delete the other 2 constraints you mentioned, however I was able to delete a record online once I dropped just the collection2item $2 constraint. Thanks again for helping us solve this outstanding problem we've had since implementing 1.7.1! Best regards, Sue Sue Walker-Thornton (w): (757) 864-2368 (m): (757) 506-9903 -Original Message- From: Claudia Juergen [mailto:claudia.juer...@ub.tu-dortmund.de] Sent: Friday, February 03, 2012 12:51 PM To: Thornton, Susan M. (LARC-B702)[LITES] Cc: DSpace-tech@lists.sourceforge.net; Dedmond, Nicole K. (LARC-B702)[LITES] Subject: Re: [Dspace-tech] Trouble deleting records online in DSpace 1.7.1 Hello Susan, to be precise, there shoul have been 3 constraints referenced as $n to be deleted in: collection2item community2community community2collection as mentioned in my first post. Claudia Thanks so much Claudia! This fixed our problem!! Sue Sue Walker-Thornton (w): (757) 864-2368 (m): (757) 506-9903 -Original Message- From: Claudia Jürgen [mailto:claudia.juer...@ub.tu-dortmund.de] Sent: Friday, February 03, 2012 10:07 AM To: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Trouble deleting records online in DSpace 1.7.1 Hello Susan, no, in the case you ran into the below mentioned problem, you got to drop the nameless constraints, e.g.: ALTER TABLE collection2item DROP CONSTRAINT $2 The error you posted org.postgresql.util.PSQLException: ERROR: update or delete on table item violates foreign key constraint $2 on table collection2item Detail: Key (item_id)=(429349) is still referenced from table collection2item indicates that these constraints were not dropped. Hope that helps Claudia Jürgen Am 03.02.2012 15:52, schrieb Thornton, Susan M. (LARC-B702)[LITES]: Hi Claudia, I don't remember getting these errors when upgrading from 1.5 to 1.6, but we never really implemented 1.6 - I ran what I needed to run for database changes from 1.5 -- 1.6 -- 1.7 and implemented 1.7.1, so I may have missed it. So is this what you're saying I need to do? ALTER TABLE collection2item DROP CONSTRAINT collection2item_item_id_fkey; ALTER TABLE community2community DROP CONSTRAINT community2community_child_comm_id_fkey; ALTER TABLE community2collection DROP CONSTRAINT community2collection_collection_id_fkey; Thanks a bunch, Sue Sue Walker-Thornton (w): (757) 864-2368 (m): (757) 506-9903 -Original Message- From: Claudia Jürgen [mailto:claudia.juer...@ub.tu-dortmund.de] Sent: Thursday, February 02, 2012 3:31 AM To: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Trouble deleting records online in DSpace 1.7.1 Hello Susan, while updating to 1.6 did you get some errors like that: psql:database_schema_15-16.sql:105: ERROR: constraint community2collection_collection_id_fkey of relation community2collection does not exist ALTER TABLE psql:database_schema_15-16.sql:108: ERROR: constraint
Re: [Dspace-tech] Trouble deleting records online in DSpace 1.7.1
Hi Susan, No, the system keeps track of the highest assigned identifier and ups it by one, so there shouldn't be a case where one is re-used. I think the question is more to do with the purpose of an archive, and whether, once an identifier is out in the wild, it should disappear. It all depends on one's model, but if DSpace is being used as an archive (in the librarian's sense), any item placed in it should be retained for ever and ever. B-- On 2/4/2012 at 11:55 AM, in message F4F4775B-2F95-4018-9920-F6B0C944DA29@mimectl, Thornton, Susan M. (LARC-B702)[LITES] susan.m.thorn...@nasa.gov wrote: Is the issue with withdrawing vs. deleting an Item primarily about not allowing its persistent identifier to be reassigned/reused? Sue Walker-Thornton Software Developer|Database Administrator NASA Langley Research Center SGT, Inc.|LITES Contract 130 Research Drive Hampton, VA 23666 Office: (757) 864-2368|Fax: (757) 224-4001|Mobile: (757) 506-9903 Email: susan.m.thorn...@nasa.gov From: Claudia Juergen [claudia.juer...@ub.tu-dortmund.de] Sent: Friday, February 03, 2012 6:00 PM To: Thornton, Susan M. (LARC-B702)[LITES] Cc: DSpace-tech@lists.sourceforge.net; Dedmond, Nicole K. (LARC-B702)[LITES] Subject: Re: [Dspace-tech] Trouble deleting records online in DSpace 1.7.1 Hello Susan, good, otherwise you wouldn't have been able to to delete a collection or communitiy. This will most likely occur less frequently, allthough with regards to persistent id's deleting an item shouldn't occur too, rather withdrawing it. cu Claudia Jürgen I did go ahead and delete the other 2 constraints you mentioned, however I was able to delete a record online once I dropped just the collection2item $2 constraint. Thanks again for helping us solve this outstanding problem we've had since implementing 1.7.1! Best regards, Sue Sue Walker-Thornton (w): (757) 864-2368 (m): (757) 506-9903 -Original Message- From: Claudia Juergen [mailto:claudia.juer...@ub.tu-dortmund.de] Sent: Friday, February 03, 2012 12:51 PM To: Thornton, Susan M. (LARC-B702)[LITES] Cc: DSpace-tech@lists.sourceforge.net; Dedmond, Nicole K. (LARC-B702)[LITES] Subject: Re: [Dspace-tech] Trouble deleting records online in DSpace 1.7.1 Hello Susan, to be precise, there shoul have been 3 constraints referenced as $n to be deleted in: collection2item community2community community2collection as mentioned in my first post. Claudia Thanks so much Claudia! This fixed our problem!! Sue Sue Walker-Thornton (w): (757) 864-2368 (m): (757) 506-9903 -Original Message- From: Claudia Jürgen [mailto:claudia.juer...@ub.tu-dortmund.de] Sent: Friday, February 03, 2012 10:07 AM To: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Trouble deleting records online in DSpace 1.7.1 Hello Susan, no, in the case you ran into the below mentioned problem, you got to drop the nameless constraints, e.g.: ALTER TABLE collection2item DROP CONSTRAINT $2 The error you posted org.postgresql.util.PSQLException: ERROR: update or delete on table item violates foreign key constraint $2 on table collection2item Detail: Key (item_id)=(429349) is still referenced from table collection2item indicates that these constraints were not dropped. Hope that helps Claudia Jürgen Am 03.02.2012 15:52, schrieb Thornton, Susan M. (LARC-B702)[LITES]: Hi Claudia, I don't remember getting these errors when upgrading from 1.5 to 1.6, but we never really implemented 1.6 - I ran what I needed to run for database c hanges from 1.5 -- 1.6 -- 1.7 and implemented 1.7.1, so I may have missed it. So is this what you're saying I need to do? ALTER TABLE collection2item DROP CONSTRAINT collection2item_item_id_fkey; ALTER TABLE community2community DROP CONSTRAINT community2community_child_comm_id_fkey; ALTER TABLE community2collection DROP CONSTRAINT community2collection_collection_id_fkey; Thanks a bunch, Sue Sue Walker-Thornton (w): (757) 864-2368 (m): (757) 506-9903 -Original Message- From: Claudia Jürgen [mailto:claudia.juer...@ub.tu-dortmund.de] Sent: Thursday, February 02, 2012 3:31 AM To: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Trouble deleting records online in DSpace 1.7.1 Hello Susan, while updating to 1.6 did you get some errors like that: psql:database_schema_15-16.sql:105: ERROR: constraint community2collection_collection_id_fkey of relation community2collection does not exist ALTER TABLE psql:database_schema_15-16.sql:108: ERROR: constraint community2community_child_comm_id_fkey of relation community2community does not exist ALTER TABLE psql:database_schema_15-16.sql:111: ERROR: constraint collection2item_item_id_fkey of relation collection2item does not exist If so, inspect your database and use the references for the foreign
Re: [Dspace-tech] Trouble deleting records online in DSpace 1.7.1
Is the issue with withdrawing vs. deleting an Item primarily about not allowing its persistent identifier to be reassigned/reused? Sue Walker-Thornton Software Developer|Database Administrator NASA Langley Research Center SGT, Inc.|LITES Contract 130 Research Drive Hampton, VA 23666 Office: (757) 864-2368|Fax: (757) 224-4001|Mobile: (757) 506-9903 Email: susan.m.thorn...@nasa.gov From: Claudia Juergen [claudia.juer...@ub.tu-dortmund.de] Sent: Friday, February 03, 2012 6:00 PM To: Thornton, Susan M. (LARC-B702)[LITES] Cc: DSpace-tech@lists.sourceforge.net; Dedmond, Nicole K. (LARC-B702)[LITES] Subject: Re: [Dspace-tech] Trouble deleting records online in DSpace 1.7.1 Hello Susan, good, otherwise you wouldn't have been able to to delete a collection or communitiy. This will most likely occur less frequently, allthough with regards to persistent id's deleting an item shouldn't occur too, rather withdrawing it. cu Claudia Jürgen I did go ahead and delete the other 2 constraints you mentioned, however I was able to delete a record online once I dropped just the collection2item $2 constraint. Thanks again for helping us solve this outstanding problem we've had since implementing 1.7.1! Best regards, Sue Sue Walker-Thornton (w): (757) 864-2368 (m): (757) 506-9903 -Original Message- From: Claudia Juergen [mailto:claudia.juer...@ub.tu-dortmund.de] Sent: Friday, February 03, 2012 12:51 PM To: Thornton, Susan M. (LARC-B702)[LITES] Cc: DSpace-tech@lists.sourceforge.net; Dedmond, Nicole K. (LARC-B702)[LITES] Subject: Re: [Dspace-tech] Trouble deleting records online in DSpace 1.7.1 Hello Susan, to be precise, there shoul have been 3 constraints referenced as $n to be deleted in: collection2item community2community community2collection as mentioned in my first post. Claudia Thanks so much Claudia! This fixed our problem!! Sue Sue Walker-Thornton (w): (757) 864-2368 (m): (757) 506-9903 -Original Message- From: Claudia Jürgen [mailto:claudia.juer...@ub.tu-dortmund.de] Sent: Friday, February 03, 2012 10:07 AM To: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Trouble deleting records online in DSpace 1.7.1 Hello Susan, no, in the case you ran into the below mentioned problem, you got to drop the nameless constraints, e.g.: ALTER TABLE collection2item DROP CONSTRAINT $2 The error you posted org.postgresql.util.PSQLException: ERROR: update or delete on table item violates foreign key constraint $2 on table collection2item Detail: Key (item_id)=(429349) is still referenced from table collection2item indicates that these constraints were not dropped. Hope that helps Claudia Jürgen Am 03.02.2012 15:52, schrieb Thornton, Susan M. (LARC-B702)[LITES]: Hi Claudia, I don't remember getting these errors when upgrading from 1.5 to 1.6, but we never really implemented 1.6 - I ran what I needed to run for database changes from 1.5 -- 1.6 -- 1.7 and implemented 1.7.1, so I may have missed it. So is this what you're saying I need to do? ALTER TABLE collection2item DROP CONSTRAINT collection2item_item_id_fkey; ALTER TABLE community2community DROP CONSTRAINT community2community_child_comm_id_fkey; ALTER TABLE community2collection DROP CONSTRAINT community2collection_collection_id_fkey; Thanks a bunch, Sue Sue Walker-Thornton (w): (757) 864-2368 (m): (757) 506-9903 -Original Message- From: Claudia Jürgen [mailto:claudia.juer...@ub.tu-dortmund.de] Sent: Thursday, February 02, 2012 3:31 AM To: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Trouble deleting records online in DSpace 1.7.1 Hello Susan, while updating to 1.6 did you get some errors like that: psql:database_schema_15-16.sql:105: ERROR: constraint community2collection_collection_id_fkey of relation community2collection does not exist ALTER TABLE psql:database_schema_15-16.sql:108: ERROR: constraint community2community_child_comm_id_fkey of relation community2community does not exist ALTER TABLE psql:database_schema_15-16.sql:111: ERROR: constraint collection2item_item_id_fkey of relation collection2item does not exist If so, inspect your database and use the references for the foreign keys to delete them, e.g:: psql [YourDBName] \d [TableName] will show you the foreign keys, e.g.: \d community2collection Table public.community2collection Column | Type | Modifiers ---+-+--- id| integer | not null community_id | integer | collection_id | integer | Indexes: community2collection_pkey PRIMARY KEY, btree (id) community2collection_collection_id_idx btree (collection_id) community2collection_community_id_idx btree (community_id) Foreign-key constraints: $1 FOREIGN KEY (community_id) REFERENCES community
Re: [Dspace-tech] Trouble deleting records online in DSpace 1.7.1
Hi Claudia, I don't remember getting these errors when upgrading from 1.5 to 1.6, but we never really implemented 1.6 - I ran what I needed to run for database changes from 1.5 -- 1.6 -- 1.7 and implemented 1.7.1, so I may have missed it. So is this what you're saying I need to do? ALTER TABLE collection2item DROP CONSTRAINT collection2item_item_id_fkey; ALTER TABLE community2community DROP CONSTRAINT community2community_child_comm_id_fkey; ALTER TABLE community2collection DROP CONSTRAINT community2collection_collection_id_fkey; Thanks a bunch, Sue Sue Walker-Thornton (w): (757) 864-2368 (m): (757) 506-9903 -Original Message- From: Claudia Jürgen [mailto:claudia.juer...@ub.tu-dortmund.de] Sent: Thursday, February 02, 2012 3:31 AM To: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Trouble deleting records online in DSpace 1.7.1 Hello Susan, while updating to 1.6 did you get some errors like that: psql:database_schema_15-16.sql:105: ERROR: constraint community2collection_collection_id_fkey of relation community2collection does not exist ALTER TABLE psql:database_schema_15-16.sql:108: ERROR: constraint community2community_child_comm_id_fkey of relation community2community does not exist ALTER TABLE psql:database_schema_15-16.sql:111: ERROR: constraint collection2item_item_id_fkey of relation collection2item does not exist If so, inspect your database and use the references for the foreign keys to delete them, e.g:: psql [YourDBName] \d [TableName] will show you the foreign keys, e.g.: \d community2collection Table public.community2collection Column | Type | Modifiers ---+-+--- id| integer | not null community_id | integer | collection_id | integer | Indexes: community2collection_pkey PRIMARY KEY, btree (id) community2collection_collection_id_idx btree (collection_id) community2collection_community_id_idx btree (community_id) Foreign-key constraints: $1 FOREIGN KEY (community_id) REFERENCES community(community_id) $2 FOREIGN KEY (collection_id) REFERENCES collection(collection_id) In that case you got to run: ALTER TABLE collection2item DROP CONSTRAINT $2; ALTER TABLE community2community DROP CONSTRAINT $2; ALTER TABLE community2collection DROP CONSTRAINT $2; The reason for this is: In Step 7 Update the database it can happen that not all the commands in the database_schema_15-16.sql are executed properly. The commands to drop foreign keys: ALTER TABLE collection2item DROP CONSTRAINT collection2item_item_id_fkey; ALTER TABLE community2community DROP CONSTRAINT community2community_child_comm_id_fkey; ALTER TABLE community2collection DROP CONSTRAINT community2collection_collection_id_fkey; assume that the keys got default names, whereas depending on the database version and operating system on which your instance started, they can have no names and just be counted internally. If you got no names or other names the script will skip the commands, with the above mentioned ERROR. This will lead to errors running DSpace as now 2 contraints exist and one is unable to delete items, collections etc. Hope that helps Claudia Jürgen Am 01.02.2012 20:46, schrieb Thornton, Susan M. (LARC-B702)[LITES]: Hello, After recently upgrading from DSpace 1.5.1 to 1.7.1, we are getting the following error whenever we try to delete an Item online: 2012-02-01 14:40:17,883 WARN org.dspace.app.webui.servlet.DSpaceServlet @ susan.m.thorn...@nasa.gov:session_id=B6C011F3369B678E2FB9ED4B0050:ip_addr=999.99.99.999:database_error:org.postgresql.util.PSQLException\colonmailto:susan.m.thorn...@nasa.gov:session_id=B6C011F3369B678E2FB9ED4B0050:ip_addr=999.99.99.999:database_error:org.postgresql.util.PSQLException\colon; ERROR\colon; update or delete on table item violates foreign key constraint $2 on table collection2item Detail\colon; Key (item_id)=(429349) is still referenced from table collection2item. org.postgresql.util.PSQLException: ERROR: update or delete on table item violates foreign key constraint $2 on table collection2item Detail: Key (item_id)=(429349) is still referenced from table collection2item. I found some old dspace-tech postings regarding this error and am wondering if the recommended fix is correct? Not sure how this one happened: after upgrading to dspace 1.6, we're having trouble deleting items from dspace. We get an error message explaining that 'update or delete on item violates foreign key constraint $2 on collection2item'. Describing collection2item yields: Table public.collection2item Column | Type | Modifiers ---+-+--- id| integer | not null collection_id | integer | item_id | integer | Indexes: collection2item_pkey
Re: [Dspace-tech] Trouble deleting records online in DSpace 1.7.1
Hello Susan, no, in the case you ran into the below mentioned problem, you got to drop the nameless constraints, e.g.: ALTER TABLE collection2item DROP CONSTRAINT $2 The error you posted org.postgresql.util.PSQLException: ERROR: update or delete on table item violates foreign key constraint $2 on table collection2item Detail: Key (item_id)=(429349) is still referenced from table collection2item indicates that these constraints were not dropped. Hope that helps Claudia Jürgen Am 03.02.2012 15:52, schrieb Thornton, Susan M. (LARC-B702)[LITES]: Hi Claudia, I don't remember getting these errors when upgrading from 1.5 to 1.6, but we never really implemented 1.6 - I ran what I needed to run for database changes from 1.5 -- 1.6 -- 1.7 and implemented 1.7.1, so I may have missed it. So is this what you're saying I need to do? ALTER TABLE collection2item DROP CONSTRAINT collection2item_item_id_fkey; ALTER TABLE community2community DROP CONSTRAINT community2community_child_comm_id_fkey; ALTER TABLE community2collection DROP CONSTRAINT community2collection_collection_id_fkey; Thanks a bunch, Sue Sue Walker-Thornton (w): (757) 864-2368 (m): (757) 506-9903 -Original Message- From: Claudia Jürgen [mailto:claudia.juer...@ub.tu-dortmund.de] Sent: Thursday, February 02, 2012 3:31 AM To: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Trouble deleting records online in DSpace 1.7.1 Hello Susan, while updating to 1.6 did you get some errors like that: psql:database_schema_15-16.sql:105: ERROR: constraint community2collection_collection_id_fkey of relation community2collection does not exist ALTER TABLE psql:database_schema_15-16.sql:108: ERROR: constraint community2community_child_comm_id_fkey of relation community2community does not exist ALTER TABLE psql:database_schema_15-16.sql:111: ERROR: constraint collection2item_item_id_fkey of relation collection2item does not exist If so, inspect your database and use the references for the foreign keys to delete them, e.g:: psql [YourDBName] \d [TableName] will show you the foreign keys, e.g.: \d community2collection Table public.community2collection Column | Type | Modifiers ---+-+--- id| integer | not null community_id | integer | collection_id | integer | Indexes: community2collection_pkey PRIMARY KEY, btree (id) community2collection_collection_id_idx btree (collection_id) community2collection_community_id_idx btree (community_id) Foreign-key constraints: $1 FOREIGN KEY (community_id) REFERENCES community(community_id) $2 FOREIGN KEY (collection_id) REFERENCES collection(collection_id) In that case you got to run: ALTER TABLE collection2item DROP CONSTRAINT $2; ALTER TABLE community2community DROP CONSTRAINT $2; ALTER TABLE community2collection DROP CONSTRAINT $2; The reason for this is: In Step 7 Update the database it can happen that not all the commands in the database_schema_15-16.sql are executed properly. The commands to drop foreign keys: ALTER TABLE collection2item DROP CONSTRAINT collection2item_item_id_fkey; ALTER TABLE community2community DROP CONSTRAINT community2community_child_comm_id_fkey; ALTER TABLE community2collection DROP CONSTRAINT community2collection_collection_id_fkey; assume that the keys got default names, whereas depending on the database version and operating system on which your instance started, they can have no names and just be counted internally. If you got no names or other names the script will skip the commands, with the above mentioned ERROR. This will lead to errors running DSpace as now 2 contraints exist and one is unable to delete items, collections etc. Hope that helps Claudia Jürgen Am 01.02.2012 20:46, schrieb Thornton, Susan M. (LARC-B702)[LITES]: Hello, After recently upgrading from DSpace 1.5.1 to 1.7.1, we are getting the following error whenever we try to delete an Item online: 2012-02-01 14:40:17,883 WARN org.dspace.app.webui.servlet.DSpaceServlet @ susan.m.thorn...@nasa.gov:session_id=B6C011F3369B678E2FB9ED4B0050:ip_addr=999.99.99.999:database_error:org.postgresql.util.PSQLException\colonmailto:susan.m.thorn...@nasa.gov:session_id=B6C011F3369B678E2FB9ED4B0050:ip_addr=999.99.99.999:database_error:org.postgresql.util.PSQLException\colon; ERROR\colon; update or delete on table item violates foreign key constraint $2 on table collection2item Detail\colon; Key (item_id)=(429349) is still referenced from table collection2item. org.postgresql.util.PSQLException: ERROR: update or delete on table item violates foreign key constraint $2 on table collection2item Detail: Key (item_id)=(429349) is still referenced from table collection2item. I found
Re: [Dspace-tech] Trouble deleting records online in DSpace 1.7.1
Thanks so much Claudia! This fixed our problem!! Sue Sue Walker-Thornton (w): (757) 864-2368 (m): (757) 506-9903 -Original Message- From: Claudia Jürgen [mailto:claudia.juer...@ub.tu-dortmund.de] Sent: Friday, February 03, 2012 10:07 AM To: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Trouble deleting records online in DSpace 1.7.1 Hello Susan, no, in the case you ran into the below mentioned problem, you got to drop the nameless constraints, e.g.: ALTER TABLE collection2item DROP CONSTRAINT $2 The error you posted org.postgresql.util.PSQLException: ERROR: update or delete on table item violates foreign key constraint $2 on table collection2item Detail: Key (item_id)=(429349) is still referenced from table collection2item indicates that these constraints were not dropped. Hope that helps Claudia Jürgen Am 03.02.2012 15:52, schrieb Thornton, Susan M. (LARC-B702)[LITES]: Hi Claudia, I don't remember getting these errors when upgrading from 1.5 to 1.6, but we never really implemented 1.6 - I ran what I needed to run for database changes from 1.5 -- 1.6 -- 1.7 and implemented 1.7.1, so I may have missed it. So is this what you're saying I need to do? ALTER TABLE collection2item DROP CONSTRAINT collection2item_item_id_fkey; ALTER TABLE community2community DROP CONSTRAINT community2community_child_comm_id_fkey; ALTER TABLE community2collection DROP CONSTRAINT community2collection_collection_id_fkey; Thanks a bunch, Sue Sue Walker-Thornton (w): (757) 864-2368 (m): (757) 506-9903 -Original Message- From: Claudia Jürgen [mailto:claudia.juer...@ub.tu-dortmund.de] Sent: Thursday, February 02, 2012 3:31 AM To: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Trouble deleting records online in DSpace 1.7.1 Hello Susan, while updating to 1.6 did you get some errors like that: psql:database_schema_15-16.sql:105: ERROR: constraint community2collection_collection_id_fkey of relation community2collection does not exist ALTER TABLE psql:database_schema_15-16.sql:108: ERROR: constraint community2community_child_comm_id_fkey of relation community2community does not exist ALTER TABLE psql:database_schema_15-16.sql:111: ERROR: constraint collection2item_item_id_fkey of relation collection2item does not exist If so, inspect your database and use the references for the foreign keys to delete them, e.g:: psql [YourDBName] \d [TableName] will show you the foreign keys, e.g.: \d community2collection Table public.community2collection Column | Type | Modifiers ---+-+--- id| integer | not null community_id | integer | collection_id | integer | Indexes: community2collection_pkey PRIMARY KEY, btree (id) community2collection_collection_id_idx btree (collection_id) community2collection_community_id_idx btree (community_id) Foreign-key constraints: $1 FOREIGN KEY (community_id) REFERENCES community(community_id) $2 FOREIGN KEY (collection_id) REFERENCES collection(collection_id) In that case you got to run: ALTER TABLE collection2item DROP CONSTRAINT $2; ALTER TABLE community2community DROP CONSTRAINT $2; ALTER TABLE community2collection DROP CONSTRAINT $2; The reason for this is: In Step 7 Update the database it can happen that not all the commands in the database_schema_15-16.sql are executed properly. The commands to drop foreign keys: ALTER TABLE collection2item DROP CONSTRAINT collection2item_item_id_fkey; ALTER TABLE community2community DROP CONSTRAINT community2community_child_comm_id_fkey; ALTER TABLE community2collection DROP CONSTRAINT community2collection_collection_id_fkey; assume that the keys got default names, whereas depending on the database version and operating system on which your instance started, they can have no names and just be counted internally. If you got no names or other names the script will skip the commands, with the above mentioned ERROR. This will lead to errors running DSpace as now 2 contraints exist and one is unable to delete items, collections etc. Hope that helps Claudia Jürgen Am 01.02.2012 20:46, schrieb Thornton, Susan M. (LARC-B702)[LITES]: Hello, After recently upgrading from DSpace 1.5.1 to 1.7.1, we are getting the following error whenever we try to delete an Item online: 2012-02-01 14:40:17,883 WARN org.dspace.app.webui.servlet.DSpaceServlet @ susan.m.thorn...@nasa.gov:session_id=B6C011F3369B678E2FB9ED4B0050:ip_addr=999.99.99.999:database_error:org.postgresql.util.PSQLException\colonmailto:susan.m.thorn...@nasa.gov:session_id=B6C011F3369B678E2FB9ED4B0050:ip_addr=999.99.99.999:database_error:org.postgresql.util.PSQLException\colon; ERROR\colon; update or delete on table item violates
Re: [Dspace-tech] Trouble deleting records online in DSpace 1.7.1
Hello Susan, to be precise, there shoul have been 3 constraints referenced as $n to be deleted in: collection2item community2community community2collection as mentioned in my first post. Claudia Thanks so much Claudia! This fixed our problem!! Sue Sue Walker-Thornton (w): (757) 864-2368 (m): (757) 506-9903 -Original Message- From: Claudia Jürgen [mailto:claudia.juer...@ub.tu-dortmund.de] Sent: Friday, February 03, 2012 10:07 AM To: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Trouble deleting records online in DSpace 1.7.1 Hello Susan, no, in the case you ran into the below mentioned problem, you got to drop the nameless constraints, e.g.: ALTER TABLE collection2item DROP CONSTRAINT $2 The error you posted org.postgresql.util.PSQLException: ERROR: update or delete on table item violates foreign key constraint $2 on table collection2item Detail: Key (item_id)=(429349) is still referenced from table collection2item indicates that these constraints were not dropped. Hope that helps Claudia Jürgen Am 03.02.2012 15:52, schrieb Thornton, Susan M. (LARC-B702)[LITES]: Hi Claudia, I don't remember getting these errors when upgrading from 1.5 to 1.6, but we never really implemented 1.6 - I ran what I needed to run for database changes from 1.5 -- 1.6 -- 1.7 and implemented 1.7.1, so I may have missed it. So is this what you're saying I need to do? ALTER TABLE collection2item DROP CONSTRAINT collection2item_item_id_fkey; ALTER TABLE community2community DROP CONSTRAINT community2community_child_comm_id_fkey; ALTER TABLE community2collection DROP CONSTRAINT community2collection_collection_id_fkey; Thanks a bunch, Sue Sue Walker-Thornton (w): (757) 864-2368 (m): (757) 506-9903 -Original Message- From: Claudia Jürgen [mailto:claudia.juer...@ub.tu-dortmund.de] Sent: Thursday, February 02, 2012 3:31 AM To: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Trouble deleting records online in DSpace 1.7.1 Hello Susan, while updating to 1.6 did you get some errors like that: psql:database_schema_15-16.sql:105: ERROR: constraint community2collection_collection_id_fkey of relation community2collection does not exist ALTER TABLE psql:database_schema_15-16.sql:108: ERROR: constraint community2community_child_comm_id_fkey of relation community2community does not exist ALTER TABLE psql:database_schema_15-16.sql:111: ERROR: constraint collection2item_item_id_fkey of relation collection2item does not exist If so, inspect your database and use the references for the foreign keys to delete them, e.g:: psql [YourDBName] \d [TableName] will show you the foreign keys, e.g.: \d community2collection Table public.community2collection Column | Type | Modifiers ---+-+--- id| integer | not null community_id | integer | collection_id | integer | Indexes: community2collection_pkey PRIMARY KEY, btree (id) community2collection_collection_id_idx btree (collection_id) community2collection_community_id_idx btree (community_id) Foreign-key constraints: $1 FOREIGN KEY (community_id) REFERENCES community(community_id) $2 FOREIGN KEY (collection_id) REFERENCES collection(collection_id) In that case you got to run: ALTER TABLE collection2item DROP CONSTRAINT $2; ALTER TABLE community2community DROP CONSTRAINT $2; ALTER TABLE community2collection DROP CONSTRAINT $2; The reason for this is: In Step 7 Update the database it can happen that not all the commands in the database_schema_15-16.sql are executed properly. The commands to drop foreign keys: ALTER TABLE collection2item DROP CONSTRAINT collection2item_item_id_fkey; ALTER TABLE community2community DROP CONSTRAINT community2community_child_comm_id_fkey; ALTER TABLE community2collection DROP CONSTRAINT community2collection_collection_id_fkey; assume that the keys got default names, whereas depending on the database version and operating system on which your instance started, they can have no names and just be counted internally. If you got no names or other names the script will skip the commands, with the above mentioned ERROR. This will lead to errors running DSpace as now 2 contraints exist and one is unable to delete items, collections etc. Hope that helps Claudia Jürgen Am 01.02.2012 20:46, schrieb Thornton, Susan M. (LARC-B702)[LITES]: Hello, After recently upgrading from DSpace 1.5.1 to 1.7.1, we are getting the following error whenever we try to delete an Item online: 2012-02-01 14:40:17,883 WARN org.dspace.app.webui.servlet.DSpaceServlet @ susan.m.thorn...@nasa.gov:session_id=B6C011F3369B678E2FB9ED4B0050:ip_addr=999.99.99.999:database_error:org.postgresql.util.PSQLException\colonmailto:susan.m.thorn
Re: [Dspace-tech] Trouble deleting records online in DSpace 1.7.1
I did go ahead and delete the other 2 constraints you mentioned, however I was able to delete a record online once I dropped just the collection2item $2 constraint. Thanks again for helping us solve this outstanding problem we've had since implementing 1.7.1! Best regards, Sue Sue Walker-Thornton (w): (757) 864-2368 (m): (757) 506-9903 -Original Message- From: Claudia Juergen [mailto:claudia.juer...@ub.tu-dortmund.de] Sent: Friday, February 03, 2012 12:51 PM To: Thornton, Susan M. (LARC-B702)[LITES] Cc: DSpace-tech@lists.sourceforge.net; Dedmond, Nicole K. (LARC-B702)[LITES] Subject: Re: [Dspace-tech] Trouble deleting records online in DSpace 1.7.1 Hello Susan, to be precise, there shoul have been 3 constraints referenced as $n to be deleted in: collection2item community2community community2collection as mentioned in my first post. Claudia Thanks so much Claudia! This fixed our problem!! Sue Sue Walker-Thornton (w): (757) 864-2368 (m): (757) 506-9903 -Original Message- From: Claudia Jürgen [mailto:claudia.juer...@ub.tu-dortmund.de] Sent: Friday, February 03, 2012 10:07 AM To: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Trouble deleting records online in DSpace 1.7.1 Hello Susan, no, in the case you ran into the below mentioned problem, you got to drop the nameless constraints, e.g.: ALTER TABLE collection2item DROP CONSTRAINT $2 The error you posted org.postgresql.util.PSQLException: ERROR: update or delete on table item violates foreign key constraint $2 on table collection2item Detail: Key (item_id)=(429349) is still referenced from table collection2item indicates that these constraints were not dropped. Hope that helps Claudia Jürgen Am 03.02.2012 15:52, schrieb Thornton, Susan M. (LARC-B702)[LITES]: Hi Claudia, I don't remember getting these errors when upgrading from 1.5 to 1.6, but we never really implemented 1.6 - I ran what I needed to run for database changes from 1.5 -- 1.6 -- 1.7 and implemented 1.7.1, so I may have missed it. So is this what you're saying I need to do? ALTER TABLE collection2item DROP CONSTRAINT collection2item_item_id_fkey; ALTER TABLE community2community DROP CONSTRAINT community2community_child_comm_id_fkey; ALTER TABLE community2collection DROP CONSTRAINT community2collection_collection_id_fkey; Thanks a bunch, Sue Sue Walker-Thornton (w): (757) 864-2368 (m): (757) 506-9903 -Original Message- From: Claudia Jürgen [mailto:claudia.juer...@ub.tu-dortmund.de] Sent: Thursday, February 02, 2012 3:31 AM To: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Trouble deleting records online in DSpace 1.7.1 Hello Susan, while updating to 1.6 did you get some errors like that: psql:database_schema_15-16.sql:105: ERROR: constraint community2collection_collection_id_fkey of relation community2collection does not exist ALTER TABLE psql:database_schema_15-16.sql:108: ERROR: constraint community2community_child_comm_id_fkey of relation community2community does not exist ALTER TABLE psql:database_schema_15-16.sql:111: ERROR: constraint collection2item_item_id_fkey of relation collection2item does not exist If so, inspect your database and use the references for the foreign keys to delete them, e.g:: psql [YourDBName] \d [TableName] will show you the foreign keys, e.g.: \d community2collection Table public.community2collection Column | Type | Modifiers ---+-+--- id| integer | not null community_id | integer | collection_id | integer | Indexes: community2collection_pkey PRIMARY KEY, btree (id) community2collection_collection_id_idx btree (collection_id) community2collection_community_id_idx btree (community_id) Foreign-key constraints: $1 FOREIGN KEY (community_id) REFERENCES community(community_id) $2 FOREIGN KEY (collection_id) REFERENCES collection(collection_id) In that case you got to run: ALTER TABLE collection2item DROP CONSTRAINT $2; ALTER TABLE community2community DROP CONSTRAINT $2; ALTER TABLE community2collection DROP CONSTRAINT $2; The reason for this is: In Step 7 Update the database it can happen that not all the commands in the database_schema_15-16.sql are executed properly. The commands to drop foreign keys: ALTER TABLE collection2item DROP CONSTRAINT collection2item_item_id_fkey; ALTER TABLE community2community DROP CONSTRAINT community2community_child_comm_id_fkey; ALTER TABLE community2collection DROP CONSTRAINT community2collection_collection_id_fkey; assume that the keys got default names, whereas depending on the database version and operating system on which your instance started, they can have no names and just be counted internally. If you got no names or other
Re: [Dspace-tech] Trouble deleting records online in DSpace 1.7.1
Hello Susan, good, otherwise you wouldn't have been able to to delete a collection or communitiy. This will most likely occur less frequently, allthough with regards to persistent id's deleting an item shouldn't occur too, rather withdrawing it. cu Claudia Jürgen I did go ahead and delete the other 2 constraints you mentioned, however I was able to delete a record online once I dropped just the collection2item $2 constraint. Thanks again for helping us solve this outstanding problem we've had since implementing 1.7.1! Best regards, Sue Sue Walker-Thornton (w): (757) 864-2368 (m): (757) 506-9903 -Original Message- From: Claudia Juergen [mailto:claudia.juer...@ub.tu-dortmund.de] Sent: Friday, February 03, 2012 12:51 PM To: Thornton, Susan M. (LARC-B702)[LITES] Cc: DSpace-tech@lists.sourceforge.net; Dedmond, Nicole K. (LARC-B702)[LITES] Subject: Re: [Dspace-tech] Trouble deleting records online in DSpace 1.7.1 Hello Susan, to be precise, there shoul have been 3 constraints referenced as $n to be deleted in: collection2item community2community community2collection as mentioned in my first post. Claudia Thanks so much Claudia! This fixed our problem!! Sue Sue Walker-Thornton (w): (757) 864-2368 (m): (757) 506-9903 -Original Message- From: Claudia Jürgen [mailto:claudia.juer...@ub.tu-dortmund.de] Sent: Friday, February 03, 2012 10:07 AM To: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Trouble deleting records online in DSpace 1.7.1 Hello Susan, no, in the case you ran into the below mentioned problem, you got to drop the nameless constraints, e.g.: ALTER TABLE collection2item DROP CONSTRAINT $2 The error you posted org.postgresql.util.PSQLException: ERROR: update or delete on table item violates foreign key constraint $2 on table collection2item Detail: Key (item_id)=(429349) is still referenced from table collection2item indicates that these constraints were not dropped. Hope that helps Claudia Jürgen Am 03.02.2012 15:52, schrieb Thornton, Susan M. (LARC-B702)[LITES]: Hi Claudia, I don't remember getting these errors when upgrading from 1.5 to 1.6, but we never really implemented 1.6 - I ran what I needed to run for database changes from 1.5 -- 1.6 -- 1.7 and implemented 1.7.1, so I may have missed it. So is this what you're saying I need to do? ALTER TABLE collection2item DROP CONSTRAINT collection2item_item_id_fkey; ALTER TABLE community2community DROP CONSTRAINT community2community_child_comm_id_fkey; ALTER TABLE community2collection DROP CONSTRAINT community2collection_collection_id_fkey; Thanks a bunch, Sue Sue Walker-Thornton (w): (757) 864-2368 (m): (757) 506-9903 -Original Message- From: Claudia Jürgen [mailto:claudia.juer...@ub.tu-dortmund.de] Sent: Thursday, February 02, 2012 3:31 AM To: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Trouble deleting records online in DSpace 1.7.1 Hello Susan, while updating to 1.6 did you get some errors like that: psql:database_schema_15-16.sql:105: ERROR: constraint community2collection_collection_id_fkey of relation community2collection does not exist ALTER TABLE psql:database_schema_15-16.sql:108: ERROR: constraint community2community_child_comm_id_fkey of relation community2community does not exist ALTER TABLE psql:database_schema_15-16.sql:111: ERROR: constraint collection2item_item_id_fkey of relation collection2item does not exist If so, inspect your database and use the references for the foreign keys to delete them, e.g:: psql [YourDBName] \d [TableName] will show you the foreign keys, e.g.: \d community2collection Table public.community2collection Column | Type | Modifiers ---+-+--- id| integer | not null community_id | integer | collection_id | integer | Indexes: community2collection_pkey PRIMARY KEY, btree (id) community2collection_collection_id_idx btree (collection_id) community2collection_community_id_idx btree (community_id) Foreign-key constraints: $1 FOREIGN KEY (community_id) REFERENCES community(community_id) $2 FOREIGN KEY (collection_id) REFERENCES collection(collection_id) In that case you got to run: ALTER TABLE collection2item DROP CONSTRAINT $2; ALTER TABLE community2community DROP CONSTRAINT $2; ALTER TABLE community2collection DROP CONSTRAINT $2; The reason for this is: In Step 7 Update the database it can happen that not all the commands in the database_schema_15-16.sql are executed properly. The commands to drop foreign keys: ALTER TABLE collection2item DROP CONSTRAINT collection2item_item_id_fkey; ALTER TABLE community2community DROP CONSTRAINT community2community_child_comm_id_fkey; ALTER TABLE community2collection DROP CONSTRAINT
Re: [Dspace-tech] Trouble deleting records online in DSpace 1.7.1
Hello Susan, while updating to 1.6 did you get some errors like that: psql:database_schema_15-16.sql:105: ERROR: constraint community2collection_collection_id_fkey of relation community2collection does not exist ALTER TABLE psql:database_schema_15-16.sql:108: ERROR: constraint community2community_child_comm_id_fkey of relation community2community does not exist ALTER TABLE psql:database_schema_15-16.sql:111: ERROR: constraint collection2item_item_id_fkey of relation collection2item does not exist If so, inspect your database and use the references for the foreign keys to delete them, e.g:: psql [YourDBName] \d [TableName] will show you the foreign keys, e.g.: \d community2collection Table public.community2collection Column | Type | Modifiers ---+-+--- id| integer | not null community_id | integer | collection_id | integer | Indexes: community2collection_pkey PRIMARY KEY, btree (id) community2collection_collection_id_idx btree (collection_id) community2collection_community_id_idx btree (community_id) Foreign-key constraints: $1 FOREIGN KEY (community_id) REFERENCES community(community_id) $2 FOREIGN KEY (collection_id) REFERENCES collection(collection_id) In that case you got to run: ALTER TABLE collection2item DROP CONSTRAINT $2; ALTER TABLE community2community DROP CONSTRAINT $2; ALTER TABLE community2collection DROP CONSTRAINT $2; The reason for this is: In Step 7 Update the database it can happen that not all the commands in the database_schema_15-16.sql are executed properly. The commands to drop foreign keys: ALTER TABLE collection2item DROP CONSTRAINT collection2item_item_id_fkey; ALTER TABLE community2community DROP CONSTRAINT community2community_child_comm_id_fkey; ALTER TABLE community2collection DROP CONSTRAINT community2collection_collection_id_fkey; assume that the keys got default names, whereas depending on the database version and operating system on which your instance started, they can have no names and just be counted internally. If you got no names or other names the script will skip the commands, with the above mentioned ERROR. This will lead to errors running DSpace as now 2 contraints exist and one is unable to delete items, collections etc. Hope that helps Claudia Jürgen Am 01.02.2012 20:46, schrieb Thornton, Susan M. (LARC-B702)[LITES]: Hello, After recently upgrading from DSpace 1.5.1 to 1.7.1, we are getting the following error whenever we try to delete an Item online: 2012-02-01 14:40:17,883 WARN org.dspace.app.webui.servlet.DSpaceServlet @ susan.m.thorn...@nasa.gov:session_id=B6C011F3369B678E2FB9ED4B0050:ip_addr=999.99.99.999:database_error:org.postgresql.util.PSQLException\colon; ERROR\colon; update or delete on table item violates foreign key constraint $2 on table collection2item Detail\colon; Key (item_id)=(429349) is still referenced from table collection2item. org.postgresql.util.PSQLException: ERROR: update or delete on table item violates foreign key constraint $2 on table collection2item Detail: Key (item_id)=(429349) is still referenced from table collection2item. I found some old dspace-tech postings regarding this error and am wondering if the recommended fix is correct? Not sure how this one happened: after upgrading to dspace 1.6, we're having trouble deleting items from dspace. We get an error message explaining that 'update or delete on item violates foreign key constraint $2 on collection2item'. Describing collection2item yields: Table public.collection2item Column | Type | Modifiers ---+-+--- id| integer | not null collection_id | integer | item_id | integer | Indexes: collection2item_pkey PRIMARY KEY, btree (id) collection2item_collection_idx btree (collection_id) collection2item_item_id_idx btree (item_id) Foreign-key constraints: $1 FOREIGN KEY (collection_id) REFERENCES collection(collection_id) $2 FOREIGN KEY (item_id) REFERENCES item(item_id) coll2item_item_fk FOREIGN KEY (item_id) REFERENCES item(item_id) DEFERRABLE I ran the database scheme update script, and it seems to have added the final, deferrable foreign key constraint; but I can't find any reference at all to the first two FKCs ($1 and $2). As far as I can tell, they aren't supposed to exist at all; I assume they're left over from some previous version of dspace, didn't get removed at some point in the past, and just never caused problems until now. Can anybody confirm that I can go ahead and drop these constraints (and similar constraints in Community2Collection? Bill Anderson Software Developer Digital Library Development Georgia Tech Library Thanks in advance! Sue Sue Walker-Thornton Software Developer/Database Administrator NASA Langley Research Center - LITES Contract susan.m.thorn...@nasa.gov (W)
[Dspace-tech] Trouble deleting records online in DSpace 1.7.1
Hello, After recently upgrading from DSpace 1.5.1 to 1.7.1, we are getting the following error whenever we try to delete an Item online: 2012-02-01 14:40:17,883 WARN org.dspace.app.webui.servlet.DSpaceServlet @ susan.m.thorn...@nasa.gov:session_id=B6C011F3369B678E2FB9ED4B0050:ip_addr=999.99.99.999:database_error:org.postgresql.util.PSQLException\colon; ERROR\colon; update or delete on table item violates foreign key constraint $2 on table collection2item Detail\colon; Key (item_id)=(429349) is still referenced from table collection2item. org.postgresql.util.PSQLException: ERROR: update or delete on table item violates foreign key constraint $2 on table collection2item Detail: Key (item_id)=(429349) is still referenced from table collection2item. I found some old dspace-tech postings regarding this error and am wondering if the recommended fix is correct? Not sure how this one happened: after upgrading to dspace 1.6, we're having trouble deleting items from dspace. We get an error message explaining that 'update or delete on item violates foreign key constraint $2 on collection2item'. Describing collection2item yields: Table public.collection2item Column | Type | Modifiers ---+-+--- id| integer | not null collection_id | integer | item_id | integer | Indexes: collection2item_pkey PRIMARY KEY, btree (id) collection2item_collection_idx btree (collection_id) collection2item_item_id_idx btree (item_id) Foreign-key constraints: $1 FOREIGN KEY (collection_id) REFERENCES collection(collection_id) $2 FOREIGN KEY (item_id) REFERENCES item(item_id) coll2item_item_fk FOREIGN KEY (item_id) REFERENCES item(item_id) DEFERRABLE I ran the database scheme update script, and it seems to have added the final, deferrable foreign key constraint; but I can't find any reference at all to the first two FKCs ($1 and $2). As far as I can tell, they aren't supposed to exist at all; I assume they're left over from some previous version of dspace, didn't get removed at some point in the past, and just never caused problems until now. Can anybody confirm that I can go ahead and drop these constraints (and similar constraints in Community2Collection? Bill Anderson Software Developer Digital Library Development Georgia Tech Library Thanks in advance! Sue Sue Walker-Thornton Software Developer/Database Administrator NASA Langley Research Center - LITES Contract susan.m.thorn...@nasa.gov (W) 757-864-2368 (M) 757-506-9903 -- Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech