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 |