Product Documentation

FairCom DB V12 Updates

Previous Topic

Next Topic

Diagnostic Logging Now in Enhanced JSON Format

SQL statement logging output has been revised to a single-line JSON format and includes the timestamp, user, and IP-address of the client making the request. This new format should allow easier ingestion of these logs into external monitoring systems. The following configuration options now output in this format:

SQL_DEBUG LOG_STMT

SQL_DEBUG LOG_STMT_TIMES

SQL_DEBUG LOG_STMT_TIMES_FETCH

Example Output

{"timestamp":"Fri Aug 24 11:56:24 2020","ipaddr":"::ffff:127.0.0.1","db":"CTREESQL","user":"admin","thread":23,"operation":"OPEN","exectime":7,"tmptime":2,"statement":"select * from syscolumns order by width "}

The SQL_DEBUG LOG_STMT_TIMES format has been changed as follows:

  1. It no longer logs statement times of the PREPARE operation.
  2. The time precision is now in milliseconds.

In the case of a parameterized string, SQL_DEBUG LOG_STMT_TIMES does not log the parameter value anymore.

TOCIndex