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 1 year 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 1 year 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
-
Import Data Into Entities via Azure Data Lake
-
Recover Deleted(soft Delete) Record and Configure in Application
-
Data Quality in batch mode and real-time integration
-
Integration with analytics tools
-
Query/Load/Delete data with the REST API
-
Does the Done Tab in Inbox have a limit?
-
How Can I Trigger Enricher or Sql Procedure when deleting?
-
Matching Rules But Only The Latest Record Creates a Golden Record
-
Unstructured and Semi Structured Data in Semarchy?
-
Read CSV files from AWS S3
See all 71 topics