pgpool log errors

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • postgresql.org@seumas.com
    #1

    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: ProcessFrontend Response: 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

    Tags: None
    • Tatsuo Ishii
      #2
      Re: pgpool log errors

      > I've started using pgpool and while everything appears to be working,[color=blue]
      > 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: ProcessFrontend Response: 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.[/color]

      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 majordomo@postg resql.org so that your
      message can get through to the mailing list cleanly

        Comment

        Previous template Next
        Working...