Driver Broken since Release 5.10.126

Driver Broken since Release 5.10.126

Postby Huizensoft » Mon 11 Apr 2011 19:57

All LinqToSql and most on Command are broken since version 5.10.126.
When trying to use PostgreSQL version 9.0.3

Give this excetion..

Unexpected server response.

If I rollback to version 5.10.121 everything works fine.

DONT YOU TEST YOUR CODE BEFORE RELEASING!!
Huizensoft
 
Posts: 5
Joined: Mon 11 Apr 2011 19:48

Full Exception

Postby Huizensoft » Mon 11 Apr 2011 20:15

Devart.Data.Linq.LinqCommandExecutionException was unhandled by user code
Message=Error on executing DbCommand.
Source=Devart.Data.Linq
StackTrace:
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.DataQuery`1.i()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at Definitive.Business.Ledger.CompanyDictionary.LookupAllList(DateTime trxDate, Boolean open, String status) in C:\Develop\DefinitiveERP\Dev\Src\Business\Ledger\CompanyDictionary.cs:line 20
at Definitive.Debtor.Quotation.SaleMain.SaleMain_Load(Object sender, EventArgs e)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Windows.Forms.Form.OnLoad(EventArgs e)
at System.Windows.Forms.Form.OnCreateControl()
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl()
at System.Windows.Forms.Control.WmShowWindow(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.Form.WmShowWindow(Message& m)
at System.Windows.Forms.Form.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)
InnerException: Devart.Data.PostgreSql.PgSqlException
Message=Unexpected server response.
Source=Devart.Data.PostgreSql
ErrorCode=-2147467259
LineNumber=0
Position=0
StackTrace:
at Devart.Data.PostgreSql.j.a(Char A_0, Boolean A_1, Boolean A_2)
at Devart.Data.PostgreSql.s.a(Char A_0, Boolean A_1, Boolean A_2)
at Devart.Data.PostgreSql.j.a(Boolean A_0, Boolean A_1, Char A_2, Boolean A_3)
at Devart.Data.PostgreSql.s.g(ae A_0)
at Devart.Data.PostgreSql.s.e(ae A_0)
at Devart.Data.PostgreSql.ae.ah()
at Devart.Data.PostgreSql.PgSqlCommand.InternalPrepare(Boolean implicitPrepare, Int32 startRecord, Int32 maxRecords)
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)
InnerException:
Huizensoft
 
Posts: 5
Joined: Mon 11 Apr 2011 19:48

Postby StanislavK » Wed 13 Apr 2011 11:56

Could you please specify the following, so that we are able to analyze the issue in more details:
- the connection string (at least approximate) you are using;
- the LINQ query and/or the generated SQL with which this error occurs.

If possible, please also send us a small project with which this issue can be reproduced. At the moment, we couldn't reproduce it in our environment.
StanislavK
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

I can confirm that: Driver Broken since Release 5.10.126

Postby rjbrookhuis » Fri 15 Apr 2011 14:19

I have a similar problem.
Problem disappears when rolling back to 5.10.121.

Stacktrace:

15-04-11 15:29:50 [Web.Global.Application_Error] ERROR System.Web.HttpUnhandledException (0x80004005): Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.NullReferenceException: Object reference not set to an instance of an object.
at Devart.Common.Entity.s.a(bm A_0, EntitySetBase A_1)
at Devart.Common.Entity.s.b(b A_0, StringBuilder A_1, b8 A_2)
at Devart.Common.Entity.s.a(b A_0, DbCommand A_1)
at Devart.Common.Entity.an.a(b A_0, DbCommandBase A_1)
at Devart.Common.Entity.an.c()
at Devart.Data.PostgreSql.Entity.PgSqlEntityProviderServices.a(DbCommandTree A_0, DbProviderManifest A_1)
at Devart.Data.PostgreSql.Entity.PgSqlEntityProviderServices.CreateDbCommandDefinition(DbProviderManifest providerManifest, DbCommandTree commandTree)
at System.Data.Common.DbProviderServices.CreateCommandDefinition(DbCommandTree commandTree)
at System.Data.Common.DbProviderServices.CreateCommand(DbCommandTree commandTree)
at System.Data.Mapping.Update.Internal.UpdateTranslator.CreateCommand(DbModificationCommandTree commandTree)
at System.Data.Mapping.Update.Internal.DynamicUpdateCommand.CreateCommand(UpdateTranslator translator, Dictionary`2 identifierValues)
at System.Data.Mapping.Update.Internal.DynamicUpdateCommand.Execute(UpdateTranslator translator, EntityConnection connection, Dictionary`2 identifierValues, List`1 generatedValues)
at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter)
at System.Data.EntityClient.EntityAdapter.Update(IEntityStateManager entityCache)
at System.Data.Objects.ObjectContext.SaveChanges(SaveOptions options)
at System.Data.Objects.ObjectContext.SaveChanges()
at MyApp.Business.Dal.BaseDal`1.Save(EntityObject entityObject, User user) in C:\Users\Me\Documents\Visual Studio 2010\Projects\MyApp\Data\Dal\BaseDal.cs:line 165
at MyApp.Business.BaseLogic`2.Update(TEntity entity, User user) in C:\Users\Me\Documents\Visual Studio 2010\Projects\MyApp\Business\Logics\BaseLogic.cs:line 57
at MyApp.Presenters.DetailsPresenter`1.Update(TEntity entity) in C:\Users\Me\Documents\Visual Studio 2010\Projects\MyApp\Presenters\DetailsPresenter.cs:line 90
--- End of inner exception stack trace ---
at System.RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
at System.RuntimeMethodHandle.InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at System.Reflection.MethodBase.Invoke(Object obj, Object[] parameters)
at MyControls.DataSourceWrapper.Invoke(MethodInfo method, Object[] parameters) in C:\Users\Me\Documents\Visual Studio 2010\Projects\MyObjectDataSource\DataSourceWrapper.cs:line 225
at MyControls.DataSourceWrapper.Update(Object obj) in C:\Users\Me\Documents\Visual Studio 2010\Projects\MyObjectDataSource\DataSourceWrapper.cs:line 85
at MyControls.MyObjectDataSourceView.ExecuteUpdate(IDictionary keys, IDictionary values, IDictionary oldValues) in C:\Users\Me\Documents\Visual Studio 2010\Projects\MyObjectDataSource\MyObjectDataSourceView.cs:line 101
at System.Web.UI.DataSourceView.Update(IDictionary keys, IDictionary values, IDictionary oldValues, DataSourceViewOperationCallback callback)
at System.Web.UI.WebControls.DetailsView.HandleUpdate(String commandArg, Boolean causesValidation)
at System.Web.UI.WebControls.DetailsView.HandleEvent(EventArgs e, Boolean causesValidation, String validationGroup)
at System.Web.UI.WebControls.DetailsView.OnBubbleEvent(Object source, EventArgs e)
at System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)
at System.Web.UI.WebControls.DetailsViewRow.OnBubbleEvent(Object source, EventArgs e)
at System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)
at Telerik.Web.UI.RadButton.OnCommand(ButtonCommandEventArgs e)
at Telerik.Web.UI.RadButton.RaisePostBackEvent(String eventArgument)
at Telerik.Web.UI.RadButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.HandleError(Exception e)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest()
at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
at System.Web.UI.Page.ProcessRequest(HttpContext context)
at ASP.security_userdetails_aspx.ProcessRequest(HttpContext context) in c:\Users\Me\AppData\Local\Temp\Temporary ASP.NET Files\root\078b3967\1c6b4fd2\App_Web_afudeacy.2.cs:line 0
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
rjbrookhuis
 
Posts: 2
Joined: Fri 15 Apr 2011 14:06

Postby AndreyR » Mon 18 Apr 2011 15:51

Thank you for the report. We are investigating the issue.
Could you please specify the version of your PostgreSQL server?
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postgres version

Postby rjbrookhuis » Tue 19 Apr 2011 07:57

We are using version 9.0.3
rjbrookhuis
 
Posts: 2
Joined: Fri 15 Apr 2011 14:06

Postby AndreyR » Tue 19 Apr 2011 13:43

We have fixed a similar problem in the upcoming Beta build to be released later this month.
Please let us know if the error persists in it.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby Huizensoft » Tue 19 Apr 2011 20:36

I have found this in the server log.


2011-04-19 22:32:14 CAT LOG: could not receive data from client: No connection could be made because the target machine actively refused it.


2011-04-19 22:32:14 CAT LOG: unexpected EOF on client connection


Still trying to track down problem.
I am now trying 5.10.141.0
This version still have the problem.
Huizensoft
 
Posts: 5
Joined: Mon 11 Apr 2011 19:48

Postby Huizensoft » Tue 19 Apr 2011 20:58

I may have found the problem.
I use the PgSqlConnection ping command to validate connection.
After that you get a hole list of errors.

When excluding the ping command everything works fine for me.

Hope this helps...
Huizensoft
 
Posts: 5
Joined: Mon 11 Apr 2011 19:48


Return to dotConnect for PostgreSQL