Agent Log Description

Each Admin process maintains a log, which includes messages generated by it, and all Storage Managers (SMs) and Transaction Engines (TEs) that it manages.

The Admin log is written to $NUODB_LOGDIR/nuoadmin.log, which is /var/log/nuodb/nuoadmin.log by default on Linux. See Environment Variables for more information on log file locations.

Examples of Log Entries

DDL statements executed

ddl-audit log entries use the following format:

[ddl-audit] DDL Statement='<ddl>' User='<user>' Client Host='<ip address>

For a description of the ddl-audit logging category, see Description of Logging Categories.

An example of log lines generated by ddl-audit, after running DDL statements, is as follows:

create table a(a int);
create user bla password 'foo';
alter table a add column s string;
drop user bla;
create view va as select * from a;
$ nuocmd show log-messages --db-name test --log-options ddl-audit
2021-02-19T20:30:24.109: [TE] server1:48006 [start_id = 7] [pid = 148] [node_id = 3] MONITORED:RUNNING =>[ddl-audit] DDL Statement='create table a(a int)' User='DB' Client Host='172.18.0.2'
2021-02-19T20:30:29.918: [TE] server1:48006 [start_id = 7] [pid = 148] [node_id = 3] MONITORED:RUNNING =>[ddl-audit] DDL Statement='create user bla password ****************' User='DB' Client Host='172.18.0.2'
2021-02-19T20:30:34.313: [TE] server1:48006 [start_id = 7] [pid = 148] [node_id = 3] MONITORED:RUNNING =>[ddl-audit] DDL Statement='alter table a add column s string' User='DB' Client Host='172.18.0.2'
2021-02-19T20:30:38.073: [TE] server1:48006 [start_id = 7] [pid = 148] [node_id = 3] MONITORED:RUNNING =>[ddl-audit] DDL Statement='drop user bla' User='DB' Client Host='172.18.0.2'
2021-02-19T20:30:41.699: [TE] server1:48006 [start_id = 7] [pid = 148] [node_id = 3] MONITORED:RUNNING =>[ddl-audit] DDL Statement='create view va as select * from a' User='DB' Client Host='172.18.0.2'

DDL Statements Executed Without Locks

The following log entry is generated in nuoadmin.log if a DDL operation is executed without a lock on the table.

The following operation did not acquire a table lock and could be potentially insecure:
<DDL OPERATION>
NuoDB recommends an exclusive lock for all potentially insecure DDL operations. For more information see LOCK.