[MCOL-4799] CMAPI status does not show the full node list Created: 2021-07-06  Updated: 2021-07-09  Resolved: 2021-07-06

Status: Closed
Project: MariaDB ColumnStore
Component/s: N/A
Affects Version/s: 5.6.1
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Allen Lee (Inactive) Assignee: Unassigned
Resolution: Not a Bug Votes: 0
Labels: None

Attachments: JPEG File maxctrl_list_servers.jpg    

 Description   

During the investigation of other issue, I found that `maxctrl list servers` and CMAPI status showed the different number of node in CS cluster.

  • maxctrl list servers - 7 nodes
  • CMAPI stauts - 6 nodes.

    [root@linxpd-edw01:/var/log/mariadb/columnstore]$ mcsStatus
    {
    "timestamp": "2021-07-06 11:21:44.481064",
    "xx.xxx.x.25": {
    "timestamp": "2021-07-06 11:21:44.486641",
    "uptime": 72481,
    "dbrm_mode": "slave",
    "cluster_mode": "readonly",
    "dbroots": [],
    "module_id": 1,
    "services": [
    {
    "name": "workernode",
    "pid": 83961
    },
    {
    "name": "PrimProc",
    "pid": 83982
    },
    {
    "name": "ExeMgr",
    "pid": 84107
    },
    {
    "name": "WriteEngine",
    "pid": 84138
    }
    ]
    },
    "xx.xxx.x.175": {
    "timestamp": "2021-07-06 11:21:44.700611",
    "uptime": 72407,
    "dbrm_mode": "slave",
    "cluster_mode": "readonly",
    "dbroots": [],
    "module_id": 2,
    "services": [
    {
    "name": "workernode",
    "pid": 83613
    },
    {
    "name": "PrimProc",
    "pid": 83634
    },
    {
    "name": "ExeMgr",
    "pid": 83755
    },
    {
    "name": "WriteEngine",
    "pid": 83795
    }
    ]
    },
    "xx.xxx.x.92": {
    "timestamp": "2021-07-06 11:21:44.929609",
    "uptime": 72371,
    "dbrm_mode": "slave",
    "cluster_mode": "readonly",
    "dbroots": [],
    "module_id": 3,
    "services": [
    {
    "name": "workernode",
    "pid": 97966
    },
    {
    "name": "PrimProc",
    "pid": 97987
    },
    {
    "name": "ExeMgr",
    "pid": 98108
    },
    {
    "name": "WriteEngine",
    "pid": 98143
    }
    ]
    },
    "xx.xxx.x.96": {
    "timestamp": "2021-07-06 11:21:45.138439",
    "uptime": 72333,
    "dbrm_mode": "slave",
    "cluster_mode": "readonly",
    "dbroots": [],
    "module_id": 4,
    "services": [
    {
    "name": "workernode",
    "pid": 97504
    },
    {
    "name": "PrimProc",
    "pid": 97526
    },
    {
    "name": "ExeMgr",
    "pid": 97653
    },
    {
    "name": "WriteEngine",
    "pid": 97683
    }
    ]
    },
    "xx.xxx.x.98": {
    "timestamp": "2021-07-06 11:21:45.353221",
    "uptime": 72291,
    "dbrm_mode": "slave",
    "cluster_mode": "readonly",
    "dbroots": [],
    "module_id": 5,
    "services": [
    {
    "name": "workernode",
    "pid": 94545
    },
    {
    "name": "PrimProc",
    "pid": 94566
    },
    {
    "name": "ExeMgr",
    "pid": 94687
    },
    {
    "name": "WriteEngine",
    "pid": 94722
    }
    ]
    },
    "xx.xxx.x.204": {
    "timestamp": "2021-07-06 11:21:45.566837",
    "uptime": 72633,
    "dbrm_mode": "master",
    "cluster_mode": "readwrite",
    "dbroots": [],
    "module_id": 6,
    "services": [
    {
    "name": "workernode",
    "pid": 85260
    },
    {
    "name": "controllernode",
    "pid": 85270
    },
    {
    "name": "PrimProc",
    "pid": 85287
    },
    {
    "name": "ExeMgr",
    "pid": 85408
    },
    {
    "name": "WriteEngine",
    "pid": 85437
    },
    {
    "name": "DMLProc",
    "pid": 85446
    },
    {
    "name": "DDLProc",
    "pid": 85543
    }
    ]
    },
    "num_nodes": 6
    }
    
    

  • Correct total # of nodes is 7 Node.


 Comments   
Comment by Todd Stoffel (Inactive) [ 2021-07-06 ]

This is not a bug. Looks more like a misconfiguration. MaxScale and CMAPI do not share information.

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