An unhandled win32 exception occurred in w3wp.exe event 1023 NET Runtime version 2.0.50727.4206

Server 2008 Standard x64 SP2
sqlserver 2008 X64
.net framework 3.5
IIS7

server console offten show error. it's a .net website(www.51yunli.com) error.
The error happen several times a day. but sometimes it happend more than 10 times in one hour.

when error happen this website app pool will be rebooted.
mostly w3wp.exe cost about 700M memory, peak memory cost about 1.2G

An unhandled win32 exception occurred in w3wp.exe

eventlog
event 1023,.NET Runtime
NET Runtime version 2.0.50727.4206 -

yzhou_cnAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

pcsmitpraConsultantCommented:
Since when you started getting this error? Quickly check if you got any security update on the server before the problem birthed.
Please paste what error you are getting that time on the browser. Do you see any error in event viewer also?
Jesse HouwingScrum Trainer | Microsoft MVP | ALM Ranger | ConsultantCommented:
It sounds like you have a memory leak in your application, which is causing IIS to recycle the apppool in order to clear the memory.
yzhou_cnAuthor Commented:
thanks for the quick comments.

there are some error  on browser.  but the error can't always be reproduced. when refresh the page the error will be disappeared.
I also guess it may caused by memory leak. how can I find the file which make the memory leak ?

I copy the web site and DB to test server with same configration. but I can't meet the these same errors. the error happen after  the visit from  the customer or  search engine like google.

errors  when open some page.
HttpException (0x80004005): DataBinding:'System.Data.DataRowView' does not contain a property with the URL

   System.Web.UI.DataBinder.GetPropertyValue(Object container, String propName) +10997589
   System.Web.UI.DataBinder.Eval(Object container, String[] expressionParts) +148
   ASP.usercontrols_friendlinks_ascx.__DataBind__control3(Object sender, EventArgs e) +119
   System.Web.UI.Control.OnDataBinding(EventArgs e) +132
   System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +170


"Server Error in '/' Application.
--------------------------------------------------------------------------------

DataBinding:'System.Data.DataRowView' does not contain a property with the URL

stack track:

[HttpException (0x80004005): DataBinding:'System.Data.DataRowView' does not contain a property with the URL]
   System.Web.UI.DataBinder.GetPropertyValue(Object container, String propName) +10997589
   System.Web.UI.DataBinder.Eval(Object container, String[] expressionParts) +148

 

"Server Error in '/' Application.
--------------------------------------------------------------------------------

couldn't  find table 1¿
IndexOutOfRangeException: couldn't  find table 1¿]
   System.Data.DataTableCollection.get_Item(Int32 index) +3150162
   DAL.Goods.getListForSearch(Int32 startid, Int32 destinationid, Int32 currpage, DateTime startdate, String key, Int32& total, DataTable& goodslist) +1639
   BLL.Goods.getListForSearch(Int32 startid, Int32 destinationid, Int32 currpage, DateTime startdate, String key, Int32& total, DataTable& goodslist) +175


"Server Error in '/' Application.
--------------------------------------------------------------------------------

Exception Details: System.IndexOutOfRangeException: Title

source error:

stack track:


[IndexOutOfRangeException: Title]
   System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName) +2674398
   System.Data.SqlClient.SqlDataReader.GetOrdinal(String name) +249
   System.Data.SqlClient.SqlDataReader.get_Item(String name) +23
   DataOpetate.SQLServer.BaseOperate.GetModelBySql(BaseModel baseinfo, String tablename, Boolean isSinglePrimay) +6067
   DAL.Goods.getModel(Int32 id) +152
   BLL.Goods.getModel(Int32 id) +80
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

Jesse HouwingScrum Trainer | Microsoft MVP | ALM Ranger | ConsultantCommented:
These errors you've posted have nothing to do with a Win32 error, but are worrysome. It looks like your software contains a few bugs or is swallowing exceptions and returning empty datasets when error occur. But it's hard to pinpoint.

Check the code that normally loads the data containing the URL property and make sure that the property is still being returned from the database (is part of the select statement in the query).

Also check for any parts where there are try/catch blocks that cause Datasets and tables to be returned without data, and where the actual error isn't rethrown or properly handled.

It looks like these methods are a candidate:
   DAL.Goods.getListForSearch(Int32 startid, Int32 destinationid, Int32 currpage, DateTime startdate, String key, Int32& total, DataTable& goodslist) +1639
   BLL.Goods.getListForSearch(Int32 startid, Int32 destinationid, Int32 currpage, DateTime startdate, String key, Int32& total, DataTable& goodslist) +175

As are the other methods being referenced from your code:
   DataOpetate.SQLServer.BaseOperate.GetModelBySql(BaseModel baseinfo, String tablename, Boolean isSinglePrimay) +6067
   DAL.Goods.getModel(Int32 id) +152
   BLL.Goods.getModel(Int32 id) +80

But these methods don't look like they're causing memory issues or native exceptions. Without letting us see some of your code it would be very hard to help you.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
yzhou_cnAuthor Commented:
thanksg, try/catch  can avoid the error page display. but can not solve the root issue. here I upload some flies. please help to check.  Goods.cs Goods.cs Line.cs
BaseOperate.cs
MyCache.cs
LineStatistic.cs
yzhou_cnAuthor Commented:
SqlConnection Do not use global or static. otherwise it will share the connection of different process . the solution is to to use the new connection. and close it  after use.
yzhou_cnAuthor Commented:
the issue was fixed  after  using new connection in sqlhelp.cs
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
.NET App Servers

From novice to tech pro — start learning today.