Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-6105

TEIID20020 Error establishing socket to host and port: <ip>:<port>. Reason: Read timed out

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Blocker
    • None
    • 15.0.1, 16.0, 15.0.2
    • JDBC Driver
    • None
    • Hide

      Just start the instances and after a while they start not responding.

      Show
      Just start the instances and after a while they start not responding.

    Description

      Hello, friends.

      I've been struggling with the error below, since we wen to production a have increased the trafic on TEIID.

      Our Wildfly based deployment has a "master" node responsible for Materializing(external) data from 25 remote sources (Multisource config) also using TEIID and using TEIID JDBC connection to them, and 2 worker nodes with external load balancing (HAProxy TCP mode) that provide data from the Materialized  views and direct remote access to others.

      All 25 TEIID JDBC remote datasources use XA, along with external materialization in PostgresDB.

      I'm able to connect to the web console anc check the current number of connections when the errors start(

      How can we tackle this sort of error. Is this problem related to the number of threads or processors( 4 vCPUs machines for each node now) ?

      (IJ031084: Unable to create connection): javax.resource.ResourceException: IJ031084: Unable to create connection
              at org.jboss.jca.adapters.jdbc.xa.XAManagedConnectionFactory.getXAManagedConnection(XAManagedConnectionFactory.java:531)
              at org.jboss.jca.adapters.jdbc.xa.XAManagedConnectionFactory$1$1.run(XAManagedConnectionFactory.java:417)
              at org.jboss.jca.adapters.jdbc.xa.XAManagedConnectionFactory$1$1.run(XAManagedConnectionFactory.java:414)
              at java.security.AccessController.doPrivileged(Native Method)
              at javax.security.auth.Subject.doAs(Subject.java:422)
              at org.jboss.jca.adapters.jdbc.xa.XAManagedConnectionFactory$1.run(XAManagedConnectionFactory.java:413)
              at org.jboss.jca.adapters.jdbc.xa.XAManagedConnectionFactory$1.run(XAManagedConnectionFactory.java:410)
              at java.security.AccessController.doPrivileged(Native Method)
              at org.jboss.jca.adapters.jdbc.xa.XAManagedConnectionFactory.createManagedConnection(XAManagedConnectionFactory.java:409)
              at org.jboss.jca.core.tx.jbossts.XAResourceRecoveryImpl.open(XAResourceRecoveryImpl.java:355)
              at org.jboss.jca.core.tx.jbossts.XAResourceRecoveryImpl.getXAResources(XAResourceRecoveryImpl.java:218)
              at com.arjuna.ats.internal.jbossatx.jta.XAResourceRecoveryHelperWrapper.getXAResources(XAResourceRecoveryHelperWrapper.java:51)
              at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.resourceInitiatedRecoveryForRecoveryHelpers(XARecoveryModule.java:627)
              at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.periodicWorkFirstPass(XARecoveryModule.java:235)
              at com.arjuna.ats.internal.jta.recovery.arjunacore.XARecoveryModule.periodicWorkFirstPass(XARecoveryModule.java:182)
              at com.arjuna.ats.internal.arjuna.recovery.PeriodicRecovery.doWorkInternal(PeriodicRecovery.java:770)
              at com.arjuna.ats.internal.arjuna.recovery.PeriodicRecovery.run(PeriodicRecovery.java:382)
      Caused by: org.teiid.jdbc.TeiidSQLException: TEIID20020 Error establishing socket to host and port: <server>:<port>. Reason: Read timed out
              at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:131)
              at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:67)
              at org.teiid.jdbc.SocketProfile.connect(SocketProfile.java:62)
              at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:107)
              at org.teiid.jdbc.TeiidDataSource.getConnection(TeiidDataSource.java:272)
              at org.teiid.jdbc.TeiidDataSource.getXAConnection(TeiidDataSource.java:569)
              at org.jboss.jca.adapters.jdbc.xa.XAManagedConnectionFactory.getXAManagedConnection(XAManagedConnectionFactory.java:515)
              ... 16 more
      Caused by: org.teiid.net.socket.SingleInstanceCommunicationException: TEIID20020 Error establishing socket to host and port: <server>:<port>. Reason: Read timed out
              at org.teiid.net.socket.SocketServerConnection.selectServerInstance(SocketServerConnection.java:134)
              at org.teiid.net.socket.SocketServerConnection.<init>(SocketServerConnection.java:88)
              at org.teiid.net.socket.SocketServerConnectionFactory.getConnection(SocketServerConnectionFactory.java:111)
              at org.teiid.jdbc.SocketProfile.connect(SocketProfile.java:60)
              ... 20 more
      Caused by: java.net.SocketTimeoutException: Read timed out
              at java.net.SocketInputStream.socketRead0(Native Method)
              at java.net.SocketInputStream.socketRead(SocketInputStream.java:116)
              at java.net.SocketInputStream.read(SocketInputStream.java:171)
              at java.net.SocketInputStream.read(SocketInputStream.java:141)
              at java.io.BufferedInputStream.fill(BufferedInputStream.java:246)
              at java.io.BufferedInputStream.read(BufferedInputStream.java:265)
              at java.io.DataInputStream.readInt(DataInputStream.java:387)
              at org.teiid.netty.handler.codec.serialization.ObjectDecoderInputStream.readObjectOverride(ObjectDecoderInputStream.java:92)
              at java.io.ObjectInputStream.readObject(ObjectInputStream.java:493)
              at java.io.ObjectInputStream.readObject(ObjectInputStream.java:460)
              at org.teiid.net.socket.OioOjbectChannelFactory$OioObjectChannel.read(OioOjbectChannelFactory.java:113)
              at org.teiid.net.socket.SocketServerInstanceImpl.doHandshake(SocketServerInstanceImpl.java:124)
              at org.teiid.net.socket.SocketServerInstanceImpl.connect(SocketServerInstanceImpl.java:92)
              at org.teiid.net.socket.SocketServerConnectionFactory.getServerInstance(SocketServerConnectionFactory.java:91)
              at org.teiid.net.socket.SocketServerConnection.selectServerInstance(SocketServerConnection.java:122)
              ... 23 more

      Attachments

        Activity

          People

            Unassigned Unassigned
            rafagsam Rafael Sampaio (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: