[
https://issues.apache.org/jira/browse/AIRFLOW-2223?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
sulphide updated AIRFLOW-2223:
------------------------------
Description:
$ airflow resetdb
[2018-03-16 15:49:39,020] \{__init__.py:45} INFO - Using executor LocalExecutor
DB: mysql://.......
This will drop existing tables if they exist. Proceed? (y/n)y
[2018-03-16 15:49:42,364] \{db.py:331} INFO - Dropping tables that exist
[2018-03-16 15:49:42,757] \{migration.py:116} INFO - Context impl MySQLImpl.
[2018-03-16 15:49:42,757] \{migration.py:121} INFO - Will assume
non-transactional DDL.
[2018-03-16 15:49:42,791] \{db.py:312} INFO - Creating tables
INFO [alembic.runtime.migration] Context impl MySQLImpl.
INFO [alembic.runtime.migration] Will assume non-transactional DDL.
INFO [alembic.runtime.migration] Running upgrade -> e3a246e0dc1, current schema
INFO [alembic.runtime.migration] Running upgrade e3a246e0dc1 -> 1507a7289a2f,
create is_encrypted
INFO [alembic.runtime.migration] Running upgrade 1507a7289a2f -> 13eb55f81627,
maintain history for compatibility with earlier migrations
INFO [alembic.runtime.migration] Running upgrade 13eb55f81627 -> 338e90f54d61,
More logging into task_isntance
INFO [alembic.runtime.migration] Running upgrade 338e90f54d61 -> 52d714495f0,
job_id indices
INFO [alembic.runtime.migration] Running upgrade 52d714495f0 -> 502898887f84,
Adding extra to Log
INFO [alembic.runtime.migration] Running upgrade 502898887f84 -> 1b38cef5b76e,
add dagrun
INFO [alembic.runtime.migration] Running upgrade 1b38cef5b76e -> 2e541a1dcfed,
task_duration
INFO [alembic.runtime.migration] Running upgrade 2e541a1dcfed -> 40e67319e3a9,
dagrun_config
INFO [alembic.runtime.migration] Running upgrade 40e67319e3a9 -> 561833c1c74b,
add password column to user
Traceback (most recent call last):
....
File
"/home/ec2-user/.virtualenvs/a/lib/python2.7/site-packages/sqlalchemy/engine/default.py",
line 507, in do_execute
cursor.execute(statement, parameters)
File
"/home/ec2-user/.virtualenvs/a/lib/python2.7/site-packages/MySQLdb/cursors.py",
line 250, in execute
self.errorhandler(self, exc, value)
File
"/home/ec2-user/.virtualenvs/a/lib/python2.7/site-packages/MySQLdb/connections.py",
line 50, in defaulterrorhandler
raise errorvalue
sqlalchemy.exc.OperationalError: (_mysql_exceptions.OperationalError) (1060,
"Duplicate column name 'password'") [SQL: u'ALTER TABLE user ADD COLUMN
password VARCHAR(255)'] (Background on this error at: http://sqlalche.me/e/e3q8)
(coeus) [ec2-user@ip-10-14-106-140 ~]$ pip freeze | grep airflow
apache-airflow==1.9.0
$ airflow upgradedb
> sql error with resetdb and upgradedb for airflow 1.9
> ----------------------------------------------------
>
> Key: AIRFLOW-2223
> URL: https://issues.apache.org/jira/browse/AIRFLOW-2223
> Project: Apache Airflow
> Issue Type: Bug
> Reporter: sulphide
> Priority: Major
>
> $ airflow resetdb
> [2018-03-16 15:49:39,020] \{__init__.py:45} INFO - Using executor
> LocalExecutor
> DB: mysql://.......
> This will drop existing tables if they exist. Proceed? (y/n)y
> [2018-03-16 15:49:42,364] \{db.py:331} INFO - Dropping tables that exist
> [2018-03-16 15:49:42,757] \{migration.py:116} INFO - Context impl MySQLImpl.
> [2018-03-16 15:49:42,757] \{migration.py:121} INFO - Will assume
> non-transactional DDL.
> [2018-03-16 15:49:42,791] \{db.py:312} INFO - Creating tables
> INFO [alembic.runtime.migration] Context impl MySQLImpl.
> INFO [alembic.runtime.migration] Will assume non-transactional DDL.
> INFO [alembic.runtime.migration] Running upgrade -> e3a246e0dc1, current
> schema
> INFO [alembic.runtime.migration] Running upgrade e3a246e0dc1 -> 1507a7289a2f,
> create is_encrypted
> INFO [alembic.runtime.migration] Running upgrade 1507a7289a2f ->
> 13eb55f81627, maintain history for compatibility with earlier migrations
> INFO [alembic.runtime.migration] Running upgrade 13eb55f81627 ->
> 338e90f54d61, More logging into task_isntance
> INFO [alembic.runtime.migration] Running upgrade 338e90f54d61 -> 52d714495f0,
> job_id indices
> INFO [alembic.runtime.migration] Running upgrade 52d714495f0 -> 502898887f84,
> Adding extra to Log
> INFO [alembic.runtime.migration] Running upgrade 502898887f84 ->
> 1b38cef5b76e, add dagrun
> INFO [alembic.runtime.migration] Running upgrade 1b38cef5b76e ->
> 2e541a1dcfed, task_duration
> INFO [alembic.runtime.migration] Running upgrade 2e541a1dcfed ->
> 40e67319e3a9, dagrun_config
> INFO [alembic.runtime.migration] Running upgrade 40e67319e3a9 ->
> 561833c1c74b, add password column to user
> Traceback (most recent call last):
> ....
> File
> "/home/ec2-user/.virtualenvs/a/lib/python2.7/site-packages/sqlalchemy/engine/default.py",
> line 507, in do_execute
> cursor.execute(statement, parameters)
> File
> "/home/ec2-user/.virtualenvs/a/lib/python2.7/site-packages/MySQLdb/cursors.py",
> line 250, in execute
> self.errorhandler(self, exc, value)
> File
> "/home/ec2-user/.virtualenvs/a/lib/python2.7/site-packages/MySQLdb/connections.py",
> line 50, in defaulterrorhandler
> raise errorvalue
> sqlalchemy.exc.OperationalError: (_mysql_exceptions.OperationalError) (1060,
> "Duplicate column name 'password'") [SQL: u'ALTER TABLE user ADD COLUMN
> password VARCHAR(255)'] (Background on this error at:
> http://sqlalche.me/e/e3q8)
> (coeus) [ec2-user@ip-10-14-106-140 ~]$ pip freeze | grep airflow
> apache-airflow==1.9.0
>
>
> $ airflow upgradedb
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
