Document Type | Troubleshooting
Category | Patch/Upgrade
Applicable Product Versions | 6FS07PS, 7FS02PS
Document Number | TPATS009
Issue
NoteThis phenomenon occurred in Tibero7 fs02 version.
While executing an internal query to retrieve statistical information, an Out Of Memory error occurred simultaneously with an Internal Error !"slab_free to a free slab chunk."
Below is the content of sys.log.
[2024-07-12T00:17:15.365551] [FRM-664] [I] THROW. ec=ERROR_OUT_OF_SHP(-3002) [ Out of memory (unable to allocate 40 bytes of shared pool memory).] (csr_id:4294967295) [region_alloc.c:420:real_sys_region_allocator_new] [2024-07-12T00:17:15.365567] [ALC-664] [I] slab_free to a free slab chunk. chunk: 00007f5018ff7a98 free: 1 slab_size: 1080 ext_num: 40 alloc_owner_id: 664 [2024-07-12T00:17:15.366248] [COM-664] [I] Internal Error with condition '!"slab_free to a free slab chunk."' (5 args) (slab_alloc.c:566:slab_free) (pid=587873, sessid=664, tid=664) [2024-07-12T00:17:15.369089] [ALC-1709] [I] Can't extend the allocator space. name: (SHP parent allocator) MISC, ext_size: 16777216, total size: 4395630592, max size: 4400090964 [2024-07-12T00:17:15.369101] [FRM-1709] [I] THROW. ec=ERROR_OUT_OF_SHP(-3002) [ Out of memory (unable to allocate 40 bytes of shared pool memory).] (csr_id:4294967295) [region_alloc.c:420:real_sys_region_allocator_new] [2024-07-12T00:17:15.369105] [FRM-1709] [I] THROW. ec=ERROR_OUT_OF_SHP(-3002) [ Out of memory (unable to allocate 0 bytes of shared pool memory).] (csr_id:4294967295) [secu_authen.c:1303:secu_check_profile]
Cause
An Out Of Memory error occurred during the execution of an internal query within Tibero to retrieve statistical information.
During the exception handling for the Out Of Memory error, an attempt was made to release a cursor twice that was used for the internal query execution, which caused the Internal Error.
Solutions
The issue can be resolved by applying patch 259638e, which modifies Tibero's exception handling logic to prevent double resource release of cursors.
CautionApply the patch through technical support provided by Tmax Tibero.