[EXPERIMENTAL] Delegating SQL execution to FDC Backend Error

[mickeywu]

[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.

[charlesdassonville]

You can run migration manually using shell or directly in the console. and then rerun firebase deploy --only dataconnect to deploy connectors. hope it will be corrected soon !

[smilly-boy]

[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.

[aalej]

Thanks for the detailed report @mickeywu! I was able to reproduce the issue. Looking through the recent changes, I think this might be related to a recently added experiment fdcapimigration. You should be able to workaround the issue by disabling the experiment firebase experiments:disable fdcapimigration.

I'll raise this to our engineering team and mark this as reproducible. Sharing mcve here - https://github.com/aalej/issues-11077