发送prelogin请求时出错：sql server 2008中的文件描述符错误 [英] Error sending prelogin request: Bad file descriptor in sql server 2008
问题描述
我正在运行11个测试的测试套件，测试单独通过，但在第8次测试后将它们一起运行ii得到此错误
2019年3月6日上午10:23:10 com.microsoft.sqlserver.jdbc.SQLServerConnection Prelogin
警告：ConnectionID：91 ClientConnectionId：da0135b9-15e6-4afd-8a30-2ed0fbd1cb85 Prelogin错误：host 192.168.10.162 port 1433发送prelogin请求时出错：错误的文件描述符（写入失败）ClientConnectionId：da0135b9-15e6-4afd-8a30-2ed0fbd1cb85
并查看'RING_BUFFER_CONNECTIVITY'
我收到了这个
<？xml version =" 1.0" encoding =" UTF-8"？>
< Record id =" 24433"类型= QUOT; RING_BUFFER_CONNECTIVITY" time =" 1761512090">
< ConnectivityTraceRecord>
< RecordType> LoginTimers< / RecordType>
< IsClient> 0< / IsClient>
< Spid> 172< / Spid>
< SniConnId> 4D5E4A5D-5F27-4723-B012-0F0EB3ABF1B5< / SniConnId>
< ClientConnectionId> DF38D66A-3DF4-46FD-B7F7-86FEDFE77202< / ClientConnectionId>
< SniConsumerError> 17830< / SniConsumerError>
< SniProvider> 7< / SniProvider>
<状态> 107< /状态>
< RemoteHost><！[CDATA [192.168.10.168]]>< / RemoteHost>
< RemotePort> 49874< / RemotePort>
< LocalHost><！[CDATA [172.17.0.2]]>< / LocalHost>
< LocalPort> 1433< / LocalPort>
< RecordTime> 3/5/2019 21：29：22.75< / RecordTime>
< TdsBufInfo>
< InputBufError> 10054< / InputBufError>
< OutputBufError> 0< / OutputBufError>
< InputBufBytes> 0< / InputBufBytes>
< / TdsBufInfo>
< LoginTimersInMilliseconds>
< TotalTime> 1772266< / TotalTime>
< EnqueueTime> 1< / EnqueueTime>&
< NetWritesTime> 0< / NetWritesTime>
< NetReadsTime> 1772211< / NetReadsTime>
< Ssl>
< TotalTime> 51< / TotalTime>
< NetReadsTime> 8< / NetReadsTime>
< NetWritesTime> 0< / NetWritesTime>
< SecureCallsTime> 42< / SecureCallsTime>
< EnqueueTime> 0< / EnqueueTime>
< / Ssl>
< Sspi>&
< TotalTime> 0< / TotalTime>
< NetReadsTime> 0< / NetReadsTime>
< NetWritesTime> 0< / NetWritesTime>
< SecureCallsTime> 0< / SecureCallsTime>
< EnqueueTime> 0< / EnqueueTime>
< / Sspi>&
< TriggerAndResGovTime>
< TotalTime> 1< / TotalTime>
< FindLogin> 0< / FindLogin>
< LogonTriggers> 0< / LogonTriggers>
< ExecClassifier> 0< / ExecClassifier>
< SessionRecover> 0< / SessionRecover>
< / TriggerAndResGovTime>
< / LoginTimersInMilliseconds>
< / ConnectivityTraceRecord>
< Stack>
< frame id =" 0"> 0X0000000389C7D28F< / frame>
< frame id =" 1"> 0X0000000389C8A2F3< / frame>
< frame id =" 2"> 0X0000000389C8924A< / frame>
< frame id =" 3"> 0X00000003892818A1< / frame>
< frame id =" 4"> 0X0000000389281743< / frame>
< frame id =" 5"> 0X0000000381524EED< / frame>
< frame id =" 6"> 0X00000003815253C8< / frame>
< frame id =" 7"> 0X000000038152503D< / frame>
< frame id =" 8"> 0X0000000381550EE8< / frame>
< frame id =" 9"> 0X0000000381550FE0< / frame>
< frame id =" 10"> 0X0000000381550C27< / frame>
< frame id =" 11"> 0X0000000381551409< / frame>
< frame id =" 12"> 0X0000000380942774< / frame>
< frame id =" 13"> 0X00000003802A0D51< / frame>
< frame id =" 14"> 0X00007F30D206D800< / frame>
< / Stack>
< /记录>
消息17830是网络错误代码0x％x在建立连接时发生;连接已关闭。这可能是由客户端或服务器登录超时到期引起的。另外，
很难确定哪个缺失配置会导致此类错误。因此，它需要使用一些故障排除工具来测试特定问题。
有些文章正在讨论这个问题，请参考它们。
如果您无法向我们提供更多信息 或找不到问题的原因 ， 也许
你可以向专业工程师寻求帮助 因为如果你允许他们将拥有你的测试环境 ，他们将分别处理你的问题
保密。
https://support.microsoft.com/en-us/assistedsupportproducts
希望它可以帮到你。
最好的问候，
拉结
i am running a test suit with 11 tests the tests are passing individually but running them together after the 8th test ii get this error
Mar 06, 2019 10:23:10 AM com.microsoft.sqlserver.jdbc.SQLServerConnection Prelogin
WARNING: ConnectionID:91 ClientConnectionId: da0135b9-15e6-4afd-8a30-2ed0fbd1cb85 Prelogin error: host 192.168.10.162 port 1433 Error sending prelogin request: Bad file descriptor (Write failed) ClientConnectionId:da0135b9-15e6-4afd-8a30-2ed0fbd1cb85
and looking at the 'RING_BUFFER_CONNECTIVITY'
i am getting this
<?xml version="1.0" encoding="UTF-8"?>
<Record id="24433" type="RING_BUFFER_CONNECTIVITY" time="1761512090">
<ConnectivityTraceRecord>
<RecordType>LoginTimers</RecordType>
<IsClient>0</IsClient>
<Spid>172</Spid>
<SniConnId>4D5E4A5D-5F27-4723-B012-0F0EB3ABF1B5</SniConnId>
<ClientConnectionId>DF38D66A-3DF4-46FD-B7F7-86FEDFE77202</ClientConnectionId>
<SniConsumerError>17830</SniConsumerError>
<SniProvider>7</SniProvider>
<State>107</State>
<RemoteHost><![CDATA[192.168.10.168]]></RemoteHost>
<RemotePort>49874</RemotePort>
<LocalHost><![CDATA[172.17.0.2]]></LocalHost>
<LocalPort>1433</LocalPort>
<RecordTime>3/5/2019 21:29:22.75</RecordTime>
<TdsBufInfo>
<InputBufError>10054</InputBufError>
<OutputBufError>0</OutputBufError>
<InputBufBytes>0</InputBufBytes>
</TdsBufInfo>
<LoginTimersInMilliseconds>
<TotalTime>1772266</TotalTime>
<EnqueueTime>1</EnqueueTime>
<NetWritesTime>0</NetWritesTime>
<NetReadsTime>1772211</NetReadsTime>
<Ssl>
<TotalTime>51</TotalTime>
<NetReadsTime>8</NetReadsTime>
<NetWritesTime>0</NetWritesTime>
<SecureCallsTime>42</SecureCallsTime>
<EnqueueTime>0</EnqueueTime>
</Ssl>
<Sspi>
<TotalTime>0</TotalTime>
<NetReadsTime>0</NetReadsTime>
<NetWritesTime>0</NetWritesTime>
<SecureCallsTime>0</SecureCallsTime>
<EnqueueTime>0</EnqueueTime>
</Sspi>
<TriggerAndResGovTime>
<TotalTime>1</TotalTime>
<FindLogin>0</FindLogin>
<LogonTriggers>0</LogonTriggers>
<ExecClassifier>0</ExecClassifier>
<SessionRecover>0</SessionRecover>
</TriggerAndResGovTime>
</LoginTimersInMilliseconds>
</ConnectivityTraceRecord>
<Stack>
<frame id="0">0X0000000389C7D28F</frame>
<frame id="1">0X0000000389C8A2F3</frame>
<frame id="2">0X0000000389C8924A</frame>
<frame id="3">0X00000003892818A1</frame>
<frame id="4">0X0000000389281743</frame>
<frame id="5">0X0000000381524EED</frame>
<frame id="6">0X00000003815253C8</frame>
<frame id="7">0X000000038152503D</frame>
<frame id="8">0X0000000381550EE8</frame>
<frame id="9">0X0000000381550FE0</frame>
<frame id="10">0X0000000381550C27</frame>
<frame id="11">0X0000000381551409</frame>
<frame id="12">0X0000000380942774</frame>
<frame id="13">0X00000003802A0D51</frame>
<frame id="14">0X00007F30D206D800</frame>
</Stack>
</Record>
Hi ,
Message 17830 is Network error code 0x%x occurred while establishing a connection; the connection has been closed. This may have been caused by client or server login timeout expiration. Also, it is hard to determine which missing configuration leads to such error. So it needs to use some troubleshooting tools to test specific problems.
There are some articles which are talking about this issue, please refer to them .
Windows SQL Intermittent Connectivity Issue - Error 17830
Connectivity Issues - 17830/10054
Advanced network adapter troubleshooting for Windows workstations
How to know if TCP offload is working
If you could not provide us more information or could not find the reason for your issue，maybe you can ask professional engineer for help because they will own your environment for testing if you allow them, and they will deal with your problem separately and confidentially.
https://support.microsoft.com/en-us/assistedsupportproducts
Hope it can help you.
Best Regards,
Rachel
这篇关于发送prelogin请求时出错：sql server 2008中的文件描述符错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
