Re: [dspace-tech] Duplicate key after restoring server from AIP backup

2022-07-15 Thread Sean Carte
Thanks, Tim.

I added a comment to
https://wiki.lyrasis.org/display/DSDOC7x/AIP+Backup+and+Restore

Sean

On Thu, 14 Jul 2022 at 19:41, Tim Donohue  wrote:

> Hi Sean,
>
> The "[dspace]/etc/" folder was removed in DSpace 7 because all the old SQL
> scripts (which used to sit in "etc" in older versions of DSpace) have been
> moved elsewhere.  This folder was already "mostly" empty in DSpace 5 & 6,
> and we completely emptied it out & removed it in DSpace 7.
>
>- SQL migration scripts (which used to be in that folder in 4.x or
>below) were all migrated to
>
> https://github.com/DSpace/DSpace/tree/main/dspace-api/src/main/resources/org/dspace/storage/rdbms/sqlmigration/postgres,
>as they are all now controlled by Flyway DB (as of DSpace 5.x)
>- The old "update-sequences.sql" SQL script (which used to be in that
>folder in 5.x or 6.x) has been replaced by the "./dspace database
>update-sequences" command
>
> So, if you see a "[dspace]/etc" folder, it can be safely removed after you
> upgrade to DSpace 7.  Any SQL scripts in that folder are outdated and
> unnecessary in DSpace 7.
>
> Tim
> --
> *From:* dspace-tech@googlegroups.com  on
> behalf of Sean Carte 
> *Sent:* Thursday, July 14, 2022 9:53 AM
> *To:* Michael Plate 
> *Cc:* DSpace Technical Support 
> *Subject:* Re: [dspace-tech] Duplicate key after restoring server from
> AIP backup
>
> Thanks for the advice, Michael.
>
> I do wonder, though, why the /dspace/etc/ directory is missing in 7.x? It
> doesn't seem to be there in:
> https://github.com/DSpace/DSpace/tree/main/dspace
>
> I took a copy from a 6.x installation, and ran it with psql. Apart from a
> couple of errors, it seemed to work and I can now deposit items.
>
> ERROR:  relation "workflowitem" does not exist
> LINE 1: ...setval('workflowitem_seq', max(workflow_id)) FROM workflowit...
>  ^
> ERROR:  relation "tasklistitem" does not exist
> LINE 1: ...setval('tasklistitem_seq', max(tasklist_id)) FROM tasklistit...
>
> Sean
>
> On Thu, 14 Jul 2022 at 12:48, Michael Plate <
> pl...@bibliothek.uni-kassel.de> wrote:
>
> Hi Sean,
>
> at least this you might correct this by setting the handle_seq to a
> value greater than the last handle.
> I don't recommend that for important systems :)
>
> Michael
>
>
> Am 14.07.22 um 08:02 schrieb Sean Carte:
> > I restored an entire site from an AIP backup, and now, when I attempt to
> > submit an item, I get this error:
> >
> > Caused by: java.sql.BatchUpdateException: Batch entry 0 update
> > public.handle set
> > resource_id='26a7cedb-76e7-4acc-a515-37708a3e1c7b'::uuid,
> > handle='123456789/9', resource_type_id=2 where handle_id=264 was
> > aborted: ERROR: duplicate key value violates unique constraint
> > "handle_handle_key"
> >Detail: Key (handle)=(123456789/9) already exists.  Call
> > getNextException to see other errors in the batch.
> >
> > I think this is because I haven't run the update-sequences.sql that the
> > documentation suggests I should, but I can't find that script; there
> > isn't even a /dspace/etc/ directory:
> >
> > ls /dspace/
> > assetstore  exportslog   solr upload
> > bin handle-server  reports   temp var
> > config  libsitemaps  triplestore  webapps
> >
> > This is the documentation I've been using:
> >
> >
> https://wiki.lyrasis.org/display/DSDOC7x/AIP+Backup+and+Restore#AIPBackupandRestore-RestoringEntireSite
> > <
> https://wiki.lyrasis.org/display/DSDOC7x/AIP+Backup+and+Restore#AIPBackupandRestore-RestoringEntireSite
> >
> >
> > DSpace version:  7.3-SNAPSHOT
> >SCM revision:  e5f316c9adf78e59d8277a271a0fc2a2d21da0f8
> >  SCM branch:  main
> >  OS:  Linux(amd64) version 5.4.0-120-generic
> >Applications:
> >   Discovery:  enabled.
> > JRE:  Private Build version 11.0.15
> > Ant version:  Apache Ant(TM) version 1.10.7 compiled on October 24
> 2019
> >   Maven version:  3.6.3
> > DSpace home:  /dspace
> >
> > Sean
> >
> > --
> > All messages to this mailing list should adhere to the Code of Conduct:
> > https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx
> > <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&quo

Re: [dspace-tech] Duplicate key after restoring server from AIP backup

2022-07-14 Thread 'Tim Donohue' via DSpace Technical Support
Hi Sean,

The "[dspace]/etc/" folder was removed in DSpace 7 because all the old SQL 
scripts (which used to sit in "etc" in older versions of DSpace) have been 
moved elsewhere.  This folder was already "mostly" empty in DSpace 5 & 6, and 
we completely emptied it out & removed it in DSpace 7.

  *   SQL migration scripts (which used to be in that folder in 4.x or below) 
were all migrated to 
https://github.com/DSpace/DSpace/tree/main/dspace-api/src/main/resources/org/dspace/storage/rdbms/sqlmigration/postgres,
 as they are all now controlled by Flyway DB (as of DSpace 5.x)
  *   The old "update-sequences.sql" SQL script (which used to be in that 
folder in 5.x or 6.x) has been replaced by the "./dspace database 
update-sequences" command

So, if you see a "[dspace]/etc" folder, it can be safely removed after you 
upgrade to DSpace 7.  Any SQL scripts in that folder are outdated and 
unnecessary in DSpace 7.

Tim

From: dspace-tech@googlegroups.com  on behalf of 
Sean Carte 
Sent: Thursday, July 14, 2022 9:53 AM
To: Michael Plate 
Cc: DSpace Technical Support 
Subject: Re: [dspace-tech] Duplicate key after restoring server from AIP backup

Thanks for the advice, Michael.

I do wonder, though, why the /dspace/etc/ directory is missing in 7.x? It 
doesn't seem to be there in: https://github.com/DSpace/DSpace/tree/main/dspace

I took a copy from a 6.x installation, and ran it with psql. Apart from a 
couple of errors, it seemed to work and I can now deposit items.

ERROR:  relation "workflowitem" does not exist
LINE 1: ...setval('workflowitem_seq', max(workflow_id)) FROM workflowit...
 ^
ERROR:  relation "tasklistitem" does not exist
LINE 1: ...setval('tasklistitem_seq', max(tasklist_id)) FROM tasklistit...

Sean

On Thu, 14 Jul 2022 at 12:48, Michael Plate 
mailto:pl...@bibliothek.uni-kassel.de>> wrote:
Hi Sean,

at least this you might correct this by setting the handle_seq to a
value greater than the last handle.
I don't recommend that for important systems :)

Michael


Am 14.07.22 um 08:02 schrieb Sean Carte:
> I restored an entire site from an AIP backup, and now, when I attempt to
> submit an item, I get this error:
>
> Caused by: java.sql.BatchUpdateException: Batch entry 0 update
> public.handle set
> resource_id='26a7cedb-76e7-4acc-a515-37708a3e1c7b'::uuid,
> handle='123456789/9', resource_type_id=2 where handle_id=264 was
> aborted: ERROR: duplicate key value violates unique constraint
> "handle_handle_key"
>Detail: Key (handle)=(123456789/9) already exists.  Call
> getNextException to see other errors in the batch.
>
> I think this is because I haven't run the update-sequences.sql that the
> documentation suggests I should, but I can't find that script; there
> isn't even a /dspace/etc/ directory:
>
> ls /dspace/
> assetstore  exportslog   solr upload
> bin handle-server  reports   temp var
> config  libsitemaps  triplestore  webapps
>
> This is the documentation I've been using:
>
> https://wiki.lyrasis.org/display/DSDOC7x/AIP+Backup+and+Restore#AIPBackupandRestore-RestoringEntireSite
> <https://wiki.lyrasis.org/display/DSDOC7x/AIP+Backup+and+Restore#AIPBackupandRestore-RestoringEntireSite>
>
> DSpace version:  7.3-SNAPSHOT
>SCM revision:  e5f316c9adf78e59d8277a271a0fc2a2d21da0f8
>  SCM branch:  main
>  OS:  Linux(amd64) version 5.4.0-120-generic
>Applications:
>   Discovery:  enabled.
> JRE:  Private Build version 11.0.15
> Ant version:  Apache Ant(TM) version 1.10.7 compiled on October 24 2019
>   Maven version:  3.6.3
> DSpace home:  /dspace
>
> Sean
>
> --
> All messages to this mailing list should adhere to the Code of Conduct:
> https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx
> <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 
> dspace-tech+unsubscr...@googlegroups.com<mailto:dspace-tech%2bunsubscr...@googlegroups.com>
> <mailto:dspace-tech+unsubscr...@googlegroups.com<mailto:dspace-tech%2bunsubscr...@googlegroups.com>>.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/dspace-tech/CA%2BxAuhMkoCiM%2BRJafRddPpH15wU%2BfB%3DJBwnAYA6m_OmogX9OhA%40mail.gmail.com
> <https://groups.google.com/d/msgid/dspace-tech/CA%2BxAuhMkoCiM%2BRJafRddPpH15wU%2BfB%3DJBwnAYA6m_OmogX9OhA%40mail.gmail.com?utm_medium=email_source=footer>.

--
All messages to this mail

Re: [dspace-tech] Duplicate key after restoring server from AIP backup

2022-07-14 Thread Sean Carte
Thanks for the advice, Michael.

I do wonder, though, why the /dspace/etc/ directory is missing in 7.x? It
doesn't seem to be there in:
https://github.com/DSpace/DSpace/tree/main/dspace

I took a copy from a 6.x installation, and ran it with psql. Apart from a
couple of errors, it seemed to work and I can now deposit items.

ERROR:  relation "workflowitem" does not exist
LINE 1: ...setval('workflowitem_seq', max(workflow_id)) FROM workflowit...
 ^
ERROR:  relation "tasklistitem" does not exist
LINE 1: ...setval('tasklistitem_seq', max(tasklist_id)) FROM tasklistit...

Sean

On Thu, 14 Jul 2022 at 12:48, Michael Plate 
wrote:

> Hi Sean,
>
> at least this you might correct this by setting the handle_seq to a
> value greater than the last handle.
> I don't recommend that for important systems :)
>
> Michael
>
>
> Am 14.07.22 um 08:02 schrieb Sean Carte:
> > I restored an entire site from an AIP backup, and now, when I attempt to
> > submit an item, I get this error:
> >
> > Caused by: java.sql.BatchUpdateException: Batch entry 0 update
> > public.handle set
> > resource_id='26a7cedb-76e7-4acc-a515-37708a3e1c7b'::uuid,
> > handle='123456789/9', resource_type_id=2 where handle_id=264 was
> > aborted: ERROR: duplicate key value violates unique constraint
> > "handle_handle_key"
> >Detail: Key (handle)=(123456789/9) already exists.  Call
> > getNextException to see other errors in the batch.
> >
> > I think this is because I haven't run the update-sequences.sql that the
> > documentation suggests I should, but I can't find that script; there
> > isn't even a /dspace/etc/ directory:
> >
> > ls /dspace/
> > assetstore  exportslog   solr upload
> > bin handle-server  reports   temp var
> > config  libsitemaps  triplestore  webapps
> >
> > This is the documentation I've been using:
> >
> >
> https://wiki.lyrasis.org/display/DSDOC7x/AIP+Backup+and+Restore#AIPBackupandRestore-RestoringEntireSite
> > <
> https://wiki.lyrasis.org/display/DSDOC7x/AIP+Backup+and+Restore#AIPBackupandRestore-RestoringEntireSite
> >
> >
> > DSpace version:  7.3-SNAPSHOT
> >SCM revision:  e5f316c9adf78e59d8277a271a0fc2a2d21da0f8
> >  SCM branch:  main
> >  OS:  Linux(amd64) version 5.4.0-120-generic
> >Applications:
> >   Discovery:  enabled.
> > JRE:  Private Build version 11.0.15
> > Ant version:  Apache Ant(TM) version 1.10.7 compiled on October 24
> 2019
> >   Maven version:  3.6.3
> > DSpace home:  /dspace
> >
> > Sean
> >
> > --
> > 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 dspace-tech+unsubscr...@googlegroups.com
> > .
> > To view this discussion on the web visit
> >
> https://groups.google.com/d/msgid/dspace-tech/CA%2BxAuhMkoCiM%2BRJafRddPpH15wU%2BfB%3DJBwnAYA6m_OmogX9OhA%40mail.gmail.com
> > <
> https://groups.google.com/d/msgid/dspace-tech/CA%2BxAuhMkoCiM%2BRJafRddPpH15wU%2BfB%3DJBwnAYA6m_OmogX9OhA%40mail.gmail.com?utm_medium=email_source=footer
> >.
>
> --
> 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 dspace-tech+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/dspace-tech/cd567e6a-5b3d-23fd-a83c-a5bd32073dd7%40bibliothek.uni-kassel.de
> .
>

-- 
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 dspace-tech+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/dspace-tech/CA%2BxAuhOnZJ5kcBYy4DS%2BM%3DyW1wqyaayBaCK5Q1kiajiGweq8Tg%40mail.gmail.com.


Re: [dspace-tech] Duplicate key after restoring server from AIP backup

2022-07-14 Thread Michael Plate

Hi Sean,

at least this you might correct this by setting the handle_seq to a 
value greater than the last handle.

I don't recommend that for important systems :)

Michael


Am 14.07.22 um 08:02 schrieb Sean Carte:
I restored an entire site from an AIP backup, and now, when I attempt to 
submit an item, I get this error:


Caused by: java.sql.BatchUpdateException: Batch entry 0 update 
public.handle set 
resource_id='26a7cedb-76e7-4acc-a515-37708a3e1c7b'::uuid, 
handle='123456789/9', resource_type_id=2 where handle_id=264 was 
aborted: ERROR: duplicate key value violates unique constraint 
"handle_handle_key"
   Detail: Key (handle)=(123456789/9) already exists.  Call 
getNextException to see other errors in the batch.


I think this is because I haven't run the update-sequences.sql that the 
documentation suggests I should, but I can't find that script; there 
isn't even a /dspace/etc/ directory:


ls /dspace/
assetstore  exports        log       solr         upload
bin         handle-server  reports   temp         var
config      lib            sitemaps  triplestore  webapps

This is the documentation I've been using:

https://wiki.lyrasis.org/display/DSDOC7x/AIP+Backup+and+Restore#AIPBackupandRestore-RestoringEntireSite 



DSpace version:  7.3-SNAPSHOT
   SCM revision:  e5f316c9adf78e59d8277a271a0fc2a2d21da0f8
     SCM branch:  main
             OS:  Linux(amd64) version 5.4.0-120-generic
   Applications:
      Discovery:  enabled.
            JRE:  Private Build version 11.0.15
    Ant version:  Apache Ant(TM) version 1.10.7 compiled on October 24 2019
  Maven version:  3.6.3
    DSpace home:  /dspace

Sean

--
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 dspace-tech+unsubscr...@googlegroups.com 
.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/dspace-tech/CA%2BxAuhMkoCiM%2BRJafRddPpH15wU%2BfB%3DJBwnAYA6m_OmogX9OhA%40mail.gmail.com 
.


--
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 dspace-tech+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/dspace-tech/cd567e6a-5b3d-23fd-a83c-a5bd32073dd7%40bibliothek.uni-kassel.de.


smime.p7s
Description: S/MIME Cryptographic Signature


[dspace-tech] Duplicate key after restoring server from AIP backup

2022-07-14 Thread Sean Carte
I restored an entire site from an AIP backup, and now, when I attempt to
submit an item, I get this error:

Caused by: java.sql.BatchUpdateException: Batch entry 0 update
public.handle set resource_id='26a7cedb-76e7-4acc-a515-37708a3e1c7b'::uuid,
handle='123456789/9', resource_type_id=2 where handle_id=264 was aborted:
ERROR: duplicate key value violates unique constraint "handle_handle_key"
  Detail: Key (handle)=(123456789/9) already exists.  Call getNextException
to see other errors in the batch.

I think this is because I haven't run the update-sequences.sql that the
documentation suggests I should, but I can't find that script; there isn't
even a /dspace/etc/ directory:

ls /dspace/
assetstore  exportslog   solr upload
bin handle-server  reports   temp var
config  libsitemaps  triplestore  webapps

This is the documentation I've been using:

https://wiki.lyrasis.org/display/DSDOC7x/AIP+Backup+and+Restore#AIPBackupandRestore-RestoringEntireSite

DSpace version:  7.3-SNAPSHOT
  SCM revision:  e5f316c9adf78e59d8277a271a0fc2a2d21da0f8
SCM branch:  main
OS:  Linux(amd64) version 5.4.0-120-generic
  Applications:
 Discovery:  enabled.
   JRE:  Private Build version 11.0.15
   Ant version:  Apache Ant(TM) version 1.10.7 compiled on October 24 2019
 Maven version:  3.6.3
   DSpace home:  /dspace

Sean

-- 
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 dspace-tech+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/dspace-tech/CA%2BxAuhMkoCiM%2BRJafRddPpH15wU%2BfB%3DJBwnAYA6m_OmogX9OhA%40mail.gmail.com.