[pgpool-general: 949] using prepared statements when memory_cache_enabled=on

Lonni J Friedman netllama at gmail.com
Wed Sep 5 08:35:55 JST 2012


Greetings,
I'm running 3.2.0 with memory_cache_enabled=on and memqcache_method =
'memcached', and I'm seeing really bizarre errors when using prepared
statements.  Basically any query that should use the prepared
statement is failing with:
server sent data ("D" message) without prior row description ("T" message)

This only happens once the data has been cached by pgpool (with the
memcache server).  If I set memory_cache_enabled=off, then it works
fine.  I'm guessing that maybe the problem is that the prepared
statement isn't getting cached, so the queries which depend on the
prepared statement fail?

Is this expected behavior?  If so, is there a work around that doesn't
require me to not cache the tables that the prepared statement
reference?

thanks!


More information about the pgpool-general mailing list