发送prelogin请求时出错:sql server 2008中的文件描述符错误 [英] Error sending prelogin request: Bad file descriptor in sql server 2008

查看:753
本文介绍了发送prelogin请求时出错: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>

         < NetReadsT​​ime> 1772211< / NetReadsT​​ime>

         < Ssl>

            < TotalTime> 51< / TotalTime>

            < NetReadsT​​ime> 8< / NetReadsT​​ime>

            < NetWritesTime> 0< / NetWritesTime>

            < SecureCallsTime> 42< / SecureCallsTime>

            < EnqueueTime> 0< / EnqueueTime>

         < / Ssl>

         < Sspi>&
            < TotalTime> 0< / TotalTime>

            < NetReadsT​​ime> 0< / NetReadsT​​ime>

            < 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在建立连接时发生;连接已关闭。这可能是由客户端或服务器登录超时到期引起的。另外,
很难确定哪个缺失配置会导致此类错误。因此,它需要使用一些故障排除工具来测试特定问题。


 


有些文章正在讨论这个问题,请参考它们。


Windows SQL间歇性连接问题 - 错误17830


连接问题 - 17830/10054


Windows工作站的高级网络适配器故障排除


如何知道TCP卸载是否正常工作


 


如果您无法向我们提供更多信息 或找不到问题的原因 也许
你可以向专业工程师寻求帮助
因为如果你允许他们将拥有你的测试环境 ,他们将分别处理你的问题
保密。


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 issuemaybe 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屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆