On 4/22/2010 12:35 AM, Jaime Casanova wrote: > On Wed, Apr 21, 2010 at 11:14 PM, Jaime Casanova > <[email protected]> wrote: >> On Wed, Apr 21, 2010 at 6:52 PM, Jan Wieck <[email protected]> wrote: >>> On 4/21/2010 7:44 PM, Jaime Casanova wrote: >>>> >>>> On Wed, Apr 21, 2010 at 6:24 PM, Jan Wieck <[email protected]> wrote: >>>>> >>>>> On 4/21/2010 7:06 PM, Jaime Casanova wrote: >>>>>> >>>>>> >>>>>> any ideas on what look for the sl_log_x problem? >>>>> >>>>> What does sl_status look like on the origin? >>>>> >>>>> >>>> >>>> mic=# select * from _sncp_incop_cluster.sl_status ; >>>> -[ RECORD 1 ]---------------+--------------------------- >>>> st_origin | 1 >>>> st_received | 2 >>>> st_last_event | 843427 >>>> st_last_event_ts | 2010-04-21 18:42:18.671167 >>>> st_last_received | 786330 >>>> st_last_received_ts | 2010-04-20 16:04:58.747498 >>>> st_last_received_event_ts | 2010-04-20 02:26:44.601898 >>>> st_lag_num_events | 57097 >>>> st_lag_time | 1 day 16:15:35.203507 >>>> >>> >>> So who did the manual delete from sl_event on node 2? >>> >> > > ah! and this is the last received event (it is in both nodes) > > mic=# select * from _sncp_incop_cluster.sl_event where ev_seqno = 786330; > -[ RECORD 1 ]+--------------------------- > ev_origin | 1 > ev_seqno | 786330 > ev_timestamp | 2010-04-20 02:26:44.601898 > ev_minxid | 20748544 > ev_maxxid | 20748544 > ev_xip | > ev_type | SUBSCRIBE_SET > ev_data1 | 999 > ev_data2 | 1 > ev_data3 | 2 > ev_data4 | t > ev_data5 | > ev_data6 | > ev_data7 | > ev_data8 | > > > and this one the next (this is only on node 1) > > mic=# select * from _sncp_incop_cluster.sl_event where ev_seqno = 786331; > -[ RECORD 1 ]+--------------------------- > ev_origin | 1 > ev_seqno | 786331 > ev_timestamp | 2010-04-20 02:26:44.601898 > ev_minxid | 20748544 > ev_maxxid | 20748544 > ev_xip | > ev_type | ENABLE_SUBSCRIPTION > ev_data1 | 999 > ev_data2 | 1 > ev_data3 | 2 > ev_data4 | t > ev_data5 | > ev_data6 | > ev_data7 | > ev_data8 | >
And this event cannot be processed on the subscriber? Can I get a dump of the _sncp_incop_cluster schema on node 2? Jan -- Anyone who trades liberty for security deserves neither liberty nor security. -- Benjamin Franklin _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
