Restoring backup from production restores documents as binary

Couchbase Server
1

This question is based off the following question Sync gateway not returning results when performing get request for a document

When backing up my production db and restoring to my local couchbase db the documents end up as binary and the error message “Warning: Editing of binary document is not allowed” is displayed when viewing a document in the UI. I used cbbackup and cbrestore to backup and restore. Using couchbase server 5.0.1 community

The solution mentioned in the link above was to delete the document and recreate it. But this affects all of my documents and I’m unable to use my production db locally. Any ideas of what I could do to fix this? At the moment I have none.

2

@glenbray,

Is your production cluster also using SG 1.5.1 and CB 5.0.1?

3

@househippo yeah thats correct. All running in docker containers.

4

@glenbray,

hmmm maybe cbbackup was never tested with the new xattr of CB 5.0 and is not taking the backups correctly.
cbbackup is no longer CB’s EE used tool for backups, cbbackupmgr is.

5

@househippo, ah right! I’ll try cbbackupmgr later today and let you know. Hopefully this works.

6

hey @househippo, so it doesn’t appear that cbbackupmgr is available on community. Is it only available on enterprise?

7

Hi @glenbray,

so it doesn’t appear that cbbackupmgr is available on community. Is it only available on enterprise?

Yes, cbbackupmgr is only available on Enterprise Edition

The issue you are hitting is MB-27459, which is targeted to be fixed in Couchbase Server 5.1.0.

If you can’t wait until 5.1.0 the code change to fix this is pretty lightweight:

http://review.couchbase.org/#/c/87583/2/pump_bfd.py

As always I would recommend testing this before using that patch in production.

I hope this helps.

8

just applied that fix and tested. Works great, thanks for that @pvarley. Thanks as well @househippo.