Teradata login timeout

Connectivity

Teradata login timeout

Hi there,

I try to connect to Teradata via JDBC connection pool (Apache Commons BasicDataSource) using following jdbc connection string

jdbc:teradata://teradataserverip/LOG=INFO,TYPE=FASTEXPORT,ENCRYPTDATA=ON

BasicDataSource cannot set login timeout. And according to my understanding, if login timeout is not set then by default teradata won't timeout login. Any suggestion why following error would happen?

2016-02-11.09:17:08.829 TERAJDBC4 TIMING [PollingCluster-akka.actor.default-dispatcher-5] com.teradata.jdbc.jdk6.JDK6_SQL_Connection@29d627a4 Login time remaining is 349 ms
2016-02-11.09:17:08.829 TERAJDBC4 TIMING [PollingCluster-akka.actor.default-dispatcher-5] com.teradata.jdbc.jdk6.JDK6_SQL_Connection@29d627a4 Hostname lookup for 10.15.9.10 took 0 ms and found 1 address(es)
2016-02-11.09:17:08.830 TERAJDBC4 TIMING [PollingCluster-akka.actor.default-dispatcher-5] com.teradata.jdbc.jdk6.JDK6_SQL_Connection@29d627a4 Login time remaining is 348 ms
2016-02-11.09:17:08.830 TERAJDBC4 TIMING [PollingCluster-akka.actor.default-dispatcher-5] com.teradata.jdbc.jdk6.JDK6_SQL_Connection@29d627a4 Login time remaining is 348 ms
2016-02-11.09:17:08.831 TERAJDBC4 TIMING [PollingCluster-akka.actor.default-dispatcher-5] com.teradata.jdbc.jdk6.JDK6_SQL_Connection@29d627a4 Attempting connection 1 to /10.15.9.10:1025
2016-02-11.09:17:08.938 TERAJDBC4 TIMING [PollingCluster-akka.actor.default-dispatcher-5] com.teradata.jdbc.jdk6.JDK6_SQL_Connection@29d627a4 Connection attempt to /10.15.9.10:1025 with timeout 348 ms took 41 ms and succeeded, waiting for thread took 0 ms
2016-02-11.09:17:08.939 TERAJDBC4 TIMING [PollingCluster-akka.actor.default-dispatcher-5] com.teradata.jdbc.jdk6.JDK6_SQL_Connection@29d627a4 Wrote Config request message, 106 bytes, time: 0 ms
2016-02-11.09:17:08.939 TERAJDBC4 TIMING [PollingCluster-akka.actor.default-dispatcher-5] com.teradata.jdbc.jdk6.JDK6_SQL_Connection@29d627a4 Login time remaining is 239 ms
2016-02-11.09:17:08.970 TERAJDBC4 TIMING [PollingCluster-akka.actor.default-dispatcher-5] com.teradata.jdbc.jdk6.JDK6_SQL_Connection@29d627a4 Read Config response message 1, 1046 bytes, time: 30 ms
2016-02-11.09:17:09.011 TERAJDBC4 TIMING [PollingCluster-akka.actor.default-dispatcher-5] com.teradata.jdbc.jdk6.JDK6_SQL_Connection@29d627a4 TdgssManager initialization took 0 ms, TdgssConfigApi initialization took 0 ms
2016-02-11.09:17:09.031 TERAJDBC4 INFO [PollingCluster-akka.actor.default-dispatcher-5] com.teradata.jdbc.jdk6.JDK6_SQL_Connection@29d627a4 tdgss version: 14.10.0.1
2016-02-11.09:17:09.060 TERAJDBC4 TIMING [PollingCluster-akka.actor.default-dispatcher-5] com.teradata.jdbc.jdk6.JDK6_SQL_Connection@29d627a4 TdgssContext.initSecContext took 26 ms
2016-02-11.09:17:09.060 TERAJDBC4 TIMING [PollingCluster-akka.actor.default-dispatcher-5] com.teradata.jdbc.jdk6.JDK6_SQL_Connection@29d627a4 Wrote Assign request message, 238 bytes, time: 0 ms
2016-02-11.09:17:09.060 TERAJDBC4 TIMING [PollingCluster-akka.actor.default-dispatcher-5] com.teradata.jdbc.jdk6.JDK6_SQL_Connection@29d627a4 Login time remaining is 118 ms
2016-02-11.09:17:09.098 TERAJDBC4 TIMING [PollingCluster-akka.actor.default-dispatcher-5] com.teradata.jdbc.jdk6.JDK6_SQL_Connection@29d627a4 Read Assign response message 1, 1110 bytes, time: 38 ms
2016-02-11.09:17:09.148 TERAJDBC4 TIMING [PollingCluster-akka.actor.default-dispatcher-5] com.teradata.jdbc.jdk6.JDK6_SQL_Connection@29d627a4 TdgssContext.initSecContext took 49 ms
2016-02-11.09:17:09.148 TERAJDBC4 TIMING [PollingCluster-akka.actor.default-dispatcher-5] com.teradata.jdbc.jdk6.JDK6_SQL_Connection@29d627a4 Wrote SSO request message, 332 bytes, time: 0 ms
2016-02-11.09:17:09.148 TERAJDBC4 TIMING [PollingCluster-akka.actor.default-dispatcher-5] com.teradata.jdbc.jdk6.JDK6_SQL_Connection@29d627a4 Login time remaining is 30 ms
2016-02-11.09:17:09.179 TERAJDBC4 TIMING [PollingCluster-akka.actor.default-dispatcher-5] com.teradata.jdbc.jdk6.JDK6_SQL_Connection@29d627a4 Read SSO request message 1, 0 bytes, time: 31 ms
2016-02-11.09:17:09.179 TERAJDBC4 INFO [PollingCluster-akka.actor.default-dispatcher-5] com.teradata.jdbc.jdk6.JDK6_SQL_Connection@29d627a4 Read message 1, 0 bytes, timed out: java.net.SocketTimeoutException: Read timed out

2016-02-11.09:17:09.186 TERAJDBC4 ERROR [PollingCluster-akka.actor.default-dispatcher-5] com.teradata.jdbc.jdk6.JDK6_SQL_Connection@29d627a4 Packet receive Thu Feb 11 09:17:09 EST 2016 socket orig=10.15.9.10 local=/10.94.148.229:50569 remote=/10.15.9.10:1025 keepalive=false nodelay=false receive=65156 send=65156 linger=10 traffic=0 concurrent=3 contimeout=10000 conwait=1000 connecttime=41 connecttotaltime=109 connectattempts=1 connectfailures=0 reconnectattempts=0 recoverable=false redrive=false failurecache={} cid=1c01f855 sess=272801 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:170) at java.net.SocketInputStream.read(SocketInputStream.java:141) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.read(TDNetworkIOIF.java:697) at com.teradata.jdbc.jdbc_4.io.TDPacketStream.readStream(TDPacketStream.java:773) at com.teradata.jdbc.jdbc.GenericLogonController.run(GenericLogonController.java:486) at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.java:205) at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.<init>(JDK6_SQL_Connection.java:35) at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructSQLConnection(JDK6ConnectionFactory.java:25) at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:179) at com.teradata.jdbc.jdbc.ManagerConnectionBase.<init>(ManagerConnectionBase.java:47) at com.teradata.jdbc.jdbc.fastexport.FastExportManagerConnection.<init>(FastExportManagerConnection.java:61) at com.teradata.jdbc.jdk6.JDK6_FastExportManager_Connection.<init>(JDK6_FastExportManager_Connection.java:28) at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructFastExportManagerConnection(JDK6ConnectionFactory.java:43) at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:210) at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:169) at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:232) at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:158) at org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:39) at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:205) at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2162) at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2148) at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:1903) at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1413) at services.connector.JDBCConnectionPool$class.getConnection(JDBCConnectionPool.scala:22) at services.connector.TeradataConnectionPool$.getConnection(TeradataConnectionPool.scala:12) at services.connector.TeradataPollingDBConnector$.<init>(TeradataPollingDBConnector.scala:21) at services.connector.TeradataPollingDBConnector$.<clinit>(TeradataPollingDBConnector.scala) at services.connector.AkkaPollingFactory$.getPollingConnector(AkkaPollingFactory.scala:39) at services.connector.AkkaPollingUtility$.getLargestTimeByTablename(AkkaPollingUtility.scala:145) at services.connector.AkkaPollingUtility$.getSqlParamList(AkkaPollingUtility.scala:52) at services.akka.SourceTablePoller$$anonfun$receive$1.applyOrElse(SourceTablePoller.scala:32) at akka.actor.Actor$class.aroundReceive(Actor.scala:467) at services.akka.SourceTablePoller.aroundReceive(SourceTablePoller.scala:16) at akka.actor.ActorCell.receiveMessage(ActorCell.scala:516) at akka.actor.ActorCell.invoke(ActorCell.scala:487) at akka.dispatch.Mailbox.processMailbox(Mailbox.scala:238) at akka.dispatch.Mailbox.run(Mailbox.scala:220) at akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(AbstractDispatcher.scala:397) at scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260) at scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339) at scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979) at scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107)

Exception type: class java.sql.SQLException
Exception message: Cannot create PoolableConnectionFactory ([Teradata JDBC Driver] [TeraJDBC 15.00.00.20] [Error 1277] [SQLState 08S01] Login timeout for Packet receive Thu Feb 11 09:17:09 EST 2016 socket orig=10.15.9.10 local=/10.94.148.229:50569 remote=/10.15.9.10:1025 keepalive=false nodelay=false receive=65156 send=65156 linger=10 traffic=0 concurrent=3 contimeout=10000 conwait=1000 connecttime=41 connecttotaltime=109 connectattempts=1 connectfailures=0 reconnectattempts=0 recoverable=false redrive=false failurecache={} cid=1c01f855 sess=272801 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:170) at java.net.SocketInputStream.read(SocketInputStream.java:141) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.read(TDNetworkIOIF.java:697) at com.teradata.jdbc.jdbc_4.io.TDPacketStream.readStream(TDPacketStream.java:773) at com.teradata.jdbc.jdbc.GenericLogonController.run(GenericLogonController.java:486) at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.java:205) at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.<init>(JDK6_SQL_Connection.java:35) at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructSQLConnection(JDK6ConnectionFactory.java:25) at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:179) at com.teradata.jdbc.jdbc.ManagerConnectionBase.<init>(ManagerConnectionBase.java:47) at com.teradata.jdbc.jdbc.fastexport.FastExportManagerConnection.<init>(FastExportManagerConnection.java:61) at com.teradata.jdbc.jdk6.JDK6_FastExportManager_Connection.<init>(JDK6_FastExportManager_Connection.java:28) at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructFastExportManagerConnection(JDK6ConnectionFactory.java:43) at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:210) at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:169) at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:232) at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:158) at org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:39) at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:205) at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2162) at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2148) at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:1903) at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1413) at services.connector.JDBCConnectionPool$class.getConnection(JDBCConnectionPool.scala:22) at services.connector.TeradataConnectionPool$.getConnection(TeradataConnectionPool.scala:12) at services.connector.TeradataPollingDBConnector$.<init>(TeradataPollingDBConnector.scala:21) at services.connector.TeradataPollingDBConnector$.<clinit>(TeradataPollingDBConnector.scala) at services.connector.AkkaPollingFactory$.getPollingConnector(AkkaPollingFactory.scala:39) at services.connector.AkkaPollingUtility$.getLargestTimeByTablename(AkkaPollingUtility.scala:145) at services.connector.AkkaPollingUtility$.getSqlParamList(AkkaPollingUtility.scala:52) at services.akka.SourceTablePoller$$anonfun$receive$1.applyOrElse(SourceTablePoller.scala:32) at akka.actor.Actor$class.aroundReceive(Actor.scala:467) at services.akka.SourceTablePoller.aroundReceive(SourceTablePoller.scala:16) at akka.actor.ActorCell.receiveMessage(ActorCell.scala:516) at akka.actor.ActorCell.invoke(ActorCell.scala:487) at akka.dispatch.Mailbox.processMailbox(Mailbox.scala:238) at akka.dispatch.Mailbox.run(Mailbox.scala:220) at akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(AbstractDispatcher.scala:397) at scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260) at scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339) at scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979) at scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107) )
java.sql.SQLException: Cannot create PoolableConnectionFactory ([Teradata JDBC Driver] [TeraJDBC 15.00.00.20] [Error 1277] [SQLState 08S01] Login timeout for Packet receive Thu Feb 11 09:17:09 EST 2016 socket orig=10.15.9.10 local=/10.94.148.229:50569 remote=/10.15.9.10:1025 keepalive=false nodelay=false receive=65156 send=65156 linger=10 traffic=0 concurrent=3 contimeout=10000 conwait=1000 connecttime=41 connecttotaltime=109 connectattempts=1 connectfailures=0 reconnectattempts=0 recoverable=false redrive=false failurecache={} cid=1c01f855 sess=272801 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:170) at java.net.SocketInputStream.read(SocketInputStream.java:141) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.read(TDNetworkIOIF.java:697) at com.teradata.jdbc.jdbc_4.io.TDPacketStream.readStream(TDPacketStream.java:773) at com.teradata.jdbc.jdbc.GenericLogonController.run(GenericLogonController.java:486) at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.java:205) at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.<init>(JDK6_SQL_Connection.java:35) at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructSQLConnection(JDK6ConnectionFactory.java:25) at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:179) at com.teradata.jdbc.jdbc.ManagerConnectionBase.<init>(ManagerConnectionBase.java:47) at com.teradata.jdbc.jdbc.fastexport.FastExportManagerConnection.<init>(FastExportManagerConnection.java:61) at com.teradata.jdbc.jdk6.JDK6_FastExportManager_Connection.<init>(JDK6_FastExportManager_Connection.java:28) at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructFastExportManagerConnection(JDK6ConnectionFactory.java:43) at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:210) at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:169) at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:232) at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:158) at org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:39) at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:205) at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2162) at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2148) at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:1903) at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1413) at services.connector.JDBCConnectionPool$class.getConnection(JDBCConnectionPool.scala:22) at services.connector.TeradataConnectionPool$.getConnection(TeradataConnectionPool.scala:12) at services.connector.TeradataPollingDBConnector$.<init>(TeradataPollingDBConnector.scala:21) at services.connector.TeradataPollingDBConnector$.<clinit>(TeradataPollingDBConnector.scala) at services.connector.AkkaPollingFactory$.getPollingConnector(AkkaPollingFactory.scala:39) at services.connector.AkkaPollingUtility$.getLargestTimeByTablename(AkkaPollingUtility.scala:145) at services.connector.AkkaPollingUtility$.getSqlParamList(AkkaPollingUtility.scala:52) at services.akka.SourceTablePoller$$anonfun$receive$1.applyOrElse(SourceTablePoller.scala:32) at akka.actor.Actor$class.aroundReceive(Actor.scala:467) at services.akka.SourceTablePoller.aroundReceive(SourceTablePoller.scala:16) at akka.actor.ActorCell.receiveMessage(ActorCell.scala:516) at akka.actor.ActorCell.invoke(ActorCell.scala:487) at akka.dispatch.Mailbox.processMailbox(Mailbox.scala:238) at akka.dispatch.Mailbox.run(Mailbox.scala:220) at akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(AbstractDispatcher.scala:397) at scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260) at scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339) at scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979) at scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107) )
at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2152)
at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:1903)
at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1413)
at services.connector.JDBCConnectionPool$class.getConnection(JDBCConnectionPool.scala:22)
at services.connector.TeradataConnectionPool$.getConnection(TeradataConnectionPool.scala:12)
at services.connector.TeradataPollingDBConnector$.<init>(TeradataPollingDBConnector.scala:21)
at services.connector.TeradataPollingDBConnector$.<clinit>(TeradataPollingDBConnector.scala)
at services.connector.AkkaPollingFactory$.getPollingConnector(AkkaPollingFactory.scala:39)
at services.connector.AkkaPollingUtility$.getLargestTimeByTablename(AkkaPollingUtility.scala:145)
at services.connector.AkkaPollingUtility$.getSqlParamList(AkkaPollingUtility.scala:52)
at services.akka.SourceTablePoller$$anonfun$receive$1.applyOrElse(SourceTablePoller.scala:32)
at akka.actor.Actor$class.aroundReceive(Actor.scala:467)
at services.akka.SourceTablePoller.aroundReceive(SourceTablePoller.scala:16)
at akka.actor.ActorCell.receiveMessage(ActorCell.scala:516)
at akka.actor.ActorCell.invoke(ActorCell.scala:487)
at akka.dispatch.Mailbox.processMailbox(Mailbox.scala:238)
at akka.dispatch.Mailbox.run(Mailbox.scala:220)
at akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(AbstractDispatcher.scala:397)
at scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260)
at scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339)
at scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979)
at scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107)
Caused by: java.sql.SQLException: [Teradata JDBC Driver] [TeraJDBC 15.00.00.20] [Error 1277] [SQLState 08S01] Login timeout for Packet receive Thu Feb 11 09:17:09 EST 2016 socket orig=10.15.9.10 local=/10.94.148.229:50569 remote=/10.15.9.10:1025 keepalive=false nodelay=false receive=65156 send=65156 linger=10 traffic=0 concurrent=3 contimeout=10000 conwait=1000 connecttime=41 connecttotaltime=109 connectattempts=1 connectfailures=0 reconnectattempts=0 recoverable=false redrive=false failurecache={} cid=1c01f855 sess=272801 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:170) at java.net.SocketInputStream.read(SocketInputStream.java:141) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.read(TDNetworkIOIF.java:697) at com.teradata.jdbc.jdbc_4.io.TDPacketStream.readStream(TDPacketStream.java:773) at com.teradata.jdbc.jdbc.GenericLogonController.run(GenericLogonController.java:486) at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.java:205) at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.<init>(JDK6_SQL_Connection.java:35) at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructSQLConnection(JDK6ConnectionFactory.java:25) at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:179) at com.teradata.jdbc.jdbc.ManagerConnectionBase.<init>(ManagerConnectionBase.java:47) at com.teradata.jdbc.jdbc.fastexport.FastExportManagerConnection.<init>(FastExportManagerConnection.java:61) at com.teradata.jdbc.jdk6.JDK6_FastExportManager_Connection.<init>(JDK6_FastExportManager_Connection.java:28) at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructFastExportManagerConnection(JDK6ConnectionFactory.java:43) at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:210) at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:169) at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:232) at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:158) at org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:39) at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:205) at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2162) at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2148) at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:1903) at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1413) at services.connector.JDBCConnectionPool$class.getConnection(JDBCConnectionPool.scala:22) at services.connector.TeradataConnectionPool$.getConnection(TeradataConnectionPool.scala:12) at services.connector.TeradataPollingDBConnector$.<init>(TeradataPollingDBConnector.scala:21) at services.connector.TeradataPollingDBConnector$.<clinit>(TeradataPollingDBConnector.scala) at services.connector.AkkaPollingFactory$.getPollingConnector(AkkaPollingFactory.scala:39) at services.connector.AkkaPollingUtility$.getLargestTimeByTablename(AkkaPollingUtility.scala:145) at services.connector.AkkaPollingUtility$.getSqlParamList(AkkaPollingUtility.scala:52) at services.akka.SourceTablePoller$$anonfun$receive$1.applyOrElse(SourceTablePoller.scala:32) at akka.actor.Actor$class.aroundReceive(Actor.scala:467) at services.akka.SourceTablePoller.aroundReceive(SourceTablePoller.scala:16) at akka.actor.ActorCell.receiveMessage(ActorCell.scala:516) at akka.actor.ActorCell.invoke(ActorCell.scala:487) at akka.dispatch.Mailbox.processMailbox(Mailbox.scala:238) at akka.dispatch.Mailbox.run(Mailbox.scala:220) at akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(AbstractDispatcher.scala:397) at scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260) at scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339) at scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979) at scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107)
at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:94)
at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:69)
at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeIoJDBCException(ErrorFactory.java:207)
at com.teradata.jdbc.jdbc_4.util.ErrorAnalyzer.analyzeIoError(ErrorAnalyzer.java:59)
at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.read(TDNetworkIOIF.java:889)
at com.teradata.jdbc.jdbc_4.io.TDPacketStream.readStream(TDPacketStream.java:773)
at com.teradata.jdbc.jdbc.GenericLogonController.run(GenericLogonController.java:486)
at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.java:205)
at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.<init>(JDK6_SQL_Connection.java:35)
at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructSQLConnection(JDK6ConnectionFactory.java:25)
at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:179)
at com.teradata.jdbc.jdbc.ManagerConnectionBase.<init>(ManagerConnectionBase.java:47)
at com.teradata.jdbc.jdbc.fastexport.FastExportManagerConnection.<init>(FastExportManagerConnection.java:61)
at com.teradata.jdbc.jdk6.JDK6_FastExportManager_Connection.<init>(JDK6_FastExportManager_Connection.java:28)
at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructFastExportManagerConnection(JDK6ConnectionFactory.java:43)
at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:210)
at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:169)
at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:232)
at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:158)
at org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:39)
at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:205)
at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2162)
at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2148)
... 21 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:170)
at java.net.SocketInputStream.read(SocketInputStream.java:141)
at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.read(TDNetworkIOIF.java:697)
... 39 more
Exception stack: ()
2 REPLIES
Teradata Employee

Re: Teradata login timeout

By default, there is no login timeout for the Teradata JDBC Driver.

That exception occurs when you specify a non-zero login timeout using the either the DriverManager.setLoginTimeout method or the DataSource.setLoginTimeout method.

Apache dbcp2 uses DriverManager to obtain a JDBC connection, which means that the Teradata JDBC Driver will use the login timeout specified via the DriverManager.setLoginTimeout method.

You are correct that the Apache dbcp2 documentation says that the method org.apache.commons.dbcp2.BasicDataSource.setLoginTimeout is not supported.

But the DataSource.setLoginTimeout method is not applicable in your situation.

You got that exception because some code running in your JVM set a nonzero timeout via the DriverManager.setLoginTimeout method.

Re: Teradata login timeout

Thank you for the reply. I initialize the Teradata connection pool in an akka actor, it probably has some underlying code that touch DriverManager.setLoginTimeout. Although I cannot verify it, after I move the initialization code out of the akka actor, the timeout problem is gone now.