Bug 2238686

Summary:	postgresql-15.4-1.fc40 FTBFS: plperl tests fail
Product:	[Fedora] Fedora	Reporter:	Petr Pisar <ppisar>
Component:	postgresql	Assignee:	Orphan Owner <extras-orphan>
Status:	CLOSED EOL	QA Contact:	Fedora Extras Quality Assurance <extras-qa>
Severity:	unspecified	Docs Contact:
Priority:	unspecified
Version:	40	CC:	anon.amish, devrim, fjanus, hhorak, ksurma, mkulik, osloup, pkubat, praiskup
Target Milestone:	---
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
URL:	https://koschei.fedoraproject.org/package/postgresql?collection=f40
Whiteboard:
Fixed In Version:		Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2025-05-16 07:43:35 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:	2231791, 2244836

Description Petr Pisar 2023-09-13 07:43:23 UTC

postgresql-15.4-1.fc40 fails to build in Fedora 40 because tests fail:

echo "+++ regress check in src/pl/plperl +++" && PATH="/builddir/build/BUILD/postgresql-15.4/tmp_install/usr/bin:/builddir/build/BUILD/postgresql-15.4/src/pl/plperl:$PATH" LD_LIBRARY_PATH="/builddir/build/BUILD/postgresql-15.4/tmp_install/usr/lib64"  ../../../src/test/regress/pg_regress --temp-instance=./tmp_check --inputdir=. --bindir=     --dbname=pl_regression plperl_setup plperl plperl_lc plperl_trigger plperl_shared plperl_elog plperl_util plperl_init plperlu plperl_array plperl_call plperl_transaction plperl_plperlu
+++ regress check in src/pl/plperl +++
============== creating temporary instance            ==============
============== initializing database system           ==============
============== starting postmaster                    ==============
running on port 51700 with PID 19381
============== creating database "pl_regression"      ==============
CREATE DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
ALTER DATABASE
============== running regression test queries        ==============
test plperl_setup                 ... ok           47 ms
test plperl                       ... ok           46 ms
test plperl_lc                    ... ok           21 ms
test plperl_trigger               ... ok           39 ms
test plperl_shared                ... ok           22 ms
test plperl_elog                  ... FAILED       26 ms
test plperl_util                  ... ok           28 ms
test plperl_init                  ... ok           37 ms
test plperlu                      ... ok           17 ms
test plperl_array                 ... ok           29 ms
test plperl_call                  ... FAILED       26 ms
test plperl_transaction           ... ok           40 ms
test plperl_plperlu               ... ok           32 ms
============== shutting down postmaster               ==============
=======================
 2 of 13 tests failed. 
=======================
The differences that caused some tests to fail can be viewed in the
file "/builddir/build/BUILD/postgresql-15.4/src/pl/plperl/regression.diffs".  A copy of the test summary that you see
above is saved in the file "/builddir/build/BUILD/postgresql-15.4/src/pl/plperl/regression.out".

A difference between passing and failing build root is at <https://koschei.fedoraproject.org/build/16277449>.

Comment 1 Filip Januš 2023-09-25 09:52:51 UTC

I have added a temporary workaround. 
https://src.fedoraproject.org/rpms/postgresql/c/826b475b082c65098f8e9536ca547a7ddd338dd7?branch=rawhide

The issue must be investigated. It seems to be related to this RPM commit https://github.com/dmnks/rpm/commit/941ee8709cc2ff39490af8d0816d5f5e8847df00

Comment 2 Aoife Moloney 2024-02-15 22:57:40 UTC

This bug appears to have been reported against 'rawhide' during the Fedora Linux 40 development cycle.
Changing version to 40.

Comment 3 Fedora Admin user for bugzilla script actions 2024-11-27 01:54:59 UTC

This package has changed maintainer in Fedora. Reassigning to the new maintainer of this component.

Comment 4 Aoife Moloney 2025-04-25 10:07:20 UTC

This message is a reminder that Fedora Linux 40 is nearing its end of life.
Fedora will stop maintaining and issuing updates for Fedora Linux 40 on 2025-05-13.
It is Fedora's policy to close all bug reports from releases that are no longer
maintained. At that time this bug will be closed as EOL if it remains open with a
'version' of '40'.

Package Maintainer: If you wish for this bug to remain open because you
plan to fix it in a currently maintained version, change the 'version' 
to a later Fedora Linux version. Note that the version field may be hidden.
Click the "Show advanced fields" button if you do not see it.

Thank you for reporting this issue and we are sorry that we were not 
able to fix it before Fedora Linux 40 is end of life. If you would still like 
to see this bug fixed and are able to reproduce it against a later version 
of Fedora Linux, you are encouraged to change the 'version' to a later version
prior to this bug being closed.

Comment 5 Aoife Moloney 2025-05-16 07:43:35 UTC

Fedora Linux 40 entered end-of-life (EOL) status on 2025-05-13.

Fedora Linux 40 is no longer maintained, which means that it
will not receive any further security or bug fix updates. As a result we
are closing this bug.

If you can reproduce this bug against a currently maintained version of Fedora Linux
please feel free to reopen this bug against that version. Note that the version
field may be hidden. Click the "Show advanced fields" button if you do not see
the version field.

If you are unable to reopen this bug, please file a new report against an
active release.

Thank you for reporting this bug and we are sorry it could not be fixed.