Hi Chris, By migrate to a new server, I'm wondering what your migration process was. Perhaps there was some existing data on the database you restored on top of???
You should have success with a pg_dump on the old server, and then a pg_restore on the new server, in a fresh/clean database. The state of things would be almost unchanged according to the DB. I like the custom / binary format -Fc. You can use pgadmin3, if the ports are open, to make it easier. That way you ensure you don't miss any sequences, or indexes. I don't know if it would be possible, or wise, to somehow drop indexes, and re-add them Another possible thing to look into is: https://wiki.postgresql.org/wiki/Fixing_Sequences (Caveat, at own risk, backup before trying, ..., untested) ________________ Peter Dietz Longsight www.longsight.com [email protected] p: 740-599-5005 x809 On Wed, Nov 4, 2015 at 11:05 PM, Andrea Schweer <[email protected]> wrote: > On 05/11/15 16:25, Chris Gray wrote: > > Yes. I updated the sequences when I finished the ingest and then again > when this error first appeared, but it hasn't helped. > > > Fair enough. Is there anything useful in the DSpace log? Or a longer stack > trace shown to you on the page? > > cheers, > Andrea > > > On Wednesday, November 4, 2015 at 9:11:50 PM UTC-5, Andrea Schweer wrote: >> >> Hi, >> >> On 05/11/15 14:53, Chris Gray wrote: >> >> We've migrated our content to a new server. Now we can't create new >> communities. >> >> The error is: >> >> ERROR: duplicate key value violates unique constraint "handle_pkey" >> Detail: Key (handle_id)=(9863) already exists. >> >> >> The number goes up by one with each attempt. >> >> >> Have you tried the updating the db sequences? >> >> >> https://wiki.duraspace.org/display/DSDOC5x/Storage+Layer#StorageLayer-MaintenanceandBackup >> (see the final bit in the "Maintenance and Backup" section) >> >> cheers, >> Andrea >> >> -- >> Dr Andrea Schweer >> IRR Technical Specialist, ITS Information Systems >> The University of Waikato, Hamilton, New Zealand+64-7-837 9120 >> >> -- > 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. > > > -- > Dr Andrea Schweer > IRR Technical Specialist, ITS Information Systems > The University of Waikato, Hamilton, New Zealand+64-7-837 9120 > > -- > 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. > -- 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.
