Thread: pgpool log errors
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,
> 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