Hello We are migrating from DSpace 5 to 7.6. Everything goes smooth but we have copied production database to test environment and when we change handle prefix it takes toooo loooong and finally does not update. After 17 hours we see the below dialog...
# time ./dspace update-handle-prefix 10230 123456789 Getting information about handles from database... In your repository will be updated 47316 handles to new prefix 123456789 from original 10230! Servlet container (e.g. Apache Tomcat, Jetty, Caucho Resin) must be running. If it is necessary, please make a backup of the database. Are you ready to continue? [y/n]: y No changes have been made to your data. real 1032m21,431s The offending query is select count(distinct handle0_.handle_id) as col_0_0_ from public.handle handle0_ cross join public.handle handle1_ where handle0_.handle like $1 DETALLE: parámetros: $1 = '10230%' Any ideas or workaround? Thanks in advance Evelio -- All messages to this mailing list should adhere to the Code of Conduct: https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx --- 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 view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/0789642b-8666-423d-aee3-4c882d96f02dn%40googlegroups.com.
