Driver Broken since Release 5.10.126

Huizensoft · Post by **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 · Post by **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:

StanislavK · Post by **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.

rjbrookhuis · Post by **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)

AndreyR · Post by **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?

rjbrookhuis · Post by **rjbrookhuis** » Tue 19 Apr 2011 07:57

We are using version 9.0.3

AndreyR · Post by **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.

Huizensoft · Post by **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 · Post by **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...

Devart Forums

Driver Broken since Release 5.10.126

Driver Broken since Release 5.10.126

Full Exception

I can confirm that: Driver Broken since Release 5.10.126

Postgres version