[pgpool-general: 5234] Connection stuck when running plv8 function that creates temp table

[Avi Weinberg]

Hi Experts,

On several occasions we had setups that stopped working because some connections were waiting for a function that got stuck.  The common thing about the setups is that the stuck function was plv8 function that creates a temp table.  Although we are not sure, we suspect it is related to pgpool because in some setups we disabled pgpool and are accessing the database directly and in others we kept pgpool.  In the first setups we did not (yet) see the problem again and in the others we keep seeing it.   Restarting pgpool resolves the problem.


Any suggestions might have caused the problem?

Thanks
Avi
IMPORTANT - This email and any attachments is intended for the above named addressee(s), and may contain information which is confidential or privileged. If you are not the intended recipient, please inform the sender immediately and delete this email: you should not copy or use this e-mail for any purpose nor disclose its contents to any person.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20170115/e36ce2f7/attachment.html>