[Pgpool-general] pgfail

[Евгений Фурманюк]

Yes, mostly select. In a insert statement is used function now. Perhaps this
is due to the reason for the fall. What pgpool do if found in statement
function now ?

2009/2/20 Евгений Фурманюк <furmanyk.ea at gmail.com>

> Hello all.
>
> 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?
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pgpool-general/attachments/20090313/0d229e13/attachment.html