[Pgpool-general] Consistency issues

[Fernando Morgenstern]

Hello,

I have pgpool setup with 4 postgres nodes. I tried to run the  
following test with:

3 Active nodes
1 Failed nodes

While recovering the failed node i decided to connect on pgpool and  
run a simple create database. What i got was:

# create database test123;
ERROR:  kind mismatch among backends. Possible last query was: "create  
database test123;" kind details are: 0[E] 1[C] 3[C]
HINT:  check data consistency among db nodes
server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.
The connection to the server was lost. Attempting reset: Succeeded.

An this caused one of the nodes to be at an inconsistency state  
( without test123 database ).

Do you know what could have caused this problem? Do i have to stop  
pgpool when running pcp_recovery_node?

Thanks,
---

Fernando Marcelo
www.consultorpc.com
fernando at consultorpc.com
Tel: +34 902 998971
Fax: +34 91 7903701

## legal disclaimer

The information contained in this email is confidential. It is  
intended only
for the stated addressee(s) and access to it by any other person is
unauthorized. If you are not an addressee, you must not disclose, copy,
circulate or in any other way use or rely on the information contained  
in
this email. Such unauthorized use may be unlawful. If you have  
received this
email in error, please inform us immediately by emailing admin at consultorpc.com
and delete it and all copies from your system.

## end mail