Skip to content
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

EF firebird dies because of out of memory [DNET274] #285

Closed
firebird-automations opened this issue Sep 18, 2009 · 8 comments
Closed

EF firebird dies because of out of memory [DNET274] #285

firebird-automations opened this issue Sep 18, 2009 · 8 comments

Comments

@firebird-automations
Copy link

Submitted by: Alexander (sms-timing)

Relate to DNET852

Attachments:
Die.zip

I have an issue. It looks like something is not cleaned up in the code. Or even worse, something is not reused when it could be reused.
When we do a batch import of many persons over the EF firebird dies because of out of memory. (1.5 GB in 20 seconds)

What I do is making 20000 persons and then call SaveChanges. For each person it opens a unique prepared statement inside fb. Danny showed me the existence of the mon$statements table and it shows you 11481 equal insert statements. (then it crashes)

So or you forget to dispose the query somewhere, or you should reuse an existing query.

Commits: c02ccc7

@firebird-automations
Copy link
Author

Modified by: @cincuranet

Attachment: Die.zip [ 11498 ]

@firebird-automations
Copy link
Author

Modified by: @cincuranet

Attachment: Die.zip [ 11498 ] =>

@firebird-automations
Copy link
Author

Modified by: @cincuranet

Attachment: Die.zip [ 11499 ]

@firebird-automations
Copy link
Author

Commented by: @cincuranet

Attached demo from Alexander.

@firebird-automations
Copy link
Author

Modified by: @cincuranet

reporter: Jiri Cincura [ cincura_net ] => Alexander [ sms-timing ]

@firebird-automations
Copy link
Author

Modified by: @cincuranet

status: Open [ 1 ] => In Progress [ 3 ]

@firebird-automations
Copy link
Author

Modified by: @cincuranet

status: In Progress [ 3 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 2.5.2 [ 10370 ]

@firebird-automations
Copy link
Author

Modified by: @cincuranet

Link: This issue relate to DNET852 [ DNET852 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants