crash-2021-12-03-09-18-51.45125.log

18 views
Skip to first unread message

Ronald Tempelman

unread,
Dec 3, 2021, 3:23:40 AM12/3/21
to ln...@googlegroups.com
2021-12-03T09:18:29.097 E t0 lnav_config.cc:133 syscall failed `mkdir(full_path.c_str(), 0755)' -- File exists
2021-12-03T09:18:29.097 E t0 lnav_config.cc:133 syscall failed `mkdir(full_path.c_str(), 0755)' -- File exists
2021-12-03T09:18:29.097 E t0 lnav_config.cc:133 syscall failed `mkdir(full_path.c_str(), 0755)' -- File exists
2021-12-03T09:18:29.097 E t0 lnav_config.cc:133 syscall failed `mkdir(full_path.c_str(), 0755)' -- File exists
2021-12-03T09:18:29.097 E t0 lnav_config.cc:133 syscall failed `mkdir(full_path.c_str(), 0755)' -- File exists
2021-12-03T09:18:29.097 E t0 lnav_config.cc:133 syscall failed `mkdir(full_path.c_str(), 0755)' -- File exists
2021-12-03T09:18:29.097 E t0 lnav_config.cc:133 syscall failed `mkdir(full_path.c_str(), 0755)' -- File exists
2021-12-03T09:18:29.097 E t0 lnav_config.cc:133 syscall failed `mkdir(full_path.c_str(), 0755)' -- File exists
2021-12-03T09:18:29.097 E t0 lnav_config.cc:133 syscall failed `mkdir(full_path.c_str(), 0755)' -- File exists
2021-12-03T09:18:29.097 E t0 lnav_config.cc:133 syscall failed `mkdir(full_path.c_str(), 0755)' -- File exists
2021-12-03T09:18:29.097 I t0 lnav.cc:2233 lnav started
2021-12-03T09:18:29.116 D t0 log_format_loader.cc:935 Loading default formats
2021-12-03T09:18:29.116 D t0 log_format_loader.cc:86 Loading format -- access_log
2021-12-03T09:18:29.116 D t0 log_format_loader.cc:86 Loading format -- alb_log
2021-12-03T09:18:29.116 D t0 log_format_loader.cc:86 Loading format -- autodeploy_log
2021-12-03T09:18:29.116 D t0 log_format_loader.cc:86 Loading format -- block_log
2021-12-03T09:18:29.116 D t0 log_format_loader.cc:86 Loading format -- candlepin_log
2021-12-03T09:18:29.117 D t0 log_format_loader.cc:86 Loading format -- choose_repo_log
2021-12-03T09:18:29.117 D t0 log_format_loader.cc:86 Loading format -- cups_log
2021-12-03T09:18:29.117 D t0 log_format_loader.cc:86 Loading format -- dpkg_log
2021-12-03T09:18:29.117 D t0 log_format_loader.cc:86 Loading format -- elb_log
2021-12-03T09:18:29.117 D t0 log_format_loader.cc:86 Loading format -- engine_log
2021-12-03T09:18:29.117 D t0 log_format_loader.cc:86 Loading format -- error_log
2021-12-03T09:18:29.117 D t0 log_format_loader.cc:86 Loading format -- fsck_hfs_log
2021-12-03T09:18:29.117 D t0 log_format_loader.cc:86 Loading format -- glog_log
2021-12-03T09:18:29.117 D t0 log_format_loader.cc:86 Loading format -- haproxy_log
2021-12-03T09:18:29.118 D t0 log_format_loader.cc:86 Loading format -- java_log
2021-12-03T09:18:29.118 D t0 log_format_loader.cc:86 Loading format -- journald_json_log
2021-12-03T09:18:29.118 D t0 log_format_loader.cc:86 Loading format -- katello_log
2021-12-03T09:18:29.118 D t0 log_format_loader.cc:86 Loading format -- openam_log
2021-12-03T09:18:29.118 D t0 log_format_loader.cc:86 Loading format -- openamdb_log
2021-12-03T09:18:29.118 D t0 log_format_loader.cc:86 Loading format -- openstack_log
2021-12-03T09:18:29.118 D t0 log_format_loader.cc:86 Loading format -- page_log
2021-12-03T09:18:29.119 D t0 log_format_loader.cc:86 Loading format -- papertrail_log
2021-12-03T09:18:29.119 D t0 log_format_loader.cc:86 Loading format -- snaplogic_log
2021-12-03T09:18:29.119 D t0 log_format_loader.cc:86 Loading format -- sssd_log
2021-12-03T09:18:29.119 D t0 log_format_loader.cc:86 Loading format -- strace_log
2021-12-03T09:18:29.119 D t0 log_format_loader.cc:86 Loading format -- sudo_log
2021-12-03T09:18:29.119 D t0 log_format_loader.cc:86 Loading format -- syslog_log
2021-12-03T09:18:29.119 D t0 log_format_loader.cc:86 Loading format -- s3_log
2021-12-03T09:18:29.120 D t0 log_format_loader.cc:86 Loading format -- tcf_log
2021-12-03T09:18:29.120 D t0 log_format_loader.cc:86 Loading format -- tcsh_history
2021-12-03T09:18:29.120 D t0 log_format_loader.cc:86 Loading format -- uwsgi_log
2021-12-03T09:18:29.120 D t0 log_format_loader.cc:86 Loading format -- vdsm_log
2021-12-03T09:18:29.120 D t0 log_format_loader.cc:86 Loading format -- vmk_log
2021-12-03T09:18:29.120 D t0 log_format_loader.cc:86 Loading format -- vmw_log
2021-12-03T09:18:29.121 D t0 log_format_loader.cc:86 Loading format -- xmlrpc_log
2021-12-03T09:18:29.121 I t0 log_format_loader.cc:897 loading formats from path: /etc/lnav/formats/*/*.json
2021-12-03T09:18:29.121 I t0 log_format_loader.cc:897 loading formats from path: /usr/etc/lnav/formats/*/*.json
2021-12-03T09:18:29.121 I t0 log_format_loader.cc:897 loading formats from path: /root/.lnav/formats/*/*.json
2021-12-03T09:18:29.122 W t0 log_format.cc:1645 alb_log/regex/std:body field 'body' not found in pattern
2021-12-03T09:18:29.122 W t0 log_format.cc:1634 block_log/regex/sq-brackets:level field 'level' not found in pattern
2021-12-03T09:18:29.122 W t0 log_format.cc:1634 block_log/regex/std:level field 'level' not found in pattern
2021-12-03T09:18:29.122 W t0 log_format.cc:1634 candlepin_log/regex/other:level field 'level' not found in pattern
2021-12-03T09:18:29.122 W t0 log_format.cc:1634 candlepin_log/regex/reqorg:level field 'level' not found in pattern
2021-12-03T09:18:29.123 W t0 log_format_loader.cc:983 Format collision, format 'cups_log' matches sample from 'error_log'
2021-12-03T09:18:29.123 W t0 log_format.cc:1634 dpkg_log/regex/std:level field 'level' not found in pattern
2021-12-03T09:18:29.124 W t0 log_format_loader.cc:983 Format collision, format 'error_log' matches sample from 'cups_log'
2021-12-03T09:18:29.124 W t0 log_format.cc:1634 fsck_hfs_log/regex/std:level field 'level' not found in pattern
2021-12-03T09:18:29.124 W t0 log_format.cc:1634 haproxy_log/regex/event_started:level field 'level' not found in pattern
2021-12-03T09:18:29.124 W t0 log_format.cc:1645 haproxy_log/regex/event_started:body field 'body' not found in pattern
2021-12-03T09:18:29.124 W t0 log_format.cc:1634 haproxy_log/regex/event_stopped:level field 'level' not found in pattern
2021-12-03T09:18:29.124 W t0 log_format.cc:1645 haproxy_log/regex/event_stopped:body field 'body' not found in pattern
2021-12-03T09:18:29.124 W t0 log_format.cc:1634 haproxy_log/regex/event_stopping:level field 'level' not found in pattern
2021-12-03T09:18:29.124 W t0 log_format.cc:1645 haproxy_log/regex/event_stopping:body field 'body' not found in pattern
2021-12-03T09:18:29.125 W t0 log_format.cc:1634 haproxy_log/regex/http:level field 'level' not found in pattern
2021-12-03T09:18:29.125 W t0 log_format.cc:1645 haproxy_log/regex/http:body field 'body' not found in pattern
2021-12-03T09:18:29.125 W t0 log_format.cc:1634 haproxy_log/regex/ssl:level field 'level' not found in pattern
2021-12-03T09:18:29.125 W t0 log_format.cc:1645 haproxy_log/regex/ssl:body field 'body' not found in pattern
2021-12-03T09:18:29.125 W t0 log_format.cc:1634 haproxy_log/regex/tcp:level field 'level' not found in pattern
2021-12-03T09:18:29.125 W t0 log_format.cc:1645 haproxy_log/regex/tcp:body field 'body' not found in pattern
2021-12-03T09:18:29.126 W t0 log_format.cc:1645 katello_log/regex/log:body field 'body' not found in pattern
2021-12-03T09:18:29.127 W t0 log_format.cc:1634 openamdb_log/regex/std:level field 'level' not found in pattern
2021-12-03T09:18:29.127 W t0 log_format_loader.cc:983 Format collision, format 'openstack_log' matches sample from 's3_log'
2021-12-03T09:18:29.127 W t0 log_format.cc:1634 page_log/regex/1.7:level field 'level' not found in pattern
2021-12-03T09:18:29.127 W t0 log_format.cc:1634 page_log/regex/pre-1.7:level field 'level' not found in pattern
2021-12-03T09:18:29.128 W t0 log_format.cc:1645 s3_log/regex/std:body field 'body' not found in pattern
2021-12-03T09:18:29.128 W t0 log_format.cc:1645 s3_log/regex/std-v2:body field 'body' not found in pattern
2021-12-03T09:18:29.128 W t0 log_format.cc:1634 sssd_log/regex/core:level field 'level' not found in pattern
2021-12-03T09:18:29.128 W t0 log_format.cc:1634 sssd_log/regex/module:level field 'level' not found in pattern
2021-12-03T09:18:29.129 W t0 log_format.cc:1645 sudo_log/regex/std:body field 'body' not found in pattern
2021-12-03T09:18:29.129 W t0 log_format_loader.cc:983 Format collision, format 'syslog_log' matches sample from 'haproxy_log'
2021-12-03T09:18:29.129 W t0 log_format_loader.cc:983 Format collision, format 'syslog_log' matches sample from 'vmk_log'
2021-12-03T09:18:29.129 W t0 log_format_loader.cc:983 Format collision, format 'syslog_log' matches sample from 'vmw_log'
2021-12-03T09:18:29.129 W t0 log_format.cc:1634 tcf_log/regex/std:level field 'level' not found in pattern
2021-12-03T09:18:29.129 W t0 log_format.cc:1634 tcsh_history/regex/std:level field 'level' not found in pattern
2021-12-03T09:18:29.130 W t0 log_format.cc:1634 vmw_log/regex/hdr-ftr:level field 'level' not found in pattern
2021-12-03T09:18:29.131 W t0 log_format.cc:1634 vmw_log/regex/section:level field 'level' not found in pattern
2021-12-03T09:18:29.131 W t0 log_format.cc:1645 vmw_log/regex/section:body field 'body' not found in pattern
2021-12-03T09:18:29.131 W t0 log_format.cc:1634 xmlrpc_log/regex/main:level field 'level' not found in pattern
2021-12-03T09:18:29.131 W t0 log_format_loader.cc:1020 Detected a cycle...
2021-12-03T09:18:29.131 W t0 log_format_loader.cc:1023   Skipping builtin format -- cups_log
2021-12-03T09:18:29.131 W t0 log_format_loader.cc:1023   Skipping builtin format -- error_log
2021-12-03T09:18:29.131 I t0 log_format_loader.cc:1045 Format order:
2021-12-03T09:18:29.131 I t0 log_format_loader.cc:1047   access_log
2021-12-03T09:18:29.131 I t0 log_format_loader.cc:1047   alb_log
2021-12-03T09:18:29.131 I t0 log_format_loader.cc:1047   autodeploy_log
2021-12-03T09:18:29.131 I t0 log_format_loader.cc:1047   block_log
2021-12-03T09:18:29.131 I t0 log_format_loader.cc:1047   candlepin_log
2021-12-03T09:18:29.131 I t0 log_format_loader.cc:1047   choose_repo_log
2021-12-03T09:18:29.131 I t0 log_format_loader.cc:1047   dpkg_log
2021-12-03T09:18:29.131 I t0 log_format_loader.cc:1047   elb_log
2021-12-03T09:18:29.131 I t0 log_format_loader.cc:1047   engine_log
2021-12-03T09:18:29.132 I t0 log_format_loader.cc:1047   fsck_hfs_log
2021-12-03T09:18:29.132 I t0 log_format_loader.cc:1047   glog_log
2021-12-03T09:18:29.132 I t0 log_format_loader.cc:1047   haproxy_log
2021-12-03T09:18:29.132 I t0 log_format_loader.cc:1047   java_log
2021-12-03T09:18:29.132 I t0 log_format_loader.cc:1047   journald_json_log
2021-12-03T09:18:29.132 I t0 log_format_loader.cc:1047   katello_log
2021-12-03T09:18:29.132 I t0 log_format_loader.cc:1047   openam_log
2021-12-03T09:18:29.132 I t0 log_format_loader.cc:1047   openamdb_log
2021-12-03T09:18:29.132 I t0 log_format_loader.cc:1047   page_log
2021-12-03T09:18:29.132 I t0 log_format_loader.cc:1047   papertrail_log
2021-12-03T09:18:29.132 I t0 log_format_loader.cc:1047   s3_log
2021-12-03T09:18:29.132 I t0 log_format_loader.cc:1047   snaplogic_log
2021-12-03T09:18:29.132 I t0 log_format_loader.cc:1047   sssd_log
2021-12-03T09:18:29.132 I t0 log_format_loader.cc:1047   strace_log
2021-12-03T09:18:29.132 I t0 log_format_loader.cc:1047   sudo_log
2021-12-03T09:18:29.132 I t0 log_format_loader.cc:1047   tcf_log
2021-12-03T09:18:29.132 I t0 log_format_loader.cc:1047   tcsh_history
2021-12-03T09:18:29.132 I t0 log_format_loader.cc:1047   uwsgi_log
2021-12-03T09:18:29.132 I t0 log_format_loader.cc:1047   vdsm_log
2021-12-03T09:18:29.132 I t0 log_format_loader.cc:1047   vmk_log
2021-12-03T09:18:29.132 I t0 log_format_loader.cc:1047   vmw_log
2021-12-03T09:18:29.132 I t0 log_format_loader.cc:1047   xmlrpc_log
2021-12-03T09:18:29.132 I t0 log_format_loader.cc:1047   openstack_log
2021-12-03T09:18:29.132 I t0 log_format_loader.cc:1047   syslog_log
2021-12-03T09:18:29.132 I t0 log_format_loader.cc:1047   cups_log
2021-12-03T09:18:29.132 I t0 log_format_loader.cc:1047   error_log
2021-12-03T09:18:29.133 D t0 log_vtab_impl.cc:130 log_vtab_impl.get_table_statement() -> CREATE TABLE all_logs  (
  log_line        INTEGER  PRIMARY KEY,            -- The line number for the log message
  log_part        TEXT     COLLATE naturalnocase,  -- The partition the message is in
  log_time        DATETIME,                        -- The adjusted timestamp for the log message
  log_actual_time DATETIME HIDDEN,                 -- The timestamp from the original log file for this message
  log_idle_msecs  INTEGER,                         -- The difference in time between this messages and the previous
  log_level       TEXT     COLLATE loglevel,       -- The log message level
  log_mark        BOOLEAN,                         -- True if the log message was marked
  log_comment     TEXT,                            -- The comment for this message
  log_tags        TEXT,                            -- A JSON list of tags for this message
  log_filters     TEXT,                            -- A JSON list of filter IDs that matched this message
  -- BEGIN Format-specific fields:
  log_format      TEXT     COLLATE 'BINARY'       , -- The name of the log file format
  log_msg_format  TEXT     COLLATE 'BINARY'       , -- The message format with variables replaced by hash marks
  log_msg_schema  TEXT    hidden COLLATE 'BINARY'       , -- The ID for the message schema

  -- END Format-specific fields
  log_time_msecs  INTEGER HIDDEN,                    -- The adjusted timestamp for the log message as the number of milliseconds from the epoch
  log_path        TEXT HIDDEN COLLATE naturalnocase, -- The path to the log file this message is from
  log_text        TEXT HIDDEN,                       -- The full text of the log message
  log_body        TEXT HIDDEN,                       -- The body of the log message
  log_raw_text    TEXT HIDDEN                        -- The raw text from the log file
);

2021-12-03T09:18:29.133 D t0 log_vtab_impl.cc:212 creating log format table: all_logs = 0
2021-12-03T09:18:29.133 D t0 log_vtab_impl.cc:130 log_vtab_impl.get_table_statement() -> CREATE TABLE generic_log  (
  log_line        INTEGER  PRIMARY KEY,            -- The line number for the log message
  log_part        TEXT     COLLATE naturalnocase,  -- The partition the message is in
  log_time        DATETIME,                        -- The adjusted timestamp for the log message
  log_actual_time DATETIME HIDDEN,                 -- The timestamp from the original log file for this message
  log_idle_msecs  INTEGER,                         -- The difference in time between this messages and the previous
  log_level       TEXT     COLLATE loglevel,       -- The log message level
  log_mark        BOOLEAN,                         -- True if the log message was marked
  log_comment     TEXT,                            -- The comment for this message
  log_tags        TEXT,                            -- A JSON list of tags for this message
  log_filters     TEXT,                            -- A JSON list of filter IDs that matched this message
  -- BEGIN Format-specific fields:

  -- END Format-specific fields
  log_time_msecs  INTEGER HIDDEN,                    -- The adjusted timestamp for the log message as the number of milliseconds from the epoch
  log_path        TEXT HIDDEN COLLATE naturalnocase, -- The path to the log file this message is from
  log_text        TEXT HIDDEN,                       -- The full text of the log message
  log_body        TEXT HIDDEN,                       -- The body of the log message
  log_raw_text    TEXT HIDDEN                        -- The raw text from the log file
);

2021-12-03T09:18:29.133 D t0 log_vtab_impl.cc:212 creating log format table: generic_log = 0
2021-12-03T09:18:29.134 D t0 log_vtab_impl.cc:130 log_vtab_impl.get_table_statement() -> CREATE TABLE logfmt_log  (
  log_line        INTEGER  PRIMARY KEY,            -- The line number for the log message
  log_part        TEXT     COLLATE naturalnocase,  -- The partition the message is in
  log_time        DATETIME,                        -- The adjusted timestamp for the log message
  log_actual_time DATETIME HIDDEN,                 -- The timestamp from the original log file for this message
  log_idle_msecs  INTEGER,                         -- The difference in time between this messages and the previous
  log_level       TEXT     COLLATE loglevel,       -- The log message level
  log_mark        BOOLEAN,                         -- True if the log message was marked
  log_comment     TEXT,                            -- The comment for this message
  log_tags        TEXT,                            -- A JSON list of tags for this message
  log_filters     TEXT,                            -- A JSON list of filter IDs that matched this message
  -- BEGIN Format-specific fields:
  fields          TEXT     COLLATE 'BINARY'       ,

  -- END Format-specific fields
  log_time_msecs  INTEGER HIDDEN,                    -- The adjusted timestamp for the log message as the number of milliseconds from the epoch
  log_path        TEXT HIDDEN COLLATE naturalnocase, -- The path to the log file this message is from
  log_text        TEXT HIDDEN,                       -- The full text of the log message
  log_body        TEXT HIDDEN,                       -- The body of the log message
  log_raw_text    TEXT HIDDEN                        -- The raw text from the log file
);

2021-12-03T09:18:29.134 D t0 log_vtab_impl.cc:212 creating log format table: logfmt_log = 0
2021-12-03T09:18:29.134 D t0 log_vtab_impl.cc:130 log_vtab_impl.get_table_statement() -> CREATE TABLE access_log  (
  log_line        INTEGER  PRIMARY KEY,            -- The line number for the log message
  log_part        TEXT     COLLATE naturalnocase,  -- The partition the message is in
  log_time        DATETIME,                        -- The adjusted timestamp for the log message
  log_actual_time DATETIME HIDDEN,                 -- The timestamp from the original log file for this message
  log_idle_msecs  INTEGER,                         -- The difference in time between this messages and the previous
  log_level       TEXT     COLLATE loglevel,       -- The log message level
  log_mark        BOOLEAN,                         -- True if the log message was marked
  log_comment     TEXT,                            -- The comment for this message
  log_tags        TEXT,                            -- A JSON list of tags for this message
  log_filters     TEXT,                            -- A JSON list of filter IDs that matched this message
  -- BEGIN Format-specific fields:
  c_ip            TEXT     COLLATE 'ipaddress'    , -- The client IP address
  cs_method       TEXT     COLLATE 'BINARY'       , -- The request method
  cs_referer      TEXT     COLLATE 'BINARY'       , -- The client's referrer
  cs_uri_query    TEXT     COLLATE 'BINARY'       , -- The query parameters in the request URI
  cs_uri_stem     TEXT     COLLATE 'BINARY'       , -- The path part of the request URI
  cs_user_agent   TEXT     COLLATE 'BINARY'       , -- The client's HTTP agent
  cs_username     TEXT     COLLATE 'BINARY'       , -- The username passed from the client to the server
  cs_version      TEXT     COLLATE 'BINARY'       , -- The client's HTTP version
  sc_bytes        INTEGER  COLLATE 'BINARY'       , -- The number of bytes returned by the server
  sc_status       INTEGER  COLLATE 'BINARY'       , -- The status code returned by the server
  cs_host         TEXT     COLLATE 'BINARY'       , -- The value of the Host heade
2021-12-03T09:18:29.134 D t0 log_vtab_impl.cc:212 creating log format table: access_log = 0
2021-12-03T09:18:29.134 D t0 log_vtab_impl.cc:130 log_vtab_impl.get_table_statement() -> CREATE TABLE alb_log  (
  log_line        INTEGER  PRIMARY KEY,            -- The line number for the log message
  log_part        TEXT     COLLATE naturalnocase,  -- The partition the message is in
  log_time        DATETIME,                        -- The adjusted timestamp for the log message
  log_actual_time DATETIME HIDDEN,                 -- The timestamp from the original log file for this message
  log_idle_msecs  INTEGER,                         -- The difference in time between this messages and the previous
  log_level       TEXT     COLLATE loglevel,       -- The log message level
  log_mark        BOOLEAN,                         -- True if the log message was marked
  log_comment     TEXT,                            -- The comment for this message
  log_tags        TEXT,                            -- A JSON list of tags for this message
  log_filters     TEXT,                            -- A JSON list of filter IDs that matched this message
  -- BEGIN Format-specific fields:
  chosen_cert_arn          TEXT     COLLATE 'BINARY'       ,
  client_ip                TEXT     COLLATE 'ipaddress'    ,
  client_port              INTEGER  COLLATE 'BINARY'       ,
  cs_method                TEXT     COLLATE 'BINARY'       ,
  cs_uri_query             TEXT     COLLATE 'BINARY'       ,
  cs_uri_stem              TEXT     COLLATE 'BINARY'       ,
  cs_version               TEXT     COLLATE 'BINARY'       ,
  domain_name              TEXT     COLLATE 'BINARY'       ,
  elb_status_code          INTEGER  COLLATE 'BINARY'       ,
  matched_rule_priority    INTEGER  COLLATE 'BINARY'       ,
  received_bytes           INTEGER  COLLATE 'BINARY'       ,
  request_processing_time  FLOAT    COLLATE 'BINARY'       ,
  response_processing_time FLOAT    COLLATE 'BINARY'       ,
  sent_bytes               INTEGER  COLLATE 'BINARY'       ,
  ssl_cipher               TEXT     COLLATE 'BINARY'       ,
  ssl_protocol             TEXT     CO
2021-12-03T09:18:29.134 D t0 log_vtab_impl.cc:212 creating log format table: alb_log = 0
2021-12-03T09:18:29.134 D t0 log_vtab_impl.cc:130 log_vtab_impl.get_table_statement() -> CREATE TABLE autodeploy_log  (
  log_line        INTEGER  PRIMARY KEY,            -- The line number for the log message
  log_part        TEXT     COLLATE naturalnocase,  -- The partition the message is in
  log_time        DATETIME,                        -- The adjusted timestamp for the log message
  log_actual_time DATETIME HIDDEN,                 -- The timestamp from the original log file for this message
  log_idle_msecs  INTEGER,                         -- The difference in time between this messages and the previous
  log_level       TEXT     COLLATE loglevel,       -- The log message level
  log_mark        BOOLEAN,                         -- True if the log message was marked
  log_comment     TEXT,                            -- The comment for this message
  log_tags        TEXT,                            -- A JSON list of tags for this message
  log_filters     TEXT,                            -- A JSON list of filter IDs that matched this message
  -- BEGIN Format-specific fields:
  module          TEXT     COLLATE 'BINARY'       , -- The name of the module that generated the message
  pid             INTEGER  COLLATE 'BINARY'       , -- The ID of the process that generated the message

  -- END Format-specific fields
  log_time_msecs  INTEGER HIDDEN,                    -- The adjusted timestamp for the log message as the number of milliseconds from the epoch
  log_path        TEXT HIDDEN COLLATE naturalnocase, -- The path to the log file this message is from
  log_text        TEXT HIDDEN,                       -- The full text of the log message
  log_body        TEXT HIDDEN,                       -- The body of the log message
  log_raw_text    TEXT HIDDEN                        -- The raw text from the log file
);

2021-12-03T09:18:29.135 D t0 log_vtab_impl.cc:212 creating log format table: autodeploy_log = 0
2021-12-03T09:18:29.135 D t0 log_vtab_impl.cc:130 log_vtab_impl.get_table_statement() -> CREATE TABLE block_log  (
  log_line        INTEGER  PRIMARY KEY,            -- The line number for the log message
  log_part        TEXT     COLLATE naturalnocase,  -- The partition the message is in
  log_time        DATETIME,                        -- The adjusted timestamp for the log message
  log_actual_time DATETIME HIDDEN,                 -- The timestamp from the original log file for this message
  log_idle_msecs  INTEGER,                         -- The difference in time between this messages and the previous
  log_level       TEXT     COLLATE loglevel,       -- The log message level
  log_mark        BOOLEAN,                         -- True if the log message was marked
  log_comment     TEXT,                            -- The comment for this message
  log_tags        TEXT,                            -- A JSON list of tags for this message
  log_filters     TEXT,                            -- A JSON list of filter IDs that matched this message
  -- BEGIN Format-specific fields:

  -- END Format-specific fields
  log_time_msecs  INTEGER HIDDEN,                    -- The adjusted timestamp for the log message as the number of milliseconds from the epoch
  log_path        TEXT HIDDEN COLLATE naturalnocase, -- The path to the log file this message is from
  log_text        TEXT HIDDEN,                       -- The full text of the log message
  log_body        TEXT HIDDEN,                       -- The body of the log message
  log_raw_text    TEXT HIDDEN                        -- The raw text from the log file
);

2021-12-03T09:18:29.135 D t0 log_vtab_impl.cc:212 creating log format table: block_log = 0
2021-12-03T09:18:29.135 D t0 log_vtab_impl.cc:130 log_vtab_impl.get_table_statement() -> CREATE TABLE candlepin_log  (
  log_line        INTEGER  PRIMARY KEY,            -- The line number for the log message
  log_part        TEXT     COLLATE naturalnocase,  -- The partition the message is in
  log_time        DATETIME,                        -- The adjusted timestamp for the log message
  log_actual_time DATETIME HIDDEN,                 -- The timestamp from the original log file for this message
  log_idle_msecs  INTEGER,                         -- The difference in time between this messages and the previous
  log_level       TEXT     COLLATE loglevel,       -- The log message level
  log_mark        BOOLEAN,                         -- True if the log message was marked
  log_comment     TEXT,                            -- The comment for this message
  log_tags        TEXT,                            -- A JSON list of tags for this message
  log_filters     TEXT,                            -- A JSON list of filter IDs that matched this message
  -- BEGIN Format-specific fields:
  alert_level     TEXT     COLLATE 'BINARY'       ,
  module          TEXT     COLLATE 'BINARY'       ,
  org             TEXT     COLLATE 'BINARY'       ,
  req             TEXT     COLLATE 'BINARY'       ,

  -- END Format-specific fields
  log_time_msecs  INTEGER HIDDEN,                    -- The adjusted timestamp for the log message as the number of milliseconds from the epoch
  log_path        TEXT HIDDEN COLLATE naturalnocase, -- The path to the log file this message is from
  log_text        TEXT HIDDEN,                       -- The full text of the log message
  log_body        TEXT HIDDEN,                       -- The body of the log message
  log_raw_text    TEXT HIDDEN                        -- The raw text from the log file
);

2021-12-03T09:18:29.135 D t0 log_vtab_impl.cc:212 creating log format table: candlepin_log = 0
2021-12-03T09:18:29.135 D t0 log_vtab_impl.cc:130 log_vtab_impl.get_table_statement() -> CREATE TABLE choose_repo_log  (
  log_line        INTEGER  PRIMARY KEY,            -- The line number for the log message
  log_part        TEXT     COLLATE naturalnocase,  -- The partition the message is in
  log_time        DATETIME,                        -- The adjusted timestamp for the log message
  log_actual_time DATETIME HIDDEN,                 -- The timestamp from the original log file for this message
  log_idle_msecs  INTEGER,                         -- The difference in time between this messages and the previous
  log_level       TEXT     COLLATE loglevel,       -- The log message level
  log_mark        BOOLEAN,                         -- True if the log message was marked
  log_comment     TEXT,                            -- The comment for this message
  log_tags        TEXT,                            -- A JSON list of tags for this message
  log_filters     TEXT,                            -- A JSON list of filter IDs that matched this message
  -- BEGIN Format-specific fields:

  -- END Format-specific fields
  log_time_msecs  INTEGER HIDDEN,                    -- The adjusted timestamp for the log message as the number of milliseconds from the epoch
  log_path        TEXT HIDDEN COLLATE naturalnocase, -- The path to the log file this message is from
  log_text        TEXT HIDDEN,                       -- The full text of the log message
  log_body        TEXT HIDDEN,                       -- The body of the log message
  log_raw_text    TEXT HIDDEN                        -- The raw text from the log file
);

2021-12-03T09:18:29.135 D t0 log_vtab_impl.cc:212 creating log format table: choose_repo_log = 0
2021-12-03T09:18:29.135 D t0 log_vtab_impl.cc:130 log_vtab_impl.get_table_statement() -> CREATE TABLE dpkg_log  (
  log_line        INTEGER  PRIMARY KEY,            -- The line number for the log message
  log_part        TEXT     COLLATE naturalnocase,  -- The partition the message is in
  log_time        DATETIME,                        -- The adjusted timestamp for the log message
  log_actual_time DATETIME HIDDEN,                 -- The timestamp from the original log file for this message
  log_idle_msecs  INTEGER,                         -- The difference in time between this messages and the previous
  log_level       TEXT     COLLATE loglevel,       -- The log message level
  log_mark        BOOLEAN,                         -- True if the log message was marked
  log_comment     TEXT,                            -- The comment for this message
  log_tags        TEXT,                            -- A JSON list of tags for this message
  log_filters     TEXT,                            -- A JSON list of filter IDs that matched this message
  -- BEGIN Format-specific fields:
  action            TEXT     COLLATE 'BINARY'       ,
  available_version TEXT     COLLATE 'BINARY'       ,
  installed_version TEXT     COLLATE 'BINARY'       ,
  package           TEXT     COLLATE 'BINARY'       ,
  status            TEXT     COLLATE 'BINARY'       ,

  -- END Format-specific fields
  log_time_msecs  INTEGER HIDDEN,                    -- The adjusted timestamp for the log message as the number of milliseconds from the epoch
  log_path        TEXT HIDDEN COLLATE naturalnocase, -- The path to the log file this message is from
  log_text        TEXT HIDDEN,                       -- The full text of the log message
  log_body        TEXT HIDDEN,                       -- The body of the log message
  log_raw_text    TEXT HIDDEN                        -- The raw text from the log file
);

2021-12-03T09:18:29.135 D t0 log_vtab_impl.cc:212 creating log format table: dpkg_log = 0
2021-12-03T09:18:29.136 D t0 log_vtab_impl.cc:130 log_vtab_impl.get_table_statement() -> CREATE TABLE elb_log  (
  log_line        INTEGER  PRIMARY KEY,            -- The line number for the log message
  log_part        TEXT     COLLATE naturalnocase,  -- The partition the message is in
  log_time        DATETIME,                        -- The adjusted timestamp for the log message
  log_actual_time DATETIME HIDDEN,                 -- The timestamp from the original log file for this message
  log_idle_msecs  INTEGER,                         -- The difference in time between this messages and the previous
  log_level       TEXT     COLLATE loglevel,       -- The log message level
  log_mark        BOOLEAN,                         -- True if the log message was marked
  log_comment     TEXT,                            -- The comment for this message
  log_tags        TEXT,                            -- A JSON list of tags for this message
  log_filters     TEXT,                            -- A JSON list of filter IDs that matched this message
  -- BEGIN Format-specific fields:
  backend_ip               TEXT     COLLATE 'ipaddress'    ,
  backend_port             INTEGER  COLLATE 'BINARY'       ,
  backend_processing_time  FLOAT    COLLATE 'BINARY'       ,
  backend_status_code      INTEGER  COLLATE 'BINARY'       ,
  client_ip                TEXT     COLLATE 'ipaddress'    ,
  client_port              INTEGER  COLLATE 'BINARY'       ,
  cs_method                TEXT     COLLATE 'BINARY'       ,
  cs_uri_query             TEXT     COLLATE 'BINARY'       ,
  cs_uri_stem              TEXT     COLLATE 'BINARY'       ,
  cs_version               TEXT     COLLATE 'BINARY'       ,
  elb                      TEXT     COLLATE 'BINARY'       ,
  elb_status_code          INTEGER  COLLATE 'BINARY'       ,
  received_bytes           INTEGER  COLLATE 'BINARY'       ,
  request_processing_time  FLOAT    COLLATE 'BINARY'       ,
  response_processing_time FLOAT    COLLATE 'BINARY'       ,
  sent_bytes               INTEGER  CO
2021-12-03T09:18:29.136 D t0 log_vtab_impl.cc:212 creating log format table: elb_log = 0
2021-12-03T09:18:29.136 D t0 log_vtab_impl.cc:130 log_vtab_impl.get_table_statement() -> CREATE TABLE engine_log  (
  log_line        INTEGER  PRIMARY KEY,            -- The line number for the log message
  log_part        TEXT     COLLATE naturalnocase,  -- The partition the message is in
  log_time        DATETIME,                        -- The adjusted timestamp for the log message
  log_actual_time DATETIME HIDDEN,                 -- The timestamp from the original log file for this message
  log_idle_msecs  INTEGER,                         -- The difference in time between this messages and the previous
  log_level       TEXT     COLLATE loglevel,       -- The log message level
  log_mark        BOOLEAN,                         -- True if the log message was marked
  log_comment     TEXT,                            -- The comment for this message
  log_tags        TEXT,                            -- A JSON list of tags for this message
  log_filters     TEXT,                            -- A JSON list of filter IDs that matched this message
  -- BEGIN Format-specific fields:
  logger          TEXT     COLLATE 'BINARY'       ,
  tid             TEXT     COLLATE 'BINARY'       ,
  thread          TEXT     COLLATE 'BINARY'       ,

  -- END Format-specific fields
  log_time_msecs  INTEGER HIDDEN,                    -- The adjusted timestamp for the log message as the number of milliseconds from the epoch
  log_path        TEXT HIDDEN COLLATE naturalnocase, -- The path to the log file this message is from
  log_text        TEXT HIDDEN,                       -- The full text of the log message
  log_body        TEXT HIDDEN,                       -- The body of the log message
  log_raw_text    TEXT HIDDEN                        -- The raw text from the log file
);

2021-12-03T09:18:29.136 D t0 log_vtab_impl.cc:212 creating log format table: engine_log = 0
2021-12-03T09:18:29.136 D t0 log_vtab_impl.cc:130 log_vtab_impl.get_table_statement() -> CREATE TABLE fsck_hfs_log  (
  log_line        INTEGER  PRIMARY KEY,            -- The line number for the log message
  log_part        TEXT     COLLATE naturalnocase,  -- The partition the message is in
  log_time        DATETIME,                        -- The adjusted timestamp for the log message
  log_actual_time DATETIME HIDDEN,                 -- The timestamp from the original log file for this message
  log_idle_msecs  INTEGER,                         -- The difference in time between this messages and the previous
  log_level       TEXT     COLLATE loglevel,       -- The log message level
  log_mark        BOOLEAN,                         -- True if the log message was marked
  log_comment     TEXT,                            -- The comment for this message
  log_tags        TEXT,                            -- A JSON list of tags for this message
  log_filters     TEXT,                            -- A JSON list of filter IDs that matched this message
  -- BEGIN Format-specific fields:
  device          TEXT     COLLATE 'BINARY'       ,

  -- END Format-specific fields
  log_time_msecs  INTEGER HIDDEN,                    -- The adjusted timestamp for the log message as the number of milliseconds from the epoch
  log_path        TEXT HIDDEN COLLATE naturalnocase, -- The path to the log file this message is from
  log_text        TEXT HIDDEN,                       -- The full text of the log message
  log_body        TEXT HIDDEN,                       -- The body of the log message
  log_raw_text    TEXT HIDDEN                        -- The raw text from the log file
);

2021-12-03T09:18:29.136 D t0 log_vtab_impl.cc:212 creating log format table: fsck_hfs_log = 0
2021-12-03T09:18:29.136 D t0 log_vtab_impl.cc:130 log_vtab_impl.get_table_statement() -> CREATE TABLE glog_log  (
  log_line        INTEGER  PRIMARY KEY,            -- The line number for the log message
  log_part        TEXT     COLLATE naturalnocase,  -- The partition the message is in
  log_time        DATETIME,                        -- The adjusted timestamp for the log message
  log_actual_time DATETIME HIDDEN,                 -- The timestamp from the original log file for this message
  log_idle_msecs  INTEGER,                         -- The difference in time between this messages and the previous
  log_level       TEXT     COLLATE loglevel,       -- The log message level
  log_mark        BOOLEAN,                         -- True if the log message was marked
  log_comment     TEXT,                            -- The comment for this message
  log_tags        TEXT,                            -- A JSON list of tags for this message
  log_filters     TEXT,                            -- A JSON list of filter IDs that matched this message
  -- BEGIN Format-specific fields:
  src_file        TEXT     COLLATE 'BINARY'       ,
  src_line        INTEGER  COLLATE 'BINARY'       ,
  thread          INTEGER  COLLATE 'BINARY'       ,

  -- END Format-specific fields
  log_time_msecs  INTEGER HIDDEN,                    -- The adjusted timestamp for the log message as the number of milliseconds from the epoch
  log_path        TEXT HIDDEN COLLATE naturalnocase, -- The path to the log file this message is from
  log_text        TEXT HIDDEN,                       -- The full text of the log message
  log_body        TEXT HIDDEN,                       -- The body of the log message
  log_raw_text    TEXT HIDDEN                        -- The raw text from the log file
);

2021-12-03T09:18:29.136 D t0 log_vtab_impl.cc:212 creating log format table: glog_log = 0
2021-12-03T09:18:29.137 D t0 log_vtab_impl.cc:130 log_vtab_impl.get_table_statement() -> CREATE TABLE haproxy_log  (
  log_line        INTEGER  PRIMARY KEY,            -- The line number for the log message
  log_part        TEXT     COLLATE naturalnocase,  -- The partition the message is in
  log_time        DATETIME,                        -- The adjusted timestamp for the log message
  log_actual_time DATETIME HIDDEN,                 -- The timestamp from the original log file for this message
  log_idle_msecs  INTEGER,                         -- The difference in time between this messages and the previous
  log_level       TEXT     COLLATE loglevel,       -- The log message level
  log_mark        BOOLEAN,                         -- True if the log message was marked
  log_comment     TEXT,                            -- The comment for this message
  log_tags        TEXT,                            -- A JSON list of tags for this message
  log_filters     TEXT,                            -- A JSON list of filter IDs that matched this message
  -- BEGIN Format-specific fields:
  frontend_name             TEXT     COLLATE 'BINARY'       ,
  logging_host              TEXT     COLLATE 'BINARY'       ,
  pid                       INTEGER  COLLATE 'BINARY'       ,
  process_name              TEXT     COLLATE 'BINARY'       ,
  backend_connections       INTEGER  COLLATE 'BINARY'       ,
  frontend_connections      INTEGER  COLLATE 'BINARY'       ,
  stopping_timeout          INTEGER  COLLATE 'BINARY'       ,
  accept_date               TEXT     COLLATE 'BINARY'       ,
  actconn                   INTEGER  COLLATE 'BINARY'       ,
  backend_name              TEXT     COLLATE 'BINARY'       ,
  backend_queue             INTEGER  COLLATE 'BINARY'       ,
  beconn                    INTEGER  COLLATE 'BINARY'       ,
  bytes_read                INTEGER  COLLATE 'BINARY'       ,
  captured_request_cookie   TEXT     COLLATE 'BINARY'       ,
  captured_request_headers  TEXT     COLLATE 'BINARY'       ,
  captured_response
2021-12-03T09:18:29.137 D t0 log_vtab_impl.cc:212 creating log format table: haproxy_log = 0
2021-12-03T09:18:29.137 D t0 log_vtab_impl.cc:130 log_vtab_impl.get_table_statement() -> CREATE TABLE java_log  (
  log_line        INTEGER  PRIMARY KEY,            -- The line number for the log message
  log_part        TEXT     COLLATE naturalnocase,  -- The partition the message is in
  log_time        DATETIME,                        -- The adjusted timestamp for the log message
  log_actual_time DATETIME HIDDEN,                 -- The timestamp from the original log file for this message
  log_idle_msecs  INTEGER,                         -- The difference in time between this messages and the previous
  log_level       TEXT     COLLATE loglevel,       -- The log message level
  log_mark        BOOLEAN,                         -- True if the log message was marked
  log_comment     TEXT,                            -- The comment for this message
  log_tags        TEXT,                            -- A JSON list of tags for this message
  log_filters     TEXT,                            -- A JSON list of filter IDs that matched this message
  -- BEGIN Format-specific fields:
  alert_level     TEXT     COLLATE 'BINARY'       ,
  jvm_no          INTEGER  COLLATE 'BINARY'       ,
  class           TEXT     COLLATE 'BINARY'       ,
  debug_level     TEXT     COLLATE 'BINARY'       ,
  function        TEXT     COLLATE 'BINARY'       ,

  -- END Format-specific fields
  log_time_msecs  INTEGER HIDDEN,                    -- The adjusted timestamp for the log message as the number of milliseconds from the epoch
  log_path        TEXT HIDDEN COLLATE naturalnocase, -- The path to the log file this message is from
  log_text        TEXT HIDDEN,                       -- The full text of the log message
  log_body        TEXT HIDDEN,                       -- The body of the log message
  log_raw_text    TEXT HIDDEN                        -- The raw text from the log file
);

2021-12-03T09:18:29.137 D t0 log_vtab_impl.cc:212 creating log format table: java_log = 0
2021-12-03T09:18:29.137 D t0 log_vtab_impl.cc:130 log_vtab_impl.get_table_statement() -> CREATE TABLE journald_json_log  (
  log_line        INTEGER  PRIMARY KEY,            -- The line number for the log message
  log_part        TEXT     COLLATE naturalnocase,  -- The partition the message is in
  log_time        DATETIME,                        -- The adjusted timestamp for the log message
  log_actual_time DATETIME HIDDEN,                 -- The timestamp from the original log file for this message
  log_idle_msecs  INTEGER,                         -- The difference in time between this messages and the previous
  log_level       TEXT     COLLATE loglevel,       -- The log message level
  log_mark        BOOLEAN,                         -- True if the log message was marked
  log_comment     TEXT,                            -- The comment for this message
  log_tags        TEXT,                            -- A JSON list of tags for this message
  log_filters     TEXT,                            -- A JSON list of filter IDs that matched this message
  -- BEGIN Format-specific fields:
  __MONOTONIC_TIMESTAMP INTEGER  COLLATE 'BINARY'       ,
  _SYSTEMD_UNIT         TEXT     COLLATE 'BINARY'       ,
  SYSLOG_IDENTIFIER     TEXT     COLLATE 'BINARY'       ,
  _PID                  INTEGER  COLLATE 'BINARY'       ,
  PRIORITY              TEXT     COLLATE 'BINARY'       ,

  -- END Format-specific fields
  log_time_msecs  INTEGER HIDDEN,                    -- The adjusted timestamp for the log message as the number of milliseconds from the epoch
  log_path        TEXT HIDDEN COLLATE naturalnocase, -- The path to the log file this message is from
  log_text        TEXT HIDDEN,                       -- The full text of the log message
  log_body        TEXT HIDDEN,                       -- The body of the log message
  log_raw_text    TEXT HIDDEN                        -- The raw text from the log file
);

2021-12-03T09:18:29.138 D t0 log_vtab_impl.cc:212 creating log format table: journald_json_log = 0
2021-12-03T09:18:29.138 D t0 log_vtab_impl.cc:130 log_vtab_impl.get_table_statement() -> CREATE TABLE katello_log  (
  log_line        INTEGER  PRIMARY KEY,            -- The line number for the log message
  log_part        TEXT     COLLATE naturalnocase,  -- The partition the message is in
  log_time        DATETIME,                        -- The adjusted timestamp for the log message
  log_actual_time DATETIME HIDDEN,                 -- The timestamp from the original log file for this message
  log_idle_msecs  INTEGER,                         -- The difference in time between this messages and the previous
  log_level       TEXT     COLLATE loglevel,       -- The log message level
  log_mark        BOOLEAN,                         -- True if the log message was marked
  log_comment     TEXT,                            -- The comment for this message
  log_tags        TEXT,                            -- A JSON list of tags for this message
  log_filters     TEXT,                            -- A JSON list of filter IDs that matched this message
  -- BEGIN Format-specific fields:
  alert_level     TEXT     COLLATE 'BINARY'       ,
  message         TEXT     COLLATE 'BINARY'       ,
  module          TEXT     COLLATE 'BINARY'       ,

  -- END Format-specific fields
  log_time_msecs  INTEGER HIDDEN,                    -- The adjusted timestamp for the log message as the number of milliseconds from the epoch
  log_path        TEXT HIDDEN COLLATE naturalnocase, -- The path to the log file this message is from
  log_text        TEXT HIDDEN,                       -- The full text of the log message
  log_body        TEXT HIDDEN,                       -- The body of the log message
  log_raw_text    TEXT HIDDEN                        -- The raw text from the log file
);

2021-12-03T09:18:29.138 D t0 log_vtab_impl.cc:212 creating log format table: katello_log = 0
2021-12-03T09:18:29.138 D t0 log_vtab_impl.cc:130 log_vtab_impl.get_table_statement() -> CREATE TABLE openam_log  (
  log_line        INTEGER  PRIMARY KEY,            -- The line number for the log message
  log_part        TEXT     COLLATE naturalnocase,  -- The partition the message is in
  log_time        DATETIME,                        -- The adjusted timestamp for the log message
  log_actual_time DATETIME HIDDEN,                 -- The timestamp from the original log file for this message
  log_idle_msecs  INTEGER,                         -- The difference in time between this messages and the previous
  log_level       TEXT     COLLATE loglevel,       -- The log message level
  log_mark        BOOLEAN,                         -- True if the log message was marked
  log_comment     TEXT,                            -- The comment for this message
  log_tags        TEXT,                            -- A JSON list of tags for this message
  log_filters     TEXT,                            -- A JSON list of filter IDs that matched this message
  -- BEGIN Format-specific fields:
  contextid       TEXT     COLLATE 'BINARY'       ,
  data            TEXT     COLLATE 'BINARY'       ,
  domain          TEXT     COLLATE 'BINARY'       ,
  hostname        TEXT     COLLATE 'ipaddress'    ,
  ipaddr          TEXT     COLLATE 'ipaddress'    ,
  loggedby        TEXT     COLLATE 'BINARY'       ,
  loginid         TEXT     COLLATE 'BINARY'       ,
  messageid       TEXT     COLLATE 'BINARY'       ,
  modulename      TEXT     COLLATE 'BINARY'       ,
  nameid          TEXT     COLLATE 'BINARY'       ,

  -- END Format-specific fields
  log_time_msecs  INTEGER HIDDEN,                    -- The adjusted timestamp for the log message as the number of milliseconds from the epoch
  log_path        TEXT HIDDEN COLLATE naturalnocase, -- The path to the log file this message is from
  log_text        TEXT HIDDEN,                       -- The full text of the log message
  log_body        TEXT HIDDEN,                       -- The bo
2021-12-03T09:18:29.138 D t0 log_vtab_impl.cc:212 creating log format table: openam_log = 0
2021-12-03T09:18:29.138 D t0 log_vtab_impl.cc:130 log_vtab_impl.get_table_statement() -> CREATE TABLE openamdb_log  (
  log_line        INTEGER  PRIMARY KEY,            -- The line number for the log message
  log_part        TEXT     COLLATE naturalnocase,  -- The partition the message is in
  log_time        DATETIME,                        -- The adjusted timestamp for the log message
  log_actual_time DATETIME HIDDEN,                 -- The timestamp from the original log file for this message
  log_idle_msecs  INTEGER,                         -- The difference in time between this messages and the previous
  log_level       TEXT     COLLATE loglevel,       -- The log message level
  log_mark        BOOLEAN,                         -- True if the log message was marked
  log_comment     TEXT,                            -- The comment for this message
  log_tags        TEXT,                            -- A JSON list of tags for this message
  log_filters     TEXT,                            -- A JSON list of filter IDs that matched this message
  -- BEGIN Format-specific fields:

  -- END Format-specific fields
  log_time_msecs  INTEGER HIDDEN,                    -- The adjusted timestamp for the log message as the number of milliseconds from the epoch
  log_path        TEXT HIDDEN COLLATE naturalnocase, -- The path to the log file this message is from
  log_text        TEXT HIDDEN,                       -- The full text of the log message
  log_body        TEXT HIDDEN,                       -- The body of the log message
  log_raw_text    TEXT HIDDEN                        -- The raw text from the log file
);

2021-12-03T09:18:29.138 D t0 log_vtab_impl.cc:212 creating log format table: openamdb_log = 0
2021-12-03T09:18:29.139 D t0 log_vtab_impl.cc:130 log_vtab_impl.get_table_statement() -> CREATE TABLE page_log  (
  log_line        INTEGER  PRIMARY KEY,            -- The line number for the log message
  log_part        TEXT     COLLATE naturalnocase,  -- The partition the message is in
  log_time        DATETIME,                        -- The adjusted timestamp for the log message
  log_actual_time DATETIME HIDDEN,                 -- The timestamp from the original log file for this message
  log_idle_msecs  INTEGER,                         -- The difference in time between this messages and the previous
  log_level       TEXT     COLLATE loglevel,       -- The log message level
  log_mark        BOOLEAN,                         -- True if the log message was marked
  log_comment     TEXT,                            -- The comment for this message
  log_tags        TEXT,                            -- A JSON list of tags for this message
  log_filters     TEXT,                            -- A JSON list of filter IDs that matched this message
  -- BEGIN Format-specific fields:
  job_billing              TEXT     COLLATE 'BINARY'       ,
  job_id                   INTEGER  COLLATE 'BINARY'       ,
  job_name                 TEXT     COLLATE 'BINARY'       ,
  job_originating_hostname TEXT     COLLATE 'ipaddress'    ,
  media                    TEXT     COLLATE 'BINARY'       ,
  num_copies               INTEGER  COLLATE 'BINARY'       ,
  page_number              TEXT     COLLATE 'BINARY'       ,
  printer                  TEXT     COLLATE 'BINARY'       ,
  sides                    TEXT     COLLATE 'BINARY'       ,
  username                 TEXT     COLLATE 'BINARY'       ,

  -- END Format-specific fields
  log_time_msecs  INTEGER HIDDEN,                    -- The adjusted timestamp for the log message as the number of milliseconds from the epoch
  log_path        TEXT HIDDEN COLLATE naturalnocase, -- The path to the log file this message is from
  log_text        TEXT HIDDEN,                       -- The ful
2021-12-03T09:18:29.139 D t0 log_vtab_impl.cc:212 creating log format table: page_log = 0
2021-12-03T09:18:29.139 D t0 log_vtab_impl.cc:130 log_vtab_impl.get_table_statement() -> CREATE TABLE papertrail_log  (
  log_line        INTEGER  PRIMARY KEY,            -- The line number for the log message
  log_part        TEXT     COLLATE naturalnocase,  -- The partition the message is in
  log_time        DATETIME,                        -- The adjusted timestamp for the log message
  log_actual_time DATETIME HIDDEN,                 -- The timestamp from the original log file for this message
  log_idle_msecs  INTEGER,                         -- The difference in time between this messages and the previous
  log_level       TEXT     COLLATE loglevel,       -- The log message level
  log_mark        BOOLEAN,                         -- True if the log message was marked
  log_comment     TEXT,                            -- The comment for this message
  log_tags        TEXT,                            -- A JSON list of tags for this message
  log_filters     TEXT,                            -- A JSON list of filter IDs that matched this message
  -- BEGIN Format-specific fields:
  display_received_at TEXT     COLLATE 'BINARY'       ,
  program             TEXT     COLLATE 'BINARY'       ,
  hostname            TEXT     COLLATE 'BINARY'       ,

  -- END Format-specific fields
  log_time_msecs  INTEGER HIDDEN,                    -- The adjusted timestamp for the log message as the number of milliseconds from the epoch
  log_path        TEXT HIDDEN COLLATE naturalnocase, -- The path to the log file this message is from
  log_text        TEXT HIDDEN,                       -- The full text of the log message
  log_body        TEXT HIDDEN,                       -- The body of the log message
  log_raw_text    TEXT HIDDEN                        -- The raw text from the log file
);

2021-12-03T09:18:29.139 D t0 log_vtab_impl.cc:212 creating log format table: papertrail_log = 0
2021-12-03T09:18:29.139 D t0 log_vtab_impl.cc:130 log_vtab_impl.get_table_statement() -> CREATE TABLE s3_log  (
  log_line        INTEGER  PRIMARY KEY,            -- The line number for the log message
  log_part        TEXT     COLLATE naturalnocase,  -- The partition the message is in
  log_time        DATETIME,                        -- The adjusted timestamp for the log message
  log_actual_time DATETIME HIDDEN,                 -- The timestamp from the original log file for this message
  log_idle_msecs  INTEGER,                         -- The difference in time between this messages and the previous
  log_level       TEXT     COLLATE loglevel,       -- The log message level
  log_mark        BOOLEAN,                         -- True if the log message was marked
  log_comment     TEXT,                            -- The comment for this message
  log_tags        TEXT,                            -- A JSON list of tags for this message
  log_filters     TEXT,                            -- A JSON list of filter IDs that matched this message
  -- BEGIN Format-specific fields:
  bucket           TEXT     COLLATE 'BINARY'       , -- The bucket
  c_ip             TEXT     COLLATE 'ipaddress'    , -- The client IP address
  cs_key           TEXT     COLLATE 'BINARY'       , -- The key for the bucket
  cs_method        TEXT     COLLATE 'BINARY'       , -- The request method
  cs_referer       TEXT     COLLATE 'BINARY'       , -- The client's referrer
  cs_uri_query     TEXT     COLLATE 'BINARY'       , -- The query parameters in the request URI
  cs_uri_stem      TEXT     COLLATE 'BINARY'       , -- The path part of the request URI
  cs_user_agent    TEXT     COLLATE 'BINARY'       , -- The client's HTTP agent
  cs_userid        TEXT     COLLATE 'BINARY'       , -- The user ID passed from the client to the server
  cs_version       TEXT     COLLATE 'BINARY'       , -- The client's HTTP version
  obj_size         INTEGER  COLLATE 'BINARY'       , -- The size of the object
  op               TEXT     COLLATE 'BINARY'
2021-12-03T09:18:29.139 D t0 log_vtab_impl.cc:212 creating log format table: s3_log = 0
2021-12-03T09:18:29.140 D t0 log_vtab_impl.cc:130 log_vtab_impl.get_table_statement() -> CREATE TABLE snaplogic_log  (
  log_line        INTEGER  PRIMARY KEY,            -- The line number for the log message
  log_part        TEXT     COLLATE naturalnocase,  -- The partition the message is in
  log_time        DATETIME,                        -- The adjusted timestamp for the log message
  log_actual_time DATETIME HIDDEN,                 -- The timestamp from the original log file for this message
  log_idle_msecs  INTEGER,                         -- The difference in time between this messages and the previous
  log_level       TEXT     COLLATE loglevel,       -- The log message level
  log_mark        BOOLEAN,                         -- True if the log message was marked
  log_comment     TEXT,                            -- The comment for this message
  log_tags        TEXT,                            -- A JSON list of tags for this message
  log_filters     TEXT,                            -- A JSON list of filter IDs that matched this message
  -- BEGIN Format-specific fields:
  comp_rid        TEXT     COLLATE 'BINARY'       ,
  facility        TEXT     COLLATE 'BINARY'       ,
  invoker         TEXT     COLLATE 'BINARY'       ,
  logger          TEXT     COLLATE 'BINARY'       ,
  msgid           TEXT     COLLATE 'BINARY'       ,
  pipe_rid        TEXT     COLLATE 'BINARY'       ,
  resource_name   TEXT     COLLATE 'BINARY'       ,

  -- END Format-specific fields
  log_time_msecs  INTEGER HIDDEN,                    -- The adjusted timestamp for the log message as the number of milliseconds from the epoch
  log_path        TEXT HIDDEN COLLATE naturalnocase, -- The path to the log file this message is from
  log_text        TEXT HIDDEN,                       -- The full text of the log message
  log_body        TEXT HIDDEN,                       -- The body of the log message
  log_raw_text    TEXT HIDDEN                        -- The raw text from the log file
);

2021-12-03T09:18:29.140 D t0 log_vtab_impl.cc:212 creating log format table: snaplogic_log = 0
2021-12-03T09:18:29.140 D t0 log_vtab_impl.cc:130 log_vtab_impl.get_table_statement() -> CREATE TABLE sssd_log  (
  log_line        INTEGER  PRIMARY KEY,            -- The line number for the log message
  log_part        TEXT     COLLATE naturalnocase,  -- The partition the message is in
  log_time        DATETIME,                        -- The adjusted timestamp for the log message
  log_actual_time DATETIME HIDDEN,                 -- The timestamp from the original log file for this message
  log_idle_msecs  INTEGER,                         -- The difference in time between this messages and the previous
  log_level       TEXT     COLLATE loglevel,       -- The log message level
  log_mark        BOOLEAN,                         -- True if the log message was marked
  log_comment     TEXT,                            -- The comment for this message
  log_tags        TEXT,                            -- A JSON list of tags for this message
  log_filters     TEXT,                            -- A JSON list of filter IDs that matched this message
  -- BEGIN Format-specific fields:
  debug_level     TEXT     COLLATE 'BINARY'       ,
  function        TEXT     COLLATE 'BINARY'       ,
  module          TEXT     COLLATE 'BINARY'       ,

  -- END Format-specific fields
  log_time_msecs  INTEGER HIDDEN,                    -- The adjusted timestamp for the log message as the number of milliseconds from the epoch
  log_path        TEXT HIDDEN COLLATE naturalnocase, -- The path to the log file this message is from
  log_text        TEXT HIDDEN,                       -- The full text of the log message
  log_body        TEXT HIDDEN,                       -- The body of the log message
  log_raw_text    TEXT HIDDEN                        -- The raw text from the log file
);

2021-12-03T09:18:29.140 D t0 log_vtab_impl.cc:212 creating log format table: sssd_log = 0
2021-12-03T09:18:29.140 D t0 log_vtab_impl.cc:130 log_vtab_impl.get_table_statement() -> CREATE TABLE strace_log  (
  log_line        INTEGER  PRIMARY KEY,            -- The line number for the log message
  log_part        TEXT     COLLATE naturalnocase,  -- The partition the message is in
  log_time        DATETIME,                        -- The adjusted timestamp for the log message
  log_actual_time DATETIME HIDDEN,                 -- The timestamp from the original log file for this message
  log_idle_msecs  INTEGER,                         -- The difference in time between this messages and the previous
  log_level       TEXT     COLLATE loglevel,       -- The log message level
  log_mark        BOOLEAN,                         -- True if the log message was marked
  log_comment     TEXT,                            -- The comment for this message
  log_tags        TEXT,                            -- A JSON list of tags for this message
  log_filters     TEXT,                            -- A JSON list of filter IDs that matched this message
  -- BEGIN Format-specific fields:
  duration        FLOAT    COLLATE 'BINARY'       ,
  errno           TEXT     COLLATE 'BINARY'       ,
  rc              INTEGER  COLLATE 'BINARY'       ,
  syscall         TEXT     COLLATE 'BINARY'       ,
  args            TEXT     COLLATE 'BINARY'       ,

  -- END Format-specific fields
  log_time_msecs  INTEGER HIDDEN,                    -- The adjusted timestamp for the log message as the number of milliseconds from the epoch
  log_path        TEXT HIDDEN COLLATE naturalnocase, -- The path to the log file this message is from
  log_text        TEXT HIDDEN,                       -- The full text of the log message
  log_body        TEXT HIDDEN,                       -- The body of the log message
  log_raw_text    TEXT HIDDEN                        -- The raw text from the log file
);

2021-12-03T09:18:29.140 D t0 log_vtab_impl.cc:212 creating log format table: strace_log = 0
2021-12-03T09:18:29.140 D t0 log_vtab_impl.cc:130 log_vtab_impl.get_table_statement() -> CREATE TABLE sudo_log  (
  log_line        INTEGER  PRIMARY KEY,            -- The line number for the log message
  log_part        TEXT     COLLATE naturalnocase,  -- The partition the message is in
  log_time        DATETIME,                        -- The adjusted timestamp for the log message
  log_actual_time DATETIME HIDDEN,                 -- The timestamp from the original log file for this message
  log_idle_msecs  INTEGER,                         -- The difference in time between this messages and the previous
  log_level       TEXT     COLLATE loglevel,       -- The log message level
  log_mark        BOOLEAN,                         -- True if the log message was marked
  log_comment     TEXT,                            -- The comment for this message
  log_tags        TEXT,                            -- A JSON list of tags for this message
  log_filters     TEXT,                            -- A JSON list of filter IDs that matched this message
  -- BEGIN Format-specific fields:
  command         TEXT     COLLATE 'BINARY'       ,
  error_msg       TEXT     COLLATE 'BINARY'       ,
  login           TEXT     COLLATE 'BINARY'       ,
  pwd             TEXT     COLLATE 'BINARY'       ,
  tty             TEXT     COLLATE 'BINARY'       ,
  user            TEXT     COLLATE 'BINARY'       ,

  -- END Format-specific fields
  log_time_msecs  INTEGER HIDDEN,                    -- The adjusted timestamp for the log message as the number of milliseconds from the epoch
  log_path        TEXT HIDDEN COLLATE naturalnocase, -- The path to the log file this message is from
  log_text        TEXT HIDDEN,                       -- The full text of the log message
  log_body        TEXT HIDDEN,                       -- The body of the log message
  log_raw_text    TEXT HIDDEN                        -- The raw text from the log file
);

2021-12-03T09:18:29.140 D t0 log_vtab_impl.cc:212 creating log format table: sudo_log = 0
2021-12-03T09:18:29.141 D t0 log_vtab_impl.cc:130 log_vtab_impl.get_table_statement() -> CREATE TABLE tcf_log  (
  log_line        INTEGER  PRIMARY KEY,            -- The line number for the log message
  log_part        TEXT     COLLATE naturalnocase,  -- The partition the message is in
  log_time        DATETIME,                        -- The adjusted timestamp for the log message
  log_actual_time DATETIME HIDDEN,                 -- The timestamp from the original log file for this message
  log_idle_msecs  INTEGER,                         -- The difference in time between this messages and the previous
  log_level       TEXT     COLLATE loglevel,       -- The log message level
  log_mark        BOOLEAN,                         -- True if the log message was marked
  log_comment     TEXT,                            -- The comment for this message
  log_tags        TEXT,                            -- A JSON list of tags for this message
  log_filters     TEXT,                            -- A JSON list of filter IDs that matched this message
  -- BEGIN Format-specific fields:
  dir             TEXT     COLLATE 'BINARY'       ,
  msg             TEXT     COLLATE 'BINARY'       ,
  name            TEXT     COLLATE 'BINARY'       ,
  service         TEXT     COLLATE 'BINARY'       ,
  token           TEXT     COLLATE 'BINARY'       ,
  type            TEXT     COLLATE 'BINARY'       ,

  -- END Format-specific fields
  log_time_msecs  INTEGER HIDDEN,                    -- The adjusted timestamp for the log message as the number of milliseconds from the epoch
  log_path        TEXT HIDDEN COLLATE naturalnocase, -- The path to the log file this message is from
  log_text        TEXT HIDDEN,                       -- The full text of the log message
  log_body        TEXT HIDDEN,                       -- The body of the log message
  log_raw_text    TEXT HIDDEN                        -- The raw text from the log file
);

2021-12-03T09:18:29.141 D t0 log_vtab_impl.cc:212 creating log format table: tcf_log = 0
2021-12-03T09:18:29.141 D t0 log_vtab_impl.cc:130 log_vtab_impl.get_table_statement() -> CREATE TABLE tcsh_history  (
  log_line        INTEGER  PRIMARY KEY,            -- The line number for the log message
  log_part        TEXT     COLLATE naturalnocase,  -- The partition the message is in
  log_time        DATETIME,                        -- The adjusted timestamp for the log message
  log_actual_time DATETIME HIDDEN,                 -- The timestamp from the original log file for this message
  log_idle_msecs  INTEGER,                         -- The difference in time between this messages and the previous
  log_level       TEXT     COLLATE loglevel,       -- The log message level
  log_mark        BOOLEAN,                         -- True if the log message was marked
  log_comment     TEXT,                            -- The comment for this message
  log_tags        TEXT,                            -- A JSON list of tags for this message
  log_filters     TEXT,                            -- A JSON list of filter IDs that matched this message
  -- BEGIN Format-specific fields:

  -- END Format-specific fields
  log_time_msecs  INTEGER HIDDEN,                    -- The adjusted timestamp for the log message as the number of milliseconds from the epoch
  log_path        TEXT HIDDEN COLLATE naturalnocase, -- The path to the log file this message is from
  log_text        TEXT HIDDEN,                       -- The full text of the log message
  log_body        TEXT HIDDEN,                       -- The body of the log message
  log_raw_text    TEXT HIDDEN                        -- The raw text from the log file
);

2021-12-03T09:18:29.141 D t0 log_vtab_impl.cc:212 creating log format table: tcsh_history = 0
2021-12-03T09:18:29.141 D t0 log_vtab_impl.cc:130 log_vtab_impl.get_table_statement() -> CREATE TABLE uwsgi_log  (
  log_line        INTEGER  PRIMARY KEY,            -- The line number for the log message
  log_part        TEXT     COLLATE naturalnocase,  -- The partition the message is in
  log_time        DATETIME,                        -- The adjusted timestamp for the log message
  log_actual_time DATETIME HIDDEN,                 -- The timestamp from the original log file for this message
  log_idle_msecs  INTEGER,                         -- The difference in time between this messages and the previous
  log_level       TEXT     COLLATE loglevel,       -- The log message level
  log_mark        BOOLEAN,                         -- True if the log message was marked
  log_comment     TEXT,                            -- The comment for this message
  log_tags        TEXT,                            -- A JSON list of tags for this message
  log_filters     TEXT,                            -- A JSON list of filter IDs that matched this message
  -- BEGIN Format-specific fields:
  c_ip            TEXT     COLLATE 'ipaddress'    ,
  cs_bytes        INTEGER  COLLATE 'BINARY'       ,
  cs_method       TEXT     COLLATE 'BINARY'       ,
  cs_uri_query    TEXT     COLLATE 'BINARY'       ,
  cs_uri_stem     TEXT     COLLATE 'BINARY'       ,
  cs_username     TEXT     COLLATE 'BINARY'       ,
  cs_vars         INTEGER  COLLATE 'BINARY'       ,
  cs_version      TEXT     COLLATE 'BINARY'       ,
  s_app           TEXT     COLLATE 'BINARY'       ,
  s_core          TEXT     COLLATE 'BINARY'       ,
  s_pid           TEXT     COLLATE 'BINARY'       ,
  s_req           INTEGER  COLLATE 'BINARY'       ,
  s_runtime       FLOAT    COLLATE 'BINARY'       , -- hello, world
  s_switches      INTEGER  COLLATE 'BINARY'       ,
  s_worker_reqs   INTEGER  COLLATE 'BINARY'       ,
  sc_bytes        INTEGER  COLLATE 'BINARY'       ,
  sc_header_bytes INTEGER  COLLATE 'BINARY'       ,
  sc_headers      INTEGER  COLLATE 'BINARY'       ,
2021-12-03T09:18:29.141 D t0 log_vtab_impl.cc:212 creating log format table: uwsgi_log = 0
2021-12-03T09:18:29.141 D t0 log_vtab_impl.cc:130 log_vtab_impl.get_table_statement() -> CREATE TABLE vdsm_log  (
  log_line        INTEGER  PRIMARY KEY,            -- The line number for the log message
  log_part        TEXT     COLLATE naturalnocase,  -- The partition the message is in
  log_time        DATETIME,                        -- The adjusted timestamp for the log message
  log_actual_time DATETIME HIDDEN,                 -- The timestamp from the original log file for this message
  log_idle_msecs  INTEGER,                         -- The difference in time between this messages and the previous
  log_level       TEXT     COLLATE loglevel,       -- The log message level
  log_mark        BOOLEAN,                         -- True if the log message was marked
  log_comment     TEXT,                            -- The comment for this message
  log_tags        TEXT,                            -- A JSON list of tags for this message
  log_filters     TEXT,                            -- A JSON list of filter IDs that matched this message
  -- BEGIN Format-specific fields:
  func            TEXT     COLLATE 'BINARY'       ,
  logger          TEXT     COLLATE 'BINARY'       ,
  module          TEXT     COLLATE 'BINARY'       ,
  src_line        INTEGER  COLLATE 'BINARY'       ,
  tid             TEXT     COLLATE 'BINARY'       ,
  src_file        TEXT     COLLATE 'BINARY'       ,
  thread          TEXT     COLLATE 'BINARY'       ,
  traceback       TEXT     COLLATE 'BINARY'       ,

  -- END Format-specific fields
  log_time_msecs  INTEGER HIDDEN,                    -- The adjusted timestamp for the log message as the number of milliseconds from the epoch
  log_path        TEXT HIDDEN COLLATE naturalnocase, -- The path to the log file this message is from
  log_text        TEXT HIDDEN,                       -- The full text of the log message
  log_body        TEXT HIDDEN,                       -- The body of the log message
  log_raw_text    TEXT HIDDEN                        -- The raw text from the log fi
2021-12-03T09:18:29.141 D t0 log_vtab_impl.cc:212 creating log format table: vdsm_log = 0
2021-12-03T09:18:29.142 D t0 log_vtab_impl.cc:130 log_vtab_impl.get_table_statement() -> CREATE TABLE vmk_log  (
  log_line        INTEGER  PRIMARY KEY,            -- The line number for the log message
  log_part        TEXT     COLLATE naturalnocase,  -- The partition the message is in
  log_time        DATETIME,                        -- The adjusted timestamp for the log message
  log_actual_time DATETIME HIDDEN,                 -- The timestamp from the original log file for this message
  log_idle_msecs  INTEGER,                         -- The difference in time between this messages and the previous
  log_level       TEXT     COLLATE loglevel,       -- The log message level
  log_mark        BOOLEAN,                         -- True if the log message was marked
  log_comment     TEXT,                            -- The comment for this message
  log_tags        TEXT,                            -- A JSON list of tags for this message
  log_filters     TEXT,                            -- A JSON list of filter IDs that matched this message
  -- BEGIN Format-specific fields:
  cpu             INTEGER  COLLATE 'BINARY'       ,
  subsystem       TEXT     COLLATE 'BINARY'       ,
  world_id        INTEGER  COLLATE 'BINARY'       ,

  -- END Format-specific fields
  log_time_msecs  INTEGER HIDDEN,                    -- The adjusted timestamp for the log message as the number of milliseconds from the epoch
  log_path        TEXT HIDDEN COLLATE naturalnocase, -- The path to the log file this message is from
  log_text        TEXT HIDDEN,                       -- The full text of the log message
  log_body        TEXT HIDDEN,                       -- The body of the log message
  log_raw_text    TEXT HIDDEN                        -- The raw text from the log file
);

2021-12-03T09:18:29.142 D t0 log_vtab_impl.cc:212 creating log format table: vmk_log = 0
2021-12-03T09:18:29.142 D t0 log_vtab_impl.cc:130 log_vtab_impl.get_table_statement() -> CREATE TABLE vmw_log  (
  log_line        INTEGER  PRIMARY KEY,            -- The line number for the log message
  log_part        TEXT     COLLATE naturalnocase,  -- The partition the message is in
  log_time        DATETIME,                        -- The adjusted timestamp for the log message
  log_actual_time DATETIME HIDDEN,                 -- The timestamp from the original log file for this message
  log_idle_msecs  INTEGER,                         -- The difference in time between this messages and the previous
  log_level       TEXT     COLLATE loglevel,       -- The log message level
  log_mark        BOOLEAN,                         -- True if the log message was marked
  log_comment     TEXT,                            -- The comment for this message
  log_tags        TEXT,                            -- A JSON list of tags for this message
  log_filters     TEXT,                            -- A JSON list of filter IDs that matched this message
  -- BEGIN Format-specific fields:
  comp            TEXT     COLLATE 'BINARY'       ,
  opid            TEXT     COLLATE 'BINARY'       ,
  tid             TEXT     COLLATE 'BINARY'       ,
  user            TEXT     COLLATE 'BINARY'       ,
  prc             TEXT     COLLATE 'BINARY'       ,
  src             TEXT     COLLATE 'BINARY'       ,
  sub             TEXT     COLLATE 'BINARY'       ,
  line            INTEGER  COLLATE 'BINARY'       ,
  file            TEXT     COLLATE 'BINARY'       ,

  -- END Format-specific fields
  log_time_msecs  INTEGER HIDDEN,                    -- The adjusted timestamp for the log message as the number of milliseconds from the epoch
  log_path        TEXT HIDDEN COLLATE naturalnocase, -- The path to the log file this message is from
  log_text        TEXT HIDDEN,                       -- The full text of the log message
  log_body        TEXT HIDDEN,                       -- The body of the log message
  log_raw_text    TEXT HIDDEN
2021-12-03T09:18:29.142 D t0 log_vtab_impl.cc:212 creating log format table: vmw_log = 0
2021-12-03T09:18:29.142 D t0 log_vtab_impl.cc:130 log_vtab_impl.get_table_statement() -> CREATE TABLE xmlrpc_log  (
  log_line        INTEGER  PRIMARY KEY,            -- The line number for the log message
  log_part        TEXT     COLLATE naturalnocase,  -- The partition the message is in
  log_time        DATETIME,                        -- The adjusted timestamp for the log message
  log_actual_time DATETIME HIDDEN,                 -- The timestamp from the original log file for this message
  log_idle_msecs  INTEGER,                         -- The difference in time between this messages and the previous
  log_level       TEXT     COLLATE loglevel,       -- The log message level
  log_mark        BOOLEAN,                         -- True if the log message was marked
  log_comment     TEXT,                            -- The comment for this message
  log_tags        TEXT,                            -- A JSON list of tags for this message
  log_filters     TEXT,                            -- A JSON list of filter IDs that matched this message
  -- BEGIN Format-specific fields:
  client_ip       TEXT     COLLATE 'BINARY'       ,
  function        TEXT     COLLATE 'BINARY'       ,
  module          TEXT     COLLATE 'BINARY'       ,
  pid             INTEGER  COLLATE 'BINARY'       ,

  -- END Format-specific fields
  log_time_msecs  INTEGER HIDDEN,                    -- The adjusted timestamp for the log message as the number of milliseconds from the epoch
  log_path        TEXT HIDDEN COLLATE naturalnocase, -- The path to the log file this message is from
  log_text        TEXT HIDDEN,                       -- The full text of the log message
  log_body        TEXT HIDDEN,                       -- The body of the log message
  log_raw_text    TEXT HIDDEN                        -- The raw text from the log file
);

2021-12-03T09:18:29.142 D t0 log_vtab_impl.cc:212 creating log format table: xmlrpc_log = 0
2021-12-03T09:18:29.142 D t0 log_vtab_impl.cc:130 log_vtab_impl.get_table_statement() -> CREATE TABLE openstack_log  (
  log_line        INTEGER  PRIMARY KEY,            -- The line number for the log message
  log_part        TEXT     COLLATE naturalnocase,  -- The partition the message is in
  log_time        DATETIME,                        -- The adjusted timestamp for the log message
  log_actual_time DATETIME HIDDEN,                 -- The timestamp from the original log file for this message
  log_idle_msecs  INTEGER,                         -- The difference in time between this messages and the previous
  log_level       TEXT     COLLATE loglevel,       -- The log message level
  log_mark        BOOLEAN,                         -- True if the log message was marked
  log_comment     TEXT,                            -- The comment for this message
  log_tags        TEXT,                            -- A JSON list of tags for this message
  log_filters     TEXT,                            -- A JSON list of filter IDs that matched this message
  -- BEGIN Format-specific fields:
  logger          TEXT     COLLATE 'BINARY'       ,
  user            TEXT     COLLATE 'BINARY'       ,
  tid             TEXT     COLLATE 'BINARY'       ,
  pid             TEXT     COLLATE 'BINARY'       ,

  -- END Format-specific fields
  log_time_msecs  INTEGER HIDDEN,                    -- The adjusted timestamp for the log message as the number of milliseconds from the epoch
  log_path        TEXT HIDDEN COLLATE naturalnocase, -- The path to the log file this message is from
  log_text        TEXT HIDDEN,                       -- The full text of the log message
  log_body        TEXT HIDDEN,                       -- The body of the log message
  log_raw_text    TEXT HIDDEN                        -- The raw text from the log file
);

2021-12-03T09:18:29.142 D t0 log_vtab_impl.cc:212 creating log format table: openstack_log = 0
2021-12-03T09:18:29.142 D t0 log_vtab_impl.cc:130 log_vtab_impl.get_table_statement() -> CREATE TABLE syslog_log  (
  log_line        INTEGER  PRIMARY KEY,            -- The line number for the log message
  log_part        TEXT     COLLATE naturalnocase,  -- The partition the message is in
  log_time        DATETIME,                        -- The adjusted timestamp for the log message
  log_actual_time DATETIME HIDDEN,                 -- The timestamp from the original log file for this message
  log_idle_msecs  INTEGER,                         -- The difference in time between this messages and the previous
  log_level       TEXT     COLLATE loglevel,       -- The log message level
  log_mark        BOOLEAN,                         -- True if the log message was marked
  log_comment     TEXT,                            -- The comment for this message
  log_tags        TEXT,                            -- A JSON list of tags for this message
  log_filters     TEXT,                            -- A JSON list of filter IDs that matched this message
  -- BEGIN Format-specific fields:
  log_hostname    TEXT     COLLATE 'ipaddress'    , -- The name of the host that generated the message
  log_msgid       TEXT     COLLATE 'BINARY'       ,
  log_pid         TEXT     COLLATE 'BINARY'       , -- The ID of the process that generated the message
  log_pri         INTEGER  COLLATE 'BINARY'       , -- The priority level of the message
  log_procname    TEXT     COLLATE 'BINARY'       , -- The name of the process that generated the message
  log_struct      TEXT     COLLATE 'BINARY'       ,
  syslog_version  INTEGER  COLLATE 'BINARY'       , -- The version of the syslog format used for this message

  -- END Format-specific fields
  log_time_msecs  INTEGER HIDDEN,                    -- The adjusted timestamp for the log message as the number of milliseconds from the epoch
  log_path        TEXT HIDDEN COLLATE naturalnocase, -- The path to the log file this message is from
  log_text        TEXT HIDDEN,                       --
2021-12-03T09:18:29.142 D t0 log_vtab_impl.cc:212 creating log format table: syslog_log = 0
2021-12-03T09:18:29.143 D t0 log_vtab_impl.cc:130 log_vtab_impl.get_table_statement() -> CREATE TABLE cups_log  (
  log_line        INTEGER  PRIMARY KEY,            -- The line number for the log message
  log_part        TEXT     COLLATE naturalnocase,  -- The partition the message is in
  log_time        DATETIME,                        -- The adjusted timestamp for the log message
  log_actual_time DATETIME HIDDEN,                 -- The timestamp from the original log file for this message
  log_idle_msecs  INTEGER,                         -- The difference in time between this messages and the previous
  log_level       TEXT     COLLATE loglevel,       -- The log message level
  log_mark        BOOLEAN,                         -- True if the log message was marked
  log_comment     TEXT,                            -- The comment for this message
  log_tags        TEXT,                            -- A JSON list of tags for this message
  log_filters     TEXT,                            -- A JSON list of filter IDs that matched this message
  -- BEGIN Format-specific fields:
  level           TEXT     COLLATE 'BINARY'       ,
  section         TEXT     COLLATE 'BINARY'       ,

  -- END Format-specific fields
  log_time_msecs  INTEGER HIDDEN,                    -- The adjusted timestamp for the log message as the number of milliseconds from the epoch
  log_path        TEXT HIDDEN COLLATE naturalnocase, -- The path to the log file this message is from
  log_text        TEXT HIDDEN,                       -- The full text of the log message
  log_body        TEXT HIDDEN,                       -- The body of the log message
  log_raw_text    TEXT HIDDEN                        -- The raw text from the log file
);

2021-12-03T09:18:29.143 D t0 log_vtab_impl.cc:212 creating log format table: cups_log = 0
2021-12-03T09:18:29.143 D t0 log_vtab_impl.cc:130 log_vtab_impl.get_table_statement() -> CREATE TABLE error_log  (
  log_line        INTEGER  PRIMARY KEY,            -- The line number for the log message
  log_part        TEXT     COLLATE naturalnocase,  -- The partition the message is in
  log_time        DATETIME,                        -- The adjusted timestamp for the log message
  log_actual_time DATETIME HIDDEN,                 -- The timestamp from the original log file for this message
  log_idle_msecs  INTEGER,                         -- The difference in time between this messages and the previous
  log_level       TEXT     COLLATE loglevel,       -- The log message level
  log_mark        BOOLEAN,                         -- True if the log message was marked
  log_comment     TEXT,                            -- The comment for this message
  log_tags        TEXT,                            -- A JSON list of tags for this message
  log_filters     TEXT,                            -- A JSON list of filter IDs that matched this message
  -- BEGIN Format-specific fields:
  c_ip            TEXT     COLLATE 'ipaddress'    , -- The client IP address
  c_port          INTEGER  COLLATE 'BINARY'       ,
  module          TEXT     COLLATE 'BINARY'       ,
  pid             INTEGER  COLLATE 'BINARY'       ,
  tid             INTEGER  COLLATE 'BINARY'       , -- The thread id

  -- END Format-specific fields
  log_time_msecs  INTEGER HIDDEN,                    -- The adjusted timestamp for the log message as the number of milliseconds from the epoch
  log_path        TEXT HIDDEN COLLATE naturalnocase, -- The path to the log file this message is from
  log_text        TEXT HIDDEN,                       -- The full text of the log message
  log_body        TEXT HIDDEN,                       -- The body of the log message
  log_raw_text    TEXT HIDDEN                        -- The raw text from the log file
);

2021-12-03T09:18:29.143 D t0 log_vtab_impl.cc:212 creating log format table: error_log = 0
2021-12-03T09:18:29.143 I t0 log_format_loader.cc:1062 executing SQL files in path: /etc/lnav/formats/*/*.sql
2021-12-03T09:18:29.143 I t0 log_format_loader.cc:1062 executing SQL files in path: /usr/etc/lnav/formats/*/*.sql
2021-12-03T09:18:29.143 I t0 log_format_loader.cc:1062 executing SQL files in path: /root/.lnav/formats/*/*.sql
2021-12-03T09:18:29.143 D t0 isc.cc:42 starting service thread for: isc::service<T>::service(std::string) [with T = curl_looper; std::string = std::__cxx11::basic_string<char>]
2021-12-03T09:18:29.143 D t0 isc.cc:42 starting service thread for: isc::service<T>::service(std::string) [with T = tailer::looper; std::string = std::__cxx11::basic_string<char>]
2021-12-03T09:18:29.143 I t1 isc.cc:49 BEGIN isc thread: isc::service<T>::service(std::string) [with T = curl_looper; std::string = std::__cxx11::basic_string<char>]
2021-12-03T09:18:29.143 I t2 isc.cc:49 BEGIN isc thread: isc::service<T>::service(std::string) [with T = tailer::looper; std::string = std::__cxx11::basic_string<char>]
2021-12-03T09:18:29.143 I t0 lnav.cc:2843 startup: lnav 0.10.1-dirty
2021-12-03T09:18:29.143 I t0 lnav_log.cc:219 uname:
2021-12-03T09:18:29.143 I t0 lnav_log.cc:220   sysname=Linux
2021-12-03T09:18:29.143 I t0 lnav_log.cc:221   nodename=ult-srv103.int.ultimum.nl
2021-12-03T09:18:29.143 I t0 lnav_log.cc:222   machine=x86_64
2021-12-03T09:18:29.143 I t0 lnav_log.cc:223   release=3.10.0-1160.45.1.el7.x86_64
2021-12-03T09:18:29.143 I t0 lnav_log.cc:224   version=#1 SMP Wed Oct 13 17:20:51 UTC 2021
2021-12-03T09:18:29.143 I t0 lnav_log.cc:225 PCRE:
2021-12-03T09:18:29.143 I t0 lnav_log.cc:226   jit=1
2021-12-03T09:18:29.143 I t0 lnav_log.cc:227   jittarget=x86 64bit (little endian + unaligned)
2021-12-03T09:18:29.143 I t0 lnav_log.cc:228 Environment:
2021-12-03T09:18:29.143 I t0 lnav_log.cc:229   HOME=/root
2021-12-03T09:18:29.143 I t0 lnav_log.cc:230   XDG_CONFIG_HOME=(null)
2021-12-03T09:18:29.143 I t0 lnav_log.cc:231   LANG=en_US.utf8
2021-12-03T09:18:29.143 I t0 lnav_log.cc:232   PATH=/usr/local/sbin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin
2021-12-03T09:18:29.143 I t0 lnav_log.cc:233   TERM=xterm-256color
2021-12-03T09:18:29.143 I t0 lnav_log.cc:234   TZ=(null)
2021-12-03T09:18:29.143 I t0 lnav_log.cc:235 Process:
2021-12-03T09:18:29.143 I t0 lnav_log.cc:236   pid=45125
2021-12-03T09:18:29.143 I t0 lnav_log.cc:237   ppid=45124
2021-12-03T09:18:29.143 I t0 lnav_log.cc:238   pgrp=45123
2021-12-03T09:18:29.143 I t0 lnav_log.cc:239   uid=0
2021-12-03T09:18:29.143 I t0 lnav_log.cc:240   gid=0
2021-12-03T09:18:29.143 I t0 lnav_log.cc:241   euid=0
2021-12-03T09:18:29.143 I t0 lnav_log.cc:242   egid=0
2021-12-03T09:18:29.143 I t0 lnav_log.cc:247   cwd=/rsyslog/filter
2021-12-03T09:18:29.143 I t0 lnav_log.cc:249 Executable:
2021-12-03T09:18:29.143 I t0 lnav_log.cc:250   version=lnav 0.10.1-dirty
2021-12-03T09:18:29.143 I t0 lnav_log.cc:253 rusage:
2021-12-03T09:18:29.143 I t0 lnav_log.cc:253   utime=0.048323
2021-12-03T09:18:29.143 I t0 lnav_log.cc:253   stime=0.012080
2021-12-03T09:18:29.143 I t0 lnav_log.cc:253   maxrss=7800
2021-12-03T09:18:29.143 I t0 lnav_log.cc:253   ixrss=0
2021-12-03T09:18:29.143 I t0 lnav_log.cc:253   idrss=0
2021-12-03T09:18:29.143 I t0 lnav_log.cc:253   isrss=0
2021-12-03T09:18:29.143 I t0 lnav_log.cc:253   minflt=3704
2021-12-03T09:18:29.143 I t0 lnav_log.cc:253   majflt=0
2021-12-03T09:18:29.143 I t0 lnav_log.cc:253   nswap=0
2021-12-03T09:18:29.143 I t0 lnav_log.cc:253   inblock=0
2021-12-03T09:18:29.143 I t0 lnav_log.cc:253   oublock=512
2021-12-03T09:18:29.143 I t0 lnav_log.cc:253   msgsnd=0
2021-12-03T09:18:29.143 I t0 lnav_log.cc:253   msgrcv=0
2021-12-03T09:18:29.143 I t0 lnav_log.cc:253   nsignals=0
2021-12-03T09:18:29.143 I t0 lnav_log.cc:253   nvcsw=4
2021-12-03T09:18:29.143 I t0 lnav_log.cc:253   nivcsw=4
2021-12-03T09:18:29.143 I t0 lnav.cc:2845 Libraries:
2021-12-03T09:18:29.143 I t0 lnav.cc:2847   bzip=1.0.8, 13-Jul-2019
2021-12-03T09:18:29.143 I t0 lnav.cc:2850   curl=7.77.0 (2021-05-26)
2021-12-03T09:18:29.143 I t0 lnav.cc:2853   libarchive=3005001
2021-12-03T09:18:29.143 I t0 lnav.cc:2855   ncurses=5.9
2021-12-03T09:18:29.143 I t0 lnav.cc:2856   pcre=8.42 2018-03-20
2021-12-03T09:18:29.143 I t0 lnav.cc:2857   readline=6.3
2021-12-03T09:18:29.143 I t0 lnav.cc:2858   sqlite=3.36.0
2021-12-03T09:18:29.143 I t0 lnav.cc:2859   zlib=1.2.11
2021-12-03T09:18:29.143 I t0 lnav.cc:2860 lnav_data:
2021-12-03T09:18:29.143 I t0 lnav.cc:2861   flags=4
2021-12-03T09:18:29.143 I t0 lnav.cc:2862   commands:
2021-12-03T09:18:29.143 I t0 lnav.cc:2866     |/root/.lnav-filter-syslog.txt
2021-12-03T09:18:29.143 I t0 lnav.cc:2868   files:
2021-12-03T09:18:29.143 I t0 lnav.cc:2872     /rsyslog/filter/executed_logged.log
2021-12-03T09:18:29.143 I t0 lnav.cc:2872     /rsyslog/filter/executed_logged.log-2021-12-03
2021-12-03T09:18:29.143 I t0 lnav.cc:2872     /rsyslog/filter/filtered.log
2021-12-03T09:18:29.143 I t0 lnav.cc:2872     /rsyslog/filter/filtered.log-2021-12-03
2021-12-03T09:18:29.148 D t0 view_curses.cc:532 COLOR_PAIRS = 32767
2021-12-03T09:18:29.169 I t0 command_executor.cc:137 Executing SQL: SELECT 3 BETWEEN 5 AND 10
2021-12-03T09:18:29.169 D t0 view_helpers.cc:436 example: SELECT 3 BETWEEN 5 AND 10
2021-12-03T09:18:29.169 D t0 view_helpers.cc:437 example result: 0
2021-12-03T09:18:29.169 I t0 command_executor.cc:137 Executing SQL: SELECT 10 BETWEEN 5 AND 10
2021-12-03T09:18:29.169 D t0 view_helpers.cc:436 example: SELECT 10 BETWEEN 5 AND 10
2021-12-03T09:18:29.169 D t0 view_helpers.cc:437 example result: 1
2021-12-03T09:18:29.169 I t0 command_executor.cc:137 Executing SQL: ATTACH DATABASE '/tmp/customers.db' AS customers
2021-12-03T09:18:29.170 D t0 view_helpers.cc:436 example: ATTACH DATABASE '/tmp/customers.db' AS customers
2021-12-03T09:18:29.170 D t0 view_helpers.cc:437 example result:
2021-12-03T09:18:29.170 I t0 command_executor.cc:137 Executing SQL: SELECT CAST(1.23 AS INTEGER)
2021-12-03T09:18:29.170 D t0 view_helpers.cc:436 example: SELECT CAST(1.23 AS INTEGER)
2021-12-03T09:18:29.170 D t0 view_helpers.cc:437 example result: 1
2021-12-03T09:18:29.170 I t0 command_executor.cc:137 Executing SQL: ATTACH DATABASE '/tmp/customers.db' AS customers
2021-12-03T09:18:29.170 E t0 sql_util.cc:586 statement aborts at 4: [ATTACH DATABASE '/tmp/customers.db' AS customers] database customers is already in use
2021-12-03T09:18:29.170 E t0 command_executor.cc:298 sqlite3_step error code: 1
2021-12-03T09:18:29.170 D t0 view_helpers.cc:436 example: ATTACH DATABASE '/tmp/customers.db' AS customers
2021-12-03T09:18:29.170 D t0 view_helpers.cc:437 example result:
2021-12-03T09:18:29.170 I t0 command_executor.cc:137 Executing SQL: SELECT 3 BETWEEN 5 AND 10
2021-12-03T09:18:29.170 D t0 view_helpers.cc:436 example: SELECT 3 BETWEEN 5 AND 10
2021-12-03T09:18:29.170 D t0 view_helpers.cc:437 example result: 0
2021-12-03T09:18:29.170 I t0 command_executor.cc:137 Executing SQL: SELECT 10 BETWEEN 5 AND 10
2021-12-03T09:18:29.170 D t0 view_helpers.cc:436 example: SELECT 10 BETWEEN 5 AND 10
2021-12-03T09:18:29.170 D t0 view_helpers.cc:437 example result: 1
2021-12-03T09:18:29.170 I t0 command_executor.cc:137 Executing SQL: SELECT CASE 1 WHEN 0 THEN 'zero' WHEN 1 THEN 'one' END
2021-12-03T09:18:29.170 D t0 view_helpers.cc:436 example: SELECT CASE 1 WHEN 0 THEN 'zero' WHEN 1 THEN 'one' END
2021-12-03T09:18:29.170 D t0 view_helpers.cc:437 example result: one
2021-12-03T09:18:29.170 I t0 command_executor.cc:137 Executing SQL: SELECT CAST(1.23 AS INTEGER)
2021-12-03T09:18:29.170 D t0 view_helpers.cc:436 example: SELECT CAST(1.23 AS INTEGER)
2021-12-03T09:18:29.170 D t0 view_helpers.cc:437 example result: 1
2021-12-03T09:18:29.170 I t0 command_executor.cc:137 Executing SQL: SELECT ('a2' < 'a10'), ('a2' < 'a10' COLLATE naturalnocase)
2021-12-03T09:18:29.170 D t0 view_helpers.cc:436 example: SELECT ('a2' < 'a10'), ('a2' < 'a10' COLLATE naturalnocase)
2021-12-03T09:18:29.170 D t0 view_helpers.cc:437 example result: ('a2' < 'a10') ('a2' < 'a10' COLLATE naturalnocase)
             0                                    1
2021-12-03T09:18:29.170 I t0 command_executor.cc:137 Executing SQL: ATTACH DATABASE '/tmp/customers.db' AS customers
2021-12-03T09:18:29.170 E t0 sql_util.cc:586 statement aborts at 4: [ATTACH DATABASE '/tmp/customers.db' AS customers] database customers is already in use
2021-12-03T09:18:29.170 E t0 command_executor.cc:298 sqlite3_step error code: 1
2021-12-03T09:18:29.170 D t0 view_helpers.cc:436 example: ATTACH DATABASE '/tmp/customers.db' AS customers
2021-12-03T09:18:29.170 D t0 view_helpers.cc:437 example result:
2021-12-03T09:18:29.170 I t0 command_executor.cc:137 Executing SQL: DETACH DATABASE customers
2021-12-03T09:18:29.170 D t0 view_helpers.cc:436 example: DETACH DATABASE customers
2021-12-03T09:18:29.170 D t0 view_helpers.cc:437 example result:
2021-12-03T09:18:29.170 I t0 command_executor.cc:137 Executing SQL: DETACH DATABASE customers
2021-12-03T09:18:29.170 E t0 sql_util.cc:586 statement aborts at 4: [DETACH DATABASE customers] no such database: customers
2021-12-03T09:18:29.170 E t0 command_executor.cc:298 sqlite3_step error code: 1
2021-12-03T09:18:29.170 D t0 view_helpers.cc:436 example: DETACH DATABASE customers
2021-12-03T09:18:29.170 D t0 view_helpers.cc:437 example result:
2021-12-03T09:18:29.170 I t0 command_executor.cc:137 Executing SQL: SELECT CASE 1 WHEN 0 THEN 'zero' WHEN 1 THEN 'one' END
2021-12-03T09:18:29.170 D t0 view_helpers.cc:436 example: SELECT CASE 1 WHEN 0 THEN 'zero' WHEN 1 THEN 'one' END
2021-12-03T09:18:29.170 D t0 view_helpers.cc:437 example result: one
2021-12-03T09:18:29.170 I t0 command_executor.cc:137 Executing SQL: SELECT CASE 1 WHEN 0 THEN 'zero' WHEN 1 THEN 'one' END
2021-12-03T09:18:29.170 D t0 view_helpers.cc:436 example: SELECT CASE 1 WHEN 0 THEN 'zero' WHEN 1 THEN 'one' END
2021-12-03T09:18:29.170 D t0 view_helpers.cc:437 example result: one
2021-12-03T09:18:29.170 I t0 command_executor.cc:137 Executing SQL: SELECT 'foobar.log' GLOB '*.log'
2021-12-03T09:18:29.170 D t0 view_helpers.cc:436 example: SELECT 'foobar.log' GLOB '*.log'
2021-12-03T09:18:29.170 D t0 view_helpers.cc:437 example result: 1
2021-12-03T09:18:29.170 I t0 command_executor.cc:137 Executing SQL: SELECT 'Hello, World!' LIKE 'Hello, %!'
2021-12-03T09:18:29.170 D t0 view_helpers.cc:436 example: SELECT 'Hello, World!' LIKE 'Hello, %!'
2021-12-03T09:18:29.170 D t0 view_helpers.cc:437 example result: 1
2021-12-03T09:18:29.170 I t0 command_executor.cc:137 Executing SQL: SELECT 'file-23' REGEXP 'file-\d+'
2021-12-03T09:18:29.170 D t0 view_helpers.cc:436 example: SELECT 'file-23' REGEXP 'file-\d+'
2021-12-03T09:18:29.170 D t0 view_helpers.cc:437 example result: 1
2021-12-03T09:18:29.170 I t0 command_executor.cc:137 Executing SQL: SELECT ('a2' < 'a10'), ('a2' < 'a10' COLLATE naturalnocase)
2021-12-03T09:18:29.170 D t0 view_helpers.cc:436 example: SELECT ('a2' < 'a10'), ('a2' < 'a10' COLLATE naturalnocase)
2021-12-03T09:18:29.170 D t0 view_helpers.cc:437 example result: ('a2' < 'a10') ('a2' < 'a10' COLLATE naturalnocase)
             0                                    1
2021-12-03T09:18:29.170 I t0 command_executor.cc:137 Executing SQL: SELECT 3 BETWEEN 5 AND 10
2021-12-03T09:18:29.170 D t0 view_helpers.cc:436 example: SELECT 3 BETWEEN 5 AND 10
2021-12-03T09:18:29.170 D t0 view_helpers.cc:437 example result: 0
2021-12-03T09:18:29.170 I t0 command_executor.cc:137 Executing SQL: SELECT 10 BETWEEN 5 AND 10
2021-12-03T09:18:29.170 D t0 view_helpers.cc:436 example: SELECT 10 BETWEEN 5 AND 10
2021-12-03T09:18:29.171 D t0 view_helpers.cc:437 example result: 1
2021-12-03T09:18:29.171 I t0 command_executor.cc:137 Executing SQL: SELECT * FROM syslog_log
2021-12-03T09:18:29.171 I t0 log_vtab_impl.cc:847 (0x7f467066eca0) best index called: nConstraint=0
2021-12-03T09:18:29.171 I t0 log_vtab_impl.cc:797 (0x7f467066eca0) filter called: 0
2021-12-03T09:18:29.171 D t0 view_helpers.cc:436 example: SELECT * FROM syslog_log
2021-12-03T09:18:29.171 D t0 view_helpers.cc:437 example result:
2021-12-03T09:18:29.171 I t0 command_executor.cc:137 Executing SQL: SELECT 'foobar.log' GLOB '*.log'
2021-12-03T09:18:29.171 D t0 view_helpers.cc:436 example: SELECT 'foobar.log' GLOB '*.log'
2021-12-03T09:18:29.171 D t0 view_helpers.cc:437 example result: 1
2021-12-03T09:18:29.171 I t0 command_executor.cc:137 Executing SQL: SELECT * FROM syslog_log
2021-12-03T09:18:29.171 I t0 log_vtab_impl.cc:847 (0x7f467066eca0) best index called: nConstraint=0
2021-12-03T09:18:29.171 I t0 log_vtab_impl.cc:797 (0x7f467066eca0) filter called: 0
2021-12-03T09:18:29.171 D t0 view_helpers.cc:436 example: SELECT * FROM syslog_log
2021-12-03T09:18:29.171 D t0 view_helpers.cc:437 example result:
2021-12-03T09:18:29.171 I t0 command_executor.cc:137 Executing SQL: INSERT INTO environ VALUES ('MSG', 'HELLO, WORLD!')
2021-12-03T09:18:29.171 D t0 view_helpers.cc:436 example: INSERT INTO environ VALUES ('MSG', 'HELLO, WORLD!')
2021-12-03T09:18:29.171 D t0 view_helpers.cc:437 example result:
2021-12-03T09:18:29.171 I t0 command_executor.cc:137 Executing SQL: INSERT INTO environ VALUES ('MSG', 'HELLO, WORLD!')
2021-12-03T09:18:29.171 E t0 sql_util.cc:586 statement aborts at 5: [INSERT INTO environ VALUES ('MSG', 'HELLO, WORLD!')] An environment variable with the name 'MSG' already exists
2021-12-03T09:18:29.171 E t0 command_executor.cc:298 sqlite3_step error code: 4
2021-12-03T09:18:29.171 D t0 view_helpers.cc:436 example: INSERT INTO environ VALUES ('MSG', 'HELLO, WORLD!')
2021-12-03T09:18:29.171 D t0 view_helpers.cc:437 example result:
2021-12-03T09:18:29.171 I t0 command_executor.cc:137 Executing SQL: SELECT 'Hello, World!' LIKE 'Hello, %!'
2021-12-03T09:18:29.171 D t0 view_helpers.cc:436 example: SELECT 'Hello, World!' LIKE 'Hello, %!'
2021-12-03T09:18:29.171 D t0 view_helpers.cc:437 example result: 1
2021-12-03T09:18:29.171 I t0 command_executor.cc:137 Executing SQL: SELECT * FROM syslog_log
2021-12-03T09:18:29.171 I t0 log_vtab_impl.cc:847 (0x7f467066eca0) best index called: nConstraint=0
2021-12-03T09:18:29.171 I t0 log_vtab_impl.cc:797 (0x7f467066eca0) filter called: 0
2021-12-03T09:18:29.171 D t0 view_helpers.cc:436 example: SELECT * FROM syslog_log
2021-12-03T09:18:29.171 D t0 view_helpers.cc:437 example result:
2021-12-03T09:18:29.171 I t0 command_executor.cc:137 Executing SQL: SELECT * FROM syslog_log
2021-12-03T09:18:29.171 I t0 log_vtab_impl.cc:847 (0x7f467066eca0) best index called: nConstraint=0
2021-12-03T09:18:29.171 I t0 log_vtab_impl.cc:797 (0x7f467066eca0) filter called: 0
2021-12-03T09:18:29.171 D t0 view_helpers.cc:436 example: SELECT * FROM syslog_log
2021-12-03T09:18:29.171 D t0 view_helpers.cc:437 example result:
2021-12-03T09:18:29.171 I t0 command_executor.cc:137 Executing SQL: SELECT 'file-23' REGEXP 'file-\d+'
2021-12-03T09:18:29.171 D t0 view_helpers.cc:436 example: SELECT 'file-23' REGEXP 'file-\d+'
2021-12-03T09:18:29.171 D t0 view_helpers.cc:437 example result: 1
2021-12-03T09:18:29.171 I t0 command_executor.cc:137 Executing SQL: SELECT * FROM syslog_log
2021-12-03T09:18:29.171 I t0 log_vtab_impl.cc:847 (0x7f467066eca0) best index called: nConstraint=0
2021-12-03T09:18:29.171 I t0 log_vtab_impl.cc:797 (0x7f467066eca0) filter called: 0
2021-12-03T09:18:29.171 D t0 view_helpers.cc:436 example: SELECT * FROM syslog_log
2021-12-03T09:18:29.171 D t0 view_helpers.cc:437 example result:
2021-12-03T09:18:29.171 I t0 command_executor.cc:137 Executing SQL: UPDATE syslog_log SET log_mark = 1 WHERE log_line = 40
2021-12-03T09:18:29.171 I t0 log_vtab_impl.cc:847 (0x7f467066eca0) best index called: nConstraint=1
2021-12-03T09:18:29.171 I t0 log_vtab_impl.cc:887 found index, passing 1 args
2021-12-03T09:18:29.171 I t0 log_vtab_impl.cc:797 (0x7f467066eca0) filter called: 1
2021-12-03T09:18:29.171 D t0 view_helpers.cc:436 example: UPDATE syslog_log SET log_mark = 1 WHERE log_line = 40
2021-12-03T09:18:29.171 D t0 view_helpers.cc:437 example result:
2021-12-03T09:18:29.171 I t0 command_executor.cc:137 Executing SQL: UPDATE syslog_log SET log_mark = 1 WHERE log_line = 40
2021-12-03T09:18:29.172 I t0 log_vtab_impl.cc:847 (0x7f467066eca0) best index called: nConstraint=1
2021-12-03T09:18:29.172 I t0 log_vtab_impl.cc:887 found index, passing 1 args
2021-12-03T09:18:29.172 I t0 log_vtab_impl.cc:797 (0x7f467066eca0) filter called: 1
2021-12-03T09:18:29.172 D t0 view_helpers.cc:436 example: UPDATE syslog_log SET log_mark = 1 WHERE log_line = 40
2021-12-03T09:18:29.172 D t0 view_helpers.cc:437 example result:
2021-12-03T09:18:29.172 I t0 command_executor.cc:137 Executing SQL: INSERT INTO environ VALUES ('MSG', 'HELLO, WORLD!')
2021-12-03T09:18:29.172 E t0 sql_util.cc:586 statement aborts at 5: [INSERT INTO environ VALUES ('MSG', 'HELLO, WORLD!')] An environment variable with the name 'MSG' already exists
2021-12-03T09:18:29.172 E t0 command_executor.cc:298 sqlite3_step error code: 4
2021-12-03T09:18:29.172 D t0 view_helpers.cc:436 example: INSERT INTO environ VALUES ('MSG', 'HELLO, WORLD!')
2021-12-03T09:18:29.172 D t0 view_helpers.cc:437 example result:
2021-12-03T09:18:29.172 I t0 command_executor.cc:137 Executing SQL: SELECT CASE 1 WHEN 0 THEN 'zero' WHEN 1 THEN 'one' END
2021-12-03T09:18:29.172 D t0 view_helpers.cc:436 example: SELECT CASE 1 WHEN 0 THEN 'zero' WHEN 1 THEN 'one' END
2021-12-03T09:18:29.172 D t0 view_helpers.cc:437 example result: one
2021-12-03T09:18:29.172 I t0 command_executor.cc:137 Executing SQL: SELECT * FROM syslog_log
2021-12-03T09:18:29.172 I t0 log_vtab_impl.cc:847 (0x7f467066eca0) best index called: nConstraint=0
2021-12-03T09:18:29.172 I t0 log_vtab_impl.cc:797 (0x7f467066eca0) filter called: 0
2021-12-03T09:18:29.172 D t0 view_helpers.cc:436 example: SELECT * FROM syslog_log
2021-12-03T09:18:29.172 D t0 view_helpers.cc:437 example result:
2021-12-03T09:18:29.172 I t0 command_executor.cc:137 Executing SQL: UPDATE syslog_log SET log_mark = 1 WHERE log_line = 40
2021-12-03T09:18:29.172 I t0 log_vtab_impl.cc:847 (0x7f467066eca0) best index called: nConstraint=1
2021-12-03T09:18:29.172 I t0 log_vtab_impl.cc:887 found index, passing 1 args
2021-12-03T09:18:29.172 I t0 log_vtab_impl.cc:797 (0x7f467066eca0) filter called: 1
2021-12-03T09:18:29.172 D t0 view_helpers.cc:436 example: UPDATE syslog_log SET log_mark = 1 WHERE log_line = 40
2021-12-03T09:18:29.172 D t0 view_helpers.cc:437 example result:
2021-12-03T09:18:29.172 I t0 command_executor.cc:137 Executing SQL: SELECT abs(-1)
2021-12-03T09:18:29.172 D t0 view_helpers.cc:436 example: SELECT abs(-1)
2021-12-03T09:18:29.172 D t0 view_helpers.cc:437 example result: 1
2021-12-03T09:18:29.172 I t0 command_executor.cc:137 Executing SQL: SELECT acos(0.2)
2021-12-03T09:18:29.172 D t0 view_helpers.cc:436 example: SELECT acos(0.2)
2021-12-03T09:18:29.172 D t0 view_helpers.cc:437 example result: 1.36943840600457
2021-12-03T09:18:29.172 I t0 command_executor.cc:137 Executing SQL: SELECT acosh(1.2)
2021-12-03T09:18:29.172 D t0 view_helpers.cc:436 example: SELECT acosh(1.2)
2021-12-03T09:18:29.172 D t0 view_helpers.cc:437 example result: 0.622362503714779
2021-12-03T09:18:29.172 I t0 command_executor.cc:137 Executing SQL: SELECT asin(0.2)
2021-12-03T09:18:29.172 D t0 view_helpers.cc:436 example: SELECT asin(0.2)
2021-12-03T09:18:29.172 D t0 view_helpers.cc:437 example result: 0.201357920790331
2021-12-03T09:18:29.172 I t0 command_executor.cc:137 Executing SQL: SELECT asinh(0.2)
2021-12-03T09:18:29.172 D t0 view_helpers.cc:436 example: SELECT asinh(0.2)
2021-12-03T09:18:29.172 D t0 view_helpers.cc:437 example result: 0.198690110349241
2021-12-03T09:18:29.172 I t0 command_executor.cc:137 Executing SQL: SELECT atan(0.2)
2021-12-03T09:18:29.172 D t0 view_helpers.cc:436 example: SELECT atan(0.2)
2021-12-03T09:18:29.172 D t0 view_helpers.cc:437 example result: 0.197395559849881
2021-12-03T09:18:29.172 I t0 command_executor.cc:137 Executing SQL: SELECT degrees(atan2(5, 5))
2021-12-03T09:18:29.172 D t0 view_helpers.cc:436 example: SELECT degrees(atan2(5, 5))
2021-12-03T09:18:29.172 D t0 view_helpers.cc:437 example result: 45.0
2021-12-03T09:18:29.172 I t0 command_executor.cc:137 Executing SQL: SELECT atanh(0.2)
2021-12-03T09:18:29.172 D t0 view_helpers.cc:436 example: SELECT atanh(0.2)
2021-12-03T09:18:29.172 D t0 view_helpers.cc:437 example result: 0.202732554054082
2021-12-03T09:18:29.172 I t0 command_executor.cc:137 Executing SQL: SELECT degrees(atn2(5, 5))
2021-12-03T09:18:29.172 D t0 view_helpers.cc:436 example: SELECT degrees(atn2(5, 5))
2021-12-03T09:18:29.172 D t0 view_helpers.cc:437 example result: 45.0
2021-12-03T09:18:29.172 I t0 command_executor.cc:137 Executing SQL: SELECT avg(ex_duration) FROM lnav_example_log
2021-12-03T09:18:29.172 D t0 view_helpers.cc:436 example: SELECT avg(ex_duration) FROM lnav_example_log
2021-12-03T09:18:29.172 D t0 view_helpers.cc:437 example result: 4.25
2021-12-03T09:18:29.172 I t0 command_executor.cc:137 Executing SQL: SELECT ex_procname, avg(ex_duration) FROM lnav_example_log GROUP BY ex_procname
2021-12-03T09:18:29.173 D t0 view_helpers.cc:436 example: SELECT ex_procname, avg(ex_duration) FROM lnav_example_log GROUP BY ex_procname
2021-12-03T09:18:29.173 D t0 view_helpers.cc:437 example result: ex_procname avg(ex_duration)
gw                       5.0
hw                       2.0
2021-12-03T09:18:29.173 I t0 command_executor.cc:137 Executing SQL: SELECT basename('foobar')
2021-12-03T09:18:29.173 D t0 view_helpers.cc:436 example: SELECT basename('foobar')
2021-12-03T09:18:29.173 D t0 view_helpers.cc:437 example result: foobar
2021-12-03T09:18:29.173 I t0 command_executor.cc:137 Executing SQL: SELECT basename('foo/bar')
2021-12-03T09:18:29.173 D t0 view_helpers.cc:436 example: SELECT basename('foo/bar')
2021-12-03T09:18:29.173 D t0 view_helpers.cc:437 example result: bar
2021-12-03T09:18:29.173 I t0 command_executor.cc:137 Executing SQL: SELECT basename('foo/bar/')
2021-12-03T09:18:29.173 D t0 view_helpers.cc:436 example: SELECT basename('foo/bar/')
2021-12-03T09:18:29.173 D t0 view_helpers.cc:437 example result: bar
2021-12-03T09:18:29.173 I t0 command_executor.cc:137 Executing SQL: SELECT basename('')
2021-12-03T09:18:29.173 D t0 view_helpers.cc:436 example: SELECT basename('')
2021-12-03T09:18:29.173 D t0 view_helpers.cc:437 example result: .
2021-12-03T09:18:29.173 I t0 command_executor.cc:137 Executing SQL: SELECT basename('foo\bar')
2021-12-03T09:18:29.173 D t0 view_helpers.cc:436 example: SELECT basename('foo\bar')
2021-12-03T09:18:29.173 D t0 view_helpers.cc:437 example result: bar
2021-12-03T09:18:29.173 I t0 command_executor.cc:137 Executing SQL: SELECT basename('/')
2021-12-03T09:18:29.173 D t0 view_helpers.cc:436 example: SELECT basename('/')
2021-12-03T09:18:29.173 D t0 view_helpers.cc:437 example result: /
2021-12-03T09:18:29.173 I t0 command_executor.cc:137 Executing SQL: SELECT ceil(1.23)
2021-12-03T09:18:29.173 D t0 view_helpers.cc:436 example: SELECT ceil(1.23)
2021-12-03T09:18:29.173 D t0 view_helpers.cc:437 example result: 2
2021-12-03T09:18:29.173 I t0 command_executor.cc:137 Executing SQL: SELECT char(0x48, 0x49)
2021-12-03T09:18:29.173 D t0 view_helpers.cc:436 example: SELECT char(0x48, 0x49)
2021-12-03T09:18:29.173 D t0 view_helpers.cc:437 example result: HI
2021-12-03T09:18:29.173 I t0 command_executor.cc:137 Executing SQL: SELECT charindex('abc', 'abcabc', 2)
2021-12-03T09:18:29.173 D t0 view_helpers.cc:436 example: SELECT charindex('abc', 'abcabc', 2)
2021-12-03T09:18:29.173 D t0 view_helpers.cc:437 example result: 4
2021-12-03T09:18:29.173 I t0 command_executor.cc:137 Executing SQL: SELECT charindex('abc', 'abcdef', 2)
2021-12-03T09:18:29.173 D t0 view_helpers.cc:436 example: SELECT charindex('abc', 'abcdef', 2)
2021-12-03T09:18:29.173 D t0 view_helpers.cc:437 example result: 0
2021-12-03T09:18:29.173 I t0 command_executor.cc:137 Executing SQL: SELECT coalesce(null, 0, null)
2021-12-03T09:18:29.173 D t0 view_helpers.cc:436 example: SELECT coalesce(null, 0, null)
2021-12-03T09:18:29.173 D t0 view_helpers.cc:437 example result: 0
2021-12-03T09:18:29.173 I t0 command_executor.cc:137 Executing SQL: SELECT count(*) FROM lnav_example_log
2021-12-03T09:18:29.173 D t0 view_helpers.cc:436 example: SELECT count(*) FROM lnav_example_log
2021-12-03T09:18:29.173 D t0 view_helpers.cc:437 example result: 4
2021-12-03T09:18:29.173 I t0 command_executor.cc:137 Executing SQL: SELECT count(log_part) FROM lnav_example_log
2021-12-03T09:18:29.173 D t0 view_helpers.cc:436 example: SELECT count(log_part) FROM lnav_example_log
2021-12-03T09:18:29.173 D t0 view_helpers.cc:437 example result: 2
2021-12-03T09:18:29.173 I t0 command_executor.cc:137 Executing SQL: SELECT date('2017-01-02T03:04:05')
2021-12-03T09:18:29.173 D t0 view_helpers.cc:436 example: SELECT date('2017-01-02T03:04:05')
2021-12-03T09:18:29.173 D t0 view_helpers.cc:437 example result: 2017-01-02
2021-12-03T09:18:29.173 I t0 command_executor.cc:137 Executing SQL: SELECT date('2017-01-02T03:04:05', '+1 day')
2021-12-03T09:18:29.173 D t0 view_helpers.cc:436 example: SELECT date('2017-01-02T03:04:05', '+1 day')
2021-12-03T09:18:29.173 D t0 view_helpers.cc:437 example result: 2017-01-03
2021-12-03T09:18:29.173 I t0 command_executor.cc:137 Executing SQL: SELECT date(1491341842, 'unixepoch')
2021-12-03T09:18:29.173 D t0 view_helpers.cc:436 example: SELECT date(1491341842, 'unixepoch')
2021-12-03T09:18:29.173 D t0 view_helpers.cc:437 example result: 2017-04-04
2021-12-03T09:18:29.173 I t0 command_executor.cc:137 Executing SQL: SELECT datetime('2017-01-02T03:04:05')
2021-12-03T09:18:29.173 D t0 view_helpers.cc:436 example: SELECT datetime('2017-01-02T03:04:05')
2021-12-03T09:18:29.173 D t0 view_helpers.cc:437 example result: 2017-01-02 03:04:05
2021-12-03T09:18:29.173 I t0 command_executor.cc:137 Executing SQL: SELECT datetime('2017-01-02T03:04:05', '+1 minute')
2021-12-03T09:18:29.173 D t0 view_helpers.cc:436 example: SELECT datetime('2017-01-02T03:04:05', '+1 minute')
2021-12-03T09:18:29.173 D t0 view_helpers.cc:437 example result: 2017-01-02 03:05:05
2021-12-03T09:18:29.173 I t0 command_executor.cc:137 Executing SQL: SELECT datetime(1491341842, 'unixepoch')
2021-12-03T09:18:29.173 D t0 view_helpers.cc:436 example: SELECT datetime(1491341842, 'unixepoch')
2021-12-03T09:18:29.173 D t0 view_helpers.cc:437 example result: 2017-04-04 21:37:22
2021-12-03T09:18:29.173 I t0 command_executor.cc:137 Executing SQL: SELECT degrees(pi())
2021-12-03T09:18:29.173 D t0 view_helpers.cc:436 example: SELECT degrees(pi())
2021-12-03T09:18:29.173 D t0 view_helpers.cc:437 example result: 180.0
2021-12-03T09:18:29.173 I t0 command_executor.cc:137 Executing SQL: SELECT dirname('foo/bar')
2021-12-03T09:18:29.173 D t0 view_helpers.cc:436 example: SELECT dirname('foo/bar')
2021-12-03T09:18:29.173 D t0 view_helpers.cc:437 example result: foo
2021-12-03T09:18:29.174 I t0 command_executor.cc:137 Executing SQL: SELECT dirname('/foo/bar')
2021-12-03T09:18:29.174 D t0 view_helpers.cc:436 example: SELECT dirname('/foo/bar')
2021-12-03T09:18:29.174 D t0 view_helpers.cc:437 example result: /foo
2021-12-03T09:18:29.174 I t0 command_executor.cc:137 Executing SQL: SELECT dirname('/bar')
2021-12-03T09:18:29.174 D t0 view_helpers.cc:436 example: SELECT dirname('/bar')
2021-12-03T09:18:29.174 D t0 view_helpers.cc:437 example result: /
2021-12-03T09:18:29.174 I t0 command_executor.cc:137 Executing SQL: SELECT dirname('foo\bar')
2021-12-03T09:18:29.174 D t0 view_helpers.cc:436 example: SELECT dirname('foo\bar')
2021-12-03T09:18:29.174 D t0 view_helpers.cc:437 example result: foo
2021-12-03T09:18:29.174 I t0 command_executor.cc:137 Executing SQL: SELECT dirname('')
2021-12-03T09:18:29.174 D t0 view_helpers.cc:436 example: SELECT dirname('')
2021-12-03T09:18:29.174 D t0 view_helpers.cc:437 example result: .
2021-12-03T09:18:29.174 I t0 command_executor.cc:137 Executing SQL: SELECT endswith('notbad.jpg', '.jpg')
2021-12-03T09:18:29.174 D t0 view_helpers.cc:436 example: SELECT endswith('notbad.jpg', '.jpg')
2021-12-03T09:18:29.174 D t0 view_helpers.cc:437 example result: 1
2021-12-03T09:18:29.174 I t0 command_executor.cc:137 Executing SQL: SELECT endswith('notbad.png', '.jpg')
2021-12-03T09:18:29.174 D t0 view_helpers.cc:436 example: SELECT endswith('notbad.png', '.jpg')
2021-12-03T09:18:29.174 D t0 view_helpers.cc:437 example result: 0
2021-12-03T09:18:29.174 I t0 command_executor.cc:137 Executing SQL: SELECT exp(2)
2021-12-03T09:18:29.174 D t0 view_helpers.cc:436 example: SELECT exp(2)
2021-12-03T09:18:29.174 D t0 view_helpers.cc:437 example result: 7.38905609893065
2021-12-03T09:18:29.174 I t0 command_executor.cc:137 Executing SQL: SELECT extract('foo=1 bar=2 name="Rolo Tomassi"')
2021-12-03T09:18:29.174 D t0 view_helpers.cc:436 example: SELECT extract('foo=1 bar=2 name="Rolo Tomassi"')
2021-12-03T09:18:29.174 D t0 view_helpers.cc:437 example result: {"foo":1,"bar":2,"name":"Rolo Tomassi"}
2021-12-03T09:18:29.174 I t0 command_executor.cc:137 Executing SQL: SELECT extract('1.0 abc 2.0')
2021-12-03T09:18:29.174 D t0 view_helpers.cc:436 example: SELECT extract('1.0 abc 2.0')
2021-12-03T09:18:29.174 D t0 view_helpers.cc:437 example result: {"col_0":1.0,"col_1":2.0}
2021-12-03T09:18:29.174 I t0 command_executor.cc:137 Executing SQL: SELECT floor(1.23)
2021-12-03T09:18:29.174 D t0 view_helpers.cc:436 example: SELECT floor(1.23)
2021-12-03T09:18:29.174 D t0 view_helpers.cc:437 example result: 1
2021-12-03T09:18:29.174 I t0 command_executor.cc:137 Executing SQL: SELECT value FROM generate_series(10, 14)
2021-12-03T09:18:29.174 D t0 view_helpers.cc:436 example: SELECT value FROM generate_series(10, 14)
2021-12-03T09:18:29.174 D t0 view_helpers.cc:437 example result: value
   10
   11
   12
   13
   14
2021-12-03T09:18:29.174 I t0 command_executor.cc:137 Executing SQL: SELECT value FROM generate_series(10, 14, 2)
2021-12-03T09:18:29.174 D t0 view_helpers.cc:436 example: SELECT value FROM generate_series(10, 14, 2)
2021-12-03T09:18:29.174 D t0 view_helpers.cc:437 example result: value
   10
   12
   14
2021-12-03T09:18:29.174 I t0 command_executor.cc:137 Executing SQL: SELECT value FROM generate_series(1, 5, -1)
2021-12-03T09:18:29.174 D t0 view_helpers.cc:436 example: SELECT value FROM generate_series(1, 5, -1)
2021-12-03T09:18:29.174 D t0 view_helpers.cc:437 example result: value
    5
    4
    3
    2
    1
2021-12-03T09:18:29.174 I t0 command_executor.cc:137 Executing SQL: SELECT gethostbyaddr('127.0.0.1')
2021-12-03T09:18:29.174 D t0 view_helpers.cc:436 example: SELECT gethostbyaddr('127.0.0.1')
2021-12-03T09:18:29.174 D t0 view_helpers.cc:437 example result: localhost
2021-12-03T09:18:29.174 I t0 command_executor.cc:137 Executing SQL: SELECT gethostbyname('localhost')
2021-12-03T09:18:29.174 D t0 view_helpers.cc:436 example: SELECT gethostbyname('localhost')
2021-12-03T09:18:29.174 D t0 view_helpers.cc:437 example result: 127.0.0.1
2021-12-03T09:18:29.174 I t0 command_executor.cc:137 Executing SQL: SELECT glob('a*', 'abc')
2021-12-03T09:18:29.174 D t0 view_helpers.cc:436 example: SELECT glob('a*', 'abc')
2021-12-03T09:18:29.174 D t0 view_helpers.cc:437 example result: 1
2021-12-03T09:18:29.175 I t0 command_executor.cc:137 Executing SQL: SELECT group_concat(ex_procname) FROM lnav_example_log
2021-12-03T09:18:29.175 D t0 view_helpers.cc:436 example: SELECT group_concat(ex_procname) FROM lnav_example_log
2021-12-03T09:18:29.175 D t0 view_helpers.cc:437 example result: hw,gw,gw,gw
2021-12-03T09:18:29.175 I t0 command_executor.cc:137 Executing SQL: SELECT group_concat(ex_procname, ', ') FROM lnav_example_log
2021-12-03T09:18:29.175 D t0 view_helpers.cc:436 example: SELECT group_concat(ex_procname, ', ') FROM lnav_example_log
2021-12-03T09:18:29.175 D t0 view_helpers.cc:437 example result: hw, gw, gw, gw
2021-12-03T09:18:29.175 I t0 command_executor.cc:137 Executing SQL: SELECT group_concat(DISTINCT ex_procname) FROM lnav_example_log
2021-12-03T09:18:29.175 D t0 view_helpers.cc:436 example: SELECT group_concat(DISTINCT ex_procname) FROM lnav_example_log
2021-12-03T09:18:29.175 D t0 view_helpers.cc:437 example result: hw,gw
2021-12-03T09:18:29.175 I t0 command_executor.cc:137 Executing SQL: SELECT group_spooky_hash(column1) FROM (VALUES ('abc'), ('123'))
2021-12-03T09:18:29.175 D t0 view_helpers.cc:436 example: SELECT group_spooky_hash(column1) FROM (VALUES ('abc'), ('123'))
2021-12-03T09:18:29.175 D t0 view_helpers.cc:437 example result: 4e7a190aead058cb123c94290f29c34a
2021-12-03T09:18:29.175 I t0 command_executor.cc:137 Executing SQL: SELECT hex('abc')
2021-12-03T09:18:29.175 D t0 view_helpers.cc:436 example: SELECT hex('abc')
2021-12-03T09:18:29.175 D t0 view_helpers.cc:437 example result: 616263
2021-12-03T09:18:29.175 I t0 command_executor.cc:137 Executing SQL: SELECT humanize_file_size(10 * 1024 * 1024)
2021-12-03T09:18:29.175 D t0 view_helpers.cc:436 example: SELECT humanize_file_size(10 * 1024 * 1024)
2021-12-03T09:18:29.175 D t0 view_helpers.cc:437 example result: 10.0MB
2021-12-03T09:18:29.175 I t0 command_executor.cc:137 Executing SQL: SELECT ifnull(null, 0)
2021-12-03T09:18:29.175 D t0 view_helpers.cc:436 example: SELECT ifnull(null, 0)
2021-12-03T09:18:29.175 D t0 view_helpers.cc:437 example result: 0
2021-12-03T09:18:29.175 I t0 command_executor.cc:137 Executing SQL: SELECT instr('abc', 'b')
2021-12-03T09:18:29.175 D t0 view_helpers.cc:436 example: SELECT instr('abc', 'b')
2021-12-03T09:18:29.175 D t0 view_helpers.cc:437 example result: 2
2021-12-03T09:18:29.175 I t0 command_executor.cc:137 Executing SQL: SELECT jget('1', '')
2021-12-03T09:18:29.175 D t0 view_helpers.cc:436 example: SELECT jget('1', '')
2021-12-03T09:18:29.175 D t0 view_helpers.cc:437 example result: 1
2021-12-03T09:18:29.175 I t0 command_executor.cc:137 Executing SQL: SELECT jget('{ "a": 1, "b": 2 }', '/b')
2021-12-03T09:18:29.175 D t0 view_helpers.cc:436 example: SELECT jget('{ "a": 1, "b": 2 }', '/b')
2021-12-03T09:18:29.175 D t0 view_helpers.cc:437 example result: 2
2021-12-03T09:18:29.175 I t0 command_executor.cc:137 Executing SQL: SELECT jget(null, '/msg', 'Hello')
2021-12-03T09:18:29.175 D t0 view_helpers.cc:436 example: SELECT jget(null, '/msg', 'Hello')
2021-12-03T09:18:29.175 D t0 view_helpers.cc:437 example result: Hello
2021-12-03T09:18:29.175 I t0 command_executor.cc:137 Executing SQL: SELECT joinpath('foo', 'bar')
2021-12-03T09:18:29.175 D t0 view_helpers.cc:436 example: SELECT joinpath('foo', 'bar')
2021-12-03T09:18:29.175 D t0 view_helpers.cc:437 example result: foo/bar
2021-12-03T09:18:29.175 I t0 command_executor.cc:137 Executing SQL: SELECT joinpath('', 'foo', 'bar')
2021-12-03T09:18:29.175 D t0 view_helpers.cc:436 example: SELECT joinpath('', 'foo', 'bar')
2021-12-03T09:18:29.175 D t0 view_helpers.cc:437 example result: foo/bar
2021-12-03T09:18:29.175 I t0 command_executor.cc:137 Executing SQL: SELECT joinpath('/', 'foo', 'bar')
2021-12-03T09:18:29.175 D t0 view_helpers.cc:436 example: SELECT joinpath('/', 'foo', 'bar')
2021-12-03T09:18:29.175 D t0 view_helpers.cc:437 example result: /foo/bar
2021-12-03T09:18:29.175 I t0 command_executor.cc:137 Executing SQL: SELECT joinpath('/', 'foo', '/bar')
2021-12-03T09:18:29.175 D t0 view_helpers.cc:436 example: SELECT joinpath('/', 'foo', '/bar')
2021-12-03T09:18:29.175 D t0 view_helpers.cc:437 example result: /bar
2021-12-03T09:18:29.175 I t0 command_executor.cc:137 Executing SQL: SELECT json_concat(NULL, 4)
2021-12-03T09:18:29.175 D t0 view_helpers.cc:436 example: SELECT json_concat(NULL, 4)
2021-12-03T09:18:29.175 D t0 view_helpers.cc:437 example result: [4]
2021-12-03T09:18:29.175 I t0 command_executor.cc:137 Executing SQL: SELECT json_concat('[1, 2, 3]', 4, 5)
2021-12-03T09:18:29.175 D t0 view_helpers.cc:436 example: SELECT json_concat('[1, 2, 3]', 4, 5)
2021-12-03T09:18:29.175 D t0 view_helpers.cc:437 example result: [1,2,3,4,5]
2021-12-03T09:18:29.175 I t0 command_executor.cc:137 Executing SQL: SELECT json_concat('[1, 2, 3]', json('[4, 5]'))
2021-12-03T09:18:29.175 D t0 view_helpers.cc:436 example: SELECT json_concat('[1, 2, 3]', json('[4, 5]'))
2021-12-03T09:18:29.176 D t0 view_helpers.cc:437 example result: [1,2,3,4,5]
2021-12-03T09:18:29.176 I t0 command_executor.cc:137 Executing SQL: SELECT json_contains('[1, 2, 3]', 4)
2021-12-03T09:18:29.176 D t0 view_helpers.cc:436 example: SELECT json_contains('[1, 2, 3]', 4)
2021-12-03T09:18:29.176 D t0 view_helpers.cc:437 example result: 0
2021-12-03T09:18:29.176 I t0 command_executor.cc:137 Executing SQL: SELECT json_contains('["abc", "def"]', 'def')
2021-12-03T09:18:29.176 D t0 view_helpers.cc:436 example: SELECT json_contains('["abc", "def"]', 'def')
2021-12-03T09:18:29.176 D t0 view_helpers.cc:437 example result: 1
2021-12-03T09:18:29.176 I t0 command_executor.cc:137 Executing SQL: SELECT json_group_array('one', 2, 3.4)
2021-12-03T09:18:29.176 D t0 view_helpers.cc:436 example: SELECT json_group_array('one', 2, 3.4)
2021-12-03T09:18:29.176 D t0 view_helpers.cc:437 example result: ["one",2,3.3999999999999999112]
2021-12-03T09:18:29.176 I t0 command_executor.cc:137 Executing SQL: SELECT json_group_array(column1) FROM (VALUES (1), (2), (3))
2021-12-03T09:18:29.176 D t0 view_helpers.cc:436 example: SELECT json_group_array(column1) FROM (VALUES (1), (2), (3))
2021-12-03T09:18:29.176 D t0 view_helpers.cc:437 example result: [1,2,3]
2021-12-03T09:18:29.176 I t0 command_executor.cc:137 Executing SQL: SELECT json_group_object('a', 1, 'b', 2)
2021-12-03T09:18:29.176 D t0 json-extension-functions.cc:539 arg type 3
2021-12-03T09:18:29.176 D t0 json-extension-functions.cc:539 arg type 3
2021-12-03T09:18:29.176 D t0 view_helpers.cc:436 example: SELECT json_group_object('a', 1, 'b', 2)
2021-12-03T09:18:29.176 D t0 view_helpers.cc:437 example result: {"a":1,"b":2}
2021-12-03T09:18:29.176 I t0 command_executor.cc:137 Executing SQL: SELECT json_group_object(column1, column2) FROM (VALUES ('a', 1), ('b', 2))
2021-12-03T09:18:29.176 D t0 view_helpers.cc:436 example: SELECT json_group_object(column1, column2) FROM (VALUES ('a', 1), ('b', 2))
2021-12-03T09:18:29.176 D t0 view_helpers.cc:437 example result: {"a":1,"b":2}
2021-12-03T09:18:29.176 I t0 command_executor.cc:137 Executing SQL: SELECT julianday('2017-01-02T03:04:05')
2021-12-03T09:18:29.176 D t0 view_helpers.cc:436 example: SELECT julianday('2017-01-02T03:04:05')
2021-12-03T09:18:29.176 D t0 view_helpers.cc:437 example result: 2457755.62783565
2021-12-03T09:18:29.176 I t0 command_executor.cc:137 Executing SQL: SELECT julianday('2017-01-02T03:04:05', '+1 minute')
2021-12-03T09:18:29.176 D t0 view_helpers.cc:436 example: SELECT julianday('2017-01-02T03:04:05', '+1 minute')
2021-12-03T09:18:29.176 D t0 view_helpers.cc:437 example result: 2457755.62853009
2021-12-03T09:18:29.176 I t0 command_executor.cc:137 Executing SQL: SELECT julianday(1491341842, 'unixepoch')
2021-12-03T09:18:29.176 D t0 view_helpers.cc:436 example: SELECT julianday(1491341842, 'unixepoch')
2021-12-03T09:18:29.176 D t0 view_helpers.cc:437 example result: 2457848.40094907
2021-12-03T09:18:29.176 I t0 command_executor.cc:137 Executing SQL: SELECT leftstr('abc', 1)
2021-12-03T09:18:29.176 D t0 view_helpers.cc:436 example: SELECT leftstr('abc', 1)
2021-12-03T09:18:29.176 D t0 view_helpers.cc:437 example result: a
2021-12-03T09:18:29.176 I t0 command_executor.cc:137 Executing SQL: SELECT leftstr('abc', 10)
2021-12-03T09:18:29.176 D t0 view_helpers.cc:436 example: SELECT leftstr('abc', 10)
2021-12-03T09:18:29.176 D t0 view_helpers.cc:437 example result: abc
2021-12-03T09:18:29.176 I t0 command_executor.cc:137 Executing SQL: SELECT length('abc')
2021-12-03T09:18:29.176 D t0 view_helpers.cc:436 example: SELECT length('abc')
2021-12-03T09:18:29.176 D t0 view_helpers.cc:437 example result: 3
2021-12-03T09:18:29.176 I t0 command_executor.cc:137 Executing SQL: SELECT like('%b%', 'aabcc')
2021-12-03T09:18:29.176 D t0 view_helpers.cc:436 example: SELECT like('%b%', 'aabcc')
2021-12-03T09:18:29.176 D t0 view_helpers.cc:437 example result: 1
2021-12-03T09:18:29.176 I t0 command_executor.cc:137 Executing SQL: SELECT like('%b:%', 'aab%', ':')
2021-12-03T09:18:29.176 D t0 view_helpers.cc:436 example: SELECT like('%b:%', 'aab%', ':')
2021-12-03T09:18:29.176 D t0 view_helpers.cc:437 example result: 1
2021-12-03T09:18:29.176 I t0 command_executor.cc:137 Executing SQL: SELECT log(8)
2021-12-03T09:18:29.176 D t0 view_helpers.cc:436 example: SELECT log(8)
2021-12-03T09:18:29.176 D t0 view_helpers.cc:437 example result: 2.07944154167984
2021-12-03T09:18:29.176 I t0 command_executor.cc:137 Executing SQL: SELECT log10(100)
2021-12-03T09:18:29.176 D t0 view_helpers.cc:436 example: SELECT log10(100)
2021-12-03T09:18:29.176 D t0 view_helpers.cc:437 example result: 2.0
2021-12-03T09:18:29.176 I t0 command_executor.cc:137 Executing SQL: SELECT logfmt2json('foo=1 bar=2 name="Rolo Tomassi"')
2021-12-03T09:18:29.176 D t0 view_helpers.cc:436 example: SELECT logfmt2json('foo=1 bar=2 name="Rolo Tomassi"')
2021-12-03T09:18:29.176 D t0 view_helpers.cc:437 example result: {"foo":1,"bar":2,"name":"Rolo Tomassi"}
2021-12-03T09:18:29.176 I t0 command_executor.cc:137 Executing SQL: SELECT lower('AbC')
2021-12-03T09:18:29.176 D t0 view_helpers.cc:436 example: SELECT lower('AbC')
2021-12-03T09:18:29.176 D t0 view_helpers.cc:437 example result: abc
2021-12-03T09:18:29.176 I t0 command_executor.cc:137 Executing SQL: SELECT ltrim('   abc')
2021-12-03T09:18:29.176 D t0 view_helpers.cc:436 example: SELECT ltrim('   abc')
2021-12-03T09:18:29.176 D t0 view_helpers.cc:437 example result: abc
2021-12-03T09:18:29.176 I t0 command_executor.cc:137 Executing SQL: SELECT ltrim('aaaabbbc', 'ab')
2021-12-03T09:18:29.176 D t0 view_helpers.cc:436 example: SELECT ltrim('aaaabbbc', 'ab')
2021-12-03T09:18:29.176 D t0 view_helpers.cc:437 example result: c
2021-12-03T09:18:29.177 I t0 command_executor.cc:137 Executing SQL: SELECT max(2, 1, 3)
2021-12-03T09:18:29.177 D t0 view_helpers.cc:436 example: SELECT max(2, 1, 3)
2021-12-03T09:18:29.177 D t0 view_helpers.cc:437 example result: 3
2021-12-03T09:18:29.177 I t0 command_executor.cc:137 Executing SQL: SELECT max(status) FROM http_status_codes
2021-12-03T09:18:29.177 D t0 view_helpers.cc:436 example: SELECT max(status) FROM http_status_codes
2021-12-03T09:18:29.177 D t0 view_helpers.cc:437 example result: 511
2021-12-03T09:18:29.177 I t0 command_executor.cc:137 Executing SQL: SELECT min(2, 1, 3)
2021-12-03T09:18:29.177 D t0 view_helpers.cc:436 example: SELECT min(2, 1, 3)
2021-12-03T09:18:29.177 D t0 view_helpers.cc:437 example result: 1
2021-12-03T09:18:29.177 I t0 command_executor.cc:137 Executing SQL: SELECT min(status) FROM http_status_codes
2021-12-03T09:18:29.177 D t0 view_helpers.cc:436 example: SELECT min(status) FROM http_status_codes
2021-12-03T09:18:29.177 D t0 view_helpers.cc:437 example result: 100
2021-12-03T09:18:29.177 I t0 command_executor.cc:137 Executing SQL: SELECT nullif(1, 1)
2021-12-03T09:18:29.177 D t0 view_helpers.cc:436 example: SELECT nullif(1, 1)
2021-12-03T09:18:29.177 D t0 view_helpers.cc:437 example result: <NULL>
2021-12-03T09:18:29.177 I t0 command_executor.cc:137 Executing SQL: SELECT nullif(1, 2)
2021-12-03T09:18:29.177 D t0 view_helpers.cc:436 example: SELECT nullif(1, 2)
2021-12-03T09:18:29.177 D t0 view_helpers.cc:437 example result: 1
2021-12-03T09:18:29.177 I t0 command_executor.cc:137 Executing SQL: SELECT padc('abc', 6) || 'def'
2021-12-03T09:18:29.177 D t0 view_helpers.cc:436 example: SELECT padc('abc', 6) || 'def'
2021-12-03T09:18:29.177 D t0 view_helpers.cc:437 example result:  abc  def
2021-12-03T09:18:29.177 I t0 command_executor.cc:137 Executing SQL: SELECT padc('abcdef', 8) || 'ghi'
2021-12-03T09:18:29.177 D t0 view_helpers.cc:436 example: SELECT padc('abcdef', 8) || 'ghi'
2021-12-03T09:18:29.177 D t0 view_helpers.cc:437 example result:  abcdef ghi
2021-12-03T09:18:29.177 I t0 command_executor.cc:137 Executing SQL: SELECT padl('abc', 6)
2021-12-03T09:18:29.177 D t0 view_helpers.cc:436 example: SELECT padl('abc', 6)
2021-12-03T09:18:29.177 D t0 view_helpers.cc:437 example result:    abc
2021-12-03T09:18:29.177 I t0 command_executor.cc:137 Executing SQL: SELECT padl('abcdef', 4)
2021-12-03T09:18:29.177 D t0 view_helpers.cc:436 example: SELECT padl('abcdef', 4)
2021-12-03T09:18:29.177 D t0 view_helpers.cc:437 example result: abcdef
2021-12-03T09:18:29.177 I t0 command_executor.cc:137 Executing SQL: SELECT padr('abc', 6) || 'def'
2021-12-03T09:18:29.177 D t0 view_helpers.cc:436 example: SELECT padr('abc', 6) || 'def'
2021-12-03T09:18:29.177 D t0 view_helpers.cc:437 example result: abc   def
2021-12-03T09:18:29.177 I t0 command_executor.cc:137 Executing SQL: SELECT padr('abcdef', 4) || 'ghi'
2021-12-03T09:18:29.177 D t0 view_helpers.cc:436 example: SELECT padr('abcdef', 4) || 'ghi'
2021-12-03T09:18:29.177 D t0 view_helpers.cc:437 example result: abcdefghi
2021-12-03T09:18:29.177 I t0 command_executor.cc:137 Executing SQL: SELECT pi()
2021-12-03T09:18:29.177 D t0 view_helpers.cc:436 example: SELECT pi()
2021-12-03T09:18:29.177 D t0 view_helpers.cc:437 example result: 3.14159265358979
2021-12-03T09:18:29.177 I t0 command_executor.cc:137 Executing SQL: SELECT power(2, 3)
2021-12-03T09:18:29.177 D t0 view_helpers.cc:436 example: SELECT power(2, 3)
2021-12-03T09:18:29.177 D t0 view_helpers.cc:437 example result: 8.0
2021-12-03T09:18:29.177 I t0 command_executor.cc:137 Executing SQL: SELECT printf('Hello, %s!', 'World')
2021-12-03T09:18:29.177 D t0 view_helpers.cc:436 example: SELECT printf('Hello, %s!', 'World')
2021-12-03T09:18:29.177 D t0 view_helpers.cc:437 example result: Hello, World!
2021-12-03T09:18:29.177 I t0 command_executor.cc:137 Executing SQL: SELECT printf('align: % 10s', 'small')
2021-12-03T09:18:29.177 D t0 view_helpers.cc:436 example: SELECT printf('align: % 10s', 'small')
2021-12-03T09:18:29.177 D t0 view_helpers.cc:437 example result: align:      small
2021-12-03T09:18:29.177 I t0 command_executor.cc:137 Executing SQL: SELECT printf('value: %05d', 11)
2021-12-03T09:18:29.177 D t0 view_helpers.cc:436 example: SELECT printf('value: %05d', 11)
2021-12-03T09:18:29.177 D t0 view_helpers.cc:437 example result: value: 00011
2021-12-03T09:18:29.177 I t0 command_executor.cc:137 Executing SQL: SELECT proper('hello, world!')
2021-12-03T09:18:29.177 D t0 view_helpers.cc:436 example: SELECT proper('hello, world!')
2021-12-03T09:18:29.177 D t0 view_helpers.cc:437 example result: Hello, World!
2021-12-03T09:18:29.177 I t0 command_executor.cc:137 Executing SQL: SELECT quote('abc')
2021-12-03T09:18:29.177 D t0 view_helpers.cc:436 example: SELECT quote('abc')
2021-12-03T09:18:29.177 D t0 view_helpers.cc:437 example result: 'abc'
2021-12-03T09:18:29.177 I t0 command_executor.cc:137 Executing SQL: SELECT quote('abc''123')
2021-12-03T09:18:29.177 D t0 view_helpers.cc:436 example: SELECT quote('abc''123')
2021-12-03T09:18:29.177 D t0 view_helpers.cc:437 example result: 'abc''123'
2021-12-03T09:18:29.177 I t0 command_executor.cc:137 Executing SQL: SELECT radians(180)
2021-12-03T09:18:29.177 D t0 view_helpers.cc:436 example: SELECT radians(180)
2021-12-03T09:18:29.177 D t0 view_helpers.cc:437 example result: 3.14159265358979
2021-12-03T09:18:29.177 I t0 command_executor.cc:137 Executing SQL: SELECT * FROM regexp_capture('a=1; b=2', '(\w+)=(\d+)')
2021-12-03T09:18:29.178 D t0 regexp_vtab.cc:242 matched 1
2021-12-03T09:18:29.178 D t0 view_helpers.cc:436 example: SELECT * FROM regexp_capture('a=1; b=2', '(\w+)=(\d+)')
2021-12-03T09:18:29.178 D t0 view_helpers.cc:437 example result: match_index capture_index capture_name capture_count range_start range_stop content
          0             0 <NULL>                   3           1          4 a=1
          0             1                          3           1          2 a
          0             2                          3           3          4 1
          1             0 <NULL>                   3           6          9 b=2
          1             1                          3           6          7 b
          1             2                          3           8          9 2
2021-12-03T09:18:29.178 I t0 command_executor.cc:137 Executing SQL: SELECT regexp_match('(\d+)', '123')
2021-12-03T09:18:29.178 D t0 view_helpers.cc:436 example: SELECT regexp_match('(\d+)', '123')
2021-12-03T09:18:29.178 D t0 view_helpers.cc:437 example result: 123
2021-12-03T09:18:29.178 I t0 command_executor.cc:137 Executing SQL: SELECT regexp_match('(\d+) (\w+)', '123 four')
2021-12-03T09:18:29.178 D t0 column_namer.cc:90 column name already exists: col
2021-12-03T09:18:29.178 D t0 view_helpers.cc:436 example: SELECT regexp_match('(\d+) (\w+)', '123 four')
2021-12-03T09:18:29.178 D t0 view_helpers.cc:437 example result: {"col_0":123,"col_1":"four"}
2021-12-03T09:18:29.178 I t0 command_executor.cc:137 Executing SQL: SELECT regexp_match('(?<num>\d+) (?<str>\w+)', '123 four')
2021-12-03T09:18:29.178 D t0 view_helpers.cc:436 example: SELECT regexp_match('(?<num>\d+) (?<str>\w+)', '123 four')
2021-12-03T09:18:29.178 D t0 view_helpers.cc:437 example result: {"num":123,"str":"four"}
2021-12-03T09:18:29.178 I t0 command_executor.cc:137 Executing SQL: SELECT regexp_replace('Hello, World!', '^(\w+)', 'Goodbye')
2021-12-03T09:18:29.178 D t0 view_helpers.cc:436 example: SELECT regexp_replace('Hello, World!', '^(\w+)', 'Goodbye')
2021-12-03T09:18:29.178 D t0 view_helpers.cc:437 example result: Goodbye, World!
2021-12-03T09:18:29.178 I t0 command_executor.cc:137 Executing SQL: SELECT regexp_replace('123 abc', '(\w+)', '<\1>')
2021-12-03T09:18:29.178 D t0 view_helpers.cc:436 example: SELECT regexp_replace('123 abc', '(\w+)', '<\1>')
2021-12-03T09:18:29.178 D t0 view_helpers.cc:437 example result: <123> <abc>
2021-12-03T09:18:29.178 I t0 command_executor.cc:137 Executing SQL: SELECT replace('abc', 'x', 'z')
2021-12-03T09:18:29.178 D t0 view_helpers.cc:436 example: SELECT replace('abc', 'x', 'z')
2021-12-03T09:18:29.178 D t0 view_helpers.cc:437 example result: abc
2021-12-03T09:18:29.178 I t0 command_executor.cc:137 Executing SQL: SELECT replace('abc', 'a', 'z')
2021-12-03T09:18:29.178 D t0 view_helpers.cc:436 example: SELECT replace('abc', 'a', 'z')
2021-12-03T09:18:29.178 D t0 view_helpers.cc:437 example result: zbc
2021-12-03T09:18:29.178 I t0 command_executor.cc:137 Executing SQL: SELECT replicate('abc', 3)
2021-12-03T09:18:29.178 D t0 view_helpers.cc:436 example: SELECT replicate('abc', 3)
2021-12-03T09:18:29.178 D t0 view_helpers.cc:437 example result: abcabcabc
2021-12-03T09:18:29.178 I t0 command_executor.cc:137 Executing SQL: SELECT reverse('abc')
2021-12-03T09:18:29.178 D t0 view_helpers.cc:436 example: SELECT reverse('abc')
2021-12-03T09:18:29.178 D t0 view_helpers.cc:437 example result: cba
2021-12-03T09:18:29.178 I t0 command_executor.cc:137 Executing SQL: SELECT rightstr('abc', 1)
2021-12-03T09:18:29.178 D t0 view_helpers.cc:436 example: SELECT rightstr('abc', 1)
2021-12-03T09:18:29.178 D t0 view_helpers.cc:437 example result: c
2021-12-03T09:18:29.178 I t0 command_executor.cc:137 Executing SQL: SELECT rightstr('abc', 10)
2021-12-03T09:18:29.178 D t0 view_helpers.cc:436 example: SELECT rightstr('abc', 10)
2021-12-03T09:18:29.178 D t0 view_helpers.cc:437 example result: abc
2021-12-03T09:18:29.178 I t0 command_executor.cc:137 Executing SQL: SELECT round(123.456)
2021-12-03T09:18:29.178 D t0 view_helpers.cc:436 example: SELECT round(123.456)
2021-12-03T09:18:29.178 D t0 view_helpers.cc:437 example result: 123.0
2021-12-03T09:18:29.178 I t0 command_executor.cc:137 Executing SQL: SELECT round(123.456, 1)
2021-12-03T09:18:29.179 D t0 view_helpers.cc:436 example: SELECT round(123.456, 1)
2021-12-03T09:18:29.179 D t0 view_helpers.cc:437 example result: 123.5
2021-12-03T09:18:29.179 I t0 command_executor.cc:137 Executing SQL: SELECT round(123.456, 5)
2021-12-03T09:18:29.179 D t0 view_helpers.cc:436 example: SELECT round(123.456, 5)
2021-12-03T09:18:29.179 D t0 view_helpers.cc:437 example result: 123.456
2021-12-03T09:18:29.179 I t0 command_executor.cc:137 Executing SQL: SELECT row_number() OVER (PARTITION BY ex_procname ORDER BY log_line) AS msg_num, ex_procname, log_body FROM lnav_example_log
2021-12-03T09:18:29.179 D t0 view_helpers.cc:436 example: SELECT row_number() OVER (PARTITION BY ex_procname ORDER BY log_line) AS msg_num, ex_procname, log_body FROM lnav_example_log
2021-12-03T09:18:29.179 D t0 view_helpers.cc:437 example result: msg_num ex_procname    log_body
      1 gw          Goodbye, World!
      2 gw          Goodbye, World!
      3 gw          Goodbye, World!
      1 hw          Hello, World!
2021-12-03T09:18:29.179 I t0 command_executor.cc:137 Executing SQL: SELECT rtrim('abc   ')
2021-12-03T09:18:29.179 D t0 view_helpers.cc:436 example: SELECT rtrim('abc   ')
2021-12-03T09:18:29.179 D t0 view_helpers.cc:437 example result: abc
2021-12-03T09:18:29.179 I t0 command_executor.cc:137 Executing SQL: SELECT rtrim('abbbbcccc', 'bc')
2021-12-03T09:18:29.179 D t0 view_helpers.cc:436 example: SELECT rtrim('abbbbcccc', 'bc')
2021-12-03T09:18:29.179 D t0 view_helpers.cc:437 example result: a
2021-12-03T09:18:29.179 I t0 command_executor.cc:137 Executing SQL: SELECT sign(10)
2021-12-03T09:18:29.179 D t0 view_helpers.cc:436 example: SELECT sign(10)
2021-12-03T09:18:29.179 D t0 view_helpers.cc:437 example result: 1
2021-12-03T09:18:29.179 I t0 command_executor.cc:137 Executing SQL: SELECT sign(0)
2021-12-03T09:18:29.179 D t0 view_helpers.cc:436 example: SELECT sign(0)
2021-12-03T09:18:29.179 D t0 view_helpers.cc:437 example result: 0
2021-12-03T09:18:29.179 I t0 command_executor.cc:137 Executing SQL: SELECT sign(-10)
2021-12-03T09:18:29.179 D t0 view_helpers.cc:436 example: SELECT sign(-10)
2021-12-03T09:18:29.179 D t0 view_helpers.cc:437 example result: -1
2021-12-03T09:18:29.179 I t0 command_executor.cc:137 Executing SQL: SELECT sparkline(32, 128)
2021-12-03T09:18:29.179 D t0 view_helpers.cc:436 example: SELECT sparkline(32, 128)
2021-12-03T09:18:29.179 D t0 view_helpers.cc:437 example result: ▂
2021-12-03T09:18:29.179 I t0 command_executor.cc:137 Executing SQL: SELECT sparkline(value) FROM json_each('[0, 1, 2, 3, 4, 5, 6, 7, 8]')
2021-12-03T09:18:29.179 D t0 view_helpers.cc:436 example: SELECT sparkline(value) FROM json_each('[0, 1, 2, 3, 4, 5, 6, 7, 8]')
2021-12-03T09:18:29.179 D t0 view_helpers.cc:437 example result:  ▁▂▃▄▅▆▇█
2021-12-03T09:18:29.179 I t0 command_executor.cc:137 Executing SQL: SELECT spooky_hash('Hello, World!')
2021-12-03T09:18:29.179 D t0 view_helpers.cc:436 example: SELECT spooky_hash('Hello, World!')
2021-12-03T09:18:29.179 D t0 view_helpers.cc:437 example result: 0b1d52cc5427db4c6a9eed9d3e5700f4
2021-12-03T09:18:29.179 I t0 command_executor.cc:137 Executing SQL: SELECT spooky_hash('Hello, World!', NULL)
2021-12-03T09:18:29.180 D t0 view_helpers.cc:436 example: SELECT spooky_hash('Hello, World!', NULL)
2021-12-03T09:18:29.180 D t0 view_helpers.cc:437 example result: c96ee75d48e6ea444fee8af948f6da25
2021-12-03T09:18:29.180 I t0 command_executor.cc:137 Executing SQL: SELECT spooky_hash('Hello, World!', '')
2021-12-03T09:18:29.180 D t0 view_helpers.cc:436 example: SELECT spooky_hash('Hello, World!', '')
2021-12-03T09:18:29.180 D t0 view_helpers.cc:437 example result: c96ee75d48e6ea444fee8af948f6da25
2021-12-03T09:18:29.180 I t0 command_executor.cc:137 Executing SQL: SELECT spooky_hash('Hello, World!', 123)
2021-12-03T09:18:29.180 D t0 view_helpers.cc:436 example: SELECT spooky_hash('Hello, World!', 123)
2021-12-03T09:18:29.180 D t0 view_helpers.cc:437 example result: f96b3d9c1a19f4394c97a1b79b1880df
2021-12-03T09:18:29.180 I t0 command_executor.cc:137 Executing SQL: SELECT sqlite_compileoption_used('ENABLE_FTS3')
2021-12-03T09:18:29.180 D t0 view_helpers.cc:436 example: SELECT sqlite_compileoption_used('ENABLE_FTS3')
2021-12-03T09:18:29.180 D t0 view_helpers.cc:437 example result: 0
2021-12-03T09:18:29.180 I t0 command_executor.cc:137 Executing SQL: SELECT square(2)
2021-12-03T09:18:29.180 D t0 view_helpers.cc:436 example: SELECT square(2)
2021-12-03T09:18:29.180 D t0 view_helpers.cc:437 example result: 4
2021-12-03T09:18:29.180 I t0 command_executor.cc:137 Executing SQL: SELECT startswith('foobar', 'foo')
2021-12-03T09:18:29.180 D t0 view_helpers.cc:436 example: SELECT startswith('foobar', 'foo')
2021-12-03T09:18:29.180 D t0 view_helpers.cc:437 example result: 1
2021-12-03T09:18:29.180 I t0 command_executor.cc:137 Executing SQL: SELECT startswith('foobar', 'bar')
2021-12-03T09:18:29.180 D t0 view_helpers.cc:436 example: SELECT startswith('foobar', 'bar')
2021-12-03T09:18:29.180 D t0 view_helpers.cc:437 example result: 0
2021-12-03T09:18:29.180 I t0 command_executor.cc:137 Executing SQL: SELECT strfilter('abcabc', 'bcd')
2021-12-03T09:18:29.180 D t0 view_helpers.cc:436 example: SELECT strfilter('abcabc', 'bcd')
2021-12-03T09:18:29.180 D t0 view_helpers.cc:437 example result: bcbc
2021-12-03T09:18:29.180 I t0 command_executor.cc:137 Executing SQL: SELECT strftime('%Y', '2017-01-02T03:04:05')
2021-12-03T09:18:29.180 D t0 view_helpers.cc:436 example: SELECT strftime('%Y', '2017-01-02T03:04:05')
2021-12-03T09:18:29.180 D t0 view_helpers.cc:437 example result: 2017
2021-12-03T09:18:29.180 I t0 command_executor.cc:137 Executing SQL: SELECT strftime('The time is: %H:%M:%S', '2017-01-02T03:04:05', '+1 minute')
2021-12-03T09:18:29.180 D t0 view_helpers.cc:436 example: SELECT strftime('The time is: %H:%M:%S', '2017-01-02T03:04:05', '+1 minute')
2021-12-03T09:18:29.180 D t0 view_helpers.cc:437 example result: The time is: 03:05:05
2021-12-03T09:18:29.180 I t0 command_executor.cc:137 Executing SQL: SELECT strftime('Julian day: %J', 1491341842, 'unixepoch')
2021-12-03T09:18:29.180 D t0 view_helpers.cc:436 example: SELECT strftime('Julian day: %J', 1491341842, 'unixepoch')
2021-12-03T09:18:29.180 D t0 view_helpers.cc:437 example result: Julian day: 2457848.400949074
2021-12-03T09:18:29.180 I t0 command_executor.cc:137 Executing SQL: SELECT substr('abc', 2)
2021-12-03T09:18:29.180 D t0 view_helpers.cc:436 example: SELECT substr('abc', 2)
2021-12-03T09:18:29.180 D t0 view_helpers.cc:437 example result: bc
2021-12-03T09:18:29.180 I t0 command_executor.cc:137 Executing SQL: SELECT substr('abc', 2, 1)
2021-12-03T09:18:29.180 D t0 view_helpers.cc:436 example: SELECT substr('abc', 2, 1)
2021-12-03T09:18:29.180 D t0 view_helpers.cc:437 example result: b
2021-12-03T09:18:29.180 I t0 command_executor.cc:137 Executing SQL: SELECT substr('abc', -1)
2021-12-03T09:18:29.180 D t0 view_helpers.cc:436 example: SELECT substr('abc', -1)
2021-12-03T09:18:29.180 D t0 view_helpers.cc:437 example result: c
2021-12-03T09:18:29.180 I t0 command_executor.cc:137 Executing SQL: SELECT substr('abc', -1, -1)
2021-12-03T09:18:29.180 D t0 view_helpers.cc:436 example: SELECT substr('abc', -1, -1)
2021-12-03T09:18:29.180 D t0 view_helpers.cc:437 example result: b
2021-12-03T09:18:29.180 I t0 command_executor.cc:137 Executing SQL: SELECT sum(ex_duration) FROM lnav_example_log
2021-12-03T09:18:29.180 D t0 view_helpers.cc:436 example: SELECT sum(ex_duration) FROM lnav_example_log
2021-12-03T09:18:29.180 D t0 view_helpers.cc:437 example result: 17
2021-12-03T09:18:29.180 I t0 command_executor.cc:137 Executing SQL: SELECT time('2017-01-02T03:04:05')
2021-12-03T09:18:29.180 D t0 view_helpers.cc:436 example: SELECT time('2017-01-02T03:04:05')
2021-12-03T09:18:29.180 D t0 view_helpers.cc:437 example result: 03:04:05
2021-12-03T09:18:29.180 I t0 command_executor.cc:137 Executing SQL: SELECT time('2017-01-02T03:04:05', '+1 minute')
2021-12-03T09:18:29.180 D t0 view_helpers.cc:436 example: SELECT time('2017-01-02T03:04:05', '+1 minute')
2021-12-03T09:18:29.180 D t0 view_helpers.cc:437 example result: 03:05:05
2021-12-03T09:18:29.180 I t0 command_executor.cc:137 Executing SQL: SELECT time(1491341842, 'unixepoch')
2021-12-03T09:18:29.180 D t0 view_helpers.cc:436 example: SELECT time(1491341842, 'unixepoch')
2021-12-03T09:18:29.180 D t0 view_helpers.cc:437 example result: 21:37:22
2021-12-03T09:18:29.180 I t0 command_executor.cc:137 Executing SQL: SELECT timediff('2017-02-03T04:05:06', '2017-02-03T04:05:00')
2021-12-03T09:18:29.181 D t0 view_helpers.cc:436 example: SELECT timediff('2017-02-03T04:05:06', '2017-02-03T04:05:00')
2021-12-03T09:18:29.181 D t0 view_helpers.cc:437 example result: 6.0
2021-12-03T09:18:29.181 I t0 command_executor.cc:137 Executing SQL: SELECT timediff('today', 'yesterday')
2021-12-03T09:18:29.181 D t0 view_helpers.cc:436 example: SELECT timediff('today', 'yesterday')
2021-12-03T09:18:29.181 D t0 view_helpers.cc:437 example result: 86400.0
2021-12-03T09:18:29.181 I t0 command_executor.cc:137 Executing SQL: SELECT timeslice('2017-01-01T05:05:00', '10m')
2021-12-03T09:18:29.181 D t0 view_helpers.cc:436 example: SELECT timeslice('2017-01-01T05:05:00', '10m')
2021-12-03T09:18:29.181 D t0 view_helpers.cc:437 example result: 2017-01-01 05:00:00.000
2021-12-03T09:18:29.181 I t0 command_executor.cc:137 Executing SQL: SELECT timeslice(log_time_msecs, '5m') AS slice, count(1) FROM lnav_example_log GROUP BY slice
2021-12-03T09:18:29.181 D t0 view_helpers.cc:436 example: SELECT timeslice(log_time_msecs, '5m') AS slice, count(1) FROM lnav_example_log GROUP BY slice
2021-12-03T09:18:29.181 D t0 view_helpers.cc:437 example result:          slice          count(1)
2017-02-03 04:05:00.000        2
2017-02-03 04:25:00.000        1
2017-02-03 04:55:00.000        1
2021-12-03T09:18:29.181 I t0 command_executor.cc:137 Executing SQL: SELECT timeslice(log_time_msecs, 'before 4:30am') AS slice, count(1) FROM lnav_example_log GROUP BY slice
2021-12-03T09:18:29.181 D t0 view_helpers.cc:436 example: SELECT timeslice(log_time_msecs, 'before 4:30am') AS slice, count(1) FROM lnav_example_log GROUP BY slice
2021-12-03T09:18:29.181 D t0 view_helpers.cc:437 example result:          slice          count(1)
<NULL>                         1
2017-02-03 00:00:00.000        3
2021-12-03T09:18:29.181 I t0 command_executor.cc:137 Executing SQL: SELECT total(ex_duration) FROM lnav_example_log
2021-12-03T09:18:29.181 D t0 view_helpers.cc:436 example: SELECT total(ex_duration) FROM lnav_example_log
2021-12-03T09:18:29.181 D t0 view_helpers.cc:437 example result: 17.0
2021-12-03T09:18:29.181 I t0 command_executor.cc:137 Executing SQL: SELECT trim('    abc   ')
2021-12-03T09:18:29.181 D t0 view_helpers.cc:436 example: SELECT trim('    abc   ')
2021-12-03T09:18:29.181 D t0 view_helpers.cc:437 example result: abc
2021-12-03T09:18:29.181 I t0 command_executor.cc:137 Executing SQL: SELECT trim('-+abc+-', '-+')
2021-12-03T09:18:29.181 D t0 view_helpers.cc:436 example: SELECT trim('-+abc+-', '-+')
2021-12-03T09:18:29.181 D t0 view_helpers.cc:437 example result: abc
2021-12-03T09:18:29.181 I t0 command_executor.cc:137 Executing SQL: SELECT typeof(1)
2021-12-03T09:18:29.181 D t0 view_helpers.cc:436 example: SELECT typeof(1)
2021-12-03T09:18:29.181 D t0 view_helpers.cc:437 example result: integer
2021-12-03T09:18:29.181 I t0 command_executor.cc:137 Executing SQL: SELECT typeof('abc')
2021-12-03T09:18:29.181 D t0 view_helpers.cc:436 example: SELECT typeof('abc')
2021-12-03T09:18:29.181 D t0 view_helpers.cc:437 example result: text
2021-12-03T09:18:29.181 I t0 command_executor.cc:137 Executing SQL: SELECT unicode('abc')
2021-12-03T09:18:29.181 D t0 view_helpers.cc:436 example: SELECT unicode('abc')
2021-12-03T09:18:29.181 D t0 view_helpers.cc:437 example result: 97
2021-12-03T09:18:29.181 I t0 command_executor.cc:137 Executing SQL: SELECT upper('aBc')
2021-12-03T09:18:29.181 D t0 view_helpers.cc:436 example: SELECT upper('aBc')
2021-12-03T09:18:29.181 D t0 view_helpers.cc:437 example result: ABC
2021-12-03T09:18:29.181 I t0 command_executor.cc:137 Executing SQL: SELECT * FROM xpath('/abc/def', '<abc><def a="b">Hello</def><def>Bye</def></abc>')
2021-12-03T09:18:29.181 D t0 view_helpers.cc:436 example: SELECT * FROM xpath('/abc/def', '<abc><def a="b">Hello</def><def>Bye</def></abc>')
2021-12-03T09:18:29.181 D t0 view_helpers.cc:437 example result:         result           node_path  node_attr node_text
<def a="b">Hello</def>␊ /abc/def[1] {"a":"b"} Hello
<def>Bye</def>␊         /abc/def[2] {}        Bye
2021-12-03T09:18:29.181 I t0 command_executor.cc:137 Executing SQL: SELECT * FROM xpath('/abc/def/@a', '<abc><def a="b">Hello</def><def>Bye</def></abc>')
2021-12-03T09:18:29.182 D t0 view_helpers.cc:436 example: SELECT * FROM xpath('/abc/def/@a', '<abc><def a="b">Hello</def><def>Bye</def></abc>')
2021-12-03T09:18:29.182 D t0 view_helpers.cc:437 example result: result   node_path    node_attr node_text
b      /abc/def[1]/@a {"a":"b"} Hello
2021-12-03T09:18:29.182 I t0 command_executor.cc:137 Executing SQL: SELECT * FROM xpath('/abc/def/text()', '<abc><def a="b">Hello &#x2605;</def></abc>')
2021-12-03T09:18:29.182 D t0 view_helpers.cc:436 example: SELECT * FROM xpath('/abc/def/text()', '<abc><def a="b">Hello &#x2605;</def></abc>')
2021-12-03T09:18:29.182 D t0 view_helpers.cc:437 example result: result     node_path    node_attr node_text
Hello ★ /abc/def/text() {}        Hello ★
2021-12-03T09:18:29.182 I t0 command_executor.cc:492 Executing file: /root/.lnav/session
2021-12-03T09:18:29.182 D t0 log_format_loader.cc:1143 Searching for script in path: /etc/lnav/formats/*/*.lnav
2021-12-03T09:18:29.182 D t0 log_format_loader.cc:1143 Searching for script in path: /usr/etc/lnav/formats/*/*.lnav
2021-12-03T09:18:29.182 D t0 log_format_loader.cc:1143 Searching for script in path: /root/.lnav/formats/*/*.lnav
2021-12-03T09:18:29.182 D t0 log_format_loader.cc:1155   found script: /root/.lnav/formats/default/dhclient-summary.lnav
2021-12-03T09:18:29.182 D t0 log_format_loader.cc:1155   found script: /root/.lnav/formats/default/lnav-pop-view.lnav
2021-12-03T09:18:29.182 D t0 log_format_loader.cc:1155   found script: /root/.lnav/formats/default/partition-by-boot.lnav
2021-12-03T09:18:29.182 D t0 log_format_loader.cc:1155   found script: /root/.lnav/formats/default/rename-stdin.lnav
2021-12-03T09:18:29.182 D t0 log_format_loader.cc:1155   found script: /root/.lnav/formats/default/search-for.lnav
2021-12-03T09:18:29.182 D t0 lnav.cc:1534 rescan started 0x7fffbf835830
2021-12-03T09:18:29.183 D t3 archive_manager.cc:119 read open /rsyslog/filter/filtered.log
2021-12-03T09:18:29.183 D t4 archive_manager.cc:119 read open /rsyslog/filter/executed_logged.log
2021-12-03T09:18:29.183 D t5 archive_manager.cc:119 read open /rsyslog/filter/filtered.log-2021-12-03
2021-12-03T09:18:29.183 D t3 archive_manager.cc:126 read next header (null) /rsyslog/filter/filtered.log
2021-12-03T09:18:29.183 D t3 archive_manager.cc:128 read next done /rsyslog/filter/filtered.log
2021-12-03T09:18:29.183 D t5 archive_manager.cc:126 read next header (null) /rsyslog/filter/filtered.log-2021-12-03
2021-12-03T09:18:29.183 I t4 archive_manager.cc:156 archive open failed: /rsyslog/filter/executed_logged.log -- Unrecognized archive format
2021-12-03T09:18:29.183 D t6 archive_manager.cc:119 read open /rsyslog/filter/executed_logged.log-2021-12-03
2021-12-03T09:18:29.183 D t5 archive_manager.cc:128 read next done /rsyslog/filter/filtered.log-2021-12-03
2021-12-03T09:18:29.183 I t3 file_collection.cc:353 loading new file: filename=/rsyslog/filter/filtered.log
2021-12-03T09:18:29.183 D t6 archive_manager.cc:126 read next header (null) /rsyslog/filter/executed_logged.log-2021-12-03
2021-12-03T09:18:29.183 D t6 archive_manager.cc:128 read next done /rsyslog/filter/executed_logged.log-2021-12-03
2021-12-03T09:18:29.183 I t5 file_collection.cc:353 loading new file: filename=/rsyslog/filter/filtered.log-2021-12-03
2021-12-03T09:18:29.183 I t4 file_collection.cc:353 loading new file: filename=/rsyslog/filter/executed_logged.log
2021-12-03T09:18:29.184 I t3 logfile.cc:94 Creating logfile: fd=11; size=39629592; mtime=1638519509; filename=/rsyslog/filter/filtered.log
2021-12-03T09:18:29.184 I t5 logfile.cc:94 Creating logfile: fd=12; size=238959072; mtime=1638497274; filename=/rsyslog/filter/filtered.log-2021-12-03
2021-12-03T09:18:29.184 I t6 file_collection.cc:353 loading new file: filename=/rsyslog/filter/executed_logged.log-2021-12-03
2021-12-03T09:18:29.184 I t4 logfile.cc:94 Creating logfile: fd=13; size=0; mtime=1638497274; filename=/rsyslog/filter/executed_logged.log
2021-12-03T09:18:29.184 I t6 logfile.cc:94 Creating logfile: fd=14; size=593; mtime=1638457442; filename=/rsyslog/filter/executed_logged.log-2021-12-03
2021-12-03T09:18:29.185 D t0 lnav.cc:1579 initial rescan rebuild
2021-12-03T09:18:29.185 D t0 logfile.cc:370 scanning file... /rsyslog/filter/executed_logged.log-2021-12-03
2021-12-03T09:18:29.185 D t0 logfile.cc:434 loading file... /rsyslog/filter/executed_logged.log-2021-12-03:0
2021-12-03T09:18:29.185 D t0 logfile.cc:482 setting text format to 0
2021-12-03T09:18:29.186 D t0 log_format.cc:683 Unable to parse line at offset 0: lexical error: invalid char in json text.
                                       Dec  2 13:25:58 172.16.50.254 d
                     (right here) ------^

2021-12-03T09:18:29.186 D t0 log_format.cc:848 0: changing pattern lock -1 -> 1
2021-12-03T09:18:29.186 I t0 logfile.cc:215 /rsyslog/filter/executed_logged.log-2021-12-03:1:log format found -- syslog_log
2021-12-03T09:18:29.186 I t0 lnav.cc:547 promoting text file to log file: /rsyslog/filter/executed_logged.log-2021-12-03 (62de05e9a69c2366e8ae4631f133ff25)
2021-12-03T09:18:29.186 D t0 logfile.cc:370 scanning file... /rsyslog/filter/filtered.log
2021-12-03T09:18:29.186 D t0 logfile.cc:434 loading file... /rsyslog/filter/filtered.log:0
2021-12-03T09:18:29.187 D t0 logfile.cc:482 setting text format to 0
2021-12-03T09:18:29.187 D t0 log_format.cc:683 Unable to parse line at offset 0: lexical error: invalid char in json text.
                                       Dec  3 03:07:56 DC1-EFW-01 : %A
                     (right here) ------^

2021-12-03T09:18:29.187 D t0 log_format.cc:848 0: changing pattern lock -1 -> 1
2021-12-03T09:18:29.187 I t0 logfile.cc:215 /rsyslog/filter/filtered.log:1:log format found -- syslog_log
2021-12-03T09:18:29.188 I t0 lnav.cc:547 promoting text file to log file: /rsyslog/filter/filtered.log (5feb40dee8c3dd463af31f33b5d90e0e)
2021-12-03T09:18:29.188 D t0 logfile.cc:370 scanning file... /rsyslog/filter/filtered.log-2021-12-03
2021-12-03T09:18:29.188 D t0 logfile.cc:434 loading file... /rsyslog/filter/filtered.log-2021-12-03:0
2021-12-03T09:18:29.189 D t0 logfile.cc:482 setting text format to 0
2021-12-03T09:18:29.189 D t0 log_format.cc:683 Unable to parse line at offset 0: lexical error: invalid char in json text.
                                       Dec  2 03:47:58 DC1-EFW-01 : %A
                     (right here) ------^

2021-12-03T09:18:29.189 D t0 log_format.cc:848 0: changing pattern lock -1 -> 1
2021-12-03T09:18:29.189 I t0 logfile.cc:215 /rsyslog/filter/filtered.log-2021-12-03:1:log format found -- syslog_log
2021-12-03T09:18:29.189 I t0 lnav.cc:547 promoting text file to log file: /rsyslog/filter/filtered.log-2021-12-03 (d99adf6e6e720f0724faa3a5ba3a22ca)
2021-12-03T09:18:29.189 D t0 logfile_sub_source.cc:605 forced to full rebuild
2021-12-03T09:18:29.189 D t0 logfile_sub_source.cc:660 new lines for /rsyslog/filter/executed_logged.log-2021-12-03:2
2021-12-03T09:18:29.494 D t0 log_format.cc:364 211204:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:29.515 D t0 log_format.cc:364 211226:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:29.534 D t0 log_format.cc:364 211279:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:29.552 D t0 log_format.cc:364 211284:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:29.570 D t0 log_format.cc:364 211302:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:29.589 D t0 log_format.cc:364 211360:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:29.609 D t0 log_format.cc:364 211787:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:29.628 D t0 log_format.cc:364 211837:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:29.646 D t0 log_format.cc:364 211854:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:29.665 D t0 log_format.cc:364 211910:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:29.688 D t0 log_format.cc:364 213090:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:29.707 D t0 log_format.cc:364 213108:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:29.725 D t0 log_format.cc:364 213209:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:29.744 D t0 log_format.cc:364 213493:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:29.763 D t0 log_format.cc:364 213534:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:29.781 D t0 log_format.cc:364 213551:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:29.800 D t0 log_format.cc:364 213603:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:29.821 D t0 log_format.cc:364 215211:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:29.840 D t0 log_format.cc:364 215243:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:29.858 D t0 log_format.cc:364 215287:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:29.898 I t0 logfile.cc:558 Resource usage for initial indexing of file: /rsyslog/filter/filtered.log:1-230433
2021-12-03T09:18:29.898 I t0 logfile.cc:562 rusage:
2021-12-03T09:18:29.898 I t0 logfile.cc:562   utime=0.688375
2021-12-03T09:18:29.898 I t0 logfile.cc:562   stime=0.020865
2021-12-03T09:18:29.898 I t0 logfile.cc:562   maxrss=6564
2021-12-03T09:18:29.898 I t0 logfile.cc:562   ixrss=0
2021-12-03T09:18:29.898 I t0 logfile.cc:562   idrss=0
2021-12-03T09:18:29.898 I t0 logfile.cc:562   isrss=0
2021-12-03T09:18:29.898 I t0 logfile.cc:562   minflt=3320
2021-12-03T09:18:29.898 I t0 logfile.cc:562   majflt=0
2021-12-03T09:18:29.898 I t0 logfile.cc:562   nswap=0
2021-12-03T09:18:29.898 I t0 logfile.cc:562   inblock=0
2021-12-03T09:18:29.898 I t0 logfile.cc:562   oublock=0
2021-12-03T09:18:29.898 I t0 logfile.cc:562   msgsnd=0
2021-12-03T09:18:29.898 I t0 logfile.cc:562   msgrcv=0
2021-12-03T09:18:29.898 I t0 logfile.cc:562   nsignals=0
2021-12-03T09:18:29.898 I t0 logfile.cc:562   nvcsw=0
2021-12-03T09:18:29.898 I t0 logfile.cc:562   nivcsw=5
2021-12-03T09:18:29.898 I t0 logfile.cc:590 Detected 89755 out-of-time-order lines in file: /rsyslog/filter/filtered.log
2021-12-03T09:18:29.898 D t0 logfile_sub_source.cc:695 /rsyslog/filter/filtered.log: log file has a new order, full rebuild
2021-12-03T09:18:30.107 D t0 log_format.cc:364 150437:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:30.119 D t0 log_format.cc:364 150585:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:30.132 D t0 log_format.cc:364 150832:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:30.145 D t0 log_format.cc:364 150834:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:30.158 D t0 log_format.cc:364 150863:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:30.175 D t0 log_format.cc:364 150973:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:30.192 D t0 log_format.cc:364 151036:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:30.206 D t0 log_format.cc:364 151097:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:30.284 D t0 log_format.cc:364 199546:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:30.300 D t0 log_format.cc:364 199567:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:30.317 D t0 log_format.cc:364 199668:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:30.340 D t0 log_format.cc:364 204324:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:30.358 D t0 log_format.cc:364 204868:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:30.376 D t0 log_format.cc:364 204933:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:30.393 D t0 log_format.cc:364 205589:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:30.410 D t0 log_format.cc:364 205629:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:30.427 D t0 log_format.cc:364 205682:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:30.443 D t0 log_format.cc:364 205870:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:30.460 D t0 log_format.cc:364 205908:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:30.477 D t0 log_format.cc:364 205921:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:30.493 D t0 log_format.cc:364 205962:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:30.529 D t0 log_format.cc:364 218190:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:30.592 D t0 log_format.cc:364 245364:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:30.614 D t0 log_format.cc:364 245367:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:30.652 D t0 log_format.cc:364 255133:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:30.739 D t0 log_format.cc:364 283619:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:30.763 D t0 log_format.cc:364 283683:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:30.787 D t0 log_format.cc:364 284110:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:30.811 D t0 log_format.cc:364 284194:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:30.835 D t0 log_format.cc:364 284314:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:30.859 D t0 log_format.cc:364 284426:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:30.888 D t0 log_format.cc:364 288182:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:30.966 D t0 log_format.cc:364 325342:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:31.059 D t0 log_format.cc:364 366016:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:31.185 D t0 log_format.cc:364 427024:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:31.222 D t0 log_format.cc:364 427028:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:31.285 D t0 log_format.cc:364 444756:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:31.415 D t0 log_format.cc:364 506039:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:31.472 D t0 log_format.cc:364 515033:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:31.574 D t0 log_format.cc:364 546921:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:31.620 D t0 log_format.cc:364 546924:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:31.664 D t0 log_format.cc:364 546953:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:31.715 D t0 log_format.cc:364 546993:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:31.778 D t0 log_format.cc:364 559414:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:31.867 D t0 log_format.cc:364 588118:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:32.006 D t0 log_format.cc:364 650989:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:32.062 D t0 log_format.cc:364 651037:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:32.124 D t0 log_format.cc:364 655732:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:32.180 D t0 log_format.cc:364 655972:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:32.236 D t0 log_format.cc:364 655976:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:32.292 D t0 log_format.cc:364 656209:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:32.348 D t0 log_format.cc:364 656340:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:32.403 D t0 log_format.cc:364 656375:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:32.460 D t0 log_format.cc:364 656426:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:32.517 D t0 log_format.cc:364 656471:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:32.574 D t0 log_format.cc:364 656510:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:32.630 D t0 log_format.cc:364 656533:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:32.689 D t0 log_format.cc:364 656577:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:32.752 D t0 log_format.cc:364 656599:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:32.805 D t0 log_format.cc:364 656631:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:32.860 D t0 log_format.cc:364 656634:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:32.914 D t0 log_format.cc:364 656657:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:32.969 D t0 log_format.cc:364 656710:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:33.024 D t0 log_format.cc:364 656747:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:33.081 D t0 log_format.cc:364 656824:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:33.136 D t0 log_format.cc:364 656846:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:33.194 D t0 log_format.cc:364 657029:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:33.250 D t0 log_format.cc:364 657119:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:33.304 D t0 log_format.cc:364 657180:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:33.358 D t0 log_format.cc:364 657199:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:33.413 D t0 log_format.cc:364 657254:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:33.468 D t0 log_format.cc:364 657298:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:33.524 D t0 log_format.cc:364 657379:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:33.578 D t0 log_format.cc:364 657389:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:33.633 D t0 log_format.cc:364 657518:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:33.693 D t0 log_format.cc:364 657552:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:33.748 D t0 log_format.cc:364 657683:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:33.802 D t0 log_format.cc:364 657727:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:33.858 D t0 log_format.cc:364 657792:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:33.913 D t0 log_format.cc:364 657823:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:33.967 D t0 log_format.cc:364 658007:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:34.022 D t0 log_format.cc:364 658024:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:34.077 D t0 log_format.cc:364 658058:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:34.131 D t0 log_format.cc:364 658131:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:34.191 D t0 log_format.cc:364 658189:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:34.245 D t0 log_format.cc:364 658211:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:34.298 D t0 log_format.cc:364 658267:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:34.351 D t0 log_format.cc:364 658338:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:34.405 D t0 log_format.cc:364 658429:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:34.459 D t0 log_format.cc:364 658446:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:34.512 D t0 log_format.cc:364 658493:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:34.565 D t0 log_format.cc:364 658508:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:34.620 D t0 log_format.cc:364 658557:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:34.675 D t0 log_format.cc:364 658609:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:34.735 D t0 log_format.cc:364 658612:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:34.788 D t0 log_format.cc:364 658625:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:34.842 D t0 log_format.cc:364 658666:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:34.897 D t0 log_format.cc:364 658683:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:34.953 D t0 log_format.cc:364 658713:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:35.008 D t0 log_format.cc:364 658725:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:35.064 D t0 log_format.cc:364 658773:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:35.120 D t0 log_format.cc:364 658787:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:35.178 D t0 log_format.cc:364 658821:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:35.234 D t0 log_format.cc:364 658890:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:35.289 D t0 log_format.cc:364 658941:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:35.345 D t0 log_format.cc:364 658979:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:35.400 D t0 log_format.cc:364 659103:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:35.456 D t0 log_format.cc:364 659135:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:35.511 D t0 log_format.cc:364 659170:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:35.565 D t0 log_format.cc:364 659181:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:35.620 D t0 log_format.cc:364 659245:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:35.677 D t0 log_format.cc:364 659252:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:35.732 D t0 log_format.cc:364 659344:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:35.806 D t0 log_format.cc:364 659401:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:35.863 D t0 log_format.cc:364 659405:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:35.919 D t0 log_format.cc:364 659432:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:35.974 D t0 log_format.cc:364 659463:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:36.031 D t0 log_format.cc:364 659471:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:36.088 D t0 log_format.cc:364 659552:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:36.140 D t0 log_format.cc:364 659585:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:36.194 D t0 log_format.cc:364 659623:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:36.246 D t0 log_format.cc:364 659637:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:36.298 D t0 log_format.cc:364 659685:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:36.349 D t0 log_format.cc:364 659773:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:36.400 D t0 log_format.cc:364 659814:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:36.450 D t0 log_format.cc:364 659846:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:36.502 D t0 log_format.cc:364 659881:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:36.556 D t0 log_format.cc:364 659898:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:36.613 D t0 log_format.cc:364 660738:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:36.670 D t0 log_format.cc:364 661504:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:36.738 D t0 log_format.cc:364 669478:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:36.791 D t0 log_format.cc:364 669789:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:36.844 D t0 log_format.cc:364 669861:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:36.897 D t0 log_format.cc:364 669924:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:36.951 D t0 log_format.cc:364 669967:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:37.003 D t0 log_format.cc:364 670009:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:37.059 D t0 log_format.cc:364 670042:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:37.114 D t0 log_format.cc:364 670075:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:37.168 D t0 log_format.cc:364 670126:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:37.224 D t0 log_format.cc:364 670162:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:37.278 D t0 log_format.cc:364 670187:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:37.330 D t0 log_format.cc:364 670234:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:37.383 D t0 log_format.cc:364 670348:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:37.436 D t0 log_format.cc:364 670392:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:37.488 D t0 log_format.cc:364 670442:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:37.542 D t0 log_format.cc:364 670601:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:37.596 D t0 log_format.cc:364 670629:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:37.649 D t0 log_format.cc:364 670632:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:37.703 D t0 log_format.cc:364 671013:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:37.757 D t0 log_format.cc:364 672093:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:37.814 D t0 log_format.cc:364 675175:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:37.867 D t0 log_format.cc:364 675219:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:37.920 D t0 log_format.cc:364 675256:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:37.978 D t0 log_format.cc:364 679624:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:38.056 D t0 log_format.cc:364 695437:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:38.159 D t0 log_format.cc:364 725488:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:38.237 D t0 log_format.cc:364 738653:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:38.335 D t0 log_format.cc:364 766210:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:38.419 D t0 log_format.cc:364 784231:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:38.483 D t0 log_format.cc:364 784274:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:38.561 D t0 log_format.cc:364 795397:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:38.639 D t0 log_format.cc:364 802552:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:38.711 D t0 log_format.cc:364 805476:detected time rollover; offsets=1 0 0 0
2021-12-03T09:18:39.049 I t0 logfile.cc:558 Resource usage for initial indexing of file: /rsyslog/filter/filtered.log-2021-12-03:1-1000000
2021-12-03T09:18:39.049 I t0 logfile.cc:562 rusage:
2021-12-03T09:18:39.049 I t0 logfile.cc:562   utime=9.024522
2021-12-03T09:18:39.049 I t0 logfile.cc:562   stime=0.122047
2021-12-03T09:18:39.049 I t0 logfile.cc:562   maxrss=27068
2021-12-03T09:18:39.049 I t0 logfile.cc:562   ixrss=0
2021-12-03T09:18:39.049 I t0 logfile.cc:562   idrss=0
2021-12-03T09:18:39.049 I t0 logfile.cc:562   isrss=0
2021-12-03T09:18:39.049 I t0 logfile.cc:562   minflt=13976
2021-12-03T09:18:39.049 I t0 logfile.cc:562   majflt=0
2021-12-03T09:18:39.049 I t0 logfile.cc:562   nswap=0
2021-12-03T09:18:39.049 I t0 logfile.cc:562   inblock=0
2021-12-03T09:18:39.049 I t0 logfile.cc:562   oublock=0
2021-12-03T09:18:39.049 I t0 logfile.cc:562   msgsnd=0
2021-12-03T09:18:39.049 I t0 logfile.cc:562   msgrcv=0
2021-12-03T09:18:39.049 I t0 logfile.cc:562   nsignals=0
2021-12-03T09:18:39.049 I t0 logfile.cc:562   nvcsw=18
2021-12-03T09:18:39.049 I t0 logfile.cc:562   nivcsw=132
2021-12-03T09:18:39.049 I t0 logfile.cc:590 Detected 529595 out-of-time-order lines in file: /rsyslog/filter/filtered.log-2021-12-03
2021-12-03T09:18:39.049 D t0 logfile_sub_source.cc:695 /rsyslog/filter/filtered.log-2021-12-03: log file has a new order, full rebuild
2021-12-03T09:18:40.496 D t0 logfile_sub_source.cc:971 redoing search
2021-12-03T09:18:40.538 I t0 session_data.cc:410 loading bookmark db: /root/.lnav/log_metadata.db
2021-12-03T09:18:40.538 E t0 sql_util.cc:586 duplicate column name: comment in "ALTER TABLE bookmarks ADD COLUMN comment text DEFAULT '';"
2021-12-03T09:18:40.538 E t0 session_data.cc:418 unable to upgrade bookmark table -- duplicate column name: comment
2021-12-03T09:18:40.538 E t0 sql_util.cc:586 duplicate column name: tags in "ALTER TABLE bookmarks ADD COLUMN tags text DEFAULT '';"
2021-12-03T09:18:40.538 E t0 session_data.cc:418 unable to upgrade bookmark table -- duplicate column name: tags
2021-12-03T09:18:40.577 I t0 session_data.cc:410 loading bookmark db: /root/.lnav/log_metadata.db
2021-12-03T09:18:40.578 E t0 sql_util.cc:586 duplicate column name: comment in "ALTER TABLE bookmarks ADD COLUMN comment text DEFAULT '';"
2021-12-03T09:18:40.578 E t0 session_data.cc:418 unable to upgrade bookmark table -- duplicate column name: comment
2021-12-03T09:18:40.578 E t0 sql_util.cc:586 duplicate column name: tags in "ALTER TABLE bookmarks ADD COLUMN tags text DEFAULT '';"
2021-12-03T09:18:40.578 E t0 session_data.cc:418 unable to upgrade bookmark table -- duplicate column name: tags
2021-12-03T09:18:40.617 I t0 session_data.cc:915 loading session file: /root/.lnav/view-info-db072dd7cd600a6da06e0c57e19d0875.ts1638519459.ppid45028.json
2021-12-03T09:18:40.617 I t0 command_executor.cc:110 Executing: filter-out managed-keys-zone
2021-12-03T09:18:40.617 D t0 lnav_commands.cc:1663 filter-out [1] managed-keys-zone
2021-12-03T09:18:41.385 I t0 command_executor.cc:110 Executing: filter-out fd0
2021-12-03T09:18:41.385 D t0 lnav_commands.cc:1663 filter-out [2] fd0
2021-12-03T09:18:42.215 I t0 command_executor.cc:110 Executing: filter-out floppy
2021-12-03T09:18:42.215 D t0 lnav_commands.cc:1663 filter-out [3] floppy
2021-12-03T09:18:43.051 I t0 command_executor.cc:110 Executing: filter-out backup
2021-12-03T09:18:43.051 D t0 lnav_commands.cc:1663 filter-out [4] backup
2021-12-03T09:18:43.891 I t0 command_executor.cc:110 Executing: filter-out stunnel
2021-12-03T09:18:43.891 D t0 lnav_commands.cc:1663 filter-out [5] stunnel
2021-12-03T09:18:44.725 I t0 command_executor.cc:110 Executing: filter-out status=deferred
2021-12-03T09:18:44.725 D t0 lnav_commands.cc:1663 filter-out [6] status=deferred
2021-12-03T09:18:45.468 I t0 command_executor.cc:110 Executing: filter-out status=bounced
2021-12-03T09:18:45.468 D t0 lnav_commands.cc:1663 filter-out [7] status=bounced
2021-12-03T09:18:46.244 I t0 command_executor.cc:110 Executing: filter-out error: can't bind socket
2021-12-03T09:18:46.244 D t0 lnav_commands.cc:1663 filter-out [8] error: can't bind socket
2021-12-03T09:18:47.031 I t0 command_executor.cc:110 Executing: filter-out clutter_actor_
2021-12-03T09:18:47.031 D t0 lnav_commands.cc:1663 filter-out [9] clutter_actor_
2021-12-03T09:18:47.813 I t0 command_executor.cc:110 Executing: filter-out Received KoD RATE from
2021-12-03T09:18:47.813 D t0 lnav_commands.cc:1663 filter-out [10] Received KoD RATE from
2021-12-03T09:18:48.577 I t0 command_executor.cc:110 Executing: filter-out DNS lookup
2021-12-03T09:18:48.577 D t0 lnav_commands.cc:1663 filter-out [11] DNS lookup
2021-12-03T09:18:49.325 I t0 command_executor.cc:110 Executing: filter-out WHAL_ERROR_RESET_CHANNF1
2021-12-03T09:18:49.325 D t0 lnav_commands.cc:1663 filter-out [12] WHAL_ERROR_RESET_CHANNF1
2021-12-03T09:18:50.039 I t0 command_executor.cc:110 Executing: filter-out WHAL_ERROR_RESET_ERRID
2021-12-03T09:18:50.039 D t0 lnav_commands.cc:1663 filter-out [13] WHAL_ERROR_RESET_ERRID
2021-12-03T09:18:50.770 I t0 command_executor.cc:110 Executing: filter-out printstraat
2021-12-03T09:18:50.770 D t0 lnav_commands.cc:1663 filter-out [14] printstraat
2021-12-03T09:18:51.498 D t0 session_data.cc:932 found state for file: e1a6f896024661fed93ed58b957dc09a 1
2021-12-03T09:18:51.498 D t0 session_data.cc:932 found state for file: 62de05e9a69c2366e8ae4631f133ff25 1
2021-12-03T09:18:51.498 D t0 session_data.cc:932 found state for file: 5feb40dee8c3dd463af31f33b5d90e0e 1
2021-12-03T09:18:51.498 D t0 session_data.cc:932 found state for file: d99adf6e6e720f0724faa3a5ba3a22ca 1
2021-12-03T09:18:51.498 D t0 lnav.cc:1597 file count 4
2021-12-03T09:18:51.498 D t0 logfile_sub_source.cc:647 no time left, skipping /rsyslog/filter/executed_logged.log-2021-12-03
2021-12-03T09:18:51.504 D t0 hotkeys.cc:155 executing key sequence x51: |lnav-pop-view ${keyseq}
2021-12-03T09:18:51.504 I t0 command_executor.cc:492 Executing file: lnav-pop-view ${keyseq}
2021-12-03T09:18:51.504 D t0 log_format_loader.cc:1143 Searching for script in path: /etc/lnav/formats/*/*.lnav
2021-12-03T09:18:51.504 D t0 log_format_loader.cc:1143 Searching for script in path: /usr/etc/lnav/formats/*/*.lnav
2021-12-03T09:18:51.504 D t0 log_format_loader.cc:1143 Searching for script in path: /root/.lnav/formats/*/*.lnav
2021-12-03T09:18:51.504 D t0 log_format_loader.cc:1155   found script: /root/.lnav/formats/default/dhclient-summary.lnav
2021-12-03T09:18:51.504 D t0 log_format_loader.cc:1155   found script: /root/.lnav/formats/default/lnav-pop-view.lnav
2021-12-03T09:18:51.504 D t0 log_format_loader.cc:1155   found script: /root/.lnav/formats/default/partition-by-boot.lnav
2021-12-03T09:18:51.504 D t0 log_format_loader.cc:1155   found script: /root/.lnav/formats/default/rename-stdin.lnav
2021-12-03T09:18:51.504 D t0 log_format_loader.cc:1155   found script: /root/.lnav/formats/default/search-for.lnav
2021-12-03T09:18:51.505 D t0 log_vtab_impl.cc:130 log_vtab_impl.get_table_statement() -> CREATE TABLE logline  (
  log_line        INTEGER  PRIMARY KEY,            -- The line number for the log message
  log_part        TEXT     COLLATE naturalnocase,  -- The partition the message is in
  log_time        DATETIME,                        -- The adjusted timestamp for the log message
  log_actual_time DATETIME HIDDEN,                 -- The timestamp from the original log file for this message
  log_idle_msecs  INTEGER,                         -- The difference in time between this messages and the previous
  log_level       TEXT     COLLATE loglevel,       -- The log message level
  log_mark        BOOLEAN,                         -- True if the log message was marked
  log_comment     TEXT,                            -- The comment for this message
  log_tags        TEXT,                            -- A JSON list of tags for this message
  log_filters     TEXT,                            -- A JSON list of filter IDs that matched this message
  -- BEGIN Format-specific fields:
  log_hostname     TEXT     COLLATE 'ipaddress'    , -- The name of the host that generated the message
  log_msgid        TEXT     COLLATE 'BINARY'       ,
  log_pid          TEXT     COLLATE 'BINARY'       , -- The ID of the process that generated the message
  log_pri          INTEGER  COLLATE 'BINARY'       , -- The priority level of the message
  log_procname     TEXT     COLLATE 'BINARY'       , -- The name of the process that generated the message
  log_struct       TEXT     COLLATE 'BINARY'       ,
  syslog_version   INTEGER  COLLATE 'BINARY'       , -- The version of the syslog format used for this message
  log_msg_instance INTEGER  COLLATE 'BINARY'       ,
  "%ASA-4-106023"  TEXT     COLLATE 'naturalnocase',
  outside          TEXT     COLLATE 'naturalnocase',
  TRANSFER         TEXT     COLLATE 'naturalnocase',

  -- END Format-specific fields
  log_time_msecs  INTEGER HIDDEN,                    -- The adjusted timestamp for th
2021-12-03T09:18:51.505 D t0 log_vtab_impl.cc:212 creating log format table: logline = 0
2021-12-03T09:18:51.513 I t0 command_executor.cc:137 Executing SQL: SELECT rowid as row_to_delete, name as last_view_name, CASE name
   WHEN 'db' THEN $keymap_def_db_view
   WHEN 'histogram' THEN $keymap_def_hist_view
   WHEN 'text' THEN $keymap_def_text_view
   ELSE ''
 END as view_alt_msg FROM lnav_view_stack ORDER BY rowid DESC LIMIT 1;
2021-12-03T09:18:51.513 I t0 command_executor.cc:603 /root/.lnav/formats/default/lnav-pop-view.lnav:6:execute result -- info: No rows matched
2021-12-03T09:18:51.514 D t0 log_vtab_impl.cc:130 log_vtab_impl.get_table_statement() -> CREATE TABLE logline  (
  log_line        INTEGER  PRIMARY KEY,            -- The line number for the log message
  log_part        TEXT     COLLATE naturalnocase,  -- The partition the message is in
  log_time        DATETIME,                        -- The adjusted timestamp for the log message
  log_actual_time DATETIME HIDDEN,                 -- The timestamp from the original log file for this message
  log_idle_msecs  INTEGER,                         -- The difference in time between this messages and the previous
  log_level       TEXT     COLLATE loglevel,       -- The log message level
  log_mark        BOOLEAN,                         -- True if the log message was marked
  log_comment     TEXT,                            -- The comment for this message
  log_tags        TEXT,                            -- A JSON list of tags for this message
  log_filters     TEXT,                            -- A JSON list of filter IDs that matched this message
  -- BEGIN Format-specific fields:
  log_hostname     TEXT     COLLATE 'ipaddress'    , -- The name of the host that generated the message
  log_msgid        TEXT     COLLATE 'BINARY'       ,
  log_pid          TEXT     COLLATE 'BINARY'       , -- The ID of the process that generated the message
  log_pri          INTEGER  COLLATE 'BINARY'       , -- The priority level of the message
  log_procname     TEXT     COLLATE 'BINARY'       , -- The name of the process that generated the message
  log_struct       TEXT     COLLATE 'BINARY'       ,
  syslog_version   INTEGER  COLLATE 'BINARY'       , -- The version of the syslog format used for this message
  log_msg_instance INTEGER  COLLATE 'BINARY'       ,
  "%ASA-4-106023"  TEXT     COLLATE 'naturalnocase',
  outside          TEXT     COLLATE 'naturalnocase',
  TRANSFER         TEXT     COLLATE 'naturalnocase',

  -- END Format-specific fields
  log_time_msecs  INTEGER HIDDEN,                    -- The adjusted timestamp for th
2021-12-03T09:18:51.514 D t0 log_vtab_impl.cc:212 creating log format table: logline = 0
2021-12-03T09:18:51.522 I t0 command_executor.cc:137 Executing SQL: SELECT top_time as last_top_time FROM lnav_views WHERE name = $last_view_name;
2021-12-03T09:18:51.522 I t0 command_executor.cc:603 /root/.lnav/formats/default/lnav-pop-view.lnav:12:execute result -- info: No rows matched
2021-12-03T09:18:51.522 D t0 log_vtab_impl.cc:130 log_vtab_impl.get_table_statement() -> CREATE TABLE logline  (
  log_line        INTEGER  PRIMARY KEY,            -- The line number for the log message
  log_part        TEXT     COLLATE naturalnocase,  -- The partition the message is in
  log_time        DATETIME,                        -- The adjusted timestamp for the log message
  log_actual_time DATETIME HIDDEN,                 -- The timestamp from the original log file for this message
  log_idle_msecs  INTEGER,                         -- The difference in time between this messages and the previous
  log_level       TEXT     COLLATE loglevel,       -- The log message level
  log_mark        BOOLEAN,                         -- True if the log message was marked
  log_comment     TEXT,                            -- The comment for this message
  log_tags        TEXT,                            -- A JSON list of tags for this message
  log_filters     TEXT,                            -- A JSON list of filter IDs that matched this message
  -- BEGIN Format-specific fields:
  log_hostname     TEXT     COLLATE 'ipaddress'    , -- The name of the host that generated the message
  log_msgid        TEXT     COLLATE 'BINARY'       ,
  log_pid          TEXT     COLLATE 'BINARY'       , -- The ID of the process that generated the message
  log_pri          INTEGER  COLLATE 'BINARY'       , -- The priority level of the message
  log_procname     TEXT     COLLATE 'BINARY'       , -- The name of the process that generated the message
  log_struct       TEXT     COLLATE 'BINARY'       ,
  syslog_version   INTEGER  COLLATE 'BINARY'       , -- The version of the syslog format used for this message
  log_msg_instance INTEGER  COLLATE 'BINARY'       ,
  "%ASA-4-106023"  TEXT     COLLATE 'naturalnocase',
  outside          TEXT     COLLATE 'naturalnocase',
  TRANSFER         TEXT     COLLATE 'naturalnocase',

  -- END Format-specific fields
  log_time_msecs  INTEGER HIDDEN,                    -- The adjusted timestamp for th
2021-12-03T09:18:51.522 D t0 log_vtab_impl.cc:212 creating log format table: logline = 0
2021-12-03T09:18:51.530 I t0 command_executor.cc:137 Executing SQL: DELETE FROM lnav_view_stack WHERE rowid = $row_to_delete;
2021-12-03T09:18:51.530 I t0 command_executor.cc:603 /root/.lnav/formats/default/lnav-pop-view.lnav:13:execute result --
2021-12-03T09:18:51.530 D t0 log_vtab_impl.cc:130 log_vtab_impl.get_table_statement() -> CREATE TABLE logline  (
  log_line        INTEGER  PRIMARY KEY,            -- The line number for the log message
  log_part        TEXT     COLLATE naturalnocase,  -- The partition the message is in
  log_time        DATETIME,                        -- The adjusted timestamp for the log message
  log_actual_time DATETIME HIDDEN,                 -- The timestamp from the original log file for this message
  log_idle_msecs  INTEGER,                         -- The difference in time between this messages and the previous
  log_level       TEXT     COLLATE loglevel,       -- The log message level
  log_mark        BOOLEAN,                         -- True if the log message was marked
  log_comment     TEXT,                            -- The comment for this message
  log_tags        TEXT,                            -- A JSON list of tags for this message
  log_filters     TEXT,                            -- A JSON list of filter IDs that matched this message
  -- BEGIN Format-specific fields:
  log_hostname     TEXT     COLLATE 'ipaddress'    , -- The name of the host that generated the message
  log_msgid        TEXT     COLLATE 'BINARY'       ,
  log_pid          TEXT     COLLATE 'BINARY'       , -- The ID of the process that generated the message
  log_pri          INTEGER  COLLATE 'BINARY'       , -- The priority level of the message
  log_procname     TEXT     COLLATE 'BINARY'       , -- The name of the process that generated the message
  log_struct       TEXT     COLLATE 'BINARY'       ,
  syslog_version   INTEGER  COLLATE 'BINARY'       , -- The version of the syslog format used for this message
  log_msg_instance INTEGER  COLLATE 'BINARY'       ,
  "%ASA-4-106023"  TEXT     COLLATE 'naturalnocase',
  outside          TEXT     COLLATE 'naturalnocase',
  TRANSFER         TEXT     COLLATE 'naturalnocase',

  -- END Format-specific fields
  log_time_msecs  INTEGER HIDDEN,                    -- The adjusted timestamp for th
2021-12-03T09:18:51.531 D t0 log_vtab_impl.cc:212 creating log format table: logline = 0
2021-12-03T09:18:51.537 I t0 command_executor.cc:137 Executing SQL: SELECT name AS new_top_view_name FROM lnav_view_stack ORDER BY rowid DESC LIMIT 1;
2021-12-03T09:18:51.537 I t0 command_executor.cc:603 /root/.lnav/formats/default/lnav-pop-view.lnav:14:execute result -- info: No rows matched
2021-12-03T09:18:51.538 D t0 log_vtab_impl.cc:130 log_vtab_impl.get_table_statement() -> CREATE TABLE logline  (
  log_line        INTEGER  PRIMARY KEY,            -- The line number for the log message
  log_part        TEXT     COLLATE naturalnocase,  -- The partition the message is in
  log_time        DATETIME,                        -- The adjusted timestamp for the log message
  log_actual_time DATETIME HIDDEN,                 -- The timestamp from the original log file for this message
  log_idle_msecs  INTEGER,                         -- The difference in time between this messages and the previous
  log_level       TEXT     COLLATE loglevel,       -- The log message level
  log_mark        BOOLEAN,                         -- True if the log message was marked
  log_comment     TEXT,                            -- The comment for this message
  log_tags        TEXT,                            -- A JSON list of tags for this message
  log_filters     TEXT,                            -- A JSON list of filter IDs that matched this message
  -- BEGIN Format-specific fields:
  log_hostname     TEXT     COLLATE 'ipaddress'    , -- The name of the host that generated the message
  log_msgid        TEXT     COLLATE 'BINARY'       ,
  log_pid          TEXT     COLLATE 'BINARY'       , -- The ID of the process that generated the message
  log_pri          INTEGER  COLLATE 'BINARY'       , -- The priority level of the message
  log_procname     TEXT     COLLATE 'BINARY'       , -- The name of the process that generated the message
  log_struct       TEXT     COLLATE 'BINARY'       ,
  syslog_version   INTEGER  COLLATE 'BINARY'       , -- The version of the syslog format used for this message
  log_msg_instance INTEGER  COLLATE 'BINARY'       ,
  "%ASA-4-106023"  TEXT     COLLATE 'naturalnocase',
  outside          TEXT     COLLATE 'naturalnocase',
  TRANSFER         TEXT     COLLATE 'naturalnocase',

  -- END Format-specific fields
  log_time_msecs  INTEGER HIDDEN,                    -- The adjusted timestamp for th
2021-12-03T09:18:51.538 D t0 log_vtab_impl.cc:212 creating log format table: logline = 0
2021-12-03T09:18:51.545 I t0 command_executor.cc:137 Executing SQL: SELECT top_time AS old_top_time FROM lnav_views WHERE name = $new_top_view_name;
2021-12-03T09:18:51.545 I t0 command_executor.cc:603 /root/.lnav/formats/default/lnav-pop-view.lnav:15:execute result -- info: No rows matched
2021-12-03T09:18:51.546 D t0 log_vtab_impl.cc:130 log_vtab_impl.get_table_statement() -> CREATE TABLE logline  (
  log_line        INTEGER  PRIMARY KEY,            -- The line number for the log message
  log_part        TEXT     COLLATE naturalnocase,  -- The partition the message is in
  log_time        DATETIME,                        -- The adjusted timestamp for the log message
  log_actual_time DATETIME HIDDEN,                 -- The timestamp from the original log file for this message
  log_idle_msecs  INTEGER,                         -- The difference in time between this messages and the previous
  log_level       TEXT     COLLATE loglevel,       -- The log message level
  log_mark        BOOLEAN,                         -- True if the log message was marked
  log_comment     TEXT,                            -- The comment for this message
  log_tags        TEXT,                            -- A JSON list of tags for this message
  log_filters     TEXT,                            -- A JSON list of filter IDs that matched this message
  -- BEGIN Format-specific fields:
  log_hostname     TEXT     COLLATE 'ipaddress'    , -- The name of the host that generated the message
  log_msgid        TEXT     COLLATE 'BINARY'       ,
  log_pid          TEXT     COLLATE 'BINARY'       , -- The ID of the process that generated the message
  log_pri          INTEGER  COLLATE 'BINARY'       , -- The priority level of the message
  log_procname     TEXT     COLLATE 'BINARY'       , -- The name of the process that generated the message
  log_struct       TEXT     COLLATE 'BINARY'       ,
  syslog_version   INTEGER  COLLATE 'BINARY'       , -- The version of the syslog format used for this message
  log_msg_instance INTEGER  COLLATE 'BINARY'       ,
  "%ASA-4-106023"  TEXT     COLLATE 'naturalnocase',
  outside          TEXT     COLLATE 'naturalnocase',
  TRANSFER         TEXT     COLLATE 'naturalnocase',

  -- END Format-specific fields
  log_time_msecs  INTEGER HIDDEN,                    -- The adjusted timestamp for th
2021-12-03T09:18:51.546 D t0 log_vtab_impl.cc:212 creating log format table: logline = 0
2021-12-03T09:18:51.554 I t0 command_executor.cc:137 Executing SQL: UPDATE lnav_views SET top_time = $last_top_time WHERE
  $1 = 'x51' AND
  name = $new_top_view_name AND
  $last_top_time IS NOT NULL;
2021-12-03T09:18:51.554 I t0 command_executor.cc:603 /root/.lnav/formats/default/lnav-pop-view.lnav:16:execute result --
2021-12-03T09:18:51.554 I t0 command_executor.cc:110 Executing: eval :alt-msg ${view_alt_msg}
2021-12-03T09:18:51.554 D t0 lnav_commands.cc:3880 Evaluating: :alt-msg ${view_alt_msg}
2021-12-03T09:18:51.554 D t0 lnav_commands.cc:3887 Expanded command to evaluate: :alt-msg
2021-12-03T09:18:51.554 I t0 command_executor.cc:110 Executing: alt-msg
2021-12-03T09:18:51.554 I t0 command_executor.cc:603 /root/.lnav/formats/default/lnav-pop-view.lnav:20:execute result --
2021-12-03T09:18:51.554 I t0 command_executor.cc:110 Executing: echo
2021-12-03T09:18:51.554 I t0 command_executor.cc:603 /root/.lnav/formats/default/lnav-pop-view.lnav:21:execute result --
2021-12-03T09:18:51.554 I t0 command_executor.cc:864 redirecting command output to screen
2021-12-03T09:18:51.554 D t0 lnav.cc:1831 initial build rebuild
2021-12-03T09:18:51.554 D t0 logfile_sub_source.cc:647 no time left, skipping /rsyslog/filter/executed_logged.log-2021-12-03
2021-12-03T09:18:51.554 I t0 command_executor.cc:659 Executing initial commands
2021-12-03T09:18:51.554 I t0 command_executor.cc:492 Executing file: /root/.lnav-filter-syslog.txt
2021-12-03T09:18:51.554 D t0 log_format_loader.cc:1143 Searching for script in path: /etc/lnav/formats/*/*.lnav
2021-12-03T09:18:51.554 D t0 log_format_loader.cc:1143 Searching for script in path: /usr/etc/lnav/formats/*/*.lnav
2021-12-03T09:18:51.554 D t0 log_format_loader.cc:1143 Searching for script in path: /root/.lnav/formats/*/*.lnav
2021-12-03T09:18:51.554 D t0 log_format_loader.cc:1155   found script: /root/.lnav/formats/default/dhclient-summary.lnav
2021-12-03T09:18:51.554 D t0 log_format_loader.cc:1155   found script: /root/.lnav/formats/default/lnav-pop-view.lnav
2021-12-03T09:18:51.554 D t0 log_format_loader.cc:1155   found script: /root/.lnav/formats/default/partition-by-boot.lnav
2021-12-03T09:18:51.554 D t0 log_format_loader.cc:1155   found script: /root/.lnav/formats/default/rename-stdin.lnav
2021-12-03T09:18:51.554 D t0 log_format_loader.cc:1155   found script: /root/.lnav/formats/default/search-for.lnav
2021-12-03T09:18:51.554 I t0 command_executor.cc:110 Executing: filter-out managed-keys-zone
2021-12-03T09:18:51.554 E t7 lnav_log.cc:604 Assertion failed: has_value() (../../lnav/src/optional.hpp: operator*: 1368)
2021-12-03T09:18:51.554 E t0 lnav_log.cc:394 Received signal: 6
2021-12-03T09:18:51.555 I t0 lnav_log.cc:219 uname:
2021-12-03T09:18:51.555 I t0 lnav_log.cc:220   sysname=Linux
2021-12-03T09:18:51.555 I t0 lnav_log.cc:221   nodename=ult-srv103.int.ultimum.nl
2021-12-03T09:18:51.555 I t0 lnav_log.cc:222   machine=x86_64
2021-12-03T09:18:51.555 I t0 lnav_log.cc:223   release=3.10.0-1160.45.1.el7.x86_64
2021-12-03T09:18:51.555 I t0 lnav_log.cc:224   version=#1 SMP Wed Oct 13 17:20:51 UTC 2021
2021-12-03T09:18:51.555 I t0 lnav_log.cc:225 PCRE:
2021-12-03T09:18:51.555 I t0 lnav_log.cc:226   jit=1
2021-12-03T09:18:51.555 I t0 lnav_log.cc:227   jittarget=x86 64bit (little endian + unaligned)
2021-12-03T09:18:51.555 I t0 lnav_log.cc:228 Environment:
2021-12-03T09:18:51.555 I t0 lnav_log.cc:229   HOME=/root
2021-12-03T09:18:51.555 I t0 lnav_log.cc:230   XDG_CONFIG_HOME=(null)
2021-12-03T09:18:51.555 I t0 lnav_log.cc:231   LANG=en_US.utf8
2021-12-03T09:18:51.555 I t0 lnav_log.cc:232   PATH=/usr/local/sbin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin
2021-12-03T09:18:51.555 I t0 lnav_log.cc:233   TERM=xterm-256color
2021-12-03T09:18:51.555 I t0 lnav_log.cc:234   TZ=(null)
2021-12-03T09:18:51.555 I t0 lnav_log.cc:235 Process:
2021-12-03T09:18:51.555 I t0 lnav_log.cc:236   pid=45125
2021-12-03T09:18:51.555 I t0 lnav_log.cc:237   ppid=45124
2021-12-03T09:18:51.555 I t0 lnav_log.cc:238   pgrp=45123
2021-12-03T09:18:51.555 I t0 lnav_log.cc:239   uid=0
2021-12-03T09:18:51.555 I t0 lnav_log.cc:240   gid=0
2021-12-03T09:18:51.555 I t0 lnav_log.cc:241   euid=0
2021-12-03T09:18:51.555 I t0 lnav_log.cc:242   egid=0
2021-12-03T09:18:51.555 I t0 lnav_log.cc:247   cwd=/rsyslog/filter
2021-12-03T09:18:51.555 I t0 lnav_log.cc:249 Executable:
2021-12-03T09:18:51.555 I t0 lnav_log.cc:250   version=lnav 0.10.1-dirty
2021-12-03T09:18:51.555 I t0 lnav_log.cc:253 rusage:
2021-12-03T09:18:51.555 I t0 lnav_log.cc:253   utime=21.515456
2021-12-03T09:18:51.555 I t0 lnav_log.cc:253   stime=0.947592
2021-12-03T09:18:51.555 I t0 lnav_log.cc:253   maxrss=61504
2021-12-03T09:18:51.555 I t0 lnav_log.cc:253   ixrss=0
2021-12-03T09:18:51.555 I t0 lnav_log.cc:253   idrss=0
2021-12-03T09:18:51.555 I t0 lnav_log.cc:253   isrss=0
2021-12-03T09:18:51.555 I t0 lnav_log.cc:253   minflt=29985
2021-12-03T09:18:51.555 I t0 lnav_log.cc:253   majflt=0
2021-12-03T09:18:51.555 I t0 lnav_log.cc:253   nswap=0
2021-12-03T09:18:51.555 I t0 lnav_log.cc:253   inblock=0
2021-12-03T09:18:51.555 I t0 lnav_log.cc:253   oublock=904
2021-12-03T09:18:51.555 I t0 lnav_log.cc:253   msgsnd=0
2021-12-03T09:18:51.555 I t0 lnav_log.cc:253   msgrcv=0
2021-12-03T09:18:51.555 I t0 lnav_log.cc:253   nsignals=0
2021-12-03T09:18:51.555 I t0 lnav_log.cc:253   nvcsw=165
2021-12-03T09:18:51.555 I t0 lnav_log.cc:253   nivcsw=343
2021-12-03T09:18:51.555 D t0 listview_curses.hh:547 listview_curses=0xed3478
2021-12-03T09:18:51.555 D t0 listview_curses.hh:548   lv_title=
2021-12-03T09:18:51.555 D t0 listview_curses.hh:549   lv_y=56
2021-12-03T09:18:51.555 D t0 listview_curses.hh:550   lv_top=0
2021-12-03T09:18:51.555 D t0 listview_curses.hh:547 listview_curses=0xed3e78
2021-12-03T09:18:51.555 D t0 listview_curses.hh:548   lv_title=
2021-12-03T09:18:51.555 D t0 listview_curses.hh:549   lv_y=0
2021-12-03T09:18:51.555 D t0 listview_curses.hh:550   lv_top=0
2021-12-03T09:18:51.555 D t0 listview_curses.hh:547 listview_curses=0xed4140
2021-12-03T09:18:51.555 D t0 listview_curses.hh:548   lv_title=
2021-12-03T09:18:51.555 D t0 listview_curses.hh:549   lv_y=50
2021-12-03T09:18:51.555 D t0 listview_curses.hh:550   lv_top=0
2021-12-03T09:18:51.555 D t0 listview_curses.hh:547 listview_curses=0xed4458
2021-12-03T09:18:51.555 D t0 listview_curses.hh:548   lv_title=
2021-12-03T09:18:51.555 D t0 listview_curses.hh:549   lv_y=50
2021-12-03T09:18:51.555 D t0 listview_curses.hh:550   lv_top=0
2021-12-03T09:18:51.555 D t0 listview_curses.hh:547 listview_curses=0xed4940
2021-12-03T09:18:51.555 D t0 listview_curses.hh:548   lv_title=
2021-12-03T09:18:51.555 D t0 listview_curses.hh:549   lv_y=56
2021-12-03T09:18:51.555 D t0 listview_curses.hh:550   lv_top=0
2021-12-03T09:18:51.555 D t0 listview_curses.hh:547 listview_curses=0xed4e28
2021-12-03T09:18:51.555 D t0 listview_curses.hh:548   lv_title=
2021-12-03T09:18:51.555 D t0 listview_curses.hh:549   lv_y=56
2021-12-03T09:18:51.555 D t0 listview_curses.hh:550   lv_top=0
2021-12-03T09:18:51.555 D t0 listview_curses.hh:547 listview_curses=0xed5310
2021-12-03T09:18:51.555 D t0 listview_curses.hh:548   lv_title=
2021-12-03T09:18:51.555 D t0 listview_curses.hh:549   lv_y=56
2021-12-03T09:18:51.555 D t0 listview_curses.hh:550   lv_top=0
2021-12-03T09:18:51.555 D t0 listview_curses.hh:547 listview_curses=0xed5648
2021-12-03T09:18:51.555 D t0 listview_curses.hh:548   lv_title=LOG
2021-12-03T09:18:51.555 D t0 listview_curses.hh:549   lv_y=1
2021-12-03T09:18:51.555 D t0 listview_curses.hh:550   lv_top=757886
2021-12-03T09:18:51.555 D t0 listview_curses.hh:547 listview_curses=0xed5908
2021-12-03T09:18:51.555 D t0 listview_curses.hh:548   lv_title=TEXT
2021-12-03T09:18:51.555 D t0 listview_curses.hh:549   lv_y=1
2021-12-03T09:18:51.555 D t0 listview_curses.hh:550   lv_top=0
2021-12-03T09:18:51.555 D t0 listview_curses.hh:547 listview_curses=0xed5bc8
2021-12-03T09:18:51.555 D t0 listview_curses.hh:548   lv_title=HELP
2021-12-03T09:18:51.555 D t0 listview_curses.hh:549   lv_y=1
2021-12-03T09:18:51.555 D t0 listview_curses.hh:550   lv_top=0
2021-12-03T09:18:51.555 D t0 listview_curses.hh:547 listview_curses=0xed5e88
2021-12-03T09:18:51.555 D t0 listview_curses.hh:548   lv_title=HIST
2021-12-03T09:18:51.555 D t0 listview_curses.hh:549   lv_y=1
2021-12-03T09:18:51.555 D t0 listview_curses.hh:550   lv_top=439
2021-12-03T09:18:51.555 D t0 listview_curses.hh:547 listview_curses=0xed6148
2021-12-03T09:18:51.555 D t0 listview_curses.hh:548   lv_title=DB
2021-12-03T09:18:51.555 D t0 listview_curses.hh:549   lv_y=1
2021-12-03T09:18:51.555 D t0 listview_curses.hh:550   lv_top=0
2021-12-03T09:18:51.555 D t0 listview_curses.hh:547 listview_curses=0xed6408
2021-12-03T09:18:51.555 D t0 listview_curses.hh:548   lv_title=SCHEMA
2021-12-03T09:18:51.555 D t0 listview_curses.hh:549   lv_y=1
2021-12-03T09:18:51.555 D t0 listview_curses.hh:550   lv_top=0
2021-12-03T09:18:51.555 D t0 listview_curses.hh:547 listview_curses=0xed66c8
2021-12-03T09:18:51.555 D t0 listview_curses.hh:548   lv_title=PRETTY
2021-12-03T09:18:51.555 D t0 listview_curses.hh:549   lv_y=1
2021-12-03T09:18:51.555 D t0 listview_curses.hh:550   lv_top=0
2021-12-03T09:18:51.555 D t0 listview_curses.hh:547 listview_curses=0xed6988
2021-12-03T09:18:51.555 D t0 listview_curses.hh:548   lv_title=SPECTRO
2021-12-03T09:18:51.555 D t0 listview_curses.hh:549   lv_y=1
2021-12-03T09:18:51.555 D t0 listview_curses.hh:550   lv_top=0
2021-12-03T09:18:51.555 I t0 lnav.hh:151 recent_key_presses: index=1
 0x51 (Q) 0x0 () 0x0 () 0x0 () 0x0 () 0x0 () 0x0 () 0x0 () 0x0 () 0x0 ()
Reply all
Reply to author
Forward
0 new messages