That's 1333 queries per second. What kind of queries are they? Mostly SELECT? -- Tatsuo Ishii SRA OSS, Inc. Japan
> Error appears only when big load on pgpool, about 400k queries by 5 minuts. > At this time in postgresql.log have been:"unexpected EOF on client > connection". > Error was repeated 55 times. > > > 2009/2/21 Tatsuo Ishii <[email protected]> > > > > 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
