Skip to main content

Search

Welcome to Tibero GTS!

Error Occurs When Performing System Memory Dump in TAC Environment

Document Type | Troubleshooting

Category | Monitoring/Inspection

Applicable Product Versions | 6FS06, 6FS07, 6FS07PS, 6FS06, 6FS07, 6FS07PS

Error Code | 12123

Document Number | TMOTS003

 

Issue

When the _INC_DSPC_CNT parameter is set, performing a system memory dump (alter system dump systemalloc;) results in the error 'TBR-12123: An attempt to begin sysdump has failed.'
SQL> select name, dflt_value, value from _vt_parameter where name='_INC_DSPC_CNT';

NAME	         DFLT_VALUE	  VALUE
-------------  ----------   -----
_INC_DSPC_CNT	          0     	1

SQL> alter system dump systemalloc;

TBR-12123: An attempt to begin sysdump has failed.
 
 

Cause

In the TAC environment, when the _INC_DSPC_CNT parameter is applied, there is no exception handling logic for memory dump of the Dispatcher thread responsible for message reception, causing the dump operation to fail.
Note
_INC_DSPC_CNT: The number of threads responsible for message reception during TCP communication between DB nodes
-- sys.log
[02-10T14:32:39.643097] [DDL-194] [I] Executing DDL: alter system dump systemalloc
[02-10T14:32:50.057710] [FRM-10] [I] The following working thread failed to stop. tid: 132 serial no: 0, pid: 22348072, status: 3.
[02-10T14:32:50.057857] [FRM-10] [I] An attempt to stop 22348072 process for sysdump has failed. Resuming all threads back to normal.
[02-10T14:32:50.068475] [FRM-194] [I] THROW. ec=ERROR_SYSDUMP_FAILED(-12123) [ An attempt to begin sysdump has failed.] (csr_id:4294967295) [dump_thread.c:858:scs_dump_phm]
[02-10T14:32:50.076763] [DDL-194] [I] DDL execution failed (ec = -12123): alter system dump systemalloc
SQL>  select * from v$process where tid=132;

  PID|       TID|      SPID|        NAME|       ATCHWAIT         

---------|----------|----------|------------|---------------
       10|       132|  20644352|        DSPC|       0x00
 
 

Solutions

Enhance the exception handling logic for the Dispatcher thread so that the memory dump can be performed normally. (Applied Patch: 326504a)
Caution
Apply the patch through technical support provided by Tmax Tibero.
 
โ€ป Workaround: Do not use the _INC_DSPC_CNT parameter
Caution
Warning To perform an allocator dump of the process, all threads except the control thread must be temporarily stopped. If even one thread cannot be stopped, the dump operation will fail with the TBR-12123 error.
SQL> alter system dump systemalloc;
TBR-12123: An attempt to begin sysdump has failed.

 
 

Related to