34,576
社区成员
发帖
与我相关
我的任务
分享数据库报TCP connection closed 错误，微软的补丁解决不了问题，求指导
数据库服务器一直用的比较稳定，但是现在每次程序连接的时候出现TCP connection closed but a child process of SQL Server may be holding a duplicate of the connection's socket. Consider enabling the TcpAbortiveClose SQL Server registry setting and restarting SQL Server. If the problem persists, contact Technical Support.错误的代码是26073，经过查找微软的支持网站，发现http://support.microsoft.com/kb/2491214说的是这个问题的解决方案，但是实际我打完补丁，升级到Microsoft SQL Server 2008 (SP3) - 10.0.5500.0 (X64)这个 版本，同时修改注册表，增加 TcpAbortiveClose项，但是仍然解决不了问题。我发现程序连接的时候，是通过默认的端口号1433来链接，我一进行测试，使用sqlcmd -S localhost,1433 -U sa -P XXXX -Q "select 1"的时候，数据库日志就报TCP connection closed but a child process of SQL Server may be holding a duplicate of the connection's socket. Consider enabling the TcpAbortiveClose SQL Server registry setting and restarting SQL Server. If the problem persists, contact Technical Support.错误，如果不加端口号sqlcmd -S localhost -U sa -P XXXX -Q "select 1"，就没有问题,哪位专家遇到过类似的问题，求指导，谢谢
具体日志信息为
08/28/2013 09:13:51,服务器,未知,TCP connection closed but a child process of SQL Server may be holding a duplicate of the connection's socket. Consider enabling the TcpAbortiveClose SQL Server registry setting and restarting SQL Server. If the problem persists<c/> contact Technical Support.
08/28/2013 09:13:51,服务器,未知,错误: 26073，严重性: 16，状态: 1。
08/28/2013 09:12:46,服务器,未知,TCP connection closed but a child process of SQL Server may be holding a duplicate of the connection's socket. Consider enabling the TcpAbortiveClose SQL Server registry setting and restarting SQL Server. If the problem persists<c/> contact Technical Support.
08/28/2013 09:12:46,服务器,未知,错误: 26073，严重性: 16，状态: 1。
08/28/2013 00:00:01,spid23s,未知,This instance of SQL Server has been using a process ID of 3004 since 2013/8/27 20:00:00 (local) 2013/8/27 12:00:00 (UTC). This is an informational message only; no user action is required.
08/27/2013 20:00:31,服务器,未知,TCP connection closed but a child process of SQL Server may be holding a duplicate of the connection's socket. Consider enabling the TcpAbortiveClose SQL Server registry setting and restarting SQL Server. If the problem persists<c/> contact Technical Support.
08/27/2013 20:00:31,服务器,未知,错误: 26073，严重性: 16，状态: 1。
08/27/2013 20:00:31,spid52,未知,Using 'xpstar.dll' version '2007.100.5500' to execute extended stored procedure 'xp_enumerrorlogs'. This is an informational message only; no user action is required.
08/27/2013 20:00:31,spid52,未知,Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.
08/27/2013 20:00:00,spid7s,未知,Recovery is complete. This is an informational message only. No user action is required.
08/27/2013 20:00:00,spid13s,未知,Service Broker manager has started.
08/27/2013 20:00:00,spid13s,未知,The Database Mirroring protocol transport is disabled or not configured.
08/27/2013 20:00:00,spid13s,未知,The Service Broker protocol transport is disabled or not configured.
08/27/2013 20:00:00,spid10s,未知,Starting up database 'tempdb'.
08/27/2013 20:00:00,服务器,未知,SQL Server is now ready for client connections. This is an informational message; no user action is required.
08/27/2013 20:00:00,服务器,未知,The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b<c/> state: 3. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.
08/27/2013 20:00:00,服务器,未知,Dedicated admin connection support was established for listening locally on port 1434.
08/27/2013 20:00:00,服务器,未知,Server is listening on [ 127.0.0.1 <ipv4> 1434].
08/27/2013 20:00:00,服务器,未知,Server is listening on [ ::1 <ipv6> 1434].
08/27/2013 20:00:00,服务器,未知,Server local connection provider is ready to accept connection on [ \\.\pipe\sql\query ].
08/27/2013 20:00:00,服务器,未知,Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
08/27/2013 20:00:00,服务器,未知,Server is listening on [ 'any' <ipv4> 1433].
08/27/2013 20:00:00,服务器,未知,Server is listening on [ 'any' <ipv6> 1433].
08/27/2013 20:00:00,服务器,未知,A self-generated certificate was successfully loaded for encryption.
08/27/2013 20:00:00,spid10s,未知,Clearing tempdb database.
08/27/2013 20:00:00,spid7s,未知,Starting up database 'msdb'.
08/27/2013 20:00:00,spid7s,未知,信息: 找不到支持全文的语言。
08/27/2013 20:00:00,spid10s,未知,Starting up database 'model'.
08/27/2013 20:00:00,spid7s,未知,Server name is 'WIN-JHCEDN9OVOQ'. This is an informational message only. No user action is required.
08/27/2013 20:00:00,spid7s,未知,The resource database build version is 10.00.5500. This is an informational message only. No user action is required.
08/27/2013 20:00:00,spid7s,未知,Starting up database 'mssqlsystemresource'.
08/27/2013 20:00:00,spid7s,未知,SQL Trace ID 1 was started by login "sa".
08/27/2013 20:00:00,spid7s,未知,FILESTREAM: effective level = 0<c/> configured level = 0<c/> file system access share name = 'MSSQLSERVER'.
08/27/2013 20:00:00,spid7s,未知,SQL Server Audit has started the audits. This is an informational message. No user action is required.
08/27/2013 20:00:00,spid7s,未知,SQL Server Audit is starting the audits. This is an informational message. No user action is required.
08/27/2013 20:00:00,spid7s,未知,Resource governor reconfiguration succeeded.
08/27/2013 20:00:00,spid7s,未知,Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
08/27/2013 20:00:00,spid7s,未知,Starting up database 'master'.
08/27/2013 20:00:00,服务器,未知,Node configuration: node 0: CPU mask: 0x0000000000000fff Active CPU mask: 0x0000000000000fff. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
08/27/2013 20:00:00,服务器,未知,Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
08/27/2013 20:00:00,服务器,未知,Using locked pages for buffer pool.
08/27/2013 20:00:00,服务器,未知,Detected 12 CPUs. This is an informational message; no user action is required.
08/27/2013 20:00:00,服务器,未知,SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
08/27/2013 20:00:00,Server,未知,Registry startup parameters: <nl/> -d C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\master.mdf<nl/> -e C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG<nl/> -l C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
08/27/2013 20:00:00,Server,未知,This instance of SQL Server last reported using a process ID of 1776 at 2013/8/27 19:59:53 (local) 2013/8/27 11:59:53 (UTC). This is an informational message only; no user action is required.
08/27/2013 20:00:00,Server,未知,Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
08/27/2013 20:00:00,Server,未知,Authentication mode is MIXED.
08/27/2013 20:00:00,Server,未知,System Manufacturer: 'IBM'<c/> System Model: 'System x3650 M4 : -[7915IF5]-'.
08/27/2013 20:00:00,Server,未知,Server process ID is 3004.
08/27/2013 20:00:00,Server,未知,All rights reserved.
08/27/2013 20:00:00,Server,未知,(c) 2005 Microsoft Corporation.
08/27/2013 20:00:00,Server,未知,Microsoft SQL Server 2008 (SP3) - 10.0.5500.0 (X64) <nl/> Sep 21 2011 22:45:45 <nl/> Copyright (c) 1988-2008 Microsoft Corporation<nl/> Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
具体日志信息为
08/28/2013 09:13:51,服务器,未知,TCP connection closed but a child process of SQL Server may be holding a duplicate of the connection's socket. Consider enabling the TcpAbortiveClose SQL Server registry setting and restarting SQL Server. If the problem persists<c/> contact Technical Support.
08/28/2013 09:13:51,服务器,未知,错误: 26073，严重性: 16，状态: 1。
08/28/2013 09:12:46,服务器,未知,TCP connection closed but a child process of SQL Server may be holding a duplicate of the connection's socket. Consider enabling the TcpAbortiveClose SQL Server registry setting and restarting SQL Server. If the problem persists<c/> contact Technical Support.
08/28/2013 09:12:46,服务器,未知,错误: 26073，严重性: 16，状态: 1。
08/28/2013 00:00:01,spid23s,未知,This instance of SQL Server has been using a process ID of 3004 since 2013/8/27 20:00:00 (local) 2013/8/27 12:00:00 (UTC). This is an informational message only; no user action is required.
08/27/2013 20:00:31,服务器,未知,TCP connection closed but a child process of SQL Server may be holding a duplicate of the connection's socket. Consider enabling the TcpAbortiveClose SQL Server registry setting and restarting SQL Server. If the problem persists<c/> contact Technical Support.
08/27/2013 20:00:31,服务器,未知,错误: 26073，严重性: 16，状态: 1。
08/27/2013 20:00:31,spid52,未知,Using 'xpstar.dll' version '2007.100.5500' to execute extended stored procedure 'xp_enumerrorlogs'. This is an informational message only; no user action is required.
08/27/2013 20:00:31,spid52,未知,Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.
08/27/2013 20:00:00,spid7s,未知,Recovery is complete. This is an informational message only. No user action is required.
08/27/2013 20:00:00,spid13s,未知,Service Broker manager has started.
08/27/2013 20:00:00,spid13s,未知,The Database Mirroring protocol transport is disabled or not configured.
08/27/2013 20:00:00,spid13s,未知,The Service Broker protocol transport is disabled or not configured.
08/27/2013 20:00:00,spid10s,未知,Starting up database 'tempdb'.
08/27/2013 20:00:00,服务器,未知,SQL Server is now ready for client connections. This is an informational message; no user action is required.
08/27/2013 20:00:00,服务器,未知,The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b<c/> state: 3. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.
08/27/2013 20:00:00,服务器,未知,Dedicated admin connection support was established for listening locally on port 1434.
08/27/2013 20:00:00,服务器,未知,Server is listening on [ 127.0.0.1 <ipv4> 1434].
08/27/2013 20:00:00,服务器,未知,Server is listening on [ ::1 <ipv6> 1434].
08/27/2013 20:00:00,服务器,未知,Server local connection provider is ready to accept connection on [ \\.\pipe\sql\query ].
08/27/2013 20:00:00,服务器,未知,Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
08/27/2013 20:00:00,服务器,未知,Server is listening on [ 'any' <ipv4> 1433].
08/27/2013 20:00:00,服务器,未知,Server is listening on [ 'any' <ipv6> 1433].
08/27/2013 20:00:00,服务器,未知,A self-generated certificate was successfully loaded for encryption.
08/27/2013 20:00:00,spid10s,未知,Clearing tempdb database.
08/27/2013 20:00:00,spid7s,未知,Starting up database 'msdb'.
08/27/2013 20:00:00,spid7s,未知,信息: 找不到支持全文的语言。
08/27/2013 20:00:00,spid10s,未知,Starting up database 'model'.
08/27/2013 20:00:00,spid7s,未知,Server name is 'WIN-JHCEDN9OVOQ'. This is an informational message only. No user action is required.
08/27/2013 20:00:00,spid7s,未知,The resource database build version is 10.00.5500. This is an informational message only. No user action is required.
08/27/2013 20:00:00,spid7s,未知,Starting up database 'mssqlsystemresource'.
08/27/2013 20:00:00,spid7s,未知,SQL Trace ID 1 was started by login "sa".
08/27/2013 20:00:00,spid7s,未知,FILESTREAM: effective level = 0<c/> configured level = 0<c/> file system access share name = 'MSSQLSERVER'.
08/27/2013 20:00:00,spid7s,未知,SQL Server Audit has started the audits. This is an informational message. No user action is required.
08/27/2013 20:00:00,spid7s,未知,SQL Server Audit is starting the audits. This is an informational message. No user action is required.
08/27/2013 20:00:00,spid7s,未知,Resource governor reconfiguration succeeded.
08/27/2013 20:00:00,spid7s,未知,Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
08/27/2013 20:00:00,spid7s,未知,Starting up database 'master'.
08/27/2013 20:00:00,服务器,未知,Node configuration: node 0: CPU mask: 0x0000000000000fff Active CPU mask: 0x0000000000000fff. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
08/27/2013 20:00:00,服务器,未知,Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
08/27/2013 20:00:00,服务器,未知,Using locked pages for buffer pool.
08/27/2013 20:00:00,服务器,未知,Detected 12 CPUs. This is an informational message; no user action is required.
08/27/2013 20:00:00,服务器,未知,SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
08/27/2013 20:00:00,Server,未知,Registry startup parameters: <nl/> -d C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\master.mdf<nl/> -e C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG<nl/> -l C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
08/27/2013 20:00:00,Server,未知,This instance of SQL Server last reported using a process ID of 1776 at 2013/8/27 19:59:53 (local) 2013/8/27 11:59:53 (UTC). This is an informational message only; no user action is required.
08/27/2013 20:00:00,Server,未知,Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
08/27/2013 20:00:00,Server,未知,Authentication mode is MIXED.
08/27/2013 20:00:00,Server,未知,System Manufacturer: 'IBM'<c/> System Model: 'System x3650 M4 : -[7915IF5]-'.
08/27/2013 20:00:00,Server,未知,Server process ID is 3004.
08/27/2013 20:00:00,Server,未知,All rights reserved.
08/27/2013 20:00:00,Server,未知,(c) 2005 Microsoft Corporation.
08/27/2013 20:00:00,Server,未知,Microsoft SQL Server 2008 (SP3) - 10.0.5500.0 (X64) <nl/> Sep 21 2011 22:45:45 <nl/> Copyright (c) 1988-2008 Microsoft Corporation<nl/> Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
...全文
请发表友善的回复…
发表回复
ponky 2013-08-28
- 打赏
- 举报
微软服务器和数据库的补丁都打过了，好像没有啥效果
ponky 2013-08-28
- 打赏
- 举报
是按照这个上面修改的
KevinLiu 2013-08-28
- 打赏
- 举报
另外这篇文章还提到WINDOWS的补丁：
http://support.microsoft.com/kb/2491214/zh-cn
KevinLiu 2013-08-28
- 打赏
- 举报
注册表你是按照这篇文章上面讲的修改的吗？ http://support.microsoft.com/kb/2491214/zh-cn
另外问一下如果你尝试用其他的Provider比如OLE DB连接是否可以正常工作啊？
