none
Search service events

    Question

  • Hi 

    I see this below warning in the event viewer - I've verified that the Search service account and the AppPool have the SPSearchDBAdmin membership on the search Databases - how do I fix this timeout? 

    A database error occurred. Source: .Net SqlClient Data Provider Code: -2 occurred 0 time(s) Description:  Error ordinal: 1 Message: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding., Class: 11, Number: -2, State: 0    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
       at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
       at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync()
       at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket()
       at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer()
       at System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value)
       at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.TdsParser.TdsExecuteTransactionManagerRequest(Byte[] buffer, TransactionManagerRequestType request, String transactionName, TransactionManagerIsolationLevel isoLevel, Int32 timeout, SqlInternalTransaction transaction, TdsParserStateObject stateObj, Boolean isDelegateControlRequest)
       at System.Data.SqlClient.SqlInternalConnectionTds.ExecuteTransactionYukon(TransactionRequest transactionRequest, String transactionName, IsolationLevel iso, SqlInternalTransaction internalTransaction, Boolean isDelegateControlRequest)
       at System.Data.SqlClient.SqlInternalTransaction.Commit()
       at System.Data.SqlClient.SqlTransaction.Commit()
       at Microsoft.Office.Server.Data.TransactionalSqlSession.Commit()
       at Microsoft.Office.Server.Search.ManagedSqlSession.CommitTransaction()

    Monday, April 10, 2017 4:35 AM

Answers

  • Hi Michael 

    I've moved the VM's  to another Hyper-V host - and havn't seen this behavior since

    • Marked as answer by JmATK Tuesday, May 23, 2017 9:11 AM
    Tuesday, May 23, 2017 8:24 AM

All replies