Comments (8)
#40314 will fix 8.0.0-8.0.19. However, if you are using 8.0.0-8.0.19, I'd highly recommend you upgrade since it's over 4 years old at this point.
from airflow.
That feels like a low blow @potiuk but on balance I think it's fair :)
:) I think we got quite a few "low blows" from MySQL over the past 4 years (starting from bad decisions about encoding, limiting the index sizes, locking far too many things during queries and causing deadlocks, bad handling and expiring of MySQL certificates in their apt repository that necessitated manually updating all past images we released for the last 4 years - the last one took 2 days of my life out ). I'd say they deserve some kind of retaliation
:D
from airflow.
Thanks for opening your first issue here! Be sure to follow the issue template! If you are willing to raise PR to address this issue please do so, no need to wait for approval.
from airflow.
from airflow.
@EnableServices what version of MySQL are you on? I am not able to reproduce this failure, and MySQL 8 does support DROP CONSTRAINT (search for it in this page - can't deep link 😞).
from airflow.
#40314 will fix 8.0.0-8.0.19. However, if you are using 8.0.0-8.0.19, I'd highly recommend you upgrade since it's over 4 years old at this point.
Yet another reason why we should consider dropping mysql :) ?
I guess this is from (Changes in MySQL 8.0.19 (2020-01-13, General Availability)
When CHECK constraints were implemented in MySQL 8.0.16, ALTER TABLE supported DROP CHECK and
ALTER CHECK syntax as MySQL extensions to standard SQL for modifying check constraints,
but did not support the more general (and SQL standard) DROP CONSTRAINT and
ALTER CONSTRAINT syntax for modifying existing constraints of any type. That syntax
is now supported; the constraint type is determined from the constraint name. (WL #12787)
from airflow.
That feels like a low blow @potiuk but on balance I think it's fair :)
On re-reading this page (https://airflow.apache.org/docs/apache-airflow/stable/howto/set-up-database.html), I can see that although it does suggest support for all versions of MySQL 8.0 - it does say "Old versions may not support all SQL statements."
Thank you @jedcunningham for the PR
from airflow.
Full disclosure: I have no idea if there are other queries that'll break as you start actually running Airflow. I only tested the migrations on an empty db :)
from airflow.
Related Issues (20)
- OpenLineage defaults in airflow.cfg incorrect HOT 4
- Add deferrable support to `LambdaInvokeFunctionOperator` HOT 10
- OpenLineage Provider issue: scheduler shuts down after pickle of OpenLineageListener fails HOT 5
- Mismatched Xcom Map Index when Dynamic Mapping over TaskGroup and not all mapped tasks have run
- After deleting a dag from the dags directory, it is still displayed in the UI HOT 3
- Syntax highlight and copy button for entries in XCom tab
- Deferred task behaviour is different from normal task HOT 1
- Request to Reintroduce Tasks Duration Multi Line Graph HOT 1
- The task was stuck, but when marking it as successful, it continues to run the remaining part of the job. HOT 2
- Mark Success but remote task continue running HOT 4
- Add on_kill to SSHOperator HOT 4
- Airflow scheduler crashes with a psycopg2.errors.GroupingError due to an incorrect SQL query when detecting orphaned datasets
- Support extraInitContainers for migrateDatabaseJob HOT 1
- ObjectStoragePath should be template-able HOT 1
- After deleting a dag from the dags directory, it is still displayed in the UI HOT 2
- values.yaml `dags.gitSync.containerLifecycleHooks` Does not working HOT 2
- Improve SFTPOperator with directory transfer and DELETE operation HOT 1
- add ower to TaskInstance class HOT 1
- Status of testing Providers that were prepared on June 22, 2024 HOT 38
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from airflow.