RDS Event Notifications subsciptions - some messages with no EventID

0

Hi

I'm setting up event notification messages to alert in Teams channels and I've noticed that several messages do not have corresponding "EventIDs" and therefore do not have relevant documentation surrounding the message

Am I missing something? Where can I can I get information about messages that don't have associated IDs.

Example With EventID:

"Message": {
            "Event Source": "db-instance",
            "Event Time": "2022-11-18 13:18:04.476",
            "Identifier Link": "https://console.aws.amazon.com/rds/home?region=eu-west-2#dbinstance:id=test-instance1",
            "Source ID": "test-instance1",
            "Source ARN": "arn:aws:rds:eu-west-2:99999999:db:test-instance1",
            "Event ID": "http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_Events.html#RDS-EVENT-0006",
            "Event Message": "DB instance restarted"
          },

Example WITHOUT EventID:

"Message": {
          "Event Source": "db-instance",
          "Event Time": "2022-11-18 13:17:44.564",
          "Identifier Link": "https://console.aws.amazon.com/rds/home?region=eu-west-2#dbinstance:id=test-instance1",
          "Source ID": "test-instance1",
          "Source ARN": "arn:aws:rds:eu-west-2:9999999999:db:test-instance1",
          "Event Message": "Read replica has been disconnected from xxxxx. Restarting postgres."
        },
1 Answer
0

Hello!

An RDS event indicates a change in the Amazon RDS environment. Note: Amazon RDS emits events on a "best effort" basis. We recommend that you avoid writing programs that depend on the order or existence of notification events because they might be out of sequence or missing. For more information, see: [+] https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/rds-cloudwatch-events.sample.html

Also, Amazon RDS doesn't guarantee the order of events sent in an event stream. The event order is subject to change. For more information, see: [+] https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_Events.overview.html

DB instance events will send an "Event ID" based on the "Event Message" as mentioned in the document: [+] https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_Events.Messages.html#USER_Events.Messages.instance

In your example, there is no "Event ID" that was associated with the "Event Message," like "Read replica has been disconnected from xxxxx. Restarting Postgres," so that is the reason you haven’t received any EventID. Sometimes, DB instance events will send "Null" as an "event ID" for some of the "Even Messages," as mentioned in the below example.

Event Source : db-instance 

Identifier Link: https://console.aws.amazon.com/rds/home?region=us-east-1#dbinstance:id=db1 

SourceId: db1 

Notification time : 2022-11-21 13:05:37.446 

Message : Slave is disconnected from the master and is attempting to reconnect. 

Event ID : http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_Events.html#null

Also, I could see in both of the examples, "Source ID" is the same as "test-instance1." If you want to capture the events of a read replica, then you should create a separate event subscription for that particular read replica. For more information, see: [+] https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_Events.Subscribing.html

answered 14 days ago

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