[Pgpool-general] Consistency error codes

[Xavier Noguer]

 Fernando,

 You might be able to get a better idea of what happens if you enable
pgpool's debugging mode (-d option). On debugging mode pgpool logs every
message type received from the frontend and every message type received
from its backends, so you might get a better idea of the message flow
that leads to the message type mismatch that you see.


Regards

On Thu, 2010-01-14 at 17:33 -0200, Fernando Morgenstern wrote:
> Xavier,
> 
> Thanks for your answer.
> 
> Unfortunately, even after reading this page, i couldn't understand what causes this problem
> 
> Do you any idea of what could have caused it?
> 
> I searched postgres log at node 0, trying to find some clue of what happened, but there isn't anything there.
> 
> Best Regards,
> ---
> 
> Fernando Marcelo
> www.consultorpc.com
> fernando at consultorpc.com
> 
> 
> Em 14/01/2010, às 11:44, Xavier Noguer escreveu:
> 
> > 
> > Fernando, you can find a description of all message types here:
> > 
> > http://developer.postgresql.org/pgdocs/postgres/protocol-message-formats.html
> > 
> > 
> > 'D' means is a data row message.
> > 
> > Regards
> > 
> > On Thu, 2010-01-14 at 09:56 -0200, Fernando Morgenstern wrote:
> >> Hello,
> >> 
> >> 
> >> Is there a part of the manual or some page where i can find the
> >> meaning of each consistency errors? I tried searching google but
> >> couldn't find this ( maybe i was using the wrong keywords ).
> >> 
> >> 
> >> Example:
> >> 
> >> 
> >> ERROR: kind mismatch among backends. Possible last query was: "SET
> >> DateStyle=ISO;SELECT oid, pg_encoding_to_char(encoding) AS encoding,
> >> datlastsysoid FROM pg_database WHERE oid = 435746" kind details are:
> >> 0[D] 1[C] 2[C] 3[C]
> >> HINT: check data consistency among db nodes
> >> 
> >> 
> >> C means that everything went correct on that node? What about D?
> >> 
> >> 
> >> 
> >> 
> >> Best Regards,
> >> ---
> >> 
> >> 
> >> Fernando Marcelo
> >> www.consultorpc.com
> >> fernando at consultorpc.com
> >> 
> >> 
> >> _______________________________________________
> >> Pgpool-general mailing list
> >> Pgpool-general at pgfoundry.org
> >> http://pgfoundry.org/mailman/listinfo/pgpool-general
> > 
> 
> _______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general