OD socket error

Hi,

We are getting the below error in one of our deployments ,it was running fine untill yesterday ,today we got the following message :-

[php]
SQLException occured in TableSchema:Exists()
DBD: Exception Message: [TDS Driver]Read timed out
DBD: Vendor Error Code: 0
DBD: SQL state: S1T00
DBD: *******************************************************
DBD:
DBD: *******STACK TRACE*************
DBD: ERROR:
java.sql.SQLException: [TDS Driver]Read timed out
at com.inet.tds.e.a(Unknown Source)
at com.inet.tds.e.a(Unknown Source)
at com.inet.tds.e.a(Unknown Source)
at com.inet.tds.a.a(Unknown Source)
at com.inet.tds.a.if(Unknown Source)
at com.inet.tds.h.a(Unknown Source)
at com.inet.tds.h.getTables(Unknown Source)
at com.interwoven.dd100.dd.TableSchema.Exists(TableSchema.java:121)
at com.interwoven.dd100.dd.TDbAgent.CleanupLobLocatorEntry(TDbAgent.java:4514)
at com.interwoven.dd100.dd.TDbAgent.setParameterValuesForWhereClause(TDbAgent.java:4132)
at com.interwoven.dd100.dd.TDbAgent.Select(TDbAgent.java:2476)
at com.interwoven.dd100.dd.TDbAgent.NarrowInsertUpdate(TDbAgent.java:2119)
at com.interwoven.dd100.dd.TDbAgent.WriteTuple(TDbAgent.java:3643)
at com.interwoven.dd100.dd.TConsumerManager.WriteConsumerInternal(TConsumerManager.java:399)
at com.interwoven.dd100.dd.TConsumerManager.WriteConsumers(TConsumerManager.java:388)
at com.interwoven.dd100.dd.TAgentClient.DoOneXmlSource(TAgentClient.java:390)
at com.interwoven.dd100.dd.TAgentClient.DoXmlSource(TAgentClient.java:319)
at com.interwoven.dd100.dd.TAgentClient.DoOneDeployment(TAgentClient.java:293)
at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:178)
at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDeploy.java:582)
at com.interwoven.dd100.dd.TDASThread.ProcessItem(TDASThread.java:203)
at com.interwoven.dd100.dd.TDASThread.run(TDASThread.java:128)

DBD: Error occured in TDbAgent: Smiley Frustrated

elect()
DBD:
DBD: *******************************************************
DBD: SQLException occured in TDbAgent Smiley Frustrated

elect()
DBD: Exception Message: Connection reset by peer: socket write error
DBD: Vendor Error Code: 0
DBD: SQL state: 08S01
DBD: *******************************************************
DBD:
DBD: *******STACK TRACE*************
DBD: ERROR:
com.inet.tds.SQLException: Connection reset by peer: socket write error
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 com.inet.tds.e.a(Unknown Source)
at com.inet.tds.b.new(Unknown Source)
at com.inet.tds.b.executeQuery(Unknown Source)
at com.interwoven.dd100.dd.TDbAgent.Select(TDbAgent.java:2482)
at com.interwoven.dd100.dd.TDbAgent.NarrowInsertUpdate(TDbAgent.java:2119)
at com.interwoven.dd100.dd.TDbAgent.WriteTuple(TDbAgent.java:3643)
at com.interwoven.dd100.dd.TConsumerManager.WriteConsumerInternal(TConsumerManager.java:399)
at com.interwoven.dd100.dd.TConsumerManager.WriteConsumers(TConsumerManager.java:388)
at com.interwoven.dd100.dd.TAgentClient.DoOneXmlSource(TAgentClient.java:390)
at com.interwoven.dd100.dd.TAgentClient.DoXmlSource(TAgentClient.java:319)
at com.interwoven.dd100.dd.TAgentClient.DoOneDeployment(TAgentClient.java:293)
at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:178)
at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDeploy.java:582)
at com.interwoven.dd100.dd.TDASThread.ProcessItem(TDASThread.java:203)
at com.interwoven.dd100.dd.TDASThread.run(TDASThread.java:128)

DBD: Error occured in NarrowInsertUpdate: Select() returned null ResultSet
DBD: -- Failed
DBD: ERROR:WriteTuple failure to consumer[0]
DBD: ERROR:deployment [xml-to-db] FAILED
DBD: Error occured in area outside TDbAgent consumer (explicit rollback initiated)
DBD: Rollback database [10.28.1.136:1433?database=prod_publicsite]...
DBD:
DBD: *******************************************************
DBD: SQLException occured in TDbAgent:Rollback()
DBD: Exception Message: Connection reset by peer: socket write error
DBD: Vendor Error Code: 0
DBD: SQL state: 08S01
[/php]

we are using a DNR script and through that script ,many deployments are running ,few days back some other deplyment failed ,next day it ran successfully ,now a different deployment has failed with same "socket error"

On a devnet thread of 2007 ,it was written that issue will be solved if we update microsft sql server drivers that are used with OD,since we cant update drivers ourselves ,i wanted a confirmation for this issue before going ahead with request for drivers updation

please guide regarding issue,

Regards,
mav

Find more posts tagged with

Comments

ISCBorisB

I do not think that's MS Drivers. After all, whatever drivers you have worked just fine yesterday. You *may* experience
SQL Server connection/Opertaions time-outs. Off the top of my head MS SQL Server default is 4 secs. Ask your DBA to
increase it. That may also explain the fleeting nature of your issue, timeout frequency depends on the changing DB Load

jagadesh

Sometimes this error will occur while two deployment were running at the same time to the particular table for the same row update.
Solution
Increase connection retry in OD and increase Timeout(Table Lock) in DB