Hello,
I ran into a strange problem.
I have my ASP.NET web application running on a shared webhost account.
Normally this works like a charm.
However, today, the application pool was being shut down. I know because I logged the following message in my db log:
Application is shutting down. Reason: Hosting environment is shutting down.
I log this using the ASP.NET HealthMonitor option.
12 minutes after that event, I receive the first HTTP request. It fails. I've logged this succesfully in the database.
The exception being:
An exception was caught during the execution of an action query: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server). Check InnerException, QueryExecuted and Parameters of this exception to examine the cause of this exception.Could not find a HttpHandler.
Stacktrace being:
at SD.LLBLGen.Pro.ORMSupportClasses.ActionQuery.Execute()
at SD.LLBLGen.Pro.ORMSupportClasses.BatchActionQuery.Execute()
at SD.LLBLGen.Pro.ORMSupportClasses.DaoBase.ExecuteActionQuery(IActionQuery queryToExecute, ITransaction containingTransaction)
at SD.LLBLGen.Pro.ORMSupportClasses.DaoBase.AddNew(IEntityFields fields, ITransaction containingTransaction)
at TopLib.DAL.Mambo.EntityClasses.Sys_EventLogEntity.InsertEntity() in C:\vsdev\TopWebPlatform\TopLib\DAL\Mambo\EntityClasses\Sys_EventLogEntity.cs:line 554
at SD.LLBLGen.Pro.ORMSupportClasses.DaoBase.PersistQueue(List1 queueToPersist, Boolean insertActions, ITransaction transactionToUse, Int32& totalAmountSaved)
at SD.LLBLGen.Pro.ORMSupportClasses.EntityBase.Save(IPredicate updateRestriction, Boolean recurse)
at SD.LLBLGen.Pro.ORMSupportClasses.EntityBase.Save()
at TopLib.AppMod.Kernel.BL.EventLog.LogException(TopRequestContext topRequest, EventType eventType, Exception e, String message, Nullable
1 outerExceptionLogId) in C:\vsdev\TopWebPlatform\TopLib\AppMod\Kernel\BL\EventLog\EventLog.cs:line 158
at TopLib.AppMod.Kernel.BL.EventLog.LogCriticalException(Exception e, String message) in C:\vsdev\TopWebPlatform\TopLib\AppMod\Kernel\BL\EventLog\EventLog.cs:line 83
at TopLib.AppMod.Kernel.BL.TopApp..cctor() in C:\vsdev\TopWebPlatform\TopLib\AppMod\Kernel\BL\TopApp\TopApp.cs:line 55
The innerexception being:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server).
the innerexception stacktrace being:
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at SD.LLBLGen.Pro.ORMSupportClasses.ActionQuery.Execute()
I simply don't get it. The system reports that we cannot connect to the database. The same database is used when logging the error and that does work fine! Strange?
This means that the database does not suffer a problem, otherwise I could not log it this way.
Does anyone have any idea on how to solve this?
Thanx,
Paul
ps.Using:
Selfservice, version 2.6 Final. Sept 12th 2008