Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h9V86-0003Eg-Un for pgsql-hackers@arkaria.postgresql.org; Thu, 28 Mar 2019 13:31:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1h9V85-0001n8-HM for pgsql-hackers@arkaria.postgresql.org; Thu, 28 Mar 2019 13:31:37 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h9V85-0001n1-5W for pgsql-hackers@lists.postgresql.org; Thu, 28 Mar 2019 13:31:37 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h9V82-0000Tu-P9 for pgsql-hackers@postgresql.org; Thu, 28 Mar 2019 13:31:35 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id x2SDVERf004972; Thu, 28 Mar 2019 09:31:15 -0400 From: Tom Lane To: Andrew Dunstan cc: Alexander Korotkov , Andres Freund , John Naylor , Jeff Janes , Nikita Glukhov , Tomas Vondra , Oleg Bartunov , Michael Paquier , Stas Kelvich , PostgreSQL-development , Thomas Munro , David Steele , Robert Haas , Pavel Stehule Subject: Re: jsonpath In-reply-to: References: <20190324164458.srta7sz5ffizkqv5@alap3.anarazel.de> <6060.1553610709@sss.pgh.pa.us> <16120.1553694533@sss.pgh.pa.us> <565a6051-b9df-3e94-b858-abce0f8b6436@2ndQuadrant.com> <23e82578-b648-ab57-a4af-791abccff344@2ndQuadrant.com> Comments: In-reply-to Andrew Dunstan message dated "Thu, 28 Mar 2019 09:10:51 -0400" MIME-Version: 1.0 Content-Type: text/plain; charset="UTF-8" Content-ID: <4970.1553779874.1@sss.pgh.pa.us> Content-Transfer-Encoding: quoted-printable Date: Thu, 28 Mar 2019 09:31:14 -0400 Message-ID: <4971.1553779874@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Andrew Dunstan writes: > I mean repeated invocations of > =C2=A0=C2=A0=C2=A0 psql -c "select '$ ? (@ like_regex \"pattern\" flag \= "a\")'::jsonpath" > These get crash, no crash, crash, no crash ... That is just wacko ... but it does seem to support my thought of a wild store somewhere. The mechanism for this case might be that memory layout is different depending on whether we had to rebuild the relcache init file at session start or not. Similarly, the fact that the full test script reliably crashes might be dependent on previous commands having left things in a certain state. Unfortunately that gets us little closer to a fix. Has anybody gotten through a valgrind run on this code yet? regards, tom lane