anthony-joyce opened a new issue, #41547: URL: https://github.com/apache/airflow/issues/41547
### Apache Airflow version Other Airflow 2 version (please specify below) ### If "Other Airflow 2 version" selected, which one? 2.10 ### What happened? After upgrading to airflow 2.10.0 from 2.8.1, `airflow db migrate` was initiated and two warnings were displayed. `/anaconda3/lib/python3.9/site-packages/airflow/migrations/versions/0151_2_10_0_dag_schedule_dataset_alias_reference.py:46 SAWarning: Table 'dag_schedule_dataset_alias_reference' specifies columns 'dag_id' as primary_key=True, not matching locally specified columns 'alias_id', 'dag_id'; setting the current primary key columns to 'alias_id', 'dag_id'. This warning may become an exception in a future release` `/anaconda3/lib/python3.9/site-packages/paramiko/transport.py:236 CryptographyDeprecationWarning: Blowfish has been deprecated and will be removed in a future release` ### What you think should happen instead? The Paramiko warning may work itself out in a future release by not being used anymore, however I am not sure if this warning is normal behavior. The second warning `/anaconda3/lib/python3.9/site-packages/airflow/migrations/versions/0151_2_10_0_dag_schedule_dataset_alias_reference.py:46 SAWarning: Table 'dag_schedule_dataset_alias_reference' specifies columns 'dag_id' as primary_key=True, not matching locally specified columns 'alias_id', 'dag_id'; setting the current primary key columns to 'alias_id', 'dag_id'. This warning may become an exception in a future release` ...is more of a concern and seems to be releated to column names. ### How to reproduce OS: CentOS7 pip list ``` Package Version ---------------------------------------- -------------------- aiohttp 3.8.1 aiosignal 1.2.0 alabaster 0.7.12 alembic 1.13.1 anaconda-client 1.9.0 anaconda-navigator 2.1.1 anaconda-project 0.10.1 annotated-types 0.6.0 anyio 3.5.0 apache-airflow 2.10.0 apache-airflow-providers-amazon 8.7.0 apache-airflow-providers-common-compat 1.1.0 apache-airflow-providers-common-io 1.3.0 apache-airflow-providers-common-sql 1.7.2 apache-airflow-providers-fab 1.0.2 apache-airflow-providers-ftp 3.5.2 apache-airflow-providers-http 4.5.2 apache-airflow-providers-imap 3.3.2 apache-airflow-providers-microsoft-mssql 3.4.2 apache-airflow-providers-mysql 5.3.1 apache-airflow-providers-postgres 5.6.1 apache-airflow-providers-slack 7.3.1 apache-airflow-providers-smtp 1.6.1 apache-airflow-providers-sqlite 3.4.3 apache-airflow-providers-ssh 3.7.3 apispec 6.3.0 appdirs 1.4.4 argcomplete 1.12.3 argh 0.26.2 argon2-cffi 20.1.0 arrow 0.13.1 asgiref 3.6.0 asn1crypto 1.5.1 astroid 2.6.6 astropy 4.3.1 async-generator 1.10 async-timeout 4.0.2 atomicwrites 1.4.0 attrs 23.1.0 autopep8 1.5.7 azure-common 1.1.28 azure-nspkg 3.0.2 Babel 2.10.1 backcall 0.2.0 backoff 2.2.1 backports.functools-lru-cache 1.6.4 backports.shutil-get-terminal-size 1.0.0 backports.tempfile 1.0 backports.weakref 1.0.post1 bcrypt 3.2.0 beautifulsoup4 4.10.0 billiard 3.6.4.0 binaryornot 0.4.4 bitarray 2.3.0 bkcharts 0.2 black 19.10b0 bleach 4.0.0 blinker 1.7.0 bokeh 2.4.3 boto 2.49.0 boto3 1.28.45 botocore 1.31.45 Bottleneck 1.3.2 brotlipy 0.7.0 cached-property 1.5.2 cachelib 0.9.0 cachetools 4.2.2 cattrs 22.1.0 certifi 2020.12.5 cffi 1.15.0 chardet 4.0.0 charset-normalizer 2.0.12 click 8.1.2 clickclick 20.10.2 cloudpickle 2.0.0 clyent 1.2.2 colorama 0.4.4 colorlog 6.8.2 commonmark 0.9.1 conda 4.10.3 conda-build 3.21.5 conda-content-trust 0+unknown conda-pack 0.6.0 conda-package-handling 1.7.3 conda-repo-cli 1.0.4 conda-token 0.3.0 conda-verify 3.4.2 ConfigUpdater 3.1.1 confire 0.2.0 connexion 2.14.2 contextlib2 0.6.0.post1 crcmod 1.7 cron-descriptor 1.2.24 croniter 2.0.3 cryptography 42.0.5 cx-Oracle 8.3.0 cycler 0.10.0 Cython 0.29.24 cytoolz 0.11.0 daal4py 2021.3.0 dask 2022.10.2 debugpy 1.4.1 decorator 5.1.0 defusedxml 0.7.1 Deprecated 1.2.13 diff-match-patch 20200713 dill 0.3.1.1 distlib 0.3.4 distributed 2022.10.2 dnspython 2.2.1 docopt 0.6.2 docutils 0.18.1 email-validator 1.2.0 entrypoints 0.3 et-xmlfile 1.1.0 eventlet 0.33.0 exceptiongroup 1.0.0rc9 execnet 1.9.0 executing 0.8.3 fastavro 1.4.10 fastcache 1.1.0 fastjsonschema 2.15.3 filelock 3.6.0 fissix 21.11.13 flake8 3.9.2 flaky 3.7.0 Flask 2.2.2 Flask-AppBuilder 4.4.1 Flask-Babel 2.0.0 Flask-Caching 2.3.0 Flask-JWT-Extended 4.4.2 Flask-Limiter 3.3.0 Flask-Login 0.6.2 Flask-OpenID 1.3.0 Flask-Session 0.4.0 Flask-SQLAlchemy 2.5.1 Flask-WTF 1.2.1 fonttools 4.25.0 frozenlist 1.3.0 fsspec 2023.12.2 future 0.18.2 geoip2 4.5.0 geomet 0.2.1.post1 gevent 21.8.0 glob2 0.7 gmpy2 2.0.8 google-analytics-data 0.12.1 google-api-core 1.31.5 google-api-python-client 2.52.0 google-auth 1.35.0 google-auth-httplib2 0.1.0 google-auth-oauthlib 0.5.0 google-crc32c 1.3.0 google-re2 1.1 google-resumable-media 2.3.2 googleapis-common-protos 1.54.0 graphviz 0.20 greenlet 1.1.2 grpcio 1.44.0 gspread 5.8.0 gspread-dataframe 3.2.2 gunicorn 20.1.0 h11 0.14.0 h5py 3.3.0 HeapDict 1.0.1 html5lib 1.1 httpcore 1.0.5 httplib2 0.19.1 httpx 0.27.0 humanize 4.0.0 hypothesis 6.54.6 identify 2.4.12 idna 3.3 ijson 3.1.4 imagecodecs 2021.8.26 imageio 2.9.0 imagesize 1.3.0 importlib_metadata 7.1.0 importlib-resources 5.12.0 incremental 21.3.0 inflection 0.5.1 iniconfig 1.1.1 intervaltree 3.1.0 ipykernel 6.4.1 ipython 7.29.0 ipython-genutils 0.2.0 ipywidgets 7.6.5 iso8601 1.0.2 isodate 0.6.1 isort 5.9.3 itsdangerous 2.1.2 JayDeBeApi 1.2.3 jdcal 1.4.1 jedi 0.18.0 jeepney 0.8.0 Jinja2 3.0.3 jinja2-time 0.2.0 jmespath 0.10.0 joblib 1.1.0 JPype1 1.3.0 json-merge-patch 0.2 json5 0.9.6 jsondiff 2.0.0 jsonpath-ng 1.5.3 jsonschema 4.19.0 jsonschema-specifications 2023.7.1 jupyter 1.0.0 jupyter-client 6.1.12 jupyter-console 6.4.0 jupyter-core 4.10.0 jupyter-server 1.4.1 jupyterlab 3.2.1 jupyterlab-pygments 0.1.2 jupyterlab-server 2.8.2 jupyterlab-widgets 1.0.0 keyring 23.1.0 kiwisolver 1.3.1 krb5 0.3.0 kylinpy 2.8.4 lazy-object-proxy 1.7.1 ldap3 2.9.1 libarchive-c 2.9 limits 3.4.0 linkify-it-py 2.0.0 llvmlite 0.37.0 locket 1.0.0 lockfile 0.12.2 luigi 3.0.3 lxml 4.8.0 mailchimp-marketing 3.0.80 Mako 1.2.0 Markdown 3.3.6 markdown-it-py 2.1.0 MarkupSafe 2.1.1 marshmallow 3.20.1 marshmallow-enum 1.5.1 marshmallow-oneofschema 3.0.1 marshmallow-sqlalchemy 0.26.1 matplotlib 3.4.3 matplotlib-inline 0.1.3 maxminddb 2.2.0 mccabe 0.6.1 mdit-py-plugins 0.3.0 mdurl 0.1.1 methodtools 0.4.7 mistune 0.8.4 mkl-fft 1.3.1 mkl-random 1.2.2 mkl-service 2.4.0 mock 4.0.3 monotonic 1.6 more-itertools 8.10.0 moreorless 0.4.0 mpmath 1.2.1 msgpack 1.0.3 multi-key-dict 2.0.3 multidict 6.0.2 multipledispatch 0.6.0 munkres 1.1.4 mypy 0.910 mypy-boto3-appflow 1.24.36.post1 mypy-boto3-rds 1.26.144 mypy-boto3-redshift-data 1.26.109 mypy-boto3-s3 1.26.155 mypy-extensions 0.4.3 mysql-connector-python 8.0.28 mysqlclient 2.1.0 navigator-updater 0.2.1 nbclassic 0.2.6 nbclient 0.5.3 nbconvert 6.1.0 nbformat 5.1.3 neo4j 4.4.3 nest-asyncio 1.5.5 networkx 2.6.3 nltk 3.6.5 nodeenv 1.6.0 nose 1.3.7 notebook 6.4.5 ntlm-auth 1.5.0 numba 0.54.1 numexpr 2.7.3 numpy 1.22.3 numpydoc 1.1.0 oauth2client 4.1.3 oauthlib 3.2.0 olefile 0.46 openapi-schema-validator 0.1.6 openapi-spec-validator 0.3.3 openpyxl 3.0.9 opentelemetry-api 1.15.0 opentelemetry-exporter-otlp 1.15.0 opentelemetry-exporter-otlp-proto-grpc 1.15.0 opentelemetry-exporter-otlp-proto-http 1.15.0 opentelemetry-proto 1.15.0 opentelemetry-sdk 1.15.0 opentelemetry-semantic-conventions 0.36b0 ordered-set 4.1.0 orjson 3.6.8 oscrypto 1.3.0 packaging 23.2 pandas 1.3.4 pandocfilters 1.4.3 parameterized 0.8.1 paramiko 2.9.2 parso 0.8.3 partd 1.2.0 path 16.0.0 pathlib 1.0.1 pathlib2 2.3.6 pathspec 0.9.0 patsy 0.5.2 pbr 5.8.1 pendulum 2.1.2 pep8 1.7.1 petl 1.7.8 pexpect 4.8.0 pickleshare 0.7.5 Pillow 8.4.0 pip 24.2 pipdeptree 2.2.1 pkginfo 1.8.2 platformdirs 2.5.2 pluggy 1.5.0 ply 3.11 plyvel 1.4.0 portalocker 2.4.0 poyo 0.5.0 prison 0.2.1 prometheus-client 0.14.1 prompt-toolkit 3.0.29 proto-plus 1.20.6 protobuf 3.20.1 psutil 5.9.0 psycopg2 2.9.3 psycopg2-binary 2.9.3 ptyprocess 0.7.0 pure-eval 0.2.2 pure-sasl 0.6.2 py 1.11.0 py4j 0.10.9.3 pyarrow 10.0.0 pyasn1 0.4.8 pyasn1-modules 0.2.8 pycodestyle 2.8.0 pycosat 0.6.3 pycountry 22.3.5 pycparser 2.21 pycryptodome 3.14.1 pycryptodomex 3.14.1 pycurl 7.44.1 pydantic 2.5.2 pydantic_core 2.14.5 pydocstyle 6.1.1 pydot 1.4.2 pyenchant 3.2.2 pyerfa 2.0.0 pyflakes 2.4.0 Pygments 2.12.0 PyJWT 2.6.0 pykerberos 1.2.4 pylint 2.9.6 pyls-spyder 0.4.0 pymongo 3.12.3 pymssql 2.2.5 PyNaCl 1.5.0 pyodbc 4.0.32 pyOpenSSL 24.1.0 pyparsing 2.4.7 pyrsistent 0.18.1 pysftp 0.2.9 PySocks 1.7.1 pyspark 3.2.1 pytest 6.2.4 python-daemon 3.0.1 python-dateutil 2.8.2 python-http-client 3.3.7 python-lsp-black 1.0.0 python-lsp-jsonrpc 1.0.0 python-lsp-server 1.2.4 python-nvd3 0.15.0 python-slugify 6.1.1 python3-openid 3.2.0 pytz 2021.3 pytzdata 2020.1 PyWavelets 1.1.1 pyxdg 0.27 PyYAML 5.4.1 pyzmq 22.3.0 QDarkStyle 3.0.2 qstylizer 0.1.10 QtAwesome 1.0.2 qtconsole 5.1.1 QtPy 1.10.0 redis 3.5.3 redshift-connector 2.0.904 referencing 0.30.2 regex 2021.8.3 requests 2.27.1 requests-oauthlib 1.3.1 requests-toolbelt 1.0.0 rfc3339-validator 0.1.4 rfc3986 1.5.0 rich 12.6.0 rich_argparse 1.1.0 rope 0.19.0 rpds-py 0.10.0 rsa 4.8 Rtree 0.9.7 ruamel-yaml-conda 0.15.100 Rx 3.2.0 s3transfer 0.6.1 sasl 0.3.1 scikit-image 0.18.3 scikit-learn 0.24.2 scikit-learn-intelex 2021.20210714.170444 scipy 1.7.1 scramp 1.4.1 seaborn 0.11.2 SecretStorage 3.3.1 semver 2.13.0 Send2Trash 1.8.0 sendgrid 6.9.7 sentinels 1.0.0 sentry-sdk 1.5.10 setproctitle 1.3.3 setuptools 67.7.2 simplegeneric 0.8.1 singledispatch 3.7.0 sip 4.19.13 six 1.16.0 slack-sdk 3.15.2 slackclient 1.3.2 smmap 5.0.0 sniffio 1.2.0 snowballstemmer 2.2.0 sortedcollections 2.1.0 sortedcontainers 2.4.0 soupsieve 2.3.2.post1 Sphinx 5.3.0 sphinxcontrib-applehelp 1.0.2 sphinxcontrib-devhelp 1.0.2 sphinxcontrib-htmlhelp 2.0.0 sphinxcontrib-jsmath 1.0.1 sphinxcontrib-qthelp 1.0.3 sphinxcontrib-serializinghtml 1.1.5 sphinxcontrib-websupport 1.2.4 spyder-kernels 2.1.3 SQLAlchemy 1.4.50 SQLAlchemy-JSONField 1.0.0 sqlalchemy-redshift 0.8.9 SQLAlchemy-Utils 0.38.2 sqlparse 0.4.2 sshtunnel 0.4.0 starkbank-ecdsa 2.0.3 statsd 3.3.0 statsmodels 0.12.2 swagger-ui-bundle 0.0.9 sympy 1.9 tables 3.6.1 tabulate 0.8.9 TBB 0.2 tblib 1.7.0 tenacity 8.0.1 termcolor 1.1.0 terminado 0.9.4 testpath 0.5.0 text-unidecode 1.3 textdistance 4.2.1 textwrap3 0.9.2 threadpoolctl 2.2.0 three-merge 0.1.1 thrift 0.16.0 tifffile 2021.7.2 tinycss 0.4 toml 0.10.2 tomli 2.0.1 toolz 0.11.2 tornado 6.1 tqdm 4.64.0 traitlets 5.1.1 typed-ast 1.4.3 types-boto 2.49.14 types-certifi 2021.10.8.1 types-croniter 1.0.9 types-cryptography 3.3.20 types-Deprecated 1.2.6 types-docutils 0.18.3 types-freezegun 1.1.9 types-Markdown 3.3.13 types-paramiko 2.8.19 types-protobuf 3.19.18 types-PyMySQL 1.0.18 types-python-dateutil 2.8.12 types-python-slugify 5.0.4 types-pytz 2021.3.6 types-PyYAML 6.0.7 types-redis 4.2.0 types-requests 2.27.20 types-setuptools 57.4.14 types-six 1.16.15 types-tabulate 0.8.7 types-termcolor 1.1.3 types-toml 0.10.5 types-urllib3 1.26.13 typing_extensions 4.9.0 tzdata 2022.1 ua-parser 0.10.0 uc-micro-py 1.0.1 ujson 4.0.2 unicodecsv 0.14.1 Unidecode 1.3.4 universal_pathlib 0.2.2 uritemplate 3.0.1 urllib3 1.26.9 userpath 1.8.0 vine 5.0.0 volatile 2.1.0 watchdog 2.1.3 watchtower 2.0.1 wcwidth 0.2.5 webencodings 0.5.1 websocket-client 1.3.2 Werkzeug 2.2.2 wheel 0.37.0 whichcraft 0.6.1 widgetsnbextension 3.5.1 wirerope 0.4.7 wrapt 1.14.0 WTForms 2.3.3 wurlitzer 2.1.1 xlrd 2.0.1 XlsxWriter 3.0.1 xlwt 1.3.0 xmltodict 0.12.0 yamllint 1.26.3 yapf 0.31.0 yarl 1.7.2 zict 2.1.0 zipp 3.8.0 zope.event 4.5.0 zope.interface 5.4.0 ``` `pip install --upgrade apache-airflow` (from 2.8.1) `airflow db migrate` ### Operating System CentOS 7 ### Versions of Apache Airflow Providers ``` apache-airflow-providers-amazon==8.7.0 apache-airflow-providers-common-compat==1.1.0 apache-airflow-providers-common-io==1.3.0 apache-airflow-providers-common-sql==1.7.2 apache-airflow-providers-fab==1.0.2 apache-airflow-providers-ftp==3.5.2 apache-airflow-providers-http==4.5.2 apache-airflow-providers-imap==3.3.2 apache-airflow-providers-microsoft-mssql==3.4.2 apache-airflow-providers-mysql==5.3.1 apache-airflow-providers-postgres==5.6.1 apache-airflow-providers-slack==7.3.1 apache-airflow-providers-smtp==1.6.1 apache-airflow-providers-sqlite==3.4.3 apache-airflow-providers-ssh==3.7.3 ``` ### Deployment Virtualenv installation ### Deployment details _No response_ ### Anything else? Thisn is the first time this warning has popped up. ### 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
