Re: Intermittent failure with t/003_logical_slots.pl test on windows - Mailing list pgsql-hackers

From Amit Kapila
Subject Re: Intermittent failure with t/003_logical_slots.pl test on windows
Date
Msg-id CAA4eK1Kb8e4bB8SJR8HRwJbnsVPdoEzH2mExB4my8-o7wmXKkg@mail.gmail.com
Whole thread Raw
In response to Intermittent failure with t/003_logical_slots.pl test on windows  (Nisha Moond <nisha.moond412@gmail.com>)
Responses Re: Intermittent failure with t/003_logical_slots.pl test on windows
List pgsql-hackers
On Tue, Oct 31, 2023 at 4:53 PM Nisha Moond <nisha.moond412@gmail.com> wrote:
>
> There is a failure with 't/003_logical_slots.pl' test during the
> upgrade. The failure is intermittent and observed in the Windows
> environment.
>

How did you reach the conclusion that it is only for
't/003_logical_slots.pl'? I see that the failure is while pg_upgrade
internally running pg_resetwal -V command to check the version which
doesn't seem to be directly related to the newly added test or code.

> Details-
> Test - pg_upgrade/t/003_logical_slots.pl
> Result -
> t/003_logical_slots.pl .. 5/?
> #   Failed test 'run of pg_upgrade of old cluster'
> #   at t/003_logical_slots.pl line 165.
> t/003_logical_slots.pl .. 10/?
> #   Failed test 'check the slot exists on new cluster'
> #   at t/003_logical_slots.pl line 171.
> #          got: ''
> #     expected: 'regress_sub|t'
> # Tests were run but no plan was declared and done_testing() was not seen.
> # Looks like your test exited with 25 just after 11.
> t/003_logical_slots.pl .. Dubious, test returned 25 (wstat 6400, 0x1900)
> Failed 2/11 subtests
>
> Test Summary Report
> -------------------
> t/003_logical_slots.pl (Wstat: 6400 (exited 25) Tests: 11 Failed: 2)
>   Failed tests:  10-11
>   Non-zero exit status: 25
>   Parse errors: No plan found in TAP output
> Files=1, Tests=11, 32 wallclock secs ( 0.03 usr +  0.01 sys =  0.05 CPU)
> Result: FAIL
>
> log attached - 'regress_log_003_logical_slots'.
>
> The failure cause is  -
> no data was returned by command
> ""D:/Project/pg1/postgres/tmp_install/bin/pg_resetwal" -V"
> check for "D:/Project/pg1/postgres/tmp_install/bin/pg_resetwal"
> failed: cannot execute
>
> Failure, exiting
> [16:24:21.144](6.275s) not ok 10 - run of pg_upgrade of old cluster
>
> If the same command is run manually, it succeeds -
>

Can you add some LOGs in pg_resetwal to find out if the command has
performed appropriately?

--
With Regards,
Amit Kapila.



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: pg_resetwal tests, logging, and docs update
Next
From: Robert Haas
Date:
Subject: Re: Requiring recovery.signal or standby.signal when recovering with a backup_label