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

Database grows each time procedure with blob type is called [CORE3951] #4284

Open
firebird-automations opened this issue Oct 9, 2012 · 6 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Pera Detlic (bambam)

Is related to CORE4109
Is related to CORE3953
Is related to CORE3952
Is duplicated by CORE4109

Votes: 1

Define output variable in stored procedure type blob (subtype text , size 80) and put a string data in it with few for-select-do loops with no insert, delete or update.
After executing procedure database file grows up from few MB to 80MB and each time is called, it become larger for around 80MB - it goes up to a few GB.
If you make sweep , no change on file size.
If you make a backup and restore , size is back again on few MB (like it was at beginning).
Just change variable type from blob to varchar (size 30000) and everything is working just fine - no file size changing - procedure even run 10 times faster.

@firebird-automations
Copy link
Collaborator Author

Modified by: Sean Leyne (seanleyne)

Link: This issue is related to CORE4109 [ CORE4109 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: Sean Leyne (seanleyne)

Link: This issue is related to CORE3953 [ CORE3953 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: Sean Leyne (seanleyne)

Link: This issue is related to CORE3952 [ CORE3952 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: Sean Leyne (seanleyne)

Link: This issue is duplicated by CORE4109 [ CORE4109 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: Sean Leyne (seanleyne)

summary: file enlarge each time procedure with blob type is called => Database grows each time procedure with blob type is called

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

security: Developers [ 10012 ] =>

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

1 participant