citusdata / citusdata/citus

Trying to sync metadata to a read-replica throws meaningless error

Open
#5,085 0 comments 0 reactions 0 assignees View on GitHub
1-2 days error message mx
Dominant language
C
Stars
12.8k
Forks
794
Avg merge
2d 14h
Merged PRs (30d)
31

Description

```SQL
select start_metadata_sync_to_node('localhost', 5505);
ERROR: you cannot sync metadata to a non-existent node
HINT: First, add the node with SELECT master_add_node('localhost',5505)
Time: 0.453 ms

table pg_dist_node;
nodeid | groupid | nodename | nodeport | noderack | hasmetadata | isactive | noderole | nodecluster | metadatasynced | shouldhaveshards
--------+---------+-----------+----------+----------+-------------+----------+-----------+-------------+----------------+------------------
2 | 1 | localhost | 5506 | default | f | t | secondary | cluster_c | f | t
3 | 1 | localhost | 5505 | default | f | t | secondary | cluster_b | f | t
1 | 1 | localhost | 5504 | default | t | t | primary | default | t | t
(3 rows)
```

We should probably use `FindWorkerNodeAnyCluster` instead of `FindWorkerNode`

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.