[Pgpool-general] understanding some log entries....

[Tatsuo Ishii]

> while testing pgpool-II I got a bit confused by some "detect_error" messages in
> the log, which I'm not able to interpret them...
> Does "detect_error" mean -> "let's look for errors",

Yes, this. So I see no errors here.

> or does it mean -> "I found an error"  ?
> And how to interpret the "C","Z","T" after "kind: " ? I guess these
> are some

They are related to PostgreSQL frontend/backend protocol. Any data
from backend to frontend (in this case pgpool) starts with "kind"
character. In this case, "C" stands for "Command complete", which
means a comand is done. "Z" means "Ready for query", which means
backend is prepared to receive next command. "T" means "Row
description", which describes data type included in a SELECT
result. To lean more, look into Internals->Frontend/Backend Protocol
in PostgreSQL documentation.
--
Tatsuo Ishii
SRA OSS, Inc. Japan

> status indicators, but a first grep over the header files didn't give some
> information to me.
> Since health_check doesn't show an error I assume everything's running fine...
> 
> any hint appreciated....GERD....
> 
> 2009-05-06 13:10:59 LOG:   pid 708: statement: insert into test (a_int,a_text)
> values (1, 'eins');
> 2009-05-06 13:10:59 DEBUG: pid 708: do_command: Query: BEGIN
> 2009-05-06 13:10:59 DEBUG: pid 708: detect_error: kind: C
> 2009-05-06 13:10:59 DEBUG: pid 708: do_command: kind: C
> 2009-05-06 13:10:59 DEBUG: pid 708: do_command: kind: Z
> 2009-05-06 13:10:59 DEBUG: pid 708: do_command: transaction state: T
> 2009-05-06 13:10:59 DEBUG: pid 708: do_command: Query: BEGIN
> 2009-05-06 13:10:59 DEBUG: pid 708: detect_error: kind: C
> 2009-05-06 13:10:59 DEBUG: pid 708: do_command: kind: C
> 2009-05-06 13:10:59 DEBUG: pid 708: do_command: kind: Z
> 2009-05-06 13:10:59 DEBUG: pid 708: do_command: transaction state: T
> 2009-05-06 13:10:59 DEBUG: pid 708: get_insert_command_table_name: extracted
> table name: "test"
> 2009-05-06 13:10:59 DEBUG: pid 708: waiting for backend 0 completing the query
> 2009-05-06 13:10:59 DEBUG: pid 708: detect_error: kind: C
> 2009-05-06 13:10:59 DEBUG: pid 708: detect_error: kind: C
> 2009-05-06 13:10:59 DEBUG: pid 708: detect_error: kind: C
> 2009-05-06 13:10:59 DEBUG: pid 708: waiting for backend 1 completing the query
> ...
> 2009-05-06 13:11:44 DEBUG: pid 559: starting health checking
> 2009-05-06 13:11:44 DEBUG: pid 559: health_check: 0 th DB node status: 2
> 2009-05-06 13:11:44 DEBUG: pid 559: health_check: 1 th DB node status: 2
> -- 
> /===============================\
> | Gerd König
> | - Infrastruktur -
> |
> | TRANSPOREON GmbH
> | Pfarrer-Weiss-Weg 12
> | DE - 89077 Ulm
> |
> |
> | Tel: +49 [0]731 16906 16
> | Fax: +49 [0]731 16906 99
> | Web: www.transporeon.com
> |
> \===============================/
> 
> 
> 
> Bleiben Sie auf dem Laufenden.
> Jetzt den Transporeon Newsletter abonnieren!
> http://www.transporeon.com/unternehmen_newsletter.shtml
> 
> 
> TRANSPOREON GmbH, Amtsgericht Ulm, HRB 722056
> Geschäftsf.: Axel Busch, Peter Förster, Roland Hötzl, Marc-Oliver Simon
> _______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general