invalid request BLR at offset 1094

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

invalid request BLR at offset 1094

Nießen, Yves

Hello,

 

currently i've got a Problem in an WebApi Project and i don't have any clue where it comes from.

It appears since i updated to .Net Prevodier > 5.0.0.0.

Currently I am using .NetProvider 5.0.5.0

 

I'm using ninject to create one DbContext per Request.

Sometimes I am getting the following exception after 1 hour, after 10 hours, after a week.

 

Exception occured: System.Data.Entity.Core.EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details. ---> FirebirdSql.Data.FirebirdClient.FbException: invalid request BLR at offset 1094 context already in use (BLR error) ---> FirebirdSql.Data.Common.IscException: invalid request BLR at offset 1094 context already in use (BLR error)

   bei FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ProcessResponse(IResponse response) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\Version10\GdsDatabase.cs:Zeile 641.

   bei FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadResponse() in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\Version10\GdsDatabase.cs:Zeile 676.

   bei FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadGenericResponse() in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\Version10\GdsDatabase.cs:Zeile 681.

   bei FirebirdSql.Data.Client.Managed.Version11.GdsStatement.Prepare(String commandText) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\Version11\GdsStatement.cs:Zeile 84.

   bei FirebirdSql.Data.FirebirdClient.FbCommand.Prepare(Boolean returnsSet) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:Zeile 1178.

   bei FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior behavior, Boolean returnsSet) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:Zeile 1192.

   bei FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:Zeile 528.

   --- Ende der internen Ausnahmestapelüberwachung ---

   bei FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:Zeile 545.

   bei FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteDbDataReader(CommandBehavior behavior) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:Zeile 639.

   bei System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed)

   bei System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.Reader(DbCommand command, DbCommandInterceptionContext interceptionContext)

   bei System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)

   --- Ende der internen Ausnahmestapelüberwachung ---

   bei System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)

   bei System.Data.Entity.Core.Objects.Internal.ObjectQueryExecutionPlan.Execute[TResultType](ObjectContext context, ObjectParameterCollection parameterValues)

   bei System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess)

   bei System.Data.Entity.Core.Objects.ObjectQuery`1.<>c__DisplayClass3.<GetResults>b__1()

   bei System.Data.Entity.Core.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)

   bei System.Data.Entity.Core.Objects.ObjectQuery`1.<System.Collections.Generic.IEnumerable<T>.GetEnumerator>b__0()

   bei System.Data.Entity.Internal.LazyEnumerator`1.MoveNext()

   bei System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)

   bei System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)

 

 

 

Any hints how to solve this issue?

 

Greetings from Germany,

Yves

 


Mit freundlichen Grüßen
Yves Nießen
Entwickler



Follow us on    

toolbox Software GmbH | Wilhelm-Lexis-Strasse 8 | 52249 Eschweiler | Germany
Phone: +49 - 24 03 - 99 66 34 | Mobile: +49 - 151 - 54 45 15 34 | Fax: +49 - 24 03 - 99 66 70

[hidden email]

toolbox ist spezialisiert auf Entwicklung und Implementierung von
maßgeschneiderten Versandsystemen für Backbetriebe und Partner
von über 750 Anwendern in mehr als 30 Ländern.

Die Pflichtangaben finden Sie hier: www.toolbox-software.com


------------------------------------------------------------------------------
Attend Shape: An AT&T Tech Expo July 15-16. Meet us at AT&T Park in San
Francisco, CA to explore cutting-edge tech and listen to tech luminaries
present their vision of the future. This family event has something for
everyone, including kids. Get more information and register today.
http://sdm.link/attshape
_______________________________________________
Firebird-net-provider mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Reply | Threaded
Open this post in threaded view
|

Re: invalid request BLR at offset 1094

Jiří Činčura-2
Looks like you've made Firebird confused. :) How's the query looking? Is the error really random and other times it runs fine?
 
-- 
Mgr. Jiří Činčura
Independent IT Specialist
 
 
On Tue, Jun 28, 2016, at 08:10, Nießen, Yves wrote:
> Hello,
>
>
>
> currently i've got a Problem in an WebApi Project and i don't have any
> clue where it comes from.
>
> It appears since i updated to .Net Prevodier > 5.0.0.0.
>
> Currently I am using .NetProvider 5.0.5.0
>
>
>
> I'm using ninject to create one DbContext per Request.
>
> Sometimes I am getting the following exception after 1 hour, after 10
> hours, after a week.
>
>
>
> Exception occured:
> System.Data.Entity.Core.EntityCommandExecutionException: An error
> occurred while executing the command definition. See the inner exception
> for details. ---> FirebirdSql.Data.FirebirdClient.FbException: invalid
> request BLR at offset 1094 context already in use (BLR error) --->
> FirebirdSql.Data.Common.IscException: invalid request BLR at offset 1094
> context already in use (BLR error)
>
>    bei
>    FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ProcessResponse(IResponse
>    response) in
>    C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\Version10\GdsDatabase.cs:Zeile
>    641.
>
>    bei
>    FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadResponse()
>    in
>    C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\Version10\GdsDatabase.cs:Zeile
>    676.
>
>    bei
>    FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadGenericResponse()
>    in
>    C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\Version10\GdsDatabase.cs:Zeile
>    681.
>
>    bei
>    FirebirdSql.Data.Client.Managed.Version11.GdsStatement.Prepare(String
>    commandText) in
>    C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\Version11\GdsStatement.cs:Zeile
>    84.
>
>    bei FirebirdSql.Data.FirebirdClient.FbCommand.Prepare(Boolean
>    returnsSet) in
>    C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:Zeile
>    1178.
>
>    bei
>    FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior
>    behavior, Boolean returnsSet) in
>    C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:Zeile
>    1192.
>
>    bei
>    FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior
>    behavior) in
>    C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:Zeile
>    528.
>
>    --- Ende der internen Ausnahmestapelüberwachung ---
>
>    bei
>    FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior
>    behavior) in
>    C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:Zeile
>    545.
>
>    bei
>    FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteDbDataReader(CommandBehavior
>    behavior) in
>    C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:Zeile
>    639.
>
>    bei
>    System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget
>    target, Func`3 operation, TInterceptionContext interceptionContext,
>    Action`3 executing, Action`3 executed)
>
>    bei
>    System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.Reader(DbCommand
>    command, DbCommandInterceptionContext interceptionContext)
>
>    bei
>    System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand
>    entityCommand, CommandBehavior behavior)
>
>    --- Ende der internen Ausnahmestapelüberwachung ---
>
>    bei
>    System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand
>    entityCommand, CommandBehavior behavior)
>
>    bei
>    System.Data.Entity.Core.Objects.Internal.ObjectQueryExecutionPlan.Execute[TResultType](ObjectContext
>    context, ObjectParameterCollection parameterValues)
>
>    bei
>    System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1
>    func, IDbExecutionStrategy executionStrategy, Boolean
>    startLocalTransaction, Boolean releaseConnectionOnSuccess)
>
>    bei
>    System.Data.Entity.Core.Objects.ObjectQuery`1.<>c__DisplayClass3.<GetResults>b__1()
>
>    bei
>    System.Data.Entity.Core.Objects.ObjectQuery`1.GetResults(Nullable`1
>    forMergeOption)
>
>    bei
>    System.Data.Entity.Core.Objects.ObjectQuery`1.<System.Collections.Generic.IEnumerable<T>.GetEnumerator>b__0()
>
>    bei System.Data.Entity.Internal.LazyEnumerator`1.MoveNext()
>
>    bei System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
>
>    bei System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
>
>
>
>
>
>
>
> Any hints how to solve this issue?
>
>
>
> Greetings from Germany,
>
> Yves
>
>
> Mit freundlichen Grüßen
> Yves Nießen
> Entwickler
>
> [cid:image3e2786.GIF@20a3e02d.42acc9c0]<http://www.messe-stuttgart.de/suedback/>
>
> Follow us on [cid:image56de94.PNG@ee89e9ff.4f9e8255]
> <https://www.linkedin.com/company/1169414?trk=vsrp_companies_cluster_name&trkInfo=VSRPsearchId%3A2413476321438776818271%2CVSRPtargetId%3A1169414%2CVSRPcmpt%3Acompanies_cluster>
>  [cid:imageb5e3cc.PNG@5092b274.4abfeb4d]
> <https://twitter.com/tbx_software>
> [cid:image978bb6.PNG@462061e4.4b87def2]
> <https://www.xing.com/companies/toolboxsoftwaregmbh>
> [cid:imagea434eb.PNG@4586128d.41b664c3]
> <http://www.youtube.com/user/toolboxbakery>
>
> toolbox Software GmbH | Wilhelm-Lexis-Strasse 8 | 52249 Eschweiler |
> Germany
> Phone: +49 - 24 03 - 99 66 34 | Mobile: +49 - 151 - 54 45 15 34 | Fax:
> +49 - 24 03 - 99 66 70
>
>
> toolbox ist spezialisiert auf Entwicklung und Implementierung von
> maßgeschneiderten Versandsystemen für Backbetriebe und Partner
> von über 750 Anwendern in mehr als 30 Ländern.
>
> Die Pflichtangaben finden Sie hier:
> www.toolbox-software.com<http://www.toolbox-software.com>
> ------------------------------------------------------------------------------
> Attend Shape: An AT&T Tech Expo July 15-16. Meet us at AT&T Park in San
> Francisco, CA to explore cutting-edge tech and listen to tech luminaries
> present their vision of the future. This family event has something for
> everyone, including kids. Get more information and register today.
> http://sdm.link/attshape
> _______________________________________________
> Firebird-net-provider mailing list
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> Email had 5 attachments:
> + image3e2786.GIF
>   12k (image/gif)
> + image56de94.PNG
>   1k (image/png)
> + imageb5e3cc.PNG
>   1k (image/png)
> + image978bb6.PNG
>   2k (image/png)
> + imagea434eb.PNG
>   1k (image/png)
 

------------------------------------------------------------------------------
Attend Shape: An AT&T Tech Expo July 15-16. Meet us at AT&T Park in San
Francisco, CA to explore cutting-edge tech and listen to tech luminaries
present their vision of the future. This family event has something for
everyone, including kids. Get more information and register today.
http://sdm.link/attshape
_______________________________________________
Firebird-net-provider mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider