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 _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
