not exact problem

my site has healthmonitoring which helps me to get exceptions via mail. there is something wrong about it which I am not sure yet.

I took about 15 mails in a day about data parts of my site. I think its about the overloading http://www.motosikletpazari.com which takes about 350 visits in a day and makes about 3500 page view and normally it works perfectly fine. the site looks fine and fast to me. but still there are unexplainable sql data reading errors.

some of them

Exception information:
Exception type: System.ArgumentException
Exception message: Column 'markaName' does not belong to table Table.

Request information:
Request URL: http://www.motosikletpazari.com/search.aspx?tur=6
Request path: /search.aspx
User host address: 85.100.96.69
User:
Is authenticated: False
Authentication Type:
Thread account name: WEB131\aspnet_241450

Thread information:
Thread ID: 5
Thread account name: WEB131\aspnet_241450
Is impersonating: False
Stack trace: at System.Data.DataRow.GetDataColumn(String columnName)
at System.Data.DataRow.get_Item(String columnName)
at Search.Page_Load(Object sender, EventArgs e) in e:\web\motosiklet1\htdocs\Search.aspx.cs:line 37

Exception information:
Exception type: System.Data.SqlClient.SqlException
Exception message: Server failed to resume the transaction, desc: 650000033c.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Request information:
Request URL: http://www.motosikletpazari.com/default.aspx
Request path: /default.aspx
User host address: 213.74.116.50
User: china
Is authenticated: True
Authentication Type: Forms
Thread account name: WEB131\aspnet_241450

Thread information:
Thread ID: 1
Thread account name: WEB131\aspnet_241450
Is impersonating: False
Stack trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at dbRelated.dbSelect(String SQL) in e:\web\motosiklet1\htdocs\App_Code\dbRelated.cs:line 44
at Bussiness.getUcuzlar() in e:\web\motosiklet1\htdocs\App_Code\Bussiness.cs:line 43
at Controls_Last6.Page_Load(Object sender, EventArgs e) in e:\web\motosiklet1\htdocs\Controls2\default.ascx.cs:line 102
at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

like I told site works fast and fine but how can I solve these problems ?

 

1) that markaName column is there and its working normally. there is nothing to fix about it.
2) I use asp.net 2 and sql 2005 and all .net stuff no java. btw I dont call stored procs.

 

"Exception message: Column 'markaName' does not belong to table Table."

You have a table named Table? Are you 100% sure you have a column named 'markaName' in table 'Table' ? Also could you be querying a second base that doesn't have the table 'Table' or 'markaName' column?





Joel Thoms
DiscountASP.NET
http://www.DiscountASP.NET

 

in table markalar. you see there is markaName there is no table that I have which named as 'Table'
ID int Unchecked
markaName nvarchar(50) Unchecked

in search there are a lot of options and tables to check which generates a long SQL sometimes it like this:

select distinct dbo.advertisement.ID, dbo.advertisement.userID, CAST(dbo.advertisement.fiyat AS money) AS fiyat, dbo.advertisement.modelName, dbo.advertisement.motorHacmi, dbo.advertisement.renk, dbo.advertisement.kiloMetre, dbo.advertisement.yil, dbo.advertisement.tur, dbo.advertisement.kimden, dbo.advertisement.advertisementBaslangicDate, dbo.advertisement.advertisementBitisDate, dbo.advertisement.advertisementGirisDate, dbo.advertisement.anonymStatistic, dbo.advertisement.userStatistic, dbo.advertisement.lastVisitorsID, SUBSTRING(dbo.advertisement.aciklama, 0, 20) AS aciklama, dbo.modeller.tipAdi, dbo.markalar.markaName, dbo.city.name, dbo.county.name AS ilceadi, dbo.tipler.name AS tipismi, dbo.advertisement.isimSoyisim, dbo.advertisement.Telefon, dbo.advertisement.EMail, dbo.advertisement.havePhoto from dbo.advertisement left outer JOIN dbo.modeller ON dbo.advertisement.modelName = dbo.modeller.tipAdi INNER JOIN dbo.markalar ON dbo.advertisement.markaID = dbo.markalar.ID INNER JOIN dbo.city ON dbo.advertisement.cityID = dbo.city.ID INNER JOIN dbo.county ON dbo.advertisement.countyID = dbo.county.ID INNER JOIN dbo.tipler ON dbo.advertisement.tipID = dbo.tipler.ID where dbo.advertisement.enable=1 and advertisement.tipID=3 order by dbo.advertisement.advertisementBaslangicDate desc

I can run this query on my database and its working. I am %100 sure of that I dont have a table as 'Table' and I am %100 sure this query working.

 

https://my.discountasp.net/mssql2005-manager.aspx

Unavailable at this time.

I dunno why. strange is it just me thinking that sql 2005 service is little bit unprofessional or just shit happens ? btw before discountasp I used to work with another hosting they have this kind of unstable sql 2005 service thats why I choosed to move discountasp. maybe just sql2005 is a bad database I lost my trust on it.