Sign in Register
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
    von
    0

    The request limit for the database has been reached

    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
    Søren Gregersen
    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 4054 posts 12927 karma points MVP 2x
    Sep 14, 2018 @ 07:07
    Richard Soeteman
    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

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies