<p dir="auto"><strong>Apache Airflow version</strong>: 2.0.1</p>
<p dir="auto"><strong>Kubernetes version (if you are using kubernetes)</strong> (use <code class="notranslate">kubectl version</code>):</p>
<p dir="auto"><strong>Environment</strong>:</p>
<ul dir="auto">
<li><strong>Cloud provider or hardware configuration</strong>: k8s on bare metal</li>
<li><strong>OS</strong> (e.g. from /etc/os-release):</li>
<li><strong>Kernel</strong> (e.g. <code class="notranslate">uname -a</code>):</li>
<li><strong>Install tools</strong>: pip</li>
<li><strong>Others</strong>:</li>
</ul>
<p dir="auto"><strong>What happened</strong>:</p>
<details><summary>
Something bad has happened.
Please consider letting us know by creating a bug report using GitHub.
<h2 dir="auto">Python version: 3.8.7<br>
Airflow version: 2.0.1<br>
Node: airflow-webserver-57f76df565-ztfb5</h2>
<p dir="auto">Traceback (most recent call last):<br>
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context<br>
self.dialect.do_execute(<br>
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute<br>
cursor.execute(statement, parameters)<br>
psycopg2.errors.UndefinedFunction: operator does not exist: bytea ~~* bytea<br>
LINE 4: ...e' AND dag_run.state = 'running' AND dag_run.conf ILIKE '\x8...<br>
^<br>
HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.</p>
<p dir="auto">The above exception was the direct cause of the following exception:</p>
<p dir="auto">Traceback (most recent call last):<br>
File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 2447, in wsgi_app<br>
response = self.full_dispatch_request()<br>
File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 1952, in full_dispatch_request<br>
rv = self.handle_user_exception(e)<br>
File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 1821, in handle_user_exception<br>
reraise(exc_type, exc_value, tb)<br>
File "/usr/local/lib/python3.8/site-packages/flask/_compat.py", line 39, in reraise<br>
raise value<br>
File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 1950, in full_dispatch_request<br>
rv = self.dispatch_request()<br>
File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 1936, in dispatch_request<br>
return self.view_functions<a href="**req.view_args">rule.endpoint</a><br>
File "/usr/local/lib/python3.8/site-packages/flask_appbuilder/security/decorators.py", line 109, in wraps<br>
return f(self, *args, **kwargs)<br>
File "/usr/local/lib/python3.8/site-packages/flask_appbuilder/views.py", line 551, in list<br>
widgets = self._list()<br>
File "/usr/local/lib/python3.8/site-packages/flask_appbuilder/baseviews.py", line 1122, in _list<br>
widgets = self._get_list_widget(<br>
File "/usr/local/lib/python3.8/site-packages/flask_appbuilder/baseviews.py", line 1021, in _get_list_widget<br>
count, lst = self.datamodel.query(<br>
File "/usr/local/lib/python3.8/site-packages/flask_appbuilder/models/sqla/interface.py", line 425, in query<br>
count = self.query_count(query, filters, select_columns)<br>
File "/usr/local/lib/python3.8/site-packages/flask_appbuilder/models/sqla/interface.py", line 346, in query_count<br>
return self._apply_inner_all(<br>
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 3803, in count<br>
return self.from_self(col).scalar()<br>
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 3523, in scalar<br>
ret = self.one()<br>
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 3490, in one<br>
ret = self.one_or_none()<br>
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 3459, in one_or_none<br>
ret = list(self)<br>
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 3535, in <strong>iter</strong><br>
return self._execute_and_instances(context)<br>
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 3560, in _execute_and_instances<br>
result = conn.execute(querycontext.statement, self._params)<br>
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1011, in execute<br>
return meth(self, multiparams, params)<br>
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection<br>
return connection._execute_clauseelement(self, multiparams, params)<br>
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement<br>
ret = self._execute_context(<br>
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context<br>
self.<em>handle_dbapi_exception(<br>
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1510, in <em>handle_dbapi_exception<br>
util.raise</em>(<br>
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise</em><br>
raise exception<br>
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context<br>
self.dialect.do_execute(<br>
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute<br>
cursor.execute(statement, parameters)<br>
sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedFunction) operator does not exist: bytea ~~* bytea<br>
LINE 4: ...e' AND dag_run.state = 'running' AND dag_run.conf ILIKE '\x8...<br>
^<br>
HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.</p>
<p dir="auto">[SQL: SELECT count(*) AS count_1<br>
FROM (SELECT dag_run.state AS dag_run_state, dag_run.id AS dag_run_id, dag_run.dag_id AS dag_run_dag_id, dag_run.execution_date AS dag_run_execution_date, dag_run.start_date AS dag_run_start_date, dag_run.end_date AS dag_run_end_date, dag_run.run_id AS dag_run_run_id, dag_run.creating_job_id AS dag_run_creating_job_id, dag_run.external_trigger AS dag_run_external_trigger, dag_run.run_type AS dag_run_run_type, dag_run.conf AS dag_run_conf, dag_run.last_scheduling_decision AS dag_run_last_scheduling_decision, dag_run.dag_hash AS dag_run_dag_hash<br>
FROM dag_run<br>
WHERE dag_run.dag_id = %(dag_id_1)s AND dag_run.state = %(state_1)s AND dag_run.conf ILIKE %(conf_1)s) AS anon_1]<br>
[parameters: {'dag_id_1': 'privacy-scrubbing-service', 'state_1': 'running', 'conf_1': &lt;psycopg2.extensions.Binary object at 0x7f2e119d90c0&gt;}]<br>
(Background on this error at: <a href="http://sqlalche.me/e/13/f405" rel="nofollow">http://sqlalche.me/e/13/f405</a>)</p>
</summary></details>
<p dir="auto"><strong>What you expected to happen</strong>:</p>
<p dir="auto">Be able to search dag runs by conf contents</p>
<p dir="auto"><strong>How to reproduce it</strong>:<br>
<a target="_blank" rel="noopener noreferrer nofollow" href="https://user-images.githubusercontent.com/42754983/110379451-b1bed000-800b-11eb-9c78-92c22db244c6.png"><img src="https://user-images.githubusercontent.com/42754983/110379451-b1bed000-800b-11eb-9c78-92c22db244c6.png" alt="image" style="max-width: 100%;"></a><br>
<a target="_blank" rel="noopener noreferrer nofollow" href="https://user-images.githubusercontent.com/42754983/110378866-fc8c1800-800a-11eb-93fc-ddf0715c6b12.png"><img src="https://user-images.githubusercontent.com/42754983/110378866-fc8c1800-800a-11eb-93fc-ddf0715c6b12.png" alt="image" style="max-width: 100%;"></a></p>
<p dir="auto"><strong>Anything else we need to know</strong>:</p>
<p dir="auto"><strong>Apache Airflow version</strong>:</p>
<p dir="auto"><strong>Kubernetes version (if you are using kubernetes)</strong> (use <code class="notranslate">kubectl version</code>): "v1.14.2"</p>
<p dir="auto"><strong>Environment</strong>:</p>
<ul dir="auto">
<li><strong>Cloud provider or hardware configuration</strong>:</li>
<li><strong>OS</strong> (e.g. from /etc/os-release):<br>
NAME="CentOS Linux"<br>
VERSION="7 (Core)"<br>
ID="centos"<br>
ID_LIKE="rhel fedora"<br>
VERSION_ID="7"<br>
PRETTY_NAME="CentOS Linux 7 (Core)"<br>
ANSI_COLOR="0;31"<br>
CPE_NAME="cpe:/o:centos:centos:7"<br>
HOME_URL="<a href="https://www.centos.org/" rel="nofollow">https://www.centos.org/</a>"<br>
BUG_REPORT_URL="<a href="https://bugs.centos.org/" rel="nofollow">https://bugs.centos.org/</a>"</li>
</ul>
<p dir="auto">CENTOS_MANTISBT_PROJECT="CentOS-7"<br>
CENTOS_MANTISBT_PROJECT_VERSION="7"<br>
REDHAT_SUPPORT_PRODUCT="centos"<br>
REDHAT_SUPPORT_PRODUCT_VERSION="7"</p>
<ul dir="auto">
<li><strong>Kernel</strong> (e.g. <code class="notranslate">uname -a</code>): 3.10.0-957.21.3.el7.x86_64 <a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="69689814" data-permission-text="Title is private" data-url="https://github.com/apache/airflow/issues/1" data-hovercard-type="pull_request" data-hovercard-url="/apache/airflow/pull/1/hovercard" href="https://github.com/apache/airflow/pull/1">#1</a> SMP Tue Jun 18 16:35:19 UTC 2019 x86_64 x86_64 x86_64 GNU/Linux</li>
<li><strong>Install tools</strong>:</li>
<li><strong>Others</strong>:</li>
</ul>
<p dir="auto"><strong>What happened</strong>:</p>
<ol dir="auto">
<li>Go to "Browse-&gt; DAG Runs"</li>
<li>Add Filter, select "Conf", "Contains", Search</li>
</ol>
<h2 dir="auto">Error messages:<br>
`<br>
Python version: 3.6.12<br>
Airflow version: 2.0.0<br>
Node: airflow-webserver-6646b76f6d-kp9vr</h2>
<p dir="auto">Traceback (most recent call last):<br>
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1277, in _execute_context<br>
cursor, statement, parameters, context<br>
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute<br>
cursor.execute(statement, parameters)<br>
psycopg2.errors.UndefinedFunction: operator does not exist: bytea ~~* bytea<br>
LINE 4: WHERE dag_run.conf ILIKE '\x80049506000000000000008c02252594...<br>
^<br>
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.</p>
<p dir="auto">The above exception was the direct cause of the following exception:</p>
<p dir="auto">Traceback (most recent call last):<br>
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 2447, in wsgi_app<br>
response = self.full_dispatch_request()<br>
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1952, in full_dispatch_request<br>
rv = self.handle_user_exception(e)<br>
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1821, in handle_user_exception<br>
reraise(exc_type, exc_value, tb)<br>
File "/usr/local/lib/python3.6/site-packages/flask/_compat.py", line 39, in reraise<br>
raise value<br>
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1950, in full_dispatch_request<br>
rv = self.dispatch_request()<br>
File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1936, in dispatch_request<br>
return self.view_functions<a href="**req.view_args">rule.endpoint</a><br>
File "/usr/local/lib/python3.6/site-packages/flask_appbuilder/security/decorators.py", line 109, in wraps<br>
return f(self, *args, **kwargs)<br>
File "/usr/local/lib/python3.6/site-packages/flask_appbuilder/views.py", line 551, in list<br>
widgets = self._list()<br>
File "/usr/local/lib/python3.6/site-packages/flask_appbuilder/baseviews.py", line 1127, in _list<br>
page_size=page_size,<br>
File "/usr/local/lib/python3.6/site-packages/flask_appbuilder/baseviews.py", line 1026, in _get_list_widget<br>
page_size=page_size,<br>
File "/usr/local/lib/python3.6/site-packages/flask_appbuilder/models/sqla/interface.py", line 425, in query<br>
count = self.query_count(query, filters, select_columns)<br>
File "/usr/local/lib/python3.6/site-packages/flask_appbuilder/models/sqla/interface.py", line 347, in query_count<br>
query, filters, select_columns=select_columns, aliases_mapping={}<br>
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 3803, in count<br>
return self.from_self(col).scalar()<br>
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 3523, in scalar<br>
ret = self.one()<br>
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 3490, in one<br>
ret = self.one_or_none()<br>
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 3459, in one_or_none<br>
ret = list(self)<br>
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 3535, in <strong>iter</strong><br>
return self._execute_and_instances(context)<br>
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/orm/query.py", line 3560, in _execute_and_instances<br>
result = conn.execute(querycontext.statement, self._params)<br>
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1011, in execute<br>
return meth(self, multiparams, params)<br>
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection<br>
return connection._execute_clauseelement(self, multiparams, params)<br>
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1130, in _execute_clauseelement<br>
distilled_params,<br>
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1317, in <em>execute_context<br>
e, statement, parameters, cursor, context<br>
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1511, in <em>handle_dbapi_exception<br>
sqlalchemy_exception, with_traceback=exc_info[2], from</em>=e<br>
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 182, in raise</em><br>
raise exception<br>
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1277, in _execute_context<br>
cursor, statement, parameters, context<br>
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute<br>
cursor.execute(statement, parameters)<br>
sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedFunction) operator does not exist: bytea ~~* bytea<br>
LINE 4: WHERE dag_run.conf ILIKE '\x80049506000000000000008c02252594...<br>
^<br>
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.</p>
<p dir="auto">[SQL: SELECT count(*) AS count_1<br>
FROM (SELECT dag_run.state AS dag_run_state, dag_run.id AS dag_run_id, dag_run.dag_id AS dag_run_dag_id, dag_run.execution_date AS dag_run_execution_date, dag_run.start_date AS dag_run_start_date, dag_run.end_date AS dag_run_end_date, dag_run.run_id AS dag_run_run_id, dag_run.creating_job_id AS dag_run_creating_job_id, dag_run.external_trigger AS dag_run_external_trigger, dag_run.run_type AS dag_run_run_type, dag_run.conf AS dag_run_conf, dag_run.last_scheduling_decision AS dag_run_last_scheduling_decision, dag_run.dag_hash AS dag_run_dag_hash<br>
FROM dag_run<br>
WHERE dag_run.conf ILIKE %(conf_1)s) AS anon_1]<br>
[parameters: {'conf_1': &lt;psycopg2.extensions.Binary object at 0x7f5dad9c2c60&gt;}]<br>
(Background on this error at: <a href="http://sqlalche.me/e/13/f405)%60" rel="nofollow">http://sqlalche.me/e/13/f405)`</a></p>

<p dir="auto"><strong>What you expected to happen</strong>: Not crashed.</p>

<p dir="auto"><strong>How to reproduce it</strong>: See above</p>

<p dir="auto"><strong>Anything else we need to know</strong>:</p>