-
Type: Bug
-
Status: Resolved
-
Priority: Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 2022.4.0
-
Component/s: Analytics / Stats
-
Tags:
-
Team:NOS
Several times, we have noticed transaction timeout errors when writing the stat entry appearing 5 minutes after the beginning of the worker execution. It is really likely that we try to write all entries in once so we end up into a transaction timeout as it takes sometimes more than 5 minutes. We should review the stat entry extraction to process them by batch and avoid running into those errors.
There are also a few SocketTimeoutException when opening a new connection to the Tableau database that maybe be related to the previous errors
java.net.SocketTimeoutException: connect timed out at java.net.PlainSocketImpl.socketConnect(Native Method) ~[?:1.8.0_312] at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350) ~[?:1.8.0_312] at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206) ~[?:1.8.0_312] at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188) ~[?:1.8.0_312] at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) ~[?:1.8.0_312] at java.net.Socket.connect(Socket.java:607) ~[?:1.8.0_312] at org.postgresql.core.PGStream.<init>(PGStream.java:70) ~[postgresql-42.2.5.jar:42.2.5] at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:91) ~[postgresql-42.2.5.jar:42.2.5] at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:192) ~[postgresql-42.2.5.jar:42.2.5]