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 1prffv-0003cc-Mk for pgsql-committers@arkaria.postgresql.org; Wed, 26 Apr 2023 13:59:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1prfft-00077G-HJ for pgsql-committers@arkaria.postgresql.org; Wed, 26 Apr 2023 13:59:13 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1prfft-000777-8c for pgsql-committers@lists.postgresql.org; Wed, 26 Apr 2023 13:59:13 +0000 Received: from relay3-d.mail.gandi.net ([217.70.183.195]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1prffq-005BS0-2B for pgsql-committers@lists.postgresql.org; Wed, 26 Apr 2023 13:59:12 +0000 Received: (Authenticated sender: adsend@dunslane.net) by mail.gandi.net (Postfix) with ESMTPSA id A942D6000D; Wed, 26 Apr 2023 13:59:06 +0000 (UTC) Content-Type: multipart/alternative; boundary="------------E4czELWWxge629NRKzdDA9f2" Message-ID: <6efeb45a-07f9-2291-c8f8-9fb4abbb6ebc@dunslane.net> Date: Wed, 26 Apr 2023 09:59:05 -0400 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.5.0 Content-Language: en-US From: Andrew Dunstan To: Andres Freund Cc: Tom Lane , pgsql-committers@lists.postgresql.org References: <08dd6053-deee-52e9-954b-eb69232905c9@dunslane.net> <2506819.1681761221@sss.pgh.pa.us> <7d7dcc20-ba19-5340-9be8-f255e8b42edc@dunslane.net> <20230420150652.jciazjap223iznjp@awork3.anarazel.de> <5bddd941-9819-6655-7a71-3f346050583e@dunslane.net> Subject: issue with meson builds on msys2 In-Reply-To: <5bddd941-9819-6655-7a71-3f346050583e@dunslane.net> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------E4czELWWxge629NRKzdDA9f2 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit [redirecting to -hackers] On 2023-04-20 Th 15:37, Andrew Dunstan wrote: > > > On 2023-04-20 Th 11:06, Andres Freund wrote: >> On 2023-04-17 16:22:30 -0400, Andrew Dunstan wrote: >>> I am still having Windows issues with meson, but only with MSYS2. >> Any more details on that? I might be able to help out / improve things. > > > For some reason which makes no sense to me the buildfarm animal fails > at the first Stop-Db step. The DB is actually stopped, but pg_ctl > returns a non-zero status. The thing that's really odd is that meson > isn't at all involved in this step. But it's happened enough that I've > had to back off using meson builds on fairywren - I'm going to do more > testing on a new Windows instance. > Still running into this, and I am rather stumped. This is a blocker for buildfarm support for meson: Here's a simple illustration of the problem. If I do the identical test with a non-meson build there is no problem: pgrunner@EC2AMAZ-GCB871B UCRT64 ~/bf $ export PGCTLTIMEOUT=300 pgrunner@EC2AMAZ-GCB871B UCRT64 ~/bf $ /usr/bin/perl -e 'chdir "root/HEAD/instkeep.2023-04-25_11-09-41"; system("bin/pg_ctl -D data-C -l logfile start") ; print "fail\n" if $?; ' waiting for server to start.... done server started pgrunner@EC2AMAZ-GCB871B UCRT64 ~/bf $ /usr/bin/perl -e 'chdir "root/HEAD/instkeep.2023-04-25_11-09-41"; system("bin/pg_ctl -D data-C -l logfile stop") ; print "fail\n" if $?; ' waiting for server to shut down....fail pgrunner@EC2AMAZ-GCB871B UCRT64 ~/bf $ tail root/HEAD/instkeep.2023-04-25_11-09-41/logfile 2023-04-26 12:44:50.188 UTC [5132:2] LOG:  listening on Unix socket "C:/tools/msys64/tmp/buildfarm-jaWBkm/.s.PGSQL.5678" 2023-04-26 12:44:50.249 UTC [5388:1] LOG:  database system was shut down at 2023-04-26 12:43:02 UTC 2023-04-26 12:44:50.260 UTC [5132:3] LOG:  database system is ready to accept connections 2023-04-26 12:45:01.542 UTC [5132:4] LOG:  received fast shutdown request 2023-04-26 12:45:01.542 UTC [5132:5] LOG:  aborting any active transactions 2023-04-26 12:45:01.547 UTC [5132:6] LOG:  background worker "logical replication launcher" (PID 3876) exited with exit code 1 2023-04-26 12:45:01.550 UTC [6032:1] LOG:  shutting down 2023-04-26 12:45:01.551 UTC [6032:2] LOG:  checkpoint starting: shutdown immediate 2023-04-26 12:45:01.557 UTC [6032:3] LOG:  checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.003 s, sync=0.001 s, total=0.007 s; sync files=0, longest=0.000 s, average=0.000 s; distance=0 kB, estimate=0 kB; lsn=0/1034E7F8, redo lsn=0/1034E7F8 2023-04-26 12:45:01.568 UTC [5132:7] LOG:  database system is shut down cheers andrew -- Andrew Dunstan EDB:https://www.enterprisedb.com --------------E4czELWWxge629NRKzdDA9f2 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit


[redirecting to -hackers]


On 2023-04-20 Th 15:37, Andrew Dunstan wrote:


On 2023-04-20 Th 11:06, Andres Freund wrote:
On 2023-04-17 16:22:30 -0400, Andrew Dunstan wrote:
I am still having Windows issues with meson, but only with MSYS2.
Any more details on that? I might be able to help out / improve things.


For some reason which makes no sense to me the buildfarm animal fails at the first Stop-Db step. The DB is actually stopped, but pg_ctl returns a non-zero status. The thing that's really odd is that meson isn't at all involved in this step. But it's happened enough that I've had to back off using meson builds on fairywren - I'm going to do more testing on a new Windows instance.



Still running into this, and I am rather stumped. This is a blocker for buildfarm support for meson:

Here's a simple illustration of the problem. If I do the identical test with a non-meson build there is no problem:


pgrunner@EC2AMAZ-GCB871B UCRT64 ~/bf
$ export PGCTLTIMEOUT=300

pgrunner@EC2AMAZ-GCB871B UCRT64 ~/bf
$ /usr/bin/perl -e 'chdir "root/HEAD/instkeep.2023-04-25_11-09-41"; system("bin/pg_ctl -D data-C -l logfile start") ; print "fail\n" if $?; '
waiting for server to start.... done
server started


pgrunner@EC2AMAZ-GCB871B UCRT64 ~/bf
$ /usr/bin/perl -e 'chdir "root/HEAD/instkeep.2023-04-25_11-09-41"; system("bin/pg_ctl -D data-C -l logfile stop") ; print "fail\n" if $?; '
waiting for server to shut down....fail

pgrunner@EC2AMAZ-GCB871B UCRT64 ~/bf
$ tail root/HEAD/instkeep.2023-04-25_11-09-41/logfile
2023-04-26 12:44:50.188 UTC [5132:2] LOG:  listening on Unix socket "C:/tools/msys64/tmp/buildfarm-jaWBkm/.s.PGSQL.5678"
2023-04-26 12:44:50.249 UTC [5388:1] LOG:  database system was shut down at 2023-04-26 12:43:02 UTC
2023-04-26 12:44:50.260 UTC [5132:3] LOG:  database system is ready to accept connections
2023-04-26 12:45:01.542 UTC [5132:4] LOG:  received fast shutdown request
2023-04-26 12:45:01.542 UTC [5132:5] LOG:  aborting any active transactions
2023-04-26 12:45:01.547 UTC [5132:6] LOG:  background worker "logical replication launcher" (PID 3876) exited with exit code 1
2023-04-26 12:45:01.550 UTC [6032:1] LOG:  shutting down
2023-04-26 12:45:01.551 UTC [6032:2] LOG:  checkpoint starting: shutdown immediate
2023-04-26 12:45:01.557 UTC [6032:3] LOG:  checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.003 s, sync=0.001 s, total=0.007 s; sync files=0, longest=0.000 s, average=0.000 s; distance=0 kB, estimate=0 kB; lsn=0/1034E7F8, redo lsn=0/1034E7F8
2023-04-26 12:45:01.568 UTC [5132:7] LOG:  database system is shut down


cheers


andrew

--
Andrew Dunstan
EDB: https://www.enterprisedb.com
--------------E4czELWWxge629NRKzdDA9f2--