[Pgpool-general] Understanding Error Messages

[Tatsuo Ishii]

> 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