BUG #18035: Assertion failure in jsonb_path_query

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: a(dot)kozhemyakin(at)postgrespro(dot)ru
Subject: BUG #18035: Assertion failure in jsonb_path_query
Date: 2023-07-25 08:57:58
Message-ID: 18035-64af5cdcb5adf2a9@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 18035
Logged by: Alexander Kozhemyakin
Email address: a(dot)kozhemyakin(at)postgrespro(dot)ru
PostgreSQL version: 16beta2
Operating system: Ubuntu 22.04
Description:

Hello,
On REL_16_BETA2 the following query: select jsonb_path_query('{}', '($[0]
like_regex "").type()');
produces assert for me:
#0 __pthread_kill_implementation (no_tid=0, signo=6,
threadid=140056864479808) at ./nptl/pthread_kill.c:44
#1 __pthread_kill_internal (signo=6, threadid=140056864479808) at
./nptl/pthread_kill.c:78
#2 __GI___pthread_kill (threadid=140056864479808, signo=signo(at)entry=6) at
./nptl/pthread_kill.c:89
#3 0x00007f618a283476 in __GI_raise (sig=sig(at)entry=6) at
../sysdeps/posix/raise.c:26
#4 0x00007f618a2697f3 in __GI_abort () at ./stdlib/abort.c:79
#5 0x0000561da5cc266f in ExceptionalCondition (
conditionName=conditionName(at)entry=0x561da5e70778 "v->type == jpiString
|| v->type == jpiNumeric || v->type == jpiBool || v->type == jpiNull ||
v->type == jpiKey || v->type == jpiAny || v->type == jpiAnyArray || v->type
== jpiAnyKey || v->type == jpiI"..., fileName=fileName(at)entry=0x561da5e70ccc
"jsonpath.c", lineNumber=lineNumber(at)entry=977) at assert.c:66
#6 0x0000561da5c0a4bb in jspGetNext (v=v(at)entry=0x7ffc228330e0,
a=a(at)entry=0x7ffc22833020) at jsonpath.c:977
#7 0x0000561da5c0be3d in appendBoolResult (res=jpbUnknown,
found=0x7ffc22833190, jsp=0x7ffc228330e0, cxt=0x7ffc22833110) at
jsonpath_exec.c:2067
#8 executeItemOptUnwrapTarget (cxt=0x7ffc22833110, jsp=0x7ffc228330e0,
jb=0x7ffc228330c0, found=0x7ffc22833190, unwrap=<optimized out>) at
jsonpath_exec.c:641
#9 0x0000561da5c0d5e1 in executeItem (found=0x7ffc22833190,
jb=0x7ffc228330c0, jsp=0x7ffc228330e0, cxt=0x7ffc22833110) at
jsonpath_exec.c:603
#10 executeJsonPath (path=0x561da77fc6b0, vars=0x561da77fc740,
json=0x561da77fc698, throwErrors=<optimized out>, result=0x7ffc22833190,
useTz=<optimized out>) at jsonpath_exec.c:589
#11 0x0000561da5c0dc44 in jsonb_path_query_internal (fcinfo=0x561da78b4298,
tz=<optimized out>) at jsonpath_exec.c:420
#12 0x0000561da59c7466 in ExecMakeFunctionResultSet (fcache=0x561da78aec70,
econtext=econtext(at)entry=0x561da78ae270, argContext=0x561da78b5e60,
isNull=0x561da78aec00, isDone=isDone(at)entry=0x561da78aec58) at
execSRF.c:625
#13 0x0000561da59f130f in ExecProjectSRF (node=node(at)entry=0x561da78ae160,
continuing=continuing(at)entry=false) at nodeProjectSet.c:175
#14 0x0000561da59f13ec in ExecProjectSet (pstate=0x561da78ae160) at
nodeProjectSet.c:105
#15 0x0000561da59bdb8a in ExecProcNode (node=0x561da78ae160) at
../../../src/include/executor/executor.h:273
#16 ExecutePlan (execute_once=<optimized out>, dest=0x561da78a92e8,
direction=<optimized out>, numberTuples=0, sendTuples=true,
operation=CMD_SELECT, use_parallel_mode=<optimized out>,
planstate=0x561da78ae160, estate=0x561da78adf38) at execMain.c:1670
#17 standard_ExecutorRun (queryDesc=0x561da7756318, direction=<optimized
out>, count=0, execute_once=<optimized out>) at execMain.c:365
#18 0x0000561da5b845df in PortalRunSelect (portal=0x561da784e548,
forward=<optimized out>, count=0, dest=<optimized out>) at pquery.c:924
#19 0x0000561da5b85ca0 in PortalRun (portal=portal(at)entry=0x561da784e548,
count=count(at)entry=9223372036854775807, isTopLevel=isTopLevel(at)entry=true,
run_once=run_once(at)entry=true, dest=dest(at)entry=0x561da78a92e8,
altdest=altdest(at)entry=0x561da78a92e8,
qc=0x7ffc22833570) at pquery.c:768
#20 0x0000561da5b81bb6 in exec_simple_query (query_string=0x561da77d40d8
"select jsonb_path_query('{}', '($[0] like_regex \"\").type()');") at
postgres.c:1274
#21 0x0000561da5b83355 in PostgresMain (dbname=<optimized out>,
username=<optimized out>) at postgres.c:4632
#22 0x0000561da5aea970 in BackendRun (port=0x561da77ff580) at
postmaster.c:4461
#23 BackendStartup (port=0x561da77ff580) at postmaster.c:4189
#24 ServerLoop () at postmaster.c:1779
#25 0x0000561da5aebb83 in PostmasterMain (argc=argc(at)entry=3,
argv=argv(at)entry=0x561da773fbf0) at postmaster.c:1463
#26 0x0000561da57ed4ee in main (argc=3, argv=0x561da773fbf0) at main.c:198

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Черников Д А 2023-07-25 09:30:24 Add instructions for downloading Linux (Mint)
Previous Message Masahiko Sawada 2023-07-25 07:35:54 Re: BUG #18031: Segmentation fault after deadlock within VACUUM's parallel worker