the request limit for the database has been reached

Press Ctrl / CMD + C to copy this to your clipboard.

Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at

von 61 posts 123 karma points

Sep 14, 2018 @ 03:43

using SeoChecker

Umbraco 7

We recently have been getting a lot of this error and there's not much info why it's happening. We are at 2.0.

SEOChecker: SEOChecker: Error in PageNotFound Module
System.Data.SqlClient.SqlException (0x80131904): Resource ID : 1. The request limit for the database is 60 and has been reached. See 'http://go.microsoft.com/fwlink/?LinkId=267637' for assistance.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   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.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.SqlInternalConnectionTds.ExecuteTransaction(TransactionRequest transactionRequest, String name, IsolationLevel iso, SqlInternalTransaction internalTransaction, Boolean isDelegateControlRequest)
   at System.Data.SqlClient.SqlInternalConnection.BeginSqlTransaction(IsolationLevel iso, String transactionName, Boolean shouldReconnect)
   at System.Data.SqlClient.SqlConnection.BeginTransaction(IsolationLevel iso, String transactionName)
   at System.Data.SqlClient.SqlConnection.BeginDbTransaction(IsolationLevel isolationLevel)
   at System.Data.Common.DbConnection.System.Data.IDbConnection.BeginTransaction(IsolationLevel isolationLevel)
   at Umbraco.Core.Persistence.Database.OpenSharedConnection()
   at Umbraco.Core.Persistence.Database.<Query>d__74`1.MoveNext()
   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
   at SEOChecker.Core.Repository.PageNotFound.PageNotFoundRepository.(String , String , String , String , String , String )
   at SEOChecker.Core.Repository.PageNotFound.PageNotFoundRepository.(Uri , Boolean )
   at SEOChecker.HttpModules.UrlModule.(Object , EventArgs )
ClientConnectionId:xxxxxxxxxxxxxxx
Error Number:10928,State:1,Class:20
ClientConnectionId before routing:xxxxxxxxxxx
Routing Destination:xxxxxxxx.tr20.xxxxxx.worker.database.windows.net,11100

Copy Link

Søren Gregersen 441 posts 1884 karma points MVP 2x c-trib

Sep 14, 2018 @ 06:17

0

Hi,

The exception message is quite clear IMHO. Your database allows 60 concurrent connections, and you have reached that limit, så the configuration is your problem.

The PageNotFound-module logs all 404 “errors”, so if you are getting alot of thatkind of traffic, that explains the cause.

HTH Søren

Copy Link
Richard Soeteman 4035 posts 12842 karma points MVP

Sep 14, 2018 @ 07:07

1

Hi Von,

Apparently you have a request limit on sql server azure. Best to increase that.. SEO Checker will make a request every minute to check if it needs to process items in the validation queue.

Best,

Richard

Copy Link
is working on a reply...

Please Sign in or register to post replies