System Logs for MariaDB Enterprise ColumnStore

Overview

MariaDB Enterprise ColumnStore writes to several different system log files that contain messages for different log levels.

Reference material is available for MariaDB Enterprise ColumnStore.

MariaDB Enterprise ColumnStore is included with MariaDB Enterprise Server.

Purpose

The system logs are intended for:

  • Monitoring the system status

  • Diagnosing problems with queries

  • Diagnosing communication problems between nodes

Format

The system logs use the following log format:

timestamp hostname process name[pid] time | session id | txn id | thread id | logging level subsystem_id message

The fields in each log message are:

Field

Description

timestamp

The timestamp for the log message in the format Month dd HH:MM:SS

hostname

The hostname of the node that logged the message

process name[pid]

The name of the ColumnStore process (such as PrimProc) followed by the process ID in square brackets

time

Execution time for this step in seconds

session id

The session ID that shows in the process list

transaction id

The transaction ID

thread id

The thread ID

logging level

The log level for the log message

subsystem id

The subsystem ID for the log message

message

The log message.

Log Levels

The system logs use the following log levels in the logging level field:

Log Level ID

Log Level Name

C

Critical

D

Debug

E

Error

I

Info

W

Warning

Subsystem IDs

The system logs use the following subsystem IDs in the subsystem id field:

Subsystem ID

Subsystem Name

1

ddljoblist

2

ddlpackage

3

dmlpackage

4

execplan

5

joblist

6

resultset

7

mcsadmin

8

oamcpp

9

ServerMonitor

10

traphandler

11

alarmmanager

12

configcpp

13

loggingcpp

14

messageqcpp

15

DDLProc

16

ExeMgr

17

ProcessManager

18

ProcessMonitor

19

writeengine

20

DMLProc

21

dmlpackageproc

22

threadpool

23

ddlpackageproc

24

dbcon

25

DiskManager

26

RouteMsg

27

SQLBuffMgr

28

PrimProc

29

controllernode

30

workernode

31

messagequeue

32

writeengineserver

33

writeenginesplit

34

cpimport.bin

35

IDBFile

Location

MariaDB Enterprise ColumnStore writes its system logs to the /var/log/mariadb/columnstore/ directory.

The system logs are divided into 5 different log files:

  • crit.log

  • debug.log

  • err.log

  • info.log

  • warning.log

Configuration

MariaDB Enterprise ColumnStore uses rsyslog to configure its system logs.

By default, the rsyslog configuration is at /etc/rsyslog.d/49-columnstore.conf.