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