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 1h8eqI-00037w-9M for pgsql-hackers@arkaria.postgresql.org; Tue, 26 Mar 2019 05:41:46 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1h8eqG-0000i1-Vv for pgsql-hackers@arkaria.postgresql.org; Tue, 26 Mar 2019 05:41:44 +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 1h8eqG-0000hu-Kw for pgsql-hackers@lists.postgresql.org; Tue, 26 Mar 2019 05:41:44 +0000 Received: from mail-wm1-x334.google.com ([2a00:1450:4864:20::334]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h8eqE-0007RX-6q for pgsql-hackers@lists.postgresql.org; Tue, 26 Mar 2019 05:41:43 +0000 Received: by mail-wm1-x334.google.com with SMTP id q16so11190831wmj.3 for ; Mon, 25 Mar 2019 22:41:42 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=33/ocxYFv/eLUWe5A4eWjakT686q0RhstpIdRvvvcUM=; b=FNrCKN/TSgPbCkLfTL8Lz2PPRO1RwSJRZ1bkOEus8cmtF8IsApN0VU79cQ8hF/Tbgd B71jjJJKA8ZQu41zH/788KoBOjPvmoD1aHfYsslSwUEY8rTNzDO49ay57UkWTPX6HNvW a05SHR6qcHt4n2xcn/t0Qfievz1+j9o/uoMuoz2XgHRf8pFzRrNPJOZ/r5MICm/gEsrB kqAkuPl4oBKJyLpAZr4NTy+ZuJvIPlWztUiR/L4jvINHe+fuKgrLouieGRrJOfCo6KDw LR3Ph7sofRHQY1mMulb4e3PYGZG89v8r/JT94npUplIUw+CKCk7D21VLLl9vn3own7oY ZWqg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=33/ocxYFv/eLUWe5A4eWjakT686q0RhstpIdRvvvcUM=; b=dy69vdPmi8SLq2yy8bxkAVA8pJ5F7QO/S/h0Kax/DlR38Yz5uPvPZJ4z4TuC0UyJg5 /xPey41gKt7+MECie7A2ftUYLg5CDsr/yA23Rjd1Kp14ie0i/rZHk1OYgyCnPT+FunVU p2DOqS6NC3dLzN+j4hlBGVmBo8VdN25v79l4tDCHobIKt1LLw/J0DfEO7CuBRHpwcxuO 2tBpwAf08m0zHvzNTVZqczXHdHxYCyF0mFhRV44aZ15+zyGmvopQoYh9WTK00ChANrJi smS3rZ9OcOsKPPgFKysKoOdTI6a3eLCjwhztGQThLNp20ym4LPfo2dtaJPXgwY/UIwhf Jm0A== X-Gm-Message-State: APjAAAX8aYkdlxEcc8E+wWwAN3mstKCr+kYn8P2xHnDuxAcFBYfaAU2F LpCcReHll6N5GhOVJ5KMODmnqL3kLuj74/ENqZc= X-Google-Smtp-Source: APXvYqx62IOkBkckWwJ7vG3Ti0GcqsfeIRclcizQ+bJc7B2UCcvSuXuviEGmXXY6iJz3nDj0x2SXbyaxeRXjNVt6ua0= X-Received: by 2002:a1c:f102:: with SMTP id p2mr8009320wmh.36.1553578900837; Mon, 25 Mar 2019 22:41:40 -0700 (PDT) MIME-Version: 1.0 References: <20180919112305.GA18604@zakirov.localdomain> In-Reply-To: From: Pavel Stehule Date: Tue, 26 Mar 2019 06:41:04 +0100 Message-ID: Subject: Re: [HACKERS] proposal: schema variables To: Erik Rijkers Cc: Artur Zakirov , Dean Rasheed , Fabien COELHO , Gilles Darold , PostgreSQL Hackers Content-Type: multipart/alternative; boundary="00000000000083db2e0584f8c6d7" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --00000000000083db2e0584f8c6d7 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable po 25. 3. 2019 v 20:40 odes=C3=ADlatel Erik Rijkers napsal: > On 2019-03-24 10:32, Pavel Stehule wrote: > > ne 24. 3. 2019 v 10:25 odes=C3=ADlatel Erik Rijkers naps= al: > > > >> On 2019-03-24 06:57, Pavel Stehule wrote: > >> > Hi > >> > > >> > rebase against current master > >> > >> I ran into this: > >> > >> (schema 'varschema2' does not exist): > >> > >> drop variable varschema2.testv cascade; > >> ERROR: schema "varschema2" does not exist > >> create variable if not exists testv as text; > >> server closed the connection unexpectedly > >> This probably means the server terminated abnormally > >> before or while processing the request. > >> connection to server was lost > >> > >> > >> (both statements are needed to force the crash) > >> > > > > I cannot to reproduce it. > > [backtrace and stuff] > > Sorry, I don't have the wherewithal to get more info but I have repeated > this now on 4 different machines (debian jessie/stretch; centos). > > I did notice that sometimes those two offending lines > " > drop variable varschema2.testv cascade; > create variable if not exists testv as text; > " > have to be repeated a few times (never more than 4 or 5 times) before > the crash occurs (signal 11: Segmentation fault). > Should be fixed now. Thank you for report Pavel > > Erik Rijkers > > > --00000000000083db2e0584f8c6d7 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


=
po 25. 3. 2019 v=C2=A020:40 odes=C3= =ADlatel Erik Rijkers <er@xs4all.nl&= gt; napsal:
On 2= 019-03-24 10:32, Pavel Stehule wrote:
> ne 24. 3. 2019 v 10:25 odes=C3=ADlatel Erik Rijkers <er@xs4all.nl> napsal:
>
>> On 2019-03-24 06:57, Pavel Stehule wrote:
>> > Hi
>> >
>> > rebase against current master
>>
>> I ran into this:
>>
>> (schema 'varschema2' does not exist):
>>
>> drop variable varschema2.testv cascade;
>> ERROR:=C2=A0 schema "varschema2" does not exist
>> create variable if not exists testv as text;
>> server closed the connection unexpectedly
>>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0This probably means the server te= rminated abnormally
>>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0before or while processing the re= quest.
>> connection to server was lost
>>
>>
>> (both statements are needed to force the crash)
>>
>
> I cannot to reproduce it.
>=C2=A0 [backtrace and stuff]

Sorry, I don't have the wherewithal to get more info but I have repeate= d
this now on 4 different machines (debian jessie/stretch; centos).

I did notice that sometimes those two offending lines
"
=C2=A0 =C2=A0drop variable varschema2.testv cascade;
=C2=A0 =C2=A0create variable if not exists testv as text;
"
have to be repeated a few times (never more than 4 or 5 times) before
the crash occurs (signal 11: Segmentation fault).

=
Should be fixed now.

Thank you for repo= rt

Pavel



Erik Rijkers


--00000000000083db2e0584f8c6d7--