Hi Steve, Can you verify this is an issue in git HEAD? There have been quite a few fixes in since 5.4.1, and this bug feels a little tickly.
As far as how this would end up, presumably one of the component parts of this constructed query is NULL, which results in the entire query becoming NULL, so tracing the source of each variable might reveal something not returning a value as expected. Best, David > On May 2, 2018, at 9:27 AM, Steven Shoopak <[email protected]> wrote: > > 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 > _______________________________________________ > Bucardo-general mailing list > [email protected] <mailto:[email protected]> > https://mail.endcrypt.com/mailman/listinfo/bucardo-general > <https://mail.endcrypt.com/mailman/listinfo/bucardo-general> -- David Christensen End Point Corporation [email protected] 785-727-1171
signature.asc
Description: Message signed with OpenPGP
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
