[pgpool-general: 330] Re: pgpool-II-3.1.2 hangs with log_destination = 'syslog' in daemon mode
Tatsuo Ishii
ishii at postgresql.org
Sat Mar 31 05:46:48 JST 2012
We have found a problem with syslog support. Please don't use syslog
support until a fix comes out.
http://www.pgpool.net/pipermail/pgpool-hackers/2012-March/000048.html
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
> Hello Everyone,
>
> When I try to start pgpool-II-3.1.2 in daemon mode with
> log_destination = 'syslog', pgpool doesn't respond.
>
> You can do a tcp handshake on port 9999 but that's it.
>
>
> Below is netstat output
>
>
> stderr / foreground ===================================
>
> tcp 0 0 0.0.0.0:9898 0.0.0.0:*
> LISTEN 22059/pgpool
> tcp 0 0 10.0.1.60:9999 0.0.0.0:*
> LISTEN 22059/pgpool
> unix 2 [ ACC ] STREAM LISTENING 7572338 22059/pgpool
> /tmp/.s.PGSQL.9999
> unix 2 [ ACC ] STREAM LISTENING 7572367 22059/pgpool
> /tmp/.s.PGSQL.9898
>
>
> stderr / background ===================================
>
> tcp 0 0 0.0.0.0:9898 0.0.0.0:*
> LISTEN 22341/pgpool
> tcp 0 0 10.0.1.60:9999 0.0.0.0:*
> LISTEN 22341/pgpool
> unix 2 [ ACC ] STREAM LISTENING 7573944 22341/pgpool
> /tmp/.s.PGSQL.9999
> unix 2 [ ACC ] STREAM LISTENING 7573952 22341/pgpool
> /tmp/.s.PGSQL.9898
>
>
>
> syslog / foreground ===================================
>
> tcp 0 0 0.0.0.0:9898 0.0.0.0:*
> LISTEN 22663/pgpool
> tcp 0 0 10.0.1.60:9999 0.0.0.0:*
> LISTEN 22663/pgpool
> unix 2 [ ACC ] STREAM LISTENING 7575637 22663/pgpool
> /tmp/.s.PGSQL.9999
> unix 2 [ ACC ] STREAM LISTENING 7575644 22663/pgpool
> /tmp/.s.PGSQL.9898
> unix 2 [ ] DGRAM 7575635 22663/pgpool
>
>
> syslog / background ===================================
> tcp 0 0 0.0.0.0:9898 0.0.0.0:*
> LISTEN 22835/pgpool
> tcp 0 0 10.0.1.60:9999 0.0.0.0:*
> LISTEN 22835/pgpool
> unix 2 [ ACC ] STREAM LISTENING 7576950 22835/pgpool
> /tmp/.s.PGSQL.9999
> unix 2 [ ACC ] STREAM LISTENING 7577052 22835/pgpool
> /tmp/.s.PGSQL.9898
> unix 2 [ ] DGRAM 7577054 22926/pgpool: wait
> unix 2 [ ] DGRAM 7577051 22835/pgpool
> unix 2 [ ] DGRAM 7577049 22927/pgpool: wait
> unix 2 [ ] DGRAM 7577048 22930/pgpool: wait
> unix 2 [ ] DGRAM 7577047 22928/pgpool: wait
> unix 2 [ ] DGRAM 7577046 22929/pgpool: wait
> unix 2 [ ] DGRAM 7577045 22925/pgpool: wait
> unix 2 [ ] DGRAM 7577044 22921/pgpool: wait
> unix 2 [ ] DGRAM 7577043 22924/pgpool: wait
> unix 2 [ ] DGRAM 7577042 22922/pgpool: wait
> unix 2 [ ] DGRAM 7577041 22923/pgpool: wait
> unix 2 [ ] DGRAM 7577040 22917/pgpool: wait
> unix 2 [ ] DGRAM 7577039 22918/pgpool: wait
> unix 2 [ ] DGRAM 7577038 22919/pgpool: wait
> unix 2 [ ] DGRAM 7577037 22920/pgpool: wait
> unix 2 [ ] DGRAM 7577036 22916/pgpool: wait
> unix 2 [ ] DGRAM 7577035 22915/pgpool: wait
> unix 2 [ ] DGRAM 7577034 22914/pgpool: wait
> unix 2 [ ] DGRAM 7577033 22913/pgpool: wait
> unix 2 [ ] DGRAM 7577032 22912/pgpool: wait
> unix 2 [ ] DGRAM 7577031 22911/pgpool: wait
> unix 2 [ ] DGRAM 7577030 22910/pgpool: wait
> unix 2 [ ] DGRAM 7577029 22909/pgpool: wait
> unix 2 [ ] DGRAM 7577028 22905/pgpool: wait
> unix 2 [ ] DGRAM 7577027 22908/pgpool: wait
> unix 2 [ ] DGRAM 7577026 22907/pgpool: wait
> unix 2 [ ] DGRAM 7577025 22906/pgpool: wait
> unix 2 [ ] DGRAM 7577024 22904/pgpool: wait
> unix 2 [ ] DGRAM 7577023 22903/pgpool: wait
> unix 2 [ ] DGRAM 7577022 22902/pgpool: wait
> unix 2 [ ] DGRAM 7577021 22898/pgpool: wait
> unix 2 [ ] DGRAM 7577020 22899/pgpool: wait
> unix 2 [ ] DGRAM 7577019 22901/pgpool: wait
> unix 2 [ ] DGRAM 7577018 22900/pgpool: wait
> unix 2 [ ] DGRAM 7577017 22893/pgpool: wait
> unix 2 [ ] DGRAM 7577016 22894/pgpool: wait
> unix 2 [ ] DGRAM 7577015 22897/pgpool: wait
> unix 2 [ ] DGRAM 7577014 22895/pgpool: wait
> unix 2 [ ] DGRAM 7577013 22896/pgpool: wait
> unix 2 [ ] DGRAM 7577012 22892/pgpool: wait
> unix 2 [ ] DGRAM 7577011 22891/pgpool: wait
> unix 2 [ ] DGRAM 7577010 22890/pgpool: wait
> unix 2 [ ] DGRAM 7577009 22889/pgpool: wait
> unix 2 [ ] DGRAM 7577008 22888/pgpool: wait
> unix 2 [ ] DGRAM 7577007 22881/pgpool: wait
> unix 2 [ ] DGRAM 7577006 22887/pgpool: wait
> unix 2 [ ] DGRAM 7577005 22886/pgpool: wait
> unix 2 [ ] DGRAM 7577004 22882/pgpool: wait
> unix 2 [ ] DGRAM 7577003 22885/pgpool: wait
> unix 2 [ ] DGRAM 7577002 22883/pgpool: wait
> unix 2 [ ] DGRAM 7577001 22884/pgpool: wait
> unix 2 [ ] DGRAM 7577000 22880/pgpool: wait
> unix 2 [ ] DGRAM 7576999 22879/pgpool: wait
> unix 2 [ ] DGRAM 7576998 22878/pgpool: wait
> unix 2 [ ] DGRAM 7576997 22877/pgpool: wait
> unix 2 [ ] DGRAM 7576996 22876/pgpool: wait
> unix 2 [ ] DGRAM 7576995 22875/pgpool: wait
> unix 2 [ ] DGRAM 7576994 22874/pgpool: wait
> unix 2 [ ] DGRAM 7576993 22873/pgpool: wait
> unix 2 [ ] DGRAM 7576992 22872/pgpool: wait
> unix 2 [ ] DGRAM 7576991 22871/pgpool: wait
> unix 2 [ ] DGRAM 7576990 22870/pgpool: wait
> unix 2 [ ] DGRAM 7576989 22866/pgpool: wait
> unix 2 [ ] DGRAM 7576988 22869/pgpool: wait
> unix 2 [ ] DGRAM 7576987 22868/pgpool: wait
> unix 2 [ ] DGRAM 7576986 22867/pgpool: wait
> unix 2 [ ] DGRAM 7576985 22865/pgpool: wait
> unix 2 [ ] DGRAM 7576984 22864/pgpool: wait
> unix 2 [ ] DGRAM 7576983 22863/pgpool: wait
> unix 2 [ ] DGRAM 7576982 22862/pgpool: wait
> unix 2 [ ] DGRAM 7576981 22861/pgpool: wait
> unix 2 [ ] DGRAM 7576980 22860/pgpool: wait
> unix 2 [ ] DGRAM 7576979 22859/pgpool: wait
> unix 2 [ ] DGRAM 7576978 22858/pgpool: wait
> unix 2 [ ] DGRAM 7576977 22855/pgpool: wait
> unix 2 [ ] DGRAM 7576976 22856/pgpool: wait
> unix 2 [ ] DGRAM 7576975 22857/pgpool: wait
> unix 2 [ ] DGRAM 7576974 22851/pgpool: wait
> unix 2 [ ] DGRAM 7576973 22852/pgpool: wait
> unix 2 [ ] DGRAM 7576972 22853/pgpool: wait
> unix 2 [ ] DGRAM 7576971 22854/pgpool: wait
> unix 2 [ ] DGRAM 7576970 22850/pgpool: wait
> unix 2 [ ] DGRAM 7576969 22849/pgpool: wait
> unix 2 [ ] DGRAM 7576968 22848/pgpool: wait
> unix 2 [ ] DGRAM 7576967 22847/pgpool: wait
> unix 2 [ ] DGRAM 7576966 22846/pgpool: wait
> unix 2 [ ] DGRAM 7576965 22845/pgpool: wait
> unix 2 [ ] DGRAM 7576964 22844/pgpool: wait
> unix 2 [ ] DGRAM 7576963 22843/pgpool: wait
> unix 2 [ ] DGRAM 7576962 22836/pgpool: wait
> unix 2 [ ] DGRAM 7576961 22842/pgpool: wait
> unix 2 [ ] DGRAM 7576960 22841/pgpool: wait
> unix 2 [ ] DGRAM 7576959 22837/pgpool: wait
> unix 2 [ ] DGRAM 7576958 22840/pgpool: wait
> unix 2 [ ] DGRAM 7576957 22839/pgpool: wait
> unix 2 [ ] DGRAM 7576956 22838/pgpool: wait
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
More information about the pgpool-general
mailing list