June 9, 2012 at 9:13 am
Hi All,
Today morning my production Server restarted unexpectedly 2 times in 1 hr.
Production Server Configuration
Windows Server 2003 R2 64-Bit enterprise edition SP2
SQL Server :- RTM10.50.1617.0Standard Edition (64-bit)
16 GB RAM, 2.66 GHz(8 CPU's)
max server memory (MB)1621474836471450014500
max degree of parallelism0102400
Before same server was working fine and the only change i did is, we installed mysql connectivity driver to create mysql linked Server. After configuring the odbc DSN for mysql i started configure mysql linked Server but MSDASQL provider isn't there.
After doing some google i came to know that there's a bug by microsoft in Windows Server 2003 64-Bit for MSDASQL. So i installed hotfix for the same from below mentioned link around 11 Am. And linked Server was created successfully created and patch also applied successfully.
http://www.microsoft.com/en-us/download/details.aspx?id=20065
And around 12:45 Pm users reported me that a database that they were doing highly delete operation is in recovery mode. This again happenned around 1:47 Pm.
Below mentioned is the error log i got at the time of issue . Please tell me why this happenned? what was the reason for sql server services restarted. As this is production issue m much more worried for next failure.
or any more configurations needed.
Error Log at 12 Pm:-
12:46:16,Server,Unknown,Registry startup parameters: <nl/> -d C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master.mdf<nl/> -e C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG<nl/> -l C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\mastlog.ldf,
12:46:16,,Warning,[139] AutoRestart: Attempting to restart the MSSQLSERVER service (attempt #2)...,
12:46:16,,Error,[359] The local host server is not running,
12:46:15,,Error,[359] The local host server is not running,
12:46:11,,Error,[368] AutoRestart: Unable to restart the MSSQLSERVER service (reason: An instance of the service is already running),
12:46:11,,Error,[298] SQLServer Error: 16389<c/> Communication link failure [SQLSTATE 08S01],
12:46:11,,Error,[359] The local host server is not running,
12:46:11,,Error,[359] The local host server is not running,
12:46:11,,Error,[359] The local host server is not running,
12:46:10,,Error,[298] SQLServer Error: 109<c/> Shared Memory Provider: The pipe has been ended. [SQLSTATE 08S01],
12:46:10,,Error,[298] SQLServer Error: 109<c/> Communication link failure [SQLSTATE 08S01],
12:46:10,,Error,[298] SQLServer Error: 16389<c/> Communication link failure [SQLSTATE 08S01],
12:46:10,,Error,[359] The local host server is not running,
12:46:10,,Error,[359] The local host server is not running,
12:46:10,,Error,[359] The local host server is not running,
12:46:10,,Error,[012] The MSSQLSERVER service terminated unexpectedly,
12:46:10,,Warning,[139] AutoRestart: Attempting to restart the MSSQLSERVER service (attempt #1)...,
12:46:07,spid107,Unknown,Error: 18056<c/> Severity: 20<c/> State: 29.,
12:46:07,spid107,Unknown,The client was unable to reuse a session with SPID 107<c/> which had been reset for connection pooling. The failure ID is 29. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message.,
12:46:07,spid64,Unknown,Error: 18056<c/> Severity: 20<c/> State: 29.,
12:46:07,spid64,Unknown,The client was unable to reuse a session with SPID 64<c/> which had been reset for connection pooling. The failure ID is 29. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message.,
12:46:04,spid116,Unknown,Error: 18056<c/> Severity: 20<c/> State: 29.,
12:46:04,spid116,Unknown,The client was unable to reuse a session with SPID 116<c/> which had been reset for connection pooling. The failure ID is 29. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message.,
12:46:03,spid65,Unknown,Error: 18056<c/> Severity: 20<c/> State: 29.,
12:46:03,spid65,Unknown,The client was unable to reuse a session with SPID 65<c/> which had been reset for connection pooling. The failure ID is 29. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message.,
12:46:03,spid62,Unknown,Error: 18056<c/> Severity: 20<c/> State: 29.,
12:46:03,spid62,Unknown,The client was unable to reuse a session with SPID 62<c/> which had been reset for connection pooling. The failure ID is 29. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message.,
12:46:03,spid51,Unknown,Error: 18056<c/> Severity: 20<c/> State: 29.,
12:46:03,spid51,Unknown,The client was unable to reuse a session with SPID 51<c/> which had been reset for connection pooling. The failure ID is 29. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message.,
12:46:03,spid72,Unknown,Error: 18056<c/> Severity: 20<c/> State: 29.,
12:46:03,spid72,Unknown,The client was unable to reuse a session with SPID 72<c/> which had been reset for connection pooling. The failure ID is 29. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message.,
12:46:01,spid80,Unknown,Error: 18056<c/> Severity: 20<c/> State: 29.,
12:46:01,spid80,Unknown,The client was unable to reuse a session with SPID 80<c/> which had been reset for connection pooling. The failure ID is 29. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message.,
12:46:00,spid77,Unknown,Error: 18056<c/> Severity: 20<c/> State: 29.,
12:46:00,spid77,Unknown,The client was unable to reuse a session with SPID 77<c/> which had been reset for connection pooling. The failure ID is 29. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message.,
12:46:00,spid81,Unknown,Error: 18056<c/> Severity: 20<c/> State: 29.,
12:46:00,spid81,Unknown,The client was unable to reuse a session with SPID 81<c/> which had been reset for connection pooling. The failure ID is 29. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message.,
Error Log at 1:47 Pm:-
13:47:16,spid7s,Unknown,FILESTREAM: effective level = 0<c/> configured level = 0<c/> file system access share name = 'MSSQLSERVER'.,
13:47:16,spid7s,Unknown,0 transactions rolled back in database 'master' (1). This is an informational message only. No user action is required.,
13:47:16,spid7s,Unknown,Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.,
13:47:15,spid7s,Unknown,6 transactions rolled forward in database 'master' (1). This is an informational message only. No user action is required.,
13:47:15,spid7s,Unknown,Starting up database 'master'.,
13:47:15,Server,Unknown,Node configuration: node 0: CPU mask: 0x00000000000000ff:0 Active CPU mask: 0x00000000000000ff:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.,
13:47:15,Server,Unknown,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.,
13:47:15,Server,Unknown,SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.,
13:47:15,Server,Unknown,Detected 8 CPUs. This is an informational message; no user action is required.,
13:47:15,Server,Unknown,This instance of SQL Server last reported using a process ID of 2400 at 6/9/2012 1:47:02 PM (local) 6/9/2012 8:17:02 AM (UTC). This is an informational message only; no user action is required.,
13:47:15,Server,Unknown,Registry startup parameters: <nl/> -d C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master.mdf<nl/> -e C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG<nl/> -l C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\mastlog.ldf,
13:47:15,Server,Unknown,Microsoft SQL Server 2008 R2 (RTM) - 10.50.1617.0 (X64) <nl/>Apr 22 2011 19:23:43 <nl/>Copyright (c) Microsoft Corporation<nl/>Standard Edition (64-bit) on Windows NT 5.2 <X64> (Build 3790: Service Pack 2),
13:47:15,Server,Unknown,(c) Microsoft Corporation.,
13:47:15,Server,Unknown,All rights reserved.,
13:47:15,Server,Unknown,Server process ID is 2540.,
13:47:15,Server,Unknown,Authentication mode is MIXED.,
13:47:15,Server,Unknown,Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG'.,
13:47:12,,Error,[012] The MSSQLSERVER service terminated unexpectedly,
13:47:12,,Warning,[139] AutoRestart: Attempting to restart the MSSQLSERVER service (attempt #1)...,
13:47:08,,Error,[298] SQLServer Error: 26<c/> Client unable to establish connection because an error was encountered during handshakes before login. Common causes include client attempting to connect to an unsupported version of SQL Server<c/> server too busy to accept new connections or a resource limitation (memory or maximum allowed connections) on the server. [SQLSTATE 08001],
13:47:08,,Error,[298] SQLServer Error: 26<c/> Client unable to establish connection because an error was encountered during handshakes before login. Common causes include client attempting to connect to an unsupported version of SQL Server<c/> server too busy to accept new connections or a resource limitation (memory or maximum allowed connections) on the server. [SQLSTATE 08001],
13:47:08,,Error,[298] SQLServer Error: 109<c/> Shared Memory Provider: The pipe has been ended. [SQLSTATE 08001],
13:47:08,,Error,[298] SQLServer Error: 109<c/> Shared Memory Provider: The pipe has been ended. [SQLSTATE 08001],
13:47:08,,Error,[298] SQLServer Error: 26<c/> Client unable to establish connection [SQLSTATE 08001],
13:47:08,,Error,[298] SQLServer Error: 26<c/> Client unable to establish connection [SQLSTATE 08001],
13:47:08,,Error,[298] SQLServer Error: 109<c/> Client unable to establish connection due to prelogin failure [SQLSTATE 08001],
13:47:08,,Error,[382] Logon to server '(local)' failed (ConnUpdateStartExecutionDate),
13:47:08,,Error,[298] SQLServer Error: 109<c/> Client unable to establish connection due to prelogin failure [SQLSTATE 08001],
13:47:08,,Error,[382] Logon to server '(local)' failed (SaveAllSchedules),
13:47:02,spid68,Unknown,Error: 18056<c/> Severity: 20<c/> State: 29.,
13:47:02,spid68,Unknown,The client was unable to reuse a session with SPID 68<c/> which had been reset for connection pooling. The failure ID is 29. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message.,
13:47:02,spid82,Unknown,Error: 18056<c/> Severity: 20<c/> State: 29.,
13:47:02,spid82,Unknown,The client was unable to reuse a session with SPID 82<c/> which had been reset for connection pooling. The failure ID is 29. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message.,
13:47:02,spid73,Unknown,Error: 18056<c/> Severity: 20<c/> State: 29.,
13:47:02,spid73,Unknown,The client was unable to reuse a session with SPID 73<c/> which had been reset for connection pooling. The failure ID is 29. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message.,
13:47:02,spid55,Unknown,Error: 18056<c/> Severity: 20<c/> State: 29.,
13:47:02,spid55,Unknown,The client was unable to reuse a session with SPID 55<c/> which had been reset for connection pooling. The failure ID is 29. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message.,
13:47:02,spid93,Unknown,Error: 18056<c/> Severity: 20<c/> State: 29.,
13:47:02,spid93,Unknown,The client was unable to reuse a session with SPID 93<c/> which had been reset for connection pooling. The failure ID is 29. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message.,
13:47:02,spid70,Unknown,Error: 18056<c/> Severity: 20<c/> State: 29.,
13:47:02,spid70,Unknown,The client was unable to reuse a session with SPID 70<c/> which had been reset for connection pooling. The failure ID is 29. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message.,
13:47:02,spid54,Unknown,Error: 18056<c/> Severity: 20<c/> State: 29.,
13:47:02,spid54,Unknown,The client was unable to reuse a session with SPID 54<c/> which had been reset for connection pooling. The failure ID is 29. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message.,
13:47:02,spid89,Unknown,Error: 18056<c/> Severity: 20<c/> State: 29.,
13:47:02,spid89,Unknown,The client was unable to reuse a session with SPID 89<c/> which had been reset for connection pooling. The failure ID is 29. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message.,
13:47:02,spid56,Unknown,Error: 18056<c/> Severity: 20<c/> State: 29.,
13:47:02,spid56,Unknown,The client was unable to reuse a session with SPID 56<c/> which had been reset for connection pooling. The failure ID is 29. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message.,
13:47:02,spid78,Unknown,Error: 18056<c/> Severity: 20<c/> State: 29.,
Viewing post 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply