Re: [Dspace-tech] HANDLE table entries without resource_id
If a handle gets deleted sets the resource_id to null and keep all the other information (basically resource_type and the handle itself). If something with an handle is getting restored from an AIP backup, DSpace checks whether the resource_type_id of the handle in the database is the same as of the DSpaceObject being restored from AIP. Handles are Persistent Identifier. Nobody wants a persistent identifier to change, because then it wouldn't be persistent anymore. ;-) That is the reason DSpace ensures that at least the resource_type of a deleted and restored handle doesn't change. I won't delete them as they don't disturbe you and as it is wanted behavior. Regards, Pascal From: Monika C. Mevenkamp [mailto:moni...@princeton.edu] Sent: Monday, February 02, 2015 3:25 PM To: dspace-tech@lists.sourceforge.net Tech Subject: [Dspace-tech] HANDLE table entries without resource_id the query SELECT HANDLE_ID, RESOURCE_TYPE_ID, RESOURCE_ID, HANDLE FROM HANDLE WHERE RESOURCE_ID IS NULL; finds a couple entries Is there a reason why I should not delete them ? Monika Monika Mevenkamp phone: 609-258-4161 693 Alexander Road, Princeton University, Princeton, NJ 08544 -- Dive into the World of Parallel Programming. The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net/___ 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] HANDLE table entries without resource_id
Also keep in mind that if you ever need to use update-sequences.sql and the most recently assigned item(s) are deleted, by removing those NULL entries you would cause the sequence to reassign the same identifiers the deleted items had to any new item(s) you submit next, thus again defeating the purpose of a persistent ID. Regards, ~~helix84 Compulsory reading: DSpace Mailing List Etiquette https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette -- Dive into the World of Parallel Programming. The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net/ ___ 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] HANDLE table entries without resource_id
the query SELECT HANDLE_ID, RESOURCE_TYPE_ID, RESOURCE_ID, HANDLE FROM HANDLE WHERE RESOURCE_ID IS NULL; finds a couple entries Is there a reason why I should not delete them ? Monika Monika Mevenkamp phone: 609-258-4161 693 Alexander Road, Princeton University, Princeton, NJ 08544 -- Dive into the World of Parallel Programming. The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net/___ 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
