sclorg / postgresql-container

PostgreSQL container images based on Red Hat Software Collections and intended for OpenShift and general usage. Users can choose between Red Hat Enterprise Linux, Fedora, and CentOS based images.
http://softwarecollections.org
Apache License 2.0
164 stars 216 forks source link

Support for building and testing PSQL-16 on C10S replace nss-wrapper with nss-wrapper-libs #587

Closed phracek closed 2 months ago

phracek commented 2 months ago

This pull request allows to build and test PSQL-16 on C10S

The pull request is separated into more commits:

phracek commented 2 months ago

[test]

phracek commented 2 months ago

[test]

phracek commented 2 months ago

RUN {{ spec.environment_setup }}

@hhorak It cannot be used because the module is unavailable for C10S. See https://github.com/sclorg/postgresql-container/blob/master/specs/multispec.yml#L41

I will fix it good catch.

phracek commented 2 months ago

[test]

phracek commented 2 months ago

[test-all]

phracek commented 2 months ago

Fedora 15 has failed for this reason:

-----------------------------------------------
Running test run_s2i_enable_ssl_test (starting at 2024-09-06 13:36:21+00:00) ... 
-----------------------------------------------
3b84e71e4d32e2887d7750409d1485a852cc94cd06dee58693a5c6d632da0f6c
Created container 3b84e71e4d32e2887d7750409d1485a852cc94cd06dee58693a5c6d632da0f6c
double free or corruption (out)
/usr/libexec/check-container: line 27:    63 Aborted                 (core dumped) pg_isready -q -h 127.0.0.1 ${POSTGRESQL_USER+-U "$POSTGRESQL_USER"} ${POSTGRESQL_DATABASE+-d "$POSTGRESQL_DATABASE"} --timeout 0
double free or corruption (out)

==============================================
Tests were run for image quay.io/fedora/postgresql-15:0
==============================================
Test cases results:

 [FAILED] for 'postgresql-container_tests' run_s2i_enable_ssl_test (00:00:40)

CEntOS Stream 10 - 16 has failed for this reason:

-----------------------------------------------
Running test run_s2i_bake_data_test (starting at 2024-09-06 13:38:17+00:00) ... 
-----------------------------------------------
  ERROR: Failed to to build /tmp/tmp.ABtq1DrUYk/Dockerfile.7a8X
Trying to pull quay.io/sclorg/postgresql-16-c10s:1-bake_8gumrrdgqn...
Error: initializing source docker://quay.io/sclorg/postgresql-16-c10s:1-bake_8gumrrdgqn: reading manifest 1-bake_8gumrrdgqn in quay.io/sclorg/postgresql-16-c10s: unauthorized: access to the requested resource is not authorized
ERROR: Creation of container didn't succeed
cat: /tmp/tmp.QBX49KryMq/bake-data-test: No such file or directory
Error: name or ID cannot be empty
cat: /tmp/tmp.QBX49KryMq/bake-data-test: No such file or directory

The complete results for CentOS Stream 10 are:

==============================================
Tests were run for image quay.io/sclorg/postgresql-16-c10s:1
==============================================
Test cases results:

 [PASSED] for 'postgresql-container_tests' run_container_creation_tests (00:00:26)
 [PASSED] for 'postgresql-container_tests' run_general_tests (00:00:44)
 [PASSED] for 'postgresql-container_tests' run_change_password_test (00:00:09)
 [PASSED] for 'postgresql-container_tests' run_replication_test (00:00:05)
 [PASSED] for 'postgresql-container_tests' run_doc_test (00:00:01)
 [PASSED] for 'postgresql-container_tests' run_s2i_test (00:00:17)
 [PASSED] for 'postgresql-container_tests' run_test_cfg_hook (00:00:11)
 [FAILED] for 'postgresql-container_tests' run_s2i_bake_data_test (00:00:28)
 [PASSED] for 'postgresql-container_tests' run_s2i_enable_ssl_test (00:00:09)
 [PASSED] for 'postgresql-container_tests' run_upgrade_test (00:00:01)
 [PASSED] for 'postgresql-container_tests' run_migration_test (00:00:02)
 [PASSED] for 'postgresql-container_tests' run_pgaudit_test (00:00:03)
 [PASSED] for 'postgresql-container_tests' run_new_pgaudit_test (00:00:03)
 [PASSED] for 'postgresql-container_tests' run_logging_test (00:00:02)
phracek commented 2 months ago

The failure on C10S is:

+ psql -f /tmp/src/init/init.sql
CREATE TABLE
INSERT 0 1
waiting for server to shut down....+ pg_ctl stop
 done
server stopped
+ tar caf data.tar.xz -C /var/lib/pgsql/data/userdata .
/bin/sh: line 1: xz: command not found
tar: data.tar.xz: Wrote only 4096 of 10240 bytes
phracek commented 2 months ago

[test]

phracek commented 2 months ago

CentOS Stream 10 passed. We are GREEN.

phracek commented 2 months ago

[test]

phracek commented 2 months ago

@hhorak @SlouchyButton Ready to re-review and merge. C10S passed.

phracek commented 2 months ago

[test]

phracek commented 2 months ago

[test]

phracek commented 2 months ago

Fix package dependencies [test]

phracek commented 2 months ago

[test]