Timeout error in BESRelay.log

1

I have a PMR open about this issue, but we haven’t made much headway yet so I wanted to post it here and see if any of you have seen this error before in your BESRelay.log:

Tue, 14 Jun 2016 15:32:43 -0500 - DatabasePropagator (5984) - Database Error: [Microsoft][SQL Server Native Client 11.0]Shared Memory Provider: Timeout error [258]. (08001:258)
[Microsoft][SQL Server Native Client 11.0]Unable to complete login process due to delay in prelogin response (08001:258)
[Microsoft][SQL Server Native Client 11.0]Login timeout expired (S1T00:0)
Tue, 14 Jun 2016 15:32:43 -0500 - DatabasePropagator (5984) - Disconnecting from database; will reconnect in 10 seconds.
Tue, 14 Jun 2016 15:41:00 -0500 - DatabasePropagator (5984) - Database Error: [Microsoft][SQL Server Native Client 11.0]Shared Memory Provider: Timeout error [258]. (08001:258)
[Microsoft][SQL Server Native Client 11.0]Unable to complete login process due to delay in prelogin response (08001:258)
[Microsoft][SQL Server Native Client 11.0]Login timeout expired (S1T00:0)
Tue, 14 Jun 2016 15:41:00 -0500 - DatabasePropagator (5984) - Disconnecting from database; will reconnect in 10 seconds.
Tue, 14 Jun 2016 16:36:32 -0500 - DatabasePropagator (5984) - Database Error: [Microsoft][SQL Server Native Client 11.0]Shared Memory Provider: Timeout error [258]. (08001:258)
[Microsoft][SQL Server Native Client 11.0]Unable to complete login process due to delay in prelogin response (08001:258)
[Microsoft][SQL Server Native Client 11.0]Login timeout expired (S1T00:0)
Tue, 14 Jun 2016 16:36:32 -0500 - DatabasePropagator (5984) - Disconnecting from database; will reconnect in 10 seconds.
Tue, 14 Jun 2016 23:10:01 -0500 - DatabasePropagator (5984) - Database Error: [Microsoft][SQL Server Native Client 11.0]Shared Memory Provider: Timeout error [258]. (08001:258)
[Microsoft][SQL Server Native Client 11.0]Unable to complete login process due to delay in prelogin response (08001:258)
[Microsoft][SQL Server Native Client 11.0]Login timeout expired (S1T00:0)
Tue, 14 Jun 2016 23:10:01 -0500 - DatabasePropagator (5984) - Disconnecting from database; will reconnect in 10 seconds.
Wed, 15 Jun 2016 05:35:31 -0500 - DatabasePropagator (5984) - Database Error: [Microsoft][SQL Server Native Client 11.0]Shared Memory Provider: Timeout error [258]. (08001:258)
[Microsoft][SQL Server Native Client 11.0]Unable to complete login process due to delay in prelogin response (08001:258)
[Microsoft][SQL Server Native Client 11.0]Login timeout expired (S1T00:0)
Wed, 15 Jun 2016 05:35:31 -0500 - DatabasePropagator (5984) - Disconnecting from database; will reconnect in 10 seconds.

It doesn’t seem to cause an issues, and it can occur several times an hour or once every six hours. All my BES services are running under the local system account.

Thanks,
Scott

2

Is the MS SQL database on a different machine than the BigFix Server application?

3

Take a look at this solution:

https://support.microsoft.com/en-us/kb/2919863

4

Have you tried a logon from SQL Server Management Studio?
If yes and you are getting the same error then the problem if from SQL Server Side.

Which versions of MSSQL are you using?

5

The database is on the same server as Bigfix.

I am on version SQL Server 2008 SP3 build 10.00.5890 (which includes MS15-058 QFE Patch)

Microsoft SQL Server Management Studio 10.0.5890.0
Microsoft Analysis Services Client Tools 10.0.5890.0
Microsoft Data Access Components (MDAC) 6.1.7601.17514
Microsoft MSXML 3.0 6.0
Microsoft Internet Explorer 9.0.8112.16421
Microsoft .NET Framework 2.0.50727.5485
Operating System 6.1.7601

I do not have any scheduled SQL jobs running at the times of the timeout. I am not using any domain ids for any of the BES services, just Local System.

Thanks for the article, I saw that too, but it applied to SQL 2012.

There are no SQL server errors in any of the error logs only in the BESRelay.log so my DBA is stumped.

I was thinking about going to SQL SP4, but this issue just started about a month ago, I and didn’t know if it would do any good. Everything is running very smoothly and very quickly.

My server wait times are great:
C:>netstat -aon | find /i “52311” | find “TIME_WAIT” /i /c
10

I can send an empty action to all 20,000+ clients and get a completed response from all clients in my console in 8 minutes!

Applying the SQL server pack may do more harm than good, and the issue hasn’t been around for long so I am just trying to figure out what is causing it.

My BES version is 9.2.7.53 and Windows Server 2008 R2 SP1

Thanks for all the replies,
Scott