PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID15734
PG Version11.2
OSUbuntu 18.04.2 LTS
Opened2019-04-04 07:54:19+00
Reported byAlexander Kukushkin
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      15734
Logged by:          Alexander Kukushkin
Email address:      (redacted)
PostgreSQL version: 11.2
Operating system:   Ubuntu 18.04.2 LTS
Description:        

According to the documentation [1], replication protocol supports SHOW
command, which is similar to the SQL command SHOW [2], so I tried to execute
"SHOW ALL;" and walsender crashed with the following stack-trace:
Program received signal SIGSEGV, Segmentation fault.
MemoryContextAlloc (context=0x0, size=104) at
./build/../src/backend/utils/mmgr/mcxt.c:783
783     ./build/../src/backend/utils/mmgr/mcxt.c: No such file or
directory.
(gdb) bt
#0  MemoryContextAlloc (context=0x0, size=104) at
./build/../src/backend/utils/mmgr/mcxt.c:783
#1  0x0000558b292beb97 in CopySnapshot (snapshot=0x558b29715060
<CatalogSnapshotData>) at ./build/../src/backend/utils/time/snapmgr.c:674
#2  0x0000558b292bf855 in RegisterSnapshotOnOwner (snapshot=0x558b29715060
<CatalogSnapshotData>, owner=0x558b2ae178c8) at
./build/../src/backend/utils/time/snapmgr.c:884
#3  0x0000558b292bf896 in RegisterSnapshot (snapshot=<optimized out>) at
./build/../src/backend/utils/time/snapmgr.c:868
#4  0x0000558b28ece60f in systable_beginscan
(heapRelation=heapRelation@entry=0x7f96bedb2cc8, indexId=<optimized out>,
indexOK=<optimized out>, snapshot=snapshot@entry=0x0, nkeys=nkeys@entry=1,
key=key@entry=0x7ffe14269ec0)
    at ./build/../src/backend/access/index/genam.c:356
#5  0x0000558b2926bfd3 in SearchCatCacheList (cache=0x558b2ae2f700,
nkeys=nkeys@entry=1, v1=16384, v2=v2@entry=0, v3=v3@entry=0) at
./build/../src/backend/utils/cache/catcache.c:1650
#6  0x0000558b2927e2ee in SearchSysCacheList (cacheId=cacheId@entry=8,
nkeys=nkeys@entry=1, key1=<optimized out>, key2=key2@entry=0,
key3=key3@entry=0) at ./build/../src/backend/utils/cache/syscache.c:1427
#7  0x0000558b2917ef50 in roles_is_member_of (roleid=roleid@entry=16384) at
./build/../src/backend/utils/adt/acl.c:4862
#8  0x0000558b29182717 in is_member_of_role (member=16384,
role=role@entry=3374) at ./build/../src/backend/utils/adt/acl.c:4946
#9  0x0000558b2929fe0a in ShowAllGUCConfig (dest=<optimized out>) at
./build/../src/backend/utils/misc/guc.c:8280
#10 GetPGVariable (name=<optimized out>, dest=<optimized out>) at
./build/../src/backend/utils/misc/guc.c:8184
#11 0x0000558b2911b7aa in exec_replication_command
(cmd_string=cmd_string@entry=0x558b2ade36b0 "SHOW ALL;") at
./build/../src/backend/replication/walsender.c:1555
#12 0x0000558b291696a6 in PostgresMain (argc=<optimized out>,
argv=argv@entry=0x558b2ae125d8, dbname=<optimized out>, username=<optimized
out>) at ./build/../src/backend/tcop/postgres.c:4178
#13 0x0000558b290f4a7d in BackendRun (port=0x558b2ae0c690) at
./build/../src/backend/postmaster/postmaster.c:4361
#14 BackendStartup (port=0x558b2ae0c690) at
./build/../src/backend/postmaster/postmaster.c:4033
#15 ServerLoop () at ./build/../src/backend/postmaster/postmaster.c:1706
#16 0x0000558b290f5abf in PostmasterMain (argc=17, argv=0x558b2adde020) at
./build/../src/backend/postmaster/postmaster.c:1379
#17 0x0000558b28e824c2 in main (argc=17, argv=0x558b2adde020) at
./build/../src/backend/main/main.c:228

I don't think that such a crash is expected behavior. Either it should
return the table with all settings or report simply error out with message
'unrecognized configuration parameter "ALL"'.

[1] https://www.postgresql.org/docs/11/protocol-replication.html
[2] https://www.postgresql.org/docs/11/sql-show.html

Messages

DateAuthorSubject
2019-04-04 07:54:19+00PG Bug reporting formBUG #15734: Walsender process crashing when executing SHOW ALL;
2019-04-08 07:39:03+00Michael PaquierRe: BUG #15734: Walsender process crashing when executing SHOW ALL;
2019-04-10 06:04:27+00Michael PaquierRe: BUG #15734: Walsender process crashing when executing SHOW ALL;
2019-04-10 15:01:21+00Alvaro HerreraRe: BUG #15734: Walsender process crashing when executing SHOW ALL;
2019-04-11 03:07:12+00Michael PaquierRe: BUG #15734: Walsender process crashing when executing SHOW ALL;
2019-04-15 03:39:06+00Michael PaquierRe: BUG #15734: Walsender process crashing when executing SHOW ALL;