citus icon indicating copy to clipboard operation
citus copied to clipboard

DROP PUBLICATION not working for worker

Open developer-espark opened this issue 9 months ago • 0 comments

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?

developer-espark avatar Mar 10 '25 07:03 developer-espark