Hello Sabrina ,
Could you please shed more knowldge on why this happens ?I have been encountering this from past 3 days contioniously and restarting the tomcat doesnt seem as viable option when its production.
Could you please clarify in which Talend version/edition you are? Are you facing this issue on talend data integration 6.2.1 as well?
I am using the
Talend Real-time Big Data Platform
Build id: 20161216_1026
The error "1 awaiting execution" occurs when trying to run a Job in Job Conductor, and you cannot stop the Job by killing it. This error is usually caused by many concurrent Job executions.
To prevent this problem, follow these steps to increase the threadCount property in the quartz.properties file to always be greater than the max running time of the concurrent tasks:
Go to the Tomcat_install_dir/webapps/org.talend.administrator/WEB_LIB/conf/class/ directory and open the quartz.properties file.
Search for threadCount and increase its value.
The default setting is:
org.quartz.threadPool.threadCount = 20
So for example, for 30 max concurrent executions, you can set:
org.quartz.threadPool.threadCount = 30
Save the file and restart Tomcat.
Additionally, are your execution server on MySQL?
Feel free to let me know if it is OK with you.
I had checked this earlier and the threadpool count was set to 30 from begining ,however, the tomcat restart has solved the issue for now , but my only concern is that if this is the only possible solution as if we keep on adding more jobs then the chnces of this occuring frequently is very high . what is the optiminal thread size . what all factors should i consider before increasing the pool size ?
Is your execution server on MySQL? Yes it is ..
It is important that the hibernate.c3p0.max_size > org.quartz.dataSource.QRTZ_DS.maxConnections
This particular situation was occuring as the hibernate.c3p0.max_size < org.quartz.dataSource.QRTZ_DS.maxConnections
In addition to that, an incompatibility with the MySQL driver used by Tomcat would make job stay "awaiting execution" state.
Restarting tac will be the root solution for you? Or you still repeat this issue for a while?
It is highly recommended you create a case on talend support portal so that we can give you a remote assistance(webex session) to look into your issue in a real working environment.