topic Re: TAC becomes unreachable and unresponsive, Connection refused in Installing and Upgrading

TAC becomes unreachable and unresponsive, Connection refused

Breaker — Sat, 16 Nov 2024 03:56:52 GMT

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

Re: TAC becomes unreachable and unresponsive, Connection refused

Anonymous — Tue, 03 Dec 2019 08:03:51 GMT

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

Re: TAC becomes unreachable and unresponsive, Connection refused

Breaker — Tue, 03 Dec 2019 09:35:47 GMT

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

Re: TAC becomes unreachable and unresponsive, Connection refused

Breaker — Wed, 04 Dec 2019 06:03:40 GMT

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

Re: TAC becomes unreachable and unresponsive, Connection refused

Arjun1 — Mon, 24 Feb 2020 15:16:34 GMT

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!