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.

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

        Activity

        perry Perry Krug created issue -
        sean Sean Lynch (Inactive) made changes -
        Field Original Value New Value
        Assignee Dustin Sallings [ dustin ]
        sharon Sharon Barr (Inactive) made changes -
        Assignee Dustin Sallings [ dustin ] Bin Cui [ bcui ]
        Fix Version/s 1.7 beta [ 10110 ]
        sharon Sharon Barr (Inactive) made changes -
        Fix Version/s 1.7 alpha 1 [ 10170 ]
        Fix Version/s 1.7 beta [ 10110 ]
        sharon Sharon Barr (Inactive) made changes -
        Affects Version/s 1.7 Alpha 2 [ 10180 ]
        Affects Version/s 1.6.4.1 [ 10141 ]
        sharon Sharon Barr (Inactive) made changes -
        Fix Version/s 1.7 Alpha 2 [ 10180 ]
        Fix Version/s 1.7 alpha 1 [ 10170 ]
        bcui Bin Cui made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Resolution Fixed [ 1 ]
        farshid Farshid Ghods (Inactive) made changes -
        Flagged [Release Note]
        perry Perry Krug made changes -
        Resolution Fixed [ 1 ]
        Status Resolved [ 5 ] Reopened [ 4 ]
        perry Perry Krug made changes -
        Affects Version/s 1.8.0 [ 10248 ]
        steve Steve Yen made changes -
        Assignee Bin Cui [ bcui ] Steve Yen [ steve ]
        peter peter made changes -
        Component/s tools [ 10223 ]
        Component/s cli [ 10011 ]
        steve Steve Yen made changes -
        Status Reopened [ 4 ] Resolved [ 5 ]
        Resolution Fixed [ 1 ]
        steve Steve Yen made changes -
        Resolution Fixed [ 1 ]
        Status Resolved [ 5 ] Reopened [ 4 ]
        steve Steve Yen made changes -
        Status Reopened [ 4 ] Resolved [ 5 ]
        Resolution Won't Fix [ 2 ]
        mikew Mike Wiederhold made changes -
        Status Resolved [ 5 ] Closed [ 6 ]

          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