PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID16466
PG Version13beta1
OSUbuntu 18.04
Opened2020-05-27 18:00:32+00
Reported byAlexander Lakhin
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      16466
Logged by:          Alexander Lakhin
Email address:      (redacted)
PostgreSQL version: 13beta1
Operating system:   Ubuntu 18.04
Description:        

When running under valgrind the following query (based on
contrib/dblink/sql/dblink.sql):
CREATE EXTENSION dblink;
CREATE FUNCTION connection_parameters() RETURNS text LANGUAGE SQL AS $f$
       SELECT $$dbname='$$||current_database()||$$'
port=$$||current_setting('port');
$f$;
SELECT dblink_connect('myconn',connection_parameters());
SELECT dblink_exec('myconn','BEGIN');
SELECT dblink_open('myconn','xxx','SELECT 1');

The following error is detected:
==00:00:00:07.723 2378719== Conditional jump or move depends on
uninitialised value(s)
==00:00:00:07.723 2378719==    at 0x486A5D0: dblink_open (dblink.c:492)
==00:00:00:07.723 2378719==    by 0x3BCA2B: ExecInterpExpr
(execExprInterp.c:699)
==00:00:00:07.723 2378719==    by 0x3B97F0: ExecInterpExprStillValid
(execExprInterp.c:1802)
==00:00:00:07.723 2378719==    by 0x3F3C05: ExecEvalExprSwitchContext
(executor.h:313)
==00:00:00:07.723 2378719==    by 0x3F3C05: ExecProject (executor.h:347)
==00:00:00:07.723 2378719==    by 0x3F3C05: ExecResult (nodeResult.c:136)
==00:00:00:07.723 2378719==    by 0x3C90EC: ExecProcNodeFirst
(execProcnode.c:450)
==00:00:00:07.723 2378719==    by 0x3C139B: ExecProcNode (executor.h:245)
==00:00:00:07.723 2378719==    by 0x3C139B: ExecutePlan (execMain.c:1646)
==00:00:00:07.723 2378719==    by 0x3C1FEC: standard_ExecutorRun
(execMain.c:364)
==00:00:00:07.723 2378719==    by 0x3C20BA: ExecutorRun (execMain.c:308)
==00:00:00:07.723 2378719==    by 0x55FED3: PortalRunSelect (pquery.c:912)
==00:00:00:07.723 2378719==    by 0x5615C7: PortalRun (pquery.c:756)
==00:00:00:07.723 2378719==    by 0x55D8F0: exec_simple_query
(postgres.c:1239)
==00:00:00:07.723 2378719==    by 0x55F7F5: PostgresMain (postgres.c:4315)
==00:00:00:07.724 2378719==

Messages

DateAuthorSubject
2020-05-27 18:00:32+00PG Bug reporting formBUG #16466: Valgrind detects an invalid read in dblink_open() with a cursor inside a transaction
2020-05-27 19:58:24+00Joe ConwayRe: BUG #16466: Valgrind detects an invalid read in dblink_open() with a cursor inside a transaction
2020-05-27 21:00:00+00Alexander LakhinRe: BUG #16466: Valgrind detects an invalid read in dblink_open() with a cursor inside a transaction
2020-05-28 17:50:15+00Joe ConwayRe: BUG #16466: Valgrind detects an invalid read in dblink_open() with a cursor inside a transaction