PostgreSQL connectors unnecessarily calling aurora_replica_status()
Answered
We have 15 connectors sending data from our Google Cloud PostgreSQL databases to BigQuery. We are not having any issues getting or receiving data. However, we recently have noticed that every 15 minutes when we sync each of these connectors our Fivetran user makes the following query for each BigQuery database...
SELECT server_id FROM aurora_replica_status() LIMIT 1
... and since both ends of these connectors are Google products the queries always fail and log an error in our Postgres databases. This is an issue because it gives us consistent error alerts and has made it hard to notice and find real errors that occur.
We would like to request that, if possible, this query not be made for PostgreSQL connectors, or at least not be made for connectors not sending data to non-Amazon destinations. Thank you so much for your help!
-
Official comment
Hi Rachel,
This certainly seems like a bug on our side! I apologize for this issue and the current experience, and ensure we can resolve this quickly. Thanks for your feedback here and appreciate and additional questions!
-
We're running into this issue as well, and it is breaking syncing for other CloudSQL tables. Is there any workaround?
I have some logs if you want them as well.
insertId,logName,receiveTimestamp,resource.labels.database_id,resource.labels.project_id,resource.labels.region,resource.type,severity,textPayload,timestamp
s=a80374fafc4d441db612a8c6b967a249;i=72474;b=6424061471854be0b637679ce3bebad5;m=69a0dbd753;t=5bc083e91b877;x=605d0b4dd5664dd1-0-0@a1,projects/adhawk-franchises/logs/cloudsql.googleapis.com%2Fpostgres.log,2021-02-23T22:14:40.591667578Z,adhawk-franchises:production-database-replica,adhawk-franchises,us-central,cloudsql_database,INFO,"2021-02-23 22:14:39.049 UTC [87824]: [3-1] db=www,user=fivetran STATEMENT: SELECT server_id FROM aurora_replica_status() LIMIT 1",2021-02-23T22:14:39.050871Z
s=a80374fafc4d441db612a8c6b967a249;i=72473;b=6424061471854be0b637679ce3bebad5;m=69a0dbd70a;t=5bc083e91b82d;x=9ce251f1f0cc31f9-0-0@a1,projects/adhawk-franchises/logs/cloudsql.googleapis.com%2Fpostgres.log,2021-02-23T22:14:40.591667578Z,adhawk-franchises:production-database-replica,adhawk-franchises,us-central,cloudsql_database,INFO,"2021-02-23 22:14:39.049 UTC [87824]: [2-1] db=www,user=fivetran HINT: No function matches the given name and argument types. You might need to add explicit type casts.",2021-02-23T22:14:39.050797Z
s=a80374fafc4d441db612a8c6b967a249;i=72472;b=6424061471854be0b637679ce3bebad5;m=69a0dbd529;t=5bc083e91b64c;x=be3696f47a3fcfe7-0-0@a1,projects/adhawk-franchises/logs/cloudsql.googleapis.com%2Fpostgres.log,2021-02-23T22:14:40.591667578Z,adhawk-franchises:production-database-replica,adhawk-franchises,us-central,cloudsql_database,ERROR,"2021-02-23 22:14:39.049 UTC [87824]: [1-1] db=www,user=fivetran ERROR: function aurora_replica_status() does not exist at character 23",2021-02-23T22:14:39.050316Z -
Thankfully, none of our connectors seem to be currently breaking from this so we have not been forced to find a workaround! But perhaps Support has a work around for that problem?
Please sign in to leave a comment.
Comments
3 comments