pg.ddx.io pgsql-bugs@postgresql.org mailing list archive help / color / mirror / Atom feed From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: tharakan@gmail.com
Subject: BUG #18828: Crash when pg_get_logical_snapshot_meta() passed empty string
Date: Sat, 01 Mar 2025 18:41:19 +0000
Message-ID: <18828-0f4701c635064211@postgresql.org> (raw )
The following bug has been logged on the website:
Bug reference: 18828
Logged by: Robins Tharakan
Email address: tharakan@gmail.com
PostgreSQL version: Unsupported/Unknown
Operating system: Ubuntu
Description:
Passing an empty string to the recently added extension function
pg_get_logical_snapshot_meta() triggers PANIC / Abort.
SQL
===
CREATE EXTENSION pg_logicalinspect;
SELECT pg_get_logical_snapshot_meta('');
Commit
======
.
.
Checking (56ba0463d38~950) - 3c7d78427e - fail
Checking (56ba0463d38~1110) - dc68515968 - Pass
Checking (56ba0463d38~1030) - 67a54b9e83 - Pass
Checking (56ba0463d38~990) - e2fd615ecc - Pass
Checking (56ba0463d38~970) - 665785d85f - fail
Checking (56ba0463d38~980) - b360d1762b - fail
Checking (56ba0463d38~985) - 04bec894a0 - fail
Checking (56ba0463d38~987) - d5ca15ee54 - fail
Checking (56ba0463d38~988) - 2453196107 - fail
Checking (56ba0463d38~989) - 7cdfeee320 - fail
Current=7cdfeee320e72162b62dddddee638e713c2b8680 - Commit Found.
Error Log
=========
2025-03-02 04:28:02.355 ACDT [3826851] PANIC: could not open file
"pg_logical/snapshots/": Is a directory
2025-03-02 04:28:02.355 ACDT [3826851] STATEMENT: select
pg_get_logical_snapshot_meta('');
2025-03-02 04:28:02.896 ACDT [3745459] LOG: client backend (PID 3826851)
was terminated by signal 6: Aborted
2025-03-02 04:28:02.896 ACDT [3745459] DETAIL: Failed process was running:
select pg_get_logical_snapshot_meta('');
2025-03-02 04:28:02.896 ACDT [3745459] LOG: terminating any other active
server processes
Output
======
smith@camry:~/proj/sqith$ psql -c "select
pg_get_logical_snapshot_meta('');"
PANIC: could not open file "pg_logical/snapshots/": Is a directory
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
connection to server was lost
view thread (26+ messages) latest in thread
Message-ID: <18828-0f4701c635064211@postgresql.org>
Permalink: ../18828-0f4701c635064211@postgresql.org/
Also on: postgresql.org/message-id/18828-0f4701c635064211@postgresql.org
copy link · copy postgr.es
reply Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, tharakan@gmail.com
Subject: Re: BUG #18828: Crash when pg_get_logical_snapshot_meta() passed empty string
In-Reply-To: <18828-0f4701c635064211@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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