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

[GNU/Linux] "database disk image is malformed" errors prevent the app to work correctly

    XMLWordPrintable

    Details

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

      Description

      Current Issues

      A sync root is already present locally, then add a new file. It will fail:

      2021-03-12 11:02:24 5081 140259052476160 INFO     nxdrive.direct_edit Direct Editing doc_id='6ec138f8-78df-426d-9a43-149c12eb9462' on server_url='https://nxdev-dev01.beta.nuxeocloud.com/nuxeo' for user='mschoentgen' with download_url='nxfile/default/6ec138f8-78df-426d-9a43-149c12eb9462/file:content/cni-mickael-verso.jpg?changeToken=3-0'
      2021-03-12 11:02:24 5081 140259052476160 DEBUG    nuxeo.client       Calling POST 'https://nxdev-dev01.beta.nuxeocloud.com/nuxeo/site/automation/Document.Fetch' with headers={...}', kwargs={'timeout': (10, 600), 'verify': True, 'cert': None, 'proxies': {}} and cookies=...>
      2021-03-12 11:02:30 5081 140259664848640 DEBUG    nxdrive.engine.watcher.remote_watcher Handle remote changes, first_pass=False
      2021-03-12 11:02:30 5081 140259664848640 ERROR    nxdrive.engine.watcher.remote_watcher Unexpected error
      Traceback (most recent call last):
        File "nxdrive/engine/watcher/remote_watcher.py", line 634, in _handle_changes
        File "nxdrive/engine/dao/sqlite.py", line 413, in get_config
        File "nxdrive/engine/dao/sqlite.py", line 154, in execute
      sqlite3.DatabaseError: database disk image is malformed
      

      Start direct Edit on a document. Sometimes you will have such error:

      2021-03-12 11:24:53 8458 140199719847680 ERROR    nxdrive.engine.workers Thread EXCEPTION
      Traceback (most recent call last):
        File "nxdrive/engine/workers.py", line 197, in run
        File "nxdrive/engine/processor.py", line 311, in _execute
        File "nxdrive/engine/processor.py", line 287, in _get_next_doc_pair
        File "nxdrive/engine/dao/sqlite.py", line 1080, in acquire_state
        File "nxdrive/engine/dao/sqlite.py", line 1106, in acquire_processor
        File "nxdrive/engine/dao/sqlite.py", line 154, in execute
      sqlite3.DatabaseError: database disk image is malformed
      

      Expected Behavior

      Those are critical components that are not working. I smell that the issue was introduced when switching the SQLite journal mode to WAL. But we will not revert that, so we need to fix the issue at the root.

        Attachments

          Activity

            People

            • Assignee:
              mschoentgen Mickaël Schoentgen
              Reporter:
              mschoentgen Mickaël Schoentgen
              Participants:
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 15 minutes
                15m