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
| Level | Value | Module |
|---|---|---|
| MM_1 | 1 | Main Module log level 1 |
| MM_2 | 2 | Main Module log level 2 |
| QP_1 | 4 | Query Processor log level 1 |
| QP_2 | 8 | Query Processor log level 2 |
| SM_1 | 16 | Storage Manager log level 1 |
| SM_2 | 32 | Storage Manager log level 2 |
| CC_1 | 64 | Cluster coordinator log level 1 |
| CC_2 | 128 | Cluster coordinator log level 2 |
| XM_1 | 256 | Cluster query distribution log level 1 |
| XM_2 | 512 | Cluster query distribution log level 2 |
| LM_1 | 1024 | Cluster link management log level 1 |
| LM_2 | 2048 | Cluster link management log level 2 |
| RP_1 | 4096 | Cluster replication log level 1 |
| RP_2 | 8192 | Cluster replication log level 2 |
| MISC_1 | 65536 | Miscellaneous log level 1 |
| MISC_2 | 131072 | Miscellaneous log level 2 |
| DEBUG | 262144 | Debug |
Configuration
-- Check current value
select name, value from v$property where name = 'TRACE_LOG_LEVEL';
-- To combine multiple levels, add their values and set the sum
-- Example: MM_1 + MM_2 + QP_1 + SM_1 + XM_1 = 1 + 2 + 4 + 16 + 256 = 279
alter system set TRACE_LOG_LEVEL = 279;Last updated on