Uploaded image for project: 'XNAT'
  1. XNAT
  2. XNAT-6717

Duplicate rows can end up stuck in prearchive table

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 1.8.2
    • 1.7, 1.8
    • Prearchive
    • None
    • 1.8.2 Sprint 1
    • Rank:
      0|ii1xhi:zi
    • 1.8.2 Sprint 1

    Description

      Likely due to some race condition, you can end up with multiple rows in the xdat_search.prearchive table for a single directory on the filesystem. When this happens, you cannot do anything with the data in the prearchive - everything complains about the duplicate rows.

      Dropping the table and restarting tomcat will fix the issue by forcing a manual rebuild of the prearchive, but this is both time-consuming and requires downtime.

      I notice there is no primary key nor uniqueness condition on the xdat_search.prearchive table, perhaps that'd fix the issue?

      Attachments

        Activity

          People

            moore.c@wustl.edu Charlie Moore (Inactive)
            katealpert@flywheel.io Kate Alpert
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: