Sample Header Ad - 728x90

CockroachDB upgrade not finalized

0 votes
1 answer
166 views
I am running a three-node CockroachDB docker cluster (Debian OS) and I recently upgraded the cluster from version v21.1 to version v21.2 following the procedure outlined in the [documentation](https://www.cockroachlabs.com/docs/v21.2/upgrade-cockroach-version) using the option
SET CLUSTER SETTING cluster.preserve_downgrade_option = '21.1';
Then I restarted the container of each node one at a time and when no issues arose I run
RESET CLUSTER SETTING cluster.preserve_downgrade_option;
Now all three nodes are running the same version and the **cluster.preserve_downgrade_option** is set to an empty string. Nonetheless, even after hours have elapsed since then, when I am trying to create a table which has a feature included in the 21.2 version
create table randdb.public.randtable
(
	name_surname varchar(30),
	update_tim TIMESTAMPTZ DEFAULT now() ON UPDATE now(),
	PRIMARY KEY (name_surname)
)
I get the error message
SQL Error [0A000]: ERROR: version 21.1-1152 must be finalized to use ON UPDATE
Other than this, the cluster seems to be fully functional. Any ideas what has gone wrong?
Asked by agrajag_42 (1 rep)
Nov 30, 2021, 11:59 AM
Last activity: Nov 30, 2021, 02:51 PM