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 1lKkxw-0007t2-5C for pgsql-bugs@arkaria.postgresql.org; Fri, 12 Mar 2021 16:48:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lKkxv-0006bL-2L for pgsql-bugs@arkaria.postgresql.org; Fri, 12 Mar 2021 16:48:43 +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 1lKkxu-0006Ye-Ny for pgsql-bugs@lists.postgresql.org; Fri, 12 Mar 2021 16:48:42 +0000 Received: from mail-qk1-x734.google.com ([2607:f8b0:4864:20::734]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lKkxn-0001Xi-Ax for pgsql-bugs@lists.postgresql.org; Fri, 12 Mar 2021 16:48:41 +0000 Received: by mail-qk1-x734.google.com with SMTP id l132so24899226qke.7 for ; Fri, 12 Mar 2021 08:48:35 -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=HjAtMu4p9kEYKD3y5qfrylBqJTit1camdlWMqp17t/Y=; b=KUFNegll/FvqHMLxLLLfqkZ0CiW3nYAzlTP2OUQ5t4MpjtXD+envVzARfruxPOF6Ok vihSYqRDMs2rCyn6hwzwKkpEalQabUvqGEUBX1Q6m1dZUTN19M5+3wK6hhXo9OeJaJ3t g4eTIxpY9h3VlhzLnjewJahuFLgVsrxK2SMH8CxaGkB03B38nYlJasmlpZ8sQIBewHP1 thwzF3/FEGlgKsshfeisACEC2UiQInWzniALUw55CLfLKFJZNsnyaHFkDKfHJMfl36BQ yM7FapNZFPWrrhPP8zXOQFqOpYcPuHFlS+ou3dE4WZQVYfy2nnoVtVBQuOfd8gGB4183 tE6w== 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=HjAtMu4p9kEYKD3y5qfrylBqJTit1camdlWMqp17t/Y=; b=JJiY4lnPZxx3CCv5nddvRn1WHE80nMUrvAglu6x1+mvUgnGiWGrkHQnsEKyQt1SeUj LNxzCbiXK9IYzQhBBu2hMBhvkEd9PRefZnAL4/jgsKl5m0+gxqSvxVZ1VlqwesdSA9gn R3e//jAhFr2h4mWNwbzcn1c11Tw+jbXJTohdOLj3ZEmS8GGUyVazJPaptMyhM0zPCibe bb2LmuldKDFIT2YAlzeWQzkP5VdXDuncaEAlJsNhN9v9+1VbjHzT2FqjpCC6JN8KT3BB uH0Pua0ytLm0U//UiUqOGeONTQdlhLV1+AX+bUaCpyrDOuvq5bI5bmjAMmDBmz6/zJYP nbWQ== X-Gm-Message-State: AOAM531MVx/p99yQDUQ8O6Bd4N2sEyEQC8m6pRlLS+kHxolJmhOHwOIP fYlT8PTLIcHfI+/EVKnzfONcIj/kFoXW6w== X-Google-Smtp-Source: ABdhPJwWKIxI3oZ44Qpx5RY5I9fpQc5a6vVBA14WgWHJks0XZhvqNyKn5dExTH2//RleLwYrclX0Eg== X-Received: by 2002:a37:a643:: with SMTP id p64mr12943266qke.276.1615567713723; Fri, 12 Mar 2021 08:48:33 -0800 (PST) Received: from F (50-78-240-110-static.hfc.comcastbusiness.net. [50.78.240.110]) by smtp.gmail.com with ESMTPSA id z5sm4675294qkz.2.2021.03.12.08.48.33 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Fri, 12 Mar 2021 08:48:33 -0800 (PST) From: "Regina Obe" To: "'Tom Lane'" Cc: 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> In-Reply-To: <2309396.1615485820@sss.pgh.pa.us> Subject: RE: BUG #16920: Can't compile PostGIS with MingW64 against PostgreSQL 14 head Date: Fri, 12 Mar 2021 11:48:31 -0500 Message-ID: <002001d7175f$8942b020$9bc81060$@pcorp.us> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Outlook 15.0 Thread-Index: AQHCjUPo5BIH9fF+WOyrxdMuyoS6VgH0iV+7AYDFGVYDOnnBIgIGZ/mnAaaow76qVrrkcA== Content-Language: en-us List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > "Regina Obe" writes: > > I was mistaken though that in the postgresql regress I do get a lot of > > failures like failure on stats. > > But many of these errors seemed to be the same as what is on the > > buildfarm > > https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=walleye&dt=202 > > 1-03-0 > > 8%2021%3A35%3A41 > > walleye's owners have so far failed to extract any useful data about why it's > been crashing. If you could provide stack traces from some of those crashes, > it'd be much appreciated. > > regards, tom lane Okay the crash on PostGIS against PostgreSQL 14 does seem to be mingw related since our debian bot passes with flying colors. Both have postgresql built with --enable-cassert (PG 13 is fine for mingw64 BTW also cassert enabled) On my mingw64 gcc 8.1.0 (cassert enabled, not sure that matters) -- in PostGIS regress - it starts crashing with this query: SELECT topology.ST_AddIsoEdge('sqlmm_topology', 1, 2, 'LINESTRING(0 0, 10 0, 5 5, 5 -5)'); Hopefully the back trace is of some help -- I'm going to try to formulate a similar one without PostGIS involvement. As far as the PostgreSQL tests, I'm not sure how to run the regress tests standalone to grab a stack trace. Suggestions welcome. Thread 1 received signal SIGSEGV, Segmentation fault. [Switching to Thread 22272.0x49ec] 0x00007ffe75f5f23f in ntdll!RtlLeaveCriticalSection () from C:\WINDOWS\SYSTEM32\ntdll.dll (gdb) bt #0 0x00007ffe75f5f23f in ntdll!RtlLeaveCriticalSection () from C:\WINDOWS\SYSTEM32\ntdll.dll #1 0x00007ffe75fd4c0e in ntdll!memset () from C:\WINDOWS\SYSTEM32\ntdll.dll #2 0x00007ffe75fbc872 in ntdll!__C_specific_handler () from C:\WINDOWS\SYSTEM32\ntdll.dll #3 0x00007ffe75fd1fef in ntdll!.chkstk () from C:\WINDOWS\SYSTEM32\ntdll.dll #4 0x00007ffe75f60939 in ntdll!RtlUnwindEx () from C:\WINDOWS\SYSTEM32\ntdll.dll #5 0x00007ffe74002eed in msvcrt!_setjmpex () from C:\WINDOWS\System32\msvcrt.dll #6 0x00000000008d929a in pg_re_throw () at elog.c:1776 #7 0x00000000008d911d in errfinish (filename=, lineno=, funcname=0x6b025560 <__func__.114531> "pg_error") at elog.c:589 #8 0x000000006afc91d3 in pg_error (fmt=, ap=) at lwgeom_pg.c:250 #9 0x000000006afdfb03 in lwerror (fmt=0x0) at lwutil.c:197 #10 0x000000006b000c16 in lwt_AddIsoEdge (topo=topo@entry=0x83629b0, startNode=startNode@entry=1, endNode=endNode@entry=2, geom=geom@entry=0x7a303b8) at lwgeom_topo.c:794 #11 0x000000006afc70d2 in ST_AddIsoEdge (fcinfo=0x7a2caa8) at postgis_topology.c:3567 #12 0x00000000005f7604 in ExecInterpExpr (state=0x7a2c9c0, econtext=0x7a2c6c0, isnull=) at execExprInterp.c:1209 #13 0x000000000062f23f in ExecEvalExprSwitchContext (isNull=0x509ef9f, econtext=0x7a2c6c0, state=0x7a2c9c0) at ../../../src/include/executor/executor.h:315 #14 ExecProject (projInfo=0x7a2c9b8) at ../../../src/include/executor/executor.h:349 #15 ExecResult (pstate=) at nodeResult.c:136 #16 0x00000000005fc0ca in ExecProcNode (node=0x7a2c5a8) at ../../../src/include/executor/executor.h:247 #17 ExecutePlan (execute_once=, dest=0x7a2b2e8, direction=, numberTuples=0, sendTuples=, operation=CMD_SELECT, use_parallel_mode=, planstate=0x7a2c5a8, estate=0x7a2c370) at execMain.c:1531 #18 standard_ExecutorRun (queryDesc=0x8338990, direction=, count=0, execute_once=) at execMain.c:350 #19 0x00000000007a08cb in PortalRunSelect (portal=0x79bcc70, portal@entry=0x7fffffff, forward=forward@entry=true, count=count@entry=0, dest=dest@entry=0x7a2b2e8) at pquery.c:912 #20 0x00000000007a20cc in PortalRun (portal=0x7fffffff, portal@entry=0x79bcc70, count=0, count@entry=2147483647, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x7a2b2e8, altdest=altdest@entry=0x7a2b2e8, qc=qc@entry=0x509f2d0) at pquery.c:756 #21 0x000000000079d6ab in exec_simple_query ( query_string=0x79fd1e0 "SELECT topology.ST_AddIsoEdge('sqlmm_topology', 1, 2, 'LINESTRING(0 0, 10 0, 5 5, 5 -5)');") at postgres.c:1173 #22 0x000000000079ee40 in PostgresMain (argc=argc@entry=1, argv=argv@entry=0x509f980, dbname=, username=) at postgres.c:4327 #23 0x0000000000708608 in BackendRun (port=0x509f7c0, port=0x509f7c0) at postmaster.c:4464 #24 SubPostmasterMain (argc=argc@entry=3, argv=argv@entry=0x5176af0) at postmaster.c:4977 #25 0x000000000093cb13 in main (argc=3, argv=0x5176af0) at main.c:186