albert wrote:
> Hi Steve,

> 
>     This is very strange,  the error is saying that the big if/else
>     block in   remote_worker.c isn't matching the events even the event
>     name as printed in the above message looks okay.
> 
> 
> Well, that sounds interesting...
> 
> Here's part of the log messages from the slony process running against 
> the slave database during step 1, that is... when replication is setup 
> for the first time and data is moved across correctly. Note that the 
> above TODO: messages are also printed and then replication messages are 
> logged and data is moved correctly (My test inserts some random data 
> into the master database, sleeps for a while, then dumps both the slave 
> and master databases and they get diffed)

This TODO error isn't the cause of your issue, one of the 'if' 
statements should be an 'else if' but that is causing that log message 
but it isn't causing a problem other than that.

Which leads us back to why isn't your slave subscribing.

Are there any locks open in the database (at the point that you've 
resubscribed things and are waiting for stuff to replicate?)

select pg_locks.*, pg_class.relname FROM pg_locks, pg_class where 
pg_locks.relation=pg_class.oid;

or something similar can show you that.

Do you have any transactions that were started before you subscribed the 
set that haven't committed yet?





-- 
Steve Singer
Afilias Canada
Data Services Developer
416-673-1142