dabla opened a new issue, #60120:
URL: https://github.com/apache/airflow/issues/60120
### Apache Airflow version
3.1.5
### If "Other Airflow 3 version" selected, which one?
_No response_
### What happened?
When using the SQLExecuteQueryTrigger through paginated GenericTransfer
which returns a non serializable result, the triggerer crashes:
```
File "/usr/lib64/python3.13/asyncio/base_events.py", line 725, in
run_until_complete
return future.result()
~~~~~~~~~~~~~^^
File
"/usr/local/lib/python3.13/site-packages/airflow/jobs/triggerer_job_runner.py",
line 873, in arun
await self.sync_state_to_supervisor(finished_ids)
File
"/usr/local/lib/python3.13/site-packages/airflow/jobs/triggerer_job_runner.py",
line 1062, in sync_state_to_supervisor
resp = await self.comms_decoder.asend(msg)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File
"/usr/local/lib/python3.13/site-packages/airflow/jobs/triggerer_job_runner.py",
line 794, in asend
bytes = frame.as_bytes()
File
"/usr/local/lib/python3.13/site-packages/airflow/sdk/execution_time/comms.py",
line 148, in as_bytes
self.req_encoder.encode_into(self, buffer, 4)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^
File
"/usr/local/lib/python3.13/site-packages/airflow/sdk/execution_time/comms.py",
line 125, in _msgpack_enc_hook
raise NotImplementedError(f"Objects of type {type(obj)} are not supported")
NotImplementedError: Objects of type <class 'oracledb.LOB'> are not
supported
```
### What you think should happen instead?
The error should be logged and the triggerer cancelled but the trigger
process should continue to run and not stop.
### How to reproduce
Use Oracle specific functions in the SQL query with the GenericTransfer in
pagination mode.
### Operating System
Redhat Linux
### Versions of Apache Airflow Providers
Using latest versions from constraints-3-1 branch
### Deployment
Other 3rd-party Helm chart
### Deployment details
_No response_
### Anything else?
_No response_
### Are you willing to submit PR?
- [x] Yes I am willing to submit a PR!
### Code of Conduct
- [x] I agree to follow this project's [Code of
Conduct](https://github.com/apache/airflow/blob/main/CODE_OF_CONDUCT.md)
--
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]
