[GOLDILOCKS] ERR-HY000(56001): location information of member 'G1N3' does not exist

원인

---

X$CLUSTER_LOCATION 에서 해당 멤버의 정보가 없는 경우 발생합니다.

gSQL> select * from x$cluster_location@local;

MEMBER_NAME HOST          PORT
----------- ------------ -----
G1N1        192.168.0.50 10000
G2N1        192.168.0.50 20000

2 rows selected.

gSQL> alter cluster location g1n3 host '192.168.0.50' port 10000;
ERR-HY000(56001): location information of member 'G1N3' does not exist :

해결방안

---

[방안 1] X$CLUSTER_LOCATION 에서 조회되는 멤버에 대해서 구문을 수행합니다.

gSQL> alter cluster location g1n1 host '192.168.0.50' port 10000;