Start a new topic
Answered

How to Monitor connections pooling?

PROD execution engine was stopped due to the occurrence of UNABLE TO GET THE CONNECTION FROM DATA SOURCE and SEMARCHY_REPOSITORY -interrupted during connection acquisition.






Best Answer

Initially one should increase the  MAXIMUMPOOLSIZE  which will allow to accommodate more concurrent tasks.


we can also the increase Connection Timeout parameter if you have the default value from 5000 to 10000.



And now to monitor connection pooling, we should use the below commands


netstat -ant | grep 5432  

lsof -nP -i :5432 -sTCP:ESTABLISHED

ss -46 -np state established dport = :5432 | grep 'java' | sort -r -k 3,3 | nl 




If the pools is working you should see 10 ESTABLISHED connections to your respective ports


for your reference


1 Comment

Answer

Initially one should increase the  MAXIMUMPOOLSIZE  which will allow to accommodate more concurrent tasks.


we can also the increase Connection Timeout parameter if you have the default value from 5000 to 10000.



And now to monitor connection pooling, we should use the below commands


netstat -ant | grep 5432  

lsof -nP -i :5432 -sTCP:ESTABLISHED

ss -46 -np state established dport = :5432 | grep 'java' | sort -r -k 3,3 | nl 




If the pools is working you should see 10 ESTABLISHED connections to your respective ports


for your reference


Login to post a comment