[
https://issues.apache.org/jira/browse/AIRFLOW-3453?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ping Zhang updated AIRFLOW-3453:
--------------------------------
Description:
macOS Mojave, _10.14.1_;
Mysql:
_Your MySQL connection id is 6034_
_Server version: 8.0.12 Homebrew_
Right after I ran `airflow initdb`,
{code:java}
_$ 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']
{code}
was:
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']_
> 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
> Priority: Major
>
> macOS Mojave, _10.14.1_;
> Mysql:
> _Your MySQL connection id is 6034_
> _Server version: 8.0.12 Homebrew_
>
> Right after I ran `airflow initdb`,
> {code:java}
>
>
> _$ 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']
>
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
