Uploaded image for project: 'Apache Airflow'
  1. Apache Airflow
  2. AIRFLOW-6813

Error while running airflow resetdb with SQL Server as backend

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Blocker
    • Resolution: Unresolved
    • Affects Version/s: 1.10.9
    • Fix Version/s: None
    • Component/s: database
    • Labels:
      None
    • Environment:
      Cent OS 6 environment

      Description

      I am connecting my Airflow with the MS SQL Server backend. airflow initdb works fine.

      However when I do airflow resetdb I get the following error

       
       
      INFO [alembic.runtime.migration] Running upgrade 939bb1e647c8 -> 004c1210f153, increase queue name size limit

      INFO [alembic.runtime.migration] Running upgrade c8ffec048a3b -> a56c9515abdc, Remove dag_stat table

      INFO [alembic.runtime.migration] Running upgrade a56c9515abdc, 004c1210f153, 74effc47d867, b3b105409875 -> 08364691d074, Merge the four heads back together

      INFO [alembic.runtime.migration] Running upgrade 08364691d074 -> fe461863935f, increase_length_for_connection_password

      INFO [alembic.runtime.migration] Running upgrade fe461863935f -> 7939bcff74ba, Add DagTags table

      WARNI [airflow.utils.log.logging_mixin.LoggingMixin] empty cryptography key - values will not be stored encrypted.

      Exception ignored in: <function _ConnectionRecord.checkout.<locals>.<lambda> at 0x7f657bf272f0>Traceback (most recent call last):File "/home/ops/.pyenv/versions/3.6.10/envs/airflow_env/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 503, in <lambda>File "/home/ops/.pyenv/versions/3.6.10/envs/airflow_env/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 710, in _finalize_fairy File "/home/ops/.pyenv/versions/3.6.10/envs/airflow_env/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 528, in checkin File "/home/ops/.pyenv/versions/3.6.10/envs/airflow_env/lib/python3.6/site-packages/sqlalchemy/pool/base.py", line 387, in _return_conn File "/home/ops/.pyenv/versions/3.6.10/envs/airflow_env/lib/python3.6/site-packages/sqlalchemy/pool/impl.py", line 106, in _do_return_conn

      TypeError: catching classes that do not inherit from BaseException is not allowed

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              amith1893 Amith Gopal
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: