Uploaded image for project: 'CritiqueBrainz'
  1. CritiqueBrainz
  2. CB-381

Dump importer doesn't reset sequence values after importing items

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • v-2020-10-09.0
    • None
    • None
    • None

      During a data import we load into a table from a file, however we don't reset the sequence numbers for the id column of the table.

      This means that some time later if someone writes a review on a server that has had a data dump imported, it will fail because it will try to reuse an existing sequence value for the ID.

      After importing tables, we should reset the sequence: https://stackoverflow.com/a/3698777

            kartik1712 amCap1712
            alastairp Alastair Porter
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:

                Version Package
                v-2020-10-09.0