citus_update_node doesn't work for non-primary nodes

[Timur Luchkin]

Hello, 

I can't change secondary node's address with citus_update_node due to "ERROR:  node X not found" . 

Sample data:

 nodeid | groupid |   nodename   | nodeport | noderack | hasmetadata | isactive | noderole  | nodecluster  
--------+---------+--------------+----------+----------+-------------+----------+-----------+--------------
      1 |       0 | 192.1.14.80  |     5454 | default  | t           | t        | primary   | default      
      2 |      11 | 192.1.14.90  |     5454 | default  | t           | t        | primary   | default      
      3 |      12 | 192.1.14.92  |     5454 | default  | t           | t        | primary   | default      
      4 |      11 | 192.1.214.90 |     5454 | default  | f           | t        | secondary | reporting
      5 |      12 | 192.1.214.92 |     5454 | default  | f           | t        | secondary | reporting 

Query:

SELECT * FROM citus_update_node(5, '192.1.114.92', 5454);
ERROR:  node 5 not found
SELECT * FROM citus_update_node(4, '192.1.114.92', 5454);
ERROR:  node 4 not found

N.B.:

Primary nodes  updates are OK. 

[Timur Luchkin]

Citus 11.1-1 on PG14.6

[Gokhan Gulbiz]

Thank you for reaching out to us regarding the issue you have encountered with citus_update_node. It is a known bug and has been fixed in the current version (Citus 11.2). We recommend updating to the latest version to ensure that this issue is resolved. The fix for this issue can be found in the following commit: https://github.com/citusdata/citus/commit/402a30a2b7f7a9afdb2765254f20e77b0d4ddd4e

Thanks,

Gokhan

[Timur Luchkin]

10x! it helped