firebase / firebase/extensions

Stream Firestore to BigQuery extension installation fails

Open
#2,449 10 comments 1 reaction 0 assignees View on GitHub
extension: firestore-bigquery-export fixed-in-kits needs: author feedback Platform reproduced type: bug
Dominant language
TypeScript
Stars
979
Forks
433
Avg merge
1d 22h
Merged PRs (30d)
127

Description

### [REQUIRED] Step 2: Describe your configuration

- Extension name: firebase/firestore-bigquery-export@0.2.5
- Extension version: 0.2.5
- Configuration values (redact info where appropriate):
- basically the defaults, setting the firestore location to my location

### [REQUIRED] Step 3: Describe the problem
When I try to install the extension, for example

https://console.firebase.google.com/project/PROJECT-460819/extensions/install?ref=firebase%2Ffirestore-bigquery-export@0.2.5

it eventually fails:

![Image](https://github.com/user-attachments/assets/6cc4721e-8794-4775-af16-6744eddb1f6c)

Details look like:

`; RESOURCE_ERROR at /deployments/firebase-ext-firestore-bigquery-export/resources/initBigQuerySync: {"ResourceType":"gcp-types/cloudfunctions-v1:projects.locations.functions","ResourceErrorCode":"400","ResourceErrorMessage":{"code":400,"message":"Failed to create 1st Gen function projects/PROJECT-460819/locations/us-central1/functions/ext-firestore-bigquery-export-initBigQuerySync: Default service account '998640598660-compute@developer.gserviceaccount.com' doesn't exist. Please recreate this account or specify a different account. Please visit https://cloud.google.com/functions/docs/troubleshooting for in-depth troubleshooting documentation.","status":"FAILED_PRECONDITION","statusMessage":"Bad Request","requestPath":"https://cloudfunctions.googleapis.com/v1/projects/PROJECT-460819/locations/us-central1/functions","httpMethod":"POST"}}; RESOURCE_ERROR at /deployments/firebase-ext-firestore-bigquery-export/resources/syncBigQuery: {"ResourceType":"gcp-types/cloudfunctions-v1:projects.locations.functions","ResourceErrorCode":"400","ResourceErrorMessage":{"code":400,"message":"Failed to create 1st Gen function projects/PROJECT-460819/locations/us-central1/functions/ext-firestore-bigquery-export-syncBigQuery: Default service account '998640598660-compute@developer.gserviceaccount.com' doesn't exist. Please recreate this account or specify a different account. Please visit https://cloud.google.com/functions/docs/troubleshooting for in-depth troubleshooting documentation.","status":"FAILED_PRECONDITION","statusMessage":"Bad Request","requestPath":"https://cloudfunctions.googleapis.com/v1/projects/PROJECT-460819/locations/us-central1/functions","httpMethod":"POST"}}; RESOURCE_ERROR at /deployments/firebase-ext-firestore-bigquery-export/resources/fsexportbigquery: {"ResourceType":"gcp-types/cloudfunctions-v2beta:projects.locations.functions","ResourceErrorCode":"404","ResourceErrorMessage":{"code":404,"message":"Service account projects/-/serviceAccounts/998640598660-compute@developer.gserviceaccount.com was not found.","status":"NOT_FOUND","statusMessage":"Not Found","requestPath":"https://cloudfunctions.googleapis.com/v2beta/projects/PROJECT-460819/locations/us-central1/functions","httpMethod":"POST"}}; RESOURCE_ERROR at /deployments/firebase-ext-firestore-bigquery-export/resources/setupBigQuerySync: {"ResourceType":"gcp-types/cloudfunctions-v1:projects.locations.functions","ResourceErrorCode":"400","ResourceErrorMessage":{"code":400,"message":"Failed to create 1st Gen function projects/PROJECT-460819/locations/us-central1/functions/ext-firestore-bigquery-export-setupBigQuerySync: Default service account '998640598660-compute@developer.gserviceaccount.com' doesn't exist. Please recreate this account or specify a different account. Please visit https://cloud.google.com/functions/docs/troubleshooting for in-depth troubleshooting documentation.","status":"FAILED_PRECONDITION","statusMessage":"Bad Request","requestPath":"https://cloudfunctions.googleapis.com/v1/projects/PROJECT-460819/locations/us-central1/functions","httpMethod":"POST"}}`

#### Steps to reproduce:

Something suspicious: when I click the "Grant" buttons on this page of the installation sequence,

![Image](https://github.com/user-attachments/assets/9c69598b-1086-477e-89b8-0d13dad87027)

I don't get positive feedback... the buttons just disappear:

![Image](https://github.com/user-attachments/assets/641117f0-76b2-4227-a71b-273841ef0a66)

##### Expected result

Extension installs cleanly

##### Actual result

Extension fails to install!

I have also tried to install the extension with the command line, which generates a slightly different error:

```
=== Deploying to 'PROJECT-460819'...

i deploying extensions
i extensions: ensuring required API firebaseextensions.googleapis.com is enabled...
✔ extensions: required API firebaseextensions.googleapis.com is enabled
i extensions: ensuring required API compute.googleapis.com is enabled...
✔ extensions: required API compute.googleapis.com is enabled

Error: Request to https://cloudresourcemanager.googleapis.com/v1/projects/PROJECT-460819:setIamPolicy had HTTP Error: 400, Service account 998640598660-compute@developer.gserviceaccount.com does not exist.
```

I strongly suspect this is related to the following issues, but since it involved the Firebase web interface, I thought it deserved its own bug:
- https://github.com/firebase/extensions/issues/2383
- https://github.com/firebase/firebase-tools/pull/8566

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.