TAC becomes unreachable and unresponsive, so no Jobs can be run

Talend Version          6.1.1

Summary

 
Additional Versions 6.x
Key words TAC performance unresponsive unreachable
Product Talend Data Integration
Component Talend Administration Center
Article Type Debugging
Problem Description Talend Administration Center (TAC) needs to be restarted frequently as it gets blocked after 1 hour.
Problem root cause

There could be many causes for this performance issue. It is important to know:

  • How many tasks are running at the same time?
  • How many tasks are running in a day on average?
  • For how long are they running?
  • When the tasks were created, was the "Generate on change" option checked?
  • How often are the related Jobs modified?

To get the TAC technical log, do a thread dump at the moment of the performance issue.

Solution or Workaround

Per the online document (Recommendations about environment and configuration for the Talend Administration Center) you should look at the values of these three parameters:

  • hibernate.c3p0.max_size (set in the configuration.properties file)
  • org.quartz.threadPool.threadCount (set in the quartz.properties file)
  • org.quartz.dataSource.QRTZ_DS.maxConnections (set in the quartz.properties file)

Note: You can locate the configuration.properties and the quartz.properties files in the Tomcat8.0\webapps\org.talend.administrator-6.2.1\WEB-INF\classes folder.

 

Increasing these values can be done incrementally, and it depends on the value of MAX_CONCURRENT_TASK_EXECUTIONS + MAX_CONCURRENT_PLAN_EXECUTIONS.

 

If hibernate.c3p0.max_size < org.quartz.dataSource.QRTZ_DS.maxConnections you will have problems, so it is important to ensure that the hibernate.c3p0.max_size > org.quartz.dataSource.QRTZ_DS.maxConnections.

You will need to restart the Tomcat / TAC for the change to take effect. After changing the values, the TAC should behave well and stop crashing.

JIRA ticket number  
Version history
Revision #:
6 of 6
Last update:
‎05-25-2017 07:10 PM
Updated by:
 
Contributors
Tags (1)