UFAL/PY-Cannot create a new license after migration

dataquest-dev / dspace-import

Blackbox tests for dspace repository

Other

0 stars 2 forks source link

UFAL/PY-Cannot create a new license after migration #114

Closed milanmajchrak closed 1 year ago

milanmajchrak commented 1 year ago

Problem description

Error message:

Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into public.license_label_extended_mapping (license_id, label_id) values (92, 20) was aborted: ERROR: duplicate key value violates unique constraint "license_label_extended_mapping_pkey"
  Detail: Key (mapping_id)=(991256) already exists.

Maybe sequences wasn't properly copied.

milanmajchrak commented 1 year ago

All sequences are copied also from the clarin-utilities database and because of different count of records between CLARIN-DSpace5 and CLARIN-DSpace7 the sequences from CLARIN-DSpace5 are causing database duplicate key errors.

TODO: Remove copying clarin-utilities table sequences.