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 1h9UoB-00021e-QX for pgsql-hackers@arkaria.postgresql.org; Thu, 28 Mar 2019 13:11:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1h9Uo9-00048t-TY for pgsql-hackers@arkaria.postgresql.org; Thu, 28 Mar 2019 13:11:01 +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 1h9Uo9-00048m-Cu for pgsql-hackers@lists.postgresql.org; Thu, 28 Mar 2019 13:11:01 +0000 Received: from mail-ot1-x342.google.com ([2607:f8b0:4864:20::342]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h9Uo3-0008RI-Ns for pgsql-hackers@postgresql.org; Thu, 28 Mar 2019 13:10:59 +0000 Received: by mail-ot1-x342.google.com with SMTP id f10so18233974otb.6 for ; Thu, 28 Mar 2019 06:10:55 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=from:subject:to:cc:references:openpgp:autocrypt:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding :content-language; bh=I+ePwG/eeq+9QF3fkeOYhZvxmyw8GRkWwuV36D+LMns=; b=CZZjJdDI9q7AjjCADNGRKhycwquyXNdrqWxf0Auv5DXjoA9b11ASWDfPPdodwjznE7 m4PxoUaenpdiqiuYudFtiXnVwm0Vzw6HEd93W4nhQwLd3RuGjMwSU7LT+eQXgu6huXLi tu5qCMKOSfuLEf3Q2DlhghtZeTd4c1urG+aJx2HERy0rwmK6DWNB5ns+/ETj+9aLHR3T xtHzMTdNGsrEjouZk6qa82bZDFEAZ5hdYkbbdLC+K90lY83BEAZOOTnFPY26S5rBkV3D YXaog7jyoGCZyczXcz+SGj0HtOFQYf3N8blWaXQny8JtL0NVtNxYPySahrIZ+miQ+Jex 49qQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:subject:to:cc:references:openpgp:autocrypt :message-id:date:user-agent:mime-version:in-reply-to :content-transfer-encoding:content-language; bh=I+ePwG/eeq+9QF3fkeOYhZvxmyw8GRkWwuV36D+LMns=; b=HYHi2S18/UTwBgzIh85EmuxEgBFVhXXAlKTAq+qNYa8F7mRRjv4qh98LPEJB65wvhP 7vjkTJ7TpMVoFi8ahZHxrfVNVJxDFwovzZuOD5QcItNZVDGOrFNHlejRSpUciicZsKkL uMV1u3+REKYyR2B5FwX9+Qozyts2/cNnSz03kXXqFX80YyA1QGDd/5tNumkymRtgfM3g DS3ltBaAV5OEhVbZu4RisLJy3mJSrm79dFCeS8QxJ11Omjbc4oaYl/ArAYlcnpjvWQ79 yrXYUBK7PY3HKwb04XXW0aNW6l/FN7laCGzMznOPoNXSrupBHR22mX3YslgJWKthDQfJ 7lwA== X-Gm-Message-State: APjAAAW5cFsgUqIf/XtAEt7HT8iFgTGT1McqBPU0XfnsuP9u4QEC287W MOPNeLt/PUpIDIsH5ypyz3v/ X-Google-Smtp-Source: APXvYqyYU8YktxtZOWUx/b5O+FVrRzAokT23ISDkiGUwd0Mx+bSdlLwSZ9vXwVyv9/er9ZWXBaCWtw== X-Received: by 2002:a9d:862:: with SMTP id 89mr31215948oty.66.1553778654855; Thu, 28 Mar 2019 06:10:54 -0700 (PDT) Received: from [192.168.10.146] (99-10-92-30.lightspeed.rlghnc.sbcglobal.net. [99.10.92.30]) by smtp.gmail.com with ESMTPSA id z12sm5112437otp.2.2019.03.28.06.10.52 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Thu, 28 Mar 2019 06:10:53 -0700 (PDT) From: Andrew Dunstan X-Google-Original-From: Andrew Dunstan Subject: Re: jsonpath To: Alexander Korotkov Cc: Tom Lane , 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 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> Openpgp: preference=signencrypt Autocrypt: addr=andrew.dunstan@2ndQuadrant.com; prefer-encrypt=mutual; keydata= xsBNBE7KWFkBCAClridxur2AIc7eW2AR7izbfp3EnNefie2HbLF0izW5Ik5UjX2HBXBx4syI gY6b0ugohXrr274+baoAlvSbq6cAoQuEVrk5IZFzt20b1Xkx65FwGSEj526yiKLocqkJceSq Xr9xcA5SGY+FZv441chh5SU92v4q6z+6LPpoHOh97ptAVXZYNTtU0LevyvD5lja0TzbvJm6C eFXitJfnm1pLEr0DGJCR/iUOl/N62Kh4855zZC7NHIjQHPOvV5Stz/l5ilDhvGVk+xkXFPys SjZoUr1rXhYLpiyi5sR0X9FHXT0KnGuz1F5ERO7ZTLSSQ6fJwPj6gOk9K+vvoKvoeql5ABEB AAHNL0FuZHJldyBEdW5zdGFuIDxhbmRyZXcuZHVuc3RhbkAybmRRdWFkcmFudC5jb20+wsCY BBMBAgBCAhsDBgsJCAcDAgYVCAIJCgsEFgIDAQIeAQIXgAUJDyV6hBYhBOQ+WEYd/Hy/RGkV pZn6f8tZ/DuBBQJcH/EVAhkBAAoJEJn6f8tZ/DuB7BEH/iDWZEbVft2m2MT6SPjARzTupt/l xLLZ/Cl6n2US2hov5+fBbnR5xvECk/YCOfG9ICvKNlpFjceqNLRKStd8cmndnI+kDw91uNM2 hpL4aJMeW65XCHvqXlOLSwv5chBpXz9NG7FMaJ+q+59sWEWjcTNmjXgkEHn53y+1pc7nSLDe cr5ZI1aB3nGXRm1SoDY5PYZkUKMykW+YBZwgcs/Q5tRaE+siN7DKbz8E628+PerwAkmHPVXN MdJFD6gs4S0gDFA8IxcyIwZU2v4By+brzcJ9Se3FK5BYxBDHtaYZxgSrJAvOUOrLIZPQTQfL TtnVs3C3JTfrxCH1ceHtnA6dRuTOwE0ETspYWQEIANGc4zQULOxhbqO2dyD51YhqCNRmm9oK Waqf+wmW4tpDe/VVcxAnNizd4LWCHfzpb5cHAtGkOPePMfzWVf6nvdF7d3eglbtf59+zG7O7 llV0xSSoFiieQBsrGvqDInXYX/4mRRXMtyhM353/tixC9RWLs1oofyYmCPPXXY7h9R7en3B8 BoVrRFcdzlIY/NFNhFGW/9dkEiGjgna2Rk6e15kln4ZvFBWUg23p93w/pqXcxY6+k/8TEk+C 4R+M6w7o2PLGOjdZ+kPiUcw5H85zf/yZJwQXzisXaNduwWB6Vads9YC9dj6kPR1c4VGRqAaY L++LAEOqrlvm2TvqQqZRtnEAEQEAAcLAZQQYAQIADwIbDAUCXA6fpAUJDyV6xAAKCRCZ+n/L Wfw7geU4B/9vFFsVmWxerDWgNjyiK80zIPmlw/iwdUlU6FIu0JWLMg4093kvxBs7RMZV9hBq n3ekBvD4IvFsVLJrw9qzSI2FH3UeYy5WXpEs01Ppia60NOlvRDqXbryzuvfe+iYo6bVP3Ikr TPTNYL/BePUTD2DPvSI82SbGTyzuA7SJv6NRqqQDMIy1fU6KyQFLmQJp/QJyhKWzm9jWh8ee w8jVaoMY0Kbq5N7RqisEx1Lu/Iw646UphdYzQNymf+kbiU5Kf4I6DhzV8w9sie1Bo1juNj3I c5/fFJsmxljbnaDbXPcnFsur1Oo9mIHFakgWgOBMuxoWfjONiLjjLh/9+ZIqSSLX Message-ID: Date: Thu, 28 Mar 2019 09:10:51 -0400 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.3.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit Content-Language: en-MW List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk 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