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

Duplicate rows can end up stuck in prearchive table

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.7, 1.8
    • Fix Version/s: 1.8.2
    • Component/s: Prearchive
    • Labels:
      None
    • Sprint:
      1.8.2 Sprint 1
    • Rank:
      0|ii1xhi:zi
    • Sprint:
      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

            Assignee:
            moore.c@wustl.edu Charlie Moore
            Reporter:
            kate@radiologics.com Kate Alpert
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: