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: Jiri C. (JIRA) <tr...@fi...> - 2018-03-27 11:26:36
|
Unify the usage of isc_network_error/isc_net_write_err/isc_net_read_err ----------------------------------------------------------------------- Key: DNET-813 URL: http://tracker.firebirdsql.org/browse/DNET-813 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-03-15 21:14:48
|
Support for Firebird 4 ---------------------- Key: DNET-812 URL: http://tracker.firebirdsql.org/browse/DNET-812 Project: .NET Data provider Issue Type: New Feature 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: Andreas P. (JIRA) <tr...@fi...> - 2018-03-14 10:37:37
|
Can't use new created columns in SQL - Statement in Up() Migration ------------------------------------------------------------------ Key: DNET-811 URL: http://tracker.firebirdsql.org/browse/DNET-811 Project: .NET Data provider Issue Type: Bug Components: Entity Framework Affects Versions: 5.9.1.0 Reporter: Andreas Patock Assignee: Jiri Cincura If I have the following migration: public partial class AddDeviceType : DbMigration { public override void Up() { CreateTable( "dbo.DeviceType", c => new { Id = c.Int(nullable: false, identity: true), Name = c.String(nullable: false, maxLength: 128), ManufacturerId = c.Int(nullable: false), }) .PrimaryKey(t => t.Id) .ForeignKey("dbo.Manufacturer", t => t.ManufacturerId, cascadeDelete: true) .Index(t => t.ManufacturerId); AddColumn("dbo.Device", "TempDeviceTypeId", c => c.Int()); AddColumn("dbo.Device", "DeviceTypeId", c => c.Int(nullable: false)); CreateIndex("dbo.Device", "DeviceTypeId"); AddForeignKey("dbo.Device", "DeviceTypeId", "dbo.DeviceType", "Id", cascadeDelete: true); Sql("UPDATE \"Device\" d SET d.\"DeviceTypeId\" = (SELECT t.\"Id\" from \"DeviceType\" t where t.\"ManufacturerId\" = d.\"ManufacturerId\" ORDER BY t.\"Id\" ROWS 1)"); } I can a Column unknown "DeviceTypeId" exception when running the migration. This can found on many examples in the internet and is working with mssql. I had the idea to do this in two migrations, but the "DeviceTypeId" is a not null field and so the first migration throws an exception also. -- 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: fish (JIRA) <tr...@fi...> - 2018-03-08 14:04:50
|
Support for DECFLOAT in FB4 --------------------------- Key: DNET-810 URL: http://tracker.firebirdsql.org/browse/DNET-810 Project: .NET Data provider Issue Type: Improvement Components: ADO.NET Provider Reporter: fish Assignee: Jiri Cincura For reference the initial implementation in Jaybird: https://github.com/FirebirdSQL/jaybird/commit/567d93a988194f545659b90feccfa9a40dba811c -- 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: Phubase T. (JIRA) <tr...@fi...> - 2018-02-16 09:13:33
|
Add support for Thai charset TIS620 ----------------------------------- Key: DNET-808 URL: http://tracker.firebirdsql.org/browse/DNET-808 Project: .NET Data provider Issue Type: Improvement Components: ADO.NET Provider Affects Versions: 5.12.1.0 Reporter: Phubase Tiewthanom Assignee: Jiri Cincura Priority: Minor Add support for Thai charset TIS620 which is available since Firebird 2.1 -- 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: Pascal D. (JIRA) <tr...@fi...> - 2018-02-10 09:20:40
|
Exception: The socket has been shut down. ----------------------------------------- Key: DNET-807 URL: http://tracker.firebirdsql.org/browse/DNET-807 Project: .NET Data provider Issue Type: Bug Components: ADO.NET Provider Affects Versions: 5.5.0.0 Environment: Ubuntu 16.04 lts Mono 5.2.0.215 Pooling active (default ) Reporter: Pascal D. Assignee: Jiri Cincura We use the Firebird driver to communicate with the Firebird database and our web service. Sometimes there is an error that can only be corrected by restarting the process. The following exception is thrown here: { "ClassName": "FirebirdSql.Data.FirebirdClient.FbException", "Message": "Error reading data from the connection.", "Data": null, "InnerException": { "ClassName": "FirebirdSql.Data.Common.IscException", "Message": "Unable to write data to the transport connection: The socket has been shut down.", "Data": null, "InnerException": { "ClassName": "System.IO.IOException", "Message": "Unable to write data to the transport connection: The socket has been shut down.", "Data": null, "InnerException": { "NativeErrorCode": 10058, "ClassName": "System.Net.Sockets.SocketException", "Message": "The socket has been shut down", "Data": null, "InnerException": null, "HelpURL": null, "StackTraceString": " at System.Net.Sockets.Socket.Send (System.Byte[] buffer, System.Int32 offset, System.Int32 size, System.Net.Sockets.SocketFlags socketFlags) [0x00016] in <d2c057d9d34d4e029e580897bd60340c>:0 \n at System.Net.Sockets.NetworkStream.Write (System.Byte[] buffer, System.Int32 offset, System.Int32 size) [0x0009b] in <d2c057d9d34d4e029e580897bd60340c>:0 ", "RemoteStackTraceString": null, "RemoteStackIndex": 0, "ExceptionMethod": null, "HResult": -2147467259, "Source": "System" }, "HelpURL": null, "StackTraceString": " at System.Net.Sockets.NetworkStream.Write (System.Byte[] buffer, System.Int32 offset, System.Int32 size) [0x000e2] in <d2c057d9d34d4e029e580897bd60340c>:0 \n at FirebirdSql.Data.Client.Managed.XdrStream.Flush () [0x000d3] in <5e7529d7713a478ca878b28774fda053>:0 \n at FirebirdSql.Data.Client.Managed.Version10.GdsTransaction.BeginTransaction (FirebirdSql.Data.Common.TransactionParameterBuffer tpb) [0x00085] in <5e7529d7713a478ca878b28774fda053>:0 ", "RemoteStackTraceString": null, "RemoteStackIndex": 0, "ExceptionMethod": null, "HResult": -2146232800, "Source": "System" }, "HelpURL": null, "StackTraceString": " at FirebirdSql.Data.Client.Managed.Version10.GdsTransaction.BeginTransaction (FirebirdSql.Data.Common.TransactionParameterBuffer tpb) [0x000dd] in <5e7529d7713a478ca878b28774fda053>:0 \n at FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.BeginTransaction (FirebirdSql.Data.Common.TransactionParameterBuffer tpb) [0x00006] in <5e7529d7713a478ca878b28774fda053>:0 \n at FirebirdSql.Data.FirebirdClient.FbTransaction.BeginTransaction () [0x00023] in <5e7529d7713a478ca878b28774fda053>:0 ", "RemoteStackTraceString": null, "RemoteStackIndex": 0, "ExceptionMethod": null, "HResult": -2146233088, "Source": "FirebirdSql.Data.FirebirdClient", "errors": [{ "Message": null, "ErrorCode": 335544726, "StrParam": "", "Type": 1, "IsArgument": false, "IsWarning": false }, { "Message": "Error reading data from the connection.", "ErrorCode": 335544726, "StrParam": "", "Type": 0, "IsArgument": false, "IsWarning": false }], "errorCode": 335544726 }, "HelpURL": null, "StackTraceString": " at FirebirdSql.Data.FirebirdClient.FbTransaction.BeginTransaction () [0x0003c] in <5e7529d7713a478ca878b28774fda053>:0 \n at (wrapper remoting-invoke-with-check) FirebirdSql.Data.FirebirdClient.FbTransaction:BeginTransaction ()\n at FirebirdSql.Data.FirebirdClient.FbCommand.Prepare (System.Boolean returnsSet) [0x00058] in <5e7529d7713a478ca878b28774fda053>:0 \n at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand (System.Data.CommandBehavior behavior, System.Boolean returnsSet) [0x00000] in <5e7529d7713a478ca878b28774fda053>:0 \n at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x00037] in <5e7529d7713a478ca878b28774fda053>:0 \n at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader () [0x00000] in <5e7529d7713a478ca878b28774fda053>:0 \n at (wrapper remoting-invoke-with-check) FirebirdSql.Data.FirebirdClient.FbCommand:ExecuteReader ()\n at FirebirdTest.Program.Select (FirebirdSql.Data.FirebirdClient.FbConnection "RemoteStackTraceString": null, "RemoteStackIndex": 0, "ExceptionMethod": null, "HResult": -2147467259, "Source": "FirebirdSql.Data.FirebirdClient", "errors": [{ "Class": 0, "LineNumber": 0, "Message": null, "Number": 335544726 }, { "Class": 0, "LineNumber": 0, "Message": "Error reading data from the connection.", "Number": 335544726 }] } Couldn't the driver automatically delete the connection from the pool? -- 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: Mark R. (JIRA) <tr...@fi...> - 2018-02-07 14:58:41
|
.NET provider should explicitly call fb_shutdown() on application exit when using Firebird Embedded --------------------------------------------------------------------------------------------------- Key: DNET-806 URL: http://tracker.firebirdsql.org/browse/DNET-806 Project: .NET Data provider Issue Type: Bug Components: ADO.NET Provider Affects Versions: 5.12.1.0 Reporter: Mark Rotteveel Assignee: Jiri Cincura If the apllication exits and there are still connections open using Firebird Embedded, then the exit may produce an access violation (0xc0000005 error). The root cause is that the fbembed.dll/fbclient.dll will call fb_shutdown() itself, but one of the other libraries (eg fbintl.dll) may already have been unloaded. To prevent this, on exit the .NET provider should explicitly call fb_shutdown for any of the native libries loaded (but especially for embedded). See also "Crash Firebird 2.5.8 Embedded with Firebird Ado.net provider." on Firebird-devel. Related: DNET-802 (cleaning up the connection pool on exit will also prevent the access violation). -- 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-02-05 20:51:54
|
Reading blobs with packet size of short.MaxValue causes exception ----------------------------------------------------------------- Key: DNET-805 URL: http://tracker.firebirdsql.org/browse/DNET-805 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 -- 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: Zeki G. (J. <tr...@fi...> - 2018-01-30 20:04:48
|
Connection lost to database with embed connection ------------------------------------------------- Key: DNET-804 URL: http://tracker.firebirdsql.org/browse/DNET-804 Project: .NET Data provider Issue Type: Bug Components: ADO.NET Provider Reporter: Zeki Gürsoy Assignee: Jiri Cincura Firebird 3.0.2 64 bit, application 64 bit, Provider 5.12.1.0 When I conneccting to database with embed connection, I get error message 'connection lost to database' My connection and code below: Dim cn As String cn = "ServerType=1;User=SYSDBA;" & "Database=C:\Program Files\Firebird\Firebird_3_0\examples\empbuild\EMPLOYEE.FDB;" & "ClientLibrary=D:\PROGRAMLAR\fbembed.dll" Dim x As New FirebirdSql.Data.FirebirdClient.FbConnection(cn) x.Open() x.Close() -- 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-01-24 13:54:47
|
XdrStream Pad and Fill possible race condition ---------------------------------------------- Key: DNET-803 URL: http://tracker.firebirdsql.org/browse/DNET-803 Project: .NET Data provider Issue Type: Bug Affects Versions: 5.12.1.0 Reporter: Jiri Cincura Assignee: Jiri Cincura Priority: Minor Pad and Fill are used for reading and also writing (though same data) and that *might* cause some race conditions. -- 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-01-24 13:36:46
|
Pool cleanup on process/domain exit ----------------------------------- Key: DNET-802 URL: http://tracker.firebirdsql.org/browse/DNET-802 Project: .NET Data provider Issue Type: Improvement Components: ADO.NET Provider 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: Andreas P. (JIRA) <tr...@fi...> - 2018-01-17 12:31:43
|
Migration Problem ----------------- Key: DNET-801 URL: http://tracker.firebirdsql.org/browse/DNET-801 Project: .NET Data provider Issue Type: Bug Components: ADO.NET Provider Affects Versions: 5.9.1.0 Environment: Firebird 2.5 Reporter: Andreas Patock Assignee: Jiri Cincura Hi Jiri, you wanted to post me this to the issue tracker - here it is. I have a problem add a new column via migration to a codefirst database. This is the code for the migration: public partial class StreamingModuleAddAddress2 : DbMigration { public override void Up() { AddColumn("dbo.StreamingModule", "Address1", c => c.String(nullable: false, maxLength: 23)); AddColumn("dbo.StreamingModule", "Address2", c => c.String(nullable: false, maxLength: 23)); AddColumn("dbo.StreamingModule", "Port1", c => c.Int(nullable: false)); AddColumn("dbo.StreamingModule", "Port2", c => c.Int(nullable: false)); DropColumn("dbo.StreamingModule", "Address"); DropColumn("dbo.StreamingModule", "Port"); } public override void Down() { AddColumn("dbo.StreamingModule", "Port", c => c.Int(nullable: false)); AddColumn("dbo.StreamingModule", "Address", c => c.String(nullable: false, maxLength: 23)); DropColumn("dbo.StreamingModule", "Port2"); DropColumn("dbo.StreamingModule", "Port1"); DropColumn("dbo.StreamingModule", "Address2"); DropColumn("dbo.StreamingModule", "Address1"); } } But when running entityframework creates the following sql: ALTER TABLE "StreamingModule" ADD "Address1" VARCHAR(23) DEFAULT CAST(_UTF8'' AS VARCHAR(0)) NOT NULL I think firebird doesn't allow the CAST in a DEFAULT statement! And this causes the following exception: FirebirdSql.Data.FirebirdClient.FbException was unhandled ErrorCode=335544569 HResult=-2147467259 Message=Dynamic SQL Error SQL error code = -104 Token unknown - line 1, column 66 CAST SQLSTATE=42000 Source=FirebirdSql.Data.FirebirdClient StackTrace: bei FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteNonQuery() bei System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.<NonQuery>b__0(DbCommand t, DbCommandInterceptionContext`1 c) 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.NonQuery(DbCommand command, DbCommandInterceptionContext interceptionContext) bei System.Data.Entity.Internal.InterceptableDbCommand.ExecuteNonQuery() bei System.Data.Entity.Migrations.DbMigrator.ExecuteSql(MigrationStatement migrationStatement, DbConnection connection, DbTransaction transaction, DbInterceptionContext interceptionContext) bei System.Data.Entity.Migrations.DbMigrator.ExecuteStatementsInternal(IEnumerable`1 migrationStatements, DbConnection connection, DbTransaction transaction, DbInterceptionContext interceptionContext) bei System.Data.Entity.Migrations.DbMigrator.ExecuteStatementsWithinTransaction(IEnumerable`1 migrationStatements, DbTransaction transaction, DbInterceptionContext interceptionContext) bei System.Data.Entity.Migrations.DbMigrator.ExecuteStatementsWithinNewTransaction(IEnumerable`1 migrationStatements, DbConnection connection, DbInterceptionContext interceptionContext) bei System.Data.Entity.Migrations.DbMigrator.ExecuteStatementsInternal(IEnumerable`1 migrationStatements, DbConnection connection, DbInterceptionContext interceptionContext) bei System.Data.Entity.Migrations.DbMigrator.ExecuteStatementsInternal(IEnumerable`1 migrationStatements, DbConnection connection) bei System.Data.Entity.Migrations.DbMigrator.<>c__DisplayClass30.<ExecuteStatements>b__2e() bei System.Data.Entity.Infrastructure.DefaultExecutionStrategy.Execute(Action operation) bei System.Data.Entity.Migrations.DbMigrator.ExecuteStatements(IEnumerable`1 migrationStatements, DbTransaction existingTransaction) bei System.Data.Entity.Migrations.DbMigrator.ExecuteStatements(IEnumerable`1 migrationStatements) bei System.Data.Entity.Migrations.DbMigrator.ExecuteOperations(String migrationId, VersionedModel targetModel, IEnumerable`1 operations, IEnumerable`1 systemOperations, Boolean downgrading, Boolean auto) bei System.Data.Entity.Migrations.DbMigrator.ApplyMigration(DbMigration migration, DbMigration lastMigration) bei System.Data.Entity.Migrations.DbMigrator.Upgrade(IEnumerable`1 pendingMigrations, String targetMigrationId, String lastMigrationId) bei System.Data.Entity.Migrations.DbMigrator.UpdateInternal(String targetMigration) bei System.Data.Entity.Migrations.DbMigrator.<>c__DisplayClassc.<Update>b__b() bei System.Data.Entity.Migrations.DbMigrator.EnsureDatabaseExists(Action mustSucceedToKeepDatabase) bei System.Data.Entity.Migrations.DbMigrator.Update(String targetMigration) bei System.Data.Entity.MigrateDatabaseToLatestVersion`2.InitializeDatabase(TContext context) bei System.Data.Entity.Internal.InternalContext.<>c__DisplayClassf`1.<CreateInitializationAction>b__e() bei System.Data.Entity.Internal.InternalContext.PerformInitializationAction(Action action) bei System.Data.Entity.Internal.InternalContext.PerformDatabaseInitialization() bei System.Data.Entity.Internal.LazyInternalContext.<InitializeDatabase>b__4(InternalContext c) bei System.Data.Entity.Internal.RetryAction`1.PerformAction(TInput input) bei System.Data.Entity.Internal.LazyInternalContext.InitializeDatabaseAction(Action`1 action) bei System.Data.Entity.Internal.LazyInternalContext.InitializeDatabase() bei System.Data.Entity.Internal.InternalContext.GetEntitySetAndBaseTypeForType(Type entityType) bei System.Data.Entity.Internal.Linq.InternalSet`1.Initialize() bei System.Data.Entity.Internal.Linq.InternalSet`1.GetEnumerator() bei System.Data.Entity.Infrastructure.DbQuery`1.System.Collections.Generic.IEnumerable<TResult>.GetEnumerator() bei System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) bei System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source) bei ConsoleTester.Program.Main(String[] args) in C:\WorkDir_Trunk\Win\Bfe\KscSilknet\Database\ConsoleTester\Program.cs:Zeile 22. bei System.AppDomain._nExecuteAssembly(RuntimeAssembly assembly, String[] args) bei System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args) bei Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly() bei System.Threading.ThreadHelper.ThreadStart_Context(Object state) bei System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) bei System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) bei System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) bei System.Threading.ThreadHelper.ThreadStart() InnerException: ErrorCode=335544569 HResult=-2146233088 IsWarning=false Message=Dynamic SQL Error SQL error code = -104 Token unknown - line 1, column 66 CAST SQLSTATE=42000 Source=FirebirdSql.Data.FirebirdClient StackTrace: bei FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ProcessResponse(IResponse response) bei FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadResponse() bei FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadGenericResponse() bei FirebirdSql.Data.Client.Managed.Version11.GdsStatement.Prepare(String commandText) bei FirebirdSql.Data.FirebirdClient.FbCommand.Prepare(Boolean returnsSet) bei FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior behavior, Boolean returnsSet) bei FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteNonQuery() InnerException: Do you have any Idea how to fix that? Kind regards, Andreas -- 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-01-08 13:36:47
|
Support for SupportsParameterOptimizationInSchemaQueries -------------------------------------------------------- Key: DNET-800 URL: http://tracker.firebirdsql.org/browse/DNET-800 Project: .NET Data provider Issue Type: Task Components: Entity Framework 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...> - 2017-12-21 10:25:26
|
Wrong computation of IsAlive in connection pool ----------------------------------------------- Key: DNET-799 URL: http://tracker.firebirdsql.org/browse/DNET-799 Project: .NET Data provider Issue Type: Bug Components: ADO.NET Provider Affects Versions: 5.12.0.0 Reporter: Jiri Cincura Assignee: Jiri Cincura https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/pull/75 -- 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: LtColRDSChauhan <rds...@gm...> - 2017-12-14 01:01:17
|
Hi, How can I clear all connection pools. Regards, Rajiv |
From: LtColRDSChauhan <rds...@gm...> - 2017-12-03 04:14:40
|
On Thu, Nov 23, 2017 at 10:54 AM, < 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. Error reading data from the connection Re: > Firebird-net-provider Digest, Vol 139, Issue 7 (LtColRDSChauhan) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Thu, 23 Nov 2017 10:54:48 +0530 > From: LtColRDSChauhan <rds...@gm...> > To: fir...@li... > Subject: [Firebird-net-provider] Error reading data from the > connection Re: Firebird-net-provider Digest, Vol 139, Issue 7 > Message-ID: > <CAMG8wxgcL1RM2EWhX3pf46Kcmr+Tya=Yb7ef8gPjN0yJcRnhAg@mail. > gmail.com> > Content-Type: text/plain; charset="utf-8" > > On Sat, Nov 18, 2017 at 7:31 PM, < > 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. Error reading data from the connection Re: > > Firebird-net-provider Digest, Vol 139, Issue 6 (LtColRDSChauhan) > > > > > > ---------------------------------------------------------------------- > > > > Message: 1 > > Date: Sat, 18 Nov 2017 19:31:44 +0530 > > From: LtColRDSChauhan <rds...@gm...> > > To: fir...@li... > > Subject: [Firebird-net-provider] Error reading data from the > > connection Re: Firebird-net-provider Digest, Vol 139, Issue 6 > > Message-ID: > > <CAMG8wxj8BvBGE88rEvN=2zhg7-W9u-VSZPU_wtCJkok1WKrXgg@mail. > > gmail.com> > > Content-Type: text/plain; charset="utf-8" > > > > On Sat, Nov 18, 2017 at 5:46 PM, < > > 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. Re: Error reading data from the connection Re: > > > Firebird-net-provider Digest, Vol 139, Issue 3 (Ji?? ?in?ura) > > > > > > > > > ---------------------------------------------------------------------- > > > > > > Message: 1 > > > Date: Sat, 18 Nov 2017 09:07:35 +0100 > > > From: Ji?? ?in?ura <ji...@ci...> > > > To: fir...@li... > > > Subject: Re: [Firebird-net-provider] Error reading data from the > > > connection Re: Firebird-net-provider Digest, Vol 139, Issue 3 > > > Message-ID: > > > <1510992455.1577004.1176679856.4C4DB47A@webmail. > > > messagingengine.com> > > > Content-Type: text/plain; charset="utf-8" > > > > > > I would check inner exception to see what happened. > > > > > > > > Thanks for responding, Jiri. > > The details of exception are as under please. Let me know if more details > > are required. > > > > > > - ex {"Error reading data from the > > connection."} FirebirdSql.Data.FirebirdClient.FbException > > > > + Data > > {System.Collections.ListDictionaryInternal} > > System.Collections.IDictionary > > {System.Collections.ListDictionaryInternal} > > > > ErrorCode 335544726 int > > > > + Errors > > {FirebirdSql.Data.FirebirdClient.FbErrorCollection} > > FirebirdSql.Data.FirebirdClient.FbErrorCollection > > > > HResult -2147467259 int > > > > HelpLink null string > > > > - InnerException {"Error reading data from > > the connection."} System.Exception > > {FirebirdSql.Data.Common.IscException} > > > > + Data > > {System.Collections.ListDictionaryInternal} > > System.Collections.IDictionary > > {System.Collections.ListDictionaryInternal} > > > > ErrorCode 335544726 int > > > > + Errors Count = 2 > > System.Collections.Generic.List<FirebirdSql.Data.Common.IscError> > > > > HResult -2146233088 int > > > > HelpLink null string > > > > - InnerException {"I/O error occurred."} > > System.Exception > > {System.IO.IOException} > > > > + Data > > {System.Collections.ListDictionaryInternal} > > System.Collections.IDictionary > > {System.Collections.ListDictionaryInternal} > > > > HResult -2146232800 int > > > > HelpLink null string > > > > - InnerException null > > System.Exception > > > > + Static members > > > > Message "I/O error occurred." > > string > > > > Source > > "FirebirdSql.Data.FirebirdClient" > > string > > > > StackTrace " at > > FirebirdSql.Data.Client.Managed.XdrStream.ReadBytes(Int32 count)\r\n > at > > FirebirdSql.Data.Client.Managed.XdrStream.ReadNextOperation()\r\n at > > FirebirdSql.Data.Client.Managed.Version11.GdsDatabase. > NextOperation()\r\n > > at > > FirebirdSql.Data.Client.Managed.Version10.GdsStatement.Fetch()" > > string > > > > + TargetSite {Byte[] > > ReadBytes(Int32)} > > System.Reflection.MethodBase {System.Reflection.RuntimeMethodInfo} > > > > + Static members > > > > + Non-Public members > > > > IsWarning false bool > > > > Message "Error reading data > from > > the connection." string > > > > SQLSTATE "08006" > > string > > > > Source > > "FirebirdSql.Data.FirebirdClient" > > string > > > > StackTrace " at > > FirebirdSql.Data.Client.Managed.Version10.GdsStatement.Fetch()\r\n at > > FirebirdSql.Data.FirebirdClient.FbCommand.Fetch()" string > > > > + TargetSite > > {FirebirdSql.Data.Common.DbValue[] > > Fetch()} System.Reflection.MethodBase > > {System.Reflection.RuntimeMethodInfo} > > > > + Static members > > > > + Non-Public members > > > > Message "Error reading data > from > > the connection." string > > > > SQLSTATE "08006" > > string > > > > Source > > "FirebirdSql.Data.FirebirdClient" > > string > > > > StackTrace " at > > FirebirdSql.Data.FirebirdClient.FbCommand.Fetch()\r\n at > > FirebirdSql.Data.FirebirdClient.FbDataReader.Read()\r\n at > > System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping > > mapping)\r\n at > > System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable > > datatable, String srcTable, DataReaderContainer dataReader, Int32 > > startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object > > parentChapterValue)\r\n at System.Data.Common.DataAdapter.Fill(DataSet > > dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, > Int32 > > maxRecords)\r\n at System.Data.Common.DbDataAdapter.FillInternal( > DataSet > > dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, > > String srcTable, IDbCommand command, CommandBehavior behavior)\r\n at > > System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 > startRecord, > > Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior > > behavior)\r\n at System.Data.Common.DbDataAdapter.Fill(DataSet > dataSet, > > String srcTable)\r\n at HMSMaster.FHMSMaster.TableS_N_ROWS_Fill(String > > tableS, Int64 nRows, Int64 iSkip, String strOrderBy) in > > D:\\HMS\\AppHMS\\SolnHMS\\HMSMaster\\FHMSMaster.cs:line 1294" > > string > > > > + TargetSite > > {FirebirdSql.Data.Common.DbValue[] > > Fetch()} System.Reflection.MethodBase > > {System.Reflection.RuntimeMethodInfo} > > > > + Static members > > > > + Non-Public members > > > > > Additional inputs: > > I observed that while copying 13,26,000 records from source in batches of > 50,000 each, exception was raised after copying 12,50,000. > So from the source I deleted the already copied 12,50,000 records and > resumed to copy the remaining 76,000. > This also failed. > Attempted versions: 6 Alpha 2, 5.12.0.0, 5.11.0.0 and 4.5.2.0. > However, I could manually insert the 76,000 records using flamerobin. > > Now to copy this particular table of the database I am using > FbCommand's ExecuteNonQuery to run a stored procedure which copies record > using Execute Statement On External database. > This works fine and faster. > > For the time being, I appear to have manoeuvred out of dead end. > > > Inputs from firebird-support helped me pinpoint the issue in my case: Use of default isolation level in FbTransaction. Changing to the under mentioned resolved my issue : tx = con.BeginTransaction( new FbTransactionOptions() { TransactionBehavior = FbTransactionBehavior.Concurrency | FbTransactionBehavior.NoWait } ); > > > > -- > > > Mgr. Ji?? ?in?ura > > > https://www.tabsoverspaces.com/ > > > > > > > > > > > > > > > ------------------------------ > > > > > > ------------------------------------------------------------ > > > ------------------ > > > 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 139, Issue 6 > > > ***************************************************** > > > > > -------------- next part -------------- > > An HTML attachment was scrubbed... > > > > ------------------------------ > > > > ------------------------------------------------------------ > > ------------------ > > 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 139, Issue 7 > > ***************************************************** > > > -------------- next part -------------- > An HTML attachment was scrubbed... > > ------------------------------ > > ------------------------------------------------------------ > ------------------ > 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 139, Issue 9 > ***************************************************** > |
From: Jiri C. (JIRA) <tr...@fi...> - 2017-12-01 13:48:47
|
EF Core Migrations support -------------------------- Key: DNET-797 URL: http://tracker.firebirdsql.org/browse/DNET-797 Project: .NET Data provider Issue Type: Sub-task Components: Entity Framework Core 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...> - 2017-12-01 13:48:43
|
EF Core scaffolding support --------------------------- Key: DNET-798 URL: http://tracker.firebirdsql.org/browse/DNET-798 Project: .NET Data provider Issue Type: Sub-task Components: Entity Framework Core 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: LtColRDSChauhan <rds...@gm...> - 2017-11-23 05:24:57
|
On Sat, Nov 18, 2017 at 7:31 PM, < 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. Error reading data from the connection Re: > Firebird-net-provider Digest, Vol 139, Issue 6 (LtColRDSChauhan) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Sat, 18 Nov 2017 19:31:44 +0530 > From: LtColRDSChauhan <rds...@gm...> > To: fir...@li... > Subject: [Firebird-net-provider] Error reading data from the > connection Re: Firebird-net-provider Digest, Vol 139, Issue 6 > Message-ID: > <CAMG8wxj8BvBGE88rEvN=2zhg7-W9u-VSZPU_wtCJkok1WKrXgg@mail. > gmail.com> > Content-Type: text/plain; charset="utf-8" > > On Sat, Nov 18, 2017 at 5:46 PM, < > 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. Re: Error reading data from the connection Re: > > Firebird-net-provider Digest, Vol 139, Issue 3 (Ji?? ?in?ura) > > > > > > ---------------------------------------------------------------------- > > > > Message: 1 > > Date: Sat, 18 Nov 2017 09:07:35 +0100 > > From: Ji?? ?in?ura <ji...@ci...> > > To: fir...@li... > > Subject: Re: [Firebird-net-provider] Error reading data from the > > connection Re: Firebird-net-provider Digest, Vol 139, Issue 3 > > Message-ID: > > <1510992455.1577004.1176679856.4C4DB47A@webmail. > > messagingengine.com> > > Content-Type: text/plain; charset="utf-8" > > > > I would check inner exception to see what happened. > > > > > Thanks for responding, Jiri. > The details of exception are as under please. Let me know if more details > are required. > > > - ex {"Error reading data from the > connection."} FirebirdSql.Data.FirebirdClient.FbException > > + Data > {System.Collections.ListDictionaryInternal} > System.Collections.IDictionary > {System.Collections.ListDictionaryInternal} > > ErrorCode 335544726 int > > + Errors > {FirebirdSql.Data.FirebirdClient.FbErrorCollection} > FirebirdSql.Data.FirebirdClient.FbErrorCollection > > HResult -2147467259 int > > HelpLink null string > > - InnerException {"Error reading data from > the connection."} System.Exception > {FirebirdSql.Data.Common.IscException} > > + Data > {System.Collections.ListDictionaryInternal} > System.Collections.IDictionary > {System.Collections.ListDictionaryInternal} > > ErrorCode 335544726 int > > + Errors Count = 2 > System.Collections.Generic.List<FirebirdSql.Data.Common.IscError> > > HResult -2146233088 int > > HelpLink null string > > - InnerException {"I/O error occurred."} > System.Exception > {System.IO.IOException} > > + Data > {System.Collections.ListDictionaryInternal} > System.Collections.IDictionary > {System.Collections.ListDictionaryInternal} > > HResult -2146232800 int > > HelpLink null string > > - InnerException null > System.Exception > > + Static members > > Message "I/O error occurred." > string > > Source > "FirebirdSql.Data.FirebirdClient" > string > > StackTrace " at > FirebirdSql.Data.Client.Managed.XdrStream.ReadBytes(Int32 count)\r\n at > FirebirdSql.Data.Client.Managed.XdrStream.ReadNextOperation()\r\n at > FirebirdSql.Data.Client.Managed.Version11.GdsDatabase.NextOperation()\r\n > at > FirebirdSql.Data.Client.Managed.Version10.GdsStatement.Fetch()" > string > > + TargetSite {Byte[] > ReadBytes(Int32)} > System.Reflection.MethodBase {System.Reflection.RuntimeMethodInfo} > > + Static members > > + Non-Public members > > IsWarning false bool > > Message "Error reading data from > the connection." string > > SQLSTATE "08006" > string > > Source > "FirebirdSql.Data.FirebirdClient" > string > > StackTrace " at > FirebirdSql.Data.Client.Managed.Version10.GdsStatement.Fetch()\r\n at > FirebirdSql.Data.FirebirdClient.FbCommand.Fetch()" string > > + TargetSite > {FirebirdSql.Data.Common.DbValue[] > Fetch()} System.Reflection.MethodBase > {System.Reflection.RuntimeMethodInfo} > > + Static members > > + Non-Public members > > Message "Error reading data from > the connection." string > > SQLSTATE "08006" > string > > Source > "FirebirdSql.Data.FirebirdClient" > string > > StackTrace " at > FirebirdSql.Data.FirebirdClient.FbCommand.Fetch()\r\n at > FirebirdSql.Data.FirebirdClient.FbDataReader.Read()\r\n at > System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping > mapping)\r\n at > System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable > datatable, String srcTable, DataReaderContainer dataReader, Int32 > startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object > parentChapterValue)\r\n at System.Data.Common.DataAdapter.Fill(DataSet > dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 > maxRecords)\r\n at System.Data.Common.DbDataAdapter.FillInternal(DataSet > dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, > String srcTable, IDbCommand command, CommandBehavior behavior)\r\n at > System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, > Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior > behavior)\r\n at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, > String srcTable)\r\n at HMSMaster.FHMSMaster.TableS_N_ROWS_Fill(String > tableS, Int64 nRows, Int64 iSkip, String strOrderBy) in > D:\\HMS\\AppHMS\\SolnHMS\\HMSMaster\\FHMSMaster.cs:line 1294" > string > > + TargetSite > {FirebirdSql.Data.Common.DbValue[] > Fetch()} System.Reflection.MethodBase > {System.Reflection.RuntimeMethodInfo} > > + Static members > > + Non-Public members > > Additional inputs: I observed that while copying 13,26,000 records from source in batches of 50,000 each, exception was raised after copying 12,50,000. So from the source I deleted the already copied 12,50,000 records and resumed to copy the remaining 76,000. This also failed. Attempted versions: 6 Alpha 2, 5.12.0.0, 5.11.0.0 and 4.5.2.0. However, I could manually insert the 76,000 records using flamerobin. Now to copy this particular table of the database I am using FbCommand's ExecuteNonQuery to run a stored procedure which copies record using Execute Statement On External database. This works fine and faster. For the time being, I appear to have manoeuvred out of dead end. > > > -- > > Mgr. Ji?? ?in?ura > > https://www.tabsoverspaces.com/ > > > > > > > > > > ------------------------------ > > > > ------------------------------------------------------------ > > ------------------ > > 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 139, Issue 6 > > ***************************************************** > > > -------------- next part -------------- > An HTML attachment was scrubbed... > > ------------------------------ > > ------------------------------------------------------------ > ------------------ > 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 139, Issue 7 > ***************************************************** > |
From: Roberto C. da S. (JIRA) <tr...@fi...> - 2017-11-21 22:54:44
|
Mapping numeric types in the same configurable way you can do in Oracle ----------------------------------------------------------------------- Key: DNET-796 URL: http://tracker.firebirdsql.org/browse/DNET-796 Project: .NET Data provider Issue Type: New Feature Affects Versions: 5.vNext, 6.0.0.0 Environment: ADO.NET framework, entity Framework Reporter: Roberto Carlos da Silva Assignee: Jiri Cincura It would be great if in the Firebird .NET Drive there was a way to map the same numeric types you can do in the Oracle Driver. It would solve various system and framework migration incompatibility issues and make it easier to choose firebird as a database for the .NET platform. I think it would be very easy to do that. https://docs.oracle.com/database/121/ODPNT/entityDataTypeMapping.htm#ODPNT8300 -- 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: LtColRDSChauhan <rds...@gm...> - 2017-11-18 14:01:53
|
On Sat, Nov 18, 2017 at 5:46 PM, < 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. Re: Error reading data from the connection Re: > Firebird-net-provider Digest, Vol 139, Issue 3 (Ji?? ?in?ura) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Sat, 18 Nov 2017 09:07:35 +0100 > From: Ji?? ?in?ura <ji...@ci...> > To: fir...@li... > Subject: Re: [Firebird-net-provider] Error reading data from the > connection Re: Firebird-net-provider Digest, Vol 139, Issue 3 > Message-ID: > <1510992455.1577004.1176679856.4C4DB47A@webmail. > messagingengine.com> > Content-Type: text/plain; charset="utf-8" > > I would check inner exception to see what happened. > > Thanks for responding, Jiri. The details of exception are as under please. Let me know if more details are required. - ex {"Error reading data from the connection."} FirebirdSql.Data.FirebirdClient.FbException + Data {System.Collections.ListDictionaryInternal} System.Collections.IDictionary {System.Collections.ListDictionaryInternal} ErrorCode 335544726 int + Errors {FirebirdSql.Data.FirebirdClient.FbErrorCollection} FirebirdSql.Data.FirebirdClient.FbErrorCollection HResult -2147467259 int HelpLink null string - InnerException {"Error reading data from the connection."} System.Exception {FirebirdSql.Data.Common.IscException} + Data {System.Collections.ListDictionaryInternal} System.Collections.IDictionary {System.Collections.ListDictionaryInternal} ErrorCode 335544726 int + Errors Count = 2 System.Collections.Generic.List<FirebirdSql.Data.Common.IscError> HResult -2146233088 int HelpLink null string - InnerException {"I/O error occurred."} System.Exception {System.IO.IOException} + Data {System.Collections.ListDictionaryInternal} System.Collections.IDictionary {System.Collections.ListDictionaryInternal} HResult -2146232800 int HelpLink null string - InnerException null System.Exception + Static members Message "I/O error occurred." string Source "FirebirdSql.Data.FirebirdClient" string StackTrace " at FirebirdSql.Data.Client.Managed.XdrStream.ReadBytes(Int32 count)\r\n at FirebirdSql.Data.Client.Managed.XdrStream.ReadNextOperation()\r\n at FirebirdSql.Data.Client.Managed.Version11.GdsDatabase.NextOperation()\r\n at FirebirdSql.Data.Client.Managed.Version10.GdsStatement.Fetch()" string + TargetSite {Byte[] ReadBytes(Int32)} System.Reflection.MethodBase {System.Reflection.RuntimeMethodInfo} + Static members + Non-Public members IsWarning false bool Message "Error reading data from the connection." string SQLSTATE "08006" string Source "FirebirdSql.Data.FirebirdClient" string StackTrace " at FirebirdSql.Data.Client.Managed.Version10.GdsStatement.Fetch()\r\n at FirebirdSql.Data.FirebirdClient.FbCommand.Fetch()" string + TargetSite {FirebirdSql.Data.Common.DbValue[] Fetch()} System.Reflection.MethodBase {System.Reflection.RuntimeMethodInfo} + Static members + Non-Public members Message "Error reading data from the connection." string SQLSTATE "08006" string Source "FirebirdSql.Data.FirebirdClient" string StackTrace " at FirebirdSql.Data.FirebirdClient.FbCommand.Fetch()\r\n at FirebirdSql.Data.FirebirdClient.FbDataReader.Read()\r\n at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)\r\n at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)\r\n at System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)\r\n at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)\r\n at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)\r\n at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)\r\n at HMSMaster.FHMSMaster.TableS_N_ROWS_Fill(String tableS, Int64 nRows, Int64 iSkip, String strOrderBy) in D:\\HMS\\AppHMS\\SolnHMS\\HMSMaster\\FHMSMaster.cs:line 1294" string + TargetSite {FirebirdSql.Data.Common.DbValue[] Fetch()} System.Reflection.MethodBase {System.Reflection.RuntimeMethodInfo} + Static members + Non-Public members > -- > Mgr. Ji?? ?in?ura > https://www.tabsoverspaces.com/ > > > > > ------------------------------ > > ------------------------------------------------------------ > ------------------ > 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 139, Issue 6 > ***************************************************** > |
From: Jiří Č. <ji...@ci...> - 2017-11-18 08:07:41
|
I would check inner exception to see what happened. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ |
From: LtColRDSChauhan <rds...@gm...> - 2017-11-18 04:15:03
|
On Sat, Nov 18, 2017 at 6:25 AM, < 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. Error reading data from the connection Re: > Firebird-net-provider Digest, Vol 139, Issue 3 (LtColRDSChauhan) > 2. Re: Error reading data from the connection Re: > Firebird-net-provider Digest, Vol 139, Issue 3 (LtColRDSChauhan) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Fri, 17 Nov 2017 19:19:07 +0530 > From: LtColRDSChauhan <rds...@gm...> > To: fir...@li... > Subject: [Firebird-net-provider] Error reading data from the > connection Re: Firebird-net-provider Digest, Vol 139, Issue 3 > Message-ID: > <CAM...@ma...ail. > com> > Content-Type: text/plain; charset="utf-8" > > On Fri, Nov 17, 2017 at 5:38 PM, < > 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. Error reading data from the connection (LtColRDSChauhan) > > 2. Re: Error reading data from the connection (Gerdus van Zyl) > > > > > > ---------------------------------------------------------------------- > > > > Message: 1 > > Date: Thu, 16 Nov 2017 20:03:05 +0530 > > From: LtColRDSChauhan <rds...@gm...> > > To: fir...@li... > > Subject: [Firebird-net-provider] Error reading data from the > > connection > > Message-ID: > > <CAMG8wxjv-2MEg9j4cxO4bAjXpDGB6-nLVBQiVdSwVr63RqCT8g@mail. > > gmail.com> > > Content-Type: text/plain; charset="utf-8" > > > > Hello, > > > > 1. I need to frequently copy a table from one database to another. This > has > > started to fail now, apparently due to increase in number of records. > > Attempting to copy about 13,26,000 records fails reporting ?Error reading > > data from the connection?. Number of records that I can still successful > > copy is about 13,24,510. > > > > 3. I copy the in batches of 50,000 records (variable) each. For each > batch, > > i open and close connection. I have tried setting connection pooling true > > and false both. Also varied the batch size to 5000, 100000 etc. > > > > 2. My database and client are on the same machine. Other details: > > > > RAM 16 GB > > > > Client application 64 Bit > > > > OS Windows 10 64 Bit > > > > Firebird ADO.NET Data Provider ? tried both: 5.11.0.0 and 5.12.0 > > > > Firebird 3.0.2.32703_0_Win64 > > > > 3. Please suggest possible solutions. > > > > Regards, > > > > Rajiv > > -------------- next part -------------- > > An HTML attachment was scrubbed... > > > > ------------------------------ > > > > Message: 2 > > Date: Thu, 16 Nov 2017 16:51:38 +0200 > > From: Gerdus van Zyl <ger...@gm...> > > To: "For users and developers of the Firebird .NET providers" > > <fir...@li...> > > Subject: Re: [Firebird-net-provider] Error reading data from the > > connection > > Message-ID: > > <CALvycTnBNwJVQVsgV3tgEkdP-MOwRGCcUJX6G7sF1dqLYmXH3g@ > > mail.gmail.com> > > Content-Type: text/plain; charset="utf-8" > > > > You can just catch the exception, rollback the batch transaction if > > possible, reconnect and retry that batch again. > > Having retry logic is the only way to ensure reliability. > > > > I am using try-catch and roll back. > Also retrying again and again after roll back for last 48hrs. > The result is consistently the same ie copying about 13,26,000 records > fails reporting Error reading data from the connection, > while copying about 13,24,510 record always succeeds. > The issue here is more then just ensuring reliability. > May be I am missing out settings. > Please suggest possible solutions. > > > > > On 16 November 2017 at 16:33, LtColRDSChauhan <rds...@gm...> > wrote: > > > > > Hello, > > > > > > 1. I need to frequently copy a table from one database to another. This > > > has started to fail now, apparently due to increase in number of > records. > > > Attempting to copy about 13,26,000 records fails reporting ?Error > reading > > > data from the connection?. Number of records that I can still > successful > > > copy is about 13,24,510. > > > > > > 3. I copy the in batches of 50,000 records (variable) each. For each > > > batch, i open and close connection. I have tried setting connection > > pooling > > > true and false both. Also varied the batch size to 5000, 100000 etc. > > > > > > 2. My database and client are on the same machine. Other details: > > > > > > RAM 16 GB > > > > > > Client application 64 Bit > > > > > > OS Windows 10 64 Bit > > > > > > Firebird ADO.NET Data Provider ? tried both: 5.11.0.0 and 5.12.0 > > > > > > Firebird 3.0.2.32703_0_Win64 > > > > > > 3. Please suggest possible solutions. > > > > > > Regards, > > > > > > Rajiv > > > > > > > > > > > > ------------------------------------------------------------ > > > ------------------ > > > 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 > > > > > > > > -------------- next part -------------- > > An HTML attachment was scrubbed... > > > > ------------------------------ > > > > ------------------------------------------------------------ > > ------------------ > > 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 139, Issue 3 > > ***************************************************** > > > -------------- next part -------------- > An HTML attachment was scrubbed... > > ------------------------------ > > Message: 2 > Date: Sat, 18 Nov 2017 06:25:47 +0530 > From: LtColRDSChauhan <rds...@gm...> > To: fir...@li... > Subject: Re: [Firebird-net-provider] Error reading data from the > connection Re: Firebird-net-provider Digest, Vol 139, Issue 3 > Message-ID: > <CAMG8wxjSMZiWbsWcVxAxdAeqryPNn7R4w+a8JZRpAKx7QsOQ4w@mail. > gmail.com> > Content-Type: text/plain; charset="utf-8" > > On Fri, Nov 17, 2017 at 7:19 PM, LtColRDSChauhan <rds...@gm...> > wrote: > > > > > > > On Fri, Nov 17, 2017 at 5:38 PM, <firebird-net-provider- > > re...@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-pr > >> ovider > >> 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. Error reading data from the connection (LtColRDSChauhan) > >> 2. Re: Error reading data from the connection (Gerdus van Zyl) > >> > >> > >> ---------------------------------------------------------------------- > >> > >> Message: 1 > >> Date: Thu, 16 Nov 2017 20:03:05 +0530 > >> From: LtColRDSChauhan <rds...@gm...> > >> To: fir...@li... > >> Subject: [Firebird-net-provider] Error reading data from the > >> connection > >> Message-ID: > >> <CAM...@ma... > >> ail.com> > >> Content-Type: text/plain; charset="utf-8" > >> > >> Hello, > >> > >> 1. I need to frequently copy a table from one database to another. This > >> has > >> started to fail now, apparently due to increase in number of records. > >> Attempting to copy about 13,26,000 records fails reporting ?Error > reading > >> data from the connection?. Number of records that I can still successful > >> copy is about 13,24,510. > >> > >> 3. I copy the in batches of 50,000 records (variable) each. For each > >> batch, > >> i open and close connection. I have tried setting connection pooling > true > >> and false both. Also varied the batch size to 5000, 100000 etc. > >> > >> 2. My database and client are on the same machine. Other details: > >> > >> RAM 16 GB > >> > >> Client application 64 Bit > >> > >> OS Windows 10 64 Bit > >> > >> Firebird ADO.NET Data Provider ? tried both: 5.11.0.0 and 5.12.0 > >> > >> Firebird 3.0.2.32703_0_Win64 > >> > >> 3. Please suggest possible solutions. > >> > >> Regards, > >> > >> Rajiv > >> -------------- next part -------------- > >> An HTML attachment was scrubbed... > >> > >> ------------------------------ > >> > >> Message: 2 > >> Date: Thu, 16 Nov 2017 16:51:38 +0200 > >> From: Gerdus van Zyl <ger...@gm...> > >> To: "For users and developers of the Firebird .NET providers" > >> <fir...@li...> > >> Subject: Re: [Firebird-net-provider] Error reading data from the > >> connection > >> Message-ID: > >> <CALvycTnBNwJVQVsgV3tgEkdP-MOwRGCcUJX6G7sF1dqLYmXH3g@mail. > >> gmail.com> > >> Content-Type: text/plain; charset="utf-8" > >> > >> You can just catch the exception, rollback the batch transaction if > >> possible, reconnect and retry that batch again. > >> Having retry logic is the only way to ensure reliability. > >> > > > > I am using try-catch and roll back. > > Also retrying again and again after roll back for last 48hrs. > > The result is consistently the same ie copying about 13,26,000 records > > fails reporting Error reading data from the connection, > > while copying about 13,24,510 record always succeeds. > > The issue here is more then just ensuring reliability. > > > I could pin point the issue in my case. > > With the select command text for FbDataAdapter set as: > > SELECT first 50000 SKIP 1260000 * FROM PATIENT_BILL order by REGDID, SER > > Calling Fill raises the exception Error reading data from the connection > immediately on a freshly created single connection with no pooling. > > Am I missing some setting for FbDataAdapter? > 1. I have tried all combinations of connection string settings for: Connection Timeout, Connection lifetime, Pooling 2. For the DataSet tried FbDataAdapter and FbDataReader both. 3. Still the above issue surfaces consistently. 4. The issue appears to be: By time the records are fetched, connection is broken / closed. 5. Any possible solutions on this? > > > > May be I am missing out settings. > > Please suggest possible solutions. > > > > > > > >> On 16 November 2017 at 16:33, LtColRDSChauhan <rds...@gm...> > wrote: > >> > >> > Hello, > >> > > >> > 1. I need to frequently copy a table from one database to another. > This > >> > has started to fail now, apparently due to increase in number of > >> records. > >> > Attempting to copy about 13,26,000 records fails reporting ?Error > >> reading > >> > data from the connection?. Number of records that I can still > successful > >> > copy is about 13,24,510. > >> > > >> > 3. I copy the in batches of 50,000 records (variable) each. For each > >> > batch, i open and close connection. I have tried setting connection > >> pooling > >> > true and false both. Also varied the batch size to 5000, 100000 etc. > >> > > >> > 2. My database and client are on the same machine. Other details: > >> > > >> > RAM 16 GB > >> > > >> > Client application 64 Bit > >> > > >> > OS Windows 10 64 Bit > >> > > >> > Firebird ADO.NET Data Provider ? tried both: 5.11.0.0 and 5.12.0 > >> > > >> > Firebird 3.0.2.32703_0_Win64 > >> > > >> > 3. Please suggest possible solutions. > >> > > >> > Regards, > >> > > >> > Rajiv > >> > > >> > > >> > > >> > ------------------------------------------------------------ > >> > ------------------ > >> > 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 > >> > > >> > > >> -------------- next part -------------- > >> An HTML attachment was scrubbed... > >> > >> ------------------------------ > >> > >> ------------------------------------------------------------ > >> ------------------ > >> 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 139, Issue 3 > >> ***************************************************** > >> > > > > > -------------- next part -------------- > An HTML attachment was scrubbed... > > ------------------------------ > > ------------------------------------------------------------ > ------------------ > 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 139, Issue 4 > ***************************************************** > |
From: LtColRDSChauhan <rds...@gm...> - 2017-11-18 00:55:58
|
On Fri, Nov 17, 2017 at 7:19 PM, LtColRDSChauhan <rds...@gm...> wrote: > > > On Fri, Nov 17, 2017 at 5:38 PM, <firebird-net-provider- > re...@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-pr >> ovider >> 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. Error reading data from the connection (LtColRDSChauhan) >> 2. Re: Error reading data from the connection (Gerdus van Zyl) >> >> >> ---------------------------------------------------------------------- >> >> Message: 1 >> Date: Thu, 16 Nov 2017 20:03:05 +0530 >> From: LtColRDSChauhan <rds...@gm...> >> To: fir...@li... >> Subject: [Firebird-net-provider] Error reading data from the >> connection >> Message-ID: >> <CAM...@ma... >> ail.com> >> Content-Type: text/plain; charset="utf-8" >> >> Hello, >> >> 1. I need to frequently copy a table from one database to another. This >> has >> started to fail now, apparently due to increase in number of records. >> Attempting to copy about 13,26,000 records fails reporting ?Error reading >> data from the connection?. Number of records that I can still successful >> copy is about 13,24,510. >> >> 3. I copy the in batches of 50,000 records (variable) each. For each >> batch, >> i open and close connection. I have tried setting connection pooling true >> and false both. Also varied the batch size to 5000, 100000 etc. >> >> 2. My database and client are on the same machine. Other details: >> >> RAM 16 GB >> >> Client application 64 Bit >> >> OS Windows 10 64 Bit >> >> Firebird ADO.NET Data Provider ? tried both: 5.11.0.0 and 5.12.0 >> >> Firebird 3.0.2.32703_0_Win64 >> >> 3. Please suggest possible solutions. >> >> Regards, >> >> Rajiv >> -------------- next part -------------- >> An HTML attachment was scrubbed... >> >> ------------------------------ >> >> Message: 2 >> Date: Thu, 16 Nov 2017 16:51:38 +0200 >> From: Gerdus van Zyl <ger...@gm...> >> To: "For users and developers of the Firebird .NET providers" >> <fir...@li...> >> Subject: Re: [Firebird-net-provider] Error reading data from the >> connection >> Message-ID: >> <CALvycTnBNwJVQVsgV3tgEkdP-MOwRGCcUJX6G7sF1dqLYmXH3g@mail. >> gmail.com> >> Content-Type: text/plain; charset="utf-8" >> >> You can just catch the exception, rollback the batch transaction if >> possible, reconnect and retry that batch again. >> Having retry logic is the only way to ensure reliability. >> > > I am using try-catch and roll back. > Also retrying again and again after roll back for last 48hrs. > The result is consistently the same ie copying about 13,26,000 records > fails reporting Error reading data from the connection, > while copying about 13,24,510 record always succeeds. > The issue here is more then just ensuring reliability. > I could pin point the issue in my case. With the select command text for FbDataAdapter set as: SELECT first 50000 SKIP 1260000 * FROM PATIENT_BILL order by REGDID, SER Calling Fill raises the exception Error reading data from the connection immediately on a freshly created single connection with no pooling. Am I missing some setting for FbDataAdapter? > May be I am missing out settings. > Please suggest possible solutions. > > > >> On 16 November 2017 at 16:33, LtColRDSChauhan <rds...@gm...> wrote: >> >> > Hello, >> > >> > 1. I need to frequently copy a table from one database to another. This >> > has started to fail now, apparently due to increase in number of >> records. >> > Attempting to copy about 13,26,000 records fails reporting ?Error >> reading >> > data from the connection?. Number of records that I can still successful >> > copy is about 13,24,510. >> > >> > 3. I copy the in batches of 50,000 records (variable) each. For each >> > batch, i open and close connection. I have tried setting connection >> pooling >> > true and false both. Also varied the batch size to 5000, 100000 etc. >> > >> > 2. My database and client are on the same machine. Other details: >> > >> > RAM 16 GB >> > >> > Client application 64 Bit >> > >> > OS Windows 10 64 Bit >> > >> > Firebird ADO.NET Data Provider ? tried both: 5.11.0.0 and 5.12.0 >> > >> > Firebird 3.0.2.32703_0_Win64 >> > >> > 3. Please suggest possible solutions. >> > >> > Regards, >> > >> > Rajiv >> > >> > >> > >> > ------------------------------------------------------------ >> > ------------------ >> > 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 >> > >> > >> -------------- next part -------------- >> An HTML attachment was scrubbed... >> >> ------------------------------ >> >> ------------------------------------------------------------ >> ------------------ >> 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 139, Issue 3 >> ***************************************************** >> > > |
From: LtColRDSChauhan <rds...@gm...> - 2017-11-17 13:57:10
|
On Fri, Nov 17, 2017 at 5:38 PM, < 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. Error reading data from the connection (LtColRDSChauhan) > 2. Re: Error reading data from the connection (Gerdus van Zyl) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Thu, 16 Nov 2017 20:03:05 +0530 > From: LtColRDSChauhan <rds...@gm...> > To: fir...@li... > Subject: [Firebird-net-provider] Error reading data from the > connection > Message-ID: > <CAMG8wxjv-2MEg9j4cxO4bAjXpDGB6-nLVBQiVdSwVr63RqCT8g@mail. > gmail.com> > Content-Type: text/plain; charset="utf-8" > > Hello, > > 1. I need to frequently copy a table from one database to another. This has > started to fail now, apparently due to increase in number of records. > Attempting to copy about 13,26,000 records fails reporting ?Error reading > data from the connection?. Number of records that I can still successful > copy is about 13,24,510. > > 3. I copy the in batches of 50,000 records (variable) each. For each batch, > i open and close connection. I have tried setting connection pooling true > and false both. Also varied the batch size to 5000, 100000 etc. > > 2. My database and client are on the same machine. Other details: > > RAM 16 GB > > Client application 64 Bit > > OS Windows 10 64 Bit > > Firebird ADO.NET Data Provider ? tried both: 5.11.0.0 and 5.12.0 > > Firebird 3.0.2.32703_0_Win64 > > 3. Please suggest possible solutions. > > Regards, > > Rajiv > -------------- next part -------------- > An HTML attachment was scrubbed... > > ------------------------------ > > Message: 2 > Date: Thu, 16 Nov 2017 16:51:38 +0200 > From: Gerdus van Zyl <ger...@gm...> > To: "For users and developers of the Firebird .NET providers" > <fir...@li...> > Subject: Re: [Firebird-net-provider] Error reading data from the > connection > Message-ID: > <CALvycTnBNwJVQVsgV3tgEkdP-MOwRGCcUJX6G7sF1dqLYmXH3g@ > mail.gmail.com> > Content-Type: text/plain; charset="utf-8" > > You can just catch the exception, rollback the batch transaction if > possible, reconnect and retry that batch again. > Having retry logic is the only way to ensure reliability. > I am using try-catch and roll back. Also retrying again and again after roll back for last 48hrs. The result is consistently the same ie copying about 13,26,000 records fails reporting Error reading data from the connection, while copying about 13,24,510 record always succeeds. The issue here is more then just ensuring reliability. May be I am missing out settings. Please suggest possible solutions. > On 16 November 2017 at 16:33, LtColRDSChauhan <rds...@gm...> wrote: > > > Hello, > > > > 1. I need to frequently copy a table from one database to another. This > > has started to fail now, apparently due to increase in number of records. > > Attempting to copy about 13,26,000 records fails reporting ?Error reading > > data from the connection?. Number of records that I can still successful > > copy is about 13,24,510. > > > > 3. I copy the in batches of 50,000 records (variable) each. For each > > batch, i open and close connection. I have tried setting connection > pooling > > true and false both. Also varied the batch size to 5000, 100000 etc. > > > > 2. My database and client are on the same machine. Other details: > > > > RAM 16 GB > > > > Client application 64 Bit > > > > OS Windows 10 64 Bit > > > > Firebird ADO.NET Data Provider ? tried both: 5.11.0.0 and 5.12.0 > > > > Firebird 3.0.2.32703_0_Win64 > > > > 3. Please suggest possible solutions. > > > > Regards, > > > > Rajiv > > > > > > > > ------------------------------------------------------------ > > ------------------ > > 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 > > > > > -------------- next part -------------- > An HTML attachment was scrubbed... > > ------------------------------ > > ------------------------------------------------------------ > ------------------ > 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 139, Issue 3 > ***************************************************** > |