I have a script to handle the ip change of a slave node. It kills all slon daemons, runs the store path command, then restarts all daemons with new details. 

I just ran it for a node with databases = 3 rep clusters. There is only one master and one slave currently.

For 2 of the 3 databases it worked fine. The sl_path updated correctly in both master and slave and the new daemons carried on replicating. For one database the new path was set in master but in slave sl_path shows the path for the master (unchanged) OK but the new slave path as <event pending>

The output for the new slon daemon for this node shows error that 'another slon daemon is already serving this node'. I have tried shutting down slon deamons for this cluster on both master and slave and restarting again but I always get this error. The master output looks fine, like its working. There were no slon daemons running for this cluster for this node, so where is slony getting confused?

Thanks,
Vicki Parsons

2005-07-29 11:55:59 BST CONFIG main: slon version 1.1.0 starting up
2005-07-29 11:55:59 BST CONFIG main: local node id = 2
2005-07-29 11:55:59 BST CONFIG main: launching sched_start_mainloop
2005-07-29 11:55:59 BST CONFIG main: loading current cluster configuration
2005-07-29 11:55:59 BST CONFIG storeNode: no_id=1 no_comment='SSS 10.112.0.102'
2005-07-29 11:55:59 BST CONFIG storePath: pa_server=1 pa_client=2 pa_conninfo="dbname=statusdb00e08161cbf0 host=10.112.0.102 user=postgres" pa_connretry=10
2005-07-29 11:55:59 BST CONFIG storeListen: li_origin=1 li_receiver=2 li_provider=1
2005-07-29 11:55:59 BST CONFIG storeSet: set_id=1 set_origin=2 set_comment='all status tables'
2005-07-29 11:55:59 BST CONFIG main: configuration complete - starting threads
2005-07-29 11:55:59 BST DEBUG1 localListenThread: thread starts
2005-07-29 11:55:59 BST FATAL localListenThread: Another slon daemon is serving this node already
2005-07-29 11:55:59 BST! DEBUG1 slon: shutdown requested




__________________________________________________

Victoria Parsons
Research & Development

StreamShield Networks

Tel	0870 114 9465
Fax	0870 114 9467




This message should be regarded as confidential. If you have received this email in error please notify the sender and destroy it immediately.
Statements of intent shall only become binding when confirmed in hard copy by an authorized signatory.


-- 
This message has been scanned for viruses and potentially
harmful content by StreamShield Protector.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://gborg.postgresql.org/pipermail/slony1-general/attachments/20050729/9c6067cf/attachment.html