Cannot dump upgraded database

I have a database used for testing. It runs as an insecure docker instance.

I updated the docker image version from 1.0.6 to 1.1.0 and restarted the docker instance. Everything seems fine, the admin ui is fine and all the data is still there.

I tried to run cockroach dump --insecure <dbname> and I got this error:

Error: pq: column name "create_table" not found
Failed running "dump"

I have not finalized the upgrade yet.

Edit: I needed to upgrade my local version of the cockroach binary! That fixed my issue. Sorry!

1 Like

We could definitely give you a better error message in case of a version mismatch. I’ve filed an issue about this: https://github.com/cockroachdb/cockroach/issues/19245

Glad you got it working, though!