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

[Gerd König]

Hello,

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