Hi Jason, helix84 is correct. It's actually recommended in the AIP Backup & Restore Documentation to always run "update-sequences.sql" after a large restoration (and your situation obviously qualifies). Unfortunately, the restoration process (especially from an empty database) is not always able to ensure that various db sequences are properly set post-restoration.
So, there's actually a note (highlighted in yellow) in the docs recommending running "update-sequences.sql" after a full-site restoration. As helix84 mentions, it won't hurt anything: https://wiki.duraspace.org/display/DSDOC4x/AIP+Backup+and+Restore#AIPBackupandRestore-RestoringEntireSite - Tim On 1/14/2014 10:15 AM, helix84 wrote: > Hi Jason, > > I'm not sure I understood your expectations completely, but some of them > seem to be wrong. DSpace is never supposed to assign a handle suffix > from a gap. It always assigns highest suffix + 1. > > The problem might be that the counter is off. In that case shut down > Tomcat and run update-sequences.sql. That will reset the sequences so > the will return the correct values next time. Running it definitely > won't hurt. > > On Jan 14, 2014 5:08 PM, "Jason Sherman" <[email protected] > <mailto:[email protected]>> wrote: > > I recently moved to DSpace 4.0 from 3.x. I set up an empty Dspace > 4.0 system, did an AIP backup of the whole 3.x site and then > restored the site into the new system. > > It's been fine for the most part, but when adding an item recently, > I got a error at the end of the submission process, saying there was > a problem assigning handle x/1623, which isn't surprising since that > handle is in use. Upon closer inspection, I see that the ID of my > new item is 1623. It did end up getting assigned an available > handle x/1631 (which is our highest assigned handle so far), but > obviously there was a bump in the road on the way there. > > We did have a handful of deleted items on our old system, and my > guess is that since those weren't brought over, that caused the item > id count to be slightly smaller than the handle count. > > I have added an item before that without any errors, and it did fill > in an unused handle in the middle without a problem. Is there > anything I should look to do in the code or in the database to > prevent this error from popping up again? > > -- > Jason Sherman > Systems Librarian > University of Science and Arts of Oklahoma > 405.574.1340 <tel:405.574.1340> > > > ------------------------------------------------------------------------------ > CenturyLink Cloud: The Leader in Enterprise Cloud Services. > Learn Why More Businesses Are Choosing CenturyLink Cloud For > Critical Workloads, Development Environments & Everything In Between. > Get a Quote or Start a Free Trial Today. > > http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk > _______________________________________________ > DSpace-tech mailing list > [email protected] > <mailto:[email protected]> > https://lists.sourceforge.net/lists/listinfo/dspace-tech > List Etiquette: > https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette > > > > ------------------------------------------------------------------------------ > CenturyLink Cloud: The Leader in Enterprise Cloud Services. > Learn Why More Businesses Are Choosing CenturyLink Cloud For > Critical Workloads, Development Environments & Everything In Between. > Get a Quote or Start a Free Trial Today. > http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk > > > > _______________________________________________ > DSpace-tech mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/dspace-tech > List Etiquette: > https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette > ------------------------------------------------------------------------------ CenturyLink Cloud: The Leader in Enterprise Cloud Services. Learn Why More Businesses Are Choosing CenturyLink Cloud For Critical Workloads, Development Environments & Everything In Between. Get a Quote or Start a Free Trial Today. http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
