[jira] [Created] (AIRFLOW-3453) Failed to run airflow resetdb

["Ping Zhang (JIRA)" <ji...@apache.org>]

Ping Zhang created AIRFLOW-3453:
-----------------------------------

             Summary: Failed to run airflow resetdb
                 Key: AIRFLOW-3453
                 URL: https://issues.apache.org/jira/browse/AIRFLOW-3453
             Project: Apache Airflow
          Issue Type: Bug
          Components: database
    Affects Versions: 1.10.1
         Environment: macOS Mojave, 10.14.1;
            Reporter: Ping Zhang


macOS Mojave, _10.14.1_;

Mysql: 

_Your MySQL connection id is 6034_
_Server version: 8.0.12 Homebrew_

 

Right after I ran `airflow initdb`, 

 

 

_$ airflow resetdb -y
[2018-12-05 16:13:49,427] \{settings.py:174} INFO - setting.configure_orm(): Using pool settings. pool_size=5, pool_recycle=1800
[2018-12-05 16:13:49,744] \{__init__.py:51} INFO - Using executor CeleryExecutor
DB: mysql://root:***@localhost/airflow
[2018-12-05 16:13:49,973] \{db.py:358} INFO - Dropping tables that exist
/Users/ping_zhang/anaconda2/envs/apache-airflow/lib/python2.7/site-packages/sqlalchemy/engine/default.py:470: Warning: (3719L, "'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.")
cursor.execute(statement, parameters)
Traceback (most recent call last):
File "/Users/ping_zhang/anaconda2/envs/apache-airflow/bin/airflow", line 4, in <module>
__import__('pkg_resources').run_script('apache-airflow==1.10.1', 'airflow')
File "/Users/ping_zhang/anaconda2/envs/apache-airflow/lib/python2.7/site-packages/pkg_resources/__init__.py", line 664, in run_script
self.require(requires)[0].run_script(script_name, ns)
File "/Users/ping_zhang/anaconda2/envs/apache-airflow/lib/python2.7/site-packages/pkg_resources/__init__.py", line 1444, in run_script
exec(code, namespace, namespace)
File "/Users/ping_zhang/anaconda2/envs/apache-airflow/lib/python2.7/site-packages/apache_airflow-1.10.1-py2.7.egg/EGG-INFO/scripts/airflow", line 32, in <module>
args.func(args)
File "/Users/ping_zhang/anaconda2/envs/apache-airflow/lib/python2.7/site-packages/apache_airflow-1.10.1-py2.7.egg/airflow/bin/cli.py", line 1020, in resetdb
db_utils.resetdb(settings.RBAC)
File "/Users/ping_zhang/anaconda2/envs/apache-airflow/lib/python2.7/site-packages/apache_airflow-1.10.1-py2.7.egg/airflow/utils/db.py", line 360, in resetdb
models.Base.metadata.drop_all(settings.engine)
File "/Users/ping_zhang/anaconda2/envs/apache-airflow/lib/python2.7/site-packages/sqlalchemy/sql/schema.py", line 3976, in drop_all
tables=tables)
File "/Users/ping_zhang/anaconda2/envs/apache-airflow/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1929, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/Users/ping_zhang/anaconda2/envs/apache-airflow/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1538, in _run_visitor
**kwargs).traverse_single(element)
File "/Users/ping_zhang/anaconda2/envs/apache-airflow/lib/python2.7/site-packages/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/Users/ping_zhang/anaconda2/envs/apache-airflow/lib/python2.7/site-packages/sqlalchemy/sql/ddl.py", line 874, in visit_metadata
table, drop_ok=True, _is_metadata_operation=True)
File "/Users/ping_zhang/anaconda2/envs/apache-airflow/lib/python2.7/site-packages/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/Users/ping_zhang/anaconda2/envs/apache-airflow/lib/python2.7/site-packages/sqlalchemy/sql/ddl.py", line 923, in visit_table
self.connection.execute(DropTable(table))
File "/Users/ping_zhang/anaconda2/envs/apache-airflow/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 945, in execute
return meth(self, multiparams, params)
File "/Users/ping_zhang/anaconda2/envs/apache-airflow/lib/python2.7/site-packages/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/Users/ping_zhang/anaconda2/envs/apache-airflow/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1002, in _execute_ddl
compiled
File "/Users/ping_zhang/anaconda2/envs/apache-airflow/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1189, in _execute_context
context)
File "/Users/ping_zhang/anaconda2/envs/apache-airflow/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1402, in _handle_dbapi_exception
exc_info
File "/Users/ping_zhang/anaconda2/envs/apache-airflow/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/Users/ping_zhang/anaconda2/envs/apache-airflow/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1182, in _execute_context
context)
File "/Users/ping_zhang/anaconda2/envs/apache-airflow/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 470, in do_execute
cursor.execute(statement, parameters)
File "/Users/ping_zhang/anaconda2/envs/apache-airflow/lib/python2.7/site-packages/MySQLdb/cursors.py", line 250, in execute
self.errorhandler(self, exc, value)
File "/Users/ping_zhang/anaconda2/envs/apache-airflow/lib/python2.7/site-packages/MySQLdb/connections.py", line 50, in defaulterrorhandler
raise errorvalue
sqlalchemy.exc.OperationalError: (_mysql_exceptions.OperationalError) (3730, "Cannot drop table 'task_instance' referenced by a foreign key constraint 'task_reschedule_dag_task_date_fkey' on table 'task_reschedule'.") [SQL: u'\nDROP TABLE task_instance']_

 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)