[Bucardo-general] bucardo.bucardo_purge_delta_oid :: throws odd error

[Steven Shoopak]

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
Bucardo-general@bucardo.org
https://mail.endcrypt.com/mailman/listinfo/bucardo-general