[#MCOL-5150] Columnstore related error messages after Columnstore in uninstalled

[MCOL-5150] Columnstore related error messages after Columnstore in uninstalled Created: 2022-06-27 Updated: 2023-10-27 Resolved: 2023-10-27
Status:	Closed
Project:	MariaDB ColumnStore
Component/s:	N/A
Affects Version/s:	1.4.4
Fix Version/s:	23.10

Type:

Bug

Priority:

Trivial

Reporter:

Susmeet Khaire

Assignee:

Leonid Fedorov

Resolution:

Fixed

Votes:

Labels:

None

Description

Columstore throws error messages after uninstalling columnstore.
It seems to be searching for the .so files that don't exist post uninstallation.

Things to note:

Customer is using a non-standard data directory
Also using different system user & group.

Post installing columnstore, mariadb service runs fine but the error messages in the error log causes their monitoring scripts to raise false alarms.

Installing MariaDB-columnstore-libs MariaDB-columnstore-engine gets rid of the error but customer doesn't want to install unncessary binaries in Production environment.

Installation steps: How customer has installed MariaDB & Columnstore

Tested on 10.4.14-8 version
[root@localhost ~]# ./mariadb_es_repo_setup --token="XXXXXXXXXXXXXXXXXXXXXXX" --apply --mariadb-server-version="10.4.14-8"

[root@localhost ~]# yum install -y MariaDB-server

[root@localhost ~]# yum install -y MariaDB-columnstore-platform.x86_64 MariaDB-columnstore-libs MariaDB-columnstore-engine

[root@localhost ~]# postConfigure

This is the MariaDB ColumnStore System Configuration and Installation tool.

It will Configure the MariaDB ColumnStore System and will perform a Package

Installation of all of the Servers within the System that is being configured.

IMPORTANT: This tool requires to run on the Performance Module #1

Prompting instructions:

        Press 'enter' to accept a value in (), if available or

        Enter one of the options within [], if available, or

        Enter a new value

===== Setup System Server Type Configuration =====

There are 2 options when configuring the System Server Type: single and multi

  'single'  - Single-Server install is used when there will only be 1 server configured

              on the system. It can also be used for production systems, if the plan is

              to stay single-server.

  'multi'   - Multi-Server install is used when you want to configure multiple servers now or

              in the future. With Multi-Server install, you can still configure just 1 server

              now and add on addition servers/modules in the future.

Select the type of System Server install [1=single, 2=multi] (2) > 1

Performing the Single Server Install.

Enter System Name (columnstore-1) >

===== Setup Storage Configuration =====

----- Setup Performance Module DBRoot Data Storage Mount Configuration -----

Columnstore supports the following storage options...

  1 - internal.  This uses the linux VFS to access files and does

      not manage the filesystem.

  2 - external *.  If you have other mountable filesystems you would

      like ColumnStore to use & manage, select this option.

  3 - GlusterFS *  Note: glusterd service must be running and enabled on

      all PMs.

  4 - S3-compatible cloud storage *.  Note: that should be configured

      before running postConfigure (see storagemanager.cnf)

  * - This option enables data replication and server failover in a

      multi-node configuration.

These options are available on this system: [1, 2, 4]

Select the type of data storage (1) >

Enter the list (Nx,Ny,Nz) or range (Nx-Nz) of DBRoot IDs assigned to module 'pm1' (1) >

sh: netstat: command not found

===== Performing Configuration Setup and MariaDB ColumnStore Startup =====

NOTE: Setting 'NumBlocksPct' to 50%

      Setting 'TotalUmMemory' to 25% of total memory.

Running the MariaDB ColumnStore setup scripts

post-mysqld-install Successfully Completed

post-mysql-install Successfully Completed

Starting module pm1 of MariaDB Columnstore Database Platform

Starting MariaDB ColumnStore Database Platform Starting, please wait ..... DONE

System Catalog Successfully Created

MariaDB ColumnStore Install Successfully Completed, System is Active

Enter the following command to define MariaDB ColumnStore Alias Commands

. /etc/profile.d/columnstoreAlias.sh

Enter 'mariadb' to access the MariaDB ColumnStore SQL console

Enter 'mcsadmin' to access the MariaDB ColumnStore Admin console

NOTE: The MariaDB ColumnStore Alias Commands are in /etc/profile.d/columnstoreAlias.sh

[root@localhost ~]# mcsadmin getSystemInfo

getsysteminfo   Mon Jun 27 11:25:47 2022

System columnstore-1

System and Module statuses

Component     Status                       Last Status Change

------------  --------------------------   ------------------------

System        ACTIVE                       Mon Jun 27 11:23:18 2022

Module pm1    ACTIVE                       Mon Jun 27 11:23:10 2022

MariaDB ColumnStore Process statuses

Process             Module    Status            Last Status Change        Process ID

------------------  ------    ---------------   ------------------------  ----------

ProcessMonitor      pm1       ACTIVE            Mon Jun 27 11:22:40 2022        2035

ProcessManager      pm1       ACTIVE            Mon Jun 27 11:22:46 2022        2096

DBRMControllerNode  pm1       ACTIVE            Mon Jun 27 11:22:51 2022        2290

ServerMonitor       pm1       ACTIVE            Mon Jun 27 11:22:54 2022        2312

DBRMWorkerNode      pm1       ACTIVE            Mon Jun 27 11:22:54 2022        2340

PrimProc            pm1       ACTIVE            Mon Jun 27 11:22:57 2022        2386

ExeMgr              pm1       ACTIVE            Mon Jun 27 11:23:01 2022        2442

WriteEngineServer   pm1       ACTIVE            Mon Jun 27 11:23:05 2022        2491

DDLProc             pm1       ACTIVE            Mon Jun 27 11:23:09 2022        2548

DMLProc             pm1       ACTIVE            Mon Jun 27 11:23:17 2022        2598

mysqld              pm1       ACTIVE            Mon Jun 27 11:22:48 2022        2232

Active Alarm Counts: Critical = 0, Major = 0, Minor = 0, Warning = 0, Info = 0

Edit my.cnf file to add error logging to a file
[root@localhost ~]# mkdir -p /var/log/mysql/
[root@localhost ~]# chown -R mysql. /var/log/mysql/
[root@localhost ~]# vim /etc/my.cnf.d/server.cnf
log_error = /var/log/mysql/error.log

[root@localhost ~]# systemctl restart mariadb

Installation was successfull and no errors logged
[root@localhost ~]# tail -100f /var/log/mysql/error.log
220627 11:30:12 Columnstore: Started; Version: 1.4.4-1
2022-06-27 11:30:12 0 [Note] InnoDB: Using Linux native AIO
2022-06-27 11:30:12 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2022-06-27 11:30:12 0 [Note] InnoDB: Uses event mutexes
2022-06-27 11:30:12 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
2022-06-27 11:30:12 0 [Note] InnoDB: Number of pools: 1
2022-06-27 11:30:12 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-06-27 11:30:12 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
2022-06-27 11:30:12 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2022-06-27 11:30:12 0 [Note] InnoDB: Completed initialization of buffer pool
2022-06-27 11:30:12 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2022-06-27 11:30:12 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-06-27 11:30:12 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-06-27 11:30:12 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-06-27 11:30:12 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-06-27 11:30:12 0 [Note] InnoDB: Waiting for purge to start
2022-06-27 11:30:12 0 [Note] InnoDB: 10.4.14 started; log sequence number 76973; transaction id 49
2022-06-27 11:30:12 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2022-06-27 11:30:12 0 [Note] InnoDB: Buffer pool(s) load completed at 220627 11:30:12
2022-06-27 11:30:12 0 [Note] Plugin 'S3' is disabled.
2022-06-27 11:30:12 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-06-27 11:30:12 server_audit: MariaDB Audit Plugin version 2.0.2 STARTED.
2022-06-27 11:30:12 server_audit: Query cache is enabled with the TABLE events. Some table reads can be veiled.
2022-06-27 11:30:12 0 [Note] Server socket created on IP: '::'.
2022-06-27 11:30:12 0 [Note] Reading of all Master_info entries succeeded
2022-06-27 11:30:12 0 [Note] Added new Master_info '' to hash table
2022-06-27 11:30:12 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.4.14-8-MariaDB-enterprise' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Enterprise Server

Stop columnstore & Mariadb services
[root@localhost ~]# mcsadmin shutdownSystem
shutdownsystem Mon Jun 27 11:33:17 2022

This command stops the processing of applications on all Modules within the MariaDB ColumnStore System

Checking for active transactions
Do you want to proceed: (y or n) [n]: y

Stopping System...
Successful stop of System

Shutting Down System...
Successful shutdown of System

[root@localhost ~]# systemctl stop mariadb

Move the columnstore and mariadb data directories
[root@localhost ~]# mkdir -p /mariadata
[root@localhost ~]# cp -r /var/lib/mysql /mariadata/
[root@localhost ~]# cp -r /var/lib/columnstore /mariadata/
[root@localhost ~]# cd /mariadata/
[root@localhost mariadata]# ll
total 0
drwxr-xr-x 5 root root 44 Jun 27 11:36 columnstore
drwxr-xr-x 7 root root 263 Jun 27 11:35 mysql
[root@localhost mariadata]# cd
[root@localhost ~]# mv /var/lib/mysql /var/lib/mysql-old
[root@localhost ~]# mv /var/lib/columnstore /var/lib/columnstore-old

Create new user and group. Change ownership of the new data directories
[root@localhost ~]# groupadd gmariadb
[root@localhost ~]# useradd -r -g gmariadb -s /bin/false mariadb

[root@localhost ~]# cd /mariadata/
[root@localhost mariadata]# ll
total 0
drwxr-xr-x 5 root root 44 Jun 27 11:36 columnstore
drwxr-xr-x 7 root root 263 Jun 27 11:35 mysql
[root@localhost mariadata]# chown -R mariadb:gmariadb *
[root@localhost mariadata]# ll
total 0
drwxr-xr-x 5 mariadb gmariadb 44 Jun 27 11:36 columnstore
drwxr-xr-x 7 mariadb gmariadb 263 Jun 27 11:35 mysql

Create softlinks
[root@localhost ~]# ln -s /mariadata/columnstore /var/lib/columnstore
[root@localhost ~]# ln -s /mariadata/mysql /var/lib/mysql

Edit the unit file to update the user & group
[root@localhost ~]# vim /usr/lib/systemd/system/mariadb.service
User=mariadb
Group=gmariadb

[root@localhost ~]# systemctl disable mariadb
[root@localhost ~]# systemctl enable mariadb
Created symlink from /etc/systemd/system/mysql.service to /usr/lib/systemd/system/mariadb.service.
Created symlink from /etc/systemd/system/mysqld.service to /usr/lib/systemd/system/mariadb.service.
Created symlink from /etc/systemd/system/multi-user.target.wants/mariadb.service to /usr/lib/systemd/system/mariadb.service.

Edit my.cnf to add the new data directory
[root@localhost ~]# vim /etc/my.cnf.d/server.cnf
datadir = /mariadata/mysql/

Start mariadb which is now pointing to the new data directory and new user & group
[root@localhost ~]# systemctl restart mariadb

[root@localhost ~]# ps aux \| grep mysql
mariadb 5485 0.9 4.6 1485248 94864 ? Ssl 11:46 0:01 /usr/sbin/mysqld
root 5523 0.0 0.0 108096 616 pts/1 S+ 11:47 0:00 tail -100f /var/log/mysql/error.log
root 5525 0.0 0.0 112812 984 pts/0 R+ 11:48 0:00 grep --color=auto mysql

Start columnstore which is now pointing to the new data directory and new user & group
[root@localhost ~]# systemctl start columnstore

[root@localhost ~]# mcsadmin getSystemInfo
getsysteminfo Mon Jun 27 11:56:33 2022

System columnstore-1

System and Module statuses

Component Status Last Status Change
------------ -------------------------- ------------------------
System ACTIVE Mon Jun 27 11:56:16 2022

Module pm1 ACTIVE Mon Jun 27 11:56:13 2022


MariaDB ColumnStore Process statuses

Process Module Status Last Status Change Process ID
------------------ ------ --------------- ------------------------ ----------
ProcessMonitor pm1 ACTIVE Mon Jun 27 11:55:39 2022 5598
ProcessManager pm1 ACTIVE Mon Jun 27 11:55:46 2022 5702
DBRMControllerNode pm1 ACTIVE Mon Jun 27 11:55:52 2022 5834
ServerMonitor pm1 ACTIVE Mon Jun 27 11:55:54 2022 5868
DBRMWorkerNode pm1 ACTIVE Mon Jun 27 11:55:54 2022 5893
PrimProc pm1 ACTIVE Mon Jun 27 11:55:58 2022 5937
ExeMgr pm1 ACTIVE Mon Jun 27 11:56:02 2022 5980
WriteEngineServer pm1 ACTIVE Mon Jun 27 11:56:06 2022 6047
DDLProc pm1 ACTIVE Mon Jun 27 11:56:11 2022 6095
DMLProc pm1 ACTIVE Mon Jun 27 11:56:15 2022 6141
mysqld pm1 ACTIVE Mon Jun 27 11:55:46 2022 5485

Active Alarm Counts: Critical = 0, Major = 0, Minor = 0, Warning = 0, Info = 0

Error log is clean
[root@localhost ~]# tail -100f /var/log/mysql/error.log
220627 11:30:12 Columnstore: Started; Version: 1.4.4-1
2022-06-27 11:30:12 0 [Note] InnoDB: Using Linux native AIO
2022-06-27 11:30:12 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2022-06-27 11:30:12 0 [Note] InnoDB: Uses event mutexes
2022-06-27 11:30:12 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
2022-06-27 11:30:12 0 [Note] InnoDB: Number of pools: 1
2022-06-27 11:30:12 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-06-27 11:30:12 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
2022-06-27 11:30:12 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2022-06-27 11:30:12 0 [Note] InnoDB: Completed initialization of buffer pool
2022-06-27 11:30:12 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2022-06-27 11:30:12 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-06-27 11:30:12 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-06-27 11:30:12 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-06-27 11:30:12 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-06-27 11:30:12 0 [Note] InnoDB: Waiting for purge to start
2022-06-27 11:30:12 0 [Note] InnoDB: 10.4.14 started; log sequence number 76973; transaction id 49
2022-06-27 11:30:12 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2022-06-27 11:30:12 0 [Note] InnoDB: Buffer pool(s) load completed at 220627 11:30:12
2022-06-27 11:30:12 0 [Note] Plugin 'S3' is disabled.
2022-06-27 11:30:12 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-06-27 11:30:12 server_audit: MariaDB Audit Plugin version 2.0.2 STARTED.
2022-06-27 11:30:12 server_audit: Query cache is enabled with the TABLE events. Some table reads can be veiled.
2022-06-27 11:30:12 0 [Note] Server socket created on IP: '::'.
2022-06-27 11:30:12 0 [Note] Reading of all Master_info entries succeeded
2022-06-27 11:30:12 0 [Note] Added new Master_info '' to hash table
2022-06-27 11:30:12 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.4.14-8-MariaDB-enterprise' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Enterprise Server
2022-06-27 11:33:22 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown
2022-06-27 11:33:22 0 [Note] Event Scheduler: Purging the queue. 0 events
2022-06-27 11:33:22 0 [Note] InnoDB: FTS optimize thread exiting.
2022-06-27 11:33:22 server_audit: STOPPED
2022-06-27 11:33:22 0 [Note] InnoDB: Starting shutdown...
2022-06-27 11:33:22 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2022-06-27 11:33:22 0 [Note] InnoDB: Buffer pool(s) dump completed at 220627 11:33:22
2022-06-27 11:33:24 0 [Note] InnoDB: Shutdown completed; log sequence number 76982; transaction id 50
2022-06-27 11:33:24 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-06-27 11:33:24 0 [Note] /usr/sbin/mysqld: Shutdown complete

Steps performed to remove Columnstore

Remove plugins
[root@localhost ~]# mysql
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 9
Server version: 10.4.14-8-MariaDB-enterprise MariaDB Enterprise Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.


MariaDB [(none)]> SHOW PLUGINS;
+-------------------------------+----------+---------------------+--------------------------+---------+
\| Name \| Status \| Type \| Library \| License \|
+-------------------------------+----------+---------------------+--------------------------+---------+
\| binlog \| ACTIVE \| STORAGE ENGINE \| NULL \| GPL \|
\| mysql_native_password \| ACTIVE \| AUTHENTICATION \| NULL \| GPL \|
\| mysql_old_password \| ACTIVE \| AUTHENTICATION \| NULL \| GPL \|
\| wsrep \| ACTIVE \| STORAGE ENGINE \| NULL \| GPL \|
\| CSV \| ACTIVE \| STORAGE ENGINE \| NULL \| GPL \|
\| MEMORY \| ACTIVE \| STORAGE ENGINE \| NULL \| GPL \|
\| Aria \| ACTIVE \| STORAGE ENGINE \| NULL \| GPL \|
\| MyISAM \| ACTIVE \| STORAGE ENGINE \| NULL \| GPL \|
\| MRG_MyISAM \| ACTIVE \| STORAGE ENGINE \| NULL \| GPL \|
\| CLIENT_STATISTICS \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INDEX_STATISTICS \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| TABLE_STATISTICS \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| USER_STATISTICS \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| SQL_SEQUENCE \| ACTIVE \| STORAGE ENGINE \| NULL \| GPL \|
\| InnoDB \| ACTIVE \| STORAGE ENGINE \| NULL \| GPL \|
\| INNODB_TRX \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_LOCKS \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_LOCK_WAITS \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_CMP \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_CMP_RESET \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_CMPMEM \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_CMPMEM_RESET \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_CMP_PER_INDEX \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_CMP_PER_INDEX_RESET \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_BUFFER_PAGE \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_BUFFER_PAGE_LRU \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_BUFFER_POOL_STATS \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_METRICS \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_FT_DEFAULT_STOPWORD \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_FT_DELETED \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_FT_BEING_DELETED \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_FT_CONFIG \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_FT_INDEX_CACHE \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_FT_INDEX_TABLE \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_SYS_TABLES \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_SYS_TABLESTATS \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_SYS_INDEXES \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_SYS_COLUMNS \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_SYS_FIELDS \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_SYS_FOREIGN \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_SYS_FOREIGN_COLS \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_SYS_TABLESPACES \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_SYS_DATAFILES \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_SYS_VIRTUAL \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_MUTEXES \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_SYS_SEMAPHORE_WAITS \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_TABLESPACES_ENCRYPTION \| ACTIVE \| INFORMATION SCHEMA \| NULL \| BSD \|
\| INNODB_TABLESPACES_SCRUBBING \| ACTIVE \| INFORMATION SCHEMA \| NULL \| BSD \|
\| S3 \| DISABLED \| STORAGE ENGINE \| NULL \| GPL \|
\| PERFORMANCE_SCHEMA \| ACTIVE \| STORAGE ENGINE \| NULL \| GPL \|
\| SEQUENCE \| ACTIVE \| STORAGE ENGINE \| NULL \| GPL \|
\| unix_socket \| ACTIVE \| AUTHENTICATION \| NULL \| GPL \|
\| FEEDBACK \| DISABLED \| INFORMATION SCHEMA \| NULL \| GPL \|
\| user_variables \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| partition \| ACTIVE \| STORAGE ENGINE \| NULL \| GPL \|
\| Columnstore \| ACTIVE \| STORAGE ENGINE \| ha_columnstore.so \| GPL \|
\| COLUMNSTORE_COLUMNS \| ACTIVE \| INFORMATION SCHEMA \| ha_columnstore.so \| GPL \|
\| COLUMNSTORE_TABLES \| ACTIVE \| INFORMATION SCHEMA \| ha_columnstore.so \| GPL \|
\| COLUMNSTORE_FILES \| ACTIVE \| INFORMATION SCHEMA \| ha_columnstore.so \| GPL \|
\| COLUMNSTORE_EXTENTS \| ACTIVE \| INFORMATION SCHEMA \| ha_columnstore.so \| GPL \|
\| SERVER_AUDIT \| ACTIVE \| AUDIT \| server_audit2.so \| GPL \|
\| DISKS \| ACTIVE \| INFORMATION SCHEMA \| disks.so \| GPL \|
\| ed25519 \| ACTIVE \| AUTHENTICATION \| auth_ed25519.so \| GPL \|
\| simple_password_check \| ACTIVE \| PASSWORD VALIDATION \| simple_password_check.so \| GPL \|
+-------------------------------+----------+---------------------+--------------------------+---------+
64 rows in set (0.001 sec)

MariaDB [(none)]> UNINSTALL PLUGIN Columnstore;
Query OK, 0 rows affected (0.001 sec)

MariaDB [(none)]> UNINSTALL PLUGIN COLUMNSTORE_COLUMNS;
Query OK, 0 rows affected (0.000 sec)

MariaDB [(none)]> UNINSTALL PLUGIN COLUMNSTORE_TABLES;
Query OK, 0 rows affected (0.000 sec)

MariaDB [(none)]> UNINSTALL PLUGIN COLUMNSTORE_FILES;
Query OK, 0 rows affected (0.000 sec)

MariaDB [(none)]> UNINSTALL PLUGIN COLUMNSTORE_EXTENTS;
Query OK, 0 rows affected (0.000 sec)

MariaDB [(none)]> SHOW PLUGINS;
+-------------------------------+----------+---------------------+--------------------------+---------+
\| Name \| Status \| Type \| Library \| License \|
+-------------------------------+----------+---------------------+--------------------------+---------+
\| binlog \| ACTIVE \| STORAGE ENGINE \| NULL \| GPL \|
\| mysql_native_password \| ACTIVE \| AUTHENTICATION \| NULL \| GPL \|
\| mysql_old_password \| ACTIVE \| AUTHENTICATION \| NULL \| GPL \|
\| wsrep \| ACTIVE \| STORAGE ENGINE \| NULL \| GPL \|
\| CSV \| ACTIVE \| STORAGE ENGINE \| NULL \| GPL \|
\| MEMORY \| ACTIVE \| STORAGE ENGINE \| NULL \| GPL \|
\| Aria \| ACTIVE \| STORAGE ENGINE \| NULL \| GPL \|
\| MyISAM \| ACTIVE \| STORAGE ENGINE \| NULL \| GPL \|
\| MRG_MyISAM \| ACTIVE \| STORAGE ENGINE \| NULL \| GPL \|
\| CLIENT_STATISTICS \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INDEX_STATISTICS \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| TABLE_STATISTICS \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| USER_STATISTICS \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| SQL_SEQUENCE \| ACTIVE \| STORAGE ENGINE \| NULL \| GPL \|
\| InnoDB \| ACTIVE \| STORAGE ENGINE \| NULL \| GPL \|
\| INNODB_TRX \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_LOCKS \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_LOCK_WAITS \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_CMP \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_CMP_RESET \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_CMPMEM \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_CMPMEM_RESET \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_CMP_PER_INDEX \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_CMP_PER_INDEX_RESET \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_BUFFER_PAGE \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_BUFFER_PAGE_LRU \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_BUFFER_POOL_STATS \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_METRICS \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_FT_DEFAULT_STOPWORD \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_FT_DELETED \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_FT_BEING_DELETED \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_FT_CONFIG \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_FT_INDEX_CACHE \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_FT_INDEX_TABLE \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_SYS_TABLES \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_SYS_TABLESTATS \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_SYS_INDEXES \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_SYS_COLUMNS \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_SYS_FIELDS \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_SYS_FOREIGN \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_SYS_FOREIGN_COLS \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_SYS_TABLESPACES \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_SYS_DATAFILES \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_SYS_VIRTUAL \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_MUTEXES \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_SYS_SEMAPHORE_WAITS \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| INNODB_TABLESPACES_ENCRYPTION \| ACTIVE \| INFORMATION SCHEMA \| NULL \| BSD \|
\| INNODB_TABLESPACES_SCRUBBING \| ACTIVE \| INFORMATION SCHEMA \| NULL \| BSD \|
\| S3 \| DISABLED \| STORAGE ENGINE \| NULL \| GPL \|
\| PERFORMANCE_SCHEMA \| ACTIVE \| STORAGE ENGINE \| NULL \| GPL \|
\| SEQUENCE \| ACTIVE \| STORAGE ENGINE \| NULL \| GPL \|
\| unix_socket \| ACTIVE \| AUTHENTICATION \| NULL \| GPL \|
\| FEEDBACK \| DISABLED \| INFORMATION SCHEMA \| NULL \| GPL \|
\| user_variables \| ACTIVE \| INFORMATION SCHEMA \| NULL \| GPL \|
\| partition \| ACTIVE \| STORAGE ENGINE \| NULL \| GPL \|
\| SERVER_AUDIT \| ACTIVE \| AUDIT \| server_audit2.so \| GPL \|
\| DISKS \| ACTIVE \| INFORMATION SCHEMA \| disks.so \| GPL \|
\| ed25519 \| ACTIVE \| AUTHENTICATION \| auth_ed25519.so \| GPL \|
\| simple_password_check \| ACTIVE \| PASSWORD VALIDATION \| simple_password_check.so \| GPL \|
+-------------------------------+----------+---------------------+--------------------------+---------+
59 rows in set (0.001 sec)

Stop services
[root@localhost ~]# systemctl stop mariadb
[root@localhost ~]# systemctl stop columnstore

Remove columnstore config and rpms. Start Mariadb service alone
[root@localhost ~]# rm -f /etc/my.cnf.d/columnstore.cnf

[root@localhost ~]# yum remove -y MariaDB-columnstore-engine.x86_64 MariaDB-columnstore-libs.x86_64 MariaDB-columnstore-platform.x86_64

[root@localhost ~]# systemctl start mariadb

Notice the error messages in error log
[root@localhost ~]# tail -200f /var/log/mysql/error.log
220627 11:30:12 Columnstore: Started; Version: 1.4.4-1
2022-06-27 11:30:12 0 [Note] InnoDB: Using Linux native AIO
2022-06-27 11:30:12 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2022-06-27 11:30:12 0 [Note] InnoDB: Uses event mutexes
2022-06-27 11:30:12 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
2022-06-27 11:30:12 0 [Note] InnoDB: Number of pools: 1
2022-06-27 11:30:12 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-06-27 11:30:12 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
2022-06-27 11:30:12 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2022-06-27 11:30:12 0 [Note] InnoDB: Completed initialization of buffer pool
2022-06-27 11:30:12 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2022-06-27 11:30:12 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-06-27 11:30:12 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-06-27 11:30:12 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-06-27 11:30:12 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-06-27 11:30:12 0 [Note] InnoDB: Waiting for purge to start
2022-06-27 11:30:12 0 [Note] InnoDB: 10.4.14 started; log sequence number 76973; transaction id 49
2022-06-27 11:30:12 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2022-06-27 11:30:12 0 [Note] InnoDB: Buffer pool(s) load completed at 220627 11:30:12
2022-06-27 11:30:12 0 [Note] Plugin 'S3' is disabled.
2022-06-27 11:30:12 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-06-27 11:30:12 server_audit: MariaDB Audit Plugin version 2.0.2 STARTED.
2022-06-27 11:30:12 server_audit: Query cache is enabled with the TABLE events. Some table reads can be veiled.
2022-06-27 11:30:12 0 [Note] Server socket created on IP: '::'.
2022-06-27 11:30:12 0 [Note] Reading of all Master_info entries succeeded
2022-06-27 11:30:12 0 [Note] Added new Master_info '' to hash table
2022-06-27 11:30:12 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.4.14-8-MariaDB-enterprise' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Enterprise Server
2022-06-27 11:33:22 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown
2022-06-27 11:33:22 0 [Note] Event Scheduler: Purging the queue. 0 events
2022-06-27 11:33:22 0 [Note] InnoDB: FTS optimize thread exiting.
2022-06-27 11:33:22 server_audit: STOPPED
2022-06-27 11:33:22 0 [Note] InnoDB: Starting shutdown...
2022-06-27 11:33:22 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2022-06-27 11:33:22 0 [Note] InnoDB: Buffer pool(s) dump completed at 220627 11:33:22
2022-06-27 11:33:24 0 [Note] InnoDB: Shutdown completed; log sequence number 76982; transaction id 50
2022-06-27 11:33:24 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-06-27 11:33:24 0 [Note] /usr/sbin/mysqld: Shutdown complete

2022-06-27 12:03:13 0 [Note] InnoDB: Using Linux native AIO
2022-06-27 12:03:13 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2022-06-27 12:03:13 0 [Note] InnoDB: Uses event mutexes
2022-06-27 12:03:13 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
2022-06-27 12:03:13 0 [Note] InnoDB: Number of pools: 1
2022-06-27 12:03:13 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-06-27 12:03:13 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
2022-06-27 12:03:13 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2022-06-27 12:03:13 0 [Note] InnoDB: Completed initialization of buffer pool
2022-06-27 12:03:13 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2022-06-27 12:03:13 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-06-27 12:03:13 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-06-27 12:03:13 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-06-27 12:03:13 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-06-27 12:03:13 0 [Note] InnoDB: Waiting for purge to start
2022-06-27 12:03:13 0 [Note] InnoDB: 10.4.14 started; log sequence number 77009; transaction id 49
2022-06-27 12:03:13 0 [Note] InnoDB: Loading buffer pool(s) from /mariadata/mysql/ib_buffer_pool
2022-06-27 12:03:13 0 [Note] InnoDB: Buffer pool(s) load completed at 220627 12:03:13
2022-06-27 12:03:13 0 [Note] Plugin 'S3' is disabled.
2022-06-27 12:03:13 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-06-27 12:03:13 server_audit: MariaDB Audit Plugin version 2.0.2 STARTED.
2022-06-27 12:03:13 server_audit: Query cache is enabled with the TABLE events. Some table reads can be veiled.
2022-06-27 12:03:13 0 [Note] Server socket created on IP: '::'.
2022-06-27 12:03:13 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:03:13 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:03:13 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:03:13 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:03:13 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:03:13 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:03:13 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:03:13 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:03:13 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:03:13 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:03:13 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:03:13 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:03:13 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:03:13 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:03:13 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:03:13 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:03:13 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:03:13 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:03:13 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:03:13 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:03:13 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:03:13 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:03:13 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:03:13 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:03:13 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:03:13 0 [ERROR] Can't open shared library 'libregr_mysql.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:03:13 0 [ERROR] Can't open shared library 'libregr_mysql.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:03:13 0 [ERROR] Can't open shared library 'libregr_mysql.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:03:13 0 [ERROR] Can't open shared library 'libregr_mysql.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:03:13 0 [ERROR] Can't open shared library 'libregr_mysql.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:03:13 0 [ERROR] Can't open shared library 'libregr_mysql.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:03:13 0 [ERROR] Can't open shared library 'libregr_mysql.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:03:13 0 [ERROR] Can't open shared library 'libregr_mysql.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:03:13 0 [ERROR] Can't open shared library 'libregr_mysql.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:03:13 0 [ERROR] Can't open shared library 'libregr_mysql.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:03:13 0 [ERROR] Can't open shared library 'libregr_mysql.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:03:13 0 [ERROR] Can't open shared library 'libregr_mysql.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:03:13 0 [ERROR] Can't open shared library 'libudf_mysql.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:03:13 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:03:13 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:03:13 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:03:13 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:03:13 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:03:13 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:03:13 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:03:13 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:03:13 0 [ERROR] Can't open shared library 'libregr_mysql.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:03:13 0 [Note] Reading of all Master_info entries succeeded
2022-06-27 12:03:13 0 [Note] Added new Master_info '' to hash table
2022-06-27 12:03:13 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.4.14-8-MariaDB-enterprise' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Enterprise Server

Workaround found but not accepted by customer

Install MariaDB-columnstore-engine MariaDB-columnstore-libs
yum install -y MariaDB-columnstore-engine.x86_64 MariaDB-columnstore-libs.x86_64

No errors in error log
[root@localhost ~]# tail -100f /var/log/mysql/error.log
2022-06-27 12:19:45 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-06-27 12:19:45 0 [Note] InnoDB: Waiting for purge to start
2022-06-27 12:19:45 0 [Note] InnoDB: 10.4.14 started; log sequence number 77045; transaction id 49
2022-06-27 12:19:45 0 [Note] InnoDB: Loading buffer pool(s) from /mariadata/mysql/ib_buffer_pool
2022-06-27 12:19:45 0 [Note] InnoDB: Buffer pool(s) load completed at 220627 12:19:45
2022-06-27 12:19:45 0 [Note] Plugin 'S3' is disabled.
2022-06-27 12:19:45 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-06-27 12:19:45 server_audit: MariaDB Audit Plugin version 2.0.2 STARTED.
2022-06-27 12:19:45 server_audit: Query cache is enabled with the TABLE events. Some table reads can be veiled.
2022-06-27 12:19:45 0 [Note] Server socket created on IP: '::'.
2022-06-27 12:19:45 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:19:45 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:19:45 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:19:45 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:19:45 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:19:45 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:19:45 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:19:45 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:19:45 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:19:45 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:19:45 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:19:45 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:19:45 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:19:45 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:19:45 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:19:45 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:19:45 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:19:45 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:19:45 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:19:45 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:19:45 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:19:45 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:19:45 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:19:45 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:19:45 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:19:45 0 [ERROR] Can't open shared library 'libregr_mysql.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:19:45 0 [ERROR] Can't open shared library 'libregr_mysql.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:19:45 0 [ERROR] Can't open shared library 'libregr_mysql.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:19:45 0 [ERROR] Can't open shared library 'libregr_mysql.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:19:45 0 [ERROR] Can't open shared library 'libregr_mysql.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:19:45 0 [ERROR] Can't open shared library 'libregr_mysql.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:19:45 0 [ERROR] Can't open shared library 'libregr_mysql.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:19:45 0 [ERROR] Can't open shared library 'libregr_mysql.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:19:45 0 [ERROR] Can't open shared library 'libregr_mysql.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:19:45 0 [ERROR] Can't open shared library 'libregr_mysql.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:19:45 0 [ERROR] Can't open shared library 'libregr_mysql.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:19:45 0 [ERROR] Can't open shared library 'libregr_mysql.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:19:45 0 [ERROR] Can't open shared library 'libudf_mysql.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:19:45 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:19:45 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:19:45 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:19:45 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:19:45 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:19:45 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:19:45 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:19:45 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:19:45 0 [ERROR] Can't open shared library 'libregr_mysql.so' (errno: 0, cannot open shared object file: No such file or directory)
2022-06-27 12:19:45 0 [Note] Reading of all Master_info entries succeeded
2022-06-27 12:19:45 0 [Note] Added new Master_info '' to hash table
2022-06-27 12:19:45 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.4.14-8-MariaDB-enterprise' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Enterprise Server
2022-06-27 12:20:06 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown
2022-06-27 12:20:06 0 [Note] Event Scheduler: Purging the queue. 0 events
2022-06-27 12:20:06 0 [Note] InnoDB: FTS optimize thread exiting.
2022-06-27 12:20:06 server_audit: STOPPED
2022-06-27 12:20:06 0 [Note] InnoDB: Starting shutdown...
2022-06-27 12:20:06 0 [Note] InnoDB: Dumping buffer pool(s) to /mariadata/mysql/ib_buffer_pool
2022-06-27 12:20:06 0 [Note] InnoDB: Buffer pool(s) dump completed at 220627 12:20:06
2022-06-27 12:20:07 0 [Note] InnoDB: Shutdown completed; log sequence number 77054; transaction id 50
2022-06-27 12:20:07 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-06-27 12:20:07 0 [Note] /usr/sbin/mysqld: Shutdown complete

220627 12:20:07 Columnstore: Started; Version: 1.4.4-1
2022-06-27 12:20:07 0 [Note] InnoDB: Using Linux native AIO
2022-06-27 12:20:07 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2022-06-27 12:20:07 0 [Note] InnoDB: Uses event mutexes
2022-06-27 12:20:07 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
2022-06-27 12:20:07 0 [Note] InnoDB: Number of pools: 1
2022-06-27 12:20:07 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-06-27 12:20:07 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
2022-06-27 12:20:07 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2022-06-27 12:20:07 0 [Note] InnoDB: Completed initialization of buffer pool
2022-06-27 12:20:07 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2022-06-27 12:20:07 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-06-27 12:20:07 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-06-27 12:20:07 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-06-27 12:20:07 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-06-27 12:20:07 0 [Note] InnoDB: Waiting for purge to start
2022-06-27 12:20:07 0 [Note] InnoDB: 10.4.14 started; log sequence number 77054; transaction id 49
2022-06-27 12:20:07 0 [Note] InnoDB: Loading buffer pool(s) from /mariadata/mysql/ib_buffer_pool
2022-06-27 12:20:07 0 [Note] InnoDB: Buffer pool(s) load completed at 220627 12:20:07
2022-06-27 12:20:07 0 [Note] Plugin 'S3' is disabled.
2022-06-27 12:20:07 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-06-27 12:20:07 server_audit: MariaDB Audit Plugin version 2.0.2 STARTED.
2022-06-27 12:20:07 server_audit: Query cache is enabled with the TABLE events. Some table reads can be veiled.
2022-06-27 12:20:07 0 [Note] Server socket created on IP: '::'.
2022-06-27 12:20:07 0 [Note] Reading of all Master_info entries succeeded
2022-06-27 12:20:07 0 [Note] Added new Master_info '' to hash table
2022-06-27 12:20:07 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.4.14-8-MariaDB-enterprise' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Enterprise Server

Comments

Comment by Susmeet Khaire [ 2022-06-27 ]

Tried upgrading to MariaDB 10.6
But the error still persists

[root@LAPTOP-15531O7Q ~]# ./mariadb_es_repo_setup --token="e8499dd2-a9ac-4263-8ac6-cbe1bc0dfb43" --apply --mariadb-server-version="10.6"

[root@LAPTOP-15531O7Q ~]# yum remove -y MariaDB-server

Dependencies Resolved

=============================================================================================================================================================

 Package                               Arch                          Version                                   Repository                               Size

=============================================================================================================================================================

Removing:

 MariaDB-server                        x86_64                        10.4.14_8-1.el7                           @mariadb-es-main                        109 M

Transaction Summary

=============================================================================================================================================================

Remove  1 Package

[root@LAPTOP-15531O7Q ~]# yum install -y MariaDB-server

=============================================================================================================================================================

 Package                               Arch                          Version                                    Repository                              Size

=============================================================================================================================================================

Installing:

 MariaDB-server                        x86_64                        10.6.8_4-1.el7_9                           mariadb-es-main                         20 M

Updating for dependencies:

 MariaDB-client                        x86_64                        10.6.8_4-1.el7_9                           mariadb-es-main                        8.7 M

 MariaDB-common                        x86_64                        10.6.8_4-1.el7_9                           mariadb-es-main                         83 k

Transaction Summary

=============================================================================================================================================================

Install  1 Package

-- Edit the unit file

[root@LAPTOP-15531O7Q ~]# vim /usr/lib/systemd/system/mariadb.service

[root@LAPTOP-15531O7Q ~]# systemctl disable mariadb

[root@LAPTOP-15531O7Q ~]# systemctl enable mariadb

Created symlink from /etc/systemd/system/multi-user.target.wants/mariadb.service to /usr/lib/systemd/system/mariadb.service.

-- Add the error log file and datadir config values

[root@LAPTOP-15531O7Q ~]# vim /etc/my.cnf.d/server.cnf

[root@LAPTOP-15531O7Q ~]# tail -70f /var/log/mysql/error.log

2022-06-27 15:23:43 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728

2022-06-27 15:23:43 0 [Note] InnoDB: Completed initialization of buffer pool

2022-06-27 15:23:43 0 [Note] InnoDB: Upgrading redo log: 100663296 bytes; LSN=84663

2022-06-27 15:23:43 0 [Note] InnoDB: Starting to delete and rewrite log file.

2022-06-27 15:23:43 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 100663296 bytes

2022-06-27 15:23:43 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0

2022-06-27 15:23:43 0 [Note] InnoDB: New log file created, LSN=84663

2022-06-27 15:23:43 0 [Note] InnoDB: 128 rollback segments are active.

2022-06-27 15:23:43 0 [Note] InnoDB: Creating shared tablespace for temporary tables

2022-06-27 15:23:43 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...

2022-06-27 15:23:43 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.

2022-06-27 15:23:43 0 [Note] InnoDB: 10.6.8 started; log sequence number 84663; transaction id 73

2022-06-27 15:23:43 0 [Note] Plugin 'FEEDBACK' is disabled.

2022-06-27 15:23:43 server_audit: MariaDB Audit Plugin version 2.4.1 STARTED.

2022-06-27 15:23:43 server_audit: Query cache is enabled with the TABLE events. Some table reads can be veiled.

2022-06-27 15:23:43 0 [Note] InnoDB: Loading buffer pool(s) from /mariadata/mysql/ib_buffer_pool

2022-06-27 15:23:43 0 [Note] Server socket created on IP: '0.0.0.0'.

2022-06-27 15:23:43 0 [Note] Server socket created on IP: '::'.

2022-06-27 15:23:43 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)

2022-06-27 15:23:43 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)

2022-06-27 15:23:43 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)

2022-06-27 15:23:43 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)

2022-06-27 15:23:43 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)

2022-06-27 15:23:43 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)

2022-06-27 15:23:43 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)

2022-06-27 15:23:43 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)

2022-06-27 15:23:43 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)

2022-06-27 15:23:43 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)

2022-06-27 15:23:43 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)

2022-06-27 15:23:43 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)

2022-06-27 15:23:43 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)

2022-06-27 15:23:43 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)

2022-06-27 15:23:43 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)

2022-06-27 15:23:43 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)

2022-06-27 15:23:43 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)

2022-06-27 15:23:43 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)

2022-06-27 15:23:43 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)

2022-06-27 15:23:43 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)

2022-06-27 15:23:43 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)

2022-06-27 15:23:43 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)

2022-06-27 15:23:43 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)

2022-06-27 15:23:43 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)

2022-06-27 15:23:43 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)

2022-06-27 15:23:43 0 [ERROR] Can't open shared library 'libregr_mysql.so' (errno: 0, cannot open shared object file: No such file or directory)

2022-06-27 15:23:43 0 [ERROR] Can't open shared library 'libregr_mysql.so' (errno: 0, cannot open shared object file: No such file or directory)

2022-06-27 15:23:43 0 [ERROR] Can't open shared library 'libregr_mysql.so' (errno: 0, cannot open shared object file: No such file or directory)

2022-06-27 15:23:43 0 [ERROR] Can't open shared library 'libregr_mysql.so' (errno: 0, cannot open shared object file: No such file or directory)

2022-06-27 15:23:43 0 [ERROR] Can't open shared library 'libregr_mysql.so' (errno: 0, cannot open shared object file: No such file or directory)

2022-06-27 15:23:43 0 [ERROR] Can't open shared library 'libregr_mysql.so' (errno: 0, cannot open shared object file: No such file or directory)

2022-06-27 15:23:43 0 [ERROR] Can't open shared library 'libregr_mysql.so' (errno: 0, cannot open shared object file: No such file or directory)

2022-06-27 15:23:43 0 [ERROR] Can't open shared library 'libregr_mysql.so' (errno: 0, cannot open shared object file: No such file or directory)

2022-06-27 15:23:43 0 [ERROR] Can't open shared library 'libregr_mysql.so' (errno: 0, cannot open shared object file: No such file or directory)

2022-06-27 15:23:43 0 [ERROR] Can't open shared library 'libregr_mysql.so' (errno: 0, cannot open shared object file: No such file or directory)

2022-06-27 15:23:43 0 [ERROR] Can't open shared library 'libregr_mysql.so' (errno: 0, cannot open shared object file: No such file or directory)

2022-06-27 15:23:43 0 [ERROR] Can't open shared library 'libregr_mysql.so' (errno: 0, cannot open shared object file: No such file or directory)

2022-06-27 15:23:43 0 [ERROR] Can't open shared library 'libudf_mysql.so' (errno: 0, cannot open shared object file: No such file or directory)

2022-06-27 15:23:43 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)

2022-06-27 15:23:43 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)

2022-06-27 15:23:43 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)

2022-06-27 15:23:43 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)

2022-06-27 15:23:43 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)

2022-06-27 15:23:43 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)

2022-06-27 15:23:43 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)

2022-06-27 15:23:43 0 [ERROR] Can't open shared library 'ha_columnstore.so' (errno: 0, cannot open shared object file: No such file or directory)

2022-06-27 15:23:43 0 [ERROR] Can't open shared library 'libregr_mysql.so' (errno: 0, cannot open shared object file: No such file or directory)

2022-06-27 15:23:43 0 [ERROR] Incorrect definition of table mysql.event: expected column 'definer' at position 3 to have type varchar(, found type char(141).

2022-06-27 15:23:43 0 [ERROR] mariadbd: Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.

2022-06-27 15:23:44 0 [Note] InnoDB: Buffer pool(s) load completed at 220627 15:23:44

2022-06-27 15:23:44 0 [Note] /usr/sbin/mariadbd: ready for connections.

Version: '10.6.8-4-MariaDB-enterprise'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Enterprise Server

Comment by Susmeet Khaire [ 2022-06-27 ]

Found the resolution.
This can be closed.

The error was duee to columnstore remains in the following system table mysql.func.
Once the table is truncated and mariadb is restarted, the error no longer pops up.

MariaDB [mysql]> SELECT * FROM func;

+-----------------------------+-----+-------------------+-----------+

| name                        | ret | dl                | type      |

+-----------------------------+-----+-------------------+-----------+

| calgetstats                 |   0 | ha_columnstore.so | function  |

| calsettrace                 |   2 | ha_columnstore.so | function  |

| calsetparms                 |   0 | ha_columnstore.so | function  |

| calflushcache               |   2 | ha_columnstore.so | function  |

| calgettrace                 |   0 | ha_columnstore.so | function  |

| calgetversion               |   0 | ha_columnstore.so | function  |

| calonlinealter              |   2 | ha_columnstore.so | function  |

| calviewtablelock            |   0 | ha_columnstore.so | function  |

| calcleartablelock           |   0 | ha_columnstore.so | function  |

| callastinsertid             |   2 | ha_columnstore.so | function  |

| calgetsqlcount              |   0 | ha_columnstore.so | function  |

| idbpm                       |   2 | ha_columnstore.so | function  |

| idbdbroot                   |   2 | ha_columnstore.so | function  |

| idbsegment                  |   2 | ha_columnstore.so | function  |

| idbsegmentdir               |   2 | ha_columnstore.so | function  |

| idbextentrelativerid        |   2 | ha_columnstore.so | function  |

| idbblockid                  |   2 | ha_columnstore.so | function  |

| idbextentid                 |   2 | ha_columnstore.so | function  |

| idbextentmin                |   0 | ha_columnstore.so | function  |

| idbextentmax                |   0 | ha_columnstore.so | function  |

| idbpartition                |   0 | ha_columnstore.so | function  |

| idblocalpm                  |   2 | ha_columnstore.so | function  |

| mcssystemready              |   2 | ha_columnstore.so | function  |

| mcssystemreadonly           |   2 | ha_columnstore.so | function  |

| mcssystemprimary            |   2 | ha_columnstore.so | function  |

| regr_avgx                   |   1 | libregr_mysql.so  | aggregate |

| regr_avgy                   |   1 | libregr_mysql.so  | aggregate |

| regr_count                  |   2 | libregr_mysql.so  | aggregate |

| regr_slope                  |   1 | libregr_mysql.so  | aggregate |

| regr_intercept              |   1 | libregr_mysql.so  | aggregate |

| regr_r2                     |   1 | libregr_mysql.so  | aggregate |

| corr                        |   1 | libregr_mysql.so  | aggregate |

| regr_sxx                    |   1 | libregr_mysql.so  | aggregate |

| regr_syy                    |   1 | libregr_mysql.so  | aggregate |

| regr_sxy                    |   1 | libregr_mysql.so  | aggregate |

| covar_pop                   |   1 | libregr_mysql.so  | aggregate |

| covar_samp                  |   1 | libregr_mysql.so  | aggregate |

| distinct_count              |   2 | libudf_mysql.so   | aggregate |

| caldisablepartitions        |   0 | ha_columnstore.so | function  |

| calenablepartitions         |   0 | ha_columnstore.so | function  |

| caldroppartitions           |   0 | ha_columnstore.so | function  |

| calshowpartitions           |   0 | ha_columnstore.so | function  |

| caldroppartitionsbyvalue    |   0 | ha_columnstore.so | function  |

| caldisablepartitionsbyvalue |   0 | ha_columnstore.so | function  |

| calenablepartitionsbyvalue  |   0 | ha_columnstore.so | function  |

| calshowpartitionsbyvalue    |   0 | ha_columnstore.so | function  |

| moda                        |   4 | libregr_mysql.so  | aggregate |

+-----------------------------+-----+-------------------+-----------+

47 rows in set (0.000 sec)

MariaDB [mysql]> TRUNCATE func;

Query OK, 0 rows affected (0.021 sec)

MariaDB [mysql]> SELECT * FROM func;

Empty set (0.001 sec)

MariaDB [mysql]> EXIT

Bye

[root@LAPTOP-15531O7Q ~]# systemctl restart mariadb

2022-06-27 15:46:52 0 [Note] InnoDB: Compressed tables use zlib 1.2.7

2022-06-27 15:46:52 0 [Note] InnoDB: Number of pools: 1

2022-06-27 15:46:52 0 [Note] InnoDB: Using SSE4.2 crc32 instructions

2022-06-27 15:46:52 0 [Note] InnoDB: Using Linux native AIO

2022-06-27 15:46:52 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728

2022-06-27 15:46:52 0 [Note] InnoDB: Completed initialization of buffer pool

2022-06-27 15:46:52 0 [Note] InnoDB: 128 rollback segments are active.

2022-06-27 15:46:52 0 [Note] InnoDB: Creating shared tablespace for temporary tables

2022-06-27 15:46:52 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...

2022-06-27 15:46:52 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.

2022-06-27 15:46:52 0 [Note] InnoDB: 10.6.8 started; log sequence number 86040; transaction id 73

2022-06-27 15:46:52 0 [Note] Plugin 'FEEDBACK' is disabled.

2022-06-27 15:46:52 server_audit: MariaDB Audit Plugin version 2.4.1 STARTED.

2022-06-27 15:46:52 server_audit: Query cache is enabled with the TABLE events. Some table reads can be veiled.

2022-06-27 15:46:52 0 [Note] InnoDB: Loading buffer pool(s) from /backup/ib_buffer_pool

2022-06-27 15:46:52 0 [Note] Server socket created on IP: '0.0.0.0'.

2022-06-27 15:46:52 0 [Note] Server socket created on IP: '::'.

2022-06-27 15:46:52 0 [Note] InnoDB: Buffer pool(s) load completed at 220627 15:46:52

2022-06-27 15:46:52 0 [ERROR] Incorrect definition of table mysql.event: expected column 'definer' at position 3 to have type varchar(, found type char(141).

2022-06-27 15:46:52 0 [ERROR] mariadbd: Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.

2022-06-27 15:46:52 0 [Note] /usr/sbin/mariadbd: ready for connections.

Version: '10.6.8-4-MariaDB-enterprise'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Enterprise Server

Comment by Todd Stoffel (Inactive) [ 2022-06-27 ]

Work Around:

MariaDB [none]> TRUNCATE mysql.func;

Comment by Daniel Lee (Inactive) [ 2022-06-27 ]

Build tested: 6.4.1-1 (#4661)

Release 1.4.4 is a very old version. Installation method has been improved in the current release. The mcsadmin tool is no longer available.

Test scenario:

1. query mysql.func table
2. stop mariadb mariadb-columnstore
3. rpm -e ColumnStore RPM package
4. start mariadb

After installation, the mysql.func table has 49 rows.

1. In VM
After uninstalling ColumnStore and starting MariaDB, mysql.func still has 49 rows. Any time MariaDB is started, the /var/log/messages file contains the report error messages.

After truncating mysql.func, restarting MariaDB no longer causing the reported errors.

2. In docker container
After uninstalling ColumnStore and starting MariaDB, mysql.func has 0 rows. /var/log/messages did not have the reported errors.

Comment by Leonid Fedorov [ 2023-10-27 ]

the version of Columnstore listed in here is not supported anymore

Generated at Thu Feb 08 02:55:42 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.