Uploaded image for project: 'Nuxeo Drive '
  1. Nuxeo Drive
  2. NXDRIVE-2020

Database downgrade are not handled

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Critical
    • Resolution: Won't Fix
    • Affects Version/s: NoFixVersionApplicable
    • Fix Version/s: Not yet scheduled version
    • Component/s: Framework

      Description

      Issue

      Sentry Issue: NUXEO-DRIVE-2TD

      OperationalError: table Uploads has no column named idx
        File "nxdrive/engine/processor.py", line 276, in _execute
        File "nxdrive/engine/processor.py", line 604, in _synchronize_locally_modified
        File "nxdrive/client/remote_client.py", line 858, in stream_update
        File "nxdrive/client/remote_client.py", line 418, in upload
        File "nxdrive/client/remote_client.py", line 502, in upload_chunks
        File "nxdrive/engine/dao/sqlite.py", line 2093, in save_upload
        File "nxdrive/engine/dao/sqlite.py", line 156, in execute
        File "nxdrive/engine/dao/sqlite.py", line 150, in execute
      

      Analysis

      The missing field is due to a downgrade of the Drive version (4.4.2 -> 4.4.1).
      In the 4.4.2 version, the Uploads table was altered.
      Downgrading to 4.4.1 did not handle the table "restoration".

      Fix

      There is no easy fix right now. Our best bet is to invest in a schema migration tool.

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: