Hi Jeff, there should be no problem running it, just make sure to only run it while your serlvet container is down.
In most cases, it will probably do nothing. Let me illustrate it with a case where you add 10 collections, then delete them, then add a new one. time action max(collection_id) currval(collection_seq) nextval(collection_seq) 1 1000 1000 1001 2 created 10 collections 1010 1010 1011 3 deleted 10 collections 1000 1010 1011 4 created 1 collection 1011 1011 1012 As you can see, update-sequences will not remove existing "holes" unless they are at the end of the sequence (i.e. running update-sequences between steps 3 and 4). All in all, there's no benefit to paying such attention to IDs (unless they are handle postfixes, see below) and since DSpace 6, the sequential IDs are replaced with UUIDs anyway. Please note that in case of handle_seq, it will do nothing because when an object is deleted, the handle table keeps the row, just sets the resource_id to null. So you'd have to delete the lates null rows from the handle table before running update-sequences. Regards, ~~helix84 Compulsory reading: DSpace Mailing List Etiquette https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette On Mon, Jun 6, 2016 at 2:14 PM, Jeffrey A Trimble <[email protected]> wrote: > We haven’t upgraded in some time, and before I begin this task, I’d like > the corporate wisdom of running the update-sequences.sql as just part of > the maintenance of the database. > > We’ve had too many purges/deletions and so many batch adds that I don’t > even have an estimate in my mind. > > Is there any issue running it just to run it and see if finds anything > wrong? > > Thanks, > > Jeff > Jeffrey Trimble, MLS > William F. Maag Library > Youngstown State University > 330.941.2483 (Office) > [email protected] > http://www.maag.ysu.edu > http://digital.maag.ysu.edu > > -- > 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 https://groups.google.com/group/dspace-tech. > For more options, visit https://groups.google.com/d/optout. > -- 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 https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
