[Bucardo-general] Install Bucardo on Amazon RDS PostgreSQL

David Christensen david at endpoint.com
Wed Jan 17 15:18:58 UTC 2018


That would exist on the database that you setup as the source, not on the main bucardo database.

> On Jan 17, 2018, at 9:04 AM, caleb ayodele <ulo23k at gmail.com> wrote:
> 
> 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 <mailto:david at endpoint.com>> wrote:
> 
> 
>> On Jan 15, 2018, at 2:06 PM, caleb ayodele <ulo23k at gmail.com <mailto: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 <mailto:david at endpoint.com>
> 785-727-1171 <tel:(785)%20727-1171>
> 
> 
> 
> 

--
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/8fd32bea/attachment-0001.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/8fd32bea/attachment-0001.sig>


More information about the Bucardo-general mailing list