[MCOL-4816] Ansible Script Errors on Deployment of MariaDB AX 5.5.2 Created: 2021-07-16  Updated: 2021-08-01  Resolved: 2021-07-21

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

Type: Bug Priority: Major
Reporter: Juan Assignee: Todd Stoffel (Inactive)
Resolution: Not a Bug Votes: 0
Labels: None


 Description   

Our devops team was able to run the new ansible script from https://github.com/mariadb-corporation/columnstore-ansible-aws to deploy 2 new columnstore 5.5.2 clusters, but recently during a 3rd deployment, we started receiving errors:

TASK [Starting Replicas] *************************************************************************************************************
changed: [mcs3] => {"changed": true, "msg": "Slave started ", "queries": ["START SLAVE"]}
changed: [mcs2] => {"changed": true, "msg": "Slave started ", "queries": ["START SLAVE"]}
PLAY [primary] ***********************************************************************************************************************
TASK [Gathering Facts] ***************************************************************************************************************
ok: [mcs1]
TASK [Adding Nodes To ColumnStore Cluster] *******************************************************************************************
failed: [mcs1] (item={'timeout': 180, 'node': 'ip-10-105-1-177.ec2.internal'}) => {"ansible_loop_var": "item", "changed": false, "connection": "close", "content": "{\"error\": {\"http_status\": \"404 Not Found\", \"message\": \"The path '/cmapi/0.4.0/cluster/add-node' was not found.\"}}                                                                                                                                                                                                                                                                                                                                                                                                                ", "content_length": "513", "content_type": "application/json", "date": "Thu, 15 Jul 2021 21:55:36 GMT", "elapsed": 0, "item": {"node": "ip-10-105-1-177.ec2.internal", "timeout": 180}, "json": {"error": {"http_status": "404 Not Found", "message": "The path '/cmapi/0.4.0/cluster/add-node' was not found."}}, "msg": "Status code was 404 and not [200]: HTTP Error 404: Not Found", "redirected": false, "server": "CherryPy/18.5.0", "status": 404, "url": "https://ip-10-105-1-177.ec2.internal:8640/cmapi/0.4.0/cluster/add-node"}
failed: [mcs1] (item={'timeout': 180, 'node': 'ip-10-105-1-178.ec2.internal'}) => {"ansible_loop_var": "item", "changed": false, "connection": "close", "content": "{\"error\": {\"http_status\": \"404 Not Found\", \"message\": \"The path '/cmapi/0.4.0/cluster/add-node' was not found.\"}}                                                                                                                                                                                                                                                                                                                                                                                                                ", "content_length": "513", "content_type": "application/json", "date": "Thu, 15 Jul 2021 21:55:40 GMT", "elapsed": 0, "item": {"node": "ip-10-105-1-178.ec2.internal", "timeout": 180}, "json": {"error": {"http_status": "404 Not Found", "message": "The path '/cmapi/0.4.0/cluster/add-node' was not found."}}, "msg": "Status code was 404 and not [200]: HTTP Error 404: Not Found", "redirected": false, "server": "CherryPy/18.5.0", "status": 404, "url": "https://ip-10-105-1-177.ec2.internal:8640/cmapi/0.4.0/cluster/add-node"}
failed: [mcs1] (item={'timeout': 180, 'node': 'ip-10-105-1-179.ec2.internal'}) => {"ansible_loop_var": "item", "changed": false, "connection": "close", "content": "{\"error\": {\"http_status\": \"404 Not Found\", \"message\": \"The path '/cmapi/0.4.0/cluster/add-node' was not found.\"}}                                                                                                                                                                                                                                                                                                                                                                                                                ", "content_length": "513", "content_type": "application/json", "date": "Thu, 15 Jul 2021 21:55:43 GMT", "elapsed": 0, "item": {"node": "ip-10-105-1-179.ec2.internal", "timeout": 180}, "json": {"error": {"http_status": "404 Not Found", "message": "The path '/cmapi/0.4.0/cluster/add-node' was not found."}}, "msg": "Status code was 404 and not [200]: HTTP Error 404: Not Found", "redirected": false, "server": "CherryPy/18.5.0", "status": 404, "url": "https://ip-10-105-1-177.ec2.internal:8640/cmapi/0.4.0/cluster/add-node"}
PLAY RECAP ***************************************************************************************************************************
mcs1                       : ok=74   changed=58   unreachable=0    failed=1    skipped=8    rescued=0    ignored=0   
mcs2                       : ok=51   changed=38   unreachable=0    failed=0    skipped=8    rescued=0    ignored=0   
mcs3                       : ok=51   changed=38   unreachable=0    failed=0    skipped=8    rescued=0    ignored=0   
mx1                        : ok=19   changed=12   unreachable=0    failed=0    skipped=4    rescued=0    ignored=0   
mx2                        : ok=19   changed=12   unreachable=0    failed=0    skipped=4    rescued=0    ignored=0 



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

This is likely due to a change on line 136 of the cluster.yml file

https://github.com/mariadb-corporation/columnstore-ansible-aws/blob/master/includes/cluster.yml#L136

The newer versions of CMAPI use an industry standard approach to PUT and DELETE

A work around for older releases is to change the text on line 136 to say add-node instead of node

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