We are using Umbraco 7.1.8 with Url Tracker 3.0.1.
We have an intermittent problem where our site will crash. When we look in the logs, we see a whole lot of errors like this:
2015-07-16 12:32:41,386 [5] ERROR Umbraco.Core.UmbracoApplicationBase - [Thread 49] An unhandled exception occurred
umbraco.DataLayer.SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader ---> System.Data.SqlClient.SqlException: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The wait operation timed out.) ---> System.ComponentModel.Win32Exception: The wait operation timed out
--- End of inner exception stack trace ---
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.Open()
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteReader(String commandText, SqlParameter[] parameters)
at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters)
--- End of inner exception stack trace ---
at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters)
at InfoCaster.Umbraco.UrlTracker.Modules.UrlTrackerModule.UrlTrackerDo(String callingEventName, Boolean ignoreHttpStatusCode) in c:\Users\kipusoep\Documents\GitHub\UrlTracker\Modules\UrlTrackerModule.cs:line 168
at InfoCaster.Umbraco.UrlTracker.Modules.UrlTrackerModule.context_AcquireRequestState(Object sender, EventArgs e) in c:\Users\kipusoep\Documents\GitHub\UrlTracker\Modules\UrlTrackerModule.cs:line 53
at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
It is unclear if the Url Tracker is the root of the problem or if it is just throwing the most errors when the database is too busy to respond.
I am wondering if anyone has seen this problem or if they know if an upgrade to the latest Url Tracker will help. I saw an improvement for version 3.8 of UrlTracker that says "no SQL queries will be performed anymore for valid requests". I'm hopeful that someone else has experienced our problem and seen versions 3.8+ as solutions. Any thoughts?
We still aren't sure if Url Tracker is involved at all. We upgraded. The problem wasn't related to versions. We found out that the site was being bombarded with 404s. The icUrlTracker table had over 2.25 million records in it (growing by at least 17,000 per day). It appears that this wasn't the problem, either. We implemented the following solution, but the site still goes down periodically.
An error occurred during the pre-login handshake
We are using Umbraco 7.1.8 with Url Tracker 3.0.1.
We have an intermittent problem where our site will crash. When we look in the logs, we see a whole lot of errors like this:
It is unclear if the Url Tracker is the root of the problem or if it is just throwing the most errors when the database is too busy to respond.
I am wondering if anyone has seen this problem or if they know if an upgrade to the latest Url Tracker will help. I saw an improvement for version 3.8 of UrlTracker that says "no SQL queries will be performed anymore for valid requests". I'm hopeful that someone else has experienced our problem and seen versions 3.8+ as solutions. Any thoughts?
Try the latest version first please.
We still aren't sure if Url Tracker is involved at all. We upgraded. The problem wasn't related to versions. We found out that the site was being bombarded with 404s. The
icUrlTrackertable had over 2.25 million records in it (growing by at least 17,000 per day). It appears that this wasn't the problem, either. We implemented the following solution, but the site still goes down periodically.is working on a reply...
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.