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

[Marcelo Martins]

I guess I just thought it was weird seeing that ": i: 0 master:0  
readfd:0 exceptfd:0" and " detect_error: kind: NUM".
It kind of mislead me to think some real errors were occurring until I  
did a diff on the " pool_process_query.c" versions and realized the  
new debug calls :)


Marcelo
PostgreSQL DBA
Linux/Solaris System Administrator

On Jan 14, 2009, at 8:59 AM, Tatsuo Ishii wrote:

>> 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.
>
> Thanks for pointing out. I think you mean there are too many DEBUG
> lines. I have removed it and committed.
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
>
>> 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