Daniel Romero romero.cl at gmail.com
Fri Nov 14 08:18:21 PST 2008
Hi.

I have 3 nodes, 1 main and 2 direct replicas.

I can see my querys in the main node log, but node 2 and 3 are not receiving
any querys, only synch or "slony internal" querys.


Any ideas?


NODE 2 LOG EXAMPLE
LOG:  statement: start transaction;set transaction isolation level
serializable;select last_value from "_romeroCLT".sl_action_seq;
LOG:  statement: rollback transaction;
LOG:  statement: start transaction; set transaction isolation level
serializable;
LOG:  statement: select ev_seqno, ev_timestamp,        ev_minxid, ev_maxxid,
ev_xip,        ev_type,        ev_data1, ev_data2, ev_data3,
ev_data4,        ev_data5, ev_data6, ev_data7, ev_data8 from
"_romeroCLT".sl_event where  ev_origin =3D '2'        and ev_seqno > '33'
order by ev_seqno
LOG:  statement: commit transaction
LOG:  statement: start transaction; set transaction isolation level
serializable;
LOG:  statement: select ev_seqno, ev_timestamp,        ev_minxid, ev_maxxid,
ev_xip,        ev_type,        ev_data1, ev_data2, ev_data3,
ev_data4,        ev_data5, ev_data6, ev_data7, ev_data8 from
"_romeroCLT".sl_event where  ev_origin =3D '2'        and ev_seqno > '34'
order by ev_seqno
LOG:  statement: rollback transaction;
LOG:  statement: start transaction;set transaction isolation level
serializable;select last_value from "_romeroCLT".sl_action_seq;
LOG:  statement: rollback transaction;
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20081114/=
791aa750/attachment.htm


More information about the Slony1-general mailing list