citusdata / citusdata/citus

Invocation of master_add_node() fails if citus wasn't created on a worker beforehand

Open
#3,879 9 comments 0 reactions 0 assignees View on GitHub
usability
Dominant language
C
Stars
12.8k
Forks
794
Avg merge
2d 14h
Merged PRs (30d)
31

Description

### Description
Before `9.3.0` we used the following script to create a new database on an existing server:
```sql
CREATE DATABASE ;
SELECT run_command_on_workers($cmd$ CREATE DATABASE ; $cmd$);
\c
CREATE EXTENSION citus;
SELECT master_add_node('worker_1_ip', 5432);
SELECT master_add_node('worker_2_ip', 5432);
SELECT run_command_on_workers($cmd$ CREATE EXTENSION citus; $cmd$);
```

### Expected behavior
Database is created

### Actual behavior
With `9.3.0` `master_add_node` fails with
```
WARNING: function assign_distributed_transaction_id(integer, integer, unknown) does not exist
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
```

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.