On Aug 29, 2008, at 3:06 PM, ries van Twisk wrote:

>
> On Aug 29, 2008, at 2:57 PM, ries van Twisk wrote:
>
>> Hey all,
>>
>> this is my first mail on this list and have a question about  
>> merging sets
>>
>> When I execute this command to slonik : merge set (id=1, add id =  
>> 999, origin=1);
>>
>> I set the set perfectly merged to my master DB, but in my slave DB  
>> I don't see
>> the set merged. Is this correct or should I execute the merge set  
>> command for each
>> slave node?
>>
>> This is on slony 2.0 RC1
>>
>>
>> Also in the file slon_watchdog I noticed a semi-colon was missing  
>> on line 47...
>>
>> thanks,
>>
>> Ries
>>
>
>
>
> TO add more info, I get this in my log...
>
> 2008-08-29 15:02:34 COT DEBUG2 remoteListenThread_1: queue event  
> 1,133 STORE_SET
> 2008-08-29 15:02:34 COT DEBUG2 remoteListenThread_1: queue event  
> 1,134 SET_ADD_TABLE
> 2008-08-29 15:02:34 COT DEBUG2 remoteListenThread_1: queue event  
> 1,135 SUBSCRIBE_SET
> 2008-08-29 15:02:34 COT DEBUG2 remoteListenThread_1: queue event  
> 1,136 ENABLE_SUBSCRIPTION
> 2008-08-29 15:02:34 COT DEBUG2 remoteListenThread_1: queue event  
> 1,137 SYNC
> 2008-08-29 15:02:34 COT DEBUG1 subscriber_1_provider_1  
> "host=127.0.0.1 dbname=ace user=postgres port=5432": backend pid =  
> 2331
> 2008-08-29 15:02:34 COT DEBUG2 remoteListenThread_1: queue event  
> 1,138 SYNC
> 2008-08-29 15:02:34 COT DEBUG2 remoteListenThread_1: queue event  
> 1,139 SYNC
> 2008-08-29 15:02:34 COT DEBUG1 remoteWorkerThread_1: connected to  
> data provider 1 on 'host=127.0.0.1 dbname=ace user=postgres port=5432'
> 2008-08-29 15:02:34 COT INFO   remoteWorkerThread_1: syncing set 1  
> with 1 table(s) from provider 1
> 2008-08-29 15:02:34 COT DEBUG2  ssy_action_list length: 0
> 2008-08-29 15:02:34 COT INFO   remoteWorkerThread_1: syncing set 999  
> with 1 table(s) from provider 1
> 2008-08-29 15:02:35 COT DEBUG2 syncThread: new sl_action_seq 1 -  
> SYNC 87
> slon(2324,0xb0185000) malloc: *** mmap(size=2147483648) failed  
> (error code=12)
> *** error: can't allocate region
> *** set a breakpoint in malloc_error_break to debug
> 2008-08-29 15:02:36 COT DEBUG2 slon: child terminated status: 11;  
> pid: 2324, current worker pid: 2324
> 2008-08-29 15:02:36 COT DEBUG1 slon: restart of worker in 10 seconds
>
> Apparently my slon daemon on my slave node dies (I got the log from  
> node2)
>
> This is on OSX leopard 64 bit. I can try CSV version of slony....
>
>
> Ries



To answer my own question,
my problem was this bugs entry : http://bugs.slony.info/bugzilla/show_bug.cgi?id=53



			regards, Ries van Twisk


-------------------------------------------------------------------------------------------------
Ries van Twisk
email: ries at vantwisk.nl
email:ries.vantwisk at bmkllc.com
blog:   http://www.vantwisk.nl/
skype: callto://r.vantwisk
Phone:+593 2 2237444