Description of Logging Categories

When you turn logging on you can specify any of the following logging categories to indicate the information you want to see in the log file. You can do this in the Automation Console and when using NuoDB Manager. For an example of doing this in the Automation Console, see About Static Logging. For a NuoDB Manager example, see About Dynamic Logging.

Logging Category Description
archive Storage manager messages.
atoms Low level atom processing messages.
bootstrap Messages sent during SQL bootstrap operations. This usually involves creating, updating and loading system tables.
client-msgs Messages sent to and received from SQL clients.
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.

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 histogram data used for index optimization.

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.
msgs Messages sent among NuoDB processes.
net Network information regarding messages being sent among NuoDB processes.
opt-index-selection SQL index selection 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.
registry Information messages about databases, schemas and sequences. This information might be helpful to NuoDB technical support.
scheduler Not currently used.
security Messages regarding the SQL user's access to database objects.
services Messages related to problems with a client connection to a broker.
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-statements Messages related to SQL result sets and statement execution statistics.
stats Messages about histogram buckets used for index selection.
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 compatiblity only. Use tx instead.
tx Messages about transaction processing.
validate Messages about database object validation.