New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Out Of memory using transaction [DNET209] #217
Comments
Commented by: @cincuranet The code/test would be helpful. |
Commented by: Nicolas T (nftimmers) Hello Jiri sorry i was in vacation, you want i send a Example test or can put the code here ?? |
Commented by: @cincuranet Code will be better. |
Commented by: Nicolas T (nftimmers)
|
Modified by: Nicolas T (nftimmers)priority: Major [ 3 ] => Critical [ 2 ] |
Commented by: @cincuranet With this code, I'm not able to run it (not taking into account need to prepare it). I.e. the line tabelaatual = DtListaTabelas.Rows[i][1].ToString(); is wrong. Post a simple code, that's ready to be run (preferably console app) and shows the error. |
Commented by: @cincuranet And BTW did you tried 2.5 FirebirdClient? |
Commented by: A. Murat Ozdemiray (ozdemiray) I have a similar problem. I use Firebird server 2.1.1, and .NET Provider 2.5. When I start a transaction and delete some records in that transaction, I observe that Firebird server memory usage increases. even though I commit that transaction, the memory usage does not decrease. Whenever I close the connection, the memory usage decreases to previous state. In http://www.firebirdfaq.org/faq118/ says that "If you are programming the Firebird C API directly, check your code. Otherwise, it might be a bug in the connectivity library you use.", so I thought it is a problem of the driver. |
Commented by: @cincuranet Without a working test case it's useless to even comment. To fix it, I need to see the problem on some exmple. |
Commented by: Nicolas T (nftimmers) Hello everyone sorry for comment late I Found the problem and is thar .net framework dont alow you to databing a datatable with 1 milion registrys but what i saw was the using of a transaction makes the out of memory hapens early. Tanks ! |
Commented by: @cincuranet I just fixed DNET274, with similar behavior, probably. Maybe this is fixed. Anyway, until I got working test case, I'm closing it as incomplete. |
Modified by: @cincuranetComponent: http://ASP.NET Providers [ 10090 ] => |
Submitted by: Nicolas T (nftimmers)
Votes: 1
Hello
I am doing a conversion from a GDB database to a FDB database for a tables, but my database have around 3g, and after a few tests the table having aroung 1 milion register, if i use the transaction i got a out of memory exception, but if i remove the transaction the process go OK, i already tried to put a test and commit after 1000 registers in the Wile, but the problem persists.
Tanks
The text was updated successfully, but these errors were encountered: