By using AWS re:Post, you agree to the AWS re:Post Terms of Use

ERROR: unexpected pageaddr for logical replication service after Aurora maintenance window

1

Hello,

Since a Sunday maintenance window, we began to receive

ERROR: unexpected pageaddr

for all logical replication apps (AWS DMS and Debezium on Kafka Connect). This error is somehow recoverable and periodic: DB write instance logs

Otherwise DMS shows no error on this but Debezium kind of fails and recovered by connecting Postgres again. We are wondering if this could be related to Aurora DB minor version update? Or more like we are wrongly using some DB parameters (reboot actually activate the changes). Thanks a lot in advance :).

Best regards, David

asked 2 years ago796 views
1 Answer
1
Accepted Answer

Hi David,

This error log is a known issue and will be patched likely in our next Aurora PostgreSQL release.

In the interim, in order to mitigate the issue, disable the logical WAL cache feature by setting the cluster parameter 'rds.logical_wal_cache' to 0 and restarting your writer instance. Please rest assured that disabling this will not result in any loss of data from existing logical replication publications.

I hope that helps :)

profile pictureAWS
SUPPORT ENGINEER
answered 2 years ago
profile picture
EXPERT
reviewed 8 months ago
  • Thanks a lot Brandon! Very helpful ! :)

  • Hi Brandon, I wonder which versions are affected?

    Best regards, Alex

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions