August 12, 2011 at 9:09 am
Dear all
My SQLSERVER 2000 went off and came back immediately with in 2 min, while doing root cause analysis.
I found below lines in Cluster log file.
Can some describe be why SQL Server went offline.
00000614.00000ef0::2011/08/11-13:37:30.337 INFO [NM] Finished pinging targets for interface d6a4f53a-e778-457e-87ea-9bb9d40978d0.
0000089c.00000d4c::2011/08/11-13:37:51.494 ERR SQL Server <SQL Server>: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
0000089c.00000d4c::2011/08/11-13:37:51.494 ERR SQL Server <SQL Server>: [sqsrvres] printODBCError: sqlstate = HYT00; native error = 0; message = [Microsoft][ODBC SQL Server Driver]Timeout expired
0000089c.00000d4c::2011/08/11-13:37:51.494 ERR SQL Server <SQL Server>: [sqsrvres] OnlineThread: QP is not online.
0000089c.00000d4c::2011/08/11-13:37:51.494 ERR SQL Server <SQL Server>: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
0000089c.00000d4c::2011/08/11-13:37:51.494 ERR SQL Server <SQL Server>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][ODBC SQL Server Driver]Communication link failure
0000089c.00000d4c::2011/08/11-13:37:51.494 ERR SQL Server <SQL Server>: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
0000089c.00000d4c::2011/08/11-13:37:51.494 ERR SQL Server <SQL Server>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][ODBC SQL Server Driver]Communication link failure
0000089c.00000d4c::2011/08/11-13:37:51.494 ERR SQL Server <SQL Server>: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
0000089c.00000d4c::2011/08/11-13:37:51.494 ERR SQL Server <SQL Server>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][ODBC SQL Server Driver]Communication link failure
0000089c.00000d4c::2011/08/11-13:37:51.494 ERR SQL Server <SQL Server>: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
0000089c.00000d4c::2011/08/11-13:37:51.494 ERR SQL Server <SQL Server>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][ODBC SQL Server Driver]Communication link failure
0000089c.00000d4c::2011/08/11-13:37:51.494 ERR SQL Server <SQL Server>: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
0000089c.00000d4c::2011/08/11-13:37:51.494 ERR SQL Server <SQL Server>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][ODBC SQL Server Driver]Communication link failure
0000089c.00000d4c::2011/08/11-13:38:12.526 ERR SQL Server <SQL Server>: [sqsrvres] ODBC sqldriverconnect failed
0000089c.00000d4c::2011/08/11-13:38:12.526 ERR SQL Server <SQL Server>: [sqsrvres] checkODBCConnectError: sqlstate = 08001; native error = b; message = [Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation.
0000089c.00000d4c::2011/08/11-13:38:12.526 ERR SQL Server <SQL Server>: [sqsrvres] ODBC sqldriverconnect failed
0000089c.00000d4c::2011/08/11-13:38:12.526 ERR SQL Server <SQL Server>: [sqsrvres] checkODBCConnectError: sqlstate = 01000; native error = 274c; message = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (PreLoginHandshake()).
00000614.00000ef0::2011/08/11-13:38:32.730 INFO [NM] Received request to get online address enum for interface d6a4f53a-e778-457e-87ea-9bb9d40978d0.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply