From commits-return-13294-archive-asf-public=cust-asf.ponee.io@airflow.incubator.apache.org Fri Mar 16 17:02:06 2018 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id 13B5818067B for ; Fri, 16 Mar 2018 17:02:05 +0100 (CET) Received: (qmail 64095 invoked by uid 500); 16 Mar 2018 16:02:05 -0000 Mailing-List: contact commits-help@airflow.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@airflow.incubator.apache.org Delivered-To: mailing list commits@airflow.incubator.apache.org Received: (qmail 64086 invoked by uid 99); 16 Mar 2018 16:02:05 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 16 Mar 2018 16:02:05 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id 9D7A11A015E for ; Fri, 16 Mar 2018 16:02:04 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -100.761 X-Spam-Level: X-Spam-Status: No, score=-100.761 tagged_above=-999 required=6.31 tests=[KAM_ASCII_DIVIDERS=0.8, KAM_INFOUSMEBIZ=0.75, RCVD_IN_DNSWL_MED=-2.3, SPF_PASS=-0.001, T_RP_MATCHES_RCVD=-0.01, USER_IN_WHITELIST=-100] autolearn=disabled Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id uaLeiAROHIrM for ; Fri, 16 Mar 2018 16:02:02 +0000 (UTC) Received: from mailrelay1-us-west.apache.org (mailrelay1-us-west.apache.org [209.188.14.139]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTP id 8ED915F6BE for ; Fri, 16 Mar 2018 16:02:01 +0000 (UTC) Received: from jira-lw-us.apache.org (unknown [207.244.88.139]) by mailrelay1-us-west.apache.org (ASF Mail Server at mailrelay1-us-west.apache.org) with ESMTP id 98051E00D1 for ; Fri, 16 Mar 2018 16:02:00 +0000 (UTC) Received: from jira-lw-us.apache.org (localhost [127.0.0.1]) by jira-lw-us.apache.org (ASF Mail Server at jira-lw-us.apache.org) with ESMTP id 4B27421277 for ; Fri, 16 Mar 2018 16:02:00 +0000 (UTC) Date: Fri, 16 Mar 2018 16:02:00 +0000 (UTC) From: "sulphide (JIRA)" To: commits@airflow.incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (AIRFLOW-2223) sql error with resetdb, upgradedb after upgrading airflow (same error) MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/AIRFLOW-2223?page=3Dcom.atlass= ian.jira.plugin.system.issuetabpanels:all-tabpanel ] sulphide updated AIRFLOW-2223: ------------------------------ Summary: sql error with resetdb, upgradedb after upgrading airflow (sam= e error) (was: sql error with resetdb, upgradedb after upgrading to airflo= w 1.9 (same error)) > sql error with resetdb, upgradedb after upgrading airflow (same error) > ---------------------------------------------------------------------- > > Key: AIRFLOW-2223 > URL: https://issues.apache.org/jira/browse/AIRFLOW-2223 > Project: Apache Airflow > Issue Type: Bug > Reporter: sulphide > Priority: Major > > =C2=A0 > =C2=A0 > $ airflow resetdb > [2018-03-16 15:49:39,020] {__init__.py:45} INFO - Using executor LocalExe= cutor > 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 MySQLI= mpl. > [2018-03-16 15:49:42,757] \{migration.py:121} INFO - Will assume non-tra= nsactional 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 -> 1507a728= 9a2f, create is_encrypted > INFO [alembic.runtime.migration] Running upgrade 1507a7289a2f -> 13eb55f= 81627, maintain history for compatibility with earlier migrations > INFO [alembic.runtime.migration] Running upgrade 13eb55f81627 -> 338e90f= 54d61, More logging into task_isntance > INFO [alembic.runtime.migration] Running upgrade 338e90f54d61 -> 52d7144= 95f0, job_id indices > INFO [alembic.runtime.migration] Running upgrade 52d714495f0 -> 50289888= 7f84, Adding extra to Log > INFO [alembic.runtime.migration] Running upgrade 502898887f84 -> 1b38cef= 5b76e, add dagrun > INFO [alembic.runtime.migration] Running upgrade 1b38cef5b76e -> 2e541a1= dcfed, task_duration > INFO [alembic.runtime.migration] Running upgrade 2e541a1dcfed -> 40e6731= 9e3a9, dagrun_config > INFO [alembic.runtime.migration] Running upgrade 40e67319e3a9 -> 561833c= 1c74b, add password column to user > Traceback (most recent call last): > .... > File "/home/ec2-user/.virtualenvs/a/lib/python2.7/site-packages/sqlalche= my/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) (1= 060, "Duplicate column name 'password'") [SQL: u'ALTER TABLE user ADD COLUM= N 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=3D=3D1.9.0 -- This message was sent by Atlassian JIRA (v7.6.3#76005)