Socket Error 804

Connectivity
Teradata Employee

Socket Error 804

Does anyone know what would cause, or how to correct a Socket Error?  Below are the details of the error message:

"CAMSPROD","Error Executing Database Query.[Teradata JDBC Driver] [TeraJDBC 13.10.00.18] [Error 804] [SQLState 08S01] Socket communication failure for Packet receive Thu Jun 14 02:50:21 CDT 2012 socket orig=10.139.0.28 local=0.0.0.0/0.0.0.0:4379 remote=/10.139.0.28:1025 keepalive=unavailable nodelay=unavailable receive=unavailable send=unavailable linger=unavailable traffic=unavailable concurrent=3 contimeout=10000 conwait=1000 connecttime=0 connecttotaltime=16 connectattempts=1 connectfailures=0 failurecache={} cid=1031697 sess=231027 java.io.IOException: Incomplete LAN message header: read 0 bytes   at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.read(TDNetworkIOIF.java:663)   at com.teradata.jdbc.jdbc_4.io.TDPacketStream.readStream(TDPacketStream.java:818)   at com.teradata.jdbc.jdbc_4.statemachine.StatementReceiveState.action(StatementReceiveState.java:129)   at com.teradata.jdbc.jdbc_4.statemachine.StatementController.runBody(StatementController.java:120)   at com.teradata.jdbc.jdbc_4.statemachine.StatementController.r...

Thanks!

Paul

14 REPLIES
Enthusiast

Re: Socket Error 804

Is this error repeatble or occurring at random? if occurring at random intervals try to increase the "concurrent" limit from 3 to 10. if you hit this error every single time, try uninstall reinstall the JDBC driver and check if the installation is ok then retry. If you again have the same problem open a ticket with GSC. - Thanks, Sankar

Teradata Employee

Re: Socket Error 804

Unfortunately, the previous poster's advice is not useful.

The "concurrent" setting is not related to this issue. (The "concurrent" setting is only relevant at connect time, is not documented, and is not intended to be changed for normal usage.)

Also, it is unlikely that uninstalling/reinstalling the Teradata JDBC Driver will affect this issue.

Error 804 can occur for different reasons. The exception error message is important for distinguishing the different error conditions.

Typically, Error 804 with the error message "Socket communication failure for Packet receive" means that a network communication failure occurred. This can be due to a variety of reasons, such as:

1. Network problem

2. Teradata Database restart

3. Teradata session was aborted by Teradata Manager, Teradata Viewpoint, or some other administrator process that aborts idle sessions

However, there is a known problem (JDBC DR 155367) with the Teradata JDBC Driver if your application is using setQueryTimeout and receiving a large result set from the Teradata Database (ResultSet containing more than 1MB of data). This problem is planned to be fixed in an upcoming release.

Enthusiast

Re: Socket Error 804

(1) The socket connection is originating and ending at the same IP I don't think that could be a net work issue!!

(2) 'database restart' error most likely reported as an error of 'database restart' not 'socket error'.

(3) Any 'abort session' by user likely be reported as 'session aborted by peer' error..

Thx

Teradata Employee

Re: Socket Error 804

Thanks for the replies.  This is a process being run by a 3rd Party company supporting a Teradata process.  This error has occurred every night that they have tried to run the process.  My impression is that they are moving a large amount of data while doing this.

Thanks!

Paul

Teradata Employee

Re: Socket Error 804

Once again, please discount what "TDDeveloper" said.

The "orig" in the error message refers to the "original" Teradata Database hostname specified by the application; it does not mean "originating".

TDDeveloper -- please refrain from posting incorrect information, or you will be banned from the forums.

Teradata Employee

Re: Socket Error 804

Thanks Tom,

I will pass this info onto to our 3rd Party support team to see if this helps them with this issue.

Paul

N/A

Re: Socket Error 804

Hey Paul,did you get a solution for this yet.I am also experiencing the same issue.any help will be really appreciated.Thanks.

Teradata Employee

Re: Socket Error 804

We saw this error on a customer's site when running a query like "select A.DatabaseName,A.TableName,A.TableKind  FROM DBC.TablesV A  WHERE TableKind = 'T' OR TableKind = 'O'". We suspect it is the size of data returned caused the error, will modify the query to limit the resultset.

Teradata Employee

Re: Socket Error 804

Teradata JDBC Driver 14.00.00.21 has been released and is now available for download here on Developer Exchange.

Teradata JDBC Driver 14.00.00.21 contains the fix for JDBC DR 155367.