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     |

-- 
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157