We have attempted to migrate our production database from DSpace 4 to DSpace 6. The migration is now successful.
After migration, we are having difficulty navigating the repository.
On startup, the repository seemed to be stuck on the following query (per the pg_activity_stat table).
group0_.uuid as uuid1_12_,
group0_.eperson_group_id as eperson_1_14_
inner join public.dspaceobject group0_1_
left outer join public.metadatavalue metadata1_
where lower(cast(metadata1_.text_value as varchar))=lower($2)
We seemed to resolve this issue by creating an index.
create index uuid on metadatavalue(dspace_object_id). I see that column is listed as a foreign key. Should an index also be present?
After resolving that issue, we encountered null pointer exceptions on the following line