From: Tom Lane <tgl@sss.pgh.pa.us>
To: =?UTF-8?B?0JLQu9Cw0LTQuNC80LjRgCDQpNGA0L7Qu9C+0LI=?= <frolov.vova@gmail.com>
cc: pgsql-bugs@lists.postgresql.org
Subject: Re: pg_dumpall bug exit code 0 with fatal
In-reply-to: <CADi=iLRqiz4qD_DoG225D=HtQLPx56HF=D2WcYGGRxx8g0TK0Q@mail.gmail.com>
References: <CADi=iLRqiz4qD_DoG225D=HtQLPx56HF=D2WcYGGRxx8g0TK0Q@mail.gmail.com>
Comments: In-reply-to =?UTF-8?B?0JLQu9Cw0LTQuNC80LjRgCDQpNGA0L7Qu9C+0LI=?= <frolov.vova@gmail.com>
	message dated "Thu, 23 Apr 2026 18:17:32 +0300"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1498862.1776980563.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Thu, 23 Apr 2026 17:42:43 -0400
Message-ID: <1498863.1776980563@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/1498863.1776980563%40sss.pgh.pa.us>
Precedence: bulk

=3D?UTF-8?B?0JLQu9Cw0LTQuNC80LjRgCDQpNGA0L7Qu9C+0LI=3D?=3D <frolov.vova@gm=
ail.com> writes:
>  I have installed two nodes cluster- PostgreSQL 16.3 (Debian
> 16.3-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian
> 12.2.0-14) 12.2.0, 64-bit with wal logical replication. When i run
> pgdump_all - i have error -
> pg_dump: error: Dumping the contents of table "*****" failed: PQgetResul=
t()
> failed.
> pg_dump: detail: Error message from server: ERROR:  canceling statement =
due
> to conflict with recovery
> DETAIL:  User query might have needed to see row versions that must be
> removed.
> pg_dump: detail: Command was: COPY **** ( **** ) TO stdout;
> pg_dumpall: error: pg_dump failed on database "**********", exiting
> it is normal, BUT! exit code is 0!

That's pretty hard to believe.  pg_dumpall emits that message only
here:

        ret =3D runPgDump(dbname, create_opts);
        if (ret !=3D 0)
            pg_fatal("pg_dump failed on database \"%s\", exiting", dbname)=
;

and pg_fatal is defined here (logging.h):

/*
 * A common shortcut: pg_log_error() and immediately exit(1).
 */
#define pg_fatal(...) do { \
        pg_log_generic(PG_LOG_ERROR, PG_LOG_PRIMARY, __VA_ARGS__); \
        exit(1); \
    } while(0)

So the exit code definitely should have been 1.  Maybe you have some
kind of wrapper around pg_dumpall that is failing to pass the exit
code through correctly?

			regards, tom lane