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.
_______________________________________________
Bucardo-general mailing list
[email protected]
https://mail.endcrypt.com/mailman/listinfo/bucardo-general
