Copied to clipboard

Flag this post as spam?

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


  • von 48 posts 110 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
    
  • Søren Gregersen 132 posts 646 karma points 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

  • Richard Soeteman 3455 posts 10263 karma points MVP
    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

Please Sign in or register to post replies

Write your reply to:

Draft