Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1suFGe-005KrC-CO
	for pgsql-bugs@arkaria.postgresql.org; Fri, 27 Sep 2024 18:00:37 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1suFGd-00CwBx-Lt
	for pgsql-bugs@arkaria.postgresql.org; Fri, 27 Sep 2024 18:00:35 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <laurenz.albe@cybertec.at>)
	id 1suFGd-00Cw8n-DA
	for pgsql-bugs@lists.postgresql.org; Fri, 27 Sep 2024 18:00:35 +0000
Received: from mail-ej1-x634.google.com ([2a00:1450:4864:20::634])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <laurenz.albe@cybertec.at>)
	id 1suFGa-001M7b-Lw
	for pgsql-bugs@lists.postgresql.org; Fri, 27 Sep 2024 18:00:33 +0000
Received: by mail-ej1-x634.google.com with SMTP id
 a640c23a62f3a-a7aa086b077so330972566b.0
        for <pgsql-bugs@lists.postgresql.org>;
 Fri, 27 Sep 2024 11:00:32 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=cybertec.at; s=cybertec.at; t=1727460031; x=1728064831;
 darn=lists.postgresql.org;
        h=mime-version:user-agent:content-transfer-encoding:references
         :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date
         :message-id:reply-to;
        bh=2o6fKtrhMggMflm9peXsIIoP+CTnqGrUedN/zlFeolM=;
        b=CdYuvWUMz015M/n8Bn2ghZFr+U2TcFNs/48JZpFTDjuzfLteQ2kGo+aP7zS/0foOCt
         fkQc0HREJ5kYQAEKhWjkOZpEAVCrzMk/4YOeL1ZtGJt1P1Z+LInB+zwxmBECiHlARM8e
         wjtR02cVmxa69MspIpOJtdLfR7YNR6UJGhwHY=
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1727460031; x=1728064831;
        h=mime-version:user-agent:content-transfer-encoding:references
         :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from
         :to:cc:subject:date:message-id:reply-to;
        bh=2o6fKtrhMggMflm9peXsIIoP+CTnqGrUedN/zlFeolM=;
        b=q2VCRSmwD3mUEd4r2RARDI03oWzduTf9ZTk/YV1N4SIchSXBSjG+7TmK4R8yUNKBhR
         oHSLWr9lD/dZ2d0U+SRHZ9bgIgUqFvinYiEjNNEcms2bb+E0zQmQICUxRYkBbcdi2uYk
         TcQ64TU0fZfZ0khBa/lm3iKoy56aYzpI3vRsALB4Qtmuff3gS16QH1tLo5hVkI4LD3Vd
         D5UeQp/n14BItb8BNmUZN0M1UO1aXhr3GBG9zXguhK8kqyMnXPLQcn9IffYxXQLwsZ3r
         QgpSB0O2MaOOLxvCLFlJlfBqBGqRF1SR4Vo+bPnkY1ecFElsMUzlYr9kH34EQ6nXF1e1
         ZcHw==
X-Forwarded-Encrypted: i=1;
 AJvYcCVNNVDUCKWSkanJfhk+D/IDTGdW/SxZXOaP7BTHzQCFqYY9wteGl8Lde0kC3+VxG8RDRqaHO5f6b7f4@lists.postgresql.org
X-Gm-Message-State: AOJu0Yz1H4TCEYaiswFQ+h8ySFqAFe8A5ZpxB0jX6tseNREzzhRVRimj
	NcjFOFj9uXYGLoLsyDt1LlvihnNXGJD5fWZB+59yLOhjeBDNJ4LjXB9nN3OVV00=
X-Google-Smtp-Source: 
 AGHT+IFOLgtkYJwtzZ1vNIG0qDzV0IZlgCn7ooiK2fHQ5iqvNqlSJPzWC7MoBakc6Ss9DMb/2rD/lQ==
X-Received: by 2002:a17:906:fe47:b0:a8d:3f6a:99cb with SMTP id
 a640c23a62f3a-a93c4a87677mr423331166b.47.1727460031093;
        Fri, 27 Sep 2024 11:00:31 -0700 (PDT)
Received: from dynamic-pd01.res.v6.highway.a1.net
 ([2001:871:260:9cfc:6fcf:5db7:b71f:99c4])
        by smtp.gmail.com with ESMTPSA id
 a640c23a62f3a-a93c297a2ffsm157214366b.157.2024.09.27.11.00.30
        (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256);
        Fri, 27 Sep 2024 11:00:30 -0700 (PDT)
Message-ID: <3f7e748610607403c134b359435a1a5134ec13cf.camel@cybertec.at>
Subject: Re: BUG #18638: PANIC: could not open file
 "pg_logical/snapshots/B6-9EE5B820.snap": Permission denied
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: bhagyalaxmi.ramagalla@toyota.com, pgsql-bugs@lists.postgresql.org
Date: Fri, 27 Sep 2024 20:00:30 +0200
In-Reply-To: <18638-760882b4e5851b71@postgresql.org>
References: <18638-760882b4e5851b71@postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.52.4 (3.52.4-1.fc40) 
MIME-Version: 1.0
List-Id: <pgsql-bugs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-bugs@lists.postgresql.org>
List-Owner: <mailto:pgsql-bugs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-bugs>
Archived-At: 
 <https://www.postgresql.org/message-id/3f7e748610607403c134b359435a1a5134ec13cf.camel%40cybertec.at>
Precedence: bulk

On Fri, 2024-09-27 at 15:54 +0000, PG Bug reporting form wrote:
> PostgreSQL version: 15.4
> Operating system:   windows
>=20
> we have postgres servers running on windows with logical replication. But
> very frequently we are observing this issue on=20
>=20
> "PostgreSQL 15.4 (EnterpriseDB Advanced Server 15.4.1), compiled by Visua=
l
> C++ build 1916, 64-bit"

That isn't PostgreSQL; we can only help in a limited fashion.

> 2034-09-27 10:25:01 EDT PANIC: could not open file "pg.logical/snapshots/=
B6-9EESB820.snap*: Permission denied
> 2024-09-27 10.25.01 EDT STATEMENT: START _REPLICATION SLOT "hevlassem" LO=
GICAL B4/866CF008 (proto version "3', publication names "hevlasser'

Perhaps a virus scanner that messes with the data directory.

Yours,
Laurenz Albe