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
