Bug #28197 Falcon integer overrun for FALCON_SYSTEM_MEMORY_SUMMARY.TOTAL_SPACE
Submitted: 2 May 2007 11:42 Modified: 6 Jun 2007 12:07
Reporter: Hakan Küçükyılmaz Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Falcon storage engine Severity:S3 (Non-critical)
Version:6.0.0-alpha OS:Any
Assigned to: Hakan Küçükyılmaz CPU Architecture:Any

[2 May 2007 11:42] Hakan Küçükyılmaz 
Description:
INFORMATION_SCHEMA.FALCON_SYSTEM_MEMORY_SUMMARY.TOTAL_SPACE shows integer overrun.

How to repeat:
Set falcon_max_record_memory to 4096MB and monitor  
  INFORMATION_SCHEMA.FALCON_SYSTEM_MEMORY_SUMMARY

After some while TOTAL_SPACE gets an integer overrun.

mysql> SELECT * FROM INFORMATION_SCHEMA.FALCON_SYSTEM_MEMORY_SUMMARY;
+-------------+------------+---------------+-----------+-------------+--------------+
| TOTAL_SPACE | FREE_SPACE | FREE_SEGMENTS | BIG_HUNKS | SMALL_HUNKS | UNIQUE_SIZES |
+-------------+------------+---------------+-----------+-------------+--------------+
| -1659843744 |     901104 |             5 |        19 |         425 |            3 |
+-------------+------------+---------------+-----------+-------------+--------------+
1 row in set (1.84 sec)
[2 May 2007 12:56] Hakan Küçükyılmaz 
Same applies for INFORMATION_SCHEMA.FALCON_RECORD_CACHE_SUMMARY.TOTAL_SPACE

mysql> insert into t1 select * from t1;
Query OK, 16577216 rows affected (8 min 10.65 sec)
Records: 16577216  Duplicates: 0  Warnings: 0

mysql> commit;
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT * FROM INFORMATION_SCHEMA.FALCON_RECORD_CACHE_SUMMARY;
+-------------+------------+---------------+-----------+-------------+--------------+
| TOTAL_SPACE | FREE_SPACE | FREE_SEGMENTS | BIG_HUNKS | SMALL_HUNKS | UNIQUE_SIZES |
+-------------+------------+---------------+-----------+-------------+--------------+
| -1260388352 |    1122896 |             1 |      1447 |           0 |            1 |
+-------------+------------+---------------+-----------+-------------+--------------+
1 row in set (4.45 sec)
[4 May 2007 18: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/26126

ChangeSet@1.2512, 2007-05-04 20:26:17+02:00, hakank@lu0011.wdf.sap.corp +3 -0
  Try to fix Bug#28197.
[18 May 2007 12:08] 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/26967

ChangeSet@1.2523, 2007-05-18 12:33:54+02:00, hakank@lu0011.wdf.sap.corp +3 -0
  Reviewed fix for Bug#28197.
  
  FALCON_RECORD_CACHE_SUMMARY.FREE_SPACE and
  FALCON_SYSTEM_MEMORY_SUMMARY.FREE_SPACE looks still quite small
  but no integer overruns anymore.
[18 May 2007 14:31] 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/26993

ChangeSet@1.2524, 2007-05-18 16:31:23+02:00, hakank@lu0011.wdf.sap.corp +1 -0
  After review changes for Bug#28197.
[6 Jun 2007 12:07] MC Brown 
A note has been added to the 6.0.1 changelog.