"Error: Database replication for RBAC is currently down" while setting up a replica for high availability in PE

You're trying to set up disaster recovery (DR), but setting up a replica isn't working. At the top of the page in the console, you see: Error: Database replication for RBAC is currently down. How do you resolve this?

Error messages and logs

• In the console, at the top of the page: Error: Database replication for RBAC is currently down.

  Note: This issue can affect the other PE databases: (pe-activity, pe-classifier, pe-puppetdb, and pe-orchestrator).

• Errors in the PE PostgreSQL log /var/log/puppetlabs/postgresql/pgstartup.log similar to:

  ERROR: subscriber s60dd73aa6f16b0 initialization failed during nonrecoverable step (c), please try the setup again

You might also see the following:

• Errors in the PE PostgreSQL log /var/log/puppetlabs/postgresql/pgstartup.log at the time the replica was provisioned similar to:

  ERROR: could not create unique index "tokens_id_key" DETAIL: Key (id)=(b6eccc79-d3c4-4210-8ae5-7f7dd8ccc12a) is duplicated

• Errors in the console services log /var/log/puppetlabs/console-services.log similar to:

  org.postgresql.util.PSQLException: ERROR: function show_subscription_status() does not exist

Version and installation information

PE version: All supported versions

Solution

To resolve the issue, reinitialize the replica using instructions in our documentation.