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
Last activity: Nov 30, 2021, 02:51 PM