[Pgpool-general] "FATAL: invalid frontend message type 4"

Xavier Noguer xnoguer at antica.cl
Thu Dec 24 14:38:33 UTC 2009


 Hello,

 I encountered a problem with a pgpool installation. Pgpool failed and
detached a backend, but I don't know the reason because that particular
pgpool server is not writing to its log (problem with cronolog, and I
can't restart pgpool since its a live system).

 What I did find was a suspicious message in the postgres log of the
failed backend. Here are the relevant lines of the log:


2009-12-23 15:07:20 CLST, sess LOG:  duration: 39.809 ms  statement:
EXECUTE <unnamed>  [PREPARE:  COMMIT]
2009-12-23 15:07:20 CLST, sess FATAL:  invalid frontend message type 4
2009-12-23 15:07:20 CLST, sess LOG:  unexpected EOF on client connection
2009-12-23 15:07:20 CLST, sess LOG:  unexpected EOF on client connection
2009-12-23 15:07:20 CLST, sess LOG:  unexpected EOF on client connection
2009-12-23 15:07:20 CLST, sess LOG:  unexpected EOF on client connection
2009-12-23 15:07:20 CLST, sess LOG:  unexpected EOF on client connection
2009-12-23 15:07:20 CLST, sess LOG:  unexpected EOF on client connection
2009-12-23 15:07:20 CLST, sess LOG:  unexpected EOF on client connection


 Since this happened at the same time as the failing of the backend I'm
assuming this condition made postgres close the connection to pgpool and
so triggered the failing and detaching of the backend.

 Does anybody know what message type 4 is ?


 Regards



More information about the Pgpool-general mailing list