> On Jan 15, 2018, at 2:06 PM, caleb ayodele <[email protected]> wrote: > > Bucardo Inernal log: > -------------------------- > > (17427) [Mon Jan 15 20:03:49 2018] KID (auth_sync) New kid, sync "auth_sync" > alive=1 Parent=17424 PID=17427 kicked=1 > (17427) [Mon Jan 15 20:04:08 2018] KID (auth_sync) Kid has died, error is: > DBD::Pg::st execute failed: ERROR: query string argument of EXECUTE is null > CONTEXT: PL/pgSQL function bucardo.bucardo_delta_check(text,text) line 24 at > EXECUTE statement at /usr/local/share/perl5/Bucardo.pm line 3407. Line: 5037 > Main DB state: ? Error: none DB auth93 state: 22004 Error: 7 DB auth96 state: > ? Error: none > (17427) [Mon Jan 15 20:04:08 2018] KID (auth_sync) Kid 17427 exiting at > cleanup_kid. Sync "auth_sync" public.activation_token_id_seq Reason: > DBD::Pg::st execute failed: ERROR: query string argument of EXECUTE is null > CONTEXT: PL/pgSQL function bucardo.bucardo_delta_check(text,text) line 24 at > EXECUTE statement at /usr/local/share/perl5/Bucardo.pm line 3407. Line: 5037 > Main DB state: ? Error: none DB auth93 state: 22004 Error: 7 DB auth96 state: > ? Error: none > (17419) [Mon Jan 15 20:04:09 2018] MCP Starting check_sync_health
Can you raise the log level to DEBUG for that function? (`ALTER FUNCTION bucardo.bucardo_check_delta SET log_min_messages = DEBUG`) I’d like to see the inputs to the bucardo_delta_check function; if either of them were NULL for some reason then the overall statement will be NULL that gets executed. > > RDS log: > -------------- > 2018-01-15 20:02:58 UTC::[unknown]@[unknown]:[28222]:WARNING: > pg_getnameinfo_all() failed: Temporary failure in name resolution > 2018-01-15 20:03:18 UTC::[unknown]@[unknown]:[28420]:WARNING: > pg_getnameinfo_all() failed: Temporary failure in name resolution > 2018-01-15 20:03:38 UTC::[unknown]@[unknown]:[28632]:WARNING: > pg_getnameinfo_all() failed: Temporary failure in name resolution > 2018-01-15 20:03:38 UTC::[unknown]@[unknown]:[28633]:WARNING: > pg_getnameinfo_all() failed: Temporary failure in name resolution > 2018-01-15 20:03:58 UTC::[unknown]@[unknown]:[28870]:WARNING: > pg_getnameinfo_all() failed: Temporary failure in name resolution I’m interested in this, but not convinced this is related, at least directly. -- 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
