CloudSQL connnection failure from CloudRuN #19551
Description
I deployed cloudquery image which I build locally using cloudquery binaries. I was able to test the container image locally and able to extract the data. But when I deployed the image to cloudrun using docker.io registry, I have bellow error. Cloudrun and cloudSQL connected and I did a connection test, it looks good, but When I deployed a container and test, it fails with below error. any help would be greatly appreciated.
2024-10-31 20:37:57.843 PDT
2024-11-01T03:37:57Z INF started call grpc.component=server grpc.method=GetVersions grpc.method_type=unary grpc.service=cloudquery.discovery.v1.Discovery grpc.start_time=2024-11-01T03:37:57Z grpc.time_ms=0.223 peer.address=@ protocol=grpc
2024-10-31 20:37:57.843 PDT
2024-11-01T03:37:57Z INF finished call grpc.code=OK grpc.component=server grpc.method=GetVersions grpc.method_type=unary grpc.service=cloudquery.discovery.v1.Discovery grpc.start_time=2024-11-01T03:37:57Z grpc.time_ms=0.311 peer.address=@ protocol=grpc
2024-10-31 20:37:57.846 PDT
2024-11-01T03:37:57Z INF started call grpc.component=server grpc.method=GetVersions grpc.method_type=unary grpc.service=cloudquery.discovery.v1.Discovery grpc.start_time=2024-11-01T03:37:57Z grpc.time_ms=0.203 peer.address=@ protocol=grpc
2024-10-31 20:37:57.846 PDT
2024-11-01T03:37:57Z INF finished call grpc.code=OK grpc.component=server grpc.method=GetVersions grpc.method_type=unary grpc.service=cloudquery.discovery.v1.Discovery grpc.start_time=2024-11-01T03:37:57Z grpc.time_ms=0.284 peer.address=@ protocol=grpc
2024-10-31 20:37:58.075 PDT
2024-11-01T03:37:58Z INF Start sync destinations=["postgresql (cloudquery/[email protected])"] invocation_id=55415a24-c950-4621-8200-d0ffc1f7cfbd module=cli source="gcp (cloudquery/[email protected])" sync_time=2024-11-01T03:37:58Z transformers=[]
2024-10-31 20:37:58.077 PDT
2024-11-01T03:37:58Z INF started call grpc.component=server grpc.method=Init grpc.method_type=unary grpc.service=cloudquery.plugin.v3.Plugin grpc.start_time=2024-11-01T03:37:58Z grpc.time_ms=0.037 peer.address=@ protocol=grpc
2024-10-31 20:37:58.077 PDT
2024-11-01T03:37:58Z INF Initializing postgresql destination invocation_id=55415a24-c950-4621-8200-d0ffc1f7cfbd module=pg-dest pgx_log_level="invalid level 0"
2024-10-31 20:39:58.080 PDT
2024-11-01T03:39:58Z ERR finished call grpc.code=Internal grpc.component=server grpc.error="rpc error: code = Internal desc = failed to init plugin: failed to initialize client: failed to get current database: failed to connect to `host=34.70.120.70 user=cloudquery01 database=cloudquery01`: dial error (timeout: context deadline exceeded)" grpc.method=Init grpc.method_type=unary grpc.service=cloudquery.plugin.v3.Plugin grpc.start_time=2024-11-01T03:37:58Z grpc.time_ms=120002.99 peer.address=@ protocol=grpc
2024-10-31 20:39:58.080 PDT
2024-11-01T03:39:58Z INF End sync destinations=["postgresql (cloudquery/[email protected])"] invocation_id=55415a24-c950-4621-8200-d0ffc1f7cfbd module=cli source="gcp (cloudquery/[email protected])" sync_time=2024-11-01T03:37:58Z transformers=[]
2024-10-31 20:39:58.080 PDT
2024-11-01T03:39:58Z INF Sending sync summary to analyticsv1.cloudquery.io:443 invocation_id=55415a24-c950-4621-8200-d0ffc1f7cfbd module=cli
2024-10-31 20:39:58.125 PDT
2024-11-01T03:39:58Z INF waiting for source plugin to terminate invocation_id=55415a24-c950-4621-8200-d0ffc1f7cfbd module=cli
2024-10-31 20:39:58.126 PDT
2024-11-01T03:39:58Z INF Got stop signal. Plugin server shutting down address=/tmp/cq-iBYFCBKHqnZnKEDt.sock signal=interrupt
2024-10-31 20:39:58.133 PDT
2024-11-01T03:39:58Z INF waiting for source plugin to terminate invocation_id=55415a24-c950-4621-8200-d0ffc1f7cfbd module=cli
2024-10-31 20:39:58.133 PDT
2024-11-01T03:39:58Z INF Got stop signal. Plugin server shutting down address=/tmp/cq-eyivzBpKTMTyoAha.sock signal=interrupt
2024-10-31 20:39:58.356 PDT
Error: failed to sync v3 source gcp: failed to init destination postgresql: rpc error: code = Internal desc = failed to init plugin: failed to initialize client: failed to get current database: failed to connect to `host=34.70.120.70 user=cloudquery01 database=cloudquery01`: dial error (timeout: context deadline exceeded)
2024-10-31 20:39:58.356 PDT
2024-11-01T03:39:58Z ERR exiting with error error="failed to sync v3 source gcp: failed to init destination postgresql: rpc error: code = Internal desc = failed to init plugin: failed to initialize client: failed to get current database: