[Pgpool-general] ProcessFrontendResponse: failed to read kind from frontend. frontend abnormally exited

[Yoshiyuki Asaba]

Hi,

From: Benoit Poulet <benoit.poulet at businessdecision.com>
Subject: [Pgpool-general] ProcessFrontendResponse: failed to read kind from frontend. frontend abnormally exited
Date: Mon, 24 Sep 2007 16:37:00 +0200

> ** 1rst problem - Databases desynch
> When i look into the log i can often see this message :
> 2007-09-23 22:26:53 ERROR: pid 10686: ProcessFrontendResponse: failed to
> read kind from frontend. frontend abnormally exited
> 2007-09-23 22:26:53 LOG:   pid 10686: do_child: exits with status 1 due
> to error
> 
> I would like to know if theses messages can explain the databases
> desynch and if not, what can be the reason of this desynch ? (we already
> check the limitation of pgpool on the pgpool's homepage).

The above message means that a client closed socket before sending
Terminate message. It is not a reason of desync.


> ** 2nd problem
> 
> When the secondary server failed or goes off-line, pgpool enter in
> degeneration mode and get stuck !
> we need to restart pgool to be able to connect to the database again.
> 
> Is it the right behavior or i missed something ?

pgpool 3.4 had the bug that it failed degeneration.
Could you upgrade it to 3.4.1?

Regards,
--
Yoshiyuki Asaba
y-asaba at sraoss.co.jp