Hi Chris,

Glad that worked out for you.

Personally, I wouldn't use the AIP route. Something will be lost in
translation.

________________
Peter Dietz
Longsight
www.longsight.com
[email protected]
p: 740-599-5005 x809

On Thu, Nov 5, 2015 at 10:45 AM, Chris Gray <[email protected]> wrote:

> Thanks, Peter,
>
> I recreated the database with pg_dump and pg_restore and that seems to
> have solved the problem.
>
> On to the next gotcha!
>
> On Thursday, November 5, 2015 at 12:12:32 AM UTC-5, Peter Dietz wrote:
>>
>> 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.
>

-- 
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.

Reply via email to