looks like all RDS enhanced metrics are affected, the /enhanced endpoint is not returning any metrics for those nodes. (config looks similar, except the affected nodes do not have aws_access_key set as they are using the instance profile/role)
I deleted some older nodes from the PMM inventory (using the UI), however, the rds_exporter config wasn’t updated (/tmp/rds_exporter/pmm-server/rds/config).
There are errors in the pmm-agent.log: “Failed to filter log events: ResourceNotFoundException: The specified log stream does not exist.”
after some tests it actually seems to be this old bug, if the “RDSOSMetrics” log stream for an instance isn’t found (e.g. due to disabled enhanced monitoring), it will not collect metrics for the other instances: