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

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Trivial
Resolution: Fixed
Affects Version/s: 1.4.4
Fix Version/s: 23.10.0
Component/s: N/A
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

Attachments

Activity

People

Assignee:: Leonid Fedorov

Reporter:: Susmeet Khaire

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2022-06-27 01:51

Updated:: 2024-02-21 13:28

Resolved:: 2023-10-27 16:48

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.