Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 41629200CE6 for ; Fri, 15 Sep 2017 21:17:09 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 3FF481609D1; Fri, 15 Sep 2017 19:17:09 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 369991609C9 for ; Fri, 15 Sep 2017 21:17:08 +0200 (CEST) Received: (qmail 44892 invoked by uid 500); 15 Sep 2017 19:17:06 -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 44795 invoked by uid 99); 15 Sep 2017 19:17:06 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 15 Sep 2017 19:17:06 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id C9A211853D6 for ; Fri, 15 Sep 2017 19:17:05 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -100.001 X-Spam-Level: X-Spam-Status: No, score=-100.001 tagged_above=-999 required=6.31 tests=[RP_MATCHES_RCVD=-0.001, SPF_PASS=-0.001, URIBL_BLOCKED=0.001, USER_IN_WHITELIST=-100] autolearn=disabled Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id Y3fuAj3OudG9 for ; Fri, 15 Sep 2017 19:17: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 BEAD760D33 for ; Fri, 15 Sep 2017 19:17: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 017DFE0217 for ; Fri, 15 Sep 2017 19:17:01 +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 930E825381 for ; Fri, 15 Sep 2017 19:17:00 +0000 (UTC) Date: Fri, 15 Sep 2017 19:17:00 +0000 (UTC) From: "Alison Stanton (JIRA)" To: commits@airflow.incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (AIRFLOW-1616) (sqlite3.OperationalError) no such table: task_instance MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 archived-at: Fri, 15 Sep 2017 19:17:09 -0000 [ https://issues.apache.org/jira/browse/AIRFLOW-1616?page=3Dcom.atlass= ian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alison Stanton updated AIRFLOW-1616: ------------------------------------ Description:=20 I am going through the [tutorial](https://pythonhosted.org/airflow/tutorial= .html) and when I get to `airflow test tutorial print_date 2015-06-01` I st= art getting errors (whether the webserver is running or not). Specifically I get: ``` (pp_airflow) Alisons-MacBook-Air:pp-airflow alison$ airflow test tutorial t= emplated 2017-09-15 [2017-09-15 13:58:16,638] {__init__.py:57} INFO - Using executor Sequential= Executor /Users/alison/Envs/pp_airflow/lib/python2.7/site-packages/airflow/www/app.p= y:23: FlaskWTFDeprecationWarning: "flask_wtf.CsrfProtect" has been renamed = to "CSRFProtect" and will be removed in 1.0. csrf =3D CsrfProtect() [2017-09-15 13:58:16,913] {models.py:168} INFO - Filling up the DagBag from= /Users/alison/airflow/dags Traceback (most recent call last): File "/Users/alison/Envs/pp_airflow/bin/airflow", line 28, in args.func(args) File "/Users/alison/Envs/pp_airflow/lib/python2.7/site-packages/airflow/b= in/cli.py", line 585, in test ti.run(ignore_task_deps=3DTrue, ignore_ti_state=3DTrue, test_mode=3DTru= e) File "/Users/alison/Envs/pp_airflow/lib/python2.7/site-packages/airflow/u= tils/db.py", line 53, in wrapper result =3D func(*args, **kwargs) File "/Users/alison/Envs/pp_airflow/lib/python2.7/site-packages/airflow/m= odels.py", line 1265, in run self.refresh_from_db(session=3Dsession, lock_for_update=3DTrue) File "/Users/alison/Envs/pp_airflow/lib/python2.7/site-packages/airflow/u= tils/db.py", line 53, in wrapper result =3D func(*args, **kwargs) File "/Users/alison/Envs/pp_airflow/lib/python2.7/site-packages/airflow/m= odels.py", line 993, in refresh_from_db ti =3D qry.with_for_update().first() File "/Users/alison/Envs/pp_airflow/lib/python2.7/site-packages/sqlalchem= y/orm/query.py", line 2755, in first ret =3D list(self[0:1]) File "/Users/alison/Envs/pp_airflow/lib/python2.7/site-packages/sqlalchem= y/orm/query.py", line 2547, in __getitem__ return list(res) File "/Users/alison/Envs/pp_airflow/lib/python2.7/site-packages/sqlalchem= y/orm/query.py", line 2855, in __iter__ return self._execute_and_instances(context) File "/Users/alison/Envs/pp_airflow/lib/python2.7/site-packages/sqlalchem= y/orm/query.py", line 2878, in _execute_and_instances result =3D conn.execute(querycontext.statement, self._params) File "/Users/alison/Envs/pp_airflow/lib/python2.7/site-packages/sqlalchem= y/engine/base.py", line 945, in execute return meth(self, multiparams, params) File "/Users/alison/Envs/pp_airflow/lib/python2.7/site-packages/sqlalchem= y/sql/elements.py", line 263, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "/Users/alison/Envs/pp_airflow/lib/python2.7/site-packages/sqlalchem= y/engine/base.py", line 1053, in _execute_clauseelement compiled_sql, distilled_params File "/Users/alison/Envs/pp_airflow/lib/python2.7/site-packages/sqlalchem= y/engine/base.py", line 1189, in _execute_context context) File "/Users/alison/Envs/pp_airflow/lib/python2.7/site-packages/sqlalchem= y/engine/base.py", line 1402, in _handle_dbapi_exception exc_info File "/Users/alison/Envs/pp_airflow/lib/python2.7/site-packages/sqlalchem= y/util/compat.py", line 203, in raise_from_cause reraise(type(exception), exception, tb=3Dexc_tb, cause=3Dcause) File "/Users/alison/Envs/pp_airflow/lib/python2.7/site-packages/sqlalchem= y/engine/base.py", line 1182, in _execute_context context) File "/Users/alison/Envs/pp_airflow/lib/python2.7/site-packages/sqlalchem= y/engine/default.py", line 470, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table: = task_instance [SQL: u'SELECT task_instance.task_id AS task_instance_task_id= , task_instance.dag_id AS task_instance_dag_id, task_instance.execution_dat= e AS task_instance_execution_date, task_instance.start_date AS task_instanc= e_start_date, task_instance.end_date AS task_instance_end_date, task_instan= ce.duration AS task_instance_duration, task_instance.state AS task_instance= _state, task_instance.try_number AS task_instance_try_number, task_instance= .hostname AS task_instance_hostname, task_instance.unixname AS task_instanc= e_unixname, task_instance.job_id AS task_instance_job_id, task_instance.poo= l AS task_instance_pool, task_instance.queue AS task_instance_queue, task_i= nstance.priority_weight AS task_instance_priority_weight, task_instance.ope= rator AS task_instance_operator, task_instance.queued_dttm AS task_instance= _queued_dttm, task_instance.pid AS task_instance_pid \nFROM task_instance \= nWHERE task_instance.dag_id =3D ? AND task_instance.task_id =3D ? AND task_= instance.execution_date =3D ?\n LIMIT ? OFFSET ?'] [parameters: ('tutorial'= , 'templated', '2017-09-15 00:00:00.000000', 1, 0)] ``` was: I am going through the [tutorial](https://pythonhosted.org/airflow/tutorial= .html) and when I get to `airflow test tutorial print_date 2015-06-01` I st= art getting errors (whether the webserver is running or not). Specifically I get: ``` (pp_airflow) Alisons-MacBook-Air:propublica-airflow alison$ airflow test tu= torial templated 2017-09-15 [2017-09-15 13:58:16,638] {__init__.py:57} INFO - Using executor Sequential= Executor /Users/alison/Envs/pp_airflow/lib/python2.7/site-packages/airflow/www/app.p= y:23: FlaskWTFDeprecationWarning: "flask_wtf.CsrfProtect" has been renamed = to "CSRFProtect" and will be removed in 1.0. csrf =3D CsrfProtect() [2017-09-15 13:58:16,913] {models.py:168} INFO - Filling up the DagBag from= /Users/alison/airflow/dags Traceback (most recent call last): File "/Users/alison/Envs/pp_airflow/bin/airflow", line 28, in args.func(args) File "/Users/alison/Envs/pp_airflow/lib/python2.7/site-packages/airflow/b= in/cli.py", line 585, in test ti.run(ignore_task_deps=3DTrue, ignore_ti_state=3DTrue, test_mode=3DTru= e) File "/Users/alison/Envs/pp_airflow/lib/python2.7/site-packages/airflow/u= tils/db.py", line 53, in wrapper result =3D func(*args, **kwargs) File "/Users/alison/Envs/pp_airflow/lib/python2.7/site-packages/airflow/m= odels.py", line 1265, in run self.refresh_from_db(session=3Dsession, lock_for_update=3DTrue) File "/Users/alison/Envs/pp_airflow/lib/python2.7/site-packages/airflow/u= tils/db.py", line 53, in wrapper result =3D func(*args, **kwargs) File "/Users/alison/Envs/pp_airflow/lib/python2.7/site-packages/airflow/m= odels.py", line 993, in refresh_from_db ti =3D qry.with_for_update().first() File "/Users/alison/Envs/pp_airflow/lib/python2.7/site-packages/sqlalchem= y/orm/query.py", line 2755, in first ret =3D list(self[0:1]) File "/Users/alison/Envs/pp_airflow/lib/python2.7/site-packages/sqlalchem= y/orm/query.py", line 2547, in __getitem__ return list(res) File "/Users/alison/Envs/pp_airflow/lib/python2.7/site-packages/sqlalchem= y/orm/query.py", line 2855, in __iter__ return self._execute_and_instances(context) File "/Users/alison/Envs/pp_airflow/lib/python2.7/site-packages/sqlalchem= y/orm/query.py", line 2878, in _execute_and_instances result =3D conn.execute(querycontext.statement, self._params) File "/Users/alison/Envs/pp_airflow/lib/python2.7/site-packages/sqlalchem= y/engine/base.py", line 945, in execute return meth(self, multiparams, params) File "/Users/alison/Envs/pp_airflow/lib/python2.7/site-packages/sqlalchem= y/sql/elements.py", line 263, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "/Users/alison/Envs/pp_airflow/lib/python2.7/site-packages/sqlalchem= y/engine/base.py", line 1053, in _execute_clauseelement compiled_sql, distilled_params File "/Users/alison/Envs/pp_airflow/lib/python2.7/site-packages/sqlalchem= y/engine/base.py", line 1189, in _execute_context context) File "/Users/alison/Envs/pp_airflow/lib/python2.7/site-packages/sqlalchem= y/engine/base.py", line 1402, in _handle_dbapi_exception exc_info File "/Users/alison/Envs/pp_airflow/lib/python2.7/site-packages/sqlalchem= y/util/compat.py", line 203, in raise_from_cause reraise(type(exception), exception, tb=3Dexc_tb, cause=3Dcause) File "/Users/alison/Envs/pp_airflow/lib/python2.7/site-packages/sqlalchem= y/engine/base.py", line 1182, in _execute_context context) File "/Users/alison/Envs/pp_airflow/lib/python2.7/site-packages/sqlalchem= y/engine/default.py", line 470, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table: = task_instance [SQL: u'SELECT task_instance.task_id AS task_instance_task_id= , task_instance.dag_id AS task_instance_dag_id, task_instance.execution_dat= e AS task_instance_execution_date, task_instance.start_date AS task_instanc= e_start_date, task_instance.end_date AS task_instance_end_date, task_instan= ce.duration AS task_instance_duration, task_instance.state AS task_instance= _state, task_instance.try_number AS task_instance_try_number, task_instance= .hostname AS task_instance_hostname, task_instance.unixname AS task_instanc= e_unixname, task_instance.job_id AS task_instance_job_id, task_instance.poo= l AS task_instance_pool, task_instance.queue AS task_instance_queue, task_i= nstance.priority_weight AS task_instance_priority_weight, task_instance.ope= rator AS task_instance_operator, task_instance.queued_dttm AS task_instance= _queued_dttm, task_instance.pid AS task_instance_pid \nFROM task_instance \= nWHERE task_instance.dag_id =3D ? AND task_instance.task_id =3D ? AND task_= instance.execution_date =3D ?\n LIMIT ? OFFSET ?'] [parameters: ('tutorial'= , 'templated', '2017-09-15 00:00:00.000000', 1, 0)] ``` > (sqlite3.OperationalError) no such table: task_instance > ------------------------------------------------------- > > Key: AIRFLOW-1616 > URL: https://issues.apache.org/jira/browse/AIRFLOW-1616 > Project: Apache Airflow > Issue Type: Bug > Affects Versions: 1.8.2 > Environment: Mac OSX 10.12.6 Sierra with python 2.7, virtualenv a= nd virtualenvwrapper > Reporter: Alison Stanton > > I am going through the [tutorial](https://pythonhosted.org/airflow/tutori= al.html) and when I get to `airflow test tutorial print_date 2015-06-01` I = start getting errors (whether the webserver is running or not). > Specifically I get: > ``` > (pp_airflow) Alisons-MacBook-Air:pp-airflow alison$ airflow test tutorial= templated 2017-09-15 > [2017-09-15 13:58:16,638] {__init__.py:57} INFO - Using executor Sequenti= alExecutor > /Users/alison/Envs/pp_airflow/lib/python2.7/site-packages/airflow/www/app= .py:23: FlaskWTFDeprecationWarning: "flask_wtf.CsrfProtect" has been rename= d to "CSRFProtect" and will be removed in 1.0. > csrf =3D CsrfProtect() > [2017-09-15 13:58:16,913] {models.py:168} INFO - Filling up the DagBag fr= om /Users/alison/airflow/dags > Traceback (most recent call last): > File "/Users/alison/Envs/pp_airflow/bin/airflow", line 28, in > args.func(args) > File "/Users/alison/Envs/pp_airflow/lib/python2.7/site-packages/airflow= /bin/cli.py", line 585, in test > ti.run(ignore_task_deps=3DTrue, ignore_ti_state=3DTrue, test_mode=3DT= rue) > File "/Users/alison/Envs/pp_airflow/lib/python2.7/site-packages/airflow= /utils/db.py", line 53, in wrapper > result =3D func(*args, **kwargs) > File "/Users/alison/Envs/pp_airflow/lib/python2.7/site-packages/airflow= /models.py", line 1265, in run > self.refresh_from_db(session=3Dsession, lock_for_update=3DTrue) > File "/Users/alison/Envs/pp_airflow/lib/python2.7/site-packages/airflow= /utils/db.py", line 53, in wrapper > result =3D func(*args, **kwargs) > File "/Users/alison/Envs/pp_airflow/lib/python2.7/site-packages/airflow= /models.py", line 993, in refresh_from_db > ti =3D qry.with_for_update().first() > File "/Users/alison/Envs/pp_airflow/lib/python2.7/site-packages/sqlalch= emy/orm/query.py", line 2755, in first > ret =3D list(self[0:1]) > File "/Users/alison/Envs/pp_airflow/lib/python2.7/site-packages/sqlalch= emy/orm/query.py", line 2547, in __getitem__ > return list(res) > File "/Users/alison/Envs/pp_airflow/lib/python2.7/site-packages/sqlalch= emy/orm/query.py", line 2855, in __iter__ > return self._execute_and_instances(context) > File "/Users/alison/Envs/pp_airflow/lib/python2.7/site-packages/sqlalch= emy/orm/query.py", line 2878, in _execute_and_instances > result =3D conn.execute(querycontext.statement, self._params) > File "/Users/alison/Envs/pp_airflow/lib/python2.7/site-packages/sqlalch= emy/engine/base.py", line 945, in execute > return meth(self, multiparams, params) > File "/Users/alison/Envs/pp_airflow/lib/python2.7/site-packages/sqlalch= emy/sql/elements.py", line 263, in _execute_on_connection > return connection._execute_clauseelement(self, multiparams, params) > File "/Users/alison/Envs/pp_airflow/lib/python2.7/site-packages/sqlalch= emy/engine/base.py", line 1053, in _execute_clauseelement > compiled_sql, distilled_params > File "/Users/alison/Envs/pp_airflow/lib/python2.7/site-packages/sqlalch= emy/engine/base.py", line 1189, in _execute_context > context) > File "/Users/alison/Envs/pp_airflow/lib/python2.7/site-packages/sqlalch= emy/engine/base.py", line 1402, in _handle_dbapi_exception > exc_info > File "/Users/alison/Envs/pp_airflow/lib/python2.7/site-packages/sqlalch= emy/util/compat.py", line 203, in raise_from_cause > reraise(type(exception), exception, tb=3Dexc_tb, cause=3Dcause) > File "/Users/alison/Envs/pp_airflow/lib/python2.7/site-packages/sqlalch= emy/engine/base.py", line 1182, in _execute_context > context) > File "/Users/alison/Envs/pp_airflow/lib/python2.7/site-packages/sqlalch= emy/engine/default.py", line 470, in do_execute > cursor.execute(statement, parameters) > sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table= : task_instance [SQL: u'SELECT task_instance.task_id AS task_instance_task_= id, task_instance.dag_id AS task_instance_dag_id, task_instance.execution_d= ate AS task_instance_execution_date, task_instance.start_date AS task_insta= nce_start_date, task_instance.end_date AS task_instance_end_date, task_inst= ance.duration AS task_instance_duration, task_instance.state AS task_instan= ce_state, task_instance.try_number AS task_instance_try_number, task_instan= ce.hostname AS task_instance_hostname, task_instance.unixname AS task_insta= nce_unixname, task_instance.job_id AS task_instance_job_id, task_instance.p= ool AS task_instance_pool, task_instance.queue AS task_instance_queue, task= _instance.priority_weight AS task_instance_priority_weight, task_instance.o= perator AS task_instance_operator, task_instance.queued_dttm AS task_instan= ce_queued_dttm, task_instance.pid AS task_instance_pid \nFROM task_instance= \nWHERE task_instance.dag_id =3D ? AND task_instance.task_id =3D ? AND tas= k_instance.execution_date =3D ?\n LIMIT ? OFFSET ?'] [parameters: ('tutoria= l', 'templated', '2017-09-15 00:00:00.000000', 1, 0)] > ``` -- This message was sent by Atlassian JIRA (v6.4.14#64029)