gptext error on write - 'Collection <gptext-index> is read-only.. '

Products

• VMware Tanzu Greenplum

Issue/Introduction

New in gptext 3.11, error message like the one below appears when trying to write to read-only index.

'Collection db.dw.sdfhindex is read-only.. ' (UDF.cpp:215) (seg74 slice1 10.84.100.230:16728 pid=700223)

Checking state of gptext shows the following:

# gptext-state -D
20231105:10:48:45:393878 gptext-state:idb7570:gpadmin-[INFO]:-Execute GPText state ...
20231105:10:48:54:393878 gptext-state:idb7570:gpadmin-[INFO]:-Check zookeeper cluster state ...
20231105:10:48:55:393878 gptext-state:idb7570:gpadmin-[INFO]:-Check GPText cluster status...
20231105:10:48:56:393878 gptext-state:idb7570:gpadmin-[INFO]:-Current GPText Version: 3.11.0
20231105:10:48:57:393878 gptext-state:idb7570:gpadmin-[INFO]:-All nodes are up and running.
20231105:10:48:57:393878 gptext-state:idb7570:gpadmin-[INFO]:------------------------------------------------
20231105:10:48:57:393878 gptext-state:idb7570:gpadmin-[INFO]:-Index state details.
20231105:10:48:57:393878 gptext-state:idb7570:gpadmin-[INFO]:------------------------------------------------
20231105:10:48:57:393878 gptext-state:idb7570:gpadmin-[INFO]:-  database   index name                  state  read only
20231105:10:48:57:393878 gptext-state:idb7570:gpadmin-[INFO]:-  sddb  db.dw.sdfhindex  Green  True
20231105:10:48:57:393878 gptext-state:idb7570:gpadmin-[INFO]:-Done.

Environment

Product Version: 6.25

Resolution

Run the following commands to unset read-only mode:

Execute SQL:
SELECT * FROM gptext.commit_index('index_name');

Run gptext-readonly utility:
gptext-readonly unset -i index_name

For more info on gptext-readonly, see documentation at: https://docs.vmware.com/en/VMware-Greenplum-Text/3.11/greenplum-text/topics-utility_ref.html#gptext-readonly