Sudden Error on IIS

Hi EE,

Lodged one our IIS webservers today to check on an issue and I got the following error message:

PROBLEM
Unable to connect to the database.
The error message returned was:
Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.

Then I restarted the IIS Server

Now, this error message appears.

Runtime Error
Description: An exception occurred while processing your request. Additionally, another exception occurred while executing the custom error page for the first exception. The request has been terminated.

I rebooted the server entirely at this point but the issue still persists.

No updates have applied to the server recently. How would I go about troubleshooting this any assistance is appreciated.

Running windows server 2016 IIS v10.

Thank you.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
NoahHardware Tester and Debugger

Commented:
Hi there! :)

Do you mean error 401? Error 401 means "bad" username or "bad" password.  This would be because you are allowing anonymous access. The anonymous user password specified in the Internet Information Services Microsoft Management Console does not match what is set for the account in user manage. You can try making sure it matches and that should fix the problem.
ZackGeneral IT Goto Guy

Author

Commented:
Hi Noah,

No, I will send a screenshot of the error I am getting.

Thank you.
IIS-Error.PNG
Scott FellDeveloper & EE Moderator
Fellow 2018
Most Valuable Expert 2013

Commented:
Turn off custom errors  to get the actual error.

Look at your database logs. I wonder if there is a process that is running for a long time or using up all your resources. When that happens it may crash your app pool and recycling gets a temporary fix until that happens again.
Acronis in Gartner 2019 MQ for datacenter backup

It is an honor to be featured in Gartner 2019 Magic Quadrant for Datacenter Backup and Recovery Solutions. Gartner’s MQ sets a high standard and earning a place on their grid is a great affirmation that Acronis is delivering on our mission to protect all data, apps, and systems.

ZackGeneral IT Goto Guy

Author

Commented:
Hi Scott,

I turned custom error messages off and rebooted the IIS server the error message hasn't changed.

Any ideas?

Thank you.
Scott FellDeveloper & EE Moderator
Fellow 2018
Most Valuable Expert 2013

Commented:
In manager studio, I would look either under the management tree > SQL Server logs as well as right click on the database  and select Activity Monitor.  Start up the app and observe what is taking place in sql server that may be hogging resources.
ZackGeneral IT Goto Guy

Author

Commented:
Hi Scott,

Just checked nothing there, also restarted the SQL Server still the same issue.

Thank you.
Developer & EE Moderator
Fellow 2018
Most Valuable Expert 2013
Commented:
All I would know to do is check your server logs, site logs and also watch the process monitor when you restart and bring things back up.
ZackGeneral IT Goto Guy

Author

Commented:
Hi Scott,

Great idea I will bring procmon into the mix and see what I find out.

Thank you.
ZackGeneral IT Goto Guy

Author

Commented:
Hi Scott,

Nothing much appeared Procmon that really stood, I will uninstall the IIS web service and reinstall it and see that resolves the issue.

Thank you.
ZackGeneral IT Goto Guy

Author

Commented:
Hi Scott,

Uninstalled-reinstalled the web server this issue now appears in the event logs:

Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 12/12/2019 9:55:58 AM
Event time (UTC): 12/11/2019 11:55:58 PM
Event ID: dcf5eadb8e9049e5adb5294e1c8b1e37
Event sequence: 38
Event occurrence: 5
Event detail code: 0
 
Application information:
    Application domain: /LM/W3SVC/1/ROOT/RiskmanTest-4-132205816528999527
    Trust level: Full
    Application Virtual Path: /RiskmanTest
    Application Path: C:\RiskManNET\RiskMan\
    Machine name: EFSVONTWEB04
 
Process information:
    Process ID: 1636
    Process name: w3wp.exe
    Account name: IIS APPPOOL\DefaultAppPool
 
Exception information:
    Exception type: SqlException
    Exception message: The transaction log for database 'RiskMan_Test' is full due to 'LOG_BACKUP'.
   at RiskManNetData.DataAccessClass.Process(SqlCommand command, Boolean useATrans)
   at RiskManNetSession.SessionClass.set_Item(String Name, Object Value)
   at RiskManNet.RMPage.Page_Init(Object sender, EventArgs e)
   at System.EventHandler.Invoke(Object sender, EventArgs e)
   at System.Web.UI.Control.OnInit(EventArgs e)
   at System.Web.UI.Page.OnInit(EventArgs e)
   at System.Web.UI.Control.InitRecursive(Control namingContainer)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

 
 
Request information:
    Request URL: http://localhost/RiskmanTest/default.aspx 
    Request path: /RiskmanTest/default.aspx
    User host address: ::1
    User:  
    Is authenticated: False
    Authentication Type:  
    Thread account name: IIS APPPOOL\DefaultAppPool
 
Thread information:
    Thread ID: 40
    Thread account name: IIS APPPOOL\DefaultAppPool
    Is impersonating: False
    Stack trace:    at RiskManNetData.DataAccessClass.Process(SqlCommand command, Boolean useATrans)
   at RiskManNetSession.SessionClass.set_Item(String Name, Object Value)
   at RiskManNet.RMPage.Page_Init(Object sender, EventArgs e)
   at System.EventHandler.Invoke(Object sender, EventArgs e)
   at System.Web.UI.Control.OnInit(EventArgs e)
   at System.Web.UI.Page.OnInit(EventArgs e)
   at System.Web.UI.Control.InitRecursive(Control namingContainer)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
 
 
Custom event details:

Looks to be DB issue I will investigate.

Thank you.
ZackGeneral IT Goto Guy

Author

Commented:
The issue was the do transaction Log was full.
ZackGeneral IT Goto Guy

Author

Commented:
Cheers Scott for your help.
ZackGeneral IT Goto Guy

Author

Commented:
Cheers Scott for your help.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial