[Bucardo-general] Install Bucardo on Amazon RDS PostgreSQL

caleb ayodele ulo23k at gmail.com
Wed Jan 17 15:04:42 UTC 2018


The problem is that i already tried to find the function and it doesn't
exist in the local database that bucardo installed in.

bucardo=# \d bucardo.bucardo_check_delta
Did not find any relation named "bucardo.bucardo_check_delta".

bucardo=# \df bucardo.bucardo_check_delta
                       List of functions
 Schema | Name | Result data type | Argument data types | Type
--------+------+------------------+---------------------+------
(0 rows)

On Wed, Jan 17, 2018 at 9:20 AM, David Christensen <david at endpoint.com>
wrote:

>
>
> 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 <(785)%20727-1171>
>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20180117/c1129f22/attachment.html>


More information about the Bucardo-general mailing list