[Bucardo-general] bucardo.bucardo_purge_delta_oid :: throws odd error
Steven Shoopak
sshoopak at epc-instore.com
Wed May 2 14:27:29 UTC 2018
Fellow Bucardians:
I'm getting a NULL string error in the following code segment in
bucardo.bucardo_purge_delta_oid:
PostgreSQL log:
5ae857bc.4f96,2018-05-01 08:04:12
EDT,postgres,production,localhost(49383),ERROR: query string argument of
EXECUTE is null *** 5ae857f8.50d8,2018-05-01 08:05:12
EDT,postgres,production,localhost(49415),ERROR: query string argument of
EXECUTE is null
Area of bucardo.bucardo_purge_delta_oid where it's happening:
-- Delete all txntimes from the delta table that:
-- 1) Have been used by all dbgroups listed in
bucardo_delta_targets
-- 2) Have a matching txntime from the track table
-- 3) Are older than the first argument interval
myst = 'DELETE FROM bucardo.'
|| deltatable
|| ' USING (SELECT txntime AS tt FROM bucardo.'
|| tracktable
|| ' GROUP BY 1 HAVING COUNT(*) = '
|| drows
|| ') AS foo'
|| ' WHERE txntime = tt'
|| ' AND txntime < now() - interval '
|| quote_literal($1);
But I can't seem to trace down why. Would anyone be able to
offer any guidance?
Thanks,
Steve
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20180502/97e6ae92/attachment.html>
More information about the Bucardo-general
mailing list