Bug #34778 Possible memory leak running UPDATEs in tight loop
| Submitted: | 23 Feb 2008 18:03 | Modified: | 9 Oct 2008 11:43 |
|---|---|---|---|
| Reporter: | Hakan Küçükyılmaz | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Falcon storage engine | Severity: | S3 (Non-critical) |
| Version: | 6.0.4, mysql-6.0-falcon-team | OS: | Any |
| Assigned to: | Christopher Powers | CPU Architecture: | Any |
| Tags: | F_SCAVENGER | ||
[23 Feb 2008 18:03]
Hakan Küçükyılmaz
[25 Feb 2008 16:13]
Ann Harrison
I'm not at all sure this is a bug... even an update that sets values to itself does create new record versions. Until the backlog is in place, that can fill memory.
[25 Feb 2008 16:23]
Hakan Küçükyılmaz
We have run this test lot's of times already. The memory consumption got stable after Kevin had fixed couple of memory leaks.
[30 Mar 2008 7:26]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/44649 ChangeSet@1.2623, 2008-03-30 02:24:29-05:00, cpowers@xeno.mysql.com +8 -0 Bug#34778, "Possible memory leak running UPDATEs in tight loop" This test generates thousands of prior record versions for just a very few records. The record scavenger ignored the prior record chain because the base record was not a scavenge candidate. The scavenger now scavenges prior records that match the transaction and record generation criteria, even when the base record is not scavengable.
[10 Apr 2008 19:14]
Bugs System
Pushed into 6.0.5-alpha
[9 Oct 2008 11:43]
Jon Stephens
Documented in the 6.0.5 changelog as follows:
Repeated UPDATE operations on a Falcon table could cause a memory leak.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.054 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.