search

rapidloop / pgmetrics

Collect and display information and stats from a running PostgreSQL server
https://pgmetrics.io
Apache License 2.0
960 stars 65 forks source link

AWS RDS, Aurora cloudwatch collection error #43

Closed cartum closed 3 years ago

cartum commented 3 years ago

Hi! I´m trying to run pgmetrics from linux to get the metrics for RDS Aurora Cluster and I´m getting this error:

pgmetrics: warning: failed to collect from AWS RDS: failed to get CloudWatch metric data: ValidationError: The value idEBSIOBalance% for parameter MetricDataQueries.member.30.Id is not matching the expected pattern ^[a-z][a-zA-Z0-9_]*$. The value idEBSByteBalance% for parameter MetricDataQueries.member.31.Id is not matching the expected pattern ^[a-z][a-zA-Z0-9_]*$. status code: 400, request id: 72bfee0a-a37f-4c4b-aa88-a5a304b4b660

The command that we are running is:

PGPASSWORD=XXXXXXXX ./pgmetrics -h writer-instance-endpoint -U SuperUser --aws-rds-dbid=clstr-instance-identifier -w -fjson database

The database output is ok, just fail with the RDS stats.

Thanks very much!

mdevan commented 3 years ago

Thanks for reporting. Is this a regular RDS, or is it Aurora? What type of EBS volume does it have?

cartum commented 3 years ago

It's an Aurora cluster provisioned with IOPS SSD (io1).

mdevan commented 3 years ago

Fixed in e928d42.

To test, you'll have to build from master:

  1. If you do not have Go installed, install it first
  2. Run cd $(mktemp -d) && go get github.com/rapidloop/pgmetrics/cmd/pgmetrics@master
  3. New pgmetrics binary will be in ~/go/bin

Feel free to reopen the issue if problem persists.