Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kjUV7-0005E7-Oa for pgsql-hackers@arkaria.postgresql.org; Sun, 29 Nov 2020 21:44:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kjUV5-0004GH-Aj for pgsql-hackers@arkaria.postgresql.org; Sun, 29 Nov 2020 21:44:55 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kjUV4-0004G9-Rx for pgsql-hackers@lists.postgresql.org; Sun, 29 Nov 2020 21:44:55 +0000 Received: from mail-pj1-x1033.google.com ([2607:f8b0:4864:20::1033]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kjUUx-00030Z-Fd for pgsql-hackers@postgresql.org; Sun, 29 Nov 2020 21:44:54 +0000 Received: by mail-pj1-x1033.google.com with SMTP id ms7so5230pjb.4 for ; Sun, 29 Nov 2020 13:44:46 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=leadboat.com; s=google; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=dUQyDEJW0EunAnL87c5yb082XFB9wEEk0uo/UiQZjuM=; b=APCWps/GRup2PX6WHs5jgvT0+9Uvu3kZGhE/GT0WNZENdwpFVvb4Vd2OLDZfwdf/bw ZozCjS2E9bEQ/7JRH98+rKcda6HatPVHX6BrC8wtWkDn46IJmkJOU4sVKIoDzOk/zimc ls4r6TVkPNbqSQhCCjRbaP2K4iEM7HfXhE1dc= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to:user-agent; bh=dUQyDEJW0EunAnL87c5yb082XFB9wEEk0uo/UiQZjuM=; b=tZwu+bBuitkTScGuqd/I5EielINVLw3VrldYomkrNyb6koUk3oRLcnR2K5x4yXP6ck 1kYP9qwRP8mQHWcBo6PRAXhDgSsXLsBGq7a0qOzVnP+5j7rkmTXTIKT63qY52qXirWgP cq2uNOclOjP0abyCU9BIqpI1NA1AAsIpEDBc/tgbFe5aKxMMX7ADaTEPIBPirnbMhI9M 7Ti02y9Go1Xinu6JUnWEZNhkloSzrTayvxKnMGGbnOq+0qVid2eDrSL/pu7uJgFtQMEY 14CId72jdDK6i6rQg00Z4GweVcFQZ6sK2y/BmJqc0JZufZ6NhmFqVkS60gh9te0pRC82 vZwA== X-Gm-Message-State: AOAM530Xw6Y/PB434lo1RAjnwchg8tp5X0V6cZ1HVwjlHgZgYiYzeHnK T+q/6/bJEUJ+sVVC36MxuhFo3Q== X-Google-Smtp-Source: ABdhPJwaaNifWWQpFyE5ZJMVqZ3wSVK+l5/RKY71pXevDUQxaGznhOusQsftMk7gqZWdAZJVRQy/4g== X-Received: by 2002:a17:902:7689:b029:da:52:4586 with SMTP id m9-20020a1709027689b02900da00524586mr15508139pll.47.1606686284831; Sun, 29 Nov 2020 13:44:44 -0800 (PST) Received: from rfd.leadboat.com ([2600:1702:a20:5750::43]) by smtp.gmail.com with ESMTPSA id j19sm13815241pff.74.2020.11.29.13.44.42 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Sun, 29 Nov 2020 13:44:44 -0800 (PST) Date: Sun, 29 Nov 2020 13:44:41 -0800 From: Noah Misch To: Amit Kapila Cc: Dilip Kumar , Erik Rijkers , Jeff Janes , Kuntal Ghosh , Michael Paquier , Peter Eisentraut , PostgreSQL Hackers , Tomas Vondra Subject: Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Message-ID: <20201129214441.GA691200@rfd.leadboat.com> References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.24 (2015-08-30) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Mon, Sep 07, 2020 at 12:00:41PM +0530, Amit Kapila wrote: > Thanks, I have pushed the last patch. Let's wait for a day or so to > see the buildfarm reports https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=sungazer&dt=2020-09-08%2006%3A24%3A14 failed the new 015_stream.pl test with the subscriber looping like this: 2020-09-08 11:22:49.848 UTC [13959252:1] LOG: logical replication apply worker for subscription "tap_sub" has started 2020-09-08 11:22:54.045 UTC [13959252:2] ERROR: could not open temporary file "16393-510.changes.0" from BufFile "16393-510.changes": No such file or directory 2020-09-08 11:22:54.055 UTC [7602182:1] LOG: logical replication apply worker for subscription "tap_sub" has started 2020-09-08 11:22:54.101 UTC [31785284:4] LOG: background worker "logical replication worker" (PID 13959252) exited with exit code 1 2020-09-08 11:23:01.142 UTC [7602182:2] ERROR: could not open temporary file "16393-510.changes.0" from BufFile "16393-510.changes": No such file or directory ... What happened there?