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

          depends on

          New Feature - A new feature of the product, which has yet to be developed. NXDRIVE-1205 Migrate database stuff to an ORM

          • Major - Major loss of function.
          • Resolved
          is related to

          Epic - Created by Jira Software - do not edit or delete. Issue type for a big user story that needs to be broken down. NXDRIVE-1504 Sentry

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: