View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000567 | Pgpool-II | General | public | 2019-12-11 07:41 | 2020-02-03 10:53 |
| Reporter | sureshreddy21 | Assigned To | pengbo | ||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | feedback | Resolution | open | ||
| Platform | Linu | OS | Oracle Linux 8.1 | OS Version | OEL 8.1 |
| Product Version | 4.1.0 | ||||
| Summary | 0000567: Getting belwo error while bring ing up pgpool and my VIP is not coming up | ||||
| Description | Dec 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 | ||||
| Tags | No tags attached. | ||||
|
|
|
|
|
Did you start pgpool using "postgres" user or "root" user? Could you show the result of "ps -ef | grep pgpool"? |
|
|
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 |
|
|
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 |
|
|
If you have resolved this issue, may I close this one? |
| 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 | |
| 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 |
