Incorrect Region Reported by service URL and Metric URL

[Siva Teja Varun Bysani]

Hi Team,

   Found an issue for us-central1. 

The Service URL  is giving the Region as us-central1

https://www.googleapis.com/sql/v1beta4/projects/<Project name> /instances

(Part of response)

{

  "items": [

    {

      "instanceType": "CLOUD_SQL_INSTANCE",

      "region": "us-central1",

      "gceZone": "us-central1-a"

    },

But the Stack Driver URL for metrics of the same DB giving the region as us-central

https://monitoring.googleapis.com:443/v3/projects/<Same Project Name>?filter=metric.type="cloudsql.googleapis.com/database/mysql/innodb_buffer_pool_pages_dirty"&interval.startTime=2020-02-20T04:00:28Z&interval.endTime=2020-02-21T04:35:28Z&aggregation.perSeriesAligner=ALIGN_MEAN&aggregation.alignmentPeriod=60s

(part of response)

{ "timeSeries": [ { "metric": { "type": "cloudsql.googleapis.com/database/mysql/innodb_buffer_pool_pages_dirty" }, "resource": { "type": "cloudsql_database", "labels": { "region": "us-central", } },

Ideally Both End Points should give same region name

[Olu]

Hello, Siva

I was able to reproduce this issue using the monitoring API interface available on this documentation[1]. The region reported in the Response header for my CloudSQL Instance seem to be a broad region category, rather than specifically the region of the Instance. I would've recommended that the issue be reported on the issue tracker link[2] however, I observed a similar issue has already been reported on this link[3] and I can confirm that the issue has been forwarded to the API Engineers. They are reviewing the issue and you can be sure that updates would be posted on the issue link as soon as a fix or an update is available for the issue. 

[1]https://cloud.google.com/monitoring/api/ref_v3/rest/v3/projects.timeSeries/list

[2]https://cloud.google.com/support/docs/issue-trackers#trackers-list

[3]https://issuetracker.google.com/151102914