Skip to main content

Search

Welcome to Tibero GTS!

FDPOOL Garbage Collection Operation Every 36 Minutes Issue Document Type: Incident Resolution

Document Type | Troubleshooting

Category | Patch/Upgrade

Applicable Product Version | 7FS02PS

Document Number | TPATS002

 

Issue

When applying Tibero 7.2.2 FS02PS_314731a, the patch was created to operate by default every 6 hours, but Garbage Collection runs every 36 minutes. Also, the syslog shows logs such as โ€˜start fdpool garbage collection / end fdpool garbage collection, invl fd = [ fd number ]โ€™.

 

 

Cause

This issue is caused by the omission of the INTERVAL IPARAM *10 logic when the agent was improved during the upgrade from Tibero 6 to 7.
 
 

Solutions

Apply a patch to operate in seconds to resolve the issue. (Patch applied: FS02PS_314731b)
Caution
Apply the patch through technical support provided by Tmax Tibero. 
Note
If the patch is not applied, here is how to manually adjust the FDPOOL_GC_INTERVAL value.
 
  • Dynamic Application Method
    SQL> alter system set _FDPOOL_GC_INTERVAL=[VALUE];
 
  • Static Application Method: Specify the parameter name and value in the tip file
    _FDPOOL_GC_INTERVAL=[VALUE]

 

 

 

 

Related to