Watch, Follow, &
Connect with Us
Public Report
Report From: InterBase/Server/Internal/Performance Monitoring tables    [ Add a report in this area ]  
Report #:  120810   Status: Closed
TMP$DATABASE use Integer for memory raport and can be overflow
Project:  InterBase Build #:  WI-V10.0.5.595
Version:    10.0 Submitted By:   Karol Bieniaszewski
Report Type:  Basic functionality failure Date Reported:  11/27/2013 6:00:11 AM
Severity:    Commonly encountered problem Last Updated: 5/8/2015 9:19:34 AM
Platform:    Not OS or platform specific Internal Tracking #:  
Resolution: Fixed (Resolution Comments) Resolved in Build: : 12.0
Duplicate of:  None
Voting and Rating
Overall Rating: No Ratings Yet
0.00 out of 5
Total Votes: None
Description
TMP$DATABASE use Integer fields for memory raport and can be overflow
affected fields - may be more but we use only this fields
TMP$SORT_MEMORY

  TMP$CURRENT_MEMORY



for few our databases values are negative for such fields


Steps to Reproduce:
None
Workarounds
None
Attachment
ibconfig.zip
Comments

Karol Bieniaszewski at 2/5/2014 12:06:42 AM -
>>Having said that, TMP$SORT_MEMORY should typically not overflow the 2 billion mark. If you are using >>InterBase 64-bit, and have thousands of SORT operations happening simultaneously, you could spill over >>the 2 billion mark. Can you tell me what your SORTMEM_BUFFER_SIZE setting in ibconfig file, and how >>many clients are simultaneously connected to your databases (in a single server)?

SORTMEM_BUFFER_SIZE
   20971520
i attache ibconfig - you see my whole settings

to one database are ~20 users connected

but we not have in sort mem negative values only in curent mem -
i only post that this two fields we use and both are integers

Sriram Balasubramanian at 2/6/2014 10:37:06 AM -
Ok; thanks for the feedback. Your SORTMEM_BUFFER_SIZE is looking alright; no problems there. I misunderstood your mention of TMP$SORT_MEMORY thinking you are reporting a problem with SORT memory.

The issue with TMP$CURRENT_MEMORY rolling over a 2 billion value is known. We will enable 64bit integer support for this in a future major release.

Karol Bieniaszewski at 5/7/2015 12:46:21 AM -
This ticket can be closed as fixed in XE7
In XE7 this fields are as "RDB$LARGE_MEMORY" - Numeric(18,0)

Server Response from: ETNACODE01