I'm replying to myself to give more information about my problem

2010/2/17 Laurent Raufaste <analogue at glop.org>:
> Hi,
>
> I have a cool Slony cluster with 12 PGs running for years.
> But I noticed some strange data in the origin's sl_confirm table:
>
> SELECT *
> FROM _ob2replication.sl_confirm
> WHERE con_seqno NOT IN (SELECT ev_seqno FROM _ob2replication.sl_event);
>          con_origin | con_received | con_seqno |       con_timestamp
> ------------+--------------+-----------+----------------------------
>         21 |           26 |   3277845 | 2009-09-26 15:01:12.61598
>         21 |           27 |   3277845 | 2009-10-22 15:13:26.370957
>         21 |           25 |   3277845 | 2009-09-26 14:54:16.162632
>         21 |            5 |   3277845 | 2009-10-22 15:13:26.669225
>
> On every server I have entries in the sl_confirm tables with events
> references which do not exist anymore.

Those entries should be cleaned up but the cleanupEvent() plpgsql
function, but they are not.

I launched a debugged version of the cleanupEvent() function and here
what I got:
ob2=# SELECT _ob2replication.mycleanup();
NOTICE:  DELETE FROM sl_confirm WHERE con_origin=21 AND con_received=2
AND con_seqno < 1060869
NOTICE:  DELETE FROM sl_confirm WHERE con_origin=21 AND con_received=5
AND con_seqno < 1060869
NOTICE:  DELETE FROM sl_confirm WHERE con_origin=21 AND
con_received=12 AND con_seqno < 1060869
NOTICE:  DELETE FROM sl_confirm WHERE con_origin=21 AND
con_received=16 AND con_seqno < 1060869
NOTICE:  DELETE FROM sl_confirm WHERE con_origin=21 AND
con_received=17 AND con_seqno < 1060869
NOTICE:  DELETE FROM sl_confirm WHERE con_origin=21 AND
con_received=22 AND con_seqno < 3277845
NOTICE:  DELETE FROM sl_confirm WHERE con_origin=21 AND
con_received=23 AND con_seqno < 1060928
NOTICE:  DELETE FROM sl_confirm WHERE con_origin=21 AND
con_received=24 AND con_seqno < 1060869
NOTICE:  DELETE FROM sl_confirm WHERE con_origin=21 AND
con_received=25 AND con_seqno < 3277845
NOTICE:  DELETE FROM sl_confirm WHERE con_origin=21 AND
con_received=26 AND con_seqno < 3277845
NOTICE:  DELETE FROM sl_confirm WHERE con_origin=21 AND
con_received=27 AND con_seqno < 3277845