Issue Details (XML | Word | Printable)

Key: CORE-3951
Type: Bug Bug
Status: Open Open
Priority: Major Major
Assignee: Unassigned
Reporter: Pera Detlic
Votes: 1
Watchers: 2
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Database grows each time procedure with blob type is called

Created: 09/Oct/12 05:36 PM   Updated: 30/May/13 02:45 AM
Component/s: Engine
Affects Version/s: 2.5.1
Fix Version/s: None

Environment: Windows 7 x64 , Firebird 2.5.1 final and 2.5.3 daily build , Lazarus, IBExpert, EMS SQL Manager
Issue Links:
Duplicate
 
Relate
 


 Description  « Hide
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.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.