Skip to main content

Community

PostgreSQL connectors unnecessarily calling aurora_replica_status()

Answered

Please sign in to leave a comment.

Comments

3 comments

  • 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?

Didn’t find what you need?

Contact support