Hey
I use the Linq Version 3 of your software for mySQL.
I do have very often a problem with Lost Connection Problem in my Software (Using LinQ and VB.NET)
I have had communicated my problem with the mySQL Enterprise Support. After playing around, the mySQL Engineer means, that the problem could be the Connection pooling of the data provider.
Now, I use pooling=false in my Connection String. And now I sometimes get the following error: The connection was not closed!
Please provide help to this!
THX
URGENT! Pooling Problem
-
StanislavK
- Devart Team
- Posts: 1710
- Joined: Thu 03 Dec 2009 10:48
Could you please describe these issues in more details? For example, please specify the exact messages and stack traces for both errors.
As for the first problem (when pooling is on), please specify the connection string you are using (without the credentials). JIC: did you try setting the 'Validate Connection' connection string parameter to true? Did it help?
Concerning the second issue, please describe the way you are using connections and data contexts. E.g., do you create separate connections and pass them to the data context constructor, or are connections only created internally inside DataContexts?
As for the first problem (when pooling is on), please specify the connection string you are using (without the credentials). JIC: did you try setting the 'Validate Connection' connection string parameter to true? Did it help?
Concerning the second issue, please describe the way you are using connections and data contexts. E.g., do you create separate connections and pass them to the data context constructor, or are connections only created internally inside DataContexts?
Hey
The error with connection pooling = True is as follows:
Devart.Data.Linq.LinqCommandExecutionException: Error on executing DbCommand. ---> Devart.Data.MySql.MySqlException: Lost connection to MySQL server during query ---> System.Net.Sockets.SocketException: Der Vorgang wurde erfolgreich beendet
at Devart.Common.al.b(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Common.at.c(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Common.t.e(Byte[] A_0, Int32 A_1, Int32 A_2)
--- End of inner exception stack trace ---
at Devart.Data.MySql.bh.a(Exception A_0)
at Devart.Common.t.e(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Data.MySql.bk.a(Int32& A_0, Int32& A_1)
at Devart.Data.MySql.bk.a(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Data.MySql.bk.a()
at Devart.Data.MySql.bk.d()
at Devart.Data.MySql.u.a(ag[]& A_0, Int32& A_1)
at Devart.Data.MySql.u.a(Byte[] A_0, Int32 A_1, Boolean A_2)
at Devart.Data.MySql.a1.e()
at Devart.Data.MySql.a1.o()
at Devart.Data.MySql.MySqlCommand.InternalExecute(CommandBehavior behavior, IDisposable stmt, Int32 startRecord, Int32 maxRecords)
at Devart.Common.DbCommandBase.InternalExecute(CommandBehavior behavior, IDisposable stmt, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
at Devart.Data.Linq.Provider.DataProvider.ExecuteQuery(CompiledQuery compiledQuery, Object[] parentArgs, Object[] userArgs, Object lastResult)
--- End of inner exception stack trace ---
at Devart.Data.Linq.LinqCommandExecutionException.CanThrowLinqCommandExecutionException(String message, Exception e)
at Devart.Data.Linq.Provider.DataProvider.ExecuteQuery(CompiledQuery compiledQuery, Object[] parentArgs, Object[] userArgs, Object lastResult)
at Devart.Data.Linq.Provider.DataProvider.ExecuteAllQueries(CompiledQuery compiledQuery, Object[] userArguments)
at Devart.Data.Linq.Provider.DataProvider.CompiledQuery.Devart.Data.Linq.Provider.ICompiledQuery.Execute(IProvider provider, Object[] userArgs)
at Devart.Data.Linq.Provider.DeferredQuery`3.a(TKeyQuery A_0)
at Devart.Data.Linq.Provider.DeferredSource`2.b()
at System.Data.Linq.EntitySet`1.Load()
at System.Data.Linq.EntitySet`1.get_Count()
at System.Windows.Forms.BindingSource.get_Count()
at Janus.Data.TableListHolderRow.a(Int32 )
at Janus.Data.DataHolderRow.a()
at Janus.Data.DataHolderRow.get_DataRow()
at Janus.Data.JanusDataRow.get_DataRow()
at Janus.Windows.GridEX.GridEXRow..ctor(JanusRow logicalRow, GridEX grid)
at Janus.Windows.GridEX.GridEX.g(JanusRow )
at Janus.Windows.GridEX.GridEX.a(Graphics , Boolean )
at Janus.Windows.GridEX.GridEX.a(Graphics )
at Janus.Windows.GridEX.GridEX.e(Graphics )
at Janus.Windows.GridEX.GridEX.R()
at Janus.Windows.GridEX.GridEX.OnPaint(PaintEventArgs e)
at System.Windows.Forms.Control.PaintWithErrorHandling(PaintEventArgs e, Int16 layer)
at System.Windows.Forms.Control.WmPaint(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ContainerControl.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
The validate connection parameter, I will try as next, I haven't had it yet.
I pass "my" connection string every time, I create a new context, because each user needs an other connection string (different databases, with same structure)
The error with connection pooling = True is as follows:
Devart.Data.Linq.LinqCommandExecutionException: Error on executing DbCommand. ---> Devart.Data.MySql.MySqlException: Lost connection to MySQL server during query ---> System.Net.Sockets.SocketException: Der Vorgang wurde erfolgreich beendet
at Devart.Common.al.b(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Common.at.c(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Common.t.e(Byte[] A_0, Int32 A_1, Int32 A_2)
--- End of inner exception stack trace ---
at Devart.Data.MySql.bh.a(Exception A_0)
at Devart.Common.t.e(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Data.MySql.bk.a(Int32& A_0, Int32& A_1)
at Devart.Data.MySql.bk.a(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Data.MySql.bk.a()
at Devart.Data.MySql.bk.d()
at Devart.Data.MySql.u.a(ag[]& A_0, Int32& A_1)
at Devart.Data.MySql.u.a(Byte[] A_0, Int32 A_1, Boolean A_2)
at Devart.Data.MySql.a1.e()
at Devart.Data.MySql.a1.o()
at Devart.Data.MySql.MySqlCommand.InternalExecute(CommandBehavior behavior, IDisposable stmt, Int32 startRecord, Int32 maxRecords)
at Devart.Common.DbCommandBase.InternalExecute(CommandBehavior behavior, IDisposable stmt, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
at Devart.Data.Linq.Provider.DataProvider.ExecuteQuery(CompiledQuery compiledQuery, Object[] parentArgs, Object[] userArgs, Object lastResult)
--- End of inner exception stack trace ---
at Devart.Data.Linq.LinqCommandExecutionException.CanThrowLinqCommandExecutionException(String message, Exception e)
at Devart.Data.Linq.Provider.DataProvider.ExecuteQuery(CompiledQuery compiledQuery, Object[] parentArgs, Object[] userArgs, Object lastResult)
at Devart.Data.Linq.Provider.DataProvider.ExecuteAllQueries(CompiledQuery compiledQuery, Object[] userArguments)
at Devart.Data.Linq.Provider.DataProvider.CompiledQuery.Devart.Data.Linq.Provider.ICompiledQuery.Execute(IProvider provider, Object[] userArgs)
at Devart.Data.Linq.Provider.DeferredQuery`3.a(TKeyQuery A_0)
at Devart.Data.Linq.Provider.DeferredSource`2.b()
at System.Data.Linq.EntitySet`1.Load()
at System.Data.Linq.EntitySet`1.get_Count()
at System.Windows.Forms.BindingSource.get_Count()
at Janus.Data.TableListHolderRow.a(Int32 )
at Janus.Data.DataHolderRow.a()
at Janus.Data.DataHolderRow.get_DataRow()
at Janus.Data.JanusDataRow.get_DataRow()
at Janus.Windows.GridEX.GridEXRow..ctor(JanusRow logicalRow, GridEX grid)
at Janus.Windows.GridEX.GridEX.g(JanusRow )
at Janus.Windows.GridEX.GridEX.a(Graphics , Boolean )
at Janus.Windows.GridEX.GridEX.a(Graphics )
at Janus.Windows.GridEX.GridEX.e(Graphics )
at Janus.Windows.GridEX.GridEX.R()
at Janus.Windows.GridEX.GridEX.OnPaint(PaintEventArgs e)
at System.Windows.Forms.Control.PaintWithErrorHandling(PaintEventArgs e, Int16 layer)
at System.Windows.Forms.Control.WmPaint(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ContainerControl.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
The validate connection parameter, I will try as next, I haven't had it yet.
I pass "my" connection string every time, I create a new context, because each user needs an other connection string (different databases, with same structure)
-
StanislavK
- Devart Team
- Posts: 1710
- Joined: Thu 03 Dec 2009 10:48
As for the first issue, the problem may be caused by expired command timeout. Please specify the value of the 'Default Command Timeout' connection string parameter set for your connections, and the 'wait_timeout' server variable.
Concerning the second error (when the pooling is off), please specify the exact exception message and stack trace for it as well.
Concerning the second error (when the pooling is off), please specify the exact exception message and stack trace for it as well.
Hey
So, I found out more detailed thing.
Connection Pooling = True!
Now, I use the Validate connection property in the connection string. And this brings me to an other error. This looks now this way:
************** Exception Text **************
Devart.Data.Linq.LinqCommandExecutionException: Error on executing DbCommand. ---> Devart.Data.MySql.MySqlException: Lost connection to MySQL server during query ---> Devart.Data.MySql.MySqlException: Lost connection to MySQL server during query ---> Devart.Common.j: Transport channel is closed.
at Devart.Common.t.e(Byte[] A_0, Int32 A_1, Int32 A_2)
--- End of inner exception stack trace ---
at Devart.Common.am.b(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Common.au.c(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Common.t.e(Byte[] A_0, Int32 A_1, Int32 A_2)
--- End of inner exception stack trace ---
at Devart.Data.MySql.bh.a(Exception A_0)
at Devart.Common.t.e(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Data.MySql.bk.a(Int32& A_0, Int32& A_1)
at Devart.Data.MySql.bk.a(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Data.MySql.bk.a()
at Devart.Data.MySql.bk.d()
at Devart.Data.MySql.t.a(ae[]& A_0, Int32& A_1)
at Devart.Data.MySql.t.a(Byte[] A_0, Int32 A_1, Boolean A_2)
at Devart.Data.MySql.a1.e()
at Devart.Data.MySql.a1.o()
at Devart.Data.MySql.MySqlCommand.InternalExecute(CommandBehavior behavior, IDisposable stmt, Int32 startRecord, Int32 maxRecords)
at Devart.Common.DbCommandBase.InternalExecute(CommandBehavior behavior, IDisposable stmt, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
at Devart.Data.Linq.Provider.DataProvider.ExecuteQuery(CompiledQuery compiledQuery, Object[] parentArgs, Object[] userArgs, Object lastResult)
--- End of inner exception stack trace ---
at Devart.Data.Linq.LinqCommandExecutionException.CanThrowLinqCommandExecutionException(String message, Exception e)
at Devart.Data.Linq.Provider.DataProvider.ExecuteQuery(CompiledQuery compiledQuery, Object[] parentArgs, Object[] userArgs, Object lastResult)
at Devart.Data.Linq.Provider.DataProvider.ExecuteAllQueries(CompiledQuery compiledQuery, Object[] userArguments)
at Devart.Data.Linq.Provider.DataProvider.CompiledQuery.Devart.Data.Linq.Provider.ICompiledQuery.Execute(IProvider provider, Object[] userArgs)
at Devart.Data.Linq.Provider.DeferredQuery`3.a(TKeyQuery A_0)
at Devart.Data.Linq.Provider.DeferredSource`2.b()
at System.Data.Linq.EntitySet`1.Load()
at System.Data.Linq.EntitySet`1.get_Count()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at System.Data.Linq.EntitySet`1.GetNewBindingList()
at System.Data.Linq.EntitySet`1.System.ComponentModel.IListSource.GetList()
at System.Windows.Forms.ListBindingHelper.GetList(Object list)
at System.Windows.Forms.ListBindingHelper.GetListItemType(Object list)
at System.Windows.Forms.BindingSource.SetList(IList list, Boolean metaDataChanged, Boolean applySortAndFilter)
at System.Windows.Forms.BindingSource.ResetList()
at System.Windows.Forms.BindingSource.set_DataSource(Object value)
at VOPT.ISAuftrag.SetDetailDaten()
at VOPT.ISAuftrag.rdbFakturiert_CheckedChanged(Object sender, EventArgs e)
at Janus.Windows.EditControls.UIRadioButton.OnCheckedChanged(EventArgs e)
at Janus.Windows.EditControls.UIRadioButton.set_Checked(Boolean value)
at Janus.Windows.EditControls.UIRadioButton.OnClick(EventArgs e)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
************** Loaded Assemblies **************
mscorlib
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.237 (RTMGDR.030319-2300)
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
----------------------------------------
VOPT
Assembly Version: 1.2.1.10
Win32 Version: 1.1.99.9
CodeBase: file:///C:/Program%20Files/Visual%20OPT%20.NET/VOPT.exe
----------------------------------------
Microsoft.VisualBasic
Assembly Version: 10.0.0.0
Win32 Version: 10.0.30319.1 built by: RTMRel
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Microsoft.VisualBasic/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll
----------------------------------------
System
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.236 built by: RTMGDR
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Core
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.233 built by: RTMGDR
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
System.Windows.Forms
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.235 built by: RTMGDR
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1 built by: RTMRel
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
Devart.Data.Linq
Assembly Version: 3.0.4.0
Win32 Version: 3.0.4.0
CodeBase: file:///C:/Program%20Files/Visual%20OPT%20.NET/Devart.Data.Linq.DLL
----------------------------------------
System.Data.Linq
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Data.Linq/v4.0_4.0.0.0__b77a5c561934e089/System.Data.Linq.dll
----------------------------------------
IntelliSoft
Assembly Version: 1.2.0.2
Win32 Version: 1.2.0.2
CodeBase: file:///C:/Program%20Files/Visual%20OPT%20.NET/IntelliSoft.DLL
----------------------------------------
Janus.Windows.GridEX.v4
Assembly Version: 4.0.14.0
Win32 Version: 4.0.14.0
CodeBase: file:///C:/Program%20Files/Visual%20OPT%20.NET/Janus.Windows.GridEX.v4.DLL
----------------------------------------
Janus.Windows.Common.v4
Assembly Version: 4.0.14.0
Win32 Version: 4.0.14.0
CodeBase: file:///C:/Program%20Files/Visual%20OPT%20.NET/Janus.Windows.Common.v4.DLL
----------------------------------------
System.Configuration
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.233 built by: RTMGDR
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Devart.Data.MySql
Assembly Version: 6.50.214.0
Win32 Version: 6.50.214.0
CodeBase: file:///C:/Program%20Files/Visual%20OPT%20.NET/Devart.Data.MySql.DLL
----------------------------------------
System.Data
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.237 (RTMGDR.030319-2300)
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Transactions
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Transactions/v4.0_4.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
Devart.Data
Assembly Version: 5.0.313.0
Win32 Version: 5.0.313.0
CodeBase: file:///C:/Program%20Files/Visual%20OPT%20.NET/Devart.Data.DLL
----------------------------------------
System.EnterpriseServices
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.EnterpriseServices/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------
Devart.Data.MySql.Linq
Assembly Version: 3.0.4.0
Win32 Version: 3.0.4.0
CodeBase: file:///C:/Program%20Files/Visual%20OPT%20.NET/Devart.Data.MySql.Linq.DLL
----------------------------------------
Anonymously Hosted DynamicMethods Assembly
Assembly Version: 0.0.0.0
Win32 Version: 4.0.30319.237 (RTMGDR.030319-2300)
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/mscorlib/v4.0_4.0.0.0__b77a5c561934e089/mscorlib.dll
----------------------------------------
System.Numerics
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1 built by: RTMRel
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Numerics/v4.0_4.0.0.0__b77a5c561934e089/System.Numerics.dll
----------------------------------------
System.Data.OracleClient
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Data.OracleClient/v4.0_4.0.0.0__b77a5c561934e089/System.Data.OracleClient.dll
----------------------------------------
Janus.Windows.UI.v4
Assembly Version: 4.0.14.0
Win32 Version: 4.0.14.0
CodeBase: file:///C:/Program%20Files/Visual%20OPT%20.NET/Janus.Windows.UI.v4.DLL
----------------------------------------
Janus.Windows.ExplorerBar.v4
Assembly Version: 4.0.14.0
Win32 Version: 4.0.14.0
CodeBase: file:///C:/Program%20Files/Visual%20OPT%20.NET/Janus.Windows.ExplorerBar.v4.DLL
----------------------------------------
Janus.Windows.Ribbon.v4
Assembly Version: 4.0.14.0
Win32 Version: 4.0.14.0
CodeBase: file:///C:/Program%20Files/Visual%20OPT%20.NET/Janus.Windows.Ribbon.v4.DLL
----------------------------------------
Janus.Data.v4
Assembly Version: 4.0.14.0
Win32 Version: 4.0.14.0
CodeBase: file:///C:/Program%20Files/Visual%20OPT%20.NET/Janus.Data.v4.DLL
----------------------------------------
DevComponents.DotNetBar2
Assembly Version: 7.0.0.1
Win32 Version: 7.0.0.1
CodeBase: file:///C:/Program%20Files/Visual%20OPT%20.NET/DevComponents.DotNetBar2.DLL
----------------------------------------
Janus.Windows.ButtonBar.v4
Assembly Version: 4.0.14.0
Win32 Version: 4.0.14.0
CodeBase: file:///C:/Program%20Files/Visual%20OPT%20.NET/Janus.Windows.ButtonBar.v4.DLL
----------------------------------------
Janus.Windows.Schedule.v4
Assembly Version: 4.0.14.0
Win32 Version: 4.0.14.0
CodeBase: file:///C:/Program%20Files/Visual%20OPT%20.NET/Janus.Windows.Schedule.v4.DLL
----------------------------------------
Accessibility
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1 built by: RTMRel
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Accessibility/v4.0_4.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------
Janus.Windows.FilterEditor.v4
Assembly Version: 4.0.14.0
Win32 Version: 4.0.14.0
CodeBase: file:///C:/Program%20Files/Visual%20OPT%20.NET/Janus.Windows.FilterEditor.v4.DLL
----------------------------------------
Janus.Windows.CalendarCombo.v4
Assembly Version: 4.0.14.0
Win32 Version: 4.0.14.0
CodeBase: file:///C:/Program%20Files/Visual%20OPT%20.NET/Janus.Windows.CalendarCombo.v4.DLL
----------------------------------------
combit.ListLabel16
Assembly Version: 16.3.4080.25436
Win32 Version: 16.3.0.0
CodeBase: file:///C:/Program%20Files/Visual%20OPT%20.NET/combit.ListLabel16.DLL
----------------------------------------
System.Web
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.237 built by: RTMGDR
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Web/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Web.dll
----------------------------------------
DevExpress.XtraLayout.v11.1
Assembly Version: 11.1.4.0
Win32 Version: 11.1.4.0
CodeBase: file:///C:/Program%20Files/Visual%20OPT%20.NET/DevExpress.XtraLayout.v11.1.DLL
----------------------------------------
DevExpress.Utils.v11.1
Assembly Version: 11.1.4.0
Win32 Version: 11.1.4.0
CodeBase: file:///C:/Program%20Files/Visual%20OPT%20.NET/DevExpress.Utils.v11.1.DLL
----------------------------------------
DevExpress.Data.v11.1
Assembly Version: 11.1.4.0
Win32 Version: 11.1.4.0
CodeBase: file:///C:/Program%20Files/Visual%20OPT%20.NET/DevExpress.Data.v11.1.DLL
----------------------------------------
DevExpress.XtraEditors.v11.1
Assembly Version: 11.1.4.0
Win32 Version: 11.1.4.0
CodeBase: file:///C:/Program%20Files/Visual%20OPT%20.NET/DevExpress.XtraEditors.v11.1.DLL
----------------------------------------
************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.
For example:
When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.
So, The Wait_Timeout of the server is set to 8 hours and the connections timeout is set to 0
THX
So, I found out more detailed thing.
Connection Pooling = True!
Now, I use the Validate connection property in the connection string. And this brings me to an other error. This looks now this way:
************** Exception Text **************
Devart.Data.Linq.LinqCommandExecutionException: Error on executing DbCommand. ---> Devart.Data.MySql.MySqlException: Lost connection to MySQL server during query ---> Devart.Data.MySql.MySqlException: Lost connection to MySQL server during query ---> Devart.Common.j: Transport channel is closed.
at Devart.Common.t.e(Byte[] A_0, Int32 A_1, Int32 A_2)
--- End of inner exception stack trace ---
at Devart.Common.am.b(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Common.au.c(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Common.t.e(Byte[] A_0, Int32 A_1, Int32 A_2)
--- End of inner exception stack trace ---
at Devart.Data.MySql.bh.a(Exception A_0)
at Devart.Common.t.e(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Data.MySql.bk.a(Int32& A_0, Int32& A_1)
at Devart.Data.MySql.bk.a(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Data.MySql.bk.a()
at Devart.Data.MySql.bk.d()
at Devart.Data.MySql.t.a(ae[]& A_0, Int32& A_1)
at Devart.Data.MySql.t.a(Byte[] A_0, Int32 A_1, Boolean A_2)
at Devart.Data.MySql.a1.e()
at Devart.Data.MySql.a1.o()
at Devart.Data.MySql.MySqlCommand.InternalExecute(CommandBehavior behavior, IDisposable stmt, Int32 startRecord, Int32 maxRecords)
at Devart.Common.DbCommandBase.InternalExecute(CommandBehavior behavior, IDisposable stmt, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
at Devart.Data.Linq.Provider.DataProvider.ExecuteQuery(CompiledQuery compiledQuery, Object[] parentArgs, Object[] userArgs, Object lastResult)
--- End of inner exception stack trace ---
at Devart.Data.Linq.LinqCommandExecutionException.CanThrowLinqCommandExecutionException(String message, Exception e)
at Devart.Data.Linq.Provider.DataProvider.ExecuteQuery(CompiledQuery compiledQuery, Object[] parentArgs, Object[] userArgs, Object lastResult)
at Devart.Data.Linq.Provider.DataProvider.ExecuteAllQueries(CompiledQuery compiledQuery, Object[] userArguments)
at Devart.Data.Linq.Provider.DataProvider.CompiledQuery.Devart.Data.Linq.Provider.ICompiledQuery.Execute(IProvider provider, Object[] userArgs)
at Devart.Data.Linq.Provider.DeferredQuery`3.a(TKeyQuery A_0)
at Devart.Data.Linq.Provider.DeferredSource`2.b()
at System.Data.Linq.EntitySet`1.Load()
at System.Data.Linq.EntitySet`1.get_Count()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at System.Data.Linq.EntitySet`1.GetNewBindingList()
at System.Data.Linq.EntitySet`1.System.ComponentModel.IListSource.GetList()
at System.Windows.Forms.ListBindingHelper.GetList(Object list)
at System.Windows.Forms.ListBindingHelper.GetListItemType(Object list)
at System.Windows.Forms.BindingSource.SetList(IList list, Boolean metaDataChanged, Boolean applySortAndFilter)
at System.Windows.Forms.BindingSource.ResetList()
at System.Windows.Forms.BindingSource.set_DataSource(Object value)
at VOPT.ISAuftrag.SetDetailDaten()
at VOPT.ISAuftrag.rdbFakturiert_CheckedChanged(Object sender, EventArgs e)
at Janus.Windows.EditControls.UIRadioButton.OnCheckedChanged(EventArgs e)
at Janus.Windows.EditControls.UIRadioButton.set_Checked(Boolean value)
at Janus.Windows.EditControls.UIRadioButton.OnClick(EventArgs e)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
************** Loaded Assemblies **************
mscorlib
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.237 (RTMGDR.030319-2300)
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
----------------------------------------
VOPT
Assembly Version: 1.2.1.10
Win32 Version: 1.1.99.9
CodeBase: file:///C:/Program%20Files/Visual%20OPT%20.NET/VOPT.exe
----------------------------------------
Microsoft.VisualBasic
Assembly Version: 10.0.0.0
Win32 Version: 10.0.30319.1 built by: RTMRel
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Microsoft.VisualBasic/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll
----------------------------------------
System
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.236 built by: RTMGDR
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Core
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.233 built by: RTMGDR
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
System.Windows.Forms
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.235 built by: RTMGDR
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1 built by: RTMRel
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
Devart.Data.Linq
Assembly Version: 3.0.4.0
Win32 Version: 3.0.4.0
CodeBase: file:///C:/Program%20Files/Visual%20OPT%20.NET/Devart.Data.Linq.DLL
----------------------------------------
System.Data.Linq
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Data.Linq/v4.0_4.0.0.0__b77a5c561934e089/System.Data.Linq.dll
----------------------------------------
IntelliSoft
Assembly Version: 1.2.0.2
Win32 Version: 1.2.0.2
CodeBase: file:///C:/Program%20Files/Visual%20OPT%20.NET/IntelliSoft.DLL
----------------------------------------
Janus.Windows.GridEX.v4
Assembly Version: 4.0.14.0
Win32 Version: 4.0.14.0
CodeBase: file:///C:/Program%20Files/Visual%20OPT%20.NET/Janus.Windows.GridEX.v4.DLL
----------------------------------------
Janus.Windows.Common.v4
Assembly Version: 4.0.14.0
Win32 Version: 4.0.14.0
CodeBase: file:///C:/Program%20Files/Visual%20OPT%20.NET/Janus.Windows.Common.v4.DLL
----------------------------------------
System.Configuration
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.233 built by: RTMGDR
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Devart.Data.MySql
Assembly Version: 6.50.214.0
Win32 Version: 6.50.214.0
CodeBase: file:///C:/Program%20Files/Visual%20OPT%20.NET/Devart.Data.MySql.DLL
----------------------------------------
System.Data
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.237 (RTMGDR.030319-2300)
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Transactions
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Transactions/v4.0_4.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
Devart.Data
Assembly Version: 5.0.313.0
Win32 Version: 5.0.313.0
CodeBase: file:///C:/Program%20Files/Visual%20OPT%20.NET/Devart.Data.DLL
----------------------------------------
System.EnterpriseServices
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.EnterpriseServices/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------
Devart.Data.MySql.Linq
Assembly Version: 3.0.4.0
Win32 Version: 3.0.4.0
CodeBase: file:///C:/Program%20Files/Visual%20OPT%20.NET/Devart.Data.MySql.Linq.DLL
----------------------------------------
Anonymously Hosted DynamicMethods Assembly
Assembly Version: 0.0.0.0
Win32 Version: 4.0.30319.237 (RTMGDR.030319-2300)
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/mscorlib/v4.0_4.0.0.0__b77a5c561934e089/mscorlib.dll
----------------------------------------
System.Numerics
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1 built by: RTMRel
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Numerics/v4.0_4.0.0.0__b77a5c561934e089/System.Numerics.dll
----------------------------------------
System.Data.OracleClient
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Data.OracleClient/v4.0_4.0.0.0__b77a5c561934e089/System.Data.OracleClient.dll
----------------------------------------
Janus.Windows.UI.v4
Assembly Version: 4.0.14.0
Win32 Version: 4.0.14.0
CodeBase: file:///C:/Program%20Files/Visual%20OPT%20.NET/Janus.Windows.UI.v4.DLL
----------------------------------------
Janus.Windows.ExplorerBar.v4
Assembly Version: 4.0.14.0
Win32 Version: 4.0.14.0
CodeBase: file:///C:/Program%20Files/Visual%20OPT%20.NET/Janus.Windows.ExplorerBar.v4.DLL
----------------------------------------
Janus.Windows.Ribbon.v4
Assembly Version: 4.0.14.0
Win32 Version: 4.0.14.0
CodeBase: file:///C:/Program%20Files/Visual%20OPT%20.NET/Janus.Windows.Ribbon.v4.DLL
----------------------------------------
Janus.Data.v4
Assembly Version: 4.0.14.0
Win32 Version: 4.0.14.0
CodeBase: file:///C:/Program%20Files/Visual%20OPT%20.NET/Janus.Data.v4.DLL
----------------------------------------
DevComponents.DotNetBar2
Assembly Version: 7.0.0.1
Win32 Version: 7.0.0.1
CodeBase: file:///C:/Program%20Files/Visual%20OPT%20.NET/DevComponents.DotNetBar2.DLL
----------------------------------------
Janus.Windows.ButtonBar.v4
Assembly Version: 4.0.14.0
Win32 Version: 4.0.14.0
CodeBase: file:///C:/Program%20Files/Visual%20OPT%20.NET/Janus.Windows.ButtonBar.v4.DLL
----------------------------------------
Janus.Windows.Schedule.v4
Assembly Version: 4.0.14.0
Win32 Version: 4.0.14.0
CodeBase: file:///C:/Program%20Files/Visual%20OPT%20.NET/Janus.Windows.Schedule.v4.DLL
----------------------------------------
Accessibility
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1 built by: RTMRel
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Accessibility/v4.0_4.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------
Janus.Windows.FilterEditor.v4
Assembly Version: 4.0.14.0
Win32 Version: 4.0.14.0
CodeBase: file:///C:/Program%20Files/Visual%20OPT%20.NET/Janus.Windows.FilterEditor.v4.DLL
----------------------------------------
Janus.Windows.CalendarCombo.v4
Assembly Version: 4.0.14.0
Win32 Version: 4.0.14.0
CodeBase: file:///C:/Program%20Files/Visual%20OPT%20.NET/Janus.Windows.CalendarCombo.v4.DLL
----------------------------------------
combit.ListLabel16
Assembly Version: 16.3.4080.25436
Win32 Version: 16.3.0.0
CodeBase: file:///C:/Program%20Files/Visual%20OPT%20.NET/combit.ListLabel16.DLL
----------------------------------------
System.Web
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.237 built by: RTMGDR
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Web/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Web.dll
----------------------------------------
DevExpress.XtraLayout.v11.1
Assembly Version: 11.1.4.0
Win32 Version: 11.1.4.0
CodeBase: file:///C:/Program%20Files/Visual%20OPT%20.NET/DevExpress.XtraLayout.v11.1.DLL
----------------------------------------
DevExpress.Utils.v11.1
Assembly Version: 11.1.4.0
Win32 Version: 11.1.4.0
CodeBase: file:///C:/Program%20Files/Visual%20OPT%20.NET/DevExpress.Utils.v11.1.DLL
----------------------------------------
DevExpress.Data.v11.1
Assembly Version: 11.1.4.0
Win32 Version: 11.1.4.0
CodeBase: file:///C:/Program%20Files/Visual%20OPT%20.NET/DevExpress.Data.v11.1.DLL
----------------------------------------
DevExpress.XtraEditors.v11.1
Assembly Version: 11.1.4.0
Win32 Version: 11.1.4.0
CodeBase: file:///C:/Program%20Files/Visual%20OPT%20.NET/DevExpress.XtraEditors.v11.1.DLL
----------------------------------------
************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.
For example:
When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.
So, The Wait_Timeout of the server is set to 8 hours and the connections timeout is set to 0
THX
-
StanislavK
- Devart Team
- Posts: 1710
- Joined: Thu 03 Dec 2009 10:48
Please specify the following:
- an approximate (without the credentials) connection string you are using; in particular, do you use security protocols (SSH or SSL)?
- the version of your MySQL server;
- the command(s) being executed when you encounter this problem.
Also, the issue may occur if you are working with a single connection or DataContext instance in several threads. Please specify if this is the case.
If possible, please send us a small test project with which the issue can be reproduced. E.g., you can try executing a command for which this error occurred in a loop.
- an approximate (without the credentials) connection string you are using; in particular, do you use security protocols (SSH or SSL)?
- the version of your MySQL server;
- the command(s) being executed when you encounter this problem.
Also, the issue may occur if you are working with a single connection or DataContext instance in several threads. Please specify if this is the case.
If possible, please send us a small test project with which the issue can be reproduced. E.g., you can try executing a command for which this error occurred in a loop.
Connection String:
mySQL Version:
THX
So, I use SSL! not SSHUser Id=***;Password=***;Host=localhost;Port=33??;Database="** **";Compress=True;Protocol=Ssl;Persist Security Info=True;Connection Timeout=0;Validate Connection=True;SSL CA Cert=resource://VOPT.ca-cert.pem;SSL Cert=resource://VOPT.client-cert.pem;SSL Key=resource://VOPT.client-key.pem;
mySQL Version:
I will try to create a sample and I will send it to you tomorrow.5.5.15-enterprise-commercial-advanced-log
THX
-
StanislavK
- Devart Team
- Posts: 1710
- Joined: Thu 03 Dec 2009 10:48
-
StanislavK
- Devart Team
- Posts: 1710
- Joined: Thu 03 Dec 2009 10:48