PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID16024
PG Version9.6.15
OSUbuntu 18.04
Opened2019-09-25 22:31:33+00
Reported byStephan Knauss
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      16024
Logged by:          Stephan Knauss
Email address:      (redacted)
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@entry=0x564008a6bde8,
elmtype=elmtype@entry=25, elmlen=elmlen@entry=-1, elmbyval=elmbyval@entry=0
'\000',
    elmalign=elmalign@entry=105 'i', elemsp=elemsp@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@entry=0x564008a6bde8,
elmtype=elmtype@entry=25, elmlen=elmlen@entry=-1, elmbyval=elmbyval@entry=0
'\000', elmalign=elmalign@entry=105 'i', elemsp=elemsp@entry=0x7ffc5a33d570,
nullsp=0x7ffc5a33d578, nelemsp=0x7ffc5a33d56c)
    at ./build/../src/backend/utils/adt/arrayfuncs.c:3530
#1  0x0000564007ad7e48 in array_contain_compare
(array1=array1@entry=0x564008a1c718, array2=array2@entry=0x564008a6bde8,
collation=100, matchall=matchall@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@entry=0x564008a5df78,
econtext=econtext@entry=0x564008a5d1e8, resultForNull=resultForNull@entry=0
'\000') at ./build/../src/backend/executor/execQual.c:5316
#5  0x00005640079a3655 in ExecScan (node=node@entry=0x564008a5d0d8,
accessMtd=accessMtd@entry=0x5640079b9b00 <SeqNext>,
recheckMtd=recheckMtd@entry=0x5640079b9af0 <SeqRecheck>) at
./build/../src/backend/executor/execScan.c:208
#6  0x00005640079b9bb8 in ExecSeqScan (node=node@entry=0x564008a5d0d8) at
./build/../src/backend/executor/nodeSeqscan.c:127
#7  0x000056400799c340 in ExecProcNode (node=node@entry=0x564008a5d0d8) at
./build/../src/backend/executor/execProcnode.c:419
#8  0x00005640079b5f59 in ExecModifyTable (node=node@entry=0x564008a5cf98)
at ./build/../src/backend/executor/nodeModifyTable.c:1392
#9  0x000056400799c380 in ExecProcNode (node=node@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@entry=0x5640089536e8, isTopLevel=isTopLevel@entry=0 '\000',
setHoldSnapshot=setHoldSnapshot@entry=0 '\000',
dest=dest@entry=0x564008a39bc0, altdest=altdest@entry=0x564008a39bc0,
completionTag=completionTag@entry=0x7ffc5a33e220 "")
    at ./build/../src/backend/tcop/pquery.c:1303
#14 0x0000564007ab7cd1 in PortalRun (portal=portal@entry=0x5640089536e8,
count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=0 '\000',
dest=dest@entry=0x564008a39bc0, altdest=altdest@entry=0x564008a39bc0,
completionTag=completionTag@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@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

Messages

DateAuthorSubject
2019-09-25 22:31:33+00PG Bug reporting formBUG #16024: segfault ip 0000560103865c60 error 4 in postgres
2019-09-25 22:45:37+00Tom LaneRe: BUG #16024: segfault ip 0000560103865c60 error 4 in postgres
2019-09-25 23:21:49+00Stephan KnaussRe: BUG #16024: segfault ip 0000560103865c60 error 4 in postgres
2019-09-27 17:21:20+00"Stephan Knauss"Re: BUG #16024: segfault ip 0000560103865c60 error 4 in postgres
2019-09-28 02:43:34+00Peter GeogheganRe: BUG #16024: segfault ip 0000560103865c60 error 4 in postgres
2019-09-28 07:44:53+00"Stephan Knauss"Re: BUG #16024: segfault ip 0000560103865c60 error 4 in postgres