Jan Wieck wrote:
> On 7/9/2010 9:21 AM, Steve Singer wrote:
>> Steve Singer wrote:
> 
> Me thinks this would possibly be a slightly too old sl_confirm, 
> resulting in the clone trying to apply events that the source had 
> already processed again.
> 
> This would very much depend on how the clone was actually created. 
> Assume you create a clone of node 2 as node 3. If there is a gap between 
> the prepare clone and when the actual copy is made, a running slon for 
> node 2 has time to process more events. IIRC it is the clone preparation 
> that creates the configuration copy including the content of sl_confirm.
> 
> Can you make sure that in your tests you stop the slon before doing the 
> clone prepare and restart it only after the pg_dump transaction for the 
> cloning has taken its snapshot?

I'm thinking that this was actually being caused by an issue in my test 
that was leaving an old version of the 'clone' database around from the 
previous run.  Since addressing that issue I've been unable to reproduce 
those duplicates in my log.

That doesn't really answer the question of do you need to stop the slons 
  in-between the CLONE PREPARE and taking the pg_dump.  If this is the 
case then we should update the documentation but I'm not yet convinced 
that this is the case.



> 
> 
> Jan
> 
>>
>>> The attached patch tries to fix bug # 120.
>>>
>>> As it is longer than a trivial patch someone else should look it over 
>>> before I apply it.
>>>
>>> Thanks
>>>
>>> http://github.com/ssinger/slony/commit/c36394565260d751a493abdfa2b61fb90f2912b3 
>>>
>>>
>>>
>>>
>>> ------------------------------------------------------------------------
>>>
>>> _______________________________________________
>>> Slony1-patches mailing list
>>> Slony1-patches at lists.slony.info
>>> http://lists.slony.info/mailman/listinfo/slony1-patches
>>
>>
>>
>>
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> Slony1-patches mailing list
>> Slony1-patches at lists.slony.info
>> http://lists.slony.info/mailman/listinfo/slony1-patches
> 
> 


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