Wed Apr 21 20:30:37 PDT 2010
- Previous message: [Slony1-general] [slony-general] error adding a table
- Next message: [Slony1-general] logswitch_finish( )
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
On 4/22/2010 12:35 AM, Jaime Casanova wrote: > On Wed, Apr 21, 2010 at 11:14 PM, Jaime Casanova > <jcasanov at systemguards.com.ec> wrote: >> On Wed, Apr 21, 2010 at 6:52 PM, Jan Wieck <JanWieck at yahoo.com> wrote: >>> On 4/21/2010 7:44 PM, Jaime Casanova wrote: >>>> >>>> On Wed, Apr 21, 2010 at 6:24 PM, Jan Wieck <JanWieck at yahoo.com> 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
- Previous message: [Slony1-general] [slony-general] error adding a table
- Next message: [Slony1-general] logswitch_finish( )
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list