[Bucardo-general] Install Bucardo on Amazon RDS PostgreSQL

[David Christensen]

> On Jan 15, 2018, at 2:06 PM, caleb ayodele <ulo23k at gmail.com> 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
david at endpoint.com
785-727-1171



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20180117/a7c43900/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: Message signed with OpenPGP
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20180117/a7c43900/attachment.sig>