[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