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

[Tatsuo Ishii]

Yes, I have a plan to do something like you said.

However at this moment, you could use Apache's rotatelogs:

pgpool -n 2>&1 | /usr/local/apache2/bin/rotatelogs /some/where 86400

(assuming you are using sh or bash etc.)
--
Tatsuo Ishii
SRA OSS, Inc. Japan

> Hello Tatsuo,
> 
> thanks for the quick and very helpful answer.
> BTW:...I convinced our developers to evaluate pgpool ASAP, and it's already in
> our develop-/test-environment :-))
> 
> I've one open question:
> Is it possible/planned to implement a pgpool-logging mechanism to create e.g.
> one log file per day (like it is in postgres). Currently (with debug output
> enabled) I get several GBs log each day....
>
> thanks in advance...::GERD::...
> 
> Tatsuo Ishii schrieb:
> >> 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
> > 
> 
> -- 
> /===============================\
> | 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