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
B
Bharat Joshi
said
over 3 years ago
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
B
Bharat Joshi
said
over 3 years ago
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
Bharat Joshi
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.
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
Bharat Joshi
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
-
Recover Deleted(soft Delete) Record and Configure in Application
-
How Can I Trigger Enricher or Sql Procedure when deleting?
-
Unstructured and Semi Structured Data in Semarchy?
-
Read CSV files from AWS S3
-
Find SQL Statements Generated for Match Rules
-
Is it possible to disable specific steps of an Integration Job?
-
Reset the Override on Many Records Through the Interface or By Script
-
PL/SQL Procedure With B_CREDATE and B_UPDDATE Not Mapped or Loaded, Columns Will Be Null
-
Unable to Load Publisher Data Using Continuous Load
-
LoadDataRecord contains non persitable expressions when trying to publish Data using the Rest API
See all 61 topics