Leonard Wennekers (JIRA | 29 Jun 14:14 2016

[FB-Tracker] Created: (DNET-687) rollback the upgrade by using dbmigrator update("0") fails

rollback the upgrade by using dbmigrator update("0") fails
----------------------------------------------------------

                 Key: DNET-687
                 URL: http://tracker.firebirdsql.org/browse/DNET-687
             Project: .NET Data provider
          Issue Type: Bug
          Components: Entity Framework support
    Affects Versions: 5.0.5.0
         Environment: windows 7 / firebird 2.5.2 / ef 6.1.3
            Reporter: Leonard Wennekers
            Assignee: Jiri Cincura

The following exception occurred:

Test
'IOLAN.Context.Migration.UnitTests.UnitTestContextManagerFirebird.TestContextMigration'
failed: System.InvalidCastException : Can't convert typee
System.Data.Entity.Migrations.Model.DropTableOperation to System.Data.Entity.Migrations.Model.HistoryOperation.
	bij FirebirdSql.Data.EntityFramework6.FbMigrationSqlGenerator.Generate(IEnumerable`1
migrationOperations, String providerManifestToken)
	bij System.Data.Entity.Migrations.DbMigrator.ExecuteOperations(String migrationId,
VersionedModel targetModel, IEnumerable`1 operations, IEnumerable`1 systemOperations, Boolean
downgrading, Boolean auto)
	bij System.Data.Entity.Migrations.DbMigrator.RevertMigration(String migrationId, DbMigration
migration, XDocument targetModel)
	bij
System.Data.Entity.Migrations.Infrastructure.MigratorLoggingDecorator.RevertMigration(String
migrationId, DbMigration migration, XDocument targetModel)
	bij System.Data.Entity.Migrations.DbMigrator.Downgrade(IEnumerable`1 pendingMigrations)
(Continue reading)

Nießen, Yves | 28 Jun 08:10 2016

invalid request BLR at offset 1094

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

Yves.Niessen <at> toolbox-software.com

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
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Jiří Činčura | 27 Jun 20:51 2016
Picon
Gravatar

Stored procedures etc. in .NET

Hi *,

there's something I've been working on for a few evenings and weekends.
As you might know, from Firebird 3 there's and interface to write a
plugin that allows to execute any code as stored procedure, function or
trigger.

So why not to have these in .NET, right? I have a working plugin right
now. Currently only stored procedures are supported. No blobs at the
moment as well.

You can check small example at the end of this email.

Now the important part. Is there enough interest in this to keep working
it? The hardest part is mostly over. Now it's just adding support for
more objects and polishing it, hardening it and probably adding features
based on requests (like security).

* SP:
recreate procedure demo (
  in_int integer,
  in_s varchar(20),
  in_long bigint,
  in_short smallint,
  in_char char(20)
) 
returns (
  out_int integer,
  out_s varchar(20),
  out_long bigint,
  out_short smallint,
  out_char char(20)
)
external name 'Example!Example.Procedures.Demo'
engine dotnet;
* Code (not sure about the tuples yet):
public static IEnumerator<Tuple<int?, string, long?, short?, string>>
Demo(int? i, string s, long?  <at> long, short?  <at> short, string  <at> char)
{
	yield return Tuple.Create(i, s,  <at> long,  <at> short,  <at> char);
	yield return Tuple.Create(i + 1, s + nameof(Demo),  <at> long + 1,
	(short?)( <at> short + 1),  <at> char);
}

--

-- 
Mgr. Jiří Činčura
Independent IT Specialist

------------------------------------------------------------------------------
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
Firebird-net-provider <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Ralf Jansen | 27 Jun 16:30 2016

current source code that builds with Visual Studio 2013

Hi,

what is the latest release that can be built with VS2013?

 

 

 

------------------------------------------------------------------------------
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
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Ralf Jansen | 22 Jun 10:52 2016

using fb 2.5 and 3.0 embedded concurrently

Hi,

 

I’m in the process of migrating a large .Net application that is using firebird embedded 2.5 to 3.0. To get a smooth transition with a minimum of user hassle and downtime it would be helpful to have both client libraries (2.5 and 3.0) used concurrently in the same process.

There are presumably dozens of databases used by the process and I would like to migrate them one by one while the other databases keep running either via the 2.5 client or the 3.0 client library.

 

Should that work? Can both libraries coexist? Can the Net. Provider cope with that scenario?

 

------------------------------------------------------------------------------
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
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Jiří Činčura | 20 Jun 18:57 2016
Picon
Gravatar

Zlib library

Hi *,

Other topic to think about. The compression is Firebird is based on zlib compression. That one is not in the
framework. So unless somebody contributes solid and proven implementation, when and if the compression
will make it to master, I'd have to introduce dependency. Maybe some sort of optional. 

I successfully tested zlib from Ionic and SharpZipLib libraries. 

Discuss… ;)

--

-- 
Mgr. Jiří Činčura
Independent IT Specialist

------------------------------------------------------------------------------
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are 
consuming the most bandwidth. Provides multi-vendor support for NetFlow, 
J-Flow, sFlow and other flows. Make informed decisions using capacity planning
reports. http://sdm.link/zohomanageengine
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Jiří Činčura | 20 Jun 16:27 2016
Picon
Gravatar

Compression's default value

Hi *,

I have some very preliminary, but working, support for FB3's compression
in .NET provider. It will be controlled via connection string's value as
usual. But what do *you* think the default value should be?

--

-- 
Mgr. Jiří Činčura
Independent IT Specialist

------------------------------------------------------------------------------
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are 
consuming the most bandwidth. Provides multi-vendor support for NetFlow, 
J-Flow, sFlow and other flows. Make informed decisions using capacity planning
reports. http://sdm.link/zohomanageengine
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[SPAM] happy))

Hi,

 

I'm so happy to hear the latest news from our friends, you may read it here http://tendymutho.matthewpaulrealestate.com/lnonlqw

 

Kind regards, For users and developers of the Firebird .NET providers

------------------------------------------------------------------------------
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are 
consuming the most bandwidth. Provides multi-vendor support for NetFlow, 
J-Flow, sFlow and other flows. Make informed decisions using capacity 
planning reports. https://ad.doubleclick.net/ddm/clk/305295220;132659582;e
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Jiri Cincura (JIRA | 12 Jun 19:46 2016

[FB-Tracker] Created: (DNET-686) Unify SPB and DPB creation for common parameters

Unify SPB and DPB creation for common parameters
------------------------------------------------

                 Key: DNET-686
                 URL: http://tracker.firebirdsql.org/browse/DNET-686
             Project: .NET Data provider
          Issue Type: Improvement
          Components: ADO.NET Provider
    Affects Versions: 5.0.5.0
            Reporter: Jiri Cincura
            Assignee: Jiri Cincura

--

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

------------------------------------------------------------------------------
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are 
consuming the most bandwidth. Provides multi-vendor support for NetFlow, 
J-Flow, sFlow and other flows. Make informed decisions using capacity 
planning reports. https://ad.doubleclick.net/ddm/clk/305295220;132659582;e
Jiri Cincura (JIRA | 12 Jun 17:21 2016

[FB-Tracker] Created: (DNET-685) NOT NULL alteration in EF Migrations

NOT NULL alteration in EF Migrations
------------------------------------

                 Key: DNET-685
                 URL: http://tracker.firebirdsql.org/browse/DNET-685
             Project: .NET Data provider
          Issue Type: Improvement
          Components: Entity Framework support
    Affects Versions: 5.0.5.0
            Reporter: Jiri Cincura
            Assignee: Jiri Cincura

--

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

------------------------------------------------------------------------------
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are 
consuming the most bandwidth. Provides multi-vendor support for NetFlow, 
J-Flow, sFlow and other flows. Make informed decisions using capacity 
planning reports. https://ad.doubleclick.net/ddm/clk/305295220;132659582;e
André Ziegler (JIRA | 12 Jun 17:03 2016

[FB-Tracker] Created: (DNET-684) System.NullReferenceException in FirebirdSql.Data.Common.Extensions.TryGetTarget

System.NullReferenceException in FirebirdSql.Data.Common.Extensions.TryGetTarget
--------------------------------------------------------------------------------

                 Key: DNET-684
                 URL: http://tracker.firebirdsql.org/browse/DNET-684
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 5.0.5.0
         Environment: Windows 8 (x64), .Net 4.5.2
            Reporter: André Ziegler
            Assignee: Jiri Cincura

While testing my app I got a crash and analyzing the dmp shows a System.NullReferenceException in FirebirdSql.Data.Common.Extensions.TryGetTarget:

PROBLEM_CLASSES: 

CLR_EXCEPTION
    Tid    [0x2]
    Frame  [0x00]

    String [System.NullReferenceException]
    Failure Bucketing
    Data Bucketing

FINALIZER
    Tid    [0x2348]
    Frame  [0x0b]: clr!FastCallFinalize
    Failure Bucketing

BUGCHECK_STR:  CLR_EXCEPTION_FINALIZER_System.NullReferenceException

DEFAULT_BUCKET_ID:  CLR_EXCEPTION_FINALIZER_System.NullReferenceException

STACK_TEXT:  
049ff1bc 51f20f89 firebirdsql_data_firebirdclient_ni!FirebirdSql.Data.Common.Extensions.TryGetTarget[[System.__Canon,_mscorlib]]+0x25
049ff1d4 51f3faee firebirdsql_data_firebirdclient_ni!FirebirdSql.Data.FirebirdClient.FbConnectionInternal.RemovePreparedCommand+0x6e
049ff20c 51f41751 firebirdsql_data_firebirdclient_ni!FirebirdSql.Data.FirebirdClient.FbCommand.Release+0x4d
049ff21c 51f409fc firebirdsql_data_firebirdclient_ni!FirebirdSql.Data.FirebirdClient.FbCommand.Dispose+0x50

FAILURE_IMAGE_NAME:  FirebirdSql.Data.FirebirdClient.ni.dll

FAILURE_FUNCTION_NAME:  FirebirdSql.Data.Common.Extensions.TryGetTarget[[System.__Canon,_mscorlib]]

BUCKET_ID_FUNCTION_STR:  FirebirdSql.Data.Common.Extensions.TryGetTarget[[System.__Canon,_mscorlib]]

FAILURE_SYMBOL_NAME:  FirebirdSql.Data.FirebirdClient.ni.dll!FirebirdSql.Data.Common.Extensions.TryGetTarget[[System.__Canon,_mscorlib]]

FAILURE_BUCKET_ID:  CLR_EXCEPTION_FINALIZER_System.NullReferenceException_80004003_FirebirdSql.Data.FirebirdClient.ni.dll!FirebirdSql.Data.Common.Extensions.TryGetTarget[[System.__Canon,_mscorlib]]

--

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

------------------------------------------------------------------------------
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are 
consuming the most bandwidth. Provides multi-vendor support for NetFlow, 
J-Flow, sFlow and other flows. Make informed decisions using capacity 
planning reports. https://ad.doubleclick.net/ddm/clk/305295220;132659582;e
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Gmane