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





-------------------------------------------------------------------------------------------------
A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?
A: Top-posting.
Q: What is the most annoying thing in e-mail?