Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-4763

CMAPI status shows wrong node as master/mismatch with maxscale (failover related)(on prem)

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Not a Bug
    • 5.5.2, 6.1.1
    • None
    • cmapi
    • 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

        1. screenshot-1.png
          194 kB
          Allen Herrera
        2. screenshot-2.png
          105 kB
          Allen Herrera

        Issue Links

          Activity

            People

              alan.mologorsky Alan Mologorsky
              allen.lee@mariadb.com Allen Lee (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              9 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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