Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Do
-
None
-
None
-
GKE
Description
Columnstore System Status remains Active if mcs become not write capable
that issue was observed with DBAAS Columnstore SingleNode deployment
Columnstore System started to return Errors when try to insert data , but that problem is not
detected in mcsadmin System Status and any Alarms are not set
s$ mariadb --host=sky0001379.mdb0001293.test.skysql.net --port=5001 --user=DB00002091 --password='xxxxxx' --ssl=1 -e "create database abc ; create table abc.abc ( a int , b varchar(64)) engine columnstore ;")
|
|
|
$ mariadb --host=sky0001379.mdb0001293.test.skysql.net --port=5001 --user=DB00002091 --password='xxxxxxxx' --ssl=1 -e "insert into abc.abc values (1,'aa'),(2,'bbb'), (3,'cccc'); "
|
ERROR 1815 (HY000) at line 1: Internal error: CAL0001: Insert Failed: Error occured when calling makeJobList
|
from the Columnstore PM Pod : columnstore System is in Active Status , any Alarms are set
[root@expmcs0001-mdb-cs-single-0 /]# mcsadmin getsystemi
|
getsysteminfo Mon Jan 6 11:35:43 2020
|
|
|
System columnstore-1
|
|
|
System and Module statuses
|
|
|
Component Status Last Status Change
|
------------ -------------------------- ------------------------
|
System ACTIVE Thu Jan 2 12:48:21 2020
|
|
|
Module pm1 ACTIVE Thu Jan 2 11:32:54 2020
|
|
|
|
|
MariaDB ColumnStore Process statuses
|
|
|
Process Module Status Last Status Change Process ID
|
------------------ ------ --------------- ------------------------ ----------
|
ProcessMonitor pm1 ACTIVE Thu Jan 2 11:32:06 2020 101
|
ProcessManager pm1 ACTIVE Thu Jan 2 11:32:13 2020 208
|
StorageManager pm1 ACTIVE Thu Jan 2 12:07:18 2020 13702
|
DBRMControllerNode pm1 ACTIVE Thu Jan 2 12:47:59 2020 26541
|
ServerMonitor pm1 ACTIVE Thu Jan 2 11:32:35 2020 780
|
DBRMWorkerNode pm1 ACTIVE Thu Jan 2 11:32:36 2020 801
|
PrimProc pm1 ACTIVE Thu Jan 2 11:32:40 2020 891
|
ExeMgr pm1 ACTIVE Thu Jan 2 11:32:44 2020 962
|
WriteEngineServer pm1 ACTIVE Thu Jan 2 12:11:01 2020 16610
|
DDLProc pm1 ACTIVE Thu Jan 2 12:48:09 2020 26681
|
DMLProc pm1 ACTIVE Thu Jan 2 12:48:20 2020 26799
|
mysqld pm1 ACTIVE Thu Jan 2 11:32:14 2020 511
|
|
|
Active Alarm Counts: Critical = 0, Major = 0, Minor = 0, Warning = 0, Info = 0
|
Attachments
Issue Links
- relates to
-
MCOL-3459 think about data integrity (partial data problem)
-
- Closed
-