From dev-return-11695-archive-asf-public=cust-asf.ponee.io@airflow.apache.org Mon Jun 15 10:50:13 2020 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 [207.244.88.153]) by mx-eu-01.ponee.io (Postfix) with SMTP id 34104180656 for ; Mon, 15 Jun 2020 12:50:13 +0200 (CEST) Received: (qmail 45705 invoked by uid 500); 15 Jun 2020 10:50:12 -0000 Mailing-List: contact dev-help@airflow.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@airflow.apache.org Delivered-To: mailing list dev@airflow.apache.org Received: (qmail 45692 invoked by uid 99); 15 Jun 2020 10:50:12 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 15 Jun 2020 10:50:12 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id 7188CC152F for ; Mon, 15 Jun 2020 10:50:11 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 0.05 X-Spam-Level: X-Spam-Status: No, score=0.05 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, FREEMAIL_ENVFROM_END_DIGIT=0.25, RCVD_IN_DNSWL_NONE=-0.0001, SPF_HELO_NONE=0.001, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd1-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-he-de.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id n5C1RysueXZ0 for ; Mon, 15 Jun 2020 10:50:09 +0000 (UTC) Received-SPF: Pass (mailfrom) identity=mailfrom; client-ip=2607:f8b0:4864:20::232; helo=mail-oi1-x232.google.com; envelope-from=joshipoornima06@gmail.com; receiver= Received: from mail-oi1-x232.google.com (mail-oi1-x232.google.com [IPv6:2607:f8b0:4864:20::232]) by mx1-he-de.apache.org (ASF Mail Server at mx1-he-de.apache.org) with ESMTPS id D765E7E151 for ; Mon, 15 Jun 2020 10:50:08 +0000 (UTC) Received: by mail-oi1-x232.google.com with SMTP id x202so15437977oix.11 for ; Mon, 15 Jun 2020 03:50:08 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to; bh=I9WHvFGe2HcIMR2EQMP20g+oXzbpP+eio1fxSoQSd80=; b=poBXLcw1UpnFLeB9ulH9Kpiv/mapGSj05d7WDrZju2Lll28m9mIPxfQWGKc0SlIPrh Xs0T30UEw0mNlnJ0gvj9DUgiNfCBHrwCSq+8NPlZb/wFlFOh7FySEIxDIqS5RACmtD0S cx4pDvS56MmM5aoKApY5xlE1HiF0pal04E+igumvBxHTIwEsokQ87fSZuXDigZ7xw4DJ iK9GIi6vTvvxAOalN9Cw+H+UCIDpTFiKFXkQBEb7XUOKrveiiJOKDfwVaY2UFBpCWHLX khU4Dc36yy35M8fIVH5lWPLs434TyBsXYrnaj8dVCdRd24TpeZ1ZAJYBaVayrBCS98Ex +xcQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to; bh=I9WHvFGe2HcIMR2EQMP20g+oXzbpP+eio1fxSoQSd80=; b=KkNCz+jcNUvDvBFb3U7IMUmTzwNeMzpN+MByEsJ25Couwm3d6Rf8Ugezg2/EagBk2z kREszVBAUcVBXlTFY9ZCrAu2n9HOvpuhHgrfYkqzMUAqECdQ9RIH7Kyh8fwGjHYxFqMC 0Xd9IPOdney/dC1oN8Ql5eOlsnlYEuwubQ40iiRrRR/zXjJPsfmc+KKd796fjAmondaS wDYNEp+R82XxoCDdCe61B1kOlNO51OCONpO35KVR1PCmgicZv/CpayXBMTSF0lawvPvJ msPApATILbaTIlHZWQZCMEA0juJ7UcqA/jdhmBqVjqLXXFZfTVrvh8EVX8DF1I9PCI+l Kt2A== X-Gm-Message-State: AOAM533Vk8ye/SkkYCRL3PpiiBEmuzmcx3VmJVNu+/hUyt+ypFIjbYpN etfx8eQSKkH1hErneNp0kc8qxdKCKzHqj2neh647ozG8 X-Google-Smtp-Source: ABdhPJyZDzp7pPTn5PnwfEgB5RYNdnl7Jdfyf7medY8FDvbqs9C3JVSNRMLBWS0G54h8cricnzVHtGFxU8qgs3/Djjk= X-Received: by 2002:a05:6808:5:: with SMTP id u5mr8135453oic.147.1592218201253; Mon, 15 Jun 2020 03:50:01 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Poornima Joshi Date: Mon, 15 Jun 2020 16:19:24 +0530 Message-ID: Subject: Re: dagrun_operator in Airflow Version 1.10.10 ERROR - No row was found for one() _run_raw_task result = task_copy.execute(context=context) To: dev@airflow.apache.org Content-Type: text/plain; charset="UTF-8" Thank you On Fri, Jun 12, 2020 at 4:54 PM SHANIT wrote: > > This issue has been resolved. We need to avoid using execution_date parameter while creating the `dagrun_operator` > > On 2020/06/09 16:33:32, SHANIT wrote: > > On Migrating Airflow from V1.10.2 to V1.10.10 One of our DAG have a task which is of dagrun_operator type. > > The DAG runs all fine. In fact the python callable of the task mentioned until the last line. Then it errors out. > > It errors out > > > > ``` > > [2020-06-09 11:36:22,838] {taskinstance.py:1145} ERROR - No row was found for one() > > Traceback (most recent call last): > > File "/usr/local/lib/python3.6/site-packages/airflow/models/taskinstance.py", line 983, in _run_raw_task > > result = task_copy.execute(context=context) > > File "/usr/local/lib/python3.6/site-packages/airflow/operators/dagrun_operator.py", line 95, in execute > > replace_microseconds=False) > > File "/usr/local/lib/python3.6/site-packages/airflow/api/common/experimental/trigger_dag.py", line 141, in trigger_dag > > replace_microseconds=replace_microseconds, > > File "/usr/local/lib/python3.6/site-packages/airflow/api/common/experimental/trigger_dag.py", line 98, in _trigger_dag > > external_trigger=True, > > File "/usr/local/lib/python3.6/site-packages/airflow/utils/db.py", line 74, in wrapper > > return func(*args, **kwargs) > > File "/usr/local/lib/python3.6/site-packages/airflow/models/dag.py", line 1471, in create_dagrun > > run.refresh_from_db() > > File "/usr/local/lib/python3.6/site-packages/airflow/utils/db.py", line 74, in wrapper > > return func(*args, **kwargs) > > File "/usr/local/lib/python3.6/site-packages/airflow/models/dagrun.py", line 109, in refresh_from_db > > DR.run_id == self.run_id > > File "/usr/local/lib64/python3.6/site-packages/sqlalchemy/orm/query.py" > > ``` > > > > Details of this is also posted at https://github.com/apache/airflow/issues/9197 > > -- Thanks & Regards Poornima