Jan Wieck JanWieck at Yahoo.com
Wed Apr 21 20:30:37 PDT 2010
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



More information about the Slony1-general mailing list