[Pgpool-general] pgfail

[Tatsuo Ishii]

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 <ishii at sraoss.co.jp>
> 
> > > 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
> >