Menu
▾
▴
firebird-net-provider — All about development of the MS .Net provider
You can subscribe to this list here.
| 2002 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(10) |
Nov
(55) |
Dec
(36) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2003 |
Jan
(38) |
Feb
(108) |
Mar
(79) |
Apr
(95) |
May
(64) |
Jun
(130) |
Jul
(146) |
Aug
(121) |
Sep
(96) |
Oct
(149) |
Nov
(161) |
Dec
(113) |
| 2004 |
Jan
(113) |
Feb
(163) |
Mar
(248) |
Apr
(132) |
May
(157) |
Jun
(160) |
Jul
(236) |
Aug
(284) |
Sep
(293) |
Oct
(277) |
Nov
(257) |
Dec
(356) |
| 2005 |
Jan
(203) |
Feb
(190) |
Mar
(220) |
Apr
(165) |
May
(124) |
Jun
(160) |
Jul
(190) |
Aug
(142) |
Sep
(152) |
Oct
(189) |
Nov
(187) |
Dec
(159) |
| 2006 |
Jan
(170) |
Feb
(151) |
Mar
(212) |
Apr
(262) |
May
(226) |
Jun
(196) |
Jul
(223) |
Aug
(165) |
Sep
(163) |
Oct
(348) |
Nov
(225) |
Dec
(141) |
| 2007 |
Jan
(261) |
Feb
(161) |
Mar
(222) |
Apr
(193) |
May
(121) |
Jun
(157) |
Jul
(151) |
Aug
(159) |
Sep
(61) |
Oct
(123) |
Nov
(172) |
Dec
(96) |
| 2008 |
Jan
(104) |
Feb
(138) |
Mar
(131) |
Apr
(131) |
May
(74) |
Jun
(107) |
Jul
(89) |
Aug
(89) |
Sep
(172) |
Oct
(158) |
Nov
(119) |
Dec
(86) |
| 2009 |
Jan
(52) |
Feb
(84) |
Mar
(78) |
Apr
(83) |
May
(54) |
Jun
(79) |
Jul
(60) |
Aug
(62) |
Sep
(50) |
Oct
(147) |
Nov
(50) |
Dec
(70) |
| 2010 |
Jan
(135) |
Feb
(113) |
Mar
(74) |
Apr
(93) |
May
(35) |
Jun
(71) |
Jul
(33) |
Aug
(110) |
Sep
(47) |
Oct
(18) |
Nov
(61) |
Dec
(34) |
| 2011 |
Jan
(46) |
Feb
(47) |
Mar
(25) |
Apr
(24) |
May
(21) |
Jun
(22) |
Jul
(20) |
Aug
(51) |
Sep
(31) |
Oct
(42) |
Nov
(22) |
Dec
(22) |
| 2012 |
Jan
(31) |
Feb
(19) |
Mar
(25) |
Apr
(55) |
May
(16) |
Jun
(28) |
Jul
(33) |
Aug
(25) |
Sep
(32) |
Oct
(25) |
Nov
(52) |
Dec
(35) |
| 2013 |
Jan
(43) |
Feb
(18) |
Mar
(36) |
Apr
(45) |
May
(22) |
Jun
(13) |
Jul
(31) |
Aug
(24) |
Sep
(19) |
Oct
(59) |
Nov
(47) |
Dec
(25) |
| 2014 |
Jan
(27) |
Feb
(15) |
Mar
(38) |
Apr
(10) |
May
(15) |
Jun
(36) |
Jul
(24) |
Aug
(28) |
Sep
(16) |
Oct
(6) |
Nov
(44) |
Dec
(40) |
| 2015 |
Jan
(52) |
Feb
(22) |
Mar
(13) |
Apr
(17) |
May
(22) |
Jun
(36) |
Jul
(18) |
Aug
(41) |
Sep
(71) |
Oct
(60) |
Nov
(49) |
Dec
(43) |
| 2016 |
Jan
(60) |
Feb
(13) |
Mar
(21) |
Apr
(28) |
May
(23) |
Jun
(39) |
Jul
(17) |
Aug
(37) |
Sep
(33) |
Oct
(15) |
Nov
(22) |
Dec
(20) |
| 2017 |
Jan
(27) |
Feb
(40) |
Mar
(48) |
Apr
(19) |
May
(29) |
Jun
(2) |
Jul
(19) |
Aug
(36) |
Sep
(18) |
Oct
(10) |
Nov
(11) |
Dec
(5) |
| 2018 |
Jan
(5) |
Feb
(4) |
Mar
(5) |
Apr
(3) |
May
(4) |
Jun
(17) |
Jul
(7) |
Aug
(7) |
Sep
(12) |
Oct
(8) |
Nov
(2) |
Dec
|
| 2019 |
Jan
(8) |
Feb
(5) |
Mar
(3) |
Apr
(5) |
May
(3) |
Jun
(2) |
Jul
(8) |
Aug
(7) |
Sep
(3) |
Oct
(12) |
Nov
(7) |
Dec
(1) |
| 2020 |
Jan
(8) |
Feb
(3) |
Mar
(7) |
Apr
(1) |
May
(2) |
Jun
(1) |
Jul
(3) |
Aug
(25) |
Sep
(5) |
Oct
(3) |
Nov
(7) |
Dec
(16) |
| 2021 |
Jan
(11) |
Feb
(10) |
Mar
(16) |
Apr
(8) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Michael W. (JIRA) <tr...@fi...> - 2018-06-29 20:10:09
|
Accessing entities using EntityFramework on encrypted database failed
---------------------------------------------------------------------
Key: DNET-832
URL: http://tracker.firebirdsql.org/browse/DNET-832
Project: .NET Data provider
Issue Type: Bug
Affects Versions: 6.0.0.0
Environment: Issue occurred on develoment environment: Windows 10; .NET 4.7.1; Firebird 3.0.3.32900 (32 Bit); Entity Framework 6.2.0-61023.0; IBPhoenix Encryption Plugin 1.2.0
Reporter: Michael Wresche
Assignee: Jiri Cincura
Priority: Blocker
At first:
- We have an encrypted Firebird database which will be accessed from our application by using Entity Framework
- The encryption plugin uses a file-based key so the connection string does not contain any encryption information.
- Accessing the encrypted database by using FbConnection, FbCommand, etc. works fine
- If the database is not encrypted and the encryption plugin is not configured in Firebird, Entity Framework as well as FbConnection works fine
- If we access the encrypted database using Entity Framework, we got the following exception (Unfortunately in german): Das Objekt des Typs "FirebirdSql.Data.Client.Managed.Version13.CryptKeyCallbackReponse" kann nicht in Typ "FirebirdSql.Data.Client.Managed.GenericResponse" umgewandelt werden. You can find the callstack of the exception at the end of the bug description.
I have debugged the issue with the latest sources on GitHub and was able to find the root cause (hopefully): The method GdsConnection.ProcessOperation returned an CryptKeyCallbackResponse which will be casted to GenericResponse in Version10.GdsDatabase.ReadGenericResponse and this fails.
After some short debugging sessions in order to find out what happened when I access the encrypted database directly (without Entity Framework), I came to the following conclusion:
Entity Framework invoked FbProviderServices.GetDbProviderManifestToken() with a connection which is not yet open. Because of the connection state the requested server version will be determined by using the FbServerProperties class (FbProviderServices Line 130). This class uses the FbService to communicate with the database. The FbService uses the GdsServiceManager and this class creates an instance of the Version10.GdsDatabase class which is used to communicate with the database. In my opinion, the instance of GdsDatabase should be created by using the appropriate factory method. Anyway, it seems that Version10.GdsDatabase is not able to communicate with encrypted databases. I came to the conclusion that encryption is only compatible with Version13. I made the following two changes in order to get working solution:
1. I changed the constructor of GdsServiceManager to create a Version13.GdsDatabase class.
2. In class Version13.GdsDatabase, I override ReadGenericResponse:
public override GenericResponse ReadGenericResponse()
{
byte[] cryptKey = new byte[2096];
var response = ReadResponse();
while (response is CryptKeyCallbackReponse cryptResponse)
{
XdrStream.Write(IscCodes.op_crypt_key_callback);
XdrStream.WriteBuffer(cryptKey);
XdrStream.Flush();
response = ReadResponse();
}
return response as GenericResponse;
}
I know that this solution is just a hack but I don't know the architecture of the source code and I found no helpful source code comments. With the described changes, I was able to access the database.
I was wondering why no other user has reported a similar behavior.
I do my best to add all required information. If you need further information, feel free to contact me.
The callstack of the exception:
FirebirdSql.Data.FirebirdClient.dll!FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadGenericResponse() Line 602
at C:\Users\michael.wresche\source\repos\FirebirdSql.Data.FirebirdClient\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\Version10\GdsDatabase.cs(602)
FirebirdSql.Data.FirebirdClient.dll!FirebirdSql.Data.Client.Managed.Version10.GdsServiceManager.Attach(FirebirdSql.Data.Common.ServiceParameterBuffer spb, string dataSource, int port, string service) Line 73
at C:\Users\michael.wresche\source\repos\FirebirdSql.Data.FirebirdClient\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Managed\Version10\GdsServiceManager.cs(73)
FirebirdSql.Data.FirebirdClient.dll!FirebirdSql.Data.Services.FbService.Open() Line 114
at C:\Users\michael.wresche\source\repos\FirebirdSql.Data.FirebirdClient\Provider\src\FirebirdSql.Data.FirebirdClient\Services\FbService.cs(114)
FirebirdSql.Data.FirebirdClient.dll!FirebirdSql.Data.Services.FbService.QueryService(byte[] items) Line 341
at C:\Users\michael.wresche\source\repos\FirebirdSql.Data.FirebirdClient\Provider\src\FirebirdSql.Data.FirebirdClient\Services\FbService.cs(341)
FirebirdSql.Data.FirebirdClient.dll!FirebirdSql.Data.Services.FbService.ProcessQuery(byte[] items, System.Action<bool, object> queryResponseAction) Line 231
at C:\Users\michael.wresche\source\repos\FirebirdSql.Data.FirebirdClient\Provider\src\FirebirdSql.Data.FirebirdClient\Services\FbService.cs(231)
FirebirdSql.Data.FirebirdClient.dll!FirebirdSql.Data.Services.FbService.Query(byte[] items, System.Action<bool, object> resultAction) Line 200
at C:\Users\michael.wresche\source\repos\FirebirdSql.Data.FirebirdClient\Provider\src\FirebirdSql.Data.FirebirdClient\Services\FbService.cs(200)
FirebirdSql.Data.FirebirdClient.dll!FirebirdSql.Data.Services.FbService.Query(byte[] items) Line 159
at C:\Users\michael.wresche\source\repos\FirebirdSql.Data.FirebirdClient\Provider\src\FirebirdSql.Data.FirebirdClient\Services\FbService.cs(159)
FirebirdSql.Data.FirebirdClient.dll!FirebirdSql.Data.Services.FbServerProperties.GetInfo(byte[] items) Line 90
at C:\Users\michael.wresche\source\repos\FirebirdSql.Data.FirebirdClient\Provider\src\FirebirdSql.Data.FirebirdClient\Services\FbServerProperties.cs(90)
FirebirdSql.Data.FirebirdClient.dll!FirebirdSql.Data.Services.FbServerProperties.GetInfo(int item) Line 85
at C:\Users\michael.wresche\source\repos\FirebirdSql.Data.FirebirdClient\Provider\src\FirebirdSql.Data.FirebirdClient\Services\FbServerProperties.cs(85)
FirebirdSql.Data.FirebirdClient.dll!FirebirdSql.Data.Services.FbServerProperties.GetString(int item) Line 75
at C:\Users\michael.wresche\source\repos\FirebirdSql.Data.FirebirdClient\Provider\src\FirebirdSql.Data.FirebirdClient\Services\FbServerProperties.cs(75)
FirebirdSql.Data.FirebirdClient.dll!FirebirdSql.Data.Services.FbServerProperties.GetServerVersion() Line 40
at C:\Users\michael.wresche\source\repos\FirebirdSql.Data.FirebirdClient\Provider\src\FirebirdSql.Data.FirebirdClient\Services\FbServerProperties.cs(40)
EntityFramework.Firebird.dll!EntityFramework.Firebird.FbProviderServices.GetDbProviderManifestToken(System.Data.Common.DbConnection connection) Line 130
at C:\Users\michael.wresche\Source\Repos\FirebirdSql.Data.FirebirdClient\Provider\src\EntityFramework.Firebird\FbProviderServices.cs(130)
EntityFramework.dll!System.Data.Entity.Core.Common.DbProviderServices.GetProviderManifestToken(System.Data.Common.DbConnection connection)
EntityFramework.dll!System.Data.Entity.Utilities.DbProviderServicesExtensions.GetProviderManifestTokenChecked(System.Data.Entity.Core.Common.DbProviderServices providerServices, System.Data.Common.DbConnection connection)
mscorlib.dll!System.Collections.Concurrent.ConcurrentDictionary<System.Tuple<System.Type, string, string>, string>.GetOrAdd(System.Tuple<System.Type, string, string> key, System.Func<System.Tuple<System.Type, string, string>, string> valueFactory)
EntityFramework.dll!System.Data.Entity.Utilities.DbConnectionExtensions.GetProviderInfo(System.Data.Common.DbConnection connection, out System.Data.Entity.Core.Common.DbProviderManifest providerManifest)
EntityFramework.dll!System.Data.Entity.DbModelBuilder.Build(System.Data.Common.DbConnection providerConnection)
EntityFramework.dll!System.Data.Entity.Internal.LazyInternalContext.CreateModel(System.Data.Entity.Internal.LazyInternalContext internalContext)
EntityFramework.dll!System.Data.Entity.Internal.RetryLazy<System.Data.Entity.Internal.LazyInternalContext, System.Data.Entity.Infrastructure.DbCompiledModel>.GetValue(System.Data.Entity.Internal.LazyInternalContext input)
EntityFramework.dll!System.Data.Entity.Internal.LazyInternalContext.InitializeContext()
EntityFramework.dll!System.Data.Entity.Internal.InternalContext.Initialize()
EntityFramework.dll!System.Data.Entity.Internal.InternalContext.GetEntitySetAndBaseTypeForType(System.Type entityType)
EntityFramework.dll!System.Data.Entity.Internal.Linq.InternalSet<OTTO.IBA.Entities.DBVersion>.Initialize()
EntityFramework.dll!System.Data.Entity.Internal.Linq.InternalSet<OTTO.IBA.Entities.DBVersion>.AsNoTracking()
EntityFramework.dll!System.Data.Entity.Infrastructure.DbQuery<OTTO.IBA.Entities.DBVersion>.AsNoTracking()
OTTO.IBA.Datenbankzugriff.EntityFramework.dll!OTTO.IBA.Datenbankzugriff.EntityFramework.DAOs.DBVersionDAO.GetAktuelleDBVersion() Line 45
at C:\Projekte\Otto_IBA2\Development\Sources\App\Datenbankzugriff\OTTO.IBA.Datenbankzugriff.EntityFramework\DAOs\DBVersionDAO.cs(45)
--
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
|
|
From: Jiri C. (JIRA) <tr...@fi...> - 2018-06-22 11:05:03
|
Span<T> and Memory<T> for lower level code (embedded, XdrStream, ...)
---------------------------------------------------------------------
Key: DNET-831
URL: http://tracker.firebirdsql.org/browse/DNET-831
Project: .NET Data provider
Issue Type: Task
Components: ADO.NET Provider
Reporter: Jiri Cincura
Assignee: Jiri Cincura
Priority: Minor
--
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
|
|
From: Reinhard G. (JIRA) <tr...@fi...> - 2018-06-17 13:28:47
|
Server using up memory when executing a big amount of select queries
--------------------------------------------------------------------
Key: DNET-830
URL: http://tracker.firebirdsql.org/browse/DNET-830
Project: .NET Data provider
Issue Type: Bug
Components: Entity Framework
Affects Versions: 6.0.0.0
Environment: Server: Firebird Server 3.0.3 32-Bit on Windows 10
Client: .NET Framework 4.6.2 on Win 10 and Mono 5.12 on Linux
Reporter: Reinhard Gunacker
Assignee: Jiri Cincura
Priority: Minor
When executing a big amount of simple LINQ queries in a loop, in a single connection or separated to several connections with pooling enabled, firebird.exe uses up memory pretty quickly.
Until you get an Exception saying it can't allocate more memory.
Didn't happen with v5.12.1 of the data provider.
--
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
|
|
From: Leonard W. (JIRA) <tr...@fi...> - 2018-06-13 20:24:57
|
The generated metadata script by using CreateDatabaseScript from a context only uses defined entity types
---------------------------------------------------------------------------------------------------------
Key: DNET-829
URL: http://tracker.firebirdsql.org/browse/DNET-829
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 6.0.0.0
Environment: Firebird 2.5.7
Reporter: Leonard Wennekers
Assignee: Jiri Cincura
I'm using the following code to generate my metadata script:
var adapter = ((IObjectContextAdapter)context).ObjectContext;
var script = adapter.CreateDatabaseScript();
Earlier versions of the provider were generating the complete script of my database for the tables, views, indexes and triggers.
Now it's only creating the tables I configured as entitytypes. Even the extra tables I create by using the migrator are not
inside the script anymore.
Is this a result of a breaking issue????
Thanks already in advance for your support and kind regards,
Leonard Wennekers
--
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
|
|
From: Leonard W. (JIRA) <tr...@fi...> - 2018-06-13 06:41:59
|
Creating a new EntityStoreSchemaGenerator raises a ProviderIncompatibleException
--------------------------------------------------------------------------------
Key: DNET-828
URL: http://tracker.firebirdsql.org/browse/DNET-828
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 6.0.0.0
Reporter: Leonard Wennekers
Assignee: Jiri Cincura
I added the problem at first as an EF6 problem, but perhaps ii's just and ADO.NET Provider problem.
Hopefully you can tell me if this is the right place to report. I would like to retrieve all tables/views and there columns without making all entities.
This was possible with the EntityStoreSchemaGenerator class.
The following function will now raise a ProviderIncompatibleException
while this was functioning with the 5.12 version
var mConnectionString = @"Data Source=localhost;Initial Catalog=\"C:\Data\Database\UnitTest.FDB\";User Id=SYSDBA;Password=masterkey;"
var storeGenerator = new EntityStoreSchemaGenerator("FirebirdSql.Data.FirebirdClient", mConnectionString, "namespace");
storeGenerator.GenerateStoreMetadata();
--
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
|
|
From: Leonard W. (JIRA) <tr...@fi...> - 2018-06-11 07:53:45
|
Creating a new EntityStoreSchemaGenerator raises a ProviderIncompatibleException
--------------------------------------------------------------------------------
Key: DNET-827
URL: http://tracker.firebirdsql.org/browse/DNET-827
Project: .NET Data provider
Issue Type: Bug
Components: Entity Framework
Affects Versions: 6.0.0.0
Reporter: Leonard Wennekers
Assignee: Jiri Cincura
The following function will now raise a ProviderIncompatibleException while this was functioning with the 5.12 version
var mConnectionString = @"Data Source=localhost;Initial Catalog=\"C:\Data\Database\UnitTest.FDB\";User Id=SYSDBA;Password=masterkey;"
var storeGenerator = new EntityStoreSchemaGenerator("FirebirdSql.Data.FirebirdClient", mConnectionString, "namespace");
storeGenerator.GenerateStoreMetadata();
--
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
|
|
From: Gerdus v. Z. <ger...@gm...> - 2018-06-08 12:39:50
|
If OldestActiveTransaction does not increase it means there is an old transaction is still busy and has not commited/rolledback. You can use the monitoring tables and the transaction ID that OldestActiveTransaction gives to find out about the transaction that is stuck. find the application/connection: http://www.firebirdfaq.org/faq352/ queries in transaction: select * from MON$STATEMENTS where MON$TRANSACTION_ID = XX On Fri, 8 Jun 2018 at 12:30, Norbert Saint Georges <ns...@te...> wrote: > Gerdus van Zyl a écrit : > > Normal if it reverts to 0. > he does not reverts to 0, it keeps an old transaction > > > Check that NextTransaction and OldestActiveTransaction do increase after > > every transaction. > > OldestActiveTransaction remain imperturbably always the same. > > however, NextTransaction returns the active transaction :-( > > thank you very much. > > -- > Norbert Saint Georges > http://tetrasys.fi > > > > ------------------------------------------------------------------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > |
|
From: Norbert S. G. <ns...@te...> - 2018-06-08 10:29:49
|
Gerdus van Zyl a écrit : > Normal if it reverts to 0. he does not reverts to 0, it keeps an old transaction > Check that NextTransaction and OldestActiveTransaction do increase after > every transaction. OldestActiveTransaction remain imperturbably always the same. however, NextTransaction returns the active transaction :-( thank you very much. -- Norbert Saint Georges http://tetrasys.fi |
|
From: Gerdus v. Z. <ger...@gm...> - 2018-06-08 09:04:50
|
Normal if it reverts to 0. Check that NextTransaction and OldestActiveTransaction do increase after every transaction. On Thu, 7 Jun 2018 at 18:33, Norbert Saint Georges <ns...@te...> wrote: > the value never changes despite several transactions. > normal? > > -- > Norbert Saint Georges > http://tetrasys.fi > > > > ------------------------------------------------------------------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > |
|
From: Jiri C. (JIRA) <tr...@fi...> - 2018-06-07 18:43:46
|
Switch to generating NuGets from csproj definition instead of handmade nuspecs
------------------------------------------------------------------------------
Key: DNET-826
URL: http://tracker.firebirdsql.org/browse/DNET-826
Project: .NET Data provider
Issue Type: Task
Components: NuGet packages
Affects Versions: 6.0.0.0
Reporter: Jiri Cincura
Assignee: Jiri Cincura
Priority: Minor
--
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
|
|
From: Norbert S. G. <ns...@te...> - 2018-06-07 16:33:17
|
the value never changes despite several transactions. normal? -- Norbert Saint Georges http://tetrasys.fi |
|
From: Danie B. (JIRA) <tr...@fi...> - 2018-06-07 13:04:48
|
connection shutdown error if connection remains open for more than 110 seconds on embedded server
-------------------------------------------------------------------------------------------------
Key: DNET-825
URL: http://tracker.firebirdsql.org/browse/DNET-825
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 5.12.1.0
Environment: Windows 10, .Net 4.5.2
Reporter: Danie Brink
Assignee: Jiri Cincura
When using FB 3.0.3.329 as an embedded server it crashes after a connection has been in use for 110 seconds in 50-60% of instances. Seems to be similar to an issue reported when using 2.5 & 3.0 simultaneously and running backups but occurs when just using 3.0 and a prepared command .
To reproduce the error:
Create a database with 1 table & 2 fields.
Create a connection to the database & then a FbCommand with 1 lookup parameter to select a record from the table & call .Prepare() on the FbCommand.
In a loop provide a value for the parameter & call the prepared FbCommand.
In 50-60% of runs firebird crashes after 110 - 115 seconds. Connection Pooling & lifetime settings appear to have no effect & once the error occurs the only way to establish a new connection to any database is to stop & restart the process. This does not happen with Firebird 2.5.8 or any other 2.5.x version we've used.
--
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
|
|
From: Jiri C. (JIRA) <tr...@fi...> - 2018-06-07 07:26:45
|
Integrate Microsoft.EntityFrameworkCore.Specification.Tests
-----------------------------------------------------------
Key: DNET-822
URL: http://tracker.firebirdsql.org/browse/DNET-822
Project: .NET Data provider
Issue Type: Task
Components: Entity Framework Core
Reporter: Jiri Cincura
Assignee: Jiri Cincura
Priority: Minor
--
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
|
|
From: Jiri C. (JIRA) <tr...@fi...> - 2018-06-07 07:26:39
|
Add FirebirdClient into DataAccessPerformance
---------------------------------------------
Key: DNET-824
URL: http://tracker.firebirdsql.org/browse/DNET-824
Project: .NET Data provider
Issue Type: Task
Reporter: Jiri Cincura
Assignee: Jiri Cincura
Priority: Minor
--
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
|
|
From: Jiri C. (JIRA) <tr...@fi...> - 2018-06-07 07:26:38
|
Integrate Microsoft.EntityFrameworkCore.Relational.Specification.Tests
----------------------------------------------------------------------
Key: DNET-823
URL: http://tracker.firebirdsql.org/browse/DNET-823
Project: .NET Data provider
Issue Type: Task
Components: Entity Framework Core
Reporter: Jiri Cincura
Assignee: Jiri Cincura
Priority: Minor
--
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
|
|
From: Jiri C. (JIRA) <tr...@fi...> - 2018-06-06 12:56:45
|
Support for CryptKeyCallback handling in Services
-------------------------------------------------
Key: DNET-821
URL: http://tracker.firebirdsql.org/browse/DNET-821
Project: .NET Data provider
Issue Type: Task
Components: ADO.NET Provider
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
|
|
From: Jiri C. (JIRA) <tr...@fi...> - 2018-06-04 19:28:45
|
.NET Standard 2.0 does not need PlatformAbstractions
-----------------------------------------------------
Key: DNET-820
URL: http://tracker.firebirdsql.org/browse/DNET-820
Project: .NET Data provider
Issue Type: Improvement
Components: ADO.NET Provider
Affects Versions: 5.12.1.0
Reporter: Jiri Cincura
Assignee: Jiri Cincura
Priority: Minor
--
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
|
|
From: Matt T. (JIRA) <tr...@fi...> - 2018-05-23 16:32:37
|
FBServer is keeping connections alive if you don't explicitly call Dispose on an FBCommand object
-------------------------------------------------------------------------------------------------
Key: DNET-819
URL: http://tracker.firebirdsql.org/browse/DNET-819
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 5.12.1.0
Reporter: Matt Thompson
Assignee: Jiri Cincura
The firebird server appears to keep the connection alive when you create an FBCommand object and do not call Dispose on it. This issue is new starting somewhere between version 5.1 and 5.12.1. After we updated to the latest general release, we noticed the server quickly running out of memory and getting an error stating too many handles were open. After wrapping the DBCommand in a using statement, this issue went away.
--
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
|
|
From: Jiri C. (JIRA) <tr...@fi...> - 2018-05-14 12:00:49
|
[ http://tracker.firebirdsql.org/browse/DNET-668?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jiri Cincura reopened DNET-668:
-------------------------------
> Connection resiliency
> ---------------------
>
> Key: DNET-668
> URL: http://tracker.firebirdsql.org/browse/DNET-668
> Project: .NET Data provider
> Issue Type: New Feature
> Components: ADO.NET Provider
> 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
|
|
From: Jiri C. (JIRA) <tr...@fi...> - 2018-05-14 11:54:46
|
Connections that are "broken" should not go back to the pool
------------------------------------------------------------
Key: DNET-818
URL: http://tracker.firebirdsql.org/browse/DNET-818
Project: .NET Data provider
Issue Type: Task
Components: ADO.NET Provider
Reporter: Jiri Cincura
Assignee: Jiri Cincura
* If there was a problem in communication, aka "broken" connection, do not return the connection back to the pool.
* The fact that connection is broken is know only if some operation was performed (aka broken connections can be in the pool until these are used).
Retry logic is up to the developer, because in the library can't understand what the transaction is possibly doing, hence whether retry is possible.
--
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
|
|
From: Peter B. (JIRA) <tr...@fi...> - 2018-05-10 08:02:47
|
Big model (Code first Entity Framework) and Firebird 3.0
--------------------------------------------------------
Key: DNET-817
URL: http://tracker.firebirdsql.org/browse/DNET-817
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 5.12.1.0
Environment: Firebird 3.0, FirebirdClient 5.12.1.0, Entity Framework 6.2
Reporter: Peter Barbanyaga
Assignee: Jiri Cincura
We try to use the approach of Code First (Entity Framework 6.2) with the DBMS Firebird 3.0. For a small model (up to 10 tables) migrations are generated and executed.
The problem arises when there is a large model (in our case 153 tables) - in this case we are faced with a "limit on the maximum length of a BINARY type" (because full EF-model (Code first) is written in the field 'Model'):
FirebirdSql.Data.FirebirdClient.FbException (0x80004005):
Dynamic SQL Error Dynamic SQL Error SQL error code = -104
String literal with 66866 characters exceeds the maximum length of 65535 characters for the BINARY character set
Related issue: http://tracker.firebirdsql.org/browse/CORE-5821
--
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
|
|
From: Adriano d. S. F. (JIRA) <tr...@fi...> - 2018-04-23 02:00:38
|
Wrong EntityFramewordCore command with Asp.Net Core Identity
------------------------------------------------------------
Key: DNET-816
URL: http://tracker.firebirdsql.org/browse/DNET-816
Project: .NET Data provider
Issue Type: Bug
Components: Entity Framework Core
Environment: <PackageReference Include="FirebirdSql.Data.FirebirdClient" Version="6.0.0-*" />
<PackageReference Include="FirebirdSql.EntityFrameworkCore.Firebird" Version="6.0.0-*" />
Reporter: Adriano dos Santos Fernandes
Assignee: Jiri Cincura
OnModelCreating has:
builder.Entity<IdentityUser>().ToTable("IDENTITY_USER")
.Ignore(u => u.LockoutEnd);
builder.Entity<IdentityUser>()
.Property(p => p.Id).HasColumnName("ID");
builder.Entity<IdentityUser>()
.Property(p => p.AccessFailedCount).HasColumnName("ACCESS_FAILED_COUNT");
builder.Entity<IdentityUser>()
.Property(p => p.ConcurrencyStamp).HasColumnName("CONCURRENCY_STAMP");
builder.Entity<IdentityUser>()
.Property("Discriminator").HasColumnName("DISCRIMINATOR");
builder.Entity<IdentityUser>()
.Property(p => p.Email).HasColumnName("EMAIL");
builder.Entity<IdentityUser>()
.Property(p => p.EmailConfirmed).HasColumnName("EMAIL_CONFIRMED");
builder.Entity<IdentityUser>()
.Property(p => p.LockoutEnabled).HasColumnName("LOCKOUT_ENABLED");
builder.Entity<IdentityUser>()
.Property(p => p.NormalizedEmail).HasColumnName("NORMALIZED_EMAIL");
builder.Entity<IdentityUser>()
.Property(p => p.NormalizedUserName).HasColumnName("NORMALIZED_USER_NAME");
builder.Entity<IdentityUser>()
.Property(p => p.PasswordHash).HasColumnName("PASSWORD_HASH");
builder.Entity<IdentityUser>()
.Property(p => p.PhoneNumber).HasColumnName("PHONE_NUMBER");
builder.Entity<IdentityUser>()
.Property(p => p.PhoneNumberConfirmed).HasColumnName("PHONE_NUMBER_CONFIRMED");
builder.Entity<IdentityUser>()
.Property(p => p.SecurityStamp).HasColumnName("SECURITY_STAMP");
builder.Entity<IdentityUser>()
.Property(p => p.TwoFactorEnabled).HasColumnName("TWO_FACTOR_ENABLED");
builder.Entity<IdentityUser>()
.Property(p => p.UserName).HasColumnName("USER_NAME");
Error:
fail: Microsoft.EntityFrameworkCore.Database.Command[20102]
Failed executing DbCommand (55ms) [Parameters=[@p0='?' (Size = 256), @p1='?', @p14='?' (Size = 8191), @p2='?' (Size = 8191), @p3='?' (Size = 256), @p4='?', @p5='?', @p6='?' (Size = 256), @p7='?' (Size = 256), @p8='?' (Size = 8191), @p9='?' (Size = 8191), @p10='?', @p11='?' (Size = 8191), @p12='?', @p13='?' (Size = 256)], CommandType='Text', CommandTimeout='30']
EXECUTE BLOCK (p0 VARCHAR(256) = ?, p1 INTEGER = ?, p2 VARCHAR(8191) = ?, p3 VARCHAR(256) = ?, p4 BOOLEAN = ?, p5 BOOLEAN = ?, p6 VARCHAR(256) = ?, p7 VARCHAR(256) = ?, p8 VARCHAR(8191) = ?, p9 VARCHAR(8191) = ?, p10 BOOLEAN = ?, p11 VARCHAR(8191) = ?, p12 BOOLEAN = ?, p13 VARCHAR(256) = ?)
RETURNS (ROWS_AFFECTED INT)
AS
BEGIN
UPDATE "IDENTITY_USER" SET "ACCESS_FAILED_COUNT" = :p1, "CONCURRENCY_STAMP" = :p14, "EMAIL" = :p3, "EMAIL_CONFIRMED" = :p4, "LOCKOUT_ENABLED" = :p5, "NORMALIZED_EMAIL" = :p6, "NORMALIZED_USER_NAME" = :p7, "PASSWORD_HASH" = :p8, "PHONE_NUMBER" = :p9, "PHONE_NUMBER_CONFIRMED" = :p10, "SECURITY_STAMP" = :p11, "TWO_FACTOR_ENABLED" = :p12, "USER_NAME" = :p13
WHERE "ID" = :p0 AND "CONCURRENCY_STAMP" = :p2;
ROWS_AFFECTED = ROW_COUNT;
SUSPEND;
END
;
FirebirdSql.Data.FirebirdClient.FbException (0x80004005): Dynamic SQL Error
SQL error code = -206
Column unknown
P14
At line 5, column 79 ---> Dynamic SQL Error
SQL error code = -206
Column unknown
P14
At line 5, column 79
--
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
|
|
From: Francesco G. (JIRA) <tr...@fi...> - 2018-04-20 08:46:39
|
The Parse function of the FbScript class does not support the MERGE SQL command
-------------------------------------------------------------------------------
Key: DNET-815
URL: http://tracker.firebirdsql.org/browse/DNET-815
Project: .NET Data provider
Issue Type: New Feature
Components: ADO.NET Provider
Affects Versions: 5.12.1.0
Environment: Windows 10 Professional
Visual studio 2015
.Net Framework: 4.6.1
Firebird .Net provider: 5.12.1.0
Firebird Database: 2.5
Reporter: Francesco Giossi
Assignee: Jiri Cincura
I can't run the MERGE script using the FbScript.Parse() function.
The same script works from
ref: https://stackoverflow.com/questions/49918753/firebird-merge-sql-command-and-net-fbbatchexecution/
--
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
|
|
From: Tomislav A. <to...@ha...> - 2018-04-03 13:09:35
|
Sent from my Sony Xperia™ smartphone ---- fir...@li... wrote ---- >Send Firebird-net-provider mailing list submissions to > fir...@li... > >To subscribe or unsubscribe via the World Wide Web, visit > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider >or, via email, send a message with subject or body 'help' to > fir...@li... > >You can reach the person managing the list at > fir...@li... > >When replying, please edit your Subject line so it is more specific >than "Re: Contents of Firebird-net-provider digest..." > > >Today's Topics: > > 1. [FB-Tracker] Created: (DNET-814) Closing FbDataReader on > broken connection throws IscException instead of FbException > (Jiri Cincura (JIRA)) > > >---------------------------------------------------------------------- > >Message: 1 >Date: Tue, 27 Mar 2018 13:00:25 +0000 (UTC) >From: "Jiri Cincura (JIRA)" <tr...@fi...> >To: fir...@li... >Subject: [Firebird-net-provider] [FB-Tracker] Created: (DNET-814) > Closing FbDataReader on broken connection throws IscException instead > of FbException >Message-ID: > <646...@tr...> >Content-Type: text/plain; charset=UTF-8 > >Closing FbDataReader on broken connection throws IscException instead of FbException >------------------------------------------------------------------------------------ > > Key: DNET-814 > URL: http://tracker.firebirdsql.org/browse/DNET-814 > Project: .NET Data provider > Issue Type: Bug > Components: ADO.NET Provider > Affects Versions: 5.12.1.0 > Reporter: Jiri Cincura > Assignee: Jiri Cincura > Priority: Minor > > >Because it's trying to rollback implicit transaction (if any) and that, because of broken connection fails to do, and fails then in `finally` on `Dispose`. > >There's probably more of these cases (FbCommand -> GdsStatement). > >-- >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 > > > > > >------------------------------ > >------------------------------------------------------------------------------ >Check out the vibrant tech community on one of the world's most >engaging tech sites, Slashdot.org! http://sdm.link/slashdot > >------------------------------ > >Subject: Digest Footer > >_______________________________________________ >Firebird-net-provider mailing list >Fir...@li... >https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > > >------------------------------ > >End of Firebird-net-provider Digest, Vol 143, Issue 5 >***************************************************** |
|
From: Jiri C. (JIRA) <tr...@fi...> - 2018-03-27 13:00:45
|
Closing FbDataReader on broken connection throws IscException instead of FbException
------------------------------------------------------------------------------------
Key: DNET-814
URL: http://tracker.firebirdsql.org/browse/DNET-814
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 5.12.1.0
Reporter: Jiri Cincura
Assignee: Jiri Cincura
Priority: Minor
Because it's trying to rollback implicit transaction (if any) and that, because of broken connection fails to do, and fails then in `finally` on `Dispose`.
There's probably more of these cases (FbCommand -> GdsStatement).
--
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
|
211 messages has been excluded from this view by a project administrator.
