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

Greg Swallow gswallow at exacttarget.com
Wed Sep 19 22:18:13 JST 2012


I see the same error using membase (which is memcached wire-compatible).

On Sep 19, 2012, at 4:56 AM, Tatsuo Ishii wrote:

>> On Sat, Sep 15, 2012 at 6:05 PM, Tatsuo Ishii <ishii at postgresql.org> wrote:
>>> Lonni,
>>> 
>>> Can you call pq_trace in your PHP app and send me the log when the
>>> error occurs?  It shows detailed data between your app and pgpool. It
>>> will help us lot to understand what's happening.
> 
> I see C packet (Command Complete) immediately follows T(row
> description, response to "D"(Descrive) packet). This is strange.
> C should appear 
> From backend> T
> :
> :
> From backend> C
> From backend (#4)> 13
> From backend> "SELECT 0"
> 
> "C" should appear after "D"(Data row). But even strange thing is we
> see two "D" packets:
> 
> From backend> D
> From backend (#4)> 286
> From backend> D
> From backend (#4)> 286
> 
> This is the reason why you see the error ("D" should not appear
> without prior "T").
> 
> I'm still looking for the cause of this.
> 
> BTW do you see same error if you use memcached, rather than shmem?
> If not, I can narrow down the error case around the shmem code.
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese: http://www.sraoss.co.jp
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
> 

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2835 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20120919/08f7bb39/attachment.p7s>


More information about the pgpool-general mailing list