By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,710 Members | 1,960 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,710 IT Pros & Developers. It's quick & easy.

pgpool log errors

P: n/a
I've started using pgpool and while everything appears to be working,
I've been getting a lot of the following errors in my logs:

----
ERROR: pid 14761: pool_read: EOF encountered
----

This seems to be simple enough - the client/user probably just canceled
the request and isn't anything to be concerned about? I get about a
dozen of these per hour on a system that has about 25,000 connections/day.
----
ERROR: pid 14761: ProcessFrontendResponse: failed to read kind
----

I have no idea what this one means. I'm concerned because I get a lot of
these Between one and two dozen per hour.

I've googled. I've searched the postgres mailing list archives. Asked
around in IRC. Can't really find anything to explain it. I would greatly
appreciate clarification from anyone with insight to this.

Regards,
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 23 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
> I've started using pgpool and while everything appears to be working,
I've been getting a lot of the following errors in my logs:

----
ERROR: pid 14761: pool_read: EOF encountered
----

This seems to be simple enough - the client/user probably just canceled
the request and isn't anything to be concerned about? I get about a
dozen of these per hour on a system that has about 25,000 connections/day.
----
ERROR: pid 14761: ProcessFrontendResponse: failed to read kind
----

I have no idea what this one means. I'm concerned because I get a lot of
these Between one and two dozen per hour.

I've googled. I've searched the postgres mailing list archives. Asked
around in IRC. Can't really find anything to explain it. I would greatly
appreciate clarification from anyone with insight to this.


I don't know what verison of pgpool you are using nor your pgpool.conf
but I guess your clients are just sloppy in that disconnect the
connection without using disconnect API (what kind of language are
using for the API, by the way?)

In this case you will get errors such as "unexpected EOF on
client connection" from PostgreSQL even if you don't use pgpool
anyway.
--
Tatsuo Ishii

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.