> 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]
You should find something in the PostgreSQL log of node 0. (0[E] means node 0 PostgreSQL reported error condition, while 1[C] means the operation completed noramly). Note that pgpool-II 2.3.1 reports PostgreSQL error in case [E], which should make admin's life a little bit easier. -- Tatsuo Ishii SRA OSS, Inc. Japan > 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 > [email protected] > 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 [email protected] > and delete it and all copies from your system. > > ## end mail > > _______________________________________________ > Pgpool-general mailing list > [email protected] > http://pgfoundry.org/mailman/listinfo/pgpool-general _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
