I am struggling with the following for some time now and have tried many suggestions from various google searches.
We have one Website running in Classic ASP on a windows server 2012 R2 using IIS 8.5
We use the website with MySQL
We get this happening during the day but at different times and I suspect this to be when the site gets busy or many queries. ( Not sure )
In The Event Viewer ( Applications ) we get Active Server Pages Errors.
When this happen the pages that tries to make queries to MySQL will just respond with Error 500 ( Internal Error ).
There are a few types of the errors and below are some:
The below error can happen for many different pages and this is just example of the last one.
Error: File /update-project.asp CreateObject Exception. The CreateObject of '(null)' caused exception C0000005..
The there are also this type of Application errors. This is a example of the last one:
Faulting application name: w3wp.exe, version: 8.5.9600.16384, time stamp: 0x52157ba0
Faulting module name: ntdll.dll, version: 6.3.9600.18895, time stamp: 0x5a4b127e
Exception code: 0xc0000374
Fault offset: 0x000e6214
Faulting process id: 0x2cd0
Faulting application start time: 0x01d3b5ffb8b88f62
Faulting application path: C:\Windows\SysWOW64\inetsrv\w3wp.exe
Faulting module path: C:\Windows\SYSTEM32\ntdll.dll
Report Id: c17383f3-21f4-11e8-80f1-0cc47adae555
Faulting package full name:
Faulting package-relative application ID:
I have tried changing quite a few things as suggested by other posts from the applicationpool settings, increasing the MySQL buffer size, and more.
As soon as this happens, I do a ApplicationPool Recycle and the problem goes away.
I have download DebugDiag 2 and created a rule for the w3wp.exe process and when this happens recorded a few dump files.
I then open the analyzer and analyze them but I do not seem to see how figure out how to read or interpret them to what could be the problem.
Is there a way I can post or provide these dump files for someone to try and help me because I am at the point pulling my hair out.
I look forward to any response from anyone that can help me or guide me in the right direction or even point me to try other things.
Thanks in advance
Below are 3 examples of connecting to MySQL and using the FileSystemObject as well as getting data from external API. Does anything from these eamples look incorrect that could cause this because it does not happen all the time, is random and can be on any of my pages and not always the same one.
sConnection = "DRIVER={MySQL ODBC 5.3 ANSI Driver}; SERVER=localhost; PORT=3306;" &_
"DATABASE=accufilemain; USER=myuser; PASSWORD=mypassword; OPTION=3;"
Set con = Server.CreateObject("ADODB.Connection")
con.Open(sConnection)
sql_check = "Select * From clients Where id = " & ClientID
Set RS = con.Execute(sql_check)
If Not RS.EOF Then
'''Get my field values
ValABC = RS("CustomerID")
End If
State = RS.State
If State <> 0 Then
RS.Close
Set RS = Nothing
End If
con.Close
Set con = Nothing
sFolder1 = "C:\inetpub\wwwroot\mywebsite\files\" & ClientID
Set fs=CreateObject("Scripting.FileSystemObject")
If Not fs.FolderExists(sFolder1) Then
fs.CreateFolder(sFolder1)
End If
Set fs = nothing
GetURL = ""
set objHttp = Server.CreateObject("Msxml2.ServerXMLHTTP")
objHttp.open "GET", "otherwebsite/api/1.1.2/Customer/Get?$skip=" & MyVAL4 & "&$top=100&apikey=" & Myapikey & "&CompanyId=" & MyCompanyId, false
objHttp.setRequestHeader "Authorization", "Basic " & MyBase64AuthDetails
objHttp.setRequestHeader "Content-Type", "application/json"
objHttp.Send
GetURL = objHttp.ResponseText
Set objHttp = Nothing
'''' Then I can search GetURL for what I need as a string.
