After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 636459 - Slots table grows without limit when using sql backend
Slots table grows without limit when using sql backend
Status: RESOLVED FIXED
Product: GnuCash
Classification: Other
Component: Backend - SQL
git-master
Other All
: Normal normal
: ---
Assigned To: John Ralls
Chris Shoemaker
Depends on:
Blocks:
 
 
Reported: 2010-12-04 15:36 UTC by John Ralls
Modified: 2018-06-29 22:48 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description John Ralls 2010-12-04 15:36:51 UTC 
Elwood Hunt <elwood.hunt@gmail.com> writes:

> I am using version 2.3.16 with MySQL as the database.  For backups, I will
> often use MySQL Administrator to export the entire schema to an SQL DDL
> file.  I recently noticed that the size of my backup file grew from ~ 800K
> to  ~ 2.8MB after adding a budget for one month (I have maybe 25 expense
> accounts).  I also noticed that it was the slots table that grew so much
> (several thousand additional rows).  Is this normal or did something go
> wrong?

This is due to the fact that slots_save() in src/backends/sql/gnc-slots-sql.c doesn't update existing slots entries, it just inserts a new entry.
Comment 1 John Ralls 2010-12-05 01:58:01 UTC 
Committed r19908, which recursively deletes contained slots.
Comment 2 John Ralls 2010-12-07 21:31:15 UTC 
Elwood reports the change fixes the problem.
Comment 3 John Ralls 2018-06-29 22:48:53 UTC 
GnuCash bug tracking has moved to a new Bugzilla host. This bug has been copied to https://bugs.gnucash.org/show_bug.cgi?id=636459. Please update any external references or bookmarks.