------------------------------------------------------------------------------- Fix Number: FJSVfsep-POOL2-14-1401-1.el8.s390x Product Names and Versions: FUJITSU Enterprise Postgres Pgpool-II 14 *1 *1 It is bundled to the server package of the following product. FUJITSU Software Enterprise Postgres Advanced Edition 14 for Linux on Z Creation date: 26.05.2023 ------------------------------------------------------------------------------- [High Risk Activity] The Customer acknowledges and agrees that the Product is designed, developed and manufactured as contemplated for general use, including without limitation, general office use, personal use, household use, and ordinary industrial use, but is not designed, developed and manufactured as contemplated for use accompanying fatal risks or dangers that, unless extremely high safety is secured, could lead directly to death, personal injury, severe physical damage or other loss (hereinafter "High Safety Required Use"), including without limitation, nuclear reaction control in nuclear facility, aircraft flight control, air traffic control, mass transport control, medical life support system, missile launch control in weapon system. The Customer, shall not use the Product without securing the sufficient safety required for the High Safety Required Use. In addition, Fujitsu (or other affiliate's name) shall not be liable against the Customer and/or any third party for any claims or damages arising in connection with the High Safety Required Use of the Product. Product and company names mentioned in this manual are the trademarks or registered trademarks of their respective owners. Copyright 2023 FUJITSU LIMITED ------------------------------------------------------------------------------- [Notes] - This is the readme for RHEL 8. - This fix is applicable to environments where the following are installed. FUJITSU Enterprise Postgres Pgpool-II 14 - Please ensure that the following steps are carried out before applying or deleting this patch. - Do not set the library path of FUJITSU Enterprise Postgres (*1) to the environment variable(*2). (*1) /lib (*2) LD_LIBRARY_PATH and LD_LIBRARY_PATH_32. - Stop the running Pgpool-II. - If the application and restoration of this correction fail, collect the following materials and contact our technical staff. - /var/log/fsep_POOL2_1401_patch.log - /var/opt/FJSVfupde/log (All files in log directory) - Perform a recovery procedure of return to the pre-apply and pre-restore state if. 1) Failed to apply or restore this fix. and 2) The following log files exist. and /var/log/fsep_POOL2_1401_patch.log 3) The log file ends with one of the following. ROLLBACK(U): was failed(non-0 return value). ROLLBACK(I): was failed(non-0 return value). [Recovery procedure] 1) Run the following command to switch to the superuser on the system. $ su - Password:****** 2) Verify that the package is installed by running the following command. If it was not installed, run of "4)". # rpm -q FJSVfsep-POOL2-14 3) Run the following command to uninstall the package. # rpm -e FJSVfsep-POOL2-14 --nodeps To confirm the uninstallation, run the following command. # rpm -q FJSVfsep-POOL2-14 4) Run the following command to install the package. # cd /PKG # rpm -i FJSVfsep-POOL2-14-*.rpm(*1) \ --prefix= --nodeps 5) To confirm the installation, run the following command. # rpm -q FJSVfsep-POOL2-14 (*1)File names are different on apply failure and restore failure. ------------------------------------------------------------------------------- [Patch Description] The following fixes are included in this patch: Fix Number: FJSVfsep-POOL2-14-1401-2.el8.s390x 01 PH21679 [ ]Security failure [*]Serious failure ([ ]Degradation) [*]Incompatibility does not exist / [ ]Incompatibility exists - Frequency ([*]Always / [ ]Rarely / [ ]Irregularly) - Description There is no particular issue because bug corrections in Pgpool-II 4.2.7 and 4.2.8 apply to FUJITSU Enterprise Postgres. - Requirements to reproduce this issue There is no particular condition because this fix applies the changes of Pgpool-II 4.2.7 and 4.2.8 to FUJITSU Enterprise Postgres. You can see applied changes in the below URLs. https://www.pgpool.net/docs/42/en/html/release-4-2-7.html https://www.pgpool.net/docs/42/en/html/release-4-2-8.html - Action Apply the changes of Pgpool-II to FUJITSU Enterprise Postgres. - Compatibility Information None. 02 PH22766 [ ]Security failure [*]Serious failure ([ ]Degradation) [*]Incompatibility does not exist / [ ]Incompatibility exists - Frequency ([*]Always / [ ]Rarely / [ ]Irregularly) - Description If you install Pgpool-II on a dedicated server that is different from the database or application server, Pgpool-II might fail to start with the following message: error while loading shared libraries: libssl.so.1.1: cannot open shared object file: No such file or directory - Requirements to reproduce this issue 1) Install Pgpool-II, and 2) Add the lib directory path of the Pgpool-II installation to LD_LIBRARY_PATH, and 3) LD_LIBRARY_PATH does not contain a directory containing libssl.so.1.1, such as followings, and - lib directory of the FUJITSU Enterprise Postgres server program - lib directory of the FUJITSU Enterprise Postgres client program 4) Start the Pgpool-II - Action Add libraries that should be in the directory where Pgpool-II is installed. - Compatibility Information None. ------------------------------------------------------------------------------- [Accumulated Patches] The following fixes are included in this patch: Fix Number: FJSVfsep-POOL2-14-1401-1.el8.s390x 01 PH20784 [ ]Security failure [*]Serious failure ([ ]Degradation) [*]Incompatibility does not exist / [ ]Incompatibility exists - Frequency ([*]Always / [ ]Rarely / [ ]Irregularly) - Description There is no particular issue because bug corrections in Pgpool-II 4.2.1 apply to FUJITSU Enterprise Postgres. - Requirements to reproduce this issue There is no particular condition because this fix applies the changes of Pgpool-II 4.2.1 to FUJITSU Enterprise Postgres. You can see applied changes in the below URL. https://www.pgpool.net/docs/42/en/html/release-4-2-1.html - Action Apply the changes of Pgpool-II to FUJITSU Enterprise Postgres. - Compatibility Information None. ------------------------------------------------------------------------------- [List of fixed files] Files replaced by the patch: $INS_DIR $INS_DIR/bin $INS_DIR/bin/pcp_attach_node $INS_DIR/bin/pcp_detach_node $INS_DIR/bin/pcp_health_check_stats $INS_DIR/bin/pcp_node_count $INS_DIR/bin/pcp_node_info $INS_DIR/bin/pcp_pool_status $INS_DIR/bin/pcp_proc_count $INS_DIR/bin/pcp_proc_info $INS_DIR/bin/pcp_promote_node $INS_DIR/bin/pcp_recovery_node $INS_DIR/bin/pcp_reload_config $INS_DIR/bin/pcp_stop_pgpool $INS_DIR/bin/pcp_watchdog_info $INS_DIR/bin/pg_enc $INS_DIR/bin/pg_md5 $INS_DIR/bin/pgpool $INS_DIR/bin/pgpool_setup $INS_DIR/bin/pgproto $INS_DIR/bin/watchdog_setup $INS_DIR/bin/wd_cli $INS_DIR/etc $INS_DIR/etc/escalation.sh.sample $INS_DIR/etc/failover.sh.sample $INS_DIR/etc/follow_primary.sh.sample $INS_DIR/etc/pcp.conf.sample $INS_DIR/etc/pgpool.conf.sample $INS_DIR/etc/pgpool.conf.sample-logical $INS_DIR/etc/pgpool.conf.sample-raw $INS_DIR/etc/pgpool.conf.sample-replication $INS_DIR/etc/pgpool.conf.sample-slony $INS_DIR/etc/pgpool.conf.sample-snapshot $INS_DIR/etc/pgpool.conf.sample-stream $INS_DIR/etc/pgpool_remote_start.sample $INS_DIR/etc/pool_hba.conf.sample $INS_DIR/etc/product.inf $INS_DIR/etc/recovery_1st_stage.sample $INS_DIR/etc/recovery_2nd_stage.sample $INS_DIR/include $INS_DIR/include/libpcp_ext.h $INS_DIR/include/pcp.h $INS_DIR/include/pool_process_reporting.h $INS_DIR/include/pool_type.h $INS_DIR/lib $INS_DIR/lib/libcom_err.so.3 $INS_DIR/lib/libcrypto.so $INS_DIR/lib/libcrypto.so.1.1 $INS_DIR/lib/libgssapi_krb5.so.2 $INS_DIR/lib/libk5crypto.so.3 $INS_DIR/lib/libkrb5.so.3 $INS_DIR/lib/libkrb5support.so.0 $INS_DIR/lib/liblber-2.4.so.2 $INS_DIR/lib/libldap-2.4.so.2 $INS_DIR/lib/libldap_r-2.4.so.2 $INS_DIR/lib/libpcp.a $INS_DIR/lib/libpcp.la $INS_DIR/lib/libpcp.so $INS_DIR/lib/libpcp.so.2 $INS_DIR/lib/libpcp.so.2.0.0 $INS_DIR/lib/libpq.so.5 $INS_DIR/lib/libssl.so $INS_DIR/lib/libssl.so.1.1 $INS_DIR/share $INS_DIR/share/pgpool-II $INS_DIR/share/pgpool-II/insert_lock.sql $INS_DIR/share/pgpool-II/pgpool.pam -------------------------------------------------------------------------------