On Thu, Nov 12, 2015 at 5:06 AM, euler <[email protected]> wrote: > Another question I would like to ask is that why this happened in the first > place and how to avoid this problem? I thought the assignment of handles > incrementally upon submission would avoid this.
Yes, they are assigned sequentially, so unless you did a manual change, it shouldn't happen. (with the possible exception of item versioning, I'm not 100% sure how it works) > Is it safe to delete the (duplicate) row in the handle table? Yes. > And how can I locate duplicate entries (one item ID, multiple handle_id)? SELECT resource_type_id, resource_id, count(*)FROM handleWHERE resource_id IS NOT NULLGROUP BY resource_type_id, resource_idHAVING count(*) > 1; Regards, ~~helix84 Compulsory reading: DSpace Mailing List Etiquette https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette -- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
