[pgpool-general: 8360] Active connection

j. e. j.emerlik at gmail.com
Mon Aug 22 19:14:25 JST 2022


Hi,
I am using pgoool version 4.2.5 and  noticed somerhing disturbing.

pg_stat_statements showed one query in active state for long time, then I checked  network connecrions between pgpool and postgresql using netstat and connection between pgpool and frontend.

Connection between pgpool and postgresql is established but between pgpool and frontend is missed. 

command on pgpool:

ps aux showed IP and port of „connected„ frontend but connection in netstat is missed.

Why and what could have happened ?
How I can diagnose that ?


Regards
Jack



More information about the pgpool-general mailing list