Software update of Columnstore overwrites datafiles, Internal error: MCS-2006

mariadb -ABNe "select product_name from inventory.products limit 1"

ERROR 1815 (HY000) at line 1: Internal error: MCS-2006: 'inventory.products' does not exist in Columnstore.

mariadb -ABNe "select version();"

10.5.13-9-MariaDB-enterprise

mariadb -ABNe "show status like 'Columnstore_version'"

Columnstore_version     5.6.3

grep -i service /etc/columnstore/storagemanager.cnf | grep '\='

service = LocalStorage

[ -f "/etc/columnstore/cmapi_server.conf" ] && echo "cmapi is installed" || echo "cmapi is not installed"

cmapi is not installed

mariadb -ABNe "select TABLE_SCHEMA, TABLE_NAME, ENGINE from information_schema.tables where TABLE_NAME='products';"

inventory       products        Columnstore

mariadb -ABNe "select product_name from inventory.products limit 1"

e0c1f3e6

systemctl stop mariadb-columnstore

systemctl stop mariadb

apt remove "*mariadb*"

apt remove "galera*"

chmod 750 mariadb_es_repo_setup

./mariadb_es_repo_setup --token="<YOUR CUSTOMER TOKEN HERE>" --apply --mariadb-server-version="10.6"

rm /etc/apt/sources.list.d/mariadb.*old*

apt update

touch /tmp/t.txt

apt install mariadb-client mariadb-server mariadb-backup mariadb-plugin-columnstore libmariadb3

# if no changes were made to datafiles in software update, thise should return 0:

find /var/lib/columnstore/ -newer /tmp/t.txt |wc -l

150

mariadb -ABNe "select product_name from inventory.products limit 1"

ERROR 1815 (HY000) at line 1: Internal error: MCS-2006: 'inventory.products' does not exist in Columnstore.