citusdata / citusdata/citus

DROP PUBLICATION not working for worker

Open
#7,921 0 comments 0 reactions 0 assignees View on GitHub
under-evaluation
Dominant language
C
Stars
12.8k
Forks
794
Avg merge
2d 14h
Merged PRs (30d)
31

Description

I have three node setup. 1 coordinator and 2-workers. I am using replication slot from quite some time. It was working fine. But after updating to 13.0.1 i face this issue for first time.

First time i tried to delete publication "DROP PUBLICATION xyz" it was deleted from coordinator and worker 2. But on worker 1, it was not delete.

When i rerun the drop command again, it is showing publication does not exists.

When i run the create publication, it is showing publication exists on worker 1.

I also tried to do run_command_on_workers and tried to drop replication on only workers.. But when i changed the log it shows as below, while i am running the command on coordinator itself.

LOG: statement: SET application_name TO 'citus_run_command gpid=10000143177'
LOG: statement: DROP PUBLICATION xyz_pub;
ERROR: operation is not allowed on this node
HINT: Connect to the coordinator and run it again.
STATEMENT: DROP PUBLICATION xyz_pub;

Is there any way i can directly delete the publication?

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.