org.teiid.jdbc.TeiidSQLException: Error establishing socket to host and port: vdb.engineering.redhat.com:31000. Reason: java.lang.RuntimeException: Unexpected error: java.security.InvalidAlgorithmParameterException: the trustAnchors parameter must be non-empty

JBoss Issue Tracker | ying ma | 3 years ago
  1. 0

    [TEIID-2593] often report: the trustAnchors parameter must be non-empty - JBoss Issue Tracker

    jboss.org | 11 months ago
    org.teiid.jdbc.TeiidSQLException: Error establishing socket to host and port: vdb.engineering.redhat.com:31000. Reason: java.lang.RuntimeException: Unexpected error: java.security.InvalidAlgorithmParameterException: the trustAnchors parameter must be non-empty
  2. 0

    This ques appear when we upgrade JBoss from 6.0 to 6.1, the teiid always could not create connection, as below: 23:49:41,639 SEVERE [org.teiid.jdbc] (Timer-2) Could not create connection: org.teiid.jdbc.TeiidSQLException: Error establishing socket to host and port: vdb.engineering.redhat.com:31000. Reason: java.lang.RuntimeException: Unexpected error: java.security.InvalidAlgorithmParameterException: the trustAnchors parameter must be non-empty at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:113) [teiid-client-7.7.0.Final.jar:7.7.0.Final] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:70) [teiid-client-7.7.0.Final.jar:7.7.0.Final] at org.teiid.jdbc.SocketProfile.connect(SocketProfile.java:56) [teiid-client-7.7.0.Final.jar:7.7.0.Final] at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:107) [teiid-client-7.7.0.Final.jar:7.7.0.Final] at java.sql.DriverManager.getConnection(DriverManager.java:571) [rt.jar:1.7.0_25] at java.sql.DriverManager.getConnection(DriverManager.java:215) [rt.jar:1.7.0_25] at com.rehat.tools.vault.service.impl.BugzillaProductUpdate.productVersionUpdateTask(BugzillaProductUpdate.java:42) [vault-service-1.1.1.jar:] at com.redhat.tools.vault.listener.UpdateTimer.run(UpdateTimer.java:31) [classes:] at java.util.TimerThread.mainLoop(Timer.java:555) [rt.jar:1.7.0_25] at java.util.TimerThread.run(Timer.java:505) [rt.jar:1.7.0_25] Caused by: [SingleInstanceCommunicationException]Error establishing socket to host and port: vdb.engineering.redhat.com:31000. Reason: java.lang.RuntimeException: Unexpected error: java.security.InvalidAlgorithmParameterException: the trustAnchors parameter must be non-empty 1 [SSLException]java.lang.RuntimeException: Unexpected error: java.security.InvalidAlgorithmParameterException: the trustAnchors parameter must be non-empty 2 [RuntimeException]Unexpected error: java.security.InvalidAlgorithmParameterException: the trustAnchors parameter must be non-empty 3 [InvalidAlgorithmParameterException]the trustAnchors parameter must be non-empty at org.teiid.net.socket.SocketServerConnection.selectServerInstance(SocketServerConnection.java:161) [teiid-client-7.7.0.Final.jar:7.7.0.Final] at org.teiid.net.socket.SocketServerConnection.<init>(SocketServerConnection.java:95) [teiid-client-7.7.0.Final.jar:7.7.0.Final] at org.teiid.net.socket.SocketServerConnectionFactory.getConnection(SocketServerConnectionFactory.java:320) [teiid-client-7.7.0.Final.jar:7.7.0.Final] at org.teiid.jdbc.SocketProfile.connect(SocketProfile.java:54) [teiid-client-7.7.0.Final.jar:7.7.0.Final] ... 7 more Caused by: javax.net.ssl.SSLException: java.lang.RuntimeException: Unexpected error: java.security.InvalidAlgorithmParameterException: the trustAnchors parameter must be non-empty at sun.security.ssl.Alerts.getSSLException(Alerts.java:208) [jsse.jar:1.7.0_25] at sun.security.ssl.SSLSocketImpl.fatal(SSLSocketImpl.java:1886) [jsse.jar:1.7.0_25] at sun.security.ssl.SSLSocketImpl.fatal(SSLSocketImpl.java:1844) [jsse.jar:1.7.0_25] at sun.security.ssl.SSLSocketImpl.handleException(SSLSocketImpl.java:1827) [jsse.jar:1.7.0_25] at sun.security.ssl.SSLSocketImpl.handleException(SSLSocketImpl.java:1753) [jsse.jar:1.7.0_25] at sun.security.ssl.AppInputStream.read(AppInputStream.java:113) [jsse.jar:1.7.0_25] at java.io.BufferedInputStream.fill(BufferedInputStream.java:235) [rt.jar:1.7.0_25] at java.io.BufferedInputStream.read1(BufferedInputStream.java:275) [rt.jar:1.7.0_25] at java.io.BufferedInputStream.read(BufferedInputStream.java:334) [rt.jar:1.7.0_25] at java.io.DataInputStream.read(DataInputStream.java:149) [rt.jar:1.7.0_25] at org.teiid.netty.handler.codec.serialization.ObjectDecoderInputStream.fillBuffer(ObjectDecoderInputStream.java:164) [teiid-client-7.7.0.Final.jar:7.7.0.Final] at org.teiid.netty.handler.codec.serialization.ObjectDecoderInputStream.findLength(ObjectDecoderInputStream.java:147) [teiid-client-7.7.0.Final.jar:7.7.0.Final] at org.teiid.netty.handler.codec.serialization.ObjectDecoderInputStream.readObjectOverride(ObjectDecoderInputStream.java:81) [teiid-client-7.7.0.Final.jar:7.7.0.Final] at java.io.ObjectInputStream.readObject(ObjectInputStream.java:364) [rt.jar:1.7.0_25] at org.teiid.net.socket.OioOjbectChannelFactory$OioObjectChannel.read(OioOjbectChannelFactory.java:114) [teiid-client-7.7.0.Final.jar:7.7.0.Final] at org.teiid.net.socket.SocketServerInstanceImpl.doHandshake(SocketServerInstanceImpl.java:113) [teiid-client-7.7.0.Final.jar:7.7.0.Final] at org.teiid.net.socket.SocketServerInstanceImpl.connect(SocketServerInstanceImpl.java:94) [teiid-client-7.7.0.Final.jar:7.7.0.Final] at org.teiid.net.socket.SocketServerConnectionFactory.getServerInstance(SocketServerConnectionFactory.java:279) [teiid-client-7.7.0.Final.jar:7.7.0.Final] at org.teiid.net.socket.SocketServerConnection.connect(SocketServerConnection.java:199) [teiid-client-7.7.0.Final.jar:7.7.0.Final] at org.teiid.net.socket.SocketServerConnection.selectServerInstance(SocketServerConnection.java:125) [teiid-client-7.7.0.Final.jar:7.7.0.Final] ... 10 more Caused by: java.lang.RuntimeException: Unexpected error: java.security.InvalidAlgorithmParameterException: the trustAnchors parameter must be non-empty at sun.security.validator.PKIXValidator.<init>(PKIXValidator.java:90) [rt.jar:1.7.0_25] at sun.security.validator.Validator.getInstance(Validator.java:179) [rt.jar:1.7.0_25] at sun.security.ssl.X509TrustManagerImpl.getValidator(X509TrustManagerImpl.java:314) [jsse.jar:1.7.0_25] at sun.security.ssl.X509TrustManagerImpl.checkTrustedInit(X509TrustManagerImpl.java:173) [jsse.jar:1.7.0_25] at sun.security.ssl.X509TrustManagerImpl.checkTrusted(X509TrustManagerImpl.java:186) [jsse.jar:1.7.0_25] at sun.security.ssl.X509TrustManagerImpl.checkServerTrusted(X509TrustManagerImpl.java:126) [jsse.jar:1.7.0_25] at sun.security.ssl.ClientHandshaker.serverCertificate(ClientHandshaker.java:1323) [jsse.jar:1.7.0_25] at sun.security.ssl.ClientHandshaker.processMessage(ClientHandshaker.java:153) [jsse.jar:1.7.0_25] at sun.security.ssl.Handshaker.processLoop(Handshaker.java:868) [jsse.jar:1.7.0_25] at sun.security.ssl.Handshaker.process_record(Handshaker.java:804) [jsse.jar:1.7.0_25] at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:1016) [jsse.jar:1.7.0_25] at sun.security.ssl.SSLSocketImpl.performInitialHandshake(SSLSocketImpl.java:1312) [jsse.jar:1.7.0_25] at sun.security.ssl.SSLSocketImpl.readDataRecord(SSLSocketImpl.java:882) [jsse.jar:1.7.0_25] at sun.security.ssl.AppInputStream.read(AppInputStream.java:102) [jsse.jar:1.7.0_25] ... 24 more Caused by: java.security.InvalidAlgorithmParameterException: the trustAnchors parameter must be non-empty at java.security.cert.PKIXParameters.setTrustAnchors(PKIXParameters.java:200) [rt.jar:1.7.0_25] at java.security.cert.PKIXParameters.<init>(PKIXParameters.java:120) [rt.jar:1.7.0_25] at java.security.cert.PKIXBuilderParameters.<init>(PKIXBuilderParameters.java:104) [rt.jar:1.7.0_25] at sun.security.validator.PKIXValidator.<init>(PKIXValidator.java:88) [rt.jar:1.7.0_25] ... 37 more According to the log, it may be caused by the cacerts in jre/lib/security is NULL, however, we've create the symlink to ../../../../../../../etc/pki/java/cacerts. I'm so confused about it, before jboss upgrade, the teiid is normal. So could you follow the issue? have any reason will cause the error?

    JBoss Issue Tracker | 3 years ago | ying ma
    org.teiid.jdbc.TeiidSQLException: Error establishing socket to host and port: vdb.engineering.redhat.com:31000. Reason: java.lang.RuntimeException: Unexpected error: java.security.InvalidAlgorithmParameterException: the trustAnchors parameter must be non-empty
  3. 0

    We wrote a Teiid procedure, one of the input parameters is List<List<Double>>. We found if we give too many data in there, e.g. 200x375, Teiid will throw out exception before go to my translator: org.teiid.jdbc.TeiidSQLException: Error Code:TEIID20013 Message:Error Code:TEIID20013 Message:java.net.SocketException: Connection reset by peer: socket write error at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:113) at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:70) at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:631) at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:559) at org.teiid.jdbc.PreparedStatementImpl.execute(PreparedStatementImpl.java:201) at MyTest.testHorizon3DWrite(MyTest.java:102) at MyTest.main(MyTest.java:27) Caused by: [TeiidComponentException] TEIID20013: Error Code:TEIID20013 Message:Error Code:TEIID20013 Message:java.net.SocketException: Connection reset by peer: socket write error 1 [SingleInstanceCommunicationException] TEIID20013: Error Code:TEIID20013 Message:java.net.SocketException: Connection reset by peer: socket write error 2 [ExecutionException]java.net.SocketException: Connection reset by peer: socket write error 3 [SocketException]Connection reset by peer: socket write error at org.teiid.client.util.ExceptionUtil.convertException(ExceptionUtil.java:61) at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler.invoke(SocketServerInstanceImpl.java:374) at org.teiid.net.socket.SocketServerConnection$1.invoke(SocketServerConnection.java:243) at $Proxy7.executeRequest(Unknown Source) at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:629) ... 4 more Caused by: [SingleInstanceCommunicationException] TEIID20013: Error Code:TEIID20013 Message:java.net.SocketException: Connection reset by peer: socket write error 1 [ExecutionException]java.net.SocketException: Connection reset by peer: socket write error 2 [SocketException]Connection reset by peer: socket write error at org.teiid.net.socket.SocketServerInstanceImpl.send(SocketServerInstanceImpl.java:177) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:102) at $Proxy1.send(Unknown Source) at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler.invoke(SocketServerInstanceImpl.java:362) ... 7 more Caused by: java.util.concurrent.ExecutionException: java.net.SocketException: Connection reset by peer: socket write error at org.teiid.client.util.ResultsFuture.convertResult(ResultsFuture.java:100) at org.teiid.client.util.ResultsFuture.get(ResultsFuture.java:95) at org.teiid.net.socket.SocketServerInstanceImpl.send(SocketServerInstanceImpl.java:174) ... 14 more Caused by: java.net.SocketException: Connection reset by peer: socket write error at java.net.SocketOutputStream.socketWrite0(Native Method) at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92) at java.net.SocketOutputStream.write(SocketOutputStream.java:136) at java.io.BufferedOutputStream.write(BufferedOutputStream.java:105) at java.io.DataOutputStream.write(DataOutputStream.java:90) at org.teiid.netty.handler.codec.serialization.ObjectEncoderOutputStream.writeObjectOverride(ObjectEncoderOutputStream.java:65) at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:326) at org.teiid.net.socket.OioOjbectChannelFactory$OioObjectChannel.write(OioOjbectChannelFactory.java:130) at org.teiid.net.socket.SocketServerInstanceImpl.send(SocketServerInstanceImpl.java:173) ... 14 more But if we give less number of data in that param, e.g. 100x375, it works fine. Thanks.

    JBoss Issue Tracker | 3 years ago | Jane Li
    org.teiid.jdbc.TeiidSQLException: Error Code:TEIID20013 Message:Error Code:TEIID20013 Message:java.net.SocketException: Connection reset by peer: socket write error
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Select * queries when using Teiid

    GitHub | 3 years ago | martinrezk
    org.teiid.jdbc.TeiidSQLException: Remote org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "tb_books) view20130219 [*]null[*]" at line 1, column 53. Was expecting: <EOF> | "cross" | "except" | "fetch" | "full" | "group" | "having" | "inner" | "intersect" | "join" ... ################################################### ## Debugging information (for the authors) ## ###################################################
  6. 0

    db:: 4.18::StreamCorruptedException kd

    hivmr.com | 7 months ago
    org.teiid.jdbc.TeiidSQLException: data length too big: 87244459 (max: 33554432)

    Root Cause Analysis

    1. org.teiid.jdbc.TeiidSQLException

      Error establishing socket to host and port: vdb.engineering.redhat.com:31000. Reason: java.lang.RuntimeException: Unexpected error: java.security.InvalidAlgorithmParameterException: the trustAnchors parameter must be non-empty

      at org.teiid.jdbc.TeiidSQLException.create()
    2. org.teiid.jdbc
      TeiidDriver.connect
      1. org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:113)[teiid-client-7.7.0.Final.jar:7.7.0.Final]
      2. org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:70)[teiid-client-7.7.0.Final.jar:7.7.0.Final]
      3. org.teiid.jdbc.SocketProfile.connect(SocketProfile.java:56)[teiid-client-7.7.0.Final.jar:7.7.0.Final]
      4. org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:107)[teiid-client-7.7.0.Final.jar:7.7.0.Final]
      4 frames
    3. Java RT
      DriverManager.getConnection
      1. java.sql.DriverManager.getConnection(DriverManager.java:571)[rt.jar:1.7.0_25]
      2. java.sql.DriverManager.getConnection(DriverManager.java:215)[rt.jar:1.7.0_25]
      2 frames
    4. com.rehat.tools
      BugzillaProductUpdate.productVersionUpdateTask
      1. com.rehat.tools.vault.service.impl.BugzillaProductUpdate.productVersionUpdateTask(BugzillaProductUpdate.java:42)[vault-service-1.1.1.jar:]
      1 frame
    5. com.redhat.tools
      UpdateTimer.run
      1. com.redhat.tools.vault.listener.UpdateTimer.run(UpdateTimer.java:31)[classes:]
      1 frame
    6. Java RT
      TimerThread.run
      1. java.util.TimerThread.mainLoop(Timer.java:555)[rt.jar:1.7.0_25]
      2. java.util.TimerThread.run(Timer.java:505)[rt.jar:1.7.0_25]
      2 frames