Uploaded image for project: 'Nuxeo Studio'
  1. Nuxeo Studio
  2. NXS-6719

Socket timeout when writing stats entry

    Details

    • Type: Bug
    • Status: Acknowledged
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: 2022.4.0
    • Component/s: Analytics / Stats

      Description

      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] 

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:

                PagerDuty

                Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.