TAC becomes unreachable and unresponsive, Connection refused

[Breaker]

Hello, 

Talend Version: 7.2.1 

Tomcat Version: 9.0.17

We get in intervals this error: 

Exception in thread "pool-19-thread-1" org.talend.logging.audit.AuditAppenderException: java.net.ConnectException: Connection refused (Connection refused)
at org.talend.logging.audit.impl.Log4j1HttpAppender.sendEvent(Log4j1HttpAppender.java:139)
at org.talend.logging.audit.impl.Log4j1HttpAppender.access$100(Log4j1HttpAppender.java:21)
at org.talend.logging.audit.impl.Log4j1HttpAppender$LogSender.run(Log4j1HttpAppender.java:196)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.net.ConnectException: Connection refused (Connection refused)
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:589)
at sun.net.NetworkClient.doConnect(NetworkClient.java:175)
at sun.net.www.http.HttpClient.openServer(HttpClient.java:463)
at sun.net.www.http.HttpClient.openServer(HttpClient.java:558)
at sun.net.www.http.HttpClient.<init>(HttpClient.java:242)
at sun.net.www.http.HttpClient.New(HttpClient.java:339)
at sun.net.www.http.HttpClient.New(HttpClient.java:357)
at sun.net.www.protocol.http.HttpURLConnection.getNewHttpClient(HttpURLConnection.java:1220)
at sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1156)
at sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:1050)
at sun.net.www.protocol.http.HttpURLConnection.connect(HttpURLConnection.java:984)
at sun.net.www.protocol.http.HttpURLConnection.getOutputStream0(HttpURLConnection.java:1334)
at sun.net.www.protocol.http.HttpURLConnection.getOutputStream(HttpURLConnection.java:1309)
at org.talend.logging.audit.impl.Log4j1HttpAppender.sendEvent(Log4j1HttpAppender.java:136)
... 5 more

If we do not restart the tomcat after a while, the TAC becomes unresponsive. So no Jobs will be running.

Does anyone know this error or can help?

Thank you.

Regards,

Thomas

[Anonymous]

Hello,

It looks like Tomcat Catalina log contains some thread pool related error messages, should be due to lack of connection objects in pool.

Could you please try to increase below parameters in configuration.properties and quartz.properties files to allocate more resources for TAC process. ('900' is an example, please change it based on exact needs)
Location of the files ([TAC_directory]\apache-tomcat\webapps\org.talend.administrator\WEB-INF\classes )

configuration.properties -
hibernate.c3p0.max_size=900

quartz.properties-
org.quartz.threadPool.threadCount = 900
org.quartz.dataSource.QRTZ_DS.maxConnections = 900

Then restart TAC.

Let us know if it works fine.

Best regards

Sabrina

[Breaker]

Hello Sabrina, 

thank you. Unfortunately, the error still happens. 

But now, I know which action this error generate. After I login to the TAC. 

Do you have any ideas about this behavior?

Best Regards,

Thomas

[Breaker · Accepted solution]

Hello,

Solution:

* Stop TAC
* Open the configuration.properties file to edit it. The file is located in the <tomcat_path>\webapps\org.talend.administratorWEB-INF\classes folder.
* In the Audit Logs section, change the auditlog.enable parameter to false.
* Restart TAC and check the logs.

Regards,

Thomas

[Arjun1]

Can i know how the audit parameters added to configuration.properties file and enables as true default? is it because of selection of Talend modules during the installation?

Regards,
Arjun
-------------
Do not forget to give Kudos to my post if it explain your query! Please accept as solution if it's solve your challenge!