You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@airflow.apache.org by GitBox <gi...@apache.org> on 2022/07/25 08:47:01 UTC
[GitHub] [airflow] vlcheong opened a new issue, #25274: Apache Airflow SqlSensor DbApiHook Error
vlcheong opened a new issue, #25274:
URL: https://github.com/apache/airflow/issues/25274
### Apache Airflow version
2.3.3 (latest released)
### What happened
I trying to make SqlSensor to work with Oracle database, I've installed all the required provider and successfully tested the connection. When I run SqlSensor I got this error message
`ERROR - Failed to execute job 32 for task check_exec_date (The connection type is not supported by SqlSensor. The associated hook should be a subclass of `DbApiHook`. Got OracleHook; 419)`
### What you think should happen instead
_No response_
### How to reproduce
_No response_
### Operating System
Ubuntu 20.04.4 LTS
### Versions of Apache Airflow Providers
apache-airflow-providers-common-sql==1.0.0
apache-airflow-providers-ftp==3.0.0
apache-airflow-providers-http==3.0.0
apache-airflow-providers-imap==3.0.0
apache-airflow-providers-oracle==3.2.0
apache-airflow-providers-postgres==5.1.0
apache-airflow-providers-sqlite==3.0.0
### Deployment
Other
### Deployment details
Run on Windows Subsystem for Linux
### Anything else
_No response_
### Are you willing to submit PR?
- [ ] 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: commits-unsubscribe@airflow.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [airflow] potiuk commented on issue #25274: Apache Airflow SqlSensor DbApiHook Error
Posted by GitBox <gi...@apache.org>.
potiuk commented on issue #25274:
URL: https://github.com/apache/airflow/issues/25274#issuecomment-1193912788
Mybe I will find another solution for that in the future as well - I will think and dig a bit deeper.
--
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: commits-unsubscribe@airflow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [airflow] potiuk commented on issue #25274: Apache Airflow SqlSensor DbApiHook Error
Posted by GitBox <gi...@apache.org>.
potiuk commented on issue #25274:
URL: https://github.com/apache/airflow/issues/25274#issuecomment-1194488690
See #25293
--
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: commits-unsubscribe@airflow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [airflow] potiuk commented on issue #25274: Apache Airflow SqlSensor DbApiHook Error
Posted by GitBox <gi...@apache.org>.
potiuk commented on issue #25274:
URL: https://github.com/apache/airflow/issues/25274#issuecomment-1194488413
Yeah. I found a solution that will make it works also if you use legacy SqlSensor (will be released in the next common.sql provider)
--
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: commits-unsubscribe@airflow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [airflow] potiuk closed issue #25274: Apache Airflow SqlSensor DbApiHook Error
Posted by GitBox <gi...@apache.org>.
potiuk closed issue #25274: Apache Airflow SqlSensor DbApiHook Error
URL: https://github.com/apache/airflow/issues/25274
--
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: commits-unsubscribe@airflow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [airflow] boring-cyborg[bot] commented on issue #25274: Apache Airflow SqlSensor DbApiHook Error
Posted by GitBox <gi...@apache.org>.
boring-cyborg[bot] commented on issue #25274:
URL: https://github.com/apache/airflow/issues/25274#issuecomment-1193763743
Thanks for opening your first issue here! Be sure to follow the issue template!
--
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: commits-unsubscribe@airflow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [airflow] potiuk commented on issue #25274: Apache Airflow SqlSensor DbApiHook Error
Posted by GitBox <gi...@apache.org>.
potiuk commented on issue #25274:
URL: https://github.com/apache/airflow/issues/25274#issuecomment-1193911726
Please use the "Common-sql" sensor for that. Instead of `from airflow.sensors import SqlSensor` use `from airflow.providers.common.sql.sensors import SqlSensors` - that should fix the problem.
Unfortunately, other than documenting it, we cannot do much about it.
Please let me know @vlcheong if it fixed your problem. if it does, I will make sure to add appropriate documentation about it.
--
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: commits-unsubscribe@airflow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org