firebase / firebase/firebase-tools

[EXPERIMENTAL] Delegating SQL execution to FDC Backend Error

Open
#11,077 3 comments 1 reaction 0 assignees View on GitHub
api: dataconnect reproducible type: bug
Dominant language
TypeScript
Stars
4.5k
Forks
1.3k
Avg merge
1d 12h
Merged PRs (30d)
84

Description

### [REQUIRED] Environment info

**firebase-tools:** 15.30.0

**Platform:** Ubuntu

### [REQUIRED] Test case

Deploy Data Connect schema that requires a migration. `schemaValidation: 'COMPATIBLE'` is my setting in `dataconnect.yaml`.

### [REQUIRED] Steps to reproduce

Running `firebase deploy --only dataconnect` with recent versions of `firebase-tools` hits an error if it involves a schema migration:

```
dataconnect: [EXPERIMENTAL] Delegating SQL execution to FDC Backend
```

The error suggests that an experimental feature was enabled, resulting in a failure. I'm not sure if it's specific to my project or how it got turned on.

The error is not present if I revert back to `firebase-tools` version `15.27.0`.

### [REQUIRED] Expected behavior

Schema migration succeeds without errors.

### [REQUIRED] Actual behavior

```
firebase deploy --only dataconnect
i dataconnect: ensuring required API firebasedataconnect.googleapis.com is enabled...
i dataconnect: ensuring required API sqladmin.googleapis.com is enabled...
✔ dataconnect: required API firebasedataconnect.googleapis.com is enabled
✔ dataconnect: required API sqladmin.googleapis.com is enabled
i dataconnect: Generating SQL schema migrations to be compatible...
⚠ dataconnect: PostgreSQL schema is incompatible with the SQL Connect Schema.
Those SQL statements will migrate it to be compatible:

........
........

i dataconnect: [EXPERIMENTAL] Delegating SQL execution to FDC Backend...

Error: Request to https://firebasedataconnect.googleapis.com/v1/projects/abc/locations/northamerica-northeast1/services/abcschemas/main:migrate had HTTP Error: 404, Method not found.
Error: Process completed with exit code 1.
```

Contributor guide

Open the contributing guide

Research direction

Start by reproducing `firebase deploy --only dataconnect` with `schemaValidation: 'COMPATIBLE'` in `dataconnect.yaml`, comparing firebase-tools 15.30.0 with 15.27.0. Trace the Data Connect schema-migration path and the request to the reported `main:migrate` endpoint; done means the migration succeeds without the 404 or experimental delegation error.

Written by the indexing model from the issue text.

Assessment

Tech stack
firebase, postgresql, typescript
Domain
backend-api-design, cli, databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Active
Clarity
Mostly clear
Newbie friendliness
48/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.