Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Not a Bug
-
5.5.2, 6.1.1
-
None
-
2021-9, 2021-10, 2021-11, 2021-12, 2021-13, 2021-14, 2021-15, 2021-16, 2021-17, 2022-22, 2022-23, 2023-4, 2023-5, 2023-6, 2023-7
Description
CMAPI status shows node1 as master, but maxcale shows node 3 as master. Restarting CMAPI/maxsclae didn't help.
- CMAPI status;
$ curl -k -s https://mcs01:8640/cmapi/0.4.0/cluster/status \
> --header 'Content-Type:application/json' \
> --header 'x-api-key:xxxxxxxxxxxxxxxxxxxxxxx' \
> | jq .
{
"timestamp": "2021-06-16 13:21:45.236436",
"xxx.xxx.xxx.235": {
"timestamp": "2021-06-16 13:21:45.256826",
"uptime": 101322,
"dbrm_mode": "master",
"cluster_mode": "readwrite",
"dbroots": [],
"module_id": 1,
"services": [
{
"name": "workernode",
"pid": 27105
},
{
"name": "controllernode",
"pid": 27115
},
{
"name": "PrimProc",
"pid": 27132
}
]
},
"xxx.xxx.xxx.91": {
"timestamp": "2021-06-16 13:21:46.309152",
"uptime": 101255,
"dbrm_mode": "slave",
"cluster_mode": "readonly",
"dbroots": [],
"module_id": 2,
"services": [
{
"name": "workernode",
"pid": 26382
}
]
},
"xxx.xxx.xxx.42": {
"timestamp": "2021-06-16 13:21:46.740908",
"uptime": 88802,
"dbrm_mode": "slave",
"cluster_mode": "readonly",
"dbroots": [],
"module_id": 3,
"services": [
{
"name": "workernode",
"pid": 16217
},
{
"name": "PrimProc",
"pid": 16238
},
{
"name": "ExeMgr",
"pid": 16271
},
{
"name": "WriteEngine",
"pid": 16289
}
]
},
"num_nodes": 3
}
- maxscale show monitors
{
"master": "mcs01",
"master_gtid_domain_id": 0,
"primary": null,
"server_info": [
{
"gtid_binlog_pos": "0-1-21893",
"gtid_current_pos": "0-1-21893",
"lock_held": null,
"master_group": null,
"name": "mcs01",
"read_only": false,
"server_id": 1,
"slave_connections": []
},
{
"gtid_binlog_pos": "0-1-21893",
"gtid_current_pos": "0-1-21893",
"lock_held": null,
"master_group": null,
"name": "mcs02",
"read_only": true,
"server_id": 2,
"slave_connections": [
{
"connection_name": "",
"gtid_io_pos": "0-1-21893",
"last_io_error": "",
"last_sql_error": "",
"master_host": "xxx.xxx.xxx.42",
"master_port": 3306,
"master_server_id": 1,
"seconds_behind_master": 0,
"slave_io_running": "Yes",
"slave_sql_running": "Yes"
}
]
},
Attachments
Issue Links
- relates to
-
MCOL-4848 MCS/CMAPI CLI tool to operate the cluster
- Closed
-
MCOL-4556 master detection not work properly in cmapi
- Closed
-
MCOL-4723 cmapi should do more consistency checks
- Open
- mentioned in
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...