Hi Glyn,

Yes I had stopped all the slons for every node but I did not DELETE FROM
"_Cluster1".sl_nodelock WHERE nl_nodeid = 1 AND nl_conncnt = 0;

Regards,
Granthana

On Tue, Oct 14, 2014 at 9:13 PM, Glyn Astill <glynastill at yahoo.co.uk> wrote:

>
> > From: Granthana Biswas <granthana.biswas at gmail.com>
> >To: "slony1-general at lists.slony.info" <slony1-general at lists.slony.info>
> >Sent: Tuesday, 14 October 2014, 11:15
> >Subject: [Slony1-general] Changing master node's IP & port
> >
> >
> >
> >Hi All,
> >
> >
> >I am trying to change the master node's IP and port
> >
> >After stopping the slon process, I ran store path as follows:
> >
> >store path (server = 1, client = 2, conninfo='host=new_ip dbname=$DB1
> user=$USER1 port=$PORT1');
> >store path (server = 1, client = 3, conninfo='host=new_ip dbname=$DB1
> user=$USER1 port=$PORT1');
> >
> >
> >But on trying to start slon process again after changing the node config,
> I got the following error:
> >
> >nohup /usr/bin/slon -d 2 -p /var/run/slony1/cl1node1.pid -f
> /home/postgres/slony_test/cl1_node1.conf >
> /home/postgres/slony_test/log/cl1node1.log 2>&1 &
> >[1] 5626
> >postgres at GB:~/slony_test$ 2014-10-14 13:09:13 IST ERROR:  duplicate key
> value violates unique constraint "sl_nodelock-pkey"
> >2014-10-14 13:09:13 IST DETAIL:  Key (nl_nodeid, nl_conncnt)=(1, 0)
> already exists.
> >2014-10-14
> 13:09:13 IST STATEMENT:  select "_Cluster1".cleanupNodelock(); insert
> into "_Cluster1".sl_nodelock values (    1, 0,
> "pg_catalog".pg_backend_pid());
> >
> >
>
> Hi Granthana,
>
> Are you sure you'd stopped all the slons?  A quick "ps aux | grep slon" on
> each machine where you have slons running should be enough to check.
>
> As long as you're positive you've stopped all the slon processes, you
> could clean up sl_nodelock by just doing DELETE FROM
> "_Cluster1".sl_nodelock WHERE nl_nodeid = 1 AND nl_conncnt = 0;
>
>
>
> >I even tried the drop path but it gives the following error:
> >
> >sh drop_path.sh
> >2014-10-14 13:52:06 IST ERROR:  Slony-I: Path cannot be dropped,
> subscription of set 1 needs it
> >2014-10-14 13:52:06 IST STATEMENT:  lock table "_Cluster1".sl_event_lock,
> "_Cluster1".sl_config_lock;select "_Cluster1".dropPath(1, 2);
> ><stdin>:8: PGRES_FATAL_ERROR lock table "_Cluster1".sl_event_lock,
> "_Cluster1".sl_config_lock;select "_Cluster1".dropPath(1, 2);  - ERROR:
> Slony-I: Path cannot be dropped, subscription of set 1 needs it
> >
> >
> >Did anyone face the same issue when trying to change ip of a node? In my
> case, I am trying to change IP of master node.
> >
> >
> >
> >Regards,
> >Granthana
> >_______________________________________________
> >Slony1-general mailing list
> >Slony1-general at lists.slony.info
> >http://lists.slony.info/mailman/listinfo/slony1-general
> >
> >
> >
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20141014/ef168339/attachment.htm