[pgpool-general: 5555] Re: pgpool and erlang - request hangs
ishii at sraoss.co.jp
Mon Jun 5 14:50:13 JST 2017
Ok, I think I found a another possible cause. After the client sends
a flush message, it read the socket until Pgpool-II returns a
response. Unfortunately, Pgpool-II keeps on waiting response from
backend, because after "Row description" message returned from backend
because "query in progress" in Pgpool-II is on. Attached patch resets
the flag upon receiving "Row description" message. I hope this solves
SRA OSS, Inc. Japan
>> Hello Tatsuo.
>> Did you have an opportunity to look into our problem? Is there anything I
>> can do to help you nail this bug?
> I was a little bit busy past 1 week due to attending PGCon in
> Ottawa. I will look into this. BTW, strange thing is, I was succeeded
> in reproducing your problem by using my own test tool and confirmed
> the fix works. Probably there are more causes which I am missing in
> your case.
>> (errmsg("Entered patched location"),
>> errdetail("message type was %c(%02x)", fkind, fkind)));
>> status = SimpleForwardToBackend(fkind, frontend, backend, len, contents);
>> Indeed, debug log contains records
>>>DEBUG: Entered patched location
>>>DETAIL: message type was H(48)
>> To sum up:
>> replication_mode = off
>> load_balance_mode = on
>> master_slave_mode = on
>> master_slave_sub_mode = 'stream'
>> memory_cache_enabled = off
>> If master_slave_mode is off, then connection from erlang library does not hang.
> Thank you for additional information.
> Best regards,
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> pgpool-general mailing list
> pgpool-general at pgpool.net
-------------- next part --------------
A non-text attachment was scrubbed...
Size: 829 bytes
Desc: not available
More information about the pgpool-general