citusdata / citusdata/citus

"ERROR: operation is not allowed on this node" when creating custom type

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

Description

I am unable to create ENUM type after installing citus columnar extension on PostgreSQL 13.

```
CREATE TYPE company AS ENUM ('test1','test2')

ERROR: operation is not allowed on this node
Hint: Connect to the coordinator and run it again.
1 statement failed.
```
Citus version:
Citus 10.0.3 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 8.3.1 20190311 (Red Hat 8.3.1-3.2.0.1), 64-bit.

The error message states to connect to the coordinator, but coordinator and workers have not been configured since I only need columnar extension.
![error](https://user-images.githubusercontent.com/86044472/122352711-09989b80-cf58-11eb-9759-5064126d0904.PNG)

Contributor guide

Open the contributing guide

Research direction

Start by reproducing CREATE TYPE company AS ENUM after installing Citus 10.0.3 with PostgreSQL 13 and no coordinator or workers configured. Trace the handling of this statement and the coordinator-only error path; done means the issue's expected behavior or a precise limitation is established and covered by an appropriate regression test.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql, sql
Domain
databases, distributed-systems
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
30/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.