[Pgpool-general] pgfail

[Tatsuo Ishii]

> I have pgpool-II-2.2 and periodical have error:
> 
> 2009-02-20 08:30:34 ERROR: pid 23585: pool_process_query: 1 th kind D does
> not match with master or majority connection kind C
> 2009-02-20 08:30:34 ERROR: pid 23585: kind mismatch among backends. Possible
> last query was: " SET SESSION AUTHORIZATION DEFAULT" kind details are: 0[C]
> 1[D]
> 2009-02-20 08:30:34 LOG:   pid 23585: notice_backend_error: 1 fail over
> request from pid 23585
> 2009-02-20 08:30:34 LOG:   pid 23584: starting degeneration. shutdown host
> 192.168.0.3(5432)
> 2009-02-20 08:30:34 LOG:   pid 23584: failover_handler: set new master node:
> 0
> 2009-02-20 08:30:34 LOG:   pid 23584: failover done. shutdown host
> 192.168.0.3(5432)
> 
> Work one two hour, then error and node failover.
> 
> What can i do?

This looks pretty strange since the query in question "SET SESSION
AUTHORIZATION DEFAULT" seems to be defined in the reset_query_list,
not yours. Moreover, non of your queries in the list should not
produce [D] packet. Can you reproduce the error and show me the
PostgreSQL log with "log_statement = 'all'"?
--
Tatsuo Ishii
SRA OSS, Inc. Japan