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

[Yoshiyuki Asaba]

Hi,

From: Benoit Poulet <benoit.poulet at businessdecision.com>
Subject: Re: [Pgpool-general] ProcessFrontendResponse: failed to read kind from frontend. frontend abnormally exited
Date: Wed, 10 Oct 2007 11:12:57 +0200

> >> ** 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?
> >   
> I do the upgrade, but it seems it doesn't fix the problem.
> Last time i tried to switch in degeneration mode for maintenance with
> the following command :
> pgpool -s s switch
> 
> I saw this in the log file :
> 2007-10-04 12:35:58 LOG:   pid 12107: starting degeneration. shutdown
> secondary host edr-02(5432)
> 2007-10-04 12:35:58 LOG:   pid 12107: degeneration done. shutdown
> secondary host edr-02(5432)
> 
> Everything seemed fine, i were able to connect through pgpool with the
> psql client and do some sql requests.
> 
> But the java app, who already had established connections to pgpool,
> crash when the app tried to do read/write requests.

pgpool does not have graceful detach so that all processes are
restarted immediately.

I think graceful detach is useful. I add the item into TODO list.

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