> We are running a two node pgpool-II database set and are using Master - > Master replication. > > What do these errors mean? > > Dec 30 15:46:17 pgpool1-2 pgpool: 2008-12-30 15:46:17 LOG: pid 3188: > ProcessFrontendResponse: failed to read kind from frontend. frontend > abnormally exited > Dec 30 15:46:17 pgpool1-2 pgpool: 2008-12-30 15:46:17 ERROR: pid 3188: > pool_process_query: 1 th kind E does not match with master connection kind S > > Dec 30 15:46:21 pgpool1-2 pgpool: 2008-12-30 15:46:21 ERROR: pid 4413: > pool_process_query: 1 th kind E does not match with master connection kind C > Dec 30 15:46:21 pgpool1-2 pgpool: 2008-12-30 15:46:21 LOG: pid 4413: > do_child: exits with status 1 due to error > > It would be nice if pgpool would log the query that generated the error. > > > There is no way we can run pgpool in debug mode in production.
Turning "log_statement" to true will log the statement pgpool executes. BTW, next release of pgpool-II will print the statement which generates the error above. > Is there a document that explains what kind E or kind S means? Please take a look into PostgeSQL docs. Internals -> Frontend/Backend Protocol -> Message formt. You will find: E: Error S: ParameterStatus C: CommandComplete -- Tatsuo Ishii SRA OSS, Inc. Japan _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
