Description of Logging Categories

When configuring logging, any combination of the following logging categories can be specified to indicate the type of messages that should appear in nuoadmin.log. These can be specified using the verbose database option, though it is not recommended configure static logging with any categories that emit a large volume of messages.

Logging can be streamed dynamically using the NuoDB Command subcommand nuocmd show log-messages. As with verbose database option, any combination of the following categories can be specified with the --log-options argument, e.g. --log-options msgs,client-msgs,checkpoint. See About Dynamic Logging for an example.

Logging Category Description

advanced-tx

Distributed transaction processing. Mostly for internal use and advanced network diagnostics.

archive

Storage manager messages.

atoms

Low level atom processing messages. Atoms are the internal object structure representing all data and metadata in a NuoDB database. Atoms are self-coordinating objects that represent specific types of information (such as data, indexes, or schemas). Atoms are stored in memory on both Transaction Engines (TEs) and Storage Managers (SMs) and are serialized over the network and stored to disk by SMs.

atom-gc

Messages about garbage collection of deleted table, schema, index, or sequence atoms.

bootstrap

Messages sent during SQL bootstrap operations. This usually involves creating, updating and loading system tables.

checkpoint

Journal logging related to checkpoint counter operations.

client-msgs

Messages sent to and received from SQL clients.

ddl-audit

Generates a log entry for each DDL statement executed. For an example of the log entries generated by ddl-audit, see Examples of Log Entries.

dump

Atom information messages.

failure

Failure detection messages from Transaction Engines and Storage Managers. This information is available only when the --ping-timeout database option is not set to 0. A setting of 0 disables automatic detection of process failure.

filter

Messages that match both the logging priority level and the logging category. For example:

verbose error,warn,services,filter

This database option restricts log output to error and warning messages for the services category.

flush

This category is deprecated. It was for internal use.

gc

Garbage collection messages.

histograms

Messages related to SQL histograms data used for index optimization.

hotcopy

Messages related to hot copy execution. For details of one message logged, see Example of Hot Copy Log Message.

i18n

NuoDB SQL client debug messages about encoding.

index

Index atom messages. This information might be helpful to NuoDB technical support.

journal

Journal messages from Storage Managers.

login-audit

Captures successful login attempts by the user identifying the user and the time.

msgs

Messages sent among NuoDB processes.

net

Network information regarding messages being sent among NuoDB processes.

opt-index-selection

SQL index selection optimization messages.

opt-joins

SQL join optimization messages.

ping

Messages checking connectivity between NuoDB processes.

records

Messages regarding the internal records that represent data in NuoDB.

record-reuse

Messages tracking assignment and reuse of record IDs.

registry

Information messages about databases, schemas and sequences. This information might be helpful to NuoDB technical support.

scheduler

Not currently used.

security

Messages detailing security events in the system. This includes messages for all login attempts (success or failure), all DDL statements that return a SECURITY_ERROR error code and failed attempts to access objects due to insufficient privileges.

services

Messages related to problems with a client connection to a nuoadmin Admin process.

sql

Miscellaneous messages related to SQL statement and query processing.

sql-index-condition-filtering

Messages to facilitate understanding of the REJECTEDINDEXHINTS column in SYSTEM.LASTSTATEMENT (see LASTSTATEMENT System Table Description). A sample message is "Rejected index entry in index DEPENDENCIES..PRIMARY_KEY of table SYSTEM.DEPENDENCIES because column 3 (DEPENDENCYTYPE) has key 81 04 that is greater than requested key fragment 80 ".

sql-params

Messages related to parameters given in SQL parameterized statements. sql-params are shown only if sql-statement-metrics and sql-statements are also enabled.

sql-results

Messages which capture query results to facilitate debugging and diagnostics. These messages include connection and transaction IDs.

sql-statements

This category prints the SQL text.

sql-statement-explain-plans

This category prints the query execution plan that was selected for the statement being executed, complete with execution counters, where available.

sql-statement-metrics

This category prints the following information:

  • All information in the system table LASTSTATEMENT.

  • The same information as in the following columns of TRACETABLE found in Using the SQL Trace Facility , that is COMPILETIME, RUNTIME, NROWS, TIMESTAMP and NUMPARAM,USER, SCHEMA, CONNID, EXECID, TRANSID.

  • When used in combination with sql-params the PARAMS metric will also be included.

sql-workload

This category prints the application workload. When used in combination with sql-params any parameters will be included in the workload.

stats

Messages regarding performance statistics.

table-events

Between transaction engines, these messages are about SQL DDL changes. This information might be helpful to NuoDB technical support.

threads

Messages about threads in Transaction Engines and Storage Managers.

transactions

This category is deprecated. It is supported for backwards compatibility only. Use tx instead.

transaction-manager

Messages about the Transaction Manager atom. Less verbose than tx.

tx

Messages about transaction processing.

validate

Messages about database object validation.

xa

Messages about XA transactions.