Trace Log

TRACE_LOG_LEVEL

When issues occur in Machbase server, detailed operations can be checked through log files. You can control the log level output for each module by setting TRACE_LOG_LEVEL.

  • Default: 277 (MM_1 + QP_1 + SM_1 + XM_1)
  • Range: 0 ~ 524287
  • Dynamic: Yes
  • Log File: $MACHBASE_HOME/trc/machbase.trc

Level Values

LevelValueModule
MM_11Main Module log level 1
MM_22Main Module log level 2
QP_14Query Processor log level 1
QP_28Query Processor log level 2
SM_116Storage Manager log level 1
SM_232Storage Manager log level 2
CC_164Cluster coordinator log level 1
CC_2128Cluster coordinator log level 2
XM_1256Cluster query distribution log level 1
XM_2512Cluster query distribution log level 2
LM_11024Cluster link management log level 1
LM_22048Cluster link management log level 2
RP_14096Cluster replication log level 1
RP_28192Cluster replication log level 2
MISC_165536Miscellaneous log level 1
MISC_2131072Miscellaneous log level 2
DEBUG262144Debug

Configuration

-- Check current value
select name, value from v$property where name = 'TRACE_LOG_LEVEL';

-- Combine multiple levels (add values)
alter system set TRACE_LOG_LEVEL = {level1 + level2 + ...};
Last updated on