<h3 dir="auto">Official Helm Chart version</h3>
<p dir="auto">1.7.0 (latest released)</p>
<h3 dir="auto">Apache Airflow version</h3>
<p dir="auto">2.3.1</p>
<h3 dir="auto">Kubernetes Version</h3>
<p dir="auto">1.23.10</p>
<h3 dir="auto">Helm Chart configuration</h3>
<div class="snippet-clipboard-content notranslate position-relative overflow-auto" data-snippet-clipboard-copy-content="webserverSecretKey: 'ad2126ad-95c5-4050-b785-218f84b4bafa'
defaultAirflowRepository: 'airflow'
defaultAirflowTag: 'test'
images:
  airflow:
   pullPolicy: Never 
webserver:
    service:
      type: NodePort

    resources:
      limits:
        cpu: 500m
        memory: 1028Mi
config:
  core:
    enable_xcom_pickling: True
pgbouncer:
  # The maximum number of connections to PgBouncer
  maxClientConn: 100
  # The maximum number of server connections to the metadata database from PgBouncer
  metadataPoolSize: 10
  # The maximum number of server connections to the result backend database from PgBouncer
  resultBackendPoolSize: 5
  enabled: true

redis:
  enabled: false
data:
  brokerUrl: redis://redis.test.org:6379/0

postgresql:
  enabled: False


enableBuiltInSecretEnvVars:
  AIRFLOW__DATABASE__SQL_ALCHEMY_CONN: False
  AIRFLOW__CELERY__RESULT_BACKEND: False
secret:
  - envName: &quot;AIRFLOW__DATABASE__SQL_ALCHEMY_CONN&quot;
    secretName: &quot;airflow-metadata&quot;
    secretKey: &quot;AIRFLOW__DATABASE__SQL_ALCHEMY_CONN&quot;
  - envName: &quot;AIRFLOW__CELERY__RESULT_BACKEND&quot;
    secretName: &quot;airflow-metadata&quot;
    secretKey: &quot;AIRFLOW__CELERY__RESULT_BACKEND&quot;

extraEnvFrom: |-
  - configMapRef:
      name: 'airflow-variables"><pre class="notranslate"><code class="notranslate">webserverSecretKey: 'ad2126ad-95c5-4050-b785-218f84b4bafa'
defaultAirflowRepository: 'airflow'
defaultAirflowTag: 'test'
images:
  airflow:
   pullPolicy: Never 
webserver:
    service:
      type: NodePort

    resources:
      limits:
        cpu: 500m
        memory: 1028Mi
config:
  core:
    enable_xcom_pickling: True
pgbouncer:
  # The maximum number of connections to PgBouncer
  maxClientConn: 100
  # The maximum number of server connections to the metadata database from PgBouncer
  metadataPoolSize: 10
  # The maximum number of server connections to the result backend database from PgBouncer
  resultBackendPoolSize: 5
  enabled: true

redis:
  enabled: false
data:
  brokerUrl: redis://redis.test.org:6379/0

postgresql:
  enabled: False


enableBuiltInSecretEnvVars:
  AIRFLOW__DATABASE__SQL_ALCHEMY_CONN: False
  AIRFLOW__CELERY__RESULT_BACKEND: False
secret:
  - envName: "AIRFLOW__DATABASE__SQL_ALCHEMY_CONN"
    secretName: "airflow-metadata"
    secretKey: "AIRFLOW__DATABASE__SQL_ALCHEMY_CONN"
  - envName: "AIRFLOW__CELERY__RESULT_BACKEND"
    secretName: "airflow-metadata"
    secretKey: "AIRFLOW__CELERY__RESULT_BACKEND"

extraEnvFrom: |-
  - configMapRef:
      name: 'airflow-variables
</code></pre></div>
<h3 dir="auto">Docker Image customisations</h3>
<p dir="auto"><em>No response</em></p>
<h3 dir="auto">What happened</h3>
<p dir="auto">I was running simple airflow on kubernetes using helm with a configuration specified.<br>
But the webserver not getting initialized.</p>
<p dir="auto">here are the kubernetes pod</p>
<div class="snippet-clipboard-content notranslate position-relative overflow-auto" data-snippet-clipboard-copy-content="NAME                                   READY   STATUS      RESTARTS        AGE
airflow-pgbouncer-db449d6b-98ldf       2/2     Running     0               49m
airflow-run-airflow-migrations-6bdwg   0/1     Completed   0               49m
airflow-scheduler-9f78574d6-cq8dc      2/2     Running     1 (9m42s ago)   49m
airflow-statsd-7c7584d6f8-6ldmr        1/1     Running     0               49m
airflow-triggerer-6b4c678799-m6pg5     1/1     Running     4 (4m32s ago)   49m
airflow-webserver-5575454d74-tc9zm     0/1     Running     5 (94s ago)     49m
airflow-worker-0                       2/2     Running     0               49m
"><pre class="notranslate"><code class="notranslate">NAME                                   READY   STATUS      RESTARTS        AGE
airflow-pgbouncer-db449d6b-98ldf       2/2     Running     0               49m
airflow-run-airflow-migrations-6bdwg   0/1     Completed   0               49m
airflow-scheduler-9f78574d6-cq8dc      2/2     Running     1 (9m42s ago)   49m
airflow-statsd-7c7584d6f8-6ldmr        1/1     Running     0               49m
airflow-triggerer-6b4c678799-m6pg5     1/1     Running     4 (4m32s ago)   49m
airflow-webserver-5575454d74-tc9zm     0/1     Running     5 (94s ago)     49m
airflow-worker-0                       2/2     Running     0               49m

</code></pre></div>
<p dir="auto">here is webserver logs</p>
<div class="snippet-clipboard-content notranslate position-relative overflow-auto" data-snippet-clipboard-copy-content="[2022-11-14 07:30:49,068] {manager.py:543} INFO - Removed Permission View: menu_access on Permissions
[2022-11-14 07:30:49,376] {manager.py:543} INFO - Removed Permission View: menu_access on Permissions
[2022-11-14 07:30:49,377] {manager.py:543} INFO - Removed Permission View: menu_access on Permissions
[2022-11-14 07:30:49,377] {manager.py:543} INFO - Removed Permission View: menu_access on Permissions
[2022-11-14 07:31:01,429] {manager.py:508} INFO - Created Permission View: menu access on Permissions
[2022-11-14 07:31:01,698] {manager.py:511} ERROR - Creation of Permission View Error: (psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint &quot;ab_permission_view_permission_id_view_menu_id_key&quot;
DETAIL:  Key (permission_id, view_menu_id)=(5, 15) already exists.

[SQL: INSERT INTO ab_permission_view (id, permission_id, view_menu_id) VALUES (nextval('ab_permission_view_id_seq'), %(permission_id)s, %(view_menu_id)s) RETURNING ab_permission_view.id]
[parameters: {'permission_id': 5, 'view_menu_id': 15}]
(Background on this error at: http://sqlalche.me/e/14/gkpj)
[2022-11-14 07:31:01,698] {manager.py:511} ERROR - Creation of Permission View Error: (psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint &quot;ab_permission_view_permission_id_view_menu_id_key&quot;
DETAIL:  Key (permission_id, view_menu_id)=(5, 15) already exists.

[SQL: INSERT INTO ab_permission_view (id, permission_id, view_menu_id) VALUES (nextval('ab_permission_view_id_seq'), %(permission_id)s, %(view_menu_id)s) RETURNING ab_permission_view.id]
[parameters: {'permission_id': 5, 'view_menu_id': 15}]
(Background on this error at: http://sqlalche.me/e/14/gkpj)
[2022-11-14 07:31:01,698] {manager.py:511} ERROR - Creation of Permission View Error: (psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint &quot;ab_permission_view_permission_id_view_menu_id_key&quot;
DETAIL:  Key (permission_id, view_menu_id)=(5, 15) already exists.

[SQL: INSERT INTO ab_permission_view (id, permission_id, view_menu_id) VALUES (nextval('ab_permission_view_id_seq'), %(permission_id)s, %(view_menu_id)s) RETURNING ab_permission_view.id]
[parameters: {'permission_id': 5, 'view_menu_id': 15}]
(Background on this error at: http://sqlalche.me/e/14/gkpj)
[2022-11-14 07:31:02,891] {manager.py:568} INFO - Added Permission menu access on Permissions to role Admin
[2022-11-14 07:31:16,535] {manager.py:570} ERROR - Add Permission to Role Error: (psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint &quot;ab_permission_view_role_permission_view_id_role_id_key&quot;
DETAIL:  Key (permission_view_id, role_id)=(207, 1) already exists.

[SQL: INSERT INTO ab_permission_view_role (id, permission_view_id, role_id) VALUES (nextval('ab_permission_view_role_id_seq'), %(permission_view_id)s, %(role_id)s) RETURNING ab_permission_view_role.id]
[parameters: {'permission_view_id': 207, 'role_id': 1}]
(Background on this error at: http://sqlalche.me/e/14/gkpj)
[2022-11-14 07:31:16,535] {manager.py:570} ERROR - Add Permission to Role Error: (psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint &quot;ab_permission_view_role_permission_view_id_role_id_key&quot;
DETAIL:  Key (permission_view_id, role_id)=(207, 1) already exists.

[SQL: INSERT INTO ab_permission_view_role (id, permission_view_id, role_id) VALUES (nextval('ab_permission_view_role_id_seq'), %(permission_view_id)s, %(role_id)s) RETURNING ab_permission_view_role.id]
[parameters: {'permission_view_id': 207, 'role_id': 1}]
(Background on this error at: http://sqlalche.me/e/14/gkpj)
[2022-11-14 07:31:16,535] {manager.py:570} ERROR - Add Permission to Role Error: (psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint &quot;ab_permission_view_role_permission_view_id_role_id_key&quot;
DETAIL:  Key (permission_view_id, role_id)=(207, 1) already exists.

[SQL: INSERT INTO ab_permission_view_role (id, permission_view_id, role_id) VALUES (nextval('ab_permission_view_role_id_seq'), %(permission_view_id)s, %(role_id)s) RETURNING ab_permission_view_role.id]
[parameters: {'permission_view_id': 207, 'role_id': 1}]
(Background on this error at: http://sqlalche.me/e/14/gkpj)
[2022-11-14 07:32:10 +0000] [22] [CRITICAL] WORKER TIMEOUT (pid:40)
[2022-11-14 07:32:10 +0000] [22] [CRITICAL] WORKER TIMEOUT (pid:41)
[2022-11-14 07:32:10 +0000] [22] [CRITICAL] WORKER TIMEOUT (pid:42)
[2022-11-14 07:32:10 +0000] [22] [CRITICAL] WORKER TIMEOUT (pid:43)
[2022-11-14 07:32:10 +0000] [43] [INFO] Worker exiting (pid: 43)
[2022-11-14 07:32:10 +0000] [42] [INFO] Worker exiting (pid: 42)
[2022-11-14 07:32:10 +0000] [41] [INFO] Worker exiting (pid: 41)
[2022-11-14 07:32:10 +0000] [40] [INFO] Worker exiting (pid: 40)
[2022-11-14 07:32:11 +0000] [22] [WARNING] Worker with pid 42 was terminated due to signal 9
[2022-11-14 07:32:11 +0000] [22] [WARNING] Worker with pid 40 was terminated due to signal 9
[2022-11-14 07:32:11 +0000] [22] [WARNING] Worker with pid 41 was terminated due to signal 9
[2022-11-14 07:32:11 +0000] [22] [WARNING] Worker with pid 43 was terminated due to signal 9
[2022-11-14 07:32:11 +0000] [44] [INFO] Booting worker with pid: 44
[2022-11-14 07:32:12 +0000] [45] [INFO] Booting worker with pid: 45
[2022-11-14 07:32:12 +0000] [46] [INFO] Booting worker with pid: 46
[2022-11-14 07:32:12 +0000] [47] [INFO] Booting worker with pid: 47
"><pre class="notranslate"><code class="notranslate">[2022-11-14 07:30:49,068] {manager.py:543} INFO - Removed Permission View: menu_access on Permissions
[2022-11-14 07:30:49,376] {manager.py:543} INFO - Removed Permission View: menu_access on Permissions
[2022-11-14 07:30:49,377] {manager.py:543} INFO - Removed Permission View: menu_access on Permissions
[2022-11-14 07:30:49,377] {manager.py:543} INFO - Removed Permission View: menu_access on Permissions
[2022-11-14 07:31:01,429] {manager.py:508} INFO - Created Permission View: menu access on Permissions
[2022-11-14 07:31:01,698] {manager.py:511} ERROR - Creation of Permission View Error: (psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint "ab_permission_view_permission_id_view_menu_id_key"
DETAIL:  Key (permission_id, view_menu_id)=(5, 15) already exists.

[SQL: INSERT INTO ab_permission_view (id, permission_id, view_menu_id) VALUES (nextval('ab_permission_view_id_seq'), %(permission_id)s, %(view_menu_id)s) RETURNING ab_permission_view.id]
[parameters: {'permission_id': 5, 'view_menu_id': 15}]
(Background on this error at: http://sqlalche.me/e/14/gkpj)
[2022-11-14 07:31:01,698] {manager.py:511} ERROR - Creation of Permission View Error: (psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint "ab_permission_view_permission_id_view_menu_id_key"
DETAIL:  Key (permission_id, view_menu_id)=(5, 15) already exists.

[SQL: INSERT INTO ab_permission_view (id, permission_id, view_menu_id) VALUES (nextval('ab_permission_view_id_seq'), %(permission_id)s, %(view_menu_id)s) RETURNING ab_permission_view.id]
[parameters: {'permission_id': 5, 'view_menu_id': 15}]
(Background on this error at: http://sqlalche.me/e/14/gkpj)
[2022-11-14 07:31:01,698] {manager.py:511} ERROR - Creation of Permission View Error: (psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint "ab_permission_view_permission_id_view_menu_id_key"
DETAIL:  Key (permission_id, view_menu_id)=(5, 15) already exists.

[SQL: INSERT INTO ab_permission_view (id, permission_id, view_menu_id) VALUES (nextval('ab_permission_view_id_seq'), %(permission_id)s, %(view_menu_id)s) RETURNING ab_permission_view.id]
[parameters: {'permission_id': 5, 'view_menu_id': 15}]
(Background on this error at: http://sqlalche.me/e/14/gkpj)
[2022-11-14 07:31:02,891] {manager.py:568} INFO - Added Permission menu access on Permissions to role Admin
[2022-11-14 07:31:16,535] {manager.py:570} ERROR - Add Permission to Role Error: (psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint "ab_permission_view_role_permission_view_id_role_id_key"
DETAIL:  Key (permission_view_id, role_id)=(207, 1) already exists.

[SQL: INSERT INTO ab_permission_view_role (id, permission_view_id, role_id) VALUES (nextval('ab_permission_view_role_id_seq'), %(permission_view_id)s, %(role_id)s) RETURNING ab_permission_view_role.id]
[parameters: {'permission_view_id': 207, 'role_id': 1}]
(Background on this error at: http://sqlalche.me/e/14/gkpj)
[2022-11-14 07:31:16,535] {manager.py:570} ERROR - Add Permission to Role Error: (psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint "ab_permission_view_role_permission_view_id_role_id_key"
DETAIL:  Key (permission_view_id, role_id)=(207, 1) already exists.

[SQL: INSERT INTO ab_permission_view_role (id, permission_view_id, role_id) VALUES (nextval('ab_permission_view_role_id_seq'), %(permission_view_id)s, %(role_id)s) RETURNING ab_permission_view_role.id]
[parameters: {'permission_view_id': 207, 'role_id': 1}]
(Background on this error at: http://sqlalche.me/e/14/gkpj)
[2022-11-14 07:31:16,535] {manager.py:570} ERROR - Add Permission to Role Error: (psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint "ab_permission_view_role_permission_view_id_role_id_key"
DETAIL:  Key (permission_view_id, role_id)=(207, 1) already exists.

[SQL: INSERT INTO ab_permission_view_role (id, permission_view_id, role_id) VALUES (nextval('ab_permission_view_role_id_seq'), %(permission_view_id)s, %(role_id)s) RETURNING ab_permission_view_role.id]
[parameters: {'permission_view_id': 207, 'role_id': 1}]
(Background on this error at: http://sqlalche.me/e/14/gkpj)
[2022-11-14 07:32:10 +0000] [22] [CRITICAL] WORKER TIMEOUT (pid:40)
[2022-11-14 07:32:10 +0000] [22] [CRITICAL] WORKER TIMEOUT (pid:41)
[2022-11-14 07:32:10 +0000] [22] [CRITICAL] WORKER TIMEOUT (pid:42)
[2022-11-14 07:32:10 +0000] [22] [CRITICAL] WORKER TIMEOUT (pid:43)
[2022-11-14 07:32:10 +0000] [43] [INFO] Worker exiting (pid: 43)
[2022-11-14 07:32:10 +0000] [42] [INFO] Worker exiting (pid: 42)
[2022-11-14 07:32:10 +0000] [41] [INFO] Worker exiting (pid: 41)
[2022-11-14 07:32:10 +0000] [40] [INFO] Worker exiting (pid: 40)
[2022-11-14 07:32:11 +0000] [22] [WARNING] Worker with pid 42 was terminated due to signal 9
[2022-11-14 07:32:11 +0000] [22] [WARNING] Worker with pid 40 was terminated due to signal 9
[2022-11-14 07:32:11 +0000] [22] [WARNING] Worker with pid 41 was terminated due to signal 9
[2022-11-14 07:32:11 +0000] [22] [WARNING] Worker with pid 43 was terminated due to signal 9
[2022-11-14 07:32:11 +0000] [44] [INFO] Booting worker with pid: 44
[2022-11-14 07:32:12 +0000] [45] [INFO] Booting worker with pid: 45
[2022-11-14 07:32:12 +0000] [46] [INFO] Booting worker with pid: 46
[2022-11-14 07:32:12 +0000] [47] [INFO] Booting worker with pid: 47

</code></pre></div>
<p dir="auto">these logs are keep on repeating.<br>
I have created postgresql externally and specified it with secrets.</p>
<h3 dir="auto">What you think should happen instead</h3>
<p dir="auto"><em>No response</em></p>
<h3 dir="auto">How to reproduce</h3>
<p dir="auto"><em>No response</em></p>
<h3 dir="auto">Anything else</h3>
<p dir="auto"><em>No response</em></p>
<h3 dir="auto">Are you willing to submit PR?</h3>
<ul class="contains-task-list">
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox"> Yes I am willing to submit a PR!</li>
</ul>
<h3 dir="auto">Code of Conduct</h3>
<ul class="contains-task-list">
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox" checked=""> I agree to follow this project's <a href="https://github.com/apache/airflow/blob/main/CODE_OF_CONDUCT.md">Code of Conduct</a></li>
</ul>
<h3 dir="auto">Apache Airflow version</h3>
<p dir="auto">2.2.5</p>
<h3 dir="auto">What happened</h3>
<p dir="auto">This is a duplicate of <a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="1187998885" data-permission-text="Title is private" data-url="https://github.com/apache/airflow/issues/22647" data-hovercard-type="issue" data-hovercard-url="/apache/airflow/issues/22647/hovercard" href="https://github.com/apache/airflow/issues/22647">#22647</a> with a clearer title.</p>
<p dir="auto">Airflow logs warnings when used in combination with SQLAlchemy &gt;= 1.4.14 about missing <a href="https://docs.sqlalchemy.org/en/14/core/custom_types.html#sqlalchemy.types.TypeDecorator.cache_ok" rel="nofollow"><code class="notranslate">cache_ok</code> fields</a> on the Airflow <code class="notranslate">TypeDecorator</code> subclasses.</p>
<p dir="auto">These look like:</p>
<div class="snippet-clipboard-content notranslate position-relative overflow-auto" data-snippet-clipboard-copy-content="[2022-03-31, 11:47:06 UTC] {warnings.py:110} WARNING - /home/ec2-user/.local/lib/python3.7/site-packages/airflow/models/renderedtifields.py:163: SAWarning: TypeDecorator UtcDateTime(timezone=True) will not produce a cache key because the ``cache_ok`` attribute is not set to True.  This can have significant performance implications including some performance degradations in comparison to prior SQLAlchemy versions.  Set this attribute to True if this type object's state is safe to use in a cache key, or False to disable this warning. (Background on this error at: https://sqlalche.me/e/14/cprf)"><pre class="notranslate"><code class="notranslate">[2022-03-31, 11:47:06 UTC] {warnings.py:110} WARNING - /home/ec2-user/.local/lib/python3.7/site-packages/airflow/models/renderedtifields.py:163: SAWarning: TypeDecorator UtcDateTime(timezone=True) will not produce a cache key because the ``cache_ok`` attribute is not set to True.  This can have significant performance implications including some performance degradations in comparison to prior SQLAlchemy versions.  Set this attribute to True if this type object's state is safe to use in a cache key, or False to disable this warning. (Background on this error at: https://sqlalche.me/e/14/cprf)
</code></pre></div>
<p dir="auto">Airflow may by default use an older version of sqlalchemy where this doesn't happen.</p>
<h3 dir="auto">What you think should happen instead</h3>
<p dir="auto">Airflow should set these fields so that logs are not emitted.</p>
<h3 dir="auto">How to reproduce</h3>
<p dir="auto">Loading Airflow models in an environment with SQLAlchemy &gt;= 1.4.14 should show this.</p>
<h3 dir="auto">Operating System</h3>
<p dir="auto">NAME="Amazon Linux" VERSION="2" ID="amzn" ID_LIKE="centos rhel fedora" VERSION_ID="2" PRETTY_NAME="Amazon Linux 2" ANSI_COLOR="0;33" CPE_NAME="cpe:2.3<g-emoji class="g-emoji" alias="o" fallback-src="https://github.githubassets.com/images/icons/emoji/unicode/2b55.png">⭕</g-emoji>amazon:amazon_linux:2" HOME_URL="<a href="https://amazonlinux.com/" rel="nofollow">https://amazonlinux.com/</a>"</p>
<h3 dir="auto">Versions of Apache Airflow Providers</h3>
<p dir="auto">apache-airflow-providers-amazon==3.0.0<br>
apache-airflow-providers-celery==2.1.0<br>
apache-airflow-providers-ftp==2.0.1<br>
apache-airflow-providers-http==2.0.3<br>
apache-airflow-providers-imap==2.2.0<br>
apache-airflow-providers-postgres==3.0.0<br>
apache-airflow-providers-redis==2.0.1<br>
apache-airflow-providers-sqlite==2.1.0</p>
<h3 dir="auto">Deployment</h3>
<p dir="auto">Other Docker-based deployment</p>
<h3 dir="auto">Deployment details</h3>
<p dir="auto"><em>No response</em></p>
<h3 dir="auto">Anything else</h3>
<p dir="auto"><em>No response</em></p>
<h3 dir="auto">Are you willing to submit PR?</h3>
<ul class="contains-task-list">
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox" checked=""> Yes I am willing to submit a PR!</li>
</ul>
<h3 dir="auto">Code of Conduct</h3>
<ul class="contains-task-list">
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox" checked=""> I agree to follow this project's <a href="https://github.com/apache/airflow/blob/main/CODE_OF_CONDUCT.md">Code of Conduct</a></li>
</ul>