pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
BUG #18638: PANIC: could not open file "pg_logical/snapshots/B6-9EE5B820.snap": Permission denied
2+ messages / 2 participants
[nested] [flat]

* BUG #18638: PANIC: could not open file "pg_logical/snapshots/B6-9EE5B820.snap": Permission denied
@ 2024-09-27 15:54  PG Bug reporting form <noreply@postgresql.org>
  0 siblings, 1 reply; 2+ messages in thread

From: PG Bug reporting form @ 2024-09-27 15:54 UTC (permalink / raw)
  To: pgsql-bugs@lists.postgresql.org; +Cc: bhagyalaxmi.ramagalla@toyota.com

The following bug has been logged on the website:

Bug reference:      18638
Logged by:          Bhagyalaxmi R
Email address:      bhagyalaxmi.ramagalla@toyota.com
PostgreSQL version: 15.4
Operating system:   windows
Description:        

Hi Team,
we have postgres servers running on windows with logical replication. But
very frequently we are observing this issue on 

"PostgreSQL 15.4 (EnterpriseDB Advanced Server 15.4.1), compiled by Visual
C++ build 1916, 64-bit"
## Log ##
024-09-27/10:2432 EDT Lod: checkpoint complete: wrote 625 buffers (110%), 0
WAL file(s) saded, 0 removed, 2 recycled, wite =59.870 5, sync=01098 s,
total: 601095 ≤ sync
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"
LOGICAL B4/866CF008 (proto version "3', publication names "hevlasser'
2024,09-27 1025.01 EDT ERROR: replication slot "hevlassemi is active for PID
20072
2024-09-27 10.25:01 EDT STATEMENT: START_REPLICATION SLOT "hevlassem"
LOGICAL 86/9EE41BE8 (proto version '3% publication names "hevlassem"
2024-09-27 1025:02 EDT FATAL: the database system is in recovery mode

 2024-09-27 10:32:37 EDT WARNING:  PID 20760 is not a PostgreSQL backend
process
2024-09-27 10:32:42 EDT WARNING:  PID 12012 is not a PostgreSQL backend
proces



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: BUG #18638: PANIC: could not open file "pg_logical/snapshots/B6-9EE5B820.snap": Permission denied
@ 2024-09-27 18:00  Laurenz Albe <laurenz.albe@cybertec.at>
  parent: PG Bug reporting form <noreply@postgresql.org>
  0 siblings, 0 replies; 2+ messages in thread

From: Laurenz Albe @ 2024-09-27 18:00 UTC (permalink / raw)
  To: bhagyalaxmi.ramagalla@toyota.com; pgsql-bugs@lists.postgresql.org

On Fri, 2024-09-27 at 15:54 +0000, PG Bug reporting form wrote:
> PostgreSQL version: 15.4
> Operating system:   windows
> 
> we have postgres servers running on windows with logical replication. But
> very frequently we are observing this issue on 
> 
> "PostgreSQL 15.4 (EnterpriseDB Advanced Server 15.4.1), compiled by Visual
> 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" LOGICAL B4/866CF008 (proto version "3', publication names "hevlasser'

Perhaps a virus scanner that messes with the data directory.

Yours,
Laurenz Albe





^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2024-09-27 18:00 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-09-27 15:54 BUG #18638: PANIC: could not open file "pg_logical/snapshots/B6-9EE5B820.snap": Permission denied PG Bug reporting form <noreply@postgresql.org>
2024-09-27 18:00 ` Laurenz Albe <laurenz.albe@cybertec.at>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox