[Pgpool-general] SQL error: kind mismatch between backends - Pgpool-II - Parallel Query Mode

[calimlimvl at nationalbookstore.com.ph]

Hi,

I just tried it on pgpool-II 2.1 and still happens. Anyone? Thanks! :)

Regards,
Viril Calimlim

> Hello!
>
> When I do EXPLAIN or EXPLAIN ANALYZE on the Pgpool-II Server with Parallel
> Query Mode and Load Balancing to TRUE, I get the following:
>
> -=-=-=-=-=-=-=-=-=
> SQL error:
>
> ERROR:  kind mismatch between backends
> HINT:  check data consistency between master and other db node
> server closed the connection unexpectedly
> 	This probably means the server terminated abnormally
> 	before or while processing the request.
>
> In statement:
> EXPLAIN ANALYZE SELECT * FROM salesdtl WHERE branchcode='001' AND
> trxdate>='2007-01-01' AND trxdate<='2007-01-31' ORDER BY qtysold DESC
> OFFSET 0 LIMIT 10
> -=-=-=-=-=-=-=-=-=
>
> Did I miss anything? Is it fixed on version 2.1 stable? I use 2.1rc1.
> Anyone please? Thank you. :)
>
> Regards,
> Viril Calimlim
>
> _______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general
>
>