Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-3360

mbrestore tool does not support restoring from WAL'ed database files

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Won't Fix
    • Affects Version/s: 1.7 alpha 2, 1.8.0
    • Fix Version/s: 1.7 alpha 2
    • Component/s: tools
    • Security Level: Public
    • Labels:
      None

      Description

      This error is presented:
      tcarpenter@sports-mb-test02:/opt/membase/1.6.4.1/data/ns_1]$ /tmp/python271/Python-2.7.1/python /opt/membase/1.6.4.1/bin/ep_engine/management/mbrestore -a default default-0.mb default-1.mb default-2.mb default-3.mb
      Traceback (most recent call last):
      File "/opt/membase/1.6.4.1/bin/ep_engine/management/mbrestore", line 147, in <module>
      main()
      File "/opt/membase/1.6.4.1/bin/ep_engine/management/mbrestore", line 105, in main
      db.executemany("attach ? as ?", zip(db_filenames, attached_dbs))
      sqlite3.OperationalError: file is encrypted or is not a database

      According to Dustin, this is because the mbrestore tool does not currently support WAL db files and the workaround is to run: /opt/membase/bin/ep_engine/management/sqlite3 <filename> 'pragma journal_mode=delete' on all the db files you are trying to restore.

      Please add the above workaround to the mbrestore script itself.

        Attachments

        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

          Activity

            People

            • Assignee:
              steve Steve Yen
              Reporter:
              perry Perry Krug
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Gerrit Reviews

                There are no open Gerrit changes