[pgpool-general: 5118] Re: Error messages - Connection Reset by peer.

[Tatsuo Ishii]

Pgpool-II also thinks that the connections to the clients was dorpped.
Maybe there's something wrong with networks?

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

> I’m getting these messages on a regular basis.  My application also thinks the connection to the database was dropped when I get the Connection Reset error.  I get more of the Connection Reset than the EOF encountered.   The database thinks these are normal disconnections with no errors.    I’m seeing this on all 3 of my PgPool servers running the same versions.
> 
> Versions:
> PgPool  3.5.0
> Postgres 9.4.4
> OS  Redhat EL 6
> 
> 2016-11-09 08:48:25: Pid: 31749 Db: dbaas User: dbaas ERROR:  unable to read data from frontend
> 2016-11-09 08:48:25: Pid: 31749 Db: dbaas User: dbaas DETAIL:  socket read failed with an error "Connection reset by peer"
> --
> 2016-11-09 09:45:08: Pid: 31736 Db: pcm_auditor_qa User: pcm_auditor_qa ERROR:  unable to read data from frontend
> 2016-11-09 09:45:08: Pid: 31736 Db: pcm_auditor_qa User: pcm_auditor_qa DETAIL:  EOF encountered with fronted
> 
> PgPool.conf  Extract:
> 
> # - Pool size -
> 
> num_init_children = 32
>                                  # Number of pools
>                                  # (change requires restart)
> max_pool = 4
>                                  # Number of connections per pool
>                                  # (change requires restart)
> 
> # - Life time -
> 
> serialize_accept = on
> child_life_time = 0
>                                  # Pool exits after being idle for this many seconds
> child_max_connections = 128
>                                  # Pool exits after receiving that many connections
>                                  # 0 means no exit
> connection_life_time = 0
>                                  # Connection to backend closes after being idle for this many seconds
>                                  # 0 means no close
> client_idle_limit = 0
>                                  # Client is disconnected after being idle for that many seconds
>                                  # (even inside an explicit transactions!)
>                                  # 0 means no disconnection
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general