Document Type | Troubleshooting
Category | Administration
Applicable Product Version | 5SP1 FS02
Document Number | TADTS081
Issue
An Internal error 'false' error occurred in the tracelog.
Cause
Upon checking the tracelog and callstack, the error occurred due to an incorrect reference during the process of freeing memory of a value used in PSM.
tracelog
11/28 14:04:23.194920 [COM][0] 6780 tbsvr_tr:218 Internal Error with condition '!"false"' (alloc_dbginfo.h:390) (pid=11974, tid=6780) 11/28 14:09:23.601004 [COM][0] 5174 tbsvr_tr:218 Internal Error with condition '!"false"' (alloc_dbginfo.h:390) (pid=11813, tid=5174)
callstack
ffffffff7b6dbe9c nanosleep (ffffffff78a050f0, ffffffff78a050e0) 0000000104d3bda0 callstack_dump_ex (11e10eda0, 40, 0, 2e25, 0, 3c) + 4c8 0000000104d2b0d4 tb_tracedump (11e000, ffffffff7ac19478, 0, 123400, 11fdae, 11de4aac0) + 7c 0000000104d2b880 tb_assert_msg (1179abf2270, 118864000, 1004bd47688, 6952, 118800, ffffffff7bd03250) + 4d0 0000000100fb0fc4 region_realloc (1241d6fc0, ffffffff77846de0, 2100, ffffffff7784aee0, 129, 11a425f00) + 48c 00000001091ea7cc psm_vm_mm_pool_compaction (ffffffff79caa138, 420, 1ff8, 400, 0, 1241d6fc0) + 684 000000010977dd4c psm_subprog (11ff43, 0, ffffffff79c7c088, ffffffffffffffe0, 0, 1004bd47688) + 204 000000010cf5a6f4 expc_eval_udf (ffffffff78a06330, ffffffff79db1578, ffffffff79db3c50, ffffffff79db4248, ffffffff79db26e8, 3) + 79c 000000010cf58460 expc_eval_internal (ffffffff78a06330, ffffffff79db1578, 1, 1fe, ffffffff79db4248, 11c1c5248) + 1420 00000001120d853c xi_serialize_expcs_to_tmp_chunk (ffffffff78a06330, ffffffff79db1578, 6, ffffffff79c95538, 31, 1) + 13c 000000010ed73004 op_join_nested_loop (ffffffff78a06330, ffffffff79c954e8, ffffffff79c955e8, ffffffff79c955f8, 47c, 1179abfa178) + fc4 000000010ecceb68 op_join_stage_idx_join (ffffffff78a06330, ffffffff79c954e8, ffffffff79c955b8, ffffffff79c955f8, 232b30, 11c847f20) + c8 000000010eccf11c op_join_idx (ffffffff79c954e8, 0, f17ba58, ffffffffffffffd8, 11de4aac0, ffffffff79c955b8) + bc 000000010bc6d334 ex_run_internal (ffffffff79c3ea38, 1, 1179abfa178, 602c, 100259b6250, 10eccf060) + bc4 000000010c471310 csr_fetch (1168897f100, 11bf59800, 100259bddb8, 0, ffffffff79c3ea38, 1) + 7c0 0000000101251dd0 tbsvr_sql_process (101000, 0, 1004bd47688, 100259b6250, 1d000, ffffffff78a06dd0) + 3ac0 00000001011b7fb0 tbsvr_msg_sql_common (ffffffffffffffe0, 0, 51a7, ffffffffffffffe0, 1004bd47688, 6) + 1190 00000001010f69e8 tbsvr_handle_msg_internal (1d1d0, 0, ffffffff7ac25ed8, ffffffffffffffe0, 100259b6250, ffffffffffffffe0) + bc0 00000001010f8a58 tbsvr_wthr_request_from_cl_conn (1005512a2f0, 4784f, ffffffffffffffe0, 1d1c8, ffffffffffffffd8, 1004bd47688) + 11b0 00000001010f3e84 tbsvr_body (ffffffff7bd03250, 6800, 101000, 11de4aac0, 697a, ffffffffffffffd0) + 121c 00000001010e6cc8 thread_main_chk_bitmask (115f17000, 800000000000, 123710000, 51bd, 0, 1) + 350 00000001010f22c0 svr_wthr_main_internal (80000000000000, 100259b6250, 800000000000, 1d000, ffffffffffffffd8, 51c8) + d38 0000000104e0e11c svr_wthr_init (1436, 10055133e70, 123710000, 11de4aac0, 10000, 123731000) + 15c
Solutions
The error occurred due to an incorrect reference while freeing the memory of a value used in psm. To resolve this, it is recommended to change the parameter _PSM_NO_VM_MM_COMPACTION to Y.
Parameter Description
Controls the operation method of memory management (relocation and release) performed upon completion of PSM operation.
How to Set
Can be set per node while online. (No service stop required)
Apply online after connecting to tbsql (immediate effect)
$ tbsql sys/tibero
SQL> ALTER SYSTEM SET _PSM_NO_VM_MM_COMPACTION = Y;Modify $TB_SID.tip file (to retain after restart)
$ vi $TB_HOME/config/$TB_SID.tip _PSM_NO_VM_MM_COMPACTION = Y