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

calimlimvl at nationalbookstore.com.ph calimlimvl at nationalbookstore.com.ph
Tue Jul 29 03:16:15 UTC 2008


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



More information about the Pgpool-general mailing list