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