Uploaded image for project: 'DSpace'
  1. DSpace
  2. DS-2844

DSpace 6 performance after migrating a large database (250,000 items)

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 6.0
    • Fix Version/s: 6.0
    • Component/s: DSpace API
    • Labels:
      None
    • Attachments:
      0
    • Comments:
      8
    • Documentation Status:
      Not Required

      Description

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

      select
      group0_.uuid as uuid1_12_,
      group0_.eperson_group_id as eperson_1_14_
      from
      public.epersongroup group0_
      inner join public.dspaceobject group0_1_
      on group0_.uuid=group0_1_.uuid
      left outer join public.metadatavalue metadata1_
      on group0_.uuid=metadata1_.dspace_object_id
      and (metadata1_.metadata_field_id=$1)
      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

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              terrywbrady Terrence W Brady
              Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: