I installed Slony-I version 1.2.0 about two weeks ago. I initialized  
the Slony-I cluster and created set 1 on the "master" node. I then  
read recommendations on the list to hold off until 1.2.1 is released,  
because of a bug, which would stop replication. Before starting the  
slon processes or subscribing node 2 to the set, I decided to hold  
off. Yesterday, I upgraded to 1.2.1RC1. When I tried to start the  
slon process, the following error was logged:

2006-11-09 21:37:47 GMT CONFIG main: slon version 1.2.1 starting up
2006-11-09 21:37:47 GMT DEBUG2 slon: watchdog process started
2006-11-09 21:37:47 GMT DEBUG2 slon: watchdog ready - pid = 11520
2006-11-09 21:37:47 GMT DEBUG2 slon: worker process created - pid =  
11521
2006-11-09 21:37:47 GMT ERROR  Slony-I schema version is 1.2.0
2006-11-09 21:37:47 GMT ERROR  please upgrade Slony-I schema to  
version 1.2.1
2006-11-09 21:37:47 GMT FATAL  main: Node has wrong Slony-I schema or  
module version loaded
2006-11-09 21:37:47 GMT DEBUG2 slon_abort() from pid=11521
2006-11-09 21:37:47 GMT DEBUG1 slon: shutdown requested
2006-11-09 21:37:47 GMT DEBUG2 slon: notify worker process to shutdown
2006-11-09 21:37:47 GMT DEBUG2 slon: child terminated status: 0; pid:  
11521, current worker pid: 11521
2006-11-09 21:37:47 GMT DEBUG1 slon: done
2006-11-09 21:37:47 GMT DEBUG2 slon: remove pid file
2006-11-09 21:37:47 GMT DEBUG2 slon: exit(0)

I ran the slonik command to update the functions on the nodes. The  
proper preamble was in the script, including the cluster name and db  
connection info, as well as both update function calls for both  
nodes. The slonik command ran without returning any standard or error  
output. I then tried to start slon and the same error as above was  
logged again.

To determine if slonik was connecting to the databases when running  
slonik to update the functions, I ran a while loop in a shell logging  
any processes connecting to the database. I noticed a connection  
coming in as a result of the slonik command with SELECT..., CREATE  
FUNCTION..., CREATE VIEW..., COMMENT..., startup... (not necessarily  
in that order) sql queries being logged. There may have been more  
commands executed; this was all the while loop was able to catch. The  
query info. was captured using ps auxww, so I'm not sure what the  
full query was.

I'm not sure if the CREATE FUNCTION should be a CREATE OR REPLACE  
FUNCTION, or if there is some other issue in upgrading the 1.2.0  
schema to 1.2.1RC1.

I thought that perhaps the Slony-I libraries weren't properly  
replaced during the install of 1.2.1RC1. Doing a diff of the  
slony1_funcs.so and xxid.so between the install directory and the  
1.2.1 source directory shows they are the same. slonik -v shows  
version 1.2.1. The 1.2.1RC1 install went through okay.

I've read through the documentation, including the upgrade process.  
I'm not sure what I'm missing.

Any assistance would be greatly appreciated.

Sincerely,

Brian Wipf
<brian at clickspace.com>