Helm chart tries to patch immutable Job resources on helm upgrade

[calebwoofenden]

Apache Airflow version

2.4.2

What happened

Running helm upgrade with helm hooks disabled in a namespace that already has the chart installed will fail because it's trying to patch a Job resource, which is immutable:

cannot patch "<release_name>-run-airflow-migrations" with kind Job: Job.batch "<release_name>-run-airflow-migrations" is invalid: spec.template: Invalid value: core.PodTemplateSpec {<...entire json spec of Job resource...>}: field is immutable

This happens when helm hooks are disabled on the db migrations job:

  migrateDatabaseJob:
    useHelmHooks: false

For more detail on why a user would want to do this, see #11979

Copying this from my comment on that issue:

Kube does offer a parameter called .spec.ttlSecondsAfterFinished that, when specified, will delete the Job after the specified number of seconds after completion (see https://kubernetes.io/docs/concepts/workloads/controllers/ttlafterfinished/). This is a pretty good solution, though installs done in a period of time shorter than this value might still run into the same problem.

The solution I propose here is to set a helm pre-install hook on the database deployment as well as the db migrations, and set the hook weight on the database lower than that of the migrations, so the database will be created first, then the migrations will run, then the webserver and etc. pods will come up. Then I think we could safely remove the wait-for-db-migrations initContainer on the deployments.

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[sunghospark-calm]

Running into the same problem here.
Had to disable the hooks because migration was not running properly during upgrade, without hooks the followup deployment fails because of the job spec conflict.

[mconigliaro]

I think #27148 might be the fix for this. It adds createUserJob.applyCustomEnv and migrateDatabaseJob.applyCustomEnv options which we should set to false. We're just waiting on a new release of the helm chart.

Related: #21943

[potiuk]

Marking as fixed then.

[alexandermalyga]

Just tried applyCustomEnv: false with 1.8.0rc1 and I'm still getting cannot patch "run-airflow-migrations" with kind Job ... field is immutable, so #27148 does not fix this issue.
EDIT:
After manually deleting the old job (deployed without applyCustomEnv: false) and redeploying, it not longer raises the error, so the fix does work.

[alexandermalyga]

Just to clarify, #27148 can indeed fix this issue, but it comes with the effect of removing env vars secrets from the migration job, which the job may use to connect to the database. #29314 should be a better fix for this issue.