pg.ddx.io pgsql-hackers@postgresql.org mailing list archive help / color / mirror / Atom feed From: Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
To: Alexander Korotkov <a.korotkov@postgrespro.ru>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Andres Freund <andres@anarazel.de>
Cc: John Naylor <john.naylor@2ndquadrant.com>
Cc: Jeff Janes <jeff.janes@gmail.com>
Cc: Nikita Glukhov <n.gluhov@postgrespro.ru>
Cc: Tomas Vondra <tomas.vondra@2ndquadrant.com>
Cc: Oleg Bartunov <obartunov@postgrespro.ru>
Cc: Michael Paquier <michael@paquier.xyz>
Cc: Stas Kelvich <s.kelvich@postgrespro.ru>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Cc: Thomas Munro <thomas.munro@enterprisedb.com>
Cc: David Steele <david@pgmasters.net>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: Pavel Stehule <pavel.stehule@gmail.com>
Subject: Re: jsonpath
Date: Thu, 28 Mar 2019 09:10:51 -0400
Message-ID: <dcff626f-d44d-ad96-ecc0-109601e2cfb9@2ndQuadrant.com> (raw )
In-Reply-To: <CAPpHfdsZvAQUQg6jjv4VU_Yn=_dhinmftZxLWK6EZuZY+Aq3Ng@mail.gmail.com >
References: <CAMkU=1w1qBvoW82ZTFpAKae027R-2OHw-m6ALe0VQRNAFueBVA@mail.gmail.com >
<CAPpHfdvbbVfgjm7Y0QQK8cmp4oXKQ1btXVk7arQKqHQqtX3TLg@mail.gmail.com >
<CAPpHfdskvCZhGFHKZ49iX9=5z5Yk+2LXyKQ_XeCx7cHziV1znQ@mail.gmail.com >
<CACPNZCt9dFP=LovsjXKNCtpEG32dkWLDVOo_9+XP406Ob_ptbw@mail.gmail.com >
<CAPpHfdu6meyXZtyWL6vw0P54tJO8VCUL5my5qcfi29C4DDvACQ@mail.gmail.com >
<20190324164458.srta7sz5ffizkqv5@alap3.anarazel.de >
<CAPpHfdsK2+UsN9SCH0Ck8745S-eOeE5GEjzS0GoKwKYm=pt_Lw@mail.gmail.com >
<CAPpHfduLp+WgnhgOWSebUL0UCw9uYrXAkZr2=9Js0eUe0f0wuA@mail.gmail.com >
<6060.1553610709@sss.pgh.pa.us >
<CAPpHfdvzvSSw6=C4JTDuxj1OjdNvVm7ncvLmY0fWr5dDH9qYfQ@mail.gmail.com >
<CAPpHfdsXWZFWXuWXKKavtbw8taZ6QRzEwB6Nf2DX19z1HKFuPQ@mail.gmail.com >
<16120.1553694533@sss.pgh.pa.us >
<565a6051-b9df-3e94-b858-abce0f8b6436@2ndQuadrant.com >
<CAPpHfdvkMdV_nQR3gO41GWJS=2Gjdrm6QhhYH2DwXJ+fMa6gBw@mail.gmail.com >
<23e82578-b648-ab57-a4af-791abccff344@2ndQuadrant.com >
<CAPpHfdsZvAQUQg6jjv4VU_Yn=_dhinmftZxLWK6EZuZY+Aq3Ng@mail.gmail.com >
On 3/28/19 8:49 AM, Alexander Korotkov wrote:
>
>> Here's an interesting data point. If I run the whole jsonpath.sql script
>> it crashes every time. If I run just the offending statement it crashes
>> exactly every other time. It looks like in that case something gets
>> clobbered and then cleared.
> Could you clarify this a bit? What is exactly every other time? Do
> you mean it doesn't crash first time, but crashes second time? Do you
> run each offending statement in the separate session? Or do you run
> multiple offending statements in the same session?
>
I mean repeated invocations of
psql -c "select '$ ? (@ like_regex \"pattern\" flag \"a\")'::jsonpath"
These get crash, no crash, crash, no crash ...
cheers
andrew
--
Andrew Dunstan https://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
view thread (198+ messages) latest in thread
Message-ID: <dcff626f-d44d-ad96-ecc0-109601e2cfb9@2ndQuadrant.com>
Permalink: ../dcff626f-d44d-ad96-ecc0-109601e2cfb9@2ndQuadrant.com/
Also on: postgresql.org/message-id/dcff626f-d44d-ad96-ecc0-109601e2cfb9@2ndQuadrant.com
copy link · copy postgr.es
reply Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: andrew.dunstan@2ndquadrant.com, a.korotkov@postgrespro.ru, tgl@sss.pgh.pa.us, andres@anarazel.de, john.naylor@2ndquadrant.com, jeff.janes@gmail.com, n.gluhov@postgrespro.ru, tomas.vondra@2ndquadrant.com, obartunov@postgrespro.ru, michael@paquier.xyz, s.kelvich@postgrespro.ru, thomas.munro@enterprisedb.com, david@pgmasters.net, robertmhaas@gmail.com, pavel.stehule@gmail.com
Subject: Re: jsonpath
In-Reply-To: <dcff626f-d44d-ad96-ecc0-109601e2cfb9@2ndQuadrant.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox