[Pgpool-general] Latest CVS verson: "i: 0 master:0 readfd:0 exceptfd:0"

Marcelo Martins pglists at zeroaccess.org
Mon Jan 12 20:06:00 UTC 2009


Hi Tatsuo,

Not sure if you have noticed this but I guess you may have already but  
anyway....

On the CVS version 1.129 that I have the following character appeared  
after the " read kind from 0 th backend" which I noticed has been  
fixed on
the latest CVS version 1.131 ... so thanks

DEBUG: pid 18003: read_kind_from_backend: read kind from 0 th backend  
� NUM_BACKENDS: 1
DEBUG: pid 18003: pool_process_query: kind from backend: D


On this latest CVS version though I have noticed the following which  
seems to happen
every time a psql command runs.  On the previous CVS version (1.129)  
which I had such did not happen.

Jan 12 13:49:52 debian-db6 pgpool: 2009-01-12 13:49:52 DEBUG: pid  
17783: i: 0 master:0 readfd:0 exceptfd:0
Jan 12 13:49:52 debian-db6 pgpool: 2009-01-12 13:49:52 DEBUG: pid  
17783: i: 1 master:0 readfd:0 exceptfd:0
Jan 12 13:49:52 debian-db6 pgpool: 2009-01-12 13:49:52 DEBUG: pid  
17783: read kind from frontend Q(51)
Jan 12 13:49:52 debian-db6 pgpool: 2009-01-12 13:49:52 DEBUG: pid  
17783: statement2: SELECT d.datname as "Name",
Jan 12 13:49:52 debian-db6 pgpool:        r.rolname as "Owner",
Jan 12 13:49:52 debian-db6 pgpool:         
pg_catalog.pg_encoding_to_char(d.encoding) as "Encoding"
Jan 12 13:49:52 debian-db6 pgpool: FROM pg_catalog.pg_database d
Jan 12 13:49:52 debian-db6 pgpool:   JOIN pg_catalog.pg_roles r ON  
d.datdba = r.oid
Jan 12 13:49:52 debian-db6 pgpool: ORDER BY 1;
Jan 12 13:49:52 debian-db6 pgpool: 2009-01-12 13:49:52 DEBUG: pid  
17783: waiting for backend 0 completing the query
Jan 12 13:49:52 debian-db6 pgpool: 2009-01-12 13:49:52 DEBUG: pid  
17783: i: 0 master:0 readfd:1 exceptfd:0
Jan 12 13:49:52 debian-db6 pgpool: 2009-01-12 13:49:52 DEBUG: pid  
17783: detect_error: kind: T
Jan 12 13:49:52 debian-db6 pgpool: 2009-01-12 13:49:52 DEBUG: pid  
17783: detect_error: kind: T
....




Marcelo
PostgreSQL DBA
Linux/Solaris System Administrator



More information about the Pgpool-general mailing list