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

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

    XMLWordPrintable

Details

    • Bug
    • Resolution: Won't Fix
    • Major
    • 1.7 alpha 2
    • 1.7 alpha 2, 1.8.0
    • tools
    • Security Level: Public
    • 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

            steve Steve Yen
            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

                PagerDuty