Bug 2332981

Summary: postgresql16-16.3-7.fc42 FTBFS: tests fail with tzdata-2024b
Product: [Fedora] Fedora Reporter: Petr Pisar <ppisar>
Component: postgresql16Assignee: Filip Januš <fjanus>
Status: CLOSED NOTABUG QA Contact:
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 42CC: anezbeda, fjanus, hhorak
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
URL: https://koschei.fedoraproject.org/package/postgresql16
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2025-04-22 06:01:40 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 2300528    

Description Petr Pisar 2024-12-18 09:15:28 UTC
postgresql16-16.3-7.fc42 fails to build in Fedora 42:

echo "# +++ regress check in src/test/regress +++" && PATH="/builddir/build/BUILD/postgresql16-16.3-bui
ld/postgresql-16.3/tmp_install/usr/bin:/builddir/build/BUILD/postgresql16-16.3-build/postgresql-16.3/sr
c/test/regress:$PATH" LD_LIBRARY_PATH="/builddir/build/BUILD/postgresql16-16.3-build/postgresql-16.3/tm
p_install/usr/lib64"  ../../../src/test/regress/pg_regress --temp-instance=./tmp_check --inputdir=. --b
indir=     --dlpath=. --max-concurrent-tests=20  --schedule=./parallel_schedule --max-connections=5 
# +++ regress check in src/test/regress +++
[...]
# 3 of 215 tests failed.
# The differences that caused some tests to fail can be viewed in the file "/builddir/build/BUILD/postgresql16-16.3-build/postgresql-16.3/src/test/regress/regression.diffs".
# A copy of the test summary that you see above is saved in the file "/builddir/build/BUILD/postgresql16-16.3-build/postgresql-16.3/src/test/regress/regression.out".
make: Leaving directory '/builddir/build/BUILD/postgresql16-16.3-build/postgresql-16.3/src/test/regress'
make: *** [GNUmakefile:118: check] Error 1
+ test_failure=1
+ set +x
=== trying to find all regression.diffs files in build directory ===
=== make failure: src/test/regress/regression.diffs ===
diff -U3 /builddir/build/BUILD/postgresql16-16.3-build/postgresql-16.3/src/test/regress/expected/date.out /builddir/build/BUILD/postgresql16-16.3-build/postgresql-16.3/src/test/regress/results/date.out
--- /builddir/build/BUILD/postgresql16-16.3-build/postgresql-16.3/src/test/regress/expected/date.out           2024-05-06 22:21:25.000000000 +0200
+++ /builddir/build/BUILD/postgresql16-16.3-build/postgresql-16.3/src/test/regress/results/date.out            2024-12-18 00:36:43.580313398 +0100
@@ -1295,7 +1295,7 @@
 SELECT DATE_TRUNC('MILLENNIUM', DATE '1970-03-20'); -- 1001-01-01
           date_trunc          
 ------------------------------
- Thu Jan 01 00:00:00 1001 PST
+ Thu Jan 01 00:00:00 1001 LMT
 (1 row)
 
 SELECT DATE_TRUNC('CENTURY', TIMESTAMP '1970-03-20 04:30:00.00000'); -- 1901
[...]

A difference between passing and failing build root is at <https://koschei.fedoraproject.org/build/19288129>. An upgrade of tzdata from 2024a-9.fc41 to 2024b-1.fc42 is suspicious. If I remember correctly, the new tzdata changed canonical names of some time zones and turned the old ones into an alias.

Comment 1 Aoife Moloney 2025-02-26 13:20:11 UTC
This bug appears to have been reported against 'rawhide' during the Fedora Linux 42 development cycle.
Changing version to 42.

Comment 2 Fedora Release Engineering 2025-03-30 04:22:18 UTC
Dear Maintainer,

your package has an open Fails To Build From Source bug for Fedora 42.
Action is required from you.

If you can fix your package to build, perform a build in koji, and either create
an update in bodhi, or close this bug without creating an update, if updating is
not appropriate [1]. If you are working on a fix, set the status to ASSIGNED to
acknowledge this. If you have already fixed this issue, please close this Bugzilla report.

Following the policy for such packages [2], your package will be orphaned if
this bug remains in NEW state more than 8 weeks (not sooner than 2025-02-12).

A week before the mass branching of Fedora 43 according to the schedule [3],
any packages not successfully rebuilt at least on Fedora 41 will be
retired regardless of the status of this bug.

[1] https://docs.fedoraproject.org/en-US/fesco/Updates_Policy/
[2] https://docs.fedoraproject.org/en-US/fesco/Fails_to_build_from_source_Fails_to_install/
[3] https://fedorapeople.org/groups/schedule/f-43/f-43-key-tasks.html

Comment 3 Fedora Release Engineering 2025-04-20 04:22:18 UTC
Dear Maintainer,

your package has an open Fails To Build From Source bug for Fedora 42.
Action is required from you.

If you can fix your package to build, perform a build in koji, and either create
an update in bodhi, or close this bug without creating an update, if updating is
not appropriate [1]. If you are working on a fix, set the status to ASSIGNED to
acknowledge this. If you have already fixed this issue, please close this Bugzilla report.

Following the policy for such packages [2], your package will be orphaned if
this bug remains in NEW state more than 8 weeks (not sooner than 2025-02-12).

A week before the mass branching of Fedora 43 according to the schedule [3],
any packages not successfully rebuilt at least on Fedora 41 will be
retired regardless of the status of this bug.

[1] https://docs.fedoraproject.org/en-US/fesco/Updates_Policy/
[2] https://docs.fedoraproject.org/en-US/fesco/Fails_to_build_from_source_Fails_to_install/
[3] https://fedorapeople.org/groups/schedule/f-43/f-43-key-tasks.html

Comment 4 Filip Januš 2025-04-22 06:01:40 UTC
fixed