[Bucardo-general] Kid has died, error is: DBD::Pg::db do failed: ERROR: permission denied to set parameter "session_replication_role" at /usr/local/share/perl/5.30.0/Bucardo.pm line 5359

[Akheel Ahmed]

Also,

I gave rds_superuser,rds_replication to the connecting user(i.e table 
owner). This time, I get a different error


(21282) [Fri Oct 22 15:22:52 2021] MCP Starting check_sync_health
(21327) [Fri Oct 22 15:23:03 2021] KID (AURORASYNC) New kid, sync 
"AURORASYNC" alive=1 Parent=21286 PID=21327 kicked=1
(21327) [Fri Oct 22 15:23:03 2021] KID (AURORASYNC) Disabling indexes 
for DEST.public.bucardo_test
(21327) [Fri Oct 22 15:23:03 2021] KID (AURORASYNC) Kid has died, error 
is: DBD::Pg::db do failed: ERROR:  permission denied for table pg_class 
at /usr/local/share/perl/5.30.0/Bucardo.pm line 5525. Line: 5037 Main DB 
state: ? Error: none DB DEST state: 42501 Error: 7 DB SRC state: ? 
Error: none
(21327) [Fri Oct 22 15:23:03 2021] KID (AURORASYNC) Kid 21327 exiting at 
cleanup_kid. Sync "AURORASYNC" public.bucardo_test Reason: DBD::Pg::db 
do failed: ERROR:  permission denied for table pg_class at 
/usr/local/share/perl/5.30.0/Bucardo.pm line 5525. Line: 5037 Main DB 
state: ? Error: none DB DEST state: 42501 Error: 7 DB SRC state: ? 
Error: none
(21282) [Fri Oct 22 15:23:03 2021] MCP Starting check_sync_health


On 23/10/2021 1:05 am, Akheel Ahmed wrote:
>
> Hi
>
> I have setup source, dest, relgroup and sync. When I start Bucardo, I 
> see a constant flurry of these messages. The source and target 
> connections are made using the owner of the tables being replicated.
>
> The source and target are Amazon Aurora postgresql environments, 
> source being 9.6.16 and target at 12.7. Does the connecting user need 
> to have superuser privilege? AWS Aurora wouldn't allow 
> creation/alteration of a role to include superuser privileges.
>
> (20943) [Fri Oct 22 14:43:26 2021] KID (AURORASYNC) New kid, sync 
> "AURORASYNC" alive=1 Parent=20865 PID=20943 kicked=1
> (20943) [Fri Oct 22 14:43:26 2021] KID (AURORASYNC) Kid has died, 
> error is: DBD::Pg::db do failed: ERROR:  permission denied to set 
> parameter "session_replication_role" at 
> /usr/local/share/perl/5.30.0/Bucardo.pm line 5359. Line: 5037 Main DB 
> state: ? Error: none DB DEST state: 42501 Error: 7 DB SRC state: ? 
> Error: none
> (20943) [Fri Oct 22 14:43:26 2021] KID (AURORASYNC) Kid 20943 exiting 
> at cleanup_kid. Sync "AURORASYNC" public.bucardo_test Reason: 
> DBD::Pg::db do failed: ERROR:  permission denied to set parameter 
> "session_replication_role" at /usr/local/share/perl/5.30.0/Bucardo.pm 
> line 5359. Line: 5037 Main DB state: ? Error: none DB DEST state: 
> 42501 Error: 7 DB SRC state: ? Error: none
> (20861) [Fri Oct 22 14:43:26 2021] MCP Starting check_sync_health
>
> Help appreciated.
>
> Thanks
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://bucardo.org/pipermail/bucardo-general/attachments/20211023/8dce1a8c/attachment.htm>