View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000741 | Pgpool-II | Bug | public | 2022-01-02 14:26 | 2022-06-28 11:16 |
| Reporter | sysadmin | Assigned To | pengbo | ||
| Priority | high | Severity | minor | Reproducibility | have not tried |
| Status | closed | Resolution | open | ||
| Platform | Linux kernel 3.10.0-1160.49.1.el | OS | CentOS 7 | OS Version | 7.9.2009 |
| Product Version | 4.3.0 | ||||
| Summary | 0000741: Conflict file when install Pgpool-II in CentOS 7 | ||||
| Description | Hi, We followed the documentation below and got an error about conflicting packages during the installation https://www.pgpool.net/docs/43/en/html/example-cluster.html#EXAMPLE-CLUSTER-REQUIREMENT Transaction check error: file /usr/bin/pcp_attach_node conflicts between attempted installs of pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 and pgpool-II-pcp-4.3.0-1.rhel7.x86_64 file /usr/bin/pcp_detach_node conflicts between attempted installs of pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 and pgpool-II-pcp-4.3.0-1.rhel7.x86_64 file /usr/bin/pcp_health_check_stats conflicts between attempted installs of pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 and pgpool-II-pcp-4.3.0-1.rhel7.x86_64 file /usr/bin/pcp_node_count conflicts between attempted installs of pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 and pgpool-II-pcp-4.3.0-1.rhel7.x86_64 file /usr/bin/pcp_node_info conflicts between attempted installs of pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 and pgpool-II-pcp-4.3.0-1.rhel7.x86_64 file /usr/bin/pcp_pool_status conflicts between attempted installs of pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 and pgpool-II-pcp-4.3.0-1.rhel7.x86_64 file /usr/bin/pcp_proc_count conflicts between attempted installs of pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 and pgpool-II-pcp-4.3.0-1.rhel7.x86_64 file /usr/bin/pcp_proc_info conflicts between attempted installs of pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 and pgpool-II-pcp-4.3.0-1.rhel7.x86_64 file /usr/bin/pcp_promote_node conflicts between attempted installs of pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 and pgpool-II-pcp-4.3.0-1.rhel7.x86_64 file /usr/bin/pcp_recovery_node conflicts between attempted installs of pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 and pgpool-II-pcp-4.3.0-1.rhel7.x86_64 file /usr/bin/pcp_reload_config conflicts between attempted installs of pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 and pgpool-II-pcp-4.3.0-1.rhel7.x86_64 file /usr/bin/pcp_stop_pgpool conflicts between attempted installs of pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 and pgpool-II-pcp-4.3.0-1.rhel7.x86_64 file /usr/bin/pcp_watchdog_info conflicts between attempted installs of pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 and pgpool-II-pcp-4.3.0-1.rhel7.x86_64 file /usr/bin/wd_cli conflicts between attempted installs of pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 and pgpool-II-pcp-4.3.0-1.rhel7.x86_64 file /usr/lib64/libpcp.so.2.0.0 conflicts between attempted installs of pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 and pgpool-II-pcp-4.3.0-1.rhel7.x86_64 file /etc/pgpool-II/escalation.sh.sample conflicts between attempted installs of pgpool-II-4.3.0-1.rhel7.x86_64 and pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 file /etc/pgpool-II/failover.sh.sample conflicts between attempted installs of pgpool-II-4.3.0-1.rhel7.x86_64 and pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 file /etc/pgpool-II/follow_primary.sh.sample conflicts between attempted installs of pgpool-II-4.3.0-1.rhel7.x86_64 and pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 file /etc/pgpool-II/pcp.conf.sample conflicts between attempted installs of pgpool-II-4.3.0-1.rhel7.x86_64 and pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 file /etc/pgpool-II/pgpool.conf.sample conflicts between attempted installs of pgpool-II-4.3.0-1.rhel7.x86_64 and pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 file /etc/pgpool-II/pgpool_remote_start.sample conflicts between attempted installs of pgpool-II-4.3.0-1.rhel7.x86_64 and pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 file /etc/pgpool-II/pool_hba.conf.sample conflicts between attempted installs of pgpool-II-4.3.0-1.rhel7.x86_64 and pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 file /etc/pgpool-II/recovery_1st_stage.sample conflicts between attempted installs of pgpool-II-4.3.0-1.rhel7.x86_64 and pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 file /etc/pgpool-II/replication_mode_recovery_1st_stage.sample conflicts between attempted installs of pgpool-II-4.3.0-1.rhel7.x86_64 and pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 file /etc/pgpool-II/replication_mode_recovery_2nd_stage.sample conflicts between attempted installs of pgpool-II-4.3.0-1.rhel7.x86_64 and pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 file /usr/bin/pg_enc conflicts between attempted installs of pgpool-II-4.3.0-1.rhel7.x86_64 and pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 file /usr/bin/pg_md5 conflicts between attempted installs of pgpool-II-4.3.0-1.rhel7.x86_64 and pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 file /usr/bin/pgpool conflicts between attempted installs of pgpool-II-4.3.0-1.rhel7.x86_64 and pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 file /usr/bin/pgproto conflicts between attempted installs of pgpool-II-4.3.0-1.rhel7.x86_64 and pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 | ||||
| Steps To Reproduce | yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm yum install -y postgresql14-server /usr/pgsql-14/bin/postgresql-14-setup initdb yum install -y https://www.pgpool.net/yum/rpms/4.3/redhat/rhel-7-x86_64/pgpool-II-release-4.3-1.noarch.rpm yum install -y pgpool-II-pg14-* | ||||
| Tags | error | ||||
|
|
This can be fixed if you install pgpool first then install postgresql. Did anyone get this problem and any solution for this. What if I have postgresql first and need install pgpool later. Thanks |
|
|
Get same error when run yum update Transaction check error: file /etc/pgpool-II/escalation.sh.sample from install of pgpool-II-4.3.0-1.rhel7.x86_64 conflicts with file from package pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 file /etc/pgpool-II/failover.sh.sample from install of pgpool-II-4.3.0-1.rhel7.x86_64 conflicts with file from package pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 file /etc/pgpool-II/follow_primary.sh.sample from install of pgpool-II-4.3.0-1.rhel7.x86_64 conflicts with file from package pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 file /etc/pgpool-II/pcp.conf.sample from install of pgpool-II-4.3.0-1.rhel7.x86_64 conflicts with file from package pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 file /etc/pgpool-II/pgpool.conf.sample from install of pgpool-II-4.3.0-1.rhel7.x86_64 conflicts with file from package pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 file /etc/pgpool-II/pgpool_remote_start.sample from install of pgpool-II-4.3.0-1.rhel7.x86_64 conflicts with file from package pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 file /etc/pgpool-II/pool_hba.conf.sample from install of pgpool-II-4.3.0-1.rhel7.x86_64 conflicts with file from package pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 file /etc/pgpool-II/recovery_1st_stage.sample from install of pgpool-II-4.3.0-1.rhel7.x86_64 conflicts with file from package pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 file /etc/pgpool-II/replication_mode_recovery_1st_stage.sample from install of pgpool-II-4.3.0-1.rhel7.x86_64 conflicts with file from package pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 file /etc/pgpool-II/replication_mode_recovery_2nd_stage.sample from install of pgpool-II-4.3.0-1.rhel7.x86_64 conflicts with file from package pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 file /usr/bin/pg_enc from install of pgpool-II-4.3.0-1.rhel7.x86_64 conflicts with file from package pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 file /usr/bin/pg_md5 from install of pgpool-II-4.3.0-1.rhel7.x86_64 conflicts with file from package pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 file /usr/bin/pgpool from install of pgpool-II-4.3.0-1.rhel7.x86_64 conflicts with file from package pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 file /usr/bin/pgproto from install of pgpool-II-4.3.0-1.rhel7.x86_64 conflicts with file from package pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 file /usr/bin/pcp_attach_node from install of pgpool-II-pcp-4.3.0-1.rhel7.x86_64 conflicts with file from package pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 file /usr/bin/pcp_detach_node from install of pgpool-II-pcp-4.3.0-1.rhel7.x86_64 conflicts with file from package pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 file /usr/bin/pcp_health_check_stats from install of pgpool-II-pcp-4.3.0-1.rhel7.x86_64 conflicts with file from package pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 file /usr/bin/pcp_node_count from install of pgpool-II-pcp-4.3.0-1.rhel7.x86_64 conflicts with file from package pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 file /usr/bin/pcp_node_info from install of pgpool-II-pcp-4.3.0-1.rhel7.x86_64 conflicts with file from package pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 file /usr/bin/pcp_pool_status from install of pgpool-II-pcp-4.3.0-1.rhel7.x86_64 conflicts with file from package pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 file /usr/bin/pcp_proc_count from install of pgpool-II-pcp-4.3.0-1.rhel7.x86_64 conflicts with file from package pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 file /usr/bin/pcp_proc_info from install of pgpool-II-pcp-4.3.0-1.rhel7.x86_64 conflicts with file from package pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 file /usr/bin/pcp_promote_node from install of pgpool-II-pcp-4.3.0-1.rhel7.x86_64 conflicts with file from package pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 file /usr/bin/pcp_recovery_node from install of pgpool-II-pcp-4.3.0-1.rhel7.x86_64 conflicts with file from package pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 file /usr/bin/pcp_reload_config from install of pgpool-II-pcp-4.3.0-1.rhel7.x86_64 conflicts with file from package pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 file /usr/bin/pcp_stop_pgpool from install of pgpool-II-pcp-4.3.0-1.rhel7.x86_64 conflicts with file from package pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 file /usr/bin/pcp_watchdog_info from install of pgpool-II-pcp-4.3.0-1.rhel7.x86_64 conflicts with file from package pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 file /usr/bin/wd_cli from install of pgpool-II-pcp-4.3.0-1.rhel7.x86_64 conflicts with file from package pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 file /usr/lib64/libpcp.so.2.0.0 from install of pgpool-II-pcp-4.3.0-1.rhel7.x86_64 conflicts with file from package pgpool-II-pg14-4.3.0-1pgdg.rhel7.x86_64 Error Summary ------------- |
|
|
It seems some packages installed from PostgreSQL repository. =============================================================================================================================================================================================== Package Arch Version Repository Size =============================================================================================================================================================================================== Installing: pgpool-II-pg14 x86_64 4.3.0-1pgdg.rhel7 pgpool43 1.8 M pgpool-II-pg14-debuginfo x86_64 4.3.0-1pgdg.rhel7 pgpool43 2.5 M pgpool-II-pg14-devel x86_64 4.3.0-1pgdg.rhel7 pgpool43 18 k pgpool-II-pg14-extensions x86_64 4.3.0-1.rhel7 pgdg14 62 k Installing for dependencies: libmemcached x86_64 1.0.16-5.el7 base 237 k pgpool-II x86_64 4.3.0-1.rhel7 pgdg-common 691 k pgpool-II-pcp x86_64 4.3.0-1.rhel7 pgdg-common 85 k Transaction Summary =============================================================================================================================================================================================== Install 4 Packages (+3 Dependent packages) You need to disable pgdg repository. # yum install --disablerepo=pgdg* pgpool-II-pg14-* Alternatively, exclude pgpool* from pgdg repository. # vi /etc/yum.repos.d/pgdg-redhat-all.repo ... [pgdg-common] ... exclude=pgpool* [pgdg14] ... exclude=pgpool* |
|
|
Do we know when this issue will be fix from the normal distribution |
|
|
> Do we know when this issue will be fix from the normal distribution It is not a Pgpool-II bug. We don't have plan to change the package names. I have added a note to the documentation. https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=ce420f1f8a7f8936663be6a6bfca4e7cda036b08 You need to disable pgdg repo using "yum install --disablerepo=pgdg* pgpool-II-pg14-*". Alternatively, you need to modify the "/etc/yum.repos.d/pgdg-redhat-all.repo". |
|
|
Close issue. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2022-01-02 14:26 | sysadmin | New Issue | |
| 2022-01-02 14:26 | sysadmin | Tag Attached: error | |
| 2022-01-03 15:39 | sysadmin | Note Added: 0003977 | |
| 2022-01-03 17:36 | sysadmin | Note Added: 0003978 | |
| 2022-01-04 09:19 | pengbo | Assigned To | => pengbo |
| 2022-01-04 09:19 | pengbo | Status | new => assigned |
| 2022-01-04 12:03 | pengbo | Note Added: 0003979 | |
| 2022-01-04 16:47 | pengbo | Status | assigned => feedback |
| 2022-01-09 01:26 | henri_pilon@belll.net | Note Added: 0003981 | |
| 2022-01-13 18:15 | pengbo | Note Added: 0003983 | |
| 2022-06-28 11:16 | pengbo | Note Added: 0004070 | |
| 2022-06-28 11:16 | pengbo | Status | feedback => closed |
