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 1pL9aa-00076F-AG for pgsql-hackers@arkaria.postgresql.org; Thu, 26 Jan 2023 21:15:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pL9aZ-0007y6-66 for pgsql-hackers@arkaria.postgresql.org; Thu, 26 Jan 2023 21:15:19 +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 1pL9aY-0007xx-Pr for pgsql-hackers@lists.postgresql.org; Thu, 26 Jan 2023 21:15:18 +0000 Received: from mail-io1-xd2c.google.com ([2607:f8b0:4864:20::d2c]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pL9aV-00050K-Kl for pgsql-hackers@lists.postgresql.org; Thu, 26 Jan 2023 21:15:18 +0000 Received: by mail-io1-xd2c.google.com with SMTP id j1so1099108iob.6 for ; Thu, 26 Jan 2023 13:15:15 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20210112.gappssmtp.com; s=20210112; h=user-agent:in-reply-to:content-disposition:mime-version:references :message-id:subject:cc:to:from:date:from:to:cc:subject:date :message-id:reply-to; bh=H0gPeyyfxME9NsWrTM6eruJ/2Cn6OkLCk7HEJsRUD/o=; b=qzCkQA+n3ukP+6irdENUXIqqFYh7d9Dsn/SRJnTuOZz5vp4IfLTbRfZpnwuz0ZKYRa +avZdpcHWIAjPymurKAc4OOxddkrnnZfqI+fpWftia6gUb6usUzMIFRUF55s8ymByDli jH3xI90alZVr43iNK/PHVMAUlXn1QF4qa9JQjNxNFbMk29hL+LUJGb/TvSBWkFqc127D NeIptoc0I5UyfRDX3b2HRDXqPAtj14PPxaE+P/JUSvCIPDa6xvdIWapWNrYOOnhJoVNv z+0U/dDSoO0VD5FAV8JaSDIF8G3ZAG14u3ZfrkwIwsTN1PHBH0koMgN/gSEJOJAEhO4i Vqww== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=user-agent:in-reply-to:content-disposition:mime-version:references :message-id:subject:cc:to:from:date:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=H0gPeyyfxME9NsWrTM6eruJ/2Cn6OkLCk7HEJsRUD/o=; b=bNVu5NnJp5eiUs0mhMka3d40FRZxPU+/+GIPPDDoPzPnwF8mhPJjMV7iUf0MmMrRVf b42ArUbIwGCFojOTLU8IK4PCFLV1JMCBhB4oC04B97ilxKJi6/J5z8HeH2JcGfDC6lcr TpvFPZqGKDQkxA+e+jlJLrcxL7kwzmwH1cNapePwr1fSPigMT0ZhhvOKfNqN81OdmwgK k9xOGMNnx7kuGcx001V2bXnw+WD1b5MDvSgsGZ5fO8G68Serq+ws7Z5HUlEfTy8OwLBZ ypMC+OAeosQ/Uy+6jf1JiVjZ1ehH7/ggbahrX/RFC02+Sfxet2cFyLSFo/3bshCjZa4X 9TQQ== X-Gm-Message-State: AFqh2krCyjSkcZNih48wl1pQ8XnnXCKIjzOn66/eGJ/e5Xbq8TAekzFZ cyag9ZB8OgkgQgzuMsRpoohxBw== X-Google-Smtp-Source: AMrXdXvaD7bCJjlLA3V3InrHZoHji5erl2gJSb5AarOdfO8tvJ2yaF4UyE/fYeHzGWMXGXS0nhu/4A== X-Received: by 2002:a6b:dd11:0:b0:704:67aa:57b0 with SMTP id f17-20020a6bdd11000000b0070467aa57b0mr25915702ioc.2.1674767713652; Thu, 26 Jan 2023 13:15:13 -0800 (PST) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id r4-20020a5edb44000000b006e3170eeee4sm597643iop.6.2023.01.26.13.15.12 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 26 Jan 2023 13:15:13 -0800 (PST) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id 05047800CA9; Thu, 26 Jan 2023 15:15:11 -0600 (CST) Date: Thu, 26 Jan 2023 15:15:11 -0600 From: Justin Pryzby To: Andres Freund Cc: Thomas Munro , vignesh C , pgsql-hackers@lists.postgresql.org, Andrew Dunstan , Tom Lane Subject: Re: Cygwin cleanup Message-ID: <20230126211511.GU22427@telsasoft.com> References: <20221109010437.GK3775@telsasoft.com> <20230103142537.GM1153@telsasoft.com> <20230112043949.GQ9837@telsasoft.com> <20230113024354.3q4aigbf4fyh2igg@awork3.anarazel.de> <20230113041755.GV9837@telsasoft.com> <20230123232814.GA13860@telsasoft.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20230123232814.GA13860@telsasoft.com> User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Note that cirrus failed like this: https://api.cirrus-ci.com/v1/artifact/task/4881596411543552/testrun/build/testrun/subscription/010_truncate/log/010_truncate_publisher.log 2023-01-25 23:17:10.417 GMT [29821][walsender] [sub1][3/0:0] ERROR: could not open file "pg_logical/snapshots/0-14F2060.snap": Is a directory 2023-01-25 23:17:10.417 GMT [29821][walsender] [sub1][3/0:0] STATEMENT: START_REPLICATION SLOT "sub1" LOGICAL 0/0 (proto_version '4', origin 'any', publication_names '"pub1"') 2023-01-25 23:17:10.418 GMT [29850][walsender] [pg_16413_sync_16394_7192732880582452157][6/0:0] PANIC: could not open file "pg_logical/snapshots/0-14F2060.snap": No such file or directory 2023-01-25 23:17:10.418 GMT [29850][walsender] [pg_16413_sync_16394_7192732880582452157][6/0:0] STATEMENT: START_REPLICATION SLOT "pg_16413_sync_16394_7192732880582452157" LOGICAL 0/14F2060 (proto_version '4', origin 'any', publication_names '"pub3"') I don't understand how "Is a directory" happened .. It looks like maybe the call stack would've been: SnapBuildSerializationPoint() xlog_decode() or standby_decode() ? LogicalDecodingProcessRecord() XLogSendLogical() WalSndLoop() StartLogicalReplication() -- Justin