Transaction isolation level can't be changed while a transac

Transaction isolation level can't be changed while a transac

Postby yuri@wallie.com » Tue 24 Nov 2009 16:25

Hi,

The following error is killing me: do you guys have any idea whatsoever what is happening ?

I'm just simply saving and retrieving simple information from our database using devart linq2sql, i'm not trying to set any transaction level or whatsoever.

This errors occurs randomly, but since i've disabled the query log in mysql (which made the server very slow), it now occurs less often.

-------------------------------------

Server Error in '/' Application.
Transaction isolation level can't be changed while a transaction is in progress
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: Devart.Data.MySql.MySqlException: Transaction isolation level can't be changed while a transaction is in progress

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[MySqlException (0x80004005): Transaction isolation level can't be changed while a transaction is in progress]
Devart.Data.MySql.ai.o() +167
Devart.Data.MySql.ai.c() +108
Devart.Data.MySql.u.a(ae[]& A_0, Int32& A_1) +84
Devart.Data.MySql.u.a(Byte[] A_0, Int32 A_1, Boolean A_2) +76
Devart.Data.MySql.a4.e() +125
Devart.Data.MySql.a4.o() +36
Devart.Data.MySql.MySqlCommand.a(CommandBehavior A_0, IDisposable A_1, Int32 A_2, Int32 A_3) +865
Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior) +178
System.Data.Common.DbCommand.ExecuteReader() +12
Devart.Common.DbCommandBase.ExecuteNonQuery() +34
Devart.Data.MySql.MySqlTransaction..ctor(MySqlConnection A_0, IsolationLevel A_1) +164
Devart.Data.MySql.MySqlInternalConnection.BeginTransaction(IsolationLevel il) +38
Devart.Common.DbConnectionBase.BeginDbTransaction(IsolationLevel isolationLevel) +12
System.Data.Common.DbConnection.BeginTransaction(IsolationLevel isolationLevel) +10
Devart.Common.Web.Providers.DbProfileProvider.GetPropertyValues(SettingsContext context, SettingsPropertyCollection properties) +468

[ProviderException: An exception occurred. Please contact your administrator.]
Devart.Common.Web.Providers.DbProfileProvider.GetPropertyValues(SettingsContext context, SettingsPropertyCollection properties) +1031
System.Configuration.SettingsBase.GetPropertiesFromProvider(SettingsProvider provider) +258
System.Configuration.SettingsBase.GetPropertyValueByName(String propertyName) +132
System.Configuration.SettingsBase.get_Item(String propertyName) +102
System.Web.Profile.ProfileBase.GetInternal(String propertyName) +36
System.Web.Profile.ProfileBase.get_Item(String propertyName) +68
System.Web.Profile.ProfileBase.GetPropertyValue(String propertyName) +7
ProfileCommon.get_firstname() +11
_usermanagement_Default.btn_edit_Click(Object sender, EventArgs e) +329
_usermanagement_Default.btn_add_Click(Object sender, EventArgs e) +70
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +111
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +110
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565


Version Information: Microsoft .NET Framework Version:2.0.50727.3082; ASP.NET Version:2.0.50727.3082
yuri@wallie.com
 
Posts: 27
Joined: Mon 08 Sep 2008 16:37

fixed

Postby yuri@wallie.com » Wed 25 Nov 2009 12:09

Fixed by installing latest version, and increasing connection timeout
yuri@wallie.com
 
Posts: 27
Joined: Mon 08 Sep 2008 16:37


Return to dotConnect for MySQL