Tue Apr 28 03:20:34 PDT 2009
- Previous message: [Slony1-general] [Slony 2.0.1] Events and Confirmations not propagating
- Next message: [Slony1-general] [Slony 2.0.1] Events and Confirmations not propagating
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
A simple restart of all slon processes seems to have resolved the issue. weird .... Cyril Scetbon wrote: > I use test_slony_state and see some informations like : > > Check of event info > --------------------------------------------------- > Problem : Events not propagating to node 2 > Problem : Events not propagating to node 4 > Problem : Events not propagating to node 3 > > Check of sl_confirm aging > --------------------------------------------------- > Confirmations not propagating from 2 to 1 > Confirmations not propagating from 2 to 3 > Confirmations not propagating from 2 to 4 > Confirmations not propagating from 3 to 1 > Confirmations not propagating from 3 to 2 > Confirmations not propagating from 3 to 4 > Confirmations not propagating from 4 to 1 > Confirmations not propagating from 4 to 2 > Confirmations not propagating from 4 to 3 > > You can see the results on one of my databases : > > - for Confirmations > > select con_origin, con_received, min(con_seqno) as minseq, > max(con_seqno) as maxseq, date_trunc('minutes', > min(now()-con_timestamp)) as age1, date_trunc('minutes', > max(now()-con_timestamp)) as age2, min(now() - con_timestamp) > > '00:30:00' as tooold from _pns_slony_voila_archi_0.sl_confirm group by > con_origin, con_received order by con_origin, con_received; > con_origin | con_received | minseq | maxseq | age1 | age2 | > tooold > ------------+--------------+---------+---------+----------+----------+-------- > > 101 | 102 | 4464029 | 4464792 | 00:00:00 | 00:16:00 | f > 101 | 103 | 4464027 | 4464792 | 00:00:00 | 00:16:00 | f > 101 | 104 | 4464024 | 4464792 | 00:00:00 | 00:16:00 | f > 102 | 101 | 29 | 29 | 03:39:00 | 03:39:00 | t > 102 | 103 | 29 | 29 | 03:39:00 | 03:39:00 | t > 102 | 104 | 29 | 29 | 03:39:00 | 03:39:00 | t > 103 | 101 | 62 | 62 | 03:39:00 | 03:39:00 | t > 103 | 102 | 62 | 62 | 03:39:00 | 03:39:00 | t > 103 | 104 | 62 | 62 | 03:39:00 | 03:39:00 | t > 104 | 101 | 57 | 57 | 03:39:00 | 03:39:00 | t > 104 | 102 | 57 | 57 | 03:39:00 | 03:39:00 | t > 104 | 103 | 57 | 57 | 03:39:00 | 03:39:00 | t > > > - for Events > > select ev_origin, min(ev_seqno), max(ev_seqno), > date_trunc('minutes', min(now() - ev_timestamp)), > date_trunc('minutes', max(now() - ev_timestamp)), > min(now() - ev_timestamp) > '00:30:00' as agehi > from _pns_slony_voila_archi_0.sl_event group by ev_origin; > ev_origin | min | max | date_trunc | date_trunc | agehi > -----------+---------+---------+------------+------------+------- > 103 | 62 | 62 | 03:49:00 | 03:49:00 | t > 104 | 57 | 57 | 03:49:00 | 03:49:00 | t > 102 | 29 | 29 | 03:49:00 | 03:49:00 | t > 101 | 4464493 | 4465346 | 00:00:00 | 00:14:00 | f > > > What can be the source of these errors and how to track them ? FYI, I > have logs but in debug level 1. > > I did not have issues in 1.2.15. > > Regards. -- Cyril SCETBON
- Previous message: [Slony1-general] [Slony 2.0.1] Events and Confirmations not propagating
- Next message: [Slony1-general] [Slony 2.0.1] Events and Confirmations not propagating
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list