RE: jsonpath

From: "Tom Turelinckx" <tom(at)turelinckx(dot)be>
To: "'Alexander Korotkov'" <a(dot)korotkov(at)postgrespro(dot)ru>, "'Andrew Dunstan'" <andrew(dot)dunstan(at)2ndquadrant(dot)com>
Cc: "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "'Andres Freund'" <andres(at)anarazel(dot)de>, "'PostgreSQL Hackers'" <pgsql-hackers(at)lists(dot)postgresql(dot)org>, "'John Naylor'" <john(dot)naylor(at)2ndquadrant(dot)com>, "'Jeff Janes'" <jeff(dot)janes(at)gmail(dot)com>, "'Nikita Glukhov'" <n(dot)gluhov(at)postgrespro(dot)ru>, "'Tomas Vondra'" <tomas(dot)vondra(at)2ndquadrant(dot)com>, "'Oleg Bartunov'" <obartunov(at)postgrespro(dot)ru>, "'Michael Paquier'" <michael(at)paquier(dot)xyz>, "'Stas Kelvich'" <s(dot)kelvich(at)postgrespro(dot)ru>, "'PostgreSQL-development'" <pgsql-hackers(at)postgresql(dot)org>, "'Thomas Munro'" <thomas(dot)munro(at)enterprisedb(dot)com>, "'David Steele'" <david(at)pgmasters(dot)net>, "'Robert Haas'" <robertmhaas(at)gmail(dot)com>, "'Pavel Stehule'" <pavel(dot)stehule(at)gmail(dot)com>
Subject: RE: jsonpath
Date: 2019-03-31 14:51:48
Message-ID: 000e01d4e7d1$4615ec50$d241c4f0$@turelinckx.be
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Alexander Korotkov wrote:

> Hmm... 550b9d26f just makes jsonpath_gram.y and jsonpath_scan.l
> compile at once. I've re-read this commit and didn't find anything
> suspicious.
> I've asked Andrew for access to jacana in order to investigate this myself.

Stack trace from skate:

[New LWP 6614]
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/lib/sparc-linux-gnu/libthread_db.so.1".
Core was generated by `postgres: pgbf regression [local] SELECT '.
Program terminated with signal 11, Segmentation fault.
#0 strlen () at ../sysdeps/sparc/sparc64/strlen.S:34
34 ldx [%o0], %o5
#0 strlen () at ../sysdeps/sparc/sparc64/strlen.S:34
#1 0x0008a3e4 in printtup (slot=0x834888, self=0x864cc0) at printtup.c:435
#2 0x00259b60 in ExecutePlan (execute_once=<optimized out>, dest=0x864cc0, direction=<optimized out>, numberTuples=0,
sendTuples=true, operation=CMD_SELECT, use_parallel_mode=<optimized out>, planstate=0x833eb0, estate=0x833d70)
at execMain.c:1686
#3 standard_ExecutorRun (queryDesc=0x7dcdc0, direction=<optimized out>, count=0, execute_once=<optimized out>)
at execMain.c:365
#4 0x00259da0 in ExecutorRun (queryDesc=0x808920, queryDesc(at)entry=0x7dcdc0,
direction=direction(at)entry=ForwardScanDirection, count=8801472, execute_once=<optimized out>) at execMain.c:309
#5 0x003e6714 in PortalRunSelect (portal=portal(at)entry=0x808920, forward=forward(at)entry=true, count=0,
count(at)entry=2147483647, dest=dest(at)entry=0x864cc0) at pquery.c:929
#6 0x003e7d3c in PortalRun (portal=portal(at)entry=0x808920, count=count(at)entry=2147483647,
isTopLevel=isTopLevel(at)entry=true, run_once=run_once(at)entry=true, dest=dest(at)entry=0x864cc0,
altdest=altdest(at)entry=0x864cc0, completionTag=completionTag(at)entry=0xff86e830 "") at pquery.c:770
#7 0x003e32d0 in exec_simple_query (
query_string=0x7ba400 "select '$.g ? (@.a == 1 || @.a == 4 && @.b == 7)'::jsonpath;") at postgres.c:1215
#8 0x003e4854 in PostgresMain (argc=<optimized out>, argv=argv(at)entry=0x7e2370, dbname=0x7e2148 "regression",
username=<optimized out>) at postgres.c:4247
#9 0x0007ae6c in BackendRun (port=0x7ddd40) at postmaster.c:4399
#10 BackendStartup (port=0x7ddd40) at postmaster.c:4090
#11 ServerLoop () at postmaster.c:1703
#12 0x00353a68 in PostmasterMain (argc=argc(at)entry=6, argv=argv(at)entry=0x7b49a8) at postmaster.c:1376
#13 0x0007cc60 in main (argc=6, argv=0x7b49a8) at main.c:228

Does this help?

Best regards,
Tom Turelinckx

In response to

  • Re: jsonpath at 2019-03-29 13:15:40 from Alexander Korotkov

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2019-03-31 15:18:23 Re: jsonpath
Previous Message Ramanarayana 2019-03-31 14:36:17 Re: Problem during Windows service start