[pgpool-general: 3312] Re: error messages

[Tatsuo Ishii]

> Hi
> 
> Is there a wiki with the possible pgpool log/error messages and what they
> mean?

No.

> This can help a lot in troubleshooting. In particular I see these
> messages in my log. Can you tell me which ones are errors and what they
> mean?

If the message started with "ERROR" then it's an error. Otherwise not
error.

> pool_send_and_wait: Error or notice message from backend: : DB node id: 0
> backend pid: 32113 statement: select  1 from table.my_function()
> message: Got none

Pgpool-II tried to send query to backend but failed because backend
returns following error message.

> canceling statement due to conflict with recovery

> 
> connection closed. retry to create new connection pool.
> 
> 
> ERROR: pid 25914: pool_flush_it: write failed to backend (3). reason:
> Broken pipe offset: 0 wlen: 5

The socket to backend was broken. You need to look into PostgreSQL log
to find out what actually happend.

> connect_inet_domain_socket: select() timed out. retrying...

Harmless. pgpool-II is try to connect to backend.

> do_child: failback event found. restart myself.

Harmless.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp