DROP PUBLICATION not working for worker
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?