[pgpool-general: 5556] Re: pgpool and erlang - request hangs

[Pavel]

Hello, Tatsuo.

Thank  you  very much, test connections works normally!!!
We'll run more tests today and I'll report the results.

What   about  the  changes  you  proposed in patch in "pgpool-general:
5506",  should  I keep them as well? Right now I'm running pgpool with
both patches applied.

You wrote 5 июня 2017 г., 8:50:13:

> 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
> your problem.

> Best regards,
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese:http://www.sraoss.co.jp

>>> 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)));
>>>                                         pool_set_doing_extended_query_message();
>>>                                 }
>>>                                 status = SimpleForwardToBackend(fkind, frontend, backend, len, contents);
>>>                                 break;
>>>                         }
>>> 
>>> Indeed, debug log contains records
>>>>DEBUG:  Entered patched location
>>>>DETAIL:  message type was H(48)
>>>>LOCATION:  pool_proto_modules.c:2484
>>> 
>>> 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
>> Japanese:http://www.sraoss.co.jp
>> _______________________________________________
>> pgpool-general mailing list
>> pgpool-general at pgpool.net
>> http://www.pgpool.net/mailman/listinfo/pgpool-general



-- 
Best regards,
 Pavel                          mailto:balroga3 at yandex.ru