Skip to main content

Search

Welcome to Tibero GTS!

Error (-7200) Occurrence Due to Incorrect UNDO_RETENTION Setting Value

Document Type | Troubleshooting

Category | Administration

Applicable Product Version | 6FS07, 7FS02

Error Code | 7200

Document Number | TADTS053

 

Issue

UNDO_RETENTION=86400 parameter was set, and upon system startup, the following error occurred, preventing normal startup.
iparam condition check failed. name:_TSN_TIME_MAP_INTERVAL, value: 8
*** Tibero initialization parameter (tip) file failure:
Error (-7200) occurred while processing parameter '_TSN_TIME_MAP_INTERVAL' and value '8'    (_TSN_TIME_MAP_INTERVAL must be between 0 and 2147483647)..
Tip file path = /tibero/tibero7/config/$TB_SID.tip

 

Cause

UNDO_RETENTION <= _TSN_TIME_MAP_SIZE * _TSN_TIME_MAP_INTERVAL is a newly added condition that must be satisfied.
Therefore, when the undo_retention value is changed to a value larger than _TSN_TIME_MAP_SIZE, the above condition is not met, causing a tberr -7200 error.
 
 

Solutions

1. Adjust the parameter value according to the formula UNDO_RETENTION <= _TSN_TIME_MAP_SIZE * _TSN_TIME_MAP_INTERVAL.
 
2. Apply the patch to resolve the issue. (Applied patch: 321199)
By applying this patch, the default size of _TSN_TIME_MAP_SIZE will be increased from 10,000 to 200,000. Also, undo_retention value changes will internally adjust the _TSN_TIME_MAP_INTERVAL value, allowing users to freely change the undo_retention value without considering other parameter values.

Caution

Apply the patch through technical support provided by Tmax Tibero.

Note

  • UNDO_RETENTION : Specifies the minimum time period in seconds that undo information can be retained.
    (default: 900, dynamic parameter)
  • _TSN_TIME_MAP_SIZE : Size of the table holding TSN-TIME MAP information.
    (default: 10000, type: INT32 / static parameter)
  • _TSN_TIME_MAP_INTERVAL : Interval period for adding TSN-TIME MAP information.
    (default: MAX(UNDO_RETENTION/_TSN_TIME_MAP_SIZE, 1), type: INT32 / dynamic parameter)

 

 

 

Related to