Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lKqc9-0005Zy-PI for pgsql-bugs@arkaria.postgresql.org; Fri, 12 Mar 2021 22:50:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lKqc8-0001tm-Ig for pgsql-bugs@arkaria.postgresql.org; Fri, 12 Mar 2021 22:50:36 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lKqc8-0001tf-8b for pgsql-bugs@lists.postgresql.org; Fri, 12 Mar 2021 22:50:36 +0000 Received: from mail-qv1-xf2d.google.com ([2607:f8b0:4864:20::f2d]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lKqc5-0004OG-IT for pgsql-bugs@lists.postgresql.org; Fri, 12 Mar 2021 22:50:35 +0000 Received: by mail-qv1-xf2d.google.com with SMTP id j17so5074121qvo.13 for ; Fri, 12 Mar 2021 14:50:33 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=pcorp-us.20150623.gappssmtp.com; s=20150623; h=from:to:cc:references:in-reply-to:subject:date:message-id :mime-version:content-transfer-encoding:thread-index :content-language; bh=9ytGeK6pJZAaUy4XXb7yyK38p3r+O09G+a/J3dnUKRU=; b=RX8v/ejTLJsXghJYgrsmIT/Q8sjo7tQS1aB9qq7MraNyoeZtA1g+3f5hlT9n73ObaA CHGEUKIyq2Z5ROlHTjQ7VyI1ZjjUeP+YOfJPbO5c7qgIJ0qWhZUwigIDXKITlIAWNEe0 GcX1sgebZ43Ym82k3aFwQfCeEkkmZktvXzz4XTrdaCQQQB64D4RNytHqZGVv8tqpqbDg t8qtnSqBo11gaGMecBSuc/BM5rCAoHaY+hXOjwuM5AImTlyqRmGK6GOW7GgsKsNC+M7J 1+cc46mW04669lvUllhZi2TVx34wlqAkNpN9qOHEcQGckmIn+l54UwmrbFd3HVxziWQo 0Dxg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:to:cc:references:in-reply-to:subject:date :message-id:mime-version:content-transfer-encoding:thread-index :content-language; bh=9ytGeK6pJZAaUy4XXb7yyK38p3r+O09G+a/J3dnUKRU=; b=XT/TrbKN1bWV00D1/luvjQH2ucAjXRMZKepJU+efwTUtR2K1tHVCzaihH9mWIZzJQI 9wtkdL8gv5Z0yDZglHd9OxzsRbvPF5nt2xlcP5qcmieMBPVD3id9O3riB2QKIIdvLFmo x3aXXxNF85P3GG/0juslPqlyTEmbH7Xggq5paZCaNTH0trbhtIMQCAbzeQC5U3eLk7LV bQYtUVpzOl6XjbE0tKG0a6YqGXdMc1D/Pfkqwef4aR/0amERCx77N5az3IWFXTWBOmS5 ZwUdVkfxVhe6PVUmamb4ZLMyrtE2R41XmF6/y2eNVVMv/t9Kkyx6lPC6tmtAI8iGF71v k9mA== X-Gm-Message-State: AOAM531uN/NBIgdVNTb4oW9migpynOl2Cu6VoiAQ/iaIUaumobBXiybL yS2nrRp9Vw9KpGLhvr4t6fujAg== X-Google-Smtp-Source: ABdhPJwitMp531D2WgBW2qQwtmo+RDfQ85oa0m6C+yZARLF0CqBa3YKhIHKus6/trH45S8t7kCeH5g== X-Received: by 2002:a0c:a954:: with SMTP id z20mr14395252qva.29.1615589432462; Fri, 12 Mar 2021 14:50:32 -0800 (PST) Received: from F (50-78-240-110-static.hfc.comcastbusiness.net. [50.78.240.110]) by smtp.gmail.com with ESMTPSA id e18sm4791353qtr.52.2021.03.12.14.50.31 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Fri, 12 Mar 2021 14:50:32 -0800 (PST) From: "Regina Obe" To: "'Tom Lane'" Cc: =?iso-8859-1?Q?'Juan_Jos=E9_Santamar=EDa_Flecha'?= , "'PostgreSQL mailing lists'" References: <16920-2332590daf58407c@postgresql.org> <2291040.1615474929@sss.pgh.pa.us> <000501d71691$c616a200$5243e600$@pcorp.us> <2294904.1615480631@sss.pgh.pa.us> <000401d716a0$1ed0fc70$5c72f550$@pcorp.us> <2309396.1615485820@sss.pgh.pa.us> <004301d71772$f3336020$d99a2060$@pcorp.us> <2551612.1615579995@sss.pgh.pa.us> <000201d71781$a0c5da20$e2518e60$@pcorp.us> <2555584.1615585679@sss.pgh.pa.us> In-Reply-To: <2555584.1615585679@sss.pgh.pa.us> Subject: RE: BUG #16920: Can't compile PostGIS with MingW64 against PostgreSQL 14 head Date: Fri, 12 Mar 2021 17:50:29 -0500 Message-ID: <000201d71792$1a916800$4fb43800$@pcorp.us> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Outlook 15.0 Thread-Index: AQHCjUPo5BIH9fF+WOyrxdMuyoS6VgH0iV+7AYDFGVYDOnnBIgIGZ/mnAaaow74Bzev/wgGR2sHjAR4fNg4C5B6w8QGN1Pv+qg+iL5A= Content-Language: en-us List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > "Regina Obe" writes: > > The backtrace of that looks like this: > > > #0 0x00007ffe76032136 in ntdll!RtlRaiseStatus () > > #3 0x00000000008da31a in pg_re_throw () at elog.c:1776 > ... > > > I'll go thru the other tests to see which ones are crashes and provide > > a bt of those too if you find it useful. > > Anyway at a glance they all seem to be on tests designed to throw an error. > > It does look suspiciously like something is broken in our attempt to longjmp > back to the server's outermost loop. We had a similar report last fall, also > about MinGW: > > https://www.postgresql.org/message-id/flat/CA%2BBEBhvHhM-Bn628pf- > LsjqRh3Ang7qCSBG0Ga%2B7KwhGqrNUPw%40mail.gmail.com > > and I don't think we ever figured out what was happening there either. > > (FWIW, walleye's owners report that the failure goes away when they change > their compiler options to more debug-friendly settings. Hmm.) > > regards, tom lane What is considered a more debug-friendly setting? My configure looks like this: ./configure --prefix=${PROJECTS}/postgresql/rel/pg${PG_VER}\ --build=${MINGHOST} \ --with-pgport=8447 --enable-cassert --enable-debug \ --with-zlib --with-libxml If I take out the --enable-cassert switch, all tests pass and no crashers. As far as crashers go, they all seem to be crashing at the 0x00000000008da31a in pg_re_throw () at elog.c:1776 Line FWIW: These are the crashers: # CRASHERS copyselect - crash #3 0x00000000008da31a in pg_re_throw () at elog.c:1776 copydml - crash - copy (insert into copydml_test default values) to stdout; #3 0x00000000008da31a in pg_re_throw () at elog.c:1776 create_index - crash test vacuum ... FAILED #crash test transactions ... FAILED (test process exited with exit code 2) 174 ms test subscription #crash test foreign_data ... FAILED (test process exited with exit code 2) 191 ms test jsonb_jsonpath ... FAILED (test process exited with exit code 2) 150 ms test xml ... FAILED (test process exited with exit code 2) 142 ms #These ones aren't crashing but failing regression when --enable-cassert is on test select ... FAILED 102 ms test inherit ... FAILED 2024 ms test sanity_check ... FAILED test join ... FAILED 948 ms test aggregates ... FAILED 6478 ms test portals ... FAILED 515 ms test arrays ... FAILED 261 ms test brin ... FAILED 515 ms test groupingsets ... FAILED 370 ms test misc_functions ... FAILED 302 ms test rules ... FAILED 1264 ms test psql ... FAILED 406 ms test amutils ... FAILED 58 ms test select_parallel ... FAILED 1962 ms test limit ... FAILED 99 ms test alter_table ... FAILED 4693 ms test rowtypes ... FAILED 266 ms test stats ... FAILED 34207 ms I don't think I've recompiled PG13 that recently so I wonder if my build is too old to see the PG13 ones you linked to. I'll try rebuilding that to see if I see similar issues. Thanks, Regina