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

 
> Can you show a full stack trace, please? Showing "bt full" output from
> GDB is ideal.
 
Sure. Here you go.

As reference, I assume the part of the query failing is this one:
ARRAY['motorway','trunk','primary','secondary','tertiary'] && tags

tags is text[]. It should have an even cardinality >=2.

(gdb) bt full
#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
elems = <optimized out>
nulls = 0x564008a6be58 ""
nelems = <optimized out>
p = 0x564008a8be0c <error: Cannot access memory at address 0x564008a8be0c>
bitmap = 0x0
bitmask = 1
i = 1
__func__ = "deconstruct_array"
#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
result = 0 '\000'
element_type = 25
typentry = 0x564008a67c08
nelems1 = <optimized out>
values2 = 0x564008a6be38
nulls2 = 0x564008a6be58 ""
nelems2 = 2
typlen = -1
typbyval = 0 '\000'
typalign = 105 'i'
i = <optimized out>
j = <optimized out>
it1 = <optimized out>
locfcinfo = {flinfo = 0x564008a67c40, context = 0x0, resultinfo = 0x0, fncollation = 100, isnull = 0 '\000', nargs = 2, arg = {94833022715748, 94833023041036, 0, 94832877895682, 94833022066616, 94833022072328, 140721821832704,
94833011943744, 94833022072328, 94833022072328, 140721821832896, 1, 140721821832752, 94833006466294, 94833011943744, 94833011943744, 1, 94833022072328, 140721821832880, 94833006475060, 94833022872008, 94833022871809, 101531, 1,
863782347751425, 72057594037927936, 94832877895681, 1901405520149961216, 140721821832880, 1, 1, 140374854075720, 94833023081832, 94833023041352, 140721821832928, 94833006461707, 863782347751425, 72057594037927936, 1,
1901405520149961216, 140721821832976, 94833004136278, 140721821833056, 94833006368963, 140374854075720, 94833007703462, 0, 94832877895680, 140721821833104, 94833006368963, 8192, 9656843508925360256, 0, 94832877895680,
94833009026328, 94832877899733, 94833009027128, 1901405520149961216, 140721821833152, 140370932574592, 16777216, 0, 140721821833152, 1901405520149961216, 140370932574592, 94833022581928, 140371762374784, 303952, 140721821833376,
94833006375993, 1305463899554112, 140721821833296, 140721821833260, 140721821833431, 112, 140721821833264, 94833022987064, 18446744070427260766, 140370906723840, 1305463899553800, 320, 9386627527654289668, 70373039146623, 1862361,
303952, 20, 70373039146623, 1862361, 303920, 1901405520149961216, 101530, 140374854028144, 0, 303952, 140371762374784, 98565, 140374854028144, 94833022093368, 140721821833472, 94833006500083},
argnull = "\000\000\063Z\374\177\000\000\000Z\201\032?&c\001\070Υ\b(at)V\000\000\000Z\201\032?&c\032\370\232\246\b(at)V\000\000\060\000\000\000\000\000\000\000\225|\b٪\177\000\000\030ǡ\b(at)V\000\000\300\000\000\000\000\000\000\000x֥\b@V\000\000\060\331\063Z\374\177\000\000^2\276\a(at)V\000\000-\000\000"}
__func__ = "array_contain_compare"
#2 0x0000564007ada7dd in arrayoverlap (fcinfo=0x564008a5d6e8) at ./build/../src/backend/utils/adt/arrayfuncs.c:4201
array1 = 0x564008a1c718
array2 = 0x564008a6bde8
collation = <optimized out>
result = <optimized out>
#3 0x000056400799d3bc in ExecMakeFunctionResultNoSets (fcache=0x564008a5d678, econtext=0x564008a5d1e8, isNull=0x7ffc5a33da37 "", isDone=<optimized out>) at ./build/../src/backend/executor/execQual.c:2041
arg = <optimized out>
result = <optimized out>
fcinfo = 0x564008a5d6e8
fcusage = {fs = 0x0, save_f_total_time = {tv_sec = 16, tv_usec = 99952}, save_total = {tv_sec = 0, tv_usec = 140721821833735}, f_start = {tv_sec = 140371762374784, tv_usec = 303952}}
i = <optimized out>
#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
clause = <optimized out>
expr_value = <optimized out>
isNull = 0 '\000'
result = 1 '\001'
oldContext = <optimized out>
l = 0x564008a5df58
#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
slot = <optimized out>
econtext = 0x564008a5d1e8
qual = 0x564008a5df78
projInfo = 0x564008a696f8
isDone = ExprSingleResult
resultSlot = <optimized out>
#6 0x00005640079b9bb8 in ExecSeqScan (node=node(at)entry=0x564008a5d0d8) at ./build/../src/backend/executor/nodeSeqscan.c:127
No locals.
#7 0x000056400799c340 in ExecProcNode (node=node(at)entry=0x564008a5d0d8) at ./build/../src/backend/executor/execProcnode.c:419
result = <optimized out>
__func__ = "ExecProcNode"
#8 0x00005640079b5f59 in ExecModifyTable (node=node(at)entry=0x564008a5cf98) at ./build/../src/backend/executor/nodeModifyTable.c:1392
estate = 0x564008a5ccf8
operation = <optimized out>
saved_resultRelInfo = <optimized out>
resultRelInfo = 0x564008a5ce88
subplanstate = 0x564008a5d0d8
junkfilter = 0x0
slot = <optimized out>
planSlot = <optimized out>
tupleid = <optimized out>
tuple_ctid = {ip_blkid = {bi_hi = 32764, bi_lo = 0}, ip_posid = 31309}
oldtupdata = {t_len = 3, t_self = {ip_blkid = {bi_hi = 0, bi_lo = 0}, ip_posid = 53416}, t_tableOid = 22080, t_data = 0x564008a33378}
oldtuple = <optimized out>
__func__ = "ExecModifyTable"
#9 0x000056400799c380 in ExecProcNode (node=node(at)entry=0x564008a5cf98) at ./build/../src/backend/executor/execProcnode.c:396
result = <optimized out>
__func__ = "ExecProcNode"
#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
slot = <optimized out>
current_tuple_count = 0
slot = <optimized out>
current_tuple_count = <optimized out>
#11 standard_ExecutorRun (queryDesc=0x564008a29ec8, direction=<optimized out>, count=0) at ./build/../src/backend/executor/execMain.c:339
estate = 0x564008a5ccf8
operation = CMD_INSERT
dest = 0x564008a39bc0
sendTuples = <optimized out>
oldcontext = <optimized out>
#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
queryDesc = 0x564008a29ec8
__func__ = "ProcessQuery"
#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
pstmt = 0x564008a35260
stmt = 0x564008a35260
active_snapshot_set = 1 '\001'
stmtlist_item = 0x564008a3ae28
#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
save_exception_stack = 0x7ffc5a33e0d0
save_context_stack = 0x0
local_sigjmp_buf = {{__jmpbuf = {94833022679960, -3071035816762185612, 94833021892328, 94833022835648, 2, 94833022680040, -3071035816655230860, -8783771880478250892}, __mask_was_saved = 0, __saved_mask = {__val = {2817148525,
94833022425664, 94832877895681, 94833022422312, 94833009247749, 140721821834928, 88, 94833021892328, 94833009140074, 2, 94833022680040, 140721821834960, 94833007801154, 2, 94833021892328, 140721821834992}}}}
result = <optimized out>
nprocessed = <optimized out>
saveTopTransactionResourceOwner = 0x5640089a1438
saveTopTransactionContext = 0x564008934ce8
saveActivePortal = 0x0
saveResourceOwner = 0x5640089a1438
savePortalContext = 0x0
saveMemoryContext = 0x564008934ce8
__func__ = "PortalRun"
#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
parsetree = 0x564008a13b98
portal = 0x5640089536e8
snapshot_set = <optimized out>
commandTag = <optimized out>
completionTag = "\000REATE TABLE\000\000\000\000P\342\063Z\374\177\000\000^2\276\a(at)V\000\000\220\342\063Z\374\177\000\000$\343\063Z\374\177\000\000p\342\063Z\374\177\000\000\266\223\234\a@V\000"
querytree_list = <optimized out>
plantree_list = 0x564008a3b408
receiver = 0x564008a39bc0
format = 0
dest = DestRemote
oldcontext = <optimized out>
parsetree_list = 0x5640089ee958
save_log_statement_stats = 0 '\000'
was_logged = 0 '\000'
msec_str = "\340\342\063Z\374\177\000\000F\001\000\000\000\000\000\000\200\350\063Z\374\177\000\000P\344\063Z\374\177\000"
parsetree_item = 0x564008a13be8
isTopLevel = <optimized out>
dest = <optimized out>
oldcontext = <optimized out>
parsetree_list = <optimized out>
parsetree_item = <optimized out>
save_log_statement_stats = <optimized out>
was_logged = <optimized out>
isTopLevel = <optimized out>
msec_str = <optimized out>
parsetree = <optimized out>
snapshot_set = <optimized out>
commandTag = <optimized out>
completionTag = <optimized out>
querytree_list = <optimized out>
plantree_list = <optimized out>
portal = <optimized out>
receiver = <optimized out>
format = <optimized out>
stmt = <optimized out>
fportal = <optimized out>
#16 PostgresMain (argc=<optimized out>, argv=argv(at)entry=0x564008989868, dbname=<optimized out>, username=<optimized out>) at ./build/../src/backend/tcop/postgres.c:4101
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"...
firstchar = <optimized out>
input_message = {
data = 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"...,
len = 1649, maxlen = 2048, cursor = 1649}
local_sigjmp_buf = {{__jmpbuf = {140721821835376, -3071035815556323212, 1, 94833022113848, 94833022113896, 0, -3071035816743311244, -8783771878490150796}, __mask_was_saved = 1, __saved_mask = {__val = {0, 140721821835604,
140374822780832, 0, 94833012125920, 8192, 4, 94833021897870, 94833021763952, 27, 94833021897870, 140721821835664, 94833007799533, 4, 1901405520149961216, 140721821835712}}}}
send_ready_for_query = 0 '\000'
disable_idle_in_transaction_timeout = 0 '\000'
__func__ = "PostgresMain"
#17 0x0000564007831664 in BackendRun (port=0x564008981600) at ./build/../src/backend/postmaster/postmaster.c:4339
ac = 1
secs = 622763581
usecs = 141864
i = 1
av = 0x564008989868
maxac = <optimized out>
av = <optimized out>
maxac = <optimized out>
ac = <optimized out>
secs = <optimized out>
usecs = <optimized out>
i = <optimized out>
#18 BackendStartup (port=0x564008981600) at ./build/../src/backend/postmaster/postmaster.c:4013
bn = <optimized out>
pid = <optimized out>
bn = <optimized out>
pid = <optimized out>
save_errno = <optimized out>
#19 ServerLoop () at ./build/../src/backend/postmaster/postmaster.c:1722
port = <optimized out>
i = <optimized out>
rmask = {fds_bits = {32, 0 <repeats 15 times>}}
selres = <optimized out>
now = <optimized out>
readmask = {fds_bits = {96, 0 <repeats 15 times>}}
nSockets = <optimized out>
last_lockfile_recheck_time = 1569448353
last_touch_time = 1569448284
__func__ = "ServerLoop"
#20 0x0000564007a51e29 in PostmasterMain (argc=5, argv=0x564008934090) at ./build/../src/backend/postmaster/postmaster.c:1330
opt = <optimized out>
status = <optimized out>
userDoption = <optimized out>
listen_addr_saved = <optimized out>
i = <optimized out>
output_config_variable = <optimized out>
__func__ = "PostmasterMain"
#21 0x0000564007832ed2 in main (argc=5, argv=0x564008934090) at ./build/../src/backend/main/main.c:228
No locals.