BUG #16024: segfault ip 0000560103865c60 error 4 in postgres

The following bug has been logged on the website:

Bug reference: 16024
Logged by: Stephan Knauss
Email address: sknauss(at)gmx(dot)de
PostgreSQL version: 9.6.15
Operating system: Ubuntu 18.04
Description:

Using ubuntu packages 9.6.15 from postgresql.org. Recently a unchanged
routine crashes a postgres backend process most of the time (or always?)
with a segmentation fault.

Call stack below. Please let me know what further details can help you. The
core is 3.6G, I can provide it on request.

Program terminated with signal SIGSEGV, Segmentation fault.
#0 deconstruct_array (array=array(at)entry=0x564008a6bde8,
elmtype=elmtype(at)entry=25, elmlen=elmlen(at)entry=-1, elmbyval=elmbyval(at)entry=0
'\000',
elmalign=elmalign(at)entry=105 'i', elemsp=elemsp(at)entry=0x7ffc5a33d570,
nullsp=0x7ffc5a33d578, nelemsp=0x7ffc5a33d56c)
at ./build/../src/backend/utils/adt/arrayfuncs.c:3530
3530 ./build/../src/backend/utils/adt/arrayfuncs.c: No such file or
directory.
(gdb) bt
#0 deconstruct_array (array=array(at)entry=0x564008a6bde8,
elmtype=elmtype(at)entry=25, elmlen=elmlen(at)entry=-1, elmbyval=elmbyval(at)entry=0
'\000', elmalign=elmalign(at)entry=105 'i', elemsp=elemsp(at)entry=0x7ffc5a33d570,
nullsp=0x7ffc5a33d578, nelemsp=0x7ffc5a33d56c)
at ./build/../src/backend/utils/adt/arrayfuncs.c:3530
#1 0x0000564007ad7e48 in array_contain_compare
(array1=array1(at)entry=0x564008a1c718, array2=array2(at)entry=0x564008a6bde8,
collation=100, matchall=matchall(at)entry=0 '\000', fn_extra=<optimized out>)
at ./build/../src/backend/utils/adt/arrayfuncs.c:4111
#2 0x0000564007ada7dd in arrayoverlap (fcinfo=0x564008a5d6e8) at
./build/../src/backend/utils/adt/arrayfuncs.c:4201
#3 0x000056400799d3bc in ExecMakeFunctionResultNoSets
(fcache=0x564008a5d678, econtext=0x564008a5d1e8, isNull=0x7ffc5a33da37 "",
isDone=<optimized out>) at ./build/../src/backend/executor/execQual.c:2041
#4 0x00005640079a30ef in ExecQual (qual=qual(at)entry=0x564008a5df78,
econtext=econtext(at)entry=0x564008a5d1e8, resultForNull=resultForNull(at)entry=0
'\000') at ./build/../src/backend/executor/execQual.c:5316
#5 0x00005640079a3655 in ExecScan (node=node(at)entry=0x564008a5d0d8,
accessMtd=accessMtd(at)entry=0x5640079b9b00 <SeqNext>,
recheckMtd=recheckMtd(at)entry=0x5640079b9af0 <SeqRecheck>) at
./build/../src/backend/executor/execScan.c:208
#6 0x00005640079b9bb8 in ExecSeqScan (node=node(at)entry=0x564008a5d0d8) at
./build/../src/backend/executor/nodeSeqscan.c:127
#7 0x000056400799c340 in ExecProcNode (node=node(at)entry=0x564008a5d0d8) at
./build/../src/backend/executor/execProcnode.c:419
#8 0x00005640079b5f59 in ExecModifyTable (node=node(at)entry=0x564008a5cf98)
at ./build/../src/backend/executor/nodeModifyTable.c:1392
#9 0x000056400799c380 in ExecProcNode (node=node(at)entry=0x564008a5cf98) at
./build/../src/backend/executor/execProcnode.c:396
#10 0x00005640079984f6 in ExecutePlan (dest=0x564008a39bc0,
direction=<optimized out>, numberTuples=0, sendTuples=<optimized out>,
operation=CMD_INSERT, use_parallel_mode=<optimized out>,
planstate=0x564008a5cf98, estate=0x564008a5ccf8)
at ./build/../src/backend/executor/execMain.c:1567
#11 standard_ExecutorRun (queryDesc=0x564008a29ec8, direction=<optimized
out>, count=0) at ./build/../src/backend/executor/execMain.c:339
#12 0x0000564007ab6eb8 in ProcessQuery (plan=<optimized out>,
sourceText=0x5640089ed678 "DROP TABLE if EXISTS loose;CREATE UNLOGGED
TABLE loose (id bigint, node bigint, lat float, lon float, x integer, y
integer);INSERT INTO loose SELECT id, nodes[1] AS node FROM planet_osm_ways
WHERE ARR"..., params=0x0, dest=0x564008a39bc0,
completionTag=0x7ffc5a33e220 "") at
./build/../src/backend/tcop/pquery.c:187
#13 0x0000564007ab70ed in PortalRunMulti
(portal=portal(at)entry=0x5640089536e8, isTopLevel=isTopLevel(at)entry=0 '\000',
setHoldSnapshot=setHoldSnapshot(at)entry=0 '\000',
dest=dest(at)entry=0x564008a39bc0, altdest=altdest(at)entry=0x564008a39bc0,
completionTag=completionTag(at)entry=0x7ffc5a33e220 "")
at ./build/../src/backend/tcop/pquery.c:1303
#14 0x0000564007ab7cd1 in PortalRun (portal=portal(at)entry=0x5640089536e8,
count=count(at)entry=9223372036854775807, isTopLevel=isTopLevel(at)entry=0 '\000',
dest=dest(at)entry=0x564008a39bc0, altdest=altdest(at)entry=0x564008a39bc0,
completionTag=completionTag(at)entry=0x7ffc5a33e220 "")
at ./build/../src/backend/tcop/pquery.c:815
#15 0x0000564007ab5455 in exec_simple_query (query_string=0x5640089ed678
"DROP TABLE if EXISTS loose;CREATE UNLOGGED TABLE loose (id bigint, node
bigint, lat float, lon float, x integer, y integer);INSERT INTO loose SELECT
id, nodes[1] AS node FROM planet_osm_ways WHERE ARR"...)
at ./build/../src/backend/tcop/postgres.c:1109
#16 PostgresMain (argc=<optimized out>, argv=argv(at)entry=0x564008989868,
dbname=<optimized out>, username=<optimized out>) at
./build/../src/backend/tcop/postgres.c:4101
#17 0x0000564007831664 in BackendRun (port=0x564008981600) at
./build/../src/backend/postmaster/postmaster.c:4339
#18 BackendStartup (port=0x564008981600) at
./build/../src/backend/postmaster/postmaster.c:4013
#19 ServerLoop () at ./build/../src/backend/postmaster/postmaster.c:1722
#20 0x0000564007a51e29 in PostmasterMain (argc=5, argv=0x564008934090) at
./build/../src/backend/postmaster/postmaster.c:1330
#21 0x0000564007832ed2 in main (argc=5, argv=0x564008934090) at
./build/../src/backend/main/main.c:228