mkalinna commented on issue #28731:
URL: https://github.com/apache/airflow/issues/28731#issuecomment-1372437766
Hi @potiuk,
I understand there are still some discussions going on how to fix the issue
best. However, I applied the current patch to apache-airflow-providers==4.1.2
and come across a different issue now:
```
[2023-01-05, 17:17:26 CET] {exasol.py:180} INFO - Running statement: EXECUTE
SCRIPT mohn_fw.update_select_to_date_for_area('CORE'), parameters: None
[2023-01-05, 17:17:26 CET] {taskinstance.py:1772} ERROR - Task failed with
exception
Traceback (most recent call last):
File
"/usr/local/lib/python3.9/site-packages/airflow/providers/common/sql/operators/sql.py",
line 255, in execute
output = hook.run(
File
"/usr/local/lib/python3.9/site-packages/airflow/providers/exasol/hooks/exasol.py",
line 182, in run
result = handler(cur)
File
"/usr/local/lib/python3.9/site-packages/airflow/providers/exasol/operators/exasol.py",
line 26, in exasol_fetch_all_handler
return cursor.fetchall()
File "/usr/local/lib/python3.9/site-packages/pyexasol/statement.py", line
96, in fetchall
return [row for row in self]
File "/usr/local/lib/python3.9/site-packages/pyexasol/statement.py", line
96, in <listcomp>
return [row for row in self]
File "/usr/local/lib/python3.9/site-packages/pyexasol/statement.py", line
63, in __next__
raise ExaRuntimeError(self.connection, 'Attempt to fetch from statement
without result set')
pyexasol.exceptions.ExaRuntimeError:
(
message => Attempt to fetch from statement without result set
dsn => xxx.bpghub.de:8563
user => TEC_MOHN_ELT
schema => MOHN_FW
session_id => 1754200364326350346
)
[2023-01-05, 17:17:26 CET] {taskinstance.py:1322} INFO - Marking task as
UP_FOR_RETRY. dag_id=MOH_DWH_DAILY_CORE,
task_id=update_select_to_date_for_area, execution_date=20221225T210000,
start_date=20230105T161724, end_date=20230105T161726
[2023-01-05, 17:17:26 CET] {standard_task_runner.py:100} ERROR - Failed to
execute job 46523 for task update_select_to_date_for_area (
(
message => Attempt to fetch from statement without result set
dsn => xxx.bpghub.de:8563
user => TEC_MOHN_ELT
schema => MOHN_FW
session_id => 1754200364326350346
)
; 1542)
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
