Attachment 1478353 Details for Bug 1621912 – Crash file (3)

Crash file (3)

crash-2018-08-23-14-51-49.28037.log (text/plain), 78.83 KB, created by Mike on 2018-08-23 21:00:37 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Mike

Created: 2018-08-23 21:00:37 UTC

Size: 78.83 KB

patch

obsolete

>2018-08-23T14:51:49.415 E lnav_config.cc:102 syscall failed `mkdir(path.c_str(), 0755)' -- File exists
>2018-08-23T14:51:49.415 E lnav_config.cc:107 syscall failed `mkdir(path.c_str(), 0755)' -- File exists
>2018-08-23T14:51:49.415 E lnav_config.cc:112 syscall failed `mkdir(path.c_str(), 0755)' -- File exists
>2018-08-23T14:51:49.415 E lnav_config.cc:117 syscall failed `mkdir(path.c_str(), 0755)' -- File exists
>2018-08-23T14:51:49.415 E lnav_config.cc:136 syscall failed `mkdir(path.c_str(), 0755)' -- File exists
>2018-08-23T14:51:49.415 I lnav.cc:3061 lnav started
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help end
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help else
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help when
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help set
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help update
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help recursive
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help limit
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help order by
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help likely
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help rtrim
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help from
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help like
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help ifnull
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help sqlite_version
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help reverse
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help coalesce
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help typeof
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help changes
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help select
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help printf
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help timediff
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help lower
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help with
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help realpath
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help case
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help readlink
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help extract
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help abs
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help nullif
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help time
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help jget
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help rightstr
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help randomblob
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help sum
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help log_top_datetime
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help dirname
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help length
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help round
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help detach
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help last_insert_rowid
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help likelihood
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help glob
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help sqlite_compileoption_used
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help gethostbyaddr
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help basename
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help regexp
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help as
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help regexp_match
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help hex
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help replace
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help endswith
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help regexp_replace
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help startswith
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help strftime
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help timeslice
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help ltrim
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help max
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help instr
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help random
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help gethostbyname
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help min
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help count
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help sqlite_compileoption_get
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help sqlite_source_id
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help julianday
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help substr
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help total_changes
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help zeroblob
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help datetime
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help trim
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help char
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help quote
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help unicode
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help unlikely
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help load_extension
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help joinpath
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help upper
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help database
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help log_top_line
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help group by
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help leftstr
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help date
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help avg
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help group_concat
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help total
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help attach
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help cast
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help replicate
>2018-08-23T14:51:49.415 D sqlite-extension-func.cc:569 help where
>2018-08-23T14:51:49.416 D log_format_loader.cc:817 Loading default formats
>2018-08-23T14:51:49.416 D log_format_loader.cc:81 Loading format -- access_log
>2018-08-23T14:51:49.417 D log_format_loader.cc:81 Loading format -- autodeploy_log
>2018-08-23T14:51:49.417 D log_format_loader.cc:81 Loading format -- block_log
>2018-08-23T14:51:49.417 D log_format_loader.cc:81 Loading format -- candlepin_log
>2018-08-23T14:51:49.417 D log_format_loader.cc:81 Loading format -- choose_repo_log
>2018-08-23T14:51:49.417 D log_format_loader.cc:81 Loading format -- cups_log
>2018-08-23T14:51:49.417 D log_format_loader.cc:81 Loading format -- dpkg_log
>2018-08-23T14:51:49.417 D log_format_loader.cc:81 Loading format -- elb_log
>2018-08-23T14:51:49.417 D log_format_loader.cc:81 Loading format -- engine_log
>2018-08-23T14:51:49.417 D log_format_loader.cc:81 Loading format -- error_log
>2018-08-23T14:51:49.417 D log_format_loader.cc:81 Loading format -- fsck_hfs_log
>2018-08-23T14:51:49.417 D log_format_loader.cc:81 Loading format -- glog_log
>2018-08-23T14:51:49.417 D log_format_loader.cc:81 Loading format -- java_log
>2018-08-23T14:51:49.417 D log_format_loader.cc:81 Loading format -- katello_log
>2018-08-23T14:51:49.417 D log_format_loader.cc:81 Loading format -- openam_log
>2018-08-23T14:51:49.417 D log_format_loader.cc:81 Loading format -- openamdb_log
>2018-08-23T14:51:49.417 D log_format_loader.cc:81 Loading format -- openstack_log
>2018-08-23T14:51:49.418 D log_format_loader.cc:81 Loading format -- page_log
>2018-08-23T14:51:49.418 D log_format_loader.cc:81 Loading format -- papertrail_log
>2018-08-23T14:51:49.418 D log_format_loader.cc:81 Loading format -- snaplogic_log
>2018-08-23T14:51:49.418 D log_format_loader.cc:81 Loading format -- sssd_log
>2018-08-23T14:51:49.418 D log_format_loader.cc:81 Loading format -- strace_log
>2018-08-23T14:51:49.418 D log_format_loader.cc:81 Loading format -- sudo_log
>2018-08-23T14:51:49.418 D log_format_loader.cc:81 Loading format -- syslog_log
>2018-08-23T14:51:49.418 D log_format_loader.cc:81 Loading format -- tcf_log
>2018-08-23T14:51:49.418 D log_format_loader.cc:81 Loading format -- tcsh_history
>2018-08-23T14:51:49.418 D log_format_loader.cc:81 Loading format -- uwsgi_log
>2018-08-23T14:51:49.418 D log_format_loader.cc:81 Loading format -- vdsm_log
>2018-08-23T14:51:49.419 D log_format_loader.cc:81 Loading format -- vmk_log
>2018-08-23T14:51:49.419 D log_format_loader.cc:81 Loading format -- vmw_log
>2018-08-23T14:51:49.419 D log_format_loader.cc:81 Loading format -- xmlrpc_log
>2018-08-23T14:51:49.419 I log_format_loader.cc:785 loading formats from path: /etc/lnav/formats/*/*.json
>2018-08-23T14:51:49.419 I log_format_loader.cc:785 loading formats from path: /etc/lnav/formats/*/*.json
>2018-08-23T14:51:49.419 I log_format_loader.cc:785 loading formats from path: /root/.lnav//formats/*/*.json
>2018-08-23T14:51:49.420 W log_format.cc:1449 block_log/regex/std:level field 'level' not found in pattern
>2018-08-23T14:51:49.420 W log_format.cc:1449 candlepin_log/regex/other:level field 'level' not found in pattern
>2018-08-23T14:51:49.420 W log_format.cc:1449 candlepin_log/regex/reqorg:level field 'level' not found in pattern
>2018-08-23T14:51:49.420 W log_format_loader.cc:870 Format collision, format 'cups_log' matches sample from 'error_log'
>2018-08-23T14:51:49.421 W log_format.cc:1449 dpkg_log/regex/std:level field 'level' not found in pattern
>2018-08-23T14:51:49.421 E pcrepp.hh:500 pcre err -8
>2018-08-23T14:51:49.421 W log_format_loader.cc:870 Format collision, format 'engine_log' matches sample from 'vdsm_log'
>2018-08-23T14:51:49.421 W log_format_loader.cc:870 Format collision, format 'error_log' matches sample from 'cups_log'
>2018-08-23T14:51:49.421 W log_format.cc:1449 fsck_hfs_log/regex/std:level field 'level' not found in pattern
>2018-08-23T14:51:49.422 W log_format.cc:1460 katello_log/regex/log:body field 'body' not found in pattern
>2018-08-23T14:51:49.422 W log_format.cc:1449 openamdb_log/regex/std:level field 'level' not found in pattern
>2018-08-23T14:51:49.422 W log_format.cc:1449 page_log/regex/1.7:level field 'level' not found in pattern
>2018-08-23T14:51:49.422 W log_format.cc:1449 page_log/regex/pre-1.7:level field 'level' not found in pattern
>2018-08-23T14:51:49.423 W log_format.cc:1449 sssd_log/regex/core:level field 'level' not found in pattern
>2018-08-23T14:51:49.423 W log_format.cc:1449 sssd_log/regex/module:level field 'level' not found in pattern
>2018-08-23T14:51:49.423 W log_format.cc:1460 sudo_log/regex/std:body field 'body' not found in pattern
>2018-08-23T14:51:49.423 W log_format.cc:1449 tcf_log/regex/std:level field 'level' not found in pattern
>2018-08-23T14:51:49.423 W log_format.cc:1449 tcsh_history/regex/std:level field 'level' not found in pattern
>2018-08-23T14:51:49.424 W log_format.cc:1449 xmlrpc_log/regex/main:level field 'level' not found in pattern
>2018-08-23T14:51:49.424 W log_format_loader.cc:902 Detected a cycle...
>2018-08-23T14:51:49.424 W log_format_loader.cc:910   Skipping builtin format -- cups_log
>2018-08-23T14:51:49.424 W log_format_loader.cc:910   Skipping builtin format -- error_log
>2018-08-23T14:51:49.424 I log_format_loader.cc:936 Format order:
>2018-08-23T14:51:49.424 I log_format_loader.cc:940   access_log
>2018-08-23T14:51:49.424 I log_format_loader.cc:940   autodeploy_log
>2018-08-23T14:51:49.424 I log_format_loader.cc:940   block_log
>2018-08-23T14:51:49.424 I log_format_loader.cc:940   candlepin_log
>2018-08-23T14:51:49.424 I log_format_loader.cc:940   choose_repo_log
>2018-08-23T14:51:49.424 I log_format_loader.cc:940   dpkg_log
>2018-08-23T14:51:49.424 I log_format_loader.cc:940   elb_log
>2018-08-23T14:51:49.424 I log_format_loader.cc:940   fsck_hfs_log
>2018-08-23T14:51:49.424 I log_format_loader.cc:940   glog_log
>2018-08-23T14:51:49.424 I log_format_loader.cc:940   java_log
>2018-08-23T14:51:49.424 I log_format_loader.cc:940   katello_log
>2018-08-23T14:51:49.424 I log_format_loader.cc:940   openam_log
>2018-08-23T14:51:49.424 I log_format_loader.cc:940   openamdb_log
>2018-08-23T14:51:49.424 I log_format_loader.cc:940   openstack_log
>2018-08-23T14:51:49.424 I log_format_loader.cc:940   page_log
>2018-08-23T14:51:49.424 I log_format_loader.cc:940   papertrail_log
>2018-08-23T14:51:49.424 I log_format_loader.cc:940   snaplogic_log
>2018-08-23T14:51:49.424 I log_format_loader.cc:940   sssd_log
>2018-08-23T14:51:49.424 I log_format_loader.cc:940   strace_log
>2018-08-23T14:51:49.424 I log_format_loader.cc:940   sudo_log
>2018-08-23T14:51:49.424 I log_format_loader.cc:940   syslog_log
>2018-08-23T14:51:49.424 I log_format_loader.cc:940   tcf_log
>2018-08-23T14:51:49.424 I log_format_loader.cc:940   tcsh_history
>2018-08-23T14:51:49.424 I log_format_loader.cc:940   uwsgi_log
>2018-08-23T14:51:49.424 I log_format_loader.cc:940   vdsm_log
>2018-08-23T14:51:49.424 I log_format_loader.cc:940   vmk_log
>2018-08-23T14:51:49.424 I log_format_loader.cc:940   vmw_log
>2018-08-23T14:51:49.424 I log_format_loader.cc:940   xmlrpc_log
>2018-08-23T14:51:49.424 I log_format_loader.cc:940   engine_log
>2018-08-23T14:51:49.424 I log_format_loader.cc:940   cups_log
>2018-08-23T14:51:49.424 I log_format_loader.cc:940   error_log
>2018-08-23T14:51:49.425 D log_vtab_impl.cc:111 log_vtab_impl.get_table_statement() -> CREATE TABLE all_logs (
>  log_line        INTEGER  PRIMARY KEY,
>  log_part        TEXT     COLLATE naturalnocase,
>  log_time        DATETIME,
>  log_actual_time DATETIME HIDDEN,
>  log_idle_msecs  INTEGER,
>  log_level       TEXT     COLLATE loglevel,
>  log_mark        BOOLEAN,
>  -- BEGIN Format-specific fields:
>  log_format      TEXT     COLLATE 'BINARY'       ,
>  log_msg_format  TEXT     COLLATE 'BINARY'       ,
>  log_msg_schema  TEXT    hidden COLLATE 'BINARY'       ,
>  -- END Format-specific fields
>  log_path        TEXT HIDDEN COLLATE naturalnocase,
>  log_text        TEXT HIDDEN,
>  log_body        TEXT HIDDEN
>);
>
>2018-08-23T14:51:49.425 D log_vtab_impl.cc:193 creating log format table: all_logs = 0x5571b0e99c38
>2018-08-23T14:51:49.425 D log_vtab_impl.cc:111 log_vtab_impl.get_table_statement() -> CREATE TABLE generic_log (
>  log_line        INTEGER  PRIMARY KEY,
>  log_part        TEXT     COLLATE naturalnocase,
>  log_time        DATETIME,
>  log_actual_time DATETIME HIDDEN,
>  log_idle_msecs  INTEGER,
>  log_level       TEXT     COLLATE loglevel,
>  log_mark        BOOLEAN,
>  -- BEGIN Format-specific fields:
>  -- END Format-specific fields
>  log_path        TEXT HIDDEN COLLATE naturalnocase,
>  log_text        TEXT HIDDEN,
>  log_body        TEXT HIDDEN
>);
>
>2018-08-23T14:51:49.425 D log_vtab_impl.cc:193 creating log format table: generic_log = 0x5571b0e4d988
>2018-08-23T14:51:49.425 D log_vtab_impl.cc:111 log_vtab_impl.get_table_statement() -> CREATE TABLE access_log (
>  log_line        INTEGER  PRIMARY KEY,
>  log_part        TEXT     COLLATE naturalnocase,
>  log_time        DATETIME,
>  log_actual_time DATETIME HIDDEN,
>  log_idle_msecs  INTEGER,
>  log_level       TEXT     COLLATE loglevel,
>  log_mark        BOOLEAN,
>  -- 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
>  -- END Format-specific fields
>  log_path        TEXT HIDDEN COLLATE naturalnocase,
>  log_text        TEXT HIDDEN,
>  log_body        TEXT HIDDEN
>);
>
>2018-08-23T14:51:49.425 D log_vtab_impl.cc:193 creating log format table: access_log = 0x5571b0e9f468
>2018-08-23T14:51:49.425 D log_vtab_impl.cc:111 log_vtab_impl.get_table_statement() -> CREATE TABLE autodeploy_log (
>  log_line        INTEGER  PRIMARY KEY,
>  log_part        TEXT     COLLATE naturalnocase,
>  log_time        DATETIME,
>  log_actual_time DATETIME HIDDEN,
>  log_idle_msecs  INTEGER,
>  log_level       TEXT     COLLATE loglevel,
>  log_mark        BOOLEAN,
>  -- 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_path        TEXT HIDDEN COLLATE naturalnocase,
>  log_text        TEXT HIDDEN,
>  log_body        TEXT HIDDEN
>);
>
>2018-08-23T14:51:49.425 D log_vtab_impl.cc:193 creating log format table: autodeploy_log = 0x5571b0ea4a08
>2018-08-23T14:51:49.425 D log_vtab_impl.cc:111 log_vtab_impl.get_table_statement() -> CREATE TABLE block_log (
>  log_line        INTEGER  PRIMARY KEY,
>  log_part        TEXT     COLLATE naturalnocase,
>  log_time        DATETIME,
>  log_actual_time DATETIME HIDDEN,
>  log_idle_msecs  INTEGER,
>  log_level       TEXT     COLLATE loglevel,
>  log_mark        BOOLEAN,
>  -- BEGIN Format-specific fields:
>  -- END Format-specific fields
>  log_path        TEXT HIDDEN COLLATE naturalnocase,
>  log_text        TEXT HIDDEN,
>  log_body        TEXT HIDDEN
>);
>
>2018-08-23T14:51:49.425 D log_vtab_impl.cc:193 creating log format table: block_log = 0x5571b0ea76e8
>2018-08-23T14:51:49.425 D log_vtab_impl.cc:111 log_vtab_impl.get_table_statement() -> CREATE TABLE candlepin_log (
>  log_line        INTEGER  PRIMARY KEY,
>  log_part        TEXT     COLLATE naturalnocase,
>  log_time        DATETIME,
>  log_actual_time DATETIME HIDDEN,
>  log_idle_msecs  INTEGER,
>  log_level       TEXT     COLLATE loglevel,
>  log_mark        BOOLEAN,
>  -- 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_path        TEXT HIDDEN COLLATE naturalnocase,
>  log_text        TEXT HIDDEN,
>  log_body        TEXT HIDDEN
>);
>
>2018-08-23T14:51:49.425 D log_vtab_impl.cc:193 creating log format table: candlepin_log = 0x5571b0ea7d28
>2018-08-23T14:51:49.425 D log_vtab_impl.cc:111 log_vtab_impl.get_table_statement() -> CREATE TABLE choose_repo_log (
>  log_line        INTEGER  PRIMARY KEY,
>  log_part        TEXT     COLLATE naturalnocase,
>  log_time        DATETIME,
>  log_actual_time DATETIME HIDDEN,
>  log_idle_msecs  INTEGER,
>  log_level       TEXT     COLLATE loglevel,
>  log_mark        BOOLEAN,
>  -- BEGIN Format-specific fields:
>  -- END Format-specific fields
>  log_path        TEXT HIDDEN COLLATE naturalnocase,
>  log_text        TEXT HIDDEN,
>  log_body        TEXT HIDDEN
>);
>
>2018-08-23T14:51:49.425 D log_vtab_impl.cc:193 creating log format table: choose_repo_log = 0x5571b0ea95b8
>2018-08-23T14:51:49.425 D log_vtab_impl.cc:111 log_vtab_impl.get_table_statement() -> CREATE TABLE dpkg_log (
>  log_line        INTEGER  PRIMARY KEY,
>  log_part        TEXT     COLLATE naturalnocase,
>  log_time        DATETIME,
>  log_actual_time DATETIME HIDDEN,
>  log_idle_msecs  INTEGER,
>  log_level       TEXT     COLLATE loglevel,
>  log_mark        BOOLEAN,
>  -- 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_path        TEXT HIDDEN COLLATE naturalnocase,
>  log_text        TEXT HIDDEN,
>  log_body        TEXT HIDDEN
>);
>
>2018-08-23T14:51:49.425 D log_vtab_impl.cc:193 creating log format table: dpkg_log = 0x5571b0e97e98
>2018-08-23T14:51:49.425 D log_vtab_impl.cc:111 log_vtab_impl.get_table_statement() -> CREATE TABLE elb_log (
>  log_line        INTEGER  PRIMARY KEY,
>  log_part        TEXT     COLLATE naturalnocase,
>  log_time        DATETIME,
>  log_actual_time DATETIME HIDDEN,
>  log_idle_msecs  INTEGER,
>  log_level       TEXT     COLLATE loglevel,
>  log_mark        BOOLEAN,
>  -- 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  COLLATE 'BINARY'       ,
>  ssl_cipher               TEXT     COLLATE 'BINARY'       ,
>  ssl_protocol             TEXT     COLLATE 'BINARY'       ,
>  user_agent               TEXT     COLLATE 'BINARY'       ,
>  -- END Format-specific fields
>  log_path        TEXT HIDDEN COLLATE naturalnocase,
>  log_text        TEXT HIDDEN,
>  log_body        TEXT HIDDEN
>);
>
>2018-08-23T14:51:49.426 D log_vtab_impl.cc:193 creating log format table: elb_log = 0x5571b0ead158
>2018-08-23T14:51:49.426 D log_vtab_impl.cc:111 log_vtab_impl.get_table_statement() -> CREATE TABLE fsck_hfs_log (
>  log_line        INTEGER  PRIMARY KEY,
>  log_part        TEXT     COLLATE naturalnocase,
>  log_time        DATETIME,
>  log_actual_time DATETIME HIDDEN,
>  log_idle_msecs  INTEGER,
>  log_level       TEXT     COLLATE loglevel,
>  log_mark        BOOLEAN,
>  -- BEGIN Format-specific fields:
>  device          TEXT     COLLATE 'BINARY'       ,
>  -- END Format-specific fields
>  log_path        TEXT HIDDEN COLLATE naturalnocase,
>  log_text        TEXT HIDDEN,
>  log_body        TEXT HIDDEN
>);
>
>2018-08-23T14:51:49.426 D log_vtab_impl.cc:193 creating log format table: fsck_hfs_log = 0x5571b0eb0698
>2018-08-23T14:51:49.426 D log_vtab_impl.cc:111 log_vtab_impl.get_table_statement() -> CREATE TABLE glog_log (
>  log_line        INTEGER  PRIMARY KEY,
>  log_part        TEXT     COLLATE naturalnocase,
>  log_time        DATETIME,
>  log_actual_time DATETIME HIDDEN,
>  log_idle_msecs  INTEGER,
>  log_level       TEXT     COLLATE loglevel,
>  log_mark        BOOLEAN,
>  -- BEGIN Format-specific fields:
>  src_file        TEXT     COLLATE 'BINARY'       ,
>  src_line        INTEGER  COLLATE 'BINARY'       ,
>  thread          INTEGER  COLLATE 'BINARY'       ,
>  -- END Format-specific fields
>  log_path        TEXT HIDDEN COLLATE naturalnocase,
>  log_text        TEXT HIDDEN,
>  log_body        TEXT HIDDEN
>);
>
>2018-08-23T14:51:49.426 D log_vtab_impl.cc:193 creating log format table: glog_log = 0x5571b0eaa7d8
>2018-08-23T14:51:49.426 D log_vtab_impl.cc:111 log_vtab_impl.get_table_statement() -> CREATE TABLE java_log (
>  log_line        INTEGER  PRIMARY KEY,
>  log_part        TEXT     COLLATE naturalnocase,
>  log_time        DATETIME,
>  log_actual_time DATETIME HIDDEN,
>  log_idle_msecs  INTEGER,
>  log_level       TEXT     COLLATE loglevel,
>  log_mark        BOOLEAN,
>  -- 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_path        TEXT HIDDEN COLLATE naturalnocase,
>  log_text        TEXT HIDDEN,
>  log_body        TEXT HIDDEN
>);
>
>2018-08-23T14:51:49.426 D log_vtab_impl.cc:193 creating log format table: java_log = 0x5571b0eb2c08
>2018-08-23T14:51:49.426 D log_vtab_impl.cc:111 log_vtab_impl.get_table_statement() -> CREATE TABLE katello_log (
>  log_line        INTEGER  PRIMARY KEY,
>  log_part        TEXT     COLLATE naturalnocase,
>  log_time        DATETIME,
>  log_actual_time DATETIME HIDDEN,
>  log_idle_msecs  INTEGER,
>  log_level       TEXT     COLLATE loglevel,
>  log_mark        BOOLEAN,
>  -- BEGIN Format-specific fields:
>  alert_level     TEXT     COLLATE 'BINARY'       ,
>  message         TEXT     COLLATE 'BINARY'       ,
>  module          TEXT     COLLATE 'BINARY'       ,
>  -- END Format-specific fields
>  log_path        TEXT HIDDEN COLLATE naturalnocase,
>  log_text        TEXT HIDDEN,
>  log_body        TEXT HIDDEN
>);
>
>2018-08-23T14:51:49.426 D log_vtab_impl.cc:193 creating log format table: katello_log = 0x5571b0eb1498
>2018-08-23T14:51:49.426 D log_vtab_impl.cc:111 log_vtab_impl.get_table_statement() -> CREATE TABLE openam_log (
>  log_line        INTEGER  PRIMARY KEY,
>  log_part        TEXT     COLLATE naturalnocase,
>  log_time        DATETIME,
>  log_actual_time DATETIME HIDDEN,
>  log_idle_msecs  INTEGER,
>  log_level       TEXT     COLLATE loglevel,
>  log_mark        BOOLEAN,
>  -- 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_path        TEXT HIDDEN COLLATE naturalnocase,
>  log_text        TEXT HIDDEN,
>  log_body        TEXT HIDDEN
>);
>
>2018-08-23T14:51:49.426 D log_vtab_impl.cc:193 creating log format table: openam_log = 0x5571b0eb45f8
>2018-08-23T14:51:49.426 D log_vtab_impl.cc:111 log_vtab_impl.get_table_statement() -> CREATE TABLE openamdb_log (
>  log_line        INTEGER  PRIMARY KEY,
>  log_part        TEXT     COLLATE naturalnocase,
>  log_time        DATETIME,
>  log_actual_time DATETIME HIDDEN,
>  log_idle_msecs  INTEGER,
>  log_level       TEXT     COLLATE loglevel,
>  log_mark        BOOLEAN,
>  -- BEGIN Format-specific fields:
>  -- END Format-specific fields
>  log_path        TEXT HIDDEN COLLATE naturalnocase,
>  log_text        TEXT HIDDEN,
>  log_body        TEXT HIDDEN
>);
>
>2018-08-23T14:51:49.426 D log_vtab_impl.cc:193 creating log format table: openamdb_log = 0x5571b0eb6228
>2018-08-23T14:51:49.426 D log_vtab_impl.cc:111 log_vtab_impl.get_table_statement() -> CREATE TABLE openstack_log (
>  log_line        INTEGER  PRIMARY KEY,
>  log_part        TEXT     COLLATE naturalnocase,
>  log_time        DATETIME,
>  log_actual_time DATETIME HIDDEN,
>  log_idle_msecs  INTEGER,
>  log_level       TEXT     COLLATE loglevel,
>  log_mark        BOOLEAN,
>  -- BEGIN Format-specific fields:
>  logger          TEXT     COLLATE 'BINARY'       ,
>  pid             TEXT     COLLATE 'BINARY'       ,
>  tid             TEXT     COLLATE 'BINARY'       ,
>  -- END Format-specific fields
>  log_path        TEXT HIDDEN COLLATE naturalnocase,
>  log_text        TEXT HIDDEN,
>  log_body        TEXT HIDDEN
>);
>
>2018-08-23T14:51:49.426 D log_vtab_impl.cc:193 creating log format table: openstack_log = 0x5571b0eba428
>2018-08-23T14:51:49.426 D log_vtab_impl.cc:111 log_vtab_impl.get_table_statement() -> CREATE TABLE page_log (
>  log_line        INTEGER  PRIMARY KEY,
>  log_part        TEXT     COLLATE naturalnocase,
>  log_time        DATETIME,
>  log_actual_time DATETIME HIDDEN,
>  log_idle_msecs  INTEGER,
>  log_level       TEXT     COLLATE loglevel,
>  log_mark        BOOLEAN,
>  -- 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_path        TEXT HIDDEN COLLATE naturalnocase,
>  log_text        TEXT HIDDEN,
>  log_body        TEXT HIDDEN
>);
>
>2018-08-23T14:51:49.426 D log_vtab_impl.cc:193 creating log format table: page_log = 0x5571b0eb8fc8
>2018-08-23T14:51:49.426 D log_vtab_impl.cc:111 log_vtab_impl.get_table_statement() -> CREATE TABLE papertrail_log (
>  log_line        INTEGER  PRIMARY KEY,
>  log_part        TEXT     COLLATE naturalnocase,
>  log_time        DATETIME,
>  log_actual_time DATETIME HIDDEN,
>  log_idle_msecs  INTEGER,
>  log_level       TEXT     COLLATE loglevel,
>  log_mark        BOOLEAN,
>  -- BEGIN Format-specific fields:
>  display_received_at TEXT     COLLATE 'BINARY'       ,
>  hostname            TEXT     COLLATE 'BINARY'       ,
>  program             TEXT     COLLATE 'BINARY'       ,
>  -- END Format-specific fields
>  log_path        TEXT HIDDEN COLLATE naturalnocase,
>  log_text        TEXT HIDDEN,
>  log_body        TEXT HIDDEN
>);
>
>2018-08-23T14:51:49.426 D log_vtab_impl.cc:193 creating log format table: papertrail_log = 0x5571b0ebde68
>2018-08-23T14:51:49.426 D log_vtab_impl.cc:111 log_vtab_impl.get_table_statement() -> CREATE TABLE snaplogic_log (
>  log_line        INTEGER  PRIMARY KEY,
>  log_part        TEXT     COLLATE naturalnocase,
>  log_time        DATETIME,
>  log_actual_time DATETIME HIDDEN,
>  log_idle_msecs  INTEGER,
>  log_level       TEXT     COLLATE loglevel,
>  log_mark        BOOLEAN,
>  -- 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_path        TEXT HIDDEN COLLATE naturalnocase,
>  log_text        TEXT HIDDEN,
>  log_body        TEXT HIDDEN
>);
>
>2018-08-23T14:51:49.426 D log_vtab_impl.cc:193 creating log format table: snaplogic_log = 0x5571b0ebbcc8
>2018-08-23T14:51:49.426 D log_vtab_impl.cc:111 log_vtab_impl.get_table_statement() -> CREATE TABLE sssd_log (
>  log_line        INTEGER  PRIMARY KEY,
>  log_part        TEXT     COLLATE naturalnocase,
>  log_time        DATETIME,
>  log_actual_time DATETIME HIDDEN,
>  log_idle_msecs  INTEGER,
>  log_level       TEXT     COLLATE loglevel,
>  log_mark        BOOLEAN,
>  -- BEGIN Format-specific fields:
>  debug_level     TEXT     COLLATE 'BINARY'       ,
>  function        TEXT     COLLATE 'BINARY'       ,
>  module          TEXT     COLLATE 'BINARY'       ,
>  -- END Format-specific fields
>  log_path        TEXT HIDDEN COLLATE naturalnocase,
>  log_text        TEXT HIDDEN,
>  log_body        TEXT HIDDEN
>);
>
>2018-08-23T14:51:49.426 D log_vtab_impl.cc:193 creating log format table: sssd_log = 0x5571b0eaba88
>2018-08-23T14:51:49.426 D log_vtab_impl.cc:111 log_vtab_impl.get_table_statement() -> CREATE TABLE strace_log (
>  log_line        INTEGER  PRIMARY KEY,
>  log_part        TEXT     COLLATE naturalnocase,
>  log_time        DATETIME,
>  log_actual_time DATETIME HIDDEN,
>  log_idle_msecs  INTEGER,
>  log_level       TEXT     COLLATE loglevel,
>  log_mark        BOOLEAN,
>  -- 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_path        TEXT HIDDEN COLLATE naturalnocase,
>  log_text        TEXT HIDDEN,
>  log_body        TEXT HIDDEN
>);
>
>2018-08-23T14:51:49.427 D log_vtab_impl.cc:193 creating log format table: strace_log = 0x5571b0ec2728
>2018-08-23T14:51:49.427 D log_vtab_impl.cc:111 log_vtab_impl.get_table_statement() -> CREATE TABLE sudo_log (
>  log_line        INTEGER  PRIMARY KEY,
>  log_part        TEXT     COLLATE naturalnocase,
>  log_time        DATETIME,
>  log_actual_time DATETIME HIDDEN,
>  log_idle_msecs  INTEGER,
>  log_level       TEXT     COLLATE loglevel,
>  log_mark        BOOLEAN,
>  -- 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_path        TEXT HIDDEN COLLATE naturalnocase,
>  log_text        TEXT HIDDEN,
>  log_body        TEXT HIDDEN
>);
>
>2018-08-23T14:51:49.427 D log_vtab_impl.cc:193 creating log format table: sudo_log = 0x5571b0ec4388
>2018-08-23T14:51:49.427 D log_vtab_impl.cc:111 log_vtab_impl.get_table_statement() -> CREATE TABLE syslog_log (
>  log_line        INTEGER  PRIMARY KEY,
>  log_part        TEXT     COLLATE naturalnocase,
>  log_time        DATETIME,
>  log_actual_time DATETIME HIDDEN,
>  log_idle_msecs  INTEGER,
>  log_level       TEXT     COLLATE loglevel,
>  log_mark        BOOLEAN,
>  -- 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_path        TEXT HIDDEN COLLATE naturalnocase,
>  log_text        TEXT HIDDEN,
>  log_body        TEXT HIDDEN
>);
>
>2018-08-23T14:51:49.427 D log_vtab_impl.cc:193 creating log format table: syslog_log = 0x5571b0ec6248
>2018-08-23T14:51:49.427 D log_vtab_impl.cc:111 log_vtab_impl.get_table_statement() -> CREATE TABLE tcf_log (
>  log_line        INTEGER  PRIMARY KEY,
>  log_part        TEXT     COLLATE naturalnocase,
>  log_time        DATETIME,
>  log_actual_time DATETIME HIDDEN,
>  log_idle_msecs  INTEGER,
>  log_level       TEXT     COLLATE loglevel,
>  log_mark        BOOLEAN,
>  -- 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_path        TEXT HIDDEN COLLATE naturalnocase,
>  log_text        TEXT HIDDEN,
>  log_body        TEXT HIDDEN
>);
>
>2018-08-23T14:51:49.427 D log_vtab_impl.cc:193 creating log format table: tcf_log = 0x5571b0ec1f38
>2018-08-23T14:51:49.427 D log_vtab_impl.cc:111 log_vtab_impl.get_table_statement() -> CREATE TABLE tcsh_history (
>  log_line        INTEGER  PRIMARY KEY,
>  log_part        TEXT     COLLATE naturalnocase,
>  log_time        DATETIME,
>  log_actual_time DATETIME HIDDEN,
>  log_idle_msecs  INTEGER,
>  log_level       TEXT     COLLATE loglevel,
>  log_mark        BOOLEAN,
>  -- BEGIN Format-specific fields:
>  -- END Format-specific fields
>  log_path        TEXT HIDDEN COLLATE naturalnocase,
>  log_text        TEXT HIDDEN,
>  log_body        TEXT HIDDEN
>);
>
>2018-08-23T14:51:49.427 D log_vtab_impl.cc:193 creating log format table: tcsh_history = 0x5571b0eca988
>2018-08-23T14:51:49.427 D log_vtab_impl.cc:111 log_vtab_impl.get_table_statement() -> CREATE TABLE uwsgi_log (
>  log_line        INTEGER  PRIMARY KEY,
>  log_part        TEXT     COLLATE naturalnocase,
>  log_time        DATETIME,
>  log_actual_time DATETIME HIDDEN,
>  log_idle_msecs  INTEGER,
>  log_level       TEXT     COLLATE loglevel,
>  log_mark        BOOLEAN,
>  -- 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'       ,
>  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'       ,
>  sc_status       INTEGER  COLLATE 'BINARY'       ,
>  -- END Format-specific fields
>  log_path        TEXT HIDDEN COLLATE naturalnocase,
>  log_text        TEXT HIDDEN,
>  log_body        TEXT HIDDEN
>);
>
>2018-08-23T14:51:49.427 D log_vtab_impl.cc:193 creating log format table: uwsgi_log = 0x5571b0e6c678
>2018-08-23T14:51:49.427 D log_vtab_impl.cc:111 log_vtab_impl.get_table_statement() -> CREATE TABLE vdsm_log (
>  log_line        INTEGER  PRIMARY KEY,
>  log_part        TEXT     COLLATE naturalnocase,
>  log_time        DATETIME,
>  log_actual_time DATETIME HIDDEN,
>  log_idle_msecs  INTEGER,
>  log_level       TEXT     COLLATE loglevel,
>  log_mark        BOOLEAN,
>  -- 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_path        TEXT HIDDEN COLLATE naturalnocase,
>  log_text        TEXT HIDDEN,
>  log_body        TEXT HIDDEN
>);
>
>2018-08-23T14:51:49.427 D log_vtab_impl.cc:193 creating log format table: vdsm_log = 0x5571b0ec8768
>2018-08-23T14:51:49.427 D log_vtab_impl.cc:111 log_vtab_impl.get_table_statement() -> CREATE TABLE vmk_log (
>  log_line        INTEGER  PRIMARY KEY,
>  log_part        TEXT     COLLATE naturalnocase,
>  log_time        DATETIME,
>  log_actual_time DATETIME HIDDEN,
>  log_idle_msecs  INTEGER,
>  log_level       TEXT     COLLATE loglevel,
>  log_mark        BOOLEAN,
>  -- BEGIN Format-specific fields:
>  cpu             INTEGER  COLLATE 'BINARY'       ,
>  subsystem       TEXT     COLLATE 'BINARY'       ,
>  world_id        INTEGER  COLLATE 'BINARY'       ,
>  -- END Format-specific fields
>  log_path        TEXT HIDDEN COLLATE naturalnocase,
>  log_text        TEXT HIDDEN,
>  log_body        TEXT HIDDEN
>);
>
>2018-08-23T14:51:49.427 D log_vtab_impl.cc:193 creating log format table: vmk_log = 0x5571b0ecc508
>2018-08-23T14:51:49.427 D log_vtab_impl.cc:111 log_vtab_impl.get_table_statement() -> CREATE TABLE vmw_log (
>  log_line        INTEGER  PRIMARY KEY,
>  log_part        TEXT     COLLATE naturalnocase,
>  log_time        DATETIME,
>  log_actual_time DATETIME HIDDEN,
>  log_idle_msecs  INTEGER,
>  log_level       TEXT     COLLATE loglevel,
>  log_mark        BOOLEAN,
>  -- 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'       ,
>  -- END Format-specific fields
>  log_path        TEXT HIDDEN COLLATE naturalnocase,
>  log_text        TEXT HIDDEN,
>  log_body        TEXT HIDDEN
>);
>
>2018-08-23T14:51:49.427 D log_vtab_impl.cc:193 creating log format table: vmw_log = 0x5571b0ec81a8
>2018-08-23T14:51:49.427 D log_vtab_impl.cc:111 log_vtab_impl.get_table_statement() -> CREATE TABLE xmlrpc_log (
>  log_line        INTEGER  PRIMARY KEY,
>  log_part        TEXT     COLLATE naturalnocase,
>  log_time        DATETIME,
>  log_actual_time DATETIME HIDDEN,
>  log_idle_msecs  INTEGER,
>  log_level       TEXT     COLLATE loglevel,
>  log_mark        BOOLEAN,
>  -- 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_path        TEXT HIDDEN COLLATE naturalnocase,
>  log_text        TEXT HIDDEN,
>  log_body        TEXT HIDDEN
>);
>
>2018-08-23T14:51:49.427 D log_vtab_impl.cc:193 creating log format table: xmlrpc_log = 0x5571b0ed2bd8
>2018-08-23T14:51:49.427 D log_vtab_impl.cc:111 log_vtab_impl.get_table_statement() -> CREATE TABLE engine_log (
>  log_line        INTEGER  PRIMARY KEY,
>  log_part        TEXT     COLLATE naturalnocase,
>  log_time        DATETIME,
>  log_actual_time DATETIME HIDDEN,
>  log_idle_msecs  INTEGER,
>  log_level       TEXT     COLLATE loglevel,
>  log_mark        BOOLEAN,
>  -- BEGIN Format-specific fields:
>  logger          TEXT     COLLATE 'BINARY'       ,
>  tid             TEXT     COLLATE 'BINARY'       ,
>  thread          TEXT     COLLATE 'BINARY'       ,
>  -- END Format-specific fields
>  log_path        TEXT HIDDEN COLLATE naturalnocase,
>  log_text        TEXT HIDDEN,
>  log_body        TEXT HIDDEN
>);
>
>2018-08-23T14:51:49.427 D log_vtab_impl.cc:193 creating log format table: engine_log = 0x5571b0ed4278
>2018-08-23T14:51:49.428 D log_vtab_impl.cc:111 log_vtab_impl.get_table_statement() -> CREATE TABLE cups_log (
>  log_line        INTEGER  PRIMARY KEY,
>  log_part        TEXT     COLLATE naturalnocase,
>  log_time        DATETIME,
>  log_actual_time DATETIME HIDDEN,
>  log_idle_msecs  INTEGER,
>  log_level       TEXT     COLLATE loglevel,
>  log_mark        BOOLEAN,
>  -- BEGIN Format-specific fields:
>  level           TEXT     COLLATE 'BINARY'       ,
>  section         TEXT     COLLATE 'BINARY'       ,
>  -- END Format-specific fields
>  log_path        TEXT HIDDEN COLLATE naturalnocase,
>  log_text        TEXT HIDDEN,
>  log_body        TEXT HIDDEN
>);
>
>2018-08-23T14:51:49.428 D log_vtab_impl.cc:193 creating log format table: cups_log = 0x5571b0ed78e8
>2018-08-23T14:51:49.428 D log_vtab_impl.cc:111 log_vtab_impl.get_table_statement() -> CREATE TABLE error_log (
>  log_line        INTEGER  PRIMARY KEY,
>  log_part        TEXT     COLLATE naturalnocase,
>  log_time        DATETIME,
>  log_actual_time DATETIME HIDDEN,
>  log_idle_msecs  INTEGER,
>  log_level       TEXT     COLLATE loglevel,
>  log_mark        BOOLEAN,
>  -- 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'       ,
>  -- END Format-specific fields
>  log_path        TEXT HIDDEN COLLATE naturalnocase,
>  log_text        TEXT HIDDEN,
>  log_body        TEXT HIDDEN
>);
>
>2018-08-23T14:51:49.428 D log_vtab_impl.cc:193 creating log format table: error_log = 0x5571b0ed9938
>2018-08-23T14:51:49.428 I log_format_loader.cc:952 executing SQL files in path: /etc/lnav/formats/*/*.sql
>2018-08-23T14:51:49.428 I log_format_loader.cc:952 executing SQL files in path: /etc/lnav/formats/*/*.sql
>2018-08-23T14:51:49.428 I log_format_loader.cc:952 executing SQL files in path: /root/.lnav//formats/*/*.sql
>2018-08-23T14:51:49.428 I logfile.cc:100 Creating logfile: fd=4; size=21400583; mtime=1535057503; filename=/var/log/messages
>2018-08-23T14:51:49.428 I lnav.cc:1465 loading new file: filename=/var/log/messages
>2018-08-23T14:51:49.428 I lnav.cc:3503 startup: lnav 0.8.3
>2018-08-23T14:51:49.428 I lnav_log.cc:171 uname:
>2018-08-23T14:51:49.428 I lnav_log.cc:172   sysname=Linux
>2018-08-23T14:51:49.428 I lnav_log.cc:173   nodename=mharris.usersys.redhat.com
>2018-08-23T14:51:49.428 I lnav_log.cc:174   machine=x86_64
>2018-08-23T14:51:49.428 I lnav_log.cc:175   release=4.17.14-202.fc28.x86_64
>2018-08-23T14:51:49.428 I lnav_log.cc:176   version=#1 SMP Wed Aug 15 12:29:25 UTC 2018
>2018-08-23T14:51:49.428 I lnav_log.cc:177 Environment:
>2018-08-23T14:51:49.428 I lnav_log.cc:178   HOME=/root
>2018-08-23T14:51:49.428 I lnav_log.cc:179   LANG=en_US.UTF-8
>2018-08-23T14:51:49.428 I lnav_log.cc:180   PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
>2018-08-23T14:51:49.428 I lnav_log.cc:181   TERM=xterm-256color
>2018-08-23T14:51:49.428 I lnav_log.cc:182   TZ=(null)
>2018-08-23T14:51:49.428 I lnav_log.cc:183 Process:
>2018-08-23T14:51:49.428 I lnav_log.cc:184   pid=28037
>2018-08-23T14:51:49.428 I lnav_log.cc:185   ppid=28036
>2018-08-23T14:51:49.428 I lnav_log.cc:186   pgrp=28036
>2018-08-23T14:51:49.428 I lnav_log.cc:187   uid=0
>2018-08-23T14:51:49.428 I lnav_log.cc:188   gid=0
>2018-08-23T14:51:49.428 I lnav_log.cc:189   euid=0
>2018-08-23T14:51:49.428 I lnav_log.cc:190   egid=0
>2018-08-23T14:51:49.428 I lnav_log.cc:195   cwd=/tmp
>2018-08-23T14:51:49.428 I lnav_log.cc:197 Executable:
>2018-08-23T14:51:49.428 I lnav_log.cc:198   version=lnav 0.8.3
>2018-08-23T14:51:49.428 I lnav_log.cc:201 rusage:
>2018-08-23T14:51:49.428 I lnav_log.cc:201   utime=0.024795
>2018-08-23T14:51:49.428 I lnav_log.cc:201   stime=0.003969
>2018-08-23T14:51:49.428 I lnav_log.cc:201   maxrss=15260
>2018-08-23T14:51:49.428 I lnav_log.cc:201   ixrss=0
>2018-08-23T14:51:49.428 I lnav_log.cc:201   idrss=0
>2018-08-23T14:51:49.428 I lnav_log.cc:201   isrss=0
>2018-08-23T14:51:49.428 I lnav_log.cc:201   minflt=1038
>2018-08-23T14:51:49.428 I lnav_log.cc:201   majflt=0
>2018-08-23T14:51:49.428 I lnav_log.cc:201   nswap=0
>2018-08-23T14:51:49.428 I lnav_log.cc:201   inblock=0
>2018-08-23T14:51:49.428 I lnav_log.cc:201   oublock=128
>2018-08-23T14:51:49.428 I lnav_log.cc:201   msgsnd=0
>2018-08-23T14:51:49.428 I lnav_log.cc:201   msgrcv=0
>2018-08-23T14:51:49.428 I lnav_log.cc:201   nsignals=0
>2018-08-23T14:51:49.428 I lnav_log.cc:201   nvcsw=0
>2018-08-23T14:51:49.428 I lnav_log.cc:201   nivcsw=1
>2018-08-23T14:51:49.428 I lnav.cc:3505 Libraries:
>2018-08-23T14:51:49.428 I lnav.cc:3507   bzip=1.0.6, 6-Sept-2010
>2018-08-23T14:51:49.428 I lnav.cc:3510   curl=7.58.0 (2018-01-24)
>2018-08-23T14:51:49.428 I lnav.cc:3512   ncurses=6.1
>2018-08-23T14:51:49.428 I lnav.cc:3513   pcre=8.42 2018-03-20
>2018-08-23T14:51:49.428 I lnav.cc:3514   readline=7.0
>2018-08-23T14:51:49.428 I lnav.cc:3515   sqlite=3.22.0
>2018-08-23T14:51:49.428 I lnav.cc:3516   zlib=1.2.11
>2018-08-23T14:51:49.428 I lnav.cc:3517 lnav_data:
>2018-08-23T14:51:49.428 I lnav.cc:3518   flags=1
>2018-08-23T14:51:49.428 I lnav.cc:3519   commands:
>2018-08-23T14:51:49.428 I lnav.cc:3526   files:
>2018-08-23T14:51:49.428 I lnav.cc:3531     /var/log/messages
>2018-08-23T14:51:49.428 I session_data.cc:279 init_session: time=1535057509; id=641fce15d4738a01020e0cb0d28610cf
>2018-08-23T14:51:49.428 I lnav.cc:3638   session_id=641fce15d4738a01020e0cb0d28610cf
>2018-08-23T14:51:49.428 I curl_looper.cc:103 curl looper thread started
>2018-08-23T14:51:49.431 W lnav.cc:1981 Not executing example: SELECT CASE 1 WHEN 0 THEN 'zero' WHEN 1 THEN 'one' END
>2018-08-23T14:51:49.431 W lnav.cc:1981 Not executing example: SELECT CASE 1 WHEN 0 THEN 'zero' WHEN 1 THEN 'one' END
>2018-08-23T14:51:49.431 W lnav.cc:1981 Not executing example: SELECT CASE 1 WHEN 0 THEN 'zero' WHEN 1 THEN 'one' END
>2018-08-23T14:51:49.431 W lnav.cc:1981 Not executing example: SELECT * FROM syslog_log
>2018-08-23T14:51:49.431 W lnav.cc:1981 Not executing example: SELECT * FROM syslog_log
>2018-08-23T14:51:49.431 I command_executor.cc:113 Executing SQL: SELECT ltrim('abc   ')
>2018-08-23T14:51:49.431 D lnav.cc:1975 example: SELECT ltrim('abc   ')
>2018-08-23T14:51:49.431 D lnav.cc:1977 example result: abc   
>2018-08-23T14:51:49.431 I command_executor.cc:113 Executing SQL: SELECT ltrim('abbbbcccc', 'bc')
>2018-08-23T14:51:49.431 D lnav.cc:1975 example: SELECT ltrim('abbbbcccc', 'bc')
>2018-08-23T14:51:49.431 D lnav.cc:1977 example result: abbbbcccc
>2018-08-23T14:51:49.431 W lnav.cc:1981 Not executing example: SELECT * FROM syslog_log
>2018-08-23T14:51:49.431 I command_executor.cc:113 Executing SQL: SELECT like('%b%', 'aabcc')
>2018-08-23T14:51:49.431 D lnav.cc:1975 example: SELECT like('%b%', 'aabcc')
>2018-08-23T14:51:49.431 D lnav.cc:1977 example result: 1
>2018-08-23T14:51:49.431 I command_executor.cc:113 Executing SQL: SELECT like('%b:%', 'aab%', ':')
>2018-08-23T14:51:49.431 D lnav.cc:1975 example: SELECT like('%b:%', 'aab%', ':')
>2018-08-23T14:51:49.431 D lnav.cc:1977 example result: 1
>2018-08-23T14:51:49.431 I command_executor.cc:113 Executing SQL: SELECT ifnull(null, 0)
>2018-08-23T14:51:49.431 D lnav.cc:1975 example: SELECT ifnull(null, 0)
>2018-08-23T14:51:49.431 D lnav.cc:1977 example result: 0
>2018-08-23T14:51:49.431 I command_executor.cc:113 Executing SQL: SELECT reverse('abc')
>2018-08-23T14:51:49.431 D lnav.cc:1975 example: SELECT reverse('abc')
>2018-08-23T14:51:49.431 D lnav.cc:1977 example result: cba
>2018-08-23T14:51:49.431 I command_executor.cc:113 Executing SQL: SELECT coalesce(null, 0, null)
>2018-08-23T14:51:49.431 D lnav.cc:1975 example: SELECT coalesce(null, 0, null)
>2018-08-23T14:51:49.431 D lnav.cc:1977 example result: 0
>2018-08-23T14:51:49.431 I command_executor.cc:113 Executing SQL: SELECT typeof(1)
>2018-08-23T14:51:49.431 D lnav.cc:1975 example: SELECT typeof(1)
>2018-08-23T14:51:49.431 D lnav.cc:1977 example result: integer
>2018-08-23T14:51:49.431 I command_executor.cc:113 Executing SQL: SELECT typeof('abc')
>2018-08-23T14:51:49.431 D lnav.cc:1975 example: SELECT typeof('abc')
>2018-08-23T14:51:49.431 D lnav.cc:1977 example result: text
>2018-08-23T14:51:49.431 W lnav.cc:1981 Not executing example: SELECT * FROM syslog_log
>2018-08-23T14:51:49.431 I command_executor.cc:113 Executing SQL: SELECT printf('Hello, %s!', 'World')
>2018-08-23T14:51:49.431 D lnav.cc:1975 example: SELECT printf('Hello, %s!', 'World')
>2018-08-23T14:51:49.431 D lnav.cc:1977 example result: Hello, World!
>2018-08-23T14:51:49.431 I command_executor.cc:113 Executing SQL: SELECT printf('align: % 10s', 'small')
>2018-08-23T14:51:49.431 D lnav.cc:1975 example: SELECT printf('align: % 10s', 'small')
>2018-08-23T14:51:49.431 D lnav.cc:1977 example result: align:      small
>2018-08-23T14:51:49.431 I command_executor.cc:113 Executing SQL: SELECT printf('value: %05d', 11)
>2018-08-23T14:51:49.431 D lnav.cc:1975 example: SELECT printf('value: %05d', 11)
>2018-08-23T14:51:49.431 D lnav.cc:1977 example result: value: 00011
>2018-08-23T14:51:49.431 I command_executor.cc:113 Executing SQL: SELECT timediff('2017-02-03T04:05:06', '2017-02-03T04:05:00')
>2018-08-23T14:51:49.431 D lnav.cc:1975 example: SELECT timediff('2017-02-03T04:05:06', '2017-02-03T04:05:00')
>2018-08-23T14:51:49.431 D lnav.cc:1977 example result: 6.0
>2018-08-23T14:51:49.431 I command_executor.cc:113 Executing SQL: SELECT timediff('today', 'yesterday')
>2018-08-23T14:51:49.431 D lnav.cc:1975 example: SELECT timediff('today', 'yesterday')
>2018-08-23T14:51:49.431 D lnav.cc:1977 example result: 86400.0
>2018-08-23T14:51:49.431 I command_executor.cc:113 Executing SQL: SELECT lower('AbC')
>2018-08-23T14:51:49.431 D lnav.cc:1975 example: SELECT lower('AbC')
>2018-08-23T14:51:49.431 D lnav.cc:1977 example result: abc
>2018-08-23T14:51:49.431 W lnav.cc:1981 Not executing example: SELECT CASE 1 WHEN 0 THEN 'zero' WHEN 1 THEN 'one' END
>2018-08-23T14:51:49.431 I command_executor.cc:113 Executing SQL: SELECT extract('foo=1 bar=2 name="Rolo Tomassi"')
>2018-08-23T14:51:49.431 D lnav.cc:1975 example: SELECT extract('foo=1 bar=2 name="Rolo Tomassi"')
>2018-08-23T14:51:49.431 D lnav.cc:1977 example result: {"foo":1,"bar":2,"name":"Rolo Tomassi"}
>2018-08-23T14:51:49.431 I command_executor.cc:113 Executing SQL: SELECT extract('1.0 abc 2.0')
>2018-08-23T14:51:49.431 D lnav.cc:1975 example: SELECT extract('1.0 abc 2.0')
>2018-08-23T14:51:49.431 D lnav.cc:1977 example result: {"col_0":1.0,"col_1":2.0}
>2018-08-23T14:51:49.431 I command_executor.cc:113 Executing SQL: SELECT abs(-1)
>2018-08-23T14:51:49.431 D lnav.cc:1975 example: SELECT abs(-1)
>2018-08-23T14:51:49.431 D lnav.cc:1977 example result: 1
>2018-08-23T14:51:49.431 I command_executor.cc:113 Executing SQL: SELECT nullif(1, 1)
>2018-08-23T14:51:49.432 D lnav.cc:1975 example: SELECT nullif(1, 1)
>2018-08-23T14:51:49.432 D lnav.cc:1977 example result: <NULL>
>2018-08-23T14:51:49.432 I command_executor.cc:113 Executing SQL: SELECT nullif(1, 2)
>2018-08-23T14:51:49.432 D lnav.cc:1975 example: SELECT nullif(1, 2)
>2018-08-23T14:51:49.432 D lnav.cc:1977 example result: 1
>2018-08-23T14:51:49.432 I command_executor.cc:113 Executing SQL: SELECT time('2017-01-02T03:04:05')
>2018-08-23T14:51:49.432 D lnav.cc:1975 example: SELECT time('2017-01-02T03:04:05')
>2018-08-23T14:51:49.432 D lnav.cc:1977 example result: 03:04:05
>2018-08-23T14:51:49.432 I command_executor.cc:113 Executing SQL: SELECT time('2017-01-02T03:04:05', '+1 minute')
>2018-08-23T14:51:49.432 D lnav.cc:1975 example: SELECT time('2017-01-02T03:04:05', '+1 minute')
>2018-08-23T14:51:49.432 D lnav.cc:1977 example result: 03:05:05
>2018-08-23T14:51:49.432 I command_executor.cc:113 Executing SQL: SELECT time(1491341842, 'unixepoch')
>2018-08-23T14:51:49.432 D lnav.cc:1975 example: SELECT time(1491341842, 'unixepoch')
>2018-08-23T14:51:49.432 D lnav.cc:1977 example result: 21:37:22
>2018-08-23T14:51:49.432 I command_executor.cc:113 Executing SQL: SELECT jget('1', '')
>2018-08-23T14:51:49.432 D lnav.cc:1975 example: SELECT jget('1', '')
>2018-08-23T14:51:49.432 D lnav.cc:1977 example result: 1
>2018-08-23T14:51:49.432 I command_executor.cc:113 Executing SQL: SELECT jget('{ "a": 1, "b": 2 }', '/b')
>2018-08-23T14:51:49.432 D lnav.cc:1975 example: SELECT jget('{ "a": 1, "b": 2 }', '/b')
>2018-08-23T14:51:49.432 D lnav.cc:1977 example result: 2
>2018-08-23T14:51:49.432 I command_executor.cc:113 Executing SQL: SELECT rightstr('abc', 1)
>2018-08-23T14:51:49.432 D lnav.cc:1975 example: SELECT rightstr('abc', 1)
>2018-08-23T14:51:49.432 D lnav.cc:1977 example result: c
>2018-08-23T14:51:49.432 I command_executor.cc:113 Executing SQL: SELECT rightstr('abc', 10)
>2018-08-23T14:51:49.432 D lnav.cc:1975 example: SELECT rightstr('abc', 10)
>2018-08-23T14:51:49.432 D lnav.cc:1977 example result: abc
>2018-08-23T14:51:49.432 I command_executor.cc:113 Executing SQL: SELECT sum(ex_duration) FROM lnav_example_log
>2018-08-23T14:51:49.432 D lnav.cc:1975 example: SELECT sum(ex_duration) FROM lnav_example_log
>2018-08-23T14:51:49.432 D lnav.cc:1977 example result: 17
>2018-08-23T14:51:49.432 I command_executor.cc:113 Executing SQL: SELECT dirname('foo/bar')
>2018-08-23T14:51:49.432 D lnav.cc:1975 example: SELECT dirname('foo/bar')
>2018-08-23T14:51:49.432 D lnav.cc:1977 example result: foo
>2018-08-23T14:51:49.432 I command_executor.cc:113 Executing SQL: SELECT dirname('/foo/bar')
>2018-08-23T14:51:49.432 D lnav.cc:1975 example: SELECT dirname('/foo/bar')
>2018-08-23T14:51:49.432 D lnav.cc:1977 example result: /foo
>2018-08-23T14:51:49.432 I command_executor.cc:113 Executing SQL: SELECT dirname('/bar')
>2018-08-23T14:51:49.432 D lnav.cc:1975 example: SELECT dirname('/bar')
>2018-08-23T14:51:49.432 D lnav.cc:1977 example result: /
>2018-08-23T14:51:49.432 I command_executor.cc:113 Executing SQL: SELECT dirname('foo\bar')
>2018-08-23T14:51:49.432 D lnav.cc:1975 example: SELECT dirname('foo\bar')
>2018-08-23T14:51:49.432 D lnav.cc:1977 example result: foo
>2018-08-23T14:51:49.432 I command_executor.cc:113 Executing SQL: SELECT dirname('')
>2018-08-23T14:51:49.432 D lnav.cc:1975 example: SELECT dirname('')
>2018-08-23T14:51:49.432 D lnav.cc:1977 example result: .
>2018-08-23T14:51:49.432 I command_executor.cc:113 Executing SQL: SELECT length('abc')
>2018-08-23T14:51:49.432 D lnav.cc:1975 example: SELECT length('abc')
>2018-08-23T14:51:49.432 D lnav.cc:1977 example result: 3
>2018-08-23T14:51:49.432 I command_executor.cc:113 Executing SQL: SELECT round(123.456)
>2018-08-23T14:51:49.432 D lnav.cc:1975 example: SELECT round(123.456)
>2018-08-23T14:51:49.432 D lnav.cc:1977 example result: 123.0
>2018-08-23T14:51:49.432 I command_executor.cc:113 Executing SQL: SELECT round(123.456, 1)
>2018-08-23T14:51:49.432 D lnav.cc:1975 example: SELECT round(123.456, 1)
>2018-08-23T14:51:49.432 D lnav.cc:1977 example result: 123.5
>2018-08-23T14:51:49.432 I command_executor.cc:113 Executing SQL: SELECT round(123.456, 5)
>2018-08-23T14:51:49.432 D lnav.cc:1975 example: SELECT round(123.456, 5)
>2018-08-23T14:51:49.432 D lnav.cc:1977 example result: 123.456
>2018-08-23T14:51:49.432 W lnav.cc:1981 Not executing example: DETACH DATABASE customers
>2018-08-23T14:51:49.432 I command_executor.cc:113 Executing SQL: SELECT glob('a*', 'abc')
>2018-08-23T14:51:49.432 D lnav.cc:1975 example: SELECT glob('a*', 'abc')
>2018-08-23T14:51:49.432 D lnav.cc:1977 example result: 1
>2018-08-23T14:51:49.432 I command_executor.cc:113 Executing SQL: SELECT sqlite_compileoption_used('ENABLE_FTS3')
>2018-08-23T14:51:49.432 D lnav.cc:1975 example: SELECT sqlite_compileoption_used('ENABLE_FTS3')
>2018-08-23T14:51:49.432 D lnav.cc:1977 example result: 1
>2018-08-23T14:51:49.432 I command_executor.cc:113 Executing SQL: SELECT gethostbyaddr('127.0.0.1')
>2018-08-23T14:51:49.432 D lnav.cc:1975 example: SELECT gethostbyaddr('127.0.0.1')
>2018-08-23T14:51:49.432 D lnav.cc:1977 example result: localhost
>2018-08-23T14:51:49.432 I command_executor.cc:113 Executing SQL: SELECT basename('foobar')
>2018-08-23T14:51:49.432 D lnav.cc:1975 example: SELECT basename('foobar')
>2018-08-23T14:51:49.432 D lnav.cc:1977 example result: foobar
>2018-08-23T14:51:49.432 I command_executor.cc:113 Executing SQL: SELECT basename('foo/bar')
>2018-08-23T14:51:49.432 D lnav.cc:1975 example: SELECT basename('foo/bar')
>2018-08-23T14:51:49.432 D lnav.cc:1977 example result: bar
>2018-08-23T14:51:49.432 I command_executor.cc:113 Executing SQL: SELECT basename('foo/bar/')
>2018-08-23T14:51:49.432 D lnav.cc:1975 example: SELECT basename('foo/bar/')
>2018-08-23T14:51:49.432 D lnav.cc:1977 example result: bar
>2018-08-23T14:51:49.432 I command_executor.cc:113 Executing SQL: SELECT basename('')
>2018-08-23T14:51:49.432 D lnav.cc:1975 example: SELECT basename('')
>2018-08-23T14:51:49.432 D lnav.cc:1977 example result: .
>2018-08-23T14:51:49.432 I command_executor.cc:113 Executing SQL: SELECT basename('foo\bar')
>2018-08-23T14:51:49.432 D lnav.cc:1975 example: SELECT basename('foo\bar')
>2018-08-23T14:51:49.432 D lnav.cc:1977 example result: bar
>2018-08-23T14:51:49.432 I command_executor.cc:113 Executing SQL: SELECT basename('foobar')
>2018-08-23T14:51:49.432 D lnav.cc:1975 example: SELECT basename('foobar')
>2018-08-23T14:51:49.432 D lnav.cc:1977 example result: foobar
>2018-08-23T14:51:49.432 I command_executor.cc:113 Executing SQL: SELECT basename('/')
>2018-08-23T14:51:49.432 D lnav.cc:1975 example: SELECT basename('/')
>2018-08-23T14:51:49.432 D lnav.cc:1977 example result: /
>2018-08-23T14:51:49.432 I command_executor.cc:113 Executing SQL: SELECT CAST(1.23 AS INTEGER)
>2018-08-23T14:51:49.432 D lnav.cc:1975 example: SELECT CAST(1.23 AS INTEGER)
>2018-08-23T14:51:49.432 D lnav.cc:1977 example result: 1
>2018-08-23T14:51:49.432 I command_executor.cc:113 Executing SQL: SELECT regexp_match('(\d+)', '123')
>2018-08-23T14:51:49.432 D lnav.cc:1975 example: SELECT regexp_match('(\d+)', '123')
>2018-08-23T14:51:49.432 D lnav.cc:1977 example result: 123
>2018-08-23T14:51:49.432 I command_executor.cc:113 Executing SQL: SELECT regexp_match('(\d+) (\w+)', '123 four')
>2018-08-23T14:51:49.432 D lnav.cc:1975 example: SELECT regexp_match('(\d+) (\w+)', '123 four')
>2018-08-23T14:51:49.432 D lnav.cc:1977 example result: {"col_0":123,"col_1":"four"}
>2018-08-23T14:51:49.432 I command_executor.cc:113 Executing SQL: SELECT regexp_match('(?<num>\d+) (?<str>\w+)', '123 four')
>2018-08-23T14:51:49.432 D lnav.cc:1975 example: SELECT regexp_match('(?<num>\d+) (?<str>\w+)', '123 four')
>2018-08-23T14:51:49.432 D lnav.cc:1977 example result: {"num":123,"str":"four"}
>2018-08-23T14:51:49.432 I command_executor.cc:113 Executing SQL: SELECT hex('abc')
>2018-08-23T14:51:49.432 D lnav.cc:1975 example: SELECT hex('abc')
>2018-08-23T14:51:49.432 D lnav.cc:1977 example result: 616263
>2018-08-23T14:51:49.432 I command_executor.cc:113 Executing SQL: SELECT replace('abc', 'x', 'z')
>2018-08-23T14:51:49.432 D lnav.cc:1975 example: SELECT replace('abc', 'x', 'z')
>2018-08-23T14:51:49.432 D lnav.cc:1977 example result: abc
>2018-08-23T14:51:49.432 I command_executor.cc:113 Executing SQL: SELECT replace('abc', 'a', 'z')
>2018-08-23T14:51:49.432 D lnav.cc:1975 example: SELECT replace('abc', 'a', 'z')
>2018-08-23T14:51:49.432 D lnav.cc:1977 example result: zbc
>2018-08-23T14:51:49.432 I command_executor.cc:113 Executing SQL: SELECT endswith('notbad.jpg', '.jpg')
>2018-08-23T14:51:49.432 D lnav.cc:1975 example: SELECT endswith('notbad.jpg', '.jpg')
>2018-08-23T14:51:49.432 D lnav.cc:1977 example result: 1
>2018-08-23T14:51:49.432 I command_executor.cc:113 Executing SQL: SELECT endswith('notbad.png', '.jpg')
>2018-08-23T14:51:49.432 D lnav.cc:1975 example: SELECT endswith('notbad.png', '.jpg')
>2018-08-23T14:51:49.432 D lnav.cc:1977 example result: 0
>2018-08-23T14:51:49.432 I command_executor.cc:113 Executing SQL: SELECT regexp_replace('Hello, World!', '^(\w+)', 'Goodbye')
>2018-08-23T14:51:49.433 D lnav.cc:1975 example: SELECT regexp_replace('Hello, World!', '^(\w+)', 'Goodbye')
>2018-08-23T14:51:49.433 D lnav.cc:1977 example result: Goodbye, World!
>2018-08-23T14:51:49.433 I command_executor.cc:113 Executing SQL: SELECT regexp_replace('123 abc', '(\w+)', '<\1>')
>2018-08-23T14:51:49.433 D lnav.cc:1975 example: SELECT regexp_replace('123 abc', '(\w+)', '<\1>')
>2018-08-23T14:51:49.433 D lnav.cc:1977 example result: <123> <abc>
>2018-08-23T14:51:49.433 I command_executor.cc:113 Executing SQL: SELECT startswith('foobar', 'foo')
>2018-08-23T14:51:49.433 D lnav.cc:1975 example: SELECT startswith('foobar', 'foo')
>2018-08-23T14:51:49.433 D lnav.cc:1977 example result: 1
>2018-08-23T14:51:49.433 I command_executor.cc:113 Executing SQL: SELECT startswith('foobar', 'bar')
>2018-08-23T14:51:49.433 D lnav.cc:1975 example: SELECT startswith('foobar', 'bar')
>2018-08-23T14:51:49.433 D lnav.cc:1977 example result: 0
>2018-08-23T14:51:49.433 I command_executor.cc:113 Executing SQL: SELECT strftime('%Y', '2017-01-02T03:04:05')
>2018-08-23T14:51:49.433 D lnav.cc:1975 example: SELECT strftime('%Y', '2017-01-02T03:04:05')
>2018-08-23T14:51:49.433 D lnav.cc:1977 example result: 2017
>2018-08-23T14:51:49.433 I command_executor.cc:113 Executing SQL: SELECT strftime('The time is: %H%M%S', '2017-01-02T03:04:05', '+1 minute')
>2018-08-23T14:51:49.433 D lnav.cc:1975 example: SELECT strftime('The time is: %H%M%S', '2017-01-02T03:04:05', '+1 minute')
>2018-08-23T14:51:49.433 D lnav.cc:1977 example result: The time is: 030505
>2018-08-23T14:51:49.433 I command_executor.cc:113 Executing SQL: SELECT strftime('Julian day: %J', 1491341842, 'unixepoch')
>2018-08-23T14:51:49.433 D lnav.cc:1975 example: SELECT strftime('Julian day: %J', 1491341842, 'unixepoch')
>2018-08-23T14:51:49.433 D lnav.cc:1977 example result: Julian day: 2457848.400949074
>2018-08-23T14:51:49.433 I command_executor.cc:113 Executing SQL: SELECT timeslice('2017-01-01T05:05:00', '10m')
>2018-08-23T14:51:49.433 D lnav.cc:1975 example: SELECT timeslice('2017-01-01T05:05:00', '10m')
>2018-08-23T14:51:49.433 D lnav.cc:1977 example result: 2017-01-01 05:00:00.000
>2018-08-23T14:51:49.433 I command_executor.cc:113 Executing SQL: SELECT timeslice(log_time, '5m') AS slice, count(*) FROM lnav_example_log GROUP BY slice
>2018-08-23T14:51:49.433 D lnav.cc:1975 example: SELECT timeslice(log_time, '5m') AS slice, count(*) FROM lnav_example_log GROUP BY slice
>2018-08-23T14:51:49.433 D lnav.cc:1977 example result:          slice          count(*) 
>2017-02-03 04:05:00.000        2 
>2017-02-03 04:25:00.000        1 
>2017-02-03 04:55:00.000        1 
>2018-08-23T14:51:49.433 I command_executor.cc:113 Executing SQL: SELECT ltrim('   abc')
>2018-08-23T14:51:49.433 D lnav.cc:1975 example: SELECT ltrim('   abc')
>2018-08-23T14:51:49.433 D lnav.cc:1977 example result: abc
>2018-08-23T14:51:49.433 I command_executor.cc:113 Executing SQL: SELECT ltrim('aaaabbbc', 'ab')
>2018-08-23T14:51:49.433 D lnav.cc:1975 example: SELECT ltrim('aaaabbbc', 'ab')
>2018-08-23T14:51:49.433 D lnav.cc:1977 example result: c
>2018-08-23T14:51:49.433 I command_executor.cc:113 Executing SQL: SELECT max(2, 1, 3)
>2018-08-23T14:51:49.433 D lnav.cc:1975 example: SELECT max(2, 1, 3)
>2018-08-23T14:51:49.433 D lnav.cc:1977 example result: 3
>2018-08-23T14:51:49.433 I command_executor.cc:113 Executing SQL: SELECT max(status) FROM http_status_codes
>2018-08-23T14:51:49.433 D lnav.cc:1975 example: SELECT max(status) FROM http_status_codes
>2018-08-23T14:51:49.433 D lnav.cc:1977 example result: 511
>2018-08-23T14:51:49.433 I command_executor.cc:113 Executing SQL: SELECT instr('abc', 'b')
>2018-08-23T14:51:49.433 D lnav.cc:1975 example: SELECT instr('abc', 'b')
>2018-08-23T14:51:49.433 D lnav.cc:1977 example result: 2
>2018-08-23T14:51:49.433 I command_executor.cc:113 Executing SQL: SELECT gethostbyname('localhost')
>2018-08-23T14:51:49.433 D lnav.cc:1975 example: SELECT gethostbyname('localhost')
>2018-08-23T14:51:49.433 D lnav.cc:1977 example result: ::1
>2018-08-23T14:51:49.433 I command_executor.cc:113 Executing SQL: SELECT min(2, 1, 3)
>2018-08-23T14:51:49.433 D lnav.cc:1975 example: SELECT min(2, 1, 3)
>2018-08-23T14:51:49.433 D lnav.cc:1977 example result: 1
>2018-08-23T14:51:49.433 I command_executor.cc:113 Executing SQL: SELECT min(status) FROM http_status_codes
>2018-08-23T14:51:49.433 D lnav.cc:1975 example: SELECT min(status) FROM http_status_codes
>2018-08-23T14:51:49.433 D lnav.cc:1977 example result: 100
>2018-08-23T14:51:49.433 I command_executor.cc:113 Executing SQL: SELECT count(*) FROM lnav_example_log
>2018-08-23T14:51:49.433 D lnav.cc:1975 example: SELECT count(*) FROM lnav_example_log
>2018-08-23T14:51:49.433 D lnav.cc:1977 example result: 4
>2018-08-23T14:51:49.433 I command_executor.cc:113 Executing SQL: SELECT count(log_part) FROM lnav_example_log
>2018-08-23T14:51:49.433 D lnav.cc:1975 example: SELECT count(log_part) FROM lnav_example_log
>2018-08-23T14:51:49.433 D lnav.cc:1977 example result: 2
>2018-08-23T14:51:49.433 I command_executor.cc:113 Executing SQL: SELECT julianday('2017-01-02T03:04:05')
>2018-08-23T14:51:49.433 D lnav.cc:1975 example: SELECT julianday('2017-01-02T03:04:05')
>2018-08-23T14:51:49.433 D lnav.cc:1977 example result: 2457755.62783565
>2018-08-23T14:51:49.433 I command_executor.cc:113 Executing SQL: SELECT julianday('2017-01-02T03:04:05', '+1 minute')
>2018-08-23T14:51:49.433 D lnav.cc:1975 example: SELECT julianday('2017-01-02T03:04:05', '+1 minute')
>2018-08-23T14:51:49.433 D lnav.cc:1977 example result: 2457755.62853009
>2018-08-23T14:51:49.433 I command_executor.cc:113 Executing SQL: SELECT julianday(1491341842, 'unixepoch')
>2018-08-23T14:51:49.433 D lnav.cc:1975 example: SELECT julianday(1491341842, 'unixepoch')
>2018-08-23T14:51:49.433 D lnav.cc:1977 example result: 2457848.40094907
>2018-08-23T14:51:49.433 I command_executor.cc:113 Executing SQL: SELECT substr('abc', 2)
>2018-08-23T14:51:49.433 D lnav.cc:1975 example: SELECT substr('abc', 2)
>2018-08-23T14:51:49.433 D lnav.cc:1977 example result: bc
>2018-08-23T14:51:49.433 I command_executor.cc:113 Executing SQL: SELECT substr('abc', 2, 1)
>2018-08-23T14:51:49.433 D lnav.cc:1975 example: SELECT substr('abc', 2, 1)
>2018-08-23T14:51:49.433 D lnav.cc:1977 example result: b
>2018-08-23T14:51:49.433 I command_executor.cc:113 Executing SQL: SELECT substr('abc', -1)
>2018-08-23T14:51:49.433 D lnav.cc:1975 example: SELECT substr('abc', -1)
>2018-08-23T14:51:49.433 D lnav.cc:1977 example result: c
>2018-08-23T14:51:49.433 I command_executor.cc:113 Executing SQL: SELECT substr('abc', -1, -1)
>2018-08-23T14:51:49.433 D lnav.cc:1975 example: SELECT substr('abc', -1, -1)
>2018-08-23T14:51:49.433 D lnav.cc:1977 example result: b
>2018-08-23T14:51:49.433 I command_executor.cc:113 Executing SQL: SELECT datetime('2017-01-02T03:04:05')
>2018-08-23T14:51:49.433 D lnav.cc:1975 example: SELECT datetime('2017-01-02T03:04:05')
>2018-08-23T14:51:49.433 D lnav.cc:1977 example result: 2017-01-02 03:04:05
>2018-08-23T14:51:49.433 I command_executor.cc:113 Executing SQL: SELECT datetime('2017-01-02T03:04:05', '+1 minute')
>2018-08-23T14:51:49.433 D lnav.cc:1975 example: SELECT datetime('2017-01-02T03:04:05', '+1 minute')
>2018-08-23T14:51:49.433 D lnav.cc:1977 example result: 2017-01-02 03:05:05
>2018-08-23T14:51:49.433 I command_executor.cc:113 Executing SQL: SELECT datetime(1491341842, 'unixepoch')
>2018-08-23T14:51:49.433 D lnav.cc:1975 example: SELECT datetime(1491341842, 'unixepoch')
>2018-08-23T14:51:49.433 D lnav.cc:1977 example result: 2017-04-04 21:37:22
>2018-08-23T14:51:49.433 I command_executor.cc:113 Executing SQL: SELECT trim('    abc   ')
>2018-08-23T14:51:49.433 D lnav.cc:1975 example: SELECT trim('    abc   ')
>2018-08-23T14:51:49.433 D lnav.cc:1977 example result: abc
>2018-08-23T14:51:49.433 I command_executor.cc:113 Executing SQL: SELECT trim('-+abc+-', '-+')
>2018-08-23T14:51:49.433 D lnav.cc:1975 example: SELECT trim('-+abc+-', '-+')
>2018-08-23T14:51:49.433 D lnav.cc:1977 example result: abc
>2018-08-23T14:51:49.433 I command_executor.cc:113 Executing SQL: SELECT char(0x48, 0x49)
>2018-08-23T14:51:49.433 D lnav.cc:1975 example: SELECT char(0x48, 0x49)
>2018-08-23T14:51:49.433 D lnav.cc:1977 example result: HI
>2018-08-23T14:51:49.433 I command_executor.cc:113 Executing SQL: SELECT quote('abc')
>2018-08-23T14:51:49.433 D lnav.cc:1975 example: SELECT quote('abc')
>2018-08-23T14:51:49.433 D lnav.cc:1977 example result: 'abc'
>2018-08-23T14:51:49.433 I command_executor.cc:113 Executing SQL: SELECT quote('abc''123')
>2018-08-23T14:51:49.433 D lnav.cc:1975 example: SELECT quote('abc''123')
>2018-08-23T14:51:49.433 D lnav.cc:1977 example result: 'abc''123'
>2018-08-23T14:51:49.433 I command_executor.cc:113 Executing SQL: SELECT unicode('abc')
>2018-08-23T14:51:49.433 D lnav.cc:1975 example: SELECT unicode('abc')
>2018-08-23T14:51:49.433 D lnav.cc:1977 example result: 97
>2018-08-23T14:51:49.433 I command_executor.cc:113 Executing SQL: SELECT joinpath('foo', 'bar')
>2018-08-23T14:51:49.433 D lnav.cc:1975 example: SELECT joinpath('foo', 'bar')
>2018-08-23T14:51:49.433 D lnav.cc:1977 example result: foo/bar
>2018-08-23T14:51:49.433 I command_executor.cc:113 Executing SQL: SELECT joinpath('', 'foo', 'bar')
>2018-08-23T14:51:49.433 D lnav.cc:1975 example: SELECT joinpath('', 'foo', 'bar')
>2018-08-23T14:51:49.433 D lnav.cc:1977 example result: foo/bar
>2018-08-23T14:51:49.433 I command_executor.cc:113 Executing SQL: SELECT joinpath('/', 'foo', 'bar')
>2018-08-23T14:51:49.433 D lnav.cc:1975 example: SELECT joinpath('/', 'foo', 'bar')
>2018-08-23T14:51:49.433 D lnav.cc:1977 example result: /foo/bar
>2018-08-23T14:51:49.433 I command_executor.cc:113 Executing SQL: SELECT joinpath('/', 'foo', '/bar')
>2018-08-23T14:51:49.433 D lnav.cc:1975 example: SELECT joinpath('/', 'foo', '/bar')
>2018-08-23T14:51:49.433 D lnav.cc:1977 example result: /bar
>2018-08-23T14:51:49.433 I command_executor.cc:113 Executing SQL: SELECT upper('aBc')
>2018-08-23T14:51:49.433 D lnav.cc:1975 example: SELECT upper('aBc')
>2018-08-23T14:51:49.433 D lnav.cc:1977 example result: ABC
>2018-08-23T14:51:49.433 W lnav.cc:1981 Not executing example: DETACH DATABASE customers
>2018-08-23T14:51:49.433 W lnav.cc:1981 Not executing example: SELECT * FROM syslog_log
>2018-08-23T14:51:49.433 I command_executor.cc:113 Executing SQL: SELECT leftstr('abc', 1)
>2018-08-23T14:51:49.433 D lnav.cc:1975 example: SELECT leftstr('abc', 1)
>2018-08-23T14:51:49.433 D lnav.cc:1977 example result: a
>2018-08-23T14:51:49.433 I command_executor.cc:113 Executing SQL: SELECT leftstr('abc', 10)
>2018-08-23T14:51:49.433 D lnav.cc:1975 example: SELECT leftstr('abc', 10)
>2018-08-23T14:51:49.433 D lnav.cc:1977 example result: abc
>2018-08-23T14:51:49.433 I command_executor.cc:113 Executing SQL: SELECT date('2017-01-02T03:04:05')
>2018-08-23T14:51:49.433 D lnav.cc:1975 example: SELECT date('2017-01-02T03:04:05')
>2018-08-23T14:51:49.433 D lnav.cc:1977 example result: 2017-01-02
>2018-08-23T14:51:49.433 I command_executor.cc:113 Executing SQL: SELECT date('2017-01-02T03:04:05', '+1 day')
>2018-08-23T14:51:49.433 D lnav.cc:1975 example: SELECT date('2017-01-02T03:04:05', '+1 day')
>2018-08-23T14:51:49.433 D lnav.cc:1977 example result: 2017-01-03
>2018-08-23T14:51:49.433 I command_executor.cc:113 Executing SQL: SELECT date(1491341842, 'unixepoch')
>2018-08-23T14:51:49.433 D lnav.cc:1975 example: SELECT date(1491341842, 'unixepoch')
>2018-08-23T14:51:49.433 D lnav.cc:1977 example result: 2017-04-04
>2018-08-23T14:51:49.433 I command_executor.cc:113 Executing SQL: SELECT avg(ex_duration) FROM lnav_example_log
>2018-08-23T14:51:49.433 D lnav.cc:1975 example: SELECT avg(ex_duration) FROM lnav_example_log
>2018-08-23T14:51:49.433 D lnav.cc:1977 example result: 4.25
>2018-08-23T14:51:49.433 I command_executor.cc:113 Executing SQL: SELECT ex_procname, avg(ex_duration) FROM lnav_example_log GROUP BY ex_procname
>2018-08-23T14:51:49.433 D lnav.cc:1975 example: SELECT ex_procname, avg(ex_duration) FROM lnav_example_log GROUP BY ex_procname
>2018-08-23T14:51:49.433 D lnav.cc:1977 example result: ex_procname avg(ex_duration) 
>gw                       5.0 
>hw                       2.0 
>2018-08-23T14:51:49.433 I command_executor.cc:113 Executing SQL: SELECT group_concat(ex_procname) FROM lnav_example_log
>2018-08-23T14:51:49.433 D lnav.cc:1975 example: SELECT group_concat(ex_procname) FROM lnav_example_log
>2018-08-23T14:51:49.433 D lnav.cc:1977 example result: hw,gw,gw,gw
>2018-08-23T14:51:49.433 I command_executor.cc:113 Executing SQL: SELECT group_concat(ex_procname, ', ') FROM lnav_example_log
>2018-08-23T14:51:49.434 D lnav.cc:1975 example: SELECT group_concat(ex_procname, ', ') FROM lnav_example_log
>2018-08-23T14:51:49.434 D lnav.cc:1977 example result: hw, gw, gw, gw
>2018-08-23T14:51:49.434 I command_executor.cc:113 Executing SQL: SELECT group_concat(DISTINCT ex_procname) FROM lnav_example_log
>2018-08-23T14:51:49.434 D lnav.cc:1975 example: SELECT group_concat(DISTINCT ex_procname) FROM lnav_example_log
>2018-08-23T14:51:49.434 D lnav.cc:1977 example result: hw,gw
>2018-08-23T14:51:49.434 I command_executor.cc:113 Executing SQL: SELECT total(ex_duration) FROM lnav_example_log
>2018-08-23T14:51:49.434 D lnav.cc:1975 example: SELECT total(ex_duration) FROM lnav_example_log
>2018-08-23T14:51:49.434 D lnav.cc:1977 example result: 17.0
>2018-08-23T14:51:49.434 W lnav.cc:1981 Not executing example: ATTACH DATABASE '/tmp/customers.db' AS customers
>2018-08-23T14:51:49.434 I command_executor.cc:113 Executing SQL: SELECT CAST(1.23 AS INTEGER)
>2018-08-23T14:51:49.434 D lnav.cc:1975 example: SELECT CAST(1.23 AS INTEGER)
>2018-08-23T14:51:49.434 D lnav.cc:1977 example result: 11
>2018-08-23T14:51:49.434 I command_executor.cc:113 Executing SQL: SELECT replicate('abc', 3)
>2018-08-23T14:51:49.434 D lnav.cc:1975 example: SELECT replicate('abc', 3)
>2018-08-23T14:51:49.434 D lnav.cc:1977 example result: abcabcabc
>2018-08-23T14:51:49.434 I command_executor.cc:440 Executing file: /root/.lnav/session
>2018-08-23T14:51:49.434 D log_format_loader.cc:1039 Searching for script in path: /etc/lnav/formats/*/*.lnav
>2018-08-23T14:51:49.434 D log_format_loader.cc:1039 Searching for script in path: /etc/lnav/formats/*/*.lnav
>2018-08-23T14:51:49.434 D log_format_loader.cc:1039 Searching for script in path: /root/.lnav//formats/*/*.lnav
>2018-08-23T14:51:49.434 D log_format_loader.cc:1051   found script: /root/.lnav//formats/default/dhclient-summary.lnav
>2018-08-23T14:51:49.434 D log_format_loader.cc:1051   found script: /root/.lnav//formats/default/lnav-pop-view.lnav
>2018-08-23T14:51:49.434 D log_format_loader.cc:1051   found script: /root/.lnav//formats/default/partition-by-boot.lnav
>2018-08-23T14:51:49.434 D log_format_loader.cc:1051   found script: /root/.lnav//formats/default/search-for.lnav
>2018-08-23T14:51:49.769 I logfile.cc:190 /var/log/messages:1:log format found -- syslog_log
>2018-08-23T14:51:49.769 I lnav.cc:512 promoting text file to log file: /var/log/messages
>2018-08-23T14:51:49.770 E lnav_log.cc:321 Received signal: 6
>lnav(+0xbb7bd)[0x5571b090b7bd]
>/lib64/libc.so.6(+0x37070)[0x7ff1d00df070]
>/lib64/libc.so.6(gsignal+0x10b)[0x7ff1d00defeb]
>/lib64/libc.so.6(abort+0x12b)[0x7ff1d00c95c1]
>lnav(+0x44008)[0x5571b0894008]
>lnav(+0xe5a2f)[0x5571b0935a2f]
>lnav(+0xe63b0)[0x5571b09363b0]
>lnav(+0xeb185)[0x5571b093b185]
>lnav(+0x4135b)[0x5571b089135b]
>lnav(+0x2c796)[0x5571b087c796]
>/lib64/libc.so.6(__libc_start_main+0xeb)[0x7ff1d00cb24b]
>lnav(+0x382ca)[0x5571b08882ca]
>2018-08-23T14:51:49.770 I lnav_log.cc:171 uname:
>2018-08-23T14:51:49.770 I lnav_log.cc:172   sysname=Linux
>2018-08-23T14:51:49.770 I lnav_log.cc:173   nodename=mharris.usersys.redhat.com
>2018-08-23T14:51:49.770 I lnav_log.cc:174   machine=x86_64
>2018-08-23T14:51:49.770 I lnav_log.cc:175   release=4.17.14-202.fc28.x86_64
>2018-08-23T14:51:49.770 I lnav_log.cc:176   version=#1 SMP Wed Aug 15 12:29:25 UTC 2018
>2018-08-23T14:51:49.770 I lnav_log.cc:177 Environment:
>2018-08-23T14:51:49.770 I lnav_log.cc:178   HOME=/root
>2018-08-23T14:51:49.770 I lnav_log.cc:179   LANG=en_US.UTF-8
>2018-08-23T14:51:49.770 I lnav_log.cc:180   PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
>2018-08-23T14:51:49.770 I lnav_log.cc:181   TERM=xterm-256color
>2018-08-23T14:51:49.770 I lnav_log.cc:182   TZ=(null)
>2018-08-23T14:51:49.770 I lnav_log.cc:183 Process:
>2018-08-23T14:51:49.770 I lnav_log.cc:184   pid=28037
>2018-08-23T14:51:49.770 I lnav_log.cc:185   ppid=28036
>2018-08-23T14:51:49.770 I lnav_log.cc:186   pgrp=28036
>2018-08-23T14:51:49.770 I lnav_log.cc:187   uid=0
>2018-08-23T14:51:49.770 I lnav_log.cc:188   gid=0
>2018-08-23T14:51:49.770 I lnav_log.cc:189   euid=0
>2018-08-23T14:51:49.770 I lnav_log.cc:190   egid=0
>2018-08-23T14:51:49.770 I lnav_log.cc:195   cwd=/tmp
>2018-08-23T14:51:49.770 I lnav_log.cc:197 Executable:
>2018-08-23T14:51:49.770 I lnav_log.cc:198   version=lnav 0.8.3
>2018-08-23T14:51:49.770 I lnav_log.cc:201 rusage:
>2018-08-23T14:51:49.770 I lnav_log.cc:201   utime=0.030183
>2018-08-23T14:51:49.770 I lnav_log.cc:201   stime=0.007047
>2018-08-23T14:51:49.770 I lnav_log.cc:201   maxrss=16768
>2018-08-23T14:51:49.770 I lnav_log.cc:201   ixrss=0
>2018-08-23T14:51:49.770 I lnav_log.cc:201   idrss=0
>2018-08-23T14:51:49.770 I lnav_log.cc:201   isrss=0
>2018-08-23T14:51:49.770 I lnav_log.cc:201   minflt=1405
>2018-08-23T14:51:49.770 I lnav_log.cc:201   majflt=0
>2018-08-23T14:51:49.770 I lnav_log.cc:201   nswap=0
>2018-08-23T14:51:49.770 I lnav_log.cc:201   inblock=0
>2018-08-23T14:51:49.770 I lnav_log.cc:201   oublock=288
>2018-08-23T14:51:49.770 I lnav_log.cc:201   msgsnd=0
>2018-08-23T14:51:49.770 I lnav_log.cc:201   msgrcv=0
>2018-08-23T14:51:49.770 I lnav_log.cc:201   nsignals=0
>2018-08-23T14:51:49.770 I lnav_log.cc:201   nvcsw=4
>2018-08-23T14:51:49.770 I lnav_log.cc:201   nivcsw=1

Actions: View

Attachments on bug 1621912: 1478351 | 1478352 | 1478353 | 1478354