Details
Major Description
Mariadb columnstore System is given in ACTIVE Status nevertheless many cs processes are not active and sql returns internal errors
expected : mcsadmin getsystemstatus returns ACTIVE Status for columnstore System
when all cs functionality is active , respectively the expected mcs processes on columnstore Modules are Active.
how to repeat :
Problem was observed in 1UM-2PMs cs installation with enabled local query .System was functional , then reboot the UM module ;
check the MariaDB columnstore status with the mcsadmin utility – it's returned Active
but when it was performed from the UM even simple math sql statement or try to create table with engine columnstore are returned Errors
[root@cps ~]# mcsadmin getsystemstatus
|
|
|
WARNING: running on non Parent OAM Module, can't make configuration changes in this session.
|
Access Console from 'pm1' if you need to make changes.
|
|
|
getsystemstatus Wed Apr 24 12:40:42 2019
|
|
|
System columnstore-1
|
|
|
System and Module statuses
|
|
|
Component Status Last Status Change
|
------------ -------------------------- ------------------------
|
System ACTIVE Wed Apr 24 12:19:19 2019
|
|
|
Module um1 ACTIVE Wed Apr 24 12:19:19 2019
|
Module pm1 ACTIVE Wed Apr 24 12:19:19 2019
|
Module pm2 ACTIVE Wed Apr 24 12:19:20 2019
|
|
|
Active Parent OAM Performance Module is 'pm1'
|
Local Query Feature is enabled
|
MariaDB ColumnStore Replication Feature is enabled
|
MariaDB ColumnStore set for Distributed Install
|
|
|
|
MariaDB [(none)]> select 16200 * 8 ;
|
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'infinidb_vtable'
|
|
MariaDB [(none)]> create table a1.a1 ( a int) engine columnstore ;
|
ERROR 1815 (HY000): Internal error: Lost connection to DDLProc
|
|
get detailed information with mcsadmin about the system status
it's seen that those are many cs processes in AUTO_OFFLINE state but the entire system status is wrongly considered Active
[root@cps ~]# mcsadmin getsystemi;
|
|
|
WARNING: running on non Parent OAM Module, can't make configuration changes in this session.
|
Access Console from 'pm1' if you need to make changes.
|
|
|
getsysteminfo Wed Apr 24 12:39:08 2019
|
|
|
System columnstore-1
|
|
|
System and Module statuses
|
|
|
Component Status Last Status Change
|
------------ -------------------------- ------------------------
|
System ACTIVE Wed Apr 24 12:19:19 2019
|
|
|
Module um1 ACTIVE Wed Apr 24 12:19:19 2019
|
Module pm1 ACTIVE Wed Apr 24 12:19:19 2019
|
Module pm2 ACTIVE Wed Apr 24 12:19:20 2019
|
|
|
Active Parent OAM Performance Module is 'pm1'
|
Local Query Feature is enabled
|
MariaDB ColumnStore Replication Feature is enabled
|
MariaDB ColumnStore set for Distributed Install
|
|
|
|
|
MariaDB ColumnStore Process statuses
|
|
|
Process Module Status Last Status Change Process ID
|
------------------ ------ --------------- ------------------------ ----------
|
ProcessMonitor um1 ACTIVE Wed Apr 24 12:18:20 2019 5836
|
ServerMonitor um1 AUTO_OFFLINE Wed Apr 24 12:16:04 2019
|
DBRMWorkerNode um1 ACTIVE Wed Apr 24 12:18:36 2019 6090
|
ExeMgr um1 ACTIVE Wed Apr 24 12:19:07 2019 6313
|
DDLProc um1 AUTO_OFFLINE Wed Apr 24 12:16:04 2019
|
DMLProc um1 AUTO_OFFLINE Wed Apr 24 12:16:04 2019
|
mysqld um1 ACTIVE Wed Apr 24 12:19:19 2019 6571
|
|
|
ProcessMonitor pm1 ACTIVE Mon Apr 22 13:10:43 2019 18256
|
ProcessManager pm1 ACTIVE Mon Apr 22 13:10:49 2019 18399
|
DBRMControllerNode pm1 ACTIVE Wed Apr 24 12:18:33 2019 753
|
ServerMonitor pm1 ACTIVE Mon Apr 22 13:11:44 2019 20176
|
DBRMWorkerNode pm1 ACTIVE Wed Apr 24 12:18:40 2019 923
|
PrimProc pm1 ACTIVE Wed Apr 24 12:18:49 2019 1063
|
ExeMgr pm1 MAN_OFFLINE Wed Apr 24 12:13:42 2019
|
WriteEngineServer pm1 ACTIVE Wed Apr 24 12:19:02 2019 1324
|
mysqld pm1 ACTIVE Wed Apr 24 12:19:19 2019 1770
|
|
|
ProcessMonitor pm2 ACTIVE Mon Apr 22 13:11:35 2019 28401
|
ProcessManager pm2 HOT_STANDBY Mon Apr 22 13:11:36 2019 28515
|
DBRMControllerNode pm2 COLD_STANDBY Wed Apr 24 12:18:32 2019
|
ServerMonitor pm2 ACTIVE Mon Apr 22 13:11:53 2019 28902
|
DBRMWorkerNode pm2 ACTIVE Wed Apr 24 12:18:45 2019 25533
|
PrimProc pm2 ACTIVE Wed Apr 24 12:18:53 2019 25619
|
ExeMgr pm2 MAN_OFFLINE Wed Apr 24 12:13:42 2019
|
WriteEngineServer pm2 ACTIVE Wed Apr 24 12:19:03 2019 25747
|
mysqld pm2 ACTIVE Wed Apr 24 12:19:20 2019 26074
|
|
|
Active Alarm Counts: Critical = 0, Major = 3, Minor = 2, Warning = 0, Info = 0
|
|
|
|