View Issue Details

IDProjectCategoryView StatusLast Update
0000567Pgpool-II[All Projects] Generalpublic2020-02-03 10:53
Reportersureshreddy21Assigned Topengbo 
PrioritynormalSeverityminorReproducibilityalways
Status feedbackResolutionopen 
PlatformLinuOSOracle Linux 8.1OS VersionOEL 8.1
Product Version4.1.0 
Target VersionFixed in Version 
Summary0000567: Getting belwo error while bring ing up pgpool and my VIP is not coming up
DescriptionDec 10 17:38:09 rac01-prod pgpool[4657]: 2019-12-10 17:38:09: pid 4779: LOG: failed to create watchdog heartbeat receive socket.
Dec 10 17:38:09 rac01-prod pgpool[4657]: 2019-12-10 17:38:09: pid 4779: DETAIL: setsockopt(SO_BINDTODEVICE) requies root privilege
Dec 10 17:38:09 rac01-prod pgpool[4657]: 2019-12-10 17:38:09: pid 4779: LOG: set SO_REUSEPORT option to the socket
Dec 10 17:38:09 rac01-prod pgpool[4657]: 2019-12-10 17:38:09: pid 4779: LOG: creating watchdog heartbeat receive socket.
Dec 10 17:38:09 rac01-prod pgpool[4657]: 2019-12-10 17:38:09: pid 4779: DETAIL: set SO_REUSEPORT
TagsNo tags attached.

Activities

sureshreddy21

2019-12-11 07:41

reporter  

pgpool.conf (4,640 bytes)

pengbo

2019-12-12 18:02

developer   ~0003020

Did you start pgpool using "postgres" user or "root" user?
Could you show the result of "ps -ef | grep pgpool"?

sureshreddy21

2019-12-18 09:28

reporter   ~0003024

I have started pgpool using systemd service, ofcourse this service is using postgres account to bring up pgpool services.

postgres 11786 1 0 19:26 ? 00:00:00 /usr/bin/pgpool -f /etc/pgpool-II/pgpool.conf -D -n
postgres 11794 11786 0 19:26 ? 00:00:00 pgpool: watchdog
postgres 11797 11786 0 19:26 ? 00:00:00 pgpool: lifecheck
postgres 11798 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11799 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11800 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11801 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11802 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11803 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11804 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11805 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11806 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11807 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11808 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11809 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11810 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11811 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11812 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11813 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11814 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11815 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11816 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11817 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11818 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11819 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11820 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11821 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11822 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11823 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11824 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11825 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11826 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11827 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11828 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11829 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11830 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11831 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11832 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11833 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11834 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11835 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11836 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11837 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11838 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11839 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11840 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11841 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11842 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11843 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11844 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11845 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11846 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11847 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11848 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11849 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11850 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11851 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11852 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11853 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11854 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11855 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11856 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11857 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11858 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11859 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11860 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11861 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11862 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11863 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11864 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11865 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11866 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11867 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11868 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11869 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11870 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11871 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11872 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11873 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11874 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11875 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11876 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11877 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11878 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11879 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11880 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11881 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11882 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11883 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11884 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11885 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11886 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11887 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11888 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11889 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11890 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11891 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11892 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11893 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11894 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11895 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11896 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11897 11786 0 19:26 ? 00:00:00 pgpool: wait for connection request
postgres 11899 11797 0 19:26 ? 00:00:00 pgpool: heartbeat receiver
postgres 11900 11797 0 19:26 ? 00:00:00 pgpool: heartbeat sender
postgres 11901 11797 0 19:26 ? 00:00:00 pgpool: heartbeat receiver
postgres 11902 11797 0 19:26 ? 00:00:00 pgpool: heartbeat sender
postgres 11910 11786 0 19:26 ? 00:00:00 pgpool: worker process
postgres 11911 11786 0 19:26 ? 00:00:00 pgpool: health check process(0)
postgres 11912 11786 0 19:26 ? 00:00:00 pgpool: health check process(1)
postgres 12017 11786 0 19:26 ? 00:00:00 pgpool: PCP: wait for connection request

pengbo

2019-12-24 14:30

developer   ~0003030

Are you using RPM packages that are built by the pgpool community?
https://pgpool.net/mediawiki/index.php/Downloads

Could you show the package info?
# rpm -qi pgpool-II-pgxxxxxxxx

pengbo

2020-02-03 10:53

developer   ~0003117

If you have resolved this issue, may I close this one?

Issue History

Date Modified Username Field Change
2019-12-11 07:41 sureshreddy21 New Issue
2019-12-11 07:41 sureshreddy21 File Added: pgpool.conf
2019-12-12 17:48 pengbo Assigned To => pengbo
2019-12-12 17:48 pengbo Status new => assigned
2019-12-12 17:48 pengbo Description Updated View Revisions
2019-12-12 18:02 pengbo Note Added: 0003020
2019-12-18 09:28 sureshreddy21 Note Added: 0003024
2019-12-24 14:30 pengbo Note Added: 0003030
2020-01-06 09:00 pengbo Status assigned => feedback
2020-02-03 10:53 pengbo Note Added: 0003117