Hi,
Anyone seeing these errors before?
[sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
[sqsrvres] printODBCError: sqlstate = 01000; native error = 2746; message =
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv()).
[sqsrvres] printODBCError: sqlstate = 08S01; native error = b; message =
[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error.
[sqsrvres] OnlineThread: QP is not online.
active/active sql2k cluster with sp3a plus MS03-031 hotfix. I have seen
these errors couple of times before. I have searched on newsgroup and did not
find any answer. Really appreciate if anyone can help.
thanks in advance.
David
These are generated when the cluster service fails to connect to SQL Server
during its check of the resource. Some error occurred to affect the
connection.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Thanks Rand for the reply.
I did not see any sql error in the sql log. In system log, there is no sign
of failover. I think i might need to setup performance monitor to trap the
resource usage if it happens next time.
thanks
David
"Rand Boyd [MSFT]" wrote:
> These are generated when the cluster service fails to connect to SQL Server
> during its check of the resource. Some error occurred to affect the
> connection.
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>
|||There probably will not be any error in the SQL errorlog. It could be a
transient error. Teh cluister serveice will try several times before it
will fail the resource.
Ranf
This posting is provided "as is" with no warranties and confers no rights.
Monday, March 19, 2012
[sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
Labels:
beforesqsrvres,
checkqueryprocessoralive,
database,
errors,
failed,
failedsqsrvres,
microsoft,
mysql,
native,
oracle,
printodbcerror,
server,
sql,
sqlexecdirect,
sqlstate,
sqsrvres
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment