[Bucardo-general] syncrun table growing unbounded?

[Mitchell Perilstein]

Greetings,

We're using 4.99.7 with PG 9.1.5 and seeing the syncrun table growing 
without bound with old (ie, ended) records, eg:

    $ psql -Ubucardo bucardo -c 'select count(*) from syncrun'
    count
    --------
      969759
    (1 row)

    $ psql -Ubucardo bucardo -c 'select count(*) from syncrun where
    ended is null'
      count
    -------
          0
    (1 row)

    $ psql -Ubucardo bucardo -c 'select * from syncrun limit 4'
       sync   | truncates | deletes | inserts | conflicts |           
    started            |             ended | lastgood | lastbad |
    lastempty | details | status
    ---------+-----------+---------+---------+-----------+-------------------------------+-------------------------------+----------+---------+-----------+---------+--------------------------------
      o1_sync |         0 |     327 |     329 |         0 | 2013-05-13
    20:24:41.93723+00  | 2013-05-13 20:24:42.346393+00 | f        |
    f       | f         |         | Complete (KID 2372)
      o1_sync |         0 |       2 |       2 |         0 | 2013-05-13
    20:42:32.73663+00  | 2013-05-13 20:42:32.759243+00 | f        |
    f       | f         |         | Complete (KID 2372)
      lg_sync |         0 |       0 |       0 |         0 | 2013-05-13
    20:25:00.507449+00 | 2013-05-13 20:25:00.513536+00 | f        |
    f       | f         |         | No delta rows found (KID 2293)
      lg_sync |         0 |       1 |       1 |         0 | 2013-05-14
    00:47:02.276394+00 | 2013-05-14 00:47:02.288491+00 | f        |
    f       | f         |         | Complete (KID 2293)
    (4 rows)


My workaround might be to add a periodic cleanup job, ie, 'delete from 
syncrun where ended is not null' every 10 min or so but I'd rather fix 
the root cause instead.
Anybody seen this?

Thanks.


Confidentiality Notice: This e-mail (including any attachments) is intended only for the recipients named above. It may contain confidential or privileged information and should not be read, copied or otherwise used by any other person. If you are not a named recipient, please notify the sender of that fact and delete the e-mail from your system.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20130517/be3c2efc/attachment.html>