Skip to content

backupccl: move free-to-use BACKUP code to OSS tree #56683

@davepacheco

Description

@davepacheco

We're running a CockroachDB v20.2.0 binary that we've built for illumos with make buildoss. It looks like this:

root@nvmedb1:~# /cockroachdb/bin/cockroach version
Build Tag:        v20.2.0
Build Time:       2020/11/11 20:41:23
Distribution:     OSS
Platform:         illumos amd64 (x86_64-pc-solaris2.11)
Go Version:       go1.15.3
C Compiler:       gcc 9.3.0
Build Commit ID:  150c5918fb6e28e0ea5bfa4e8e94088986fbbf98
Build Type:       release

root@nvmedb1:~# uname -a
SunOS nvmedb1 5.11 omnios-r151034-b3d6e2addc i86pc i386 i86pc
root@nvmedb1:~# 

I set up a 3-node cluster in AWS using this build. I populated it using the "kv" workload (using cockroach workload). I then tried to back it up with the newly-free BACKUP command, but it failed like this:

root@loadgen0:~# cockroach sql 
#
# Welcome to the CockroachDB SQL shell.
# All statements must be terminated by a semicolon.
# To exit, type: \q.
#
# Client version: CockroachDB OSS v20.2.0-rc.3 (x86_64-pc-solaris2.11, built 2020/11/06 22:01:00, go1.15.3)
# Server version: CockroachDB OSS v20.2.0 (x86_64-pc-solaris2.11, built 2020/11/11 20:41:23, go1.15.3)
# Cluster ID: 5163af61-986b-40bf-80ac-fe74affc5072
#
# Enter \? for a brief introduction.
#
root@192.168.1.163:26257/defaultdb> BACKUP DATABASE kv TO "nodelocal://1/backup-2020-11-13";
ERROR: a CCL binary is required to use this statement type: *tree.Backup
SQLSTATE: XXC01
root@192.168.1.163:26257/defaultdb> ^D
ERROR: a CCL binary is required to use this statement type: *tree.Backup
SQLSTATE: XXC01
Failed running "sql"
root@loadgen0:~# 

I understood from the recent announcement and the current docs on BACKUP that a full backup like this is supposed to be part of the "free, open-source option CockroachDB Core". Shouldn't it work with a make buildoss build? I wouldn't expect it to require a CCL binary.

Thanks in advance!

Epic CRDB-8962

Jira issue: CRDB-2915

Metadata

Metadata

Assignees

No one assigned

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions