FreeBSD crash on install
David Gessel
Howdy,
looks like an awesome tool, exactly what I was looking for, but
didn't run as expected.
Unfortunately, lnav has crashed, sorry for the inconvenience.
FreeBSD 14.1-RELEASE-p3 GENERIC amd64
2024-09-09T12:13:03.545 D t0 pollable.cc:41 pollable attach
0x2072600290c8 to 0x207260019058
2024-09-09T12:13:03.576 E t0 lnav.cc:2237 failed to setup tz:
Could not get current timezone
2024-09-09T12:13:03.580 I t0 lnav.cc:2550 lnav started
2024-09-09T12:13:03.581 I t0 lnav_config.cc:1801 loading builtin
configuration into default
2024-09-09T12:13:03.591 I t0 lnav_config.cc:1803 loading builtin
configuration into base
2024-09-09T12:13:03.601 I t0 lnav_config.cc:1806 loading installed
configuration files
2024-09-09T12:13:03.601 I t0 lnav_config.cc:1836 loading user
configuration
2024-09-09T12:13:03.601 I t0 lnav_config.cc:1691 loading
configuration from /root/.config/lnav/config.json
2024-09-09T12:13:03.601 I t0 log.annotate.cc:84 preparing
annotation condition expression: SELECT 1 WHERE :log_body LIKE
'%[context]%[/context]%'
2024-09-09T12:13:03.609 D t0 log_format_loader.cc:1356 Loading
default formats
2024-09-09T12:13:03.609 D t0 log_format_loader.cc:86 Loading
format -- access_log
2024-09-09T12:13:03.610 D t0 log_format_loader.cc:86 Loading
format -- alb_log
2024-09-09T12:13:03.610 D t0 log_format_loader.cc:86 Loading
format -- block_log
2024-09-09T12:13:03.611 D t0 log_format_loader.cc:86 Loading
format -- bunyan_log
2024-09-09T12:13:03.611 D t0 log_format_loader.cc:86 Loading
format -- candlepin_log
2024-09-09T12:13:03.611 D t0 log_format_loader.cc:86 Loading
format -- choose_repo_log
2024-09-09T12:13:03.611 D t0 log_format_loader.cc:86 Loading
format -- cloudflare_json_log
2024-09-09T12:13:03.612 D t0 log_format_loader.cc:86 Loading
format -- cloudvm_ram_log
2024-09-09T12:13:03.612 D t0 log_format_loader.cc:86 Loading
format -- cups_log
2024-09-09T12:13:03.612 D t0 log_format_loader.cc:86 Loading
format -- dpkg_log
2024-09-09T12:13:03.613 D t0 log_format_loader.cc:86 Loading
format -- elb_log
2024-09-09T12:13:03.613 D t0 log_format_loader.cc:86 Loading
format -- engine_log
2024-09-09T12:13:03.613 D t0 log_format_loader.cc:86 Loading
format -- error_log
2024-09-09T12:13:03.614 D t0 log_format_loader.cc:86 Loading
format -- esx_syslog_log
2024-09-09T12:13:03.614 D t0 log_format_loader.cc:86 Loading
format -- fsck_hfs_log
2024-09-09T12:13:03.614 D t0 log_format_loader.cc:86 Loading
format -- github_events_log
2024-09-09T12:13:03.615 D t0 log_format_loader.cc:86 Loading
format -- glog_log
2024-09-09T12:13:03.615 D t0 log_format_loader.cc:86 Loading
format -- haproxy_log
2024-09-09T12:13:03.616 D t0 log_format_loader.cc:86 Loading
format -- java_log
2024-09-09T12:13:03.617 D t0 log_format_loader.cc:86 Loading
format -- journald_json_log
2024-09-09T12:13:03.617 D t0 log_format_loader.cc:86 Loading
format -- katello_log
2024-09-09T12:13:03.617 D t0 log_format_loader.cc:86 Loading
format -- nextcloud
2024-09-09T12:13:03.618 D t0 log_format_loader.cc:86 Loading
format -- nextflow_log
2024-09-09T12:13:03.618 D t0 log_format_loader.cc:86 Loading
format -- openam_log
2024-09-09T12:13:03.618 D t0 log_format_loader.cc:86 Loading
format -- openamdb_log
2024-09-09T12:13:03.618 D t0 log_format_loader.cc:86 Loading
format -- openstack_log
2024-09-09T12:13:03.619 D t0 log_format_loader.cc:86 Loading
format -- page_log
2024-09-09T12:13:03.619 D t0 log_format_loader.cc:86 Loading
format -- papertrail_log
2024-09-09T12:13:03.619 D t0 log_format_loader.cc:86 Loading
format -- pcap_log
2024-09-09T12:13:03.619 D t0 log_format_loader.cc:86 Loading
format -- procstate_log
2024-09-09T12:13:03.620 D t0 log_format_loader.cc:86 Loading
format -- redis_log
2024-09-09T12:13:03.620 D t0 log_format_loader.cc:86 Loading
format -- snaplogic_log
2024-09-09T12:13:03.620 D t0 log_format_loader.cc:86 Loading
format -- sssd_log
2024-09-09T12:13:03.621 D t0 log_format_loader.cc:86 Loading
format -- strace_log
2024-09-09T12:13:03.621 D t0 log_format_loader.cc:86 Loading
format -- sudo_log
2024-09-09T12:13:03.621 D t0 log_format_loader.cc:86 Loading
format -- syslog_log
2024-09-09T12:13:03.621 D t0 log_format_loader.cc:86 Loading
format -- s3_log
2024-09-09T12:13:03.622 D t0 log_format_loader.cc:86 Loading
format -- tcf_log
2024-09-09T12:13:03.622 D t0 log_format_loader.cc:86 Loading
format -- tcsh_history
2024-09-09T12:13:03.622 D t0 log_format_loader.cc:86 Loading
format -- unifi_log
2024-09-09T12:13:03.624 D t0 log_format_loader.cc:86 Loading
format -- uwsgi_log
2024-09-09T12:13:03.624 D t0 log_format_loader.cc:86 Loading
format -- vdsm_log
2024-09-09T12:13:03.624 D t0 log_format_loader.cc:86 Loading
format -- vmk_log
2024-09-09T12:13:03.625 D t0 log_format_loader.cc:86 Loading
format -- vmw_log
2024-09-09T12:13:03.627 D t0 log_format_loader.cc:86 Loading
format -- vmw_vc_svc_log
2024-09-09T12:13:03.628 D t0 log_format_loader.cc:86 Loading
format -- vmw_py_log
2024-09-09T12:13:03.628 D t0 log_format_loader.cc:86 Loading
format -- vpostgres_log
2024-09-09T12:13:03.628 D t0 log_format_loader.cc:86 Loading
format -- xmlrpc_log
2024-09-09T12:13:03.628 I t0 log_format_loader.cc:1319 loading
formats from path: /etc/lnav/formats/*/*.json
2024-09-09T12:13:03.628 I t0 log_format_loader.cc:1319 loading
formats from path: /usr/local/etc/lnav/formats/*/*.json
2024-09-09T12:13:03.628 I t0 log_format_loader.cc:1319 loading
formats from path: /root/.config/lnav/formats/*/*.json
2024-09-09T12:13:03.629 W t0 log_format.cc:2883
/alb_log/regex/std:body field 'body' not found in pattern
2024-09-09T12:13:03.629 W t0 log_format.cc:2871
/block_log/regex/sq-brackets:level field 'level' not found in
pattern
2024-09-09T12:13:03.629 W t0 log_format.cc:2871
/block_log/regex/std:level field 'level' not found in pattern
2024-09-09T12:13:03.629 W t0 log_format.cc:2871
/candlepin_log/regex/other:level field 'level' not found in
pattern
2024-09-09T12:13:03.629 W t0 log_format.cc:2871
/candlepin_log/regex/reqorg:level field 'level' not found in
pattern
2024-09-09T12:13:03.629 W t0 log_format.cc:2871
/cloudvm_ram_log/regex/std:level field 'level' not found in
pattern
2024-09-09T12:13:03.629 W t0 log_format_loader.cc:1411 Format
collision, format 'cups_log' matches sample from 'error_log'
2024-09-09T12:13:03.629 W t0 log_format.cc:2871
/dpkg_log/regex/std:level field 'level' not found in pattern
2024-09-09T12:13:03.629 W t0 log_format_loader.cc:1411 Format
collision, format 'error_log' matches sample from 'cups_log'
2024-09-09T12:13:03.630 W t0 log_format_loader.cc:1411 Format
collision, format 'esx_syslog_log' matches sample from 'vmk_log'
2024-09-09T12:13:03.630 W t0 log_format_loader.cc:1411 Format
collision, format 'esx_syslog_log' matches sample from 'vmw_log'
2024-09-09T12:13:03.630 W t0 log_format.cc:2871
/fsck_hfs_log/regex/std:level field 'level' not found in pattern
2024-09-09T12:13:03.630 W t0 log_format.cc:2871
/haproxy_log/regex/event_started:level field 'level' not found in
pattern
2024-09-09T12:13:03.630 W t0 log_format.cc:2883
/haproxy_log/regex/event_started:body field 'body' not found in
pattern
2024-09-09T12:13:03.630 W t0 log_format.cc:2871
/haproxy_log/regex/event_stopped:level field 'level' not found in
pattern
2024-09-09T12:13:03.630 W t0 log_format.cc:2883
/haproxy_log/regex/event_stopped:body field 'body' not found in
pattern
2024-09-09T12:13:03.630 W t0 log_format.cc:2871
/haproxy_log/regex/event_stopping:level field 'level' not found in
pattern
2024-09-09T12:13:03.630 W t0 log_format.cc:2883
/haproxy_log/regex/event_stopping:body field 'body' not found in
pattern
2024-09-09T12:13:03.630 W t0 log_format.cc:2871
/haproxy_log/regex/http:level field 'level' not found in pattern
2024-09-09T12:13:03.630 W t0 log_format.cc:2883
/haproxy_log/regex/http:body field 'body' not found in pattern
2024-09-09T12:13:03.630 W t0 log_format.cc:2871
/haproxy_log/regex/ssl:level field 'level' not found in pattern
2024-09-09T12:13:03.630 W t0 log_format.cc:2883
/haproxy_log/regex/ssl:body field 'body' not found in pattern
2024-09-09T12:13:03.630 W t0 log_format.cc:2871
/haproxy_log/regex/tcp:level field 'level' not found in pattern
2024-09-09T12:13:03.630 W t0 log_format.cc:2883
/haproxy_log/regex/tcp:body field 'body' not found in pattern
2024-09-09T12:13:03.631 W t0 log_format_loader.cc:1411 Format
collision, format 'java_log' matches sample from 'vmw_log'
2024-09-09T12:13:03.631 W t0 log_format.cc:2883
/katello_log/regex/log:body field 'body' not found in pattern
2024-09-09T12:13:03.631 W t0 log_format.cc:2871
/openamdb_log/regex/std:level field 'level' not found in pattern
2024-09-09T12:13:03.631 W t0 log_format_loader.cc:1411 Format
collision, format 'openstack_log' matches sample from 's3_log'
2024-09-09T12:13:03.631 W t0 log_format.cc:2871
/page_log/regex/1.7:level field 'level' not found in pattern
2024-09-09T12:13:03.631 W t0 log_format.cc:2871
/page_log/regex/pre-1.7:level field 'level' not found in pattern
2024-09-09T12:13:03.631 W t0 log_format.cc:2883
/page_log/regex/pre-1.7:body field 'body' not found in pattern
2024-09-09T12:13:03.631 I t0 log_format.cc:2947 preparing
file-format header expression: SELECT 1 WHERE :header REGEXP
'^(?:a1b2c3d4|d4c3b2a1|a1b23c4d|4d3cb2a1).*'
2024-09-09T12:13:03.631 I t0 log_format.cc:2947 preparing
file-format header expression: SELECT 1 WHERE :header REGEXP
'^0a0d0d0a.{8}(?:1a2b3c4d|4d3c2b1a).*'
2024-09-09T12:13:03.631 W t0 log_format.cc:2871
/procstate_log/regex/std:level field 'level' not found in pattern
2024-09-09T12:13:03.631 W t0 log_format.cc:2871
/redis_log/regex/sig:level field 'level' not found in pattern
2024-09-09T12:13:03.632 W t0 log_format.cc:2883
/s3_log/regex/std:body field 'body' not found in pattern
2024-09-09T12:13:03.632 W t0 log_format.cc:2883
/s3_log/regex/std-v2:body field 'body' not found in pattern
2024-09-09T12:13:03.632 W t0 log_format.cc:2883
/sudo_log/regex/std:body field 'body' not found in pattern
2024-09-09T12:13:03.632 W t0 log_format_loader.cc:1411 Format
collision, format 'syslog_log' matches sample from 'elb_log'
2024-09-09T12:13:03.632 W t0 log_format_loader.cc:1411 Format
collision, format 'syslog_log' matches sample from 'haproxy_log'
2024-09-09T12:13:03.632 W t0 log_format_loader.cc:1411 Format
collision, format 'syslog_log' matches sample from 'java_log'
2024-09-09T12:13:03.632 W t0 log_format_loader.cc:1411 Format
collision, format 'syslog_log' matches sample from 'vmk_log'
2024-09-09T12:13:03.632 W t0 log_format_loader.cc:1411 Format
collision, format 'syslog_log' matches sample from 'vmw_log'
2024-09-09T12:13:03.632 W t0 log_format.cc:2871
/tcf_log/regex/std:level field 'level' not found in pattern
2024-09-09T12:13:03.632 W t0 log_format.cc:2871
/tcsh_history/regex/std:level field 'level' not found in pattern
2024-09-09T12:13:03.633 W t0 log_format.cc:2883
/vmw_log/regex/esx-section:body field 'body' not found in pattern
2024-09-09T12:13:03.633 W t0 log_format.cc:2871
/vmw_log/regex/hdr-ftr:level field 'level' not found in pattern
2024-09-09T12:13:03.633 W t0 log_format.cc:2871
/vmw_log/regex/section:level field 'level' not found in pattern
2024-09-09T12:13:03.633 W t0 log_format.cc:2883
/vmw_log/regex/section:body field 'body' not found in pattern
2024-09-09T12:13:03.634 W t0 log_format_loader.cc:1411 Format
collision, format 'vmw_log' matches sample from 'esx_syslog_log'
2024-09-09T12:13:03.634 W t0 log_format.cc:2871
/xmlrpc_log/regex/main:level field 'level' not found in pattern
2024-09-09T12:13:03.634 W t0 log_format_loader.cc:1440 Detected a
cycle...
2024-09-09T12:13:03.634 W t0 log_format_loader.cc:1444 Skipping
builtin format -- cups_log
2024-09-09T12:13:03.634 W t0 log_format_loader.cc:1444 Skipping
builtin format -- error_log
2024-09-09T12:13:03.634 W t0 log_format_loader.cc:1444 Skipping
builtin format -- esx_syslog_log
2024-09-09T12:13:03.634 W t0 log_format_loader.cc:1444 Skipping
builtin format -- java_log
2024-09-09T12:13:03.634 W t0 log_format_loader.cc:1444 Skipping
builtin format -- syslog_log
2024-09-09T12:13:03.634 W t0 log_format_loader.cc:1444 Skipping
builtin format -- vmw_log
2024-09-09T12:13:03.634 W t0 log_format_loader.cc:1440 Detected a
cycle...
2024-09-09T12:13:03.634 W t0 log_format_loader.cc:1444 Skipping
builtin format -- esx_syslog_log
2024-09-09T12:13:03.634 W t0 log_format_loader.cc:1444 Skipping
builtin format -- java_log
2024-09-09T12:13:03.634 W t0 log_format_loader.cc:1444 Skipping
builtin format -- syslog_log
2024-09-09T12:13:03.634 W t0 log_format_loader.cc:1444 Skipping
builtin format -- vmw_log
2024-09-09T12:13:03.634 I t0 log_format_loader.cc:1465 Format
order:
2024-09-09T12:13:03.634 I t0 log_format_loader.cc:1468
access_log
2024-09-09T12:13:03.634 I t0 log_format_loader.cc:1468 alb_log
2024-09-09T12:13:03.634 I t0 log_format_loader.cc:1468 block_log
2024-09-09T12:13:03.634 I t0 log_format_loader.cc:1468
bunyan_log
2024-09-09T12:13:03.634 I t0 log_format_loader.cc:1468
candlepin_log
2024-09-09T12:13:03.634 I t0 log_format_loader.cc:1468
choose_repo_log
2024-09-09T12:13:03.634 I t0 log_format_loader.cc:1468
cloudflare_json_log
2024-09-09T12:13:03.634 I t0 log_format_loader.cc:1468
cloudvm_ram_log
2024-09-09T12:13:03.634 I t0 log_format_loader.cc:1468 dpkg_log
2024-09-09T12:13:03.634 I t0 log_format_loader.cc:1468 elb_log
2024-09-09T12:13:03.634 I t0 log_format_loader.cc:1468
engine_log
2024-09-09T12:13:03.634 I t0 log_format_loader.cc:1468
fsck_hfs_log
2024-09-09T12:13:03.634 I t0 log_format_loader.cc:1468
github_events_log
2024-09-09T12:13:03.634 I t0 log_format_loader.cc:1468 glog_log
2024-09-09T12:13:03.634 I t0 log_format_loader.cc:1468
haproxy_log
2024-09-09T12:13:03.634 I t0 log_format_loader.cc:1468
journald_json_log
2024-09-09T12:13:03.634 I t0 log_format_loader.cc:1468
katello_log
2024-09-09T12:13:03.634 I t0 log_format_loader.cc:1468 nextcloud
2024-09-09T12:13:03.634 I t0 log_format_loader.cc:1468
nextflow_log
2024-09-09T12:13:03.634 I t0 log_format_loader.cc:1468
openam_log
2024-09-09T12:13:03.634 I t0 log_format_loader.cc:1468
openamdb_log
2024-09-09T12:13:03.634 I t0 log_format_loader.cc:1468 page_log
2024-09-09T12:13:03.634 I t0 log_format_loader.cc:1468
papertrail_log
2024-09-09T12:13:03.634 I t0 log_format_loader.cc:1468 pcap_log
2024-09-09T12:13:03.634 I t0 log_format_loader.cc:1468
procstate_log
2024-09-09T12:13:03.634 I t0 log_format_loader.cc:1468 redis_log
2024-09-09T12:13:03.634 I t0 log_format_loader.cc:1468 s3_log
2024-09-09T12:13:03.634 I t0 log_format_loader.cc:1468
snaplogic_log
2024-09-09T12:13:03.634 I t0 log_format_loader.cc:1468 sssd_log
2024-09-09T12:13:03.634 I t0 log_format_loader.cc:1468
strace_log
2024-09-09T12:13:03.634 I t0 log_format_loader.cc:1468 sudo_log
2024-09-09T12:13:03.634 I t0 log_format_loader.cc:1468 tcf_log
2024-09-09T12:13:03.634 I t0 log_format_loader.cc:1468
tcsh_history
2024-09-09T12:13:03.634 I t0 log_format_loader.cc:1468 unifi_log
2024-09-09T12:13:03.634 I t0 log_format_loader.cc:1468 uwsgi_log
2024-09-09T12:13:03.634 I t0 log_format_loader.cc:1468 vdsm_log
2024-09-09T12:13:03.634 I t0 log_format_loader.cc:1468 vmk_log
2024-09-09T12:13:03.634 I t0 log_format_loader.cc:1468
vmw_py_log
2024-09-09T12:13:03.634 I t0 log_format_loader.cc:1468
vmw_vc_svc_log
2024-09-09T12:13:03.634 I t0 log_format_loader.cc:1468
vpostgres_log
2024-09-09T12:13:03.634 I t0 log_format_loader.cc:1468
xmlrpc_log
2024-09-09T12:13:03.634 I t0 log_format_loader.cc:1468
openstack_log
2024-09-09T12:13:03.634 I t0 log_format_loader.cc:1468 cups_log
2024-09-09T12:13:03.634 I t0 log_format_loader.cc:1468 error_log
2024-09-09T12:13:03.634 I t0 log_format_loader.cc:1468
esx_syslog_log
2024-09-09T12:13:03.634 I t0 log_format_loader.cc:1468 vmw_log
2024-09-09T12:13:03.634 I t0 log_format_loader.cc:1468 java_log
2024-09-09T12:13:03.634 I t0 log_format_loader.cc:1468
syslog_log
2024-09-09T12:13:03.635 D t0 log_vtab_impl.cc:360 creating log
format table: all_logs = 0x0
2024-09-09T12:13:03.635 D t0 log_vtab_impl.cc:360 creating log
format table: generic_log = 0x0
2024-09-09T12:13:03.635 D t0 log_vtab_impl.cc:360 creating log
format table: lnav_piper_log = 0x0
2024-09-09T12:13:03.635 D t0 log_vtab_impl.cc:360 creating log
format table: logfmt_log = 0x0
2024-09-09T12:13:03.636 D t0 log_vtab_impl.cc:360 creating log
format table: access_log = 0x0
2024-09-09T12:13:03.636 D t0 log_vtab_impl.cc:360 creating log
format table: alb_log = 0x0
2024-09-09T12:13:03.636 D t0 log_vtab_impl.cc:360 creating log
format table: block_log = 0x0
2024-09-09T12:13:03.636 D t0 log_vtab_impl.cc:360 creating log
format table: bunyan_log = 0x0
2024-09-09T12:13:03.636 D t0 log_vtab_impl.cc:360 creating log
format table: candlepin_log = 0x0
2024-09-09T12:13:03.636 D t0 log_vtab_impl.cc:360 creating log
format table: choose_repo_log = 0x0
2024-09-09T12:13:03.636 D t0 log_vtab_impl.cc:360 creating log
format table: cloudflare_json_log = 0x0
2024-09-09T12:13:03.636 D t0 log_vtab_impl.cc:360 creating log
format table: cloudvm_ram_log = 0x0
2024-09-09T12:13:03.636 D t0 log_vtab_impl.cc:360 creating log
format table: dpkg_log = 0x0
2024-09-09T12:13:03.636 D t0 log_vtab_impl.cc:360 creating log
format table: elb_log = 0x0
2024-09-09T12:13:03.637 D t0 log_vtab_impl.cc:360 creating log
format table: engine_log = 0x0
2024-09-09T12:13:03.637 D t0 log_vtab_impl.cc:360 creating log
format table: fsck_hfs_log = 0x0
2024-09-09T12:13:03.637 D t0 log_vtab_impl.cc:360 creating log
format table: github_events_log = 0x0
2024-09-09T12:13:03.637 D t0 log_vtab_impl.cc:360 creating log
format table: glog_log = 0x0
2024-09-09T12:13:03.637 D t0 log_vtab_impl.cc:360 creating log
format table: haproxy_log = 0x0
2024-09-09T12:13:03.637 D t0 log_vtab_impl.cc:360 creating log
format table: journald_json_log = 0x0
2024-09-09T12:13:03.637 D t0 log_vtab_impl.cc:360 creating log
format table: katello_log = 0x0
2024-09-09T12:13:03.637 D t0 log_vtab_impl.cc:360 creating log
format table: nextcloud = 0x0
2024-09-09T12:13:03.637 D t0 log_vtab_impl.cc:360 creating log
format table: nextflow_log = 0x0
2024-09-09T12:13:03.637 D t0 log_vtab_impl.cc:360 creating log
format table: openam_log = 0x0
2024-09-09T12:13:03.637 D t0 log_vtab_impl.cc:360 creating log
format table: openamdb_log = 0x0
2024-09-09T12:13:03.638 D t0 log_vtab_impl.cc:360 creating log
format table: page_log = 0x0
2024-09-09T12:13:03.638 D t0 log_vtab_impl.cc:360 creating log
format table: papertrail_log = 0x0
2024-09-09T12:13:03.638 D t0 log_vtab_impl.cc:360 creating log
format table: pcap_log = 0x0
2024-09-09T12:13:03.638 D t0 log_vtab_impl.cc:360 creating log
format table: procstate_log = 0x0
2024-09-09T12:13:03.638 D t0 log_vtab_impl.cc:360 creating log
format table: redis_log = 0x0
2024-09-09T12:13:03.638 D t0 log_vtab_impl.cc:360 creating log
format table: s3_log = 0x0
2024-09-09T12:13:03.638 D t0 log_vtab_impl.cc:360 creating log
format table: snaplogic_log = 0x0
2024-09-09T12:13:03.638 D t0 log_vtab_impl.cc:360 creating log
format table: sssd_log = 0x0
2024-09-09T12:13:03.638 D t0 log_vtab_impl.cc:360 creating log
format table: strace_log = 0x0
2024-09-09T12:13:03.638 D t0 log_vtab_impl.cc:360 creating log
format table: sudo_log = 0x0
2024-09-09T12:13:03.638 D t0 log_vtab_impl.cc:360 creating log
format table: tcf_log = 0x0
2024-09-09T12:13:03.639 D t0 log_vtab_impl.cc:360 creating log
format table: tcsh_history = 0x0
2024-09-09T12:13:03.639 D t0 log_vtab_impl.cc:360 creating log
format table: unifi_log = 0x0
2024-09-09T12:13:03.639 D t0 log_vtab_impl.cc:360 creating log
format table: uwsgi_log = 0x0
2024-09-09T12:13:03.639 D t0 log_vtab_impl.cc:360 creating log
format table: vdsm_log = 0x0
2024-09-09T12:13:03.639 D t0 log_vtab_impl.cc:360 creating log
format table: vmk_log = 0x0
2024-09-09T12:13:03.639 D t0 log_vtab_impl.cc:360 creating log
format table: vmw_py_log = 0x0
2024-09-09T12:13:03.639 D t0 log_vtab_impl.cc:360 creating log
format table: vmw_vc_svc_log = 0x0
2024-09-09T12:13:03.639 D t0 log_vtab_impl.cc:360 creating log
format table: vpostgres_log = 0x0
2024-09-09T12:13:03.639 D t0 log_vtab_impl.cc:360 creating log
format table: xmlrpc_log = 0x0
2024-09-09T12:13:03.639 D t0 log_vtab_impl.cc:360 creating log
format table: openstack_log = 0x0
2024-09-09T12:13:03.639 D t0 log_vtab_impl.cc:360 creating log
format table: cups_log = 0x0
2024-09-09T12:13:03.640 D t0 log_vtab_impl.cc:360 creating log
format table: error_log = 0x0
2024-09-09T12:13:03.640 D t0 log_vtab_impl.cc:360 creating log
format table: esx_syslog_log = 0x0
2024-09-09T12:13:03.640 D t0 log_vtab_impl.cc:360 creating log
format table: vmw_log = 0x0
2024-09-09T12:13:03.640 D t0 log_vtab_impl.cc:360 creating log
format table: java_log = 0x0
2024-09-09T12:13:03.640 D t0 log_vtab_impl.cc:360 creating log
format table: syslog_log = 0x0
2024-09-09T12:13:03.640 I t0 log_format_loader.cc:1488 executing
SQL files in path: /etc/lnav/formats/*/*.sql
2024-09-09T12:13:03.640 I t0 log_format_loader.cc:1488 executing
SQL files in path: /usr/local/etc/lnav/formats/*/*.sql
2024-09-09T12:13:03.640 I t0 log_format_loader.cc:1488 executing
SQL files in path: /root/.config/lnav/formats/*/*.sql
2024-09-09T12:13:03.640 D t0 log_vtab_impl.cc:360 creating log
format table: cloudvm_ram_sizes = 0x0
2024-09-09T12:13:03.641 D t0 log_vtab_impl.cc:360 creating log
format table: procstate_procs = 0x0
2024-09-09T12:13:03.641 D t0 log_vtab_impl.cc:360 creating log
format table: vpx_lro_begin = 0x0
2024-09-09T12:13:03.641 D t0 log_vtab_impl.cc:360 creating log
format table: vpx_lro_error = 0x0
2024-09-09T12:13:03.641 D t0 log_vtab_impl.cc:360 creating log
format table: vpx_lro_finish = 0x0
2024-09-09T12:13:03.641 D t0 log_vtab_impl.cc:360 creating log
format table: vpxd_session_pool_stats = 0x0
2024-09-09T12:13:03.642 D t0 log_vtab_impl.cc:360 creating log
format table: vpxd_session_stats = 0x0
2024-09-09T12:13:03.642 D t0 isc.cc:43 starting service thread
for: isc::service<curl_looper>::service(std::string) [T =
curl_looper]
2024-09-09T12:13:03.642 D t0 isc.cc:43 starting service thread
for: isc::service<io_looper>::service(std::string) [T =
io_looper]
2024-09-09T12:13:03.642 D t0 isc.cc:43 starting service thread
for: isc::service<tailer::looper>::service(std::string) [T =
tailer::looper]
2024-09-09T12:13:03.642 I t0 lnav.cc:3290 startup: lnav 0.12.2
2024-09-09T12:13:03.642 I t0 lnav_log.cc:221 uname:
2024-09-09T12:13:03.642 I t0 lnav_log.cc:222 sysname=FreeBSD
2024-09-09T12:13:03.642 I t0 lnav_log.cc:223 nodename=matanawa
2024-09-09T12:13:03.642 I t0 lnav_log.cc:224 machine=amd64
2024-09-09T12:13:03.642 I t0 lnav_log.cc:225
release=14.1-RELEASE-p3
2024-09-09T12:13:03.642 I t0 lnav_log.cc:226 version=FreeBSD
14.1-RELEASE-p3 GENERIC
2024-09-09T12:13:03.642 I t0 lnav_log.cc:227 PCRE:
2024-09-09T12:13:03.642 I t0 lnav_log.cc:228 jit=1
2024-09-09T12:13:03.642 I t0 lnav_log.cc:229 jittarget=x86 64bit
(little endian + unaligned)
2024-09-09T12:13:03.642 I t0 lnav_log.cc:230 Environment:
2024-09-09T12:13:03.642 I t0 lnav_log.cc:231 HOME=/root
2024-09-09T12:13:03.642 I t0 lnav_log.cc:232
XDG_CONFIG_HOME=(null)
2024-09-09T12:13:03.642 I t0 lnav_log.cc:233 LANG=C.UTF-8
2024-09-09T12:13:03.642 I t0 lnav_log.cc:234
PATH=/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/sbin:/usr/local/bin:/root/bin
2024-09-09T12:13:03.642 I t0 lnav_log.cc:235
TERM=screen-256color
2024-09-09T12:13:03.642 I t0 lnav_log.cc:236 TZ=(null)
2024-09-09T12:13:03.642 I t0 lnav_log.cc:237 Process:
2024-09-09T12:13:03.642 I t1 isc.cc:51 BEGIN isc thread:
isc::service<curl_looper>::service(std::string) [T =
curl_looper]
2024-09-09T12:13:03.642 I t0 lnav_log.cc:238 pid=6842
2024-09-09T12:13:03.642 I t2 isc.cc:51 BEGIN isc thread:
isc::service<io_looper>::service(std::string) [T =
io_looper]
2024-09-09T12:13:03.642 I t3 isc.cc:51 BEGIN isc thread:
isc::service<tailer::looper>::service(std::string) [T =
tailer::looper]
2024-09-09T12:13:03.642 I t0 lnav_log.cc:239 ppid=49994
2024-09-09T12:13:03.642 I t0 lnav_log.cc:240 pgrp=6842
2024-09-09T12:13:03.642 I t0 lnav_log.cc:241 uid=0
2024-09-09T12:13:03.642 I t0 lnav_log.cc:242 gid=0
2024-09-09T12:13:03.642 I t0 lnav_log.cc:243 euid=0
2024-09-09T12:13:03.642 I t0 lnav_log.cc:244 egid=0
2024-09-09T12:13:03.642 I t0 lnav_log.cc:248 cwd=/var/log
2024-09-09T12:13:03.642 I t0 lnav_log.cc:250 Executable:
2024-09-09T12:13:03.642 I t0 lnav_log.cc:251 version=lnav 0.12.2
2024-09-09T12:13:03.642 I t0 lnav_log.cc:254 rusage:
2024-09-09T12:13:03.642 I t0 lnav_log.cc:254 utime=0.085496
2024-09-09T12:13:03.642 I t0 lnav_log.cc:254 stime=0.017099
2024-09-09T12:13:03.642 I t0 lnav_log.cc:254 maxrss=36680
2024-09-09T12:13:03.642 I t0 lnav_log.cc:254 ixrss=76992
2024-09-09T12:13:03.642 I t0 lnav_log.cc:254 idrss=5568
2024-09-09T12:13:03.642 I t0 lnav_log.cc:254 isrss=1536
2024-09-09T12:13:03.642 I t0 lnav_log.cc:254 minflt=2566
2024-09-09T12:13:03.642 I t0 lnav_log.cc:254 majflt=148
2024-09-09T12:13:03.642 I t0 lnav_log.cc:254 nswap=0
2024-09-09T12:13:03.642 I t0 lnav_log.cc:254 inblock=6
2024-09-09T12:13:03.642 I t0 lnav_log.cc:254 oublock=75
2024-09-09T12:13:03.642 I t0 lnav_log.cc:254 msgsnd=0
2024-09-09T12:13:03.642 I t0 lnav_log.cc:254 msgrcv=0
2024-09-09T12:13:03.642 I t0 lnav_log.cc:254 nsignals=0
2024-09-09T12:13:03.642 I t0 lnav_log.cc:254 nvcsw=31
2024-09-09T12:13:03.642 I t0 lnav_log.cc:254 nivcsw=0
2024-09-09T12:13:03.642 I t0 lnav.cc:3292 Libraries:
2024-09-09T12:13:03.642 I t0 lnav.cc:3294 bzip=1.0.8,
13-Jul-2019
2024-09-09T12:13:03.642 I t0 lnav.cc:3297 curl=8.9.1
(2024-07-31)
2024-09-09T12:13:03.642 I t0 lnav.cc:3300 libarchive=3007004
2024-09-09T12:13:03.642 I t0 lnav.cc:3301 details=libarchive
3.7.4 zlib/1.3.1 liblzma/5.4.5 bz2lib/1.0.8 libzstd/1.5.2
2024-09-09T12:13:03.642 I t0 lnav.cc:3303 ncurses=6.2
2024-09-09T12:13:03.642 I t0 lnav.cc:3304 pcre2=10.43 2024-02-16
2024-09-09T12:13:03.642 I t0 lnav.cc:3305 readline=8.2
2024-09-09T12:13:03.643 I t0 lnav.cc:3306 sqlite=3.46.1
2024-09-09T12:13:03.643 I t0 lnav.cc:3307 zlib=1.3.1
2024-09-09T12:13:03.643 I t0 lnav.cc:3308 lnav_data:
2024-09-09T12:13:03.643 I t0 lnav.cc:3309 flags=0
2024-09-09T12:13:03.643 I t0 lnav.cc:3310 commands:
2024-09-09T12:13:03.643 I t0 lnav.cc:3317 files:
2024-09-09T12:13:03.643 I t0 lnav.cc:3323 /var/log/messages
2024-09-09T12:13:03.643 D t0 pollable.cc:41 pollable attach
0x207260aa80c8 to 0x207260019058
2024-09-09T12:13:03.650 D t0 view_curses.cc:724 COLOR_PAIRS =
32767
2024-09-09T12:13:03.668 I t0 command_executor.cc:312 Executing
SQL: SELECT 3 BETWEEN 5 AND 10
2024-09-09T12:13:03.668 I t0 command_executor.cc:406
sqlite3_changes() -> 1
2024-09-09T12:13:03.668 I t0 command_executor.cc:312 Executing
SQL: SELECT 10 BETWEEN 5 AND 10
2024-09-09T12:13:03.668 I t0 command_executor.cc:406
sqlite3_changes() -> 1
2024-09-09T12:13:03.668 I t0 command_executor.cc:312 Executing
SQL: SELECT CAST(1.23 AS INTEGER)
2024-09-09T12:13:03.668 I t0 command_executor.cc:406
sqlite3_changes() -> 1
2024-09-09T12:13:03.668 I t0 command_executor.cc:312 Executing
SQL: SELECT CASE 1 WHEN 0 THEN 'zero' WHEN 1 THEN 'one' END
2024-09-09T12:13:03.668 I t0 command_executor.cc:406
sqlite3_changes() -> 1
2024-09-09T12:13:03.668 I t0 command_executor.cc:312 Executing
SQL: SELECT ('a2' < 'a10'), ('a2' < 'a10' COLLATE
naturalnocase)
2024-09-09T12:13:03.668 I t0 command_executor.cc:406
sqlite3_changes() -> 1
2024-09-09T12:13:03.668 I t0 command_executor.cc:312 Executing
SQL: DETACH DATABASE customers
2024-09-09T12:13:03.668 E t0 sql_util.cc:552 (1) statement aborts
at 4: [DETACH DATABASE customers] no such database: customers
2024-09-09T12:13:03.668 E t0 command_executor.cc:443 sqlite3_step
error code: 1
2024-09-09T12:13:03.668 I t0 command_executor.cc:312 Executing
SQL: SELECT 'foobar.log' GLOB '*.log'
2024-09-09T12:13:03.668 I t0 command_executor.cc:406
sqlite3_changes() -> 1
2024-09-09T12:13:03.668 I t0 command_executor.cc:312 Executing
SQL: SELECT 'Hello, World!' LIKE 'Hello, %!'
2024-09-09T12:13:03.668 I t0 command_executor.cc:406
sqlite3_changes() -> 1
2024-09-09T12:13:03.668 I t0 command_executor.cc:312 Executing
SQL: SELECT 'file-23' REGEXP 'file-\d+'
2024-09-09T12:13:03.668 I t0 command_executor.cc:406
sqlite3_changes() -> 1
2024-09-09T12:13:03.668 I t0 command_executor.cc:312 Executing
SQL: SELECT * FROM syslog_log
2024-09-09T12:13:03.668 I t0 log_vtab_impl.cc:1773
vt_best_index(syslog_log, nConstraint=0)
2024-09-09T12:13:03.668 I t0 command_executor.cc:406
sqlite3_changes() -> 1
2024-09-09T12:13:03.668 I t0 command_executor.cc:312 Executing
SQL: INSERT INTO environ VALUES ('MSG', 'HELLO, WORLD!')
2024-09-09T12:13:03.669 I t0 command_executor.cc:406
sqlite3_changes() -> 1
2024-09-09T12:13:03.669 I t0 command_executor.cc:312 Executing
SQL: UPDATE syslog_log SET log_mark = 1 WHERE log_line = 40
2024-09-09T12:13:03.669 I t0 log_vtab_impl.cc:1773
vt_best_index(syslog_log, nConstraint=1)
2024-09-09T12:13:03.669 D t0 log_vtab_impl.cc:1795 column 0: op:
=
2024-09-09T12:13:03.669 I t0 log_vtab_impl.cc:1919 found index:
SEARCH syslog_log USING log_line = ?
2024-09-09T12:13:03.669 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.669 I t0 command_executor.cc:312 Executing
SQL: SELECT abs(-1)
2024-09-09T12:13:03.669 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.669 I t0 command_executor.cc:312 Executing
SQL: SELECT acos(0.2)
2024-09-09T12:13:03.669 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.669 I t0 command_executor.cc:312 Executing
SQL: SELECT acosh(1.2)
2024-09-09T12:13:03.669 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.669 I t0 command_executor.cc:312 Executing
SQL: SELECT anonymize('Hello, 192.168.1.2')
2024-09-09T12:13:03.669 D t0 text_anonymizer.cc:514 tok_re 19 5:6
2024-09-09T12:13:03.669 D t0 text_anonymizer.cc:514 tok_re 46 6:7
2024-09-09T12:13:03.669 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.669 I t0 command_executor.cc:312 Executing
SQL: SELECT asin(0.2)
2024-09-09T12:13:03.669 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.669 I t0 command_executor.cc:312 Executing
SQL: SELECT asinh(0.2)
2024-09-09T12:13:03.669 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.669 I t0 command_executor.cc:312 Executing
SQL: SELECT atan(0.2)
2024-09-09T12:13:03.669 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.669 I t0 command_executor.cc:312 Executing
SQL: SELECT degrees(atan2(5, 5))
2024-09-09T12:13:03.669 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.669 I t0 command_executor.cc:312 Executing
SQL: SELECT atanh(0.2)
2024-09-09T12:13:03.669 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.669 I t0 command_executor.cc:312 Executing
SQL: SELECT degrees(atn2(5, 5))
2024-09-09T12:13:03.669 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.669 I t0 command_executor.cc:312 Executing
SQL: SELECT avg(ex_duration) FROM lnav_example_log
2024-09-09T12:13:03.669 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.669 I t0 command_executor.cc:312 Executing
SQL: SELECT ex_procname, avg(ex_duration) FROM lnav_example_log
GROUP BY ex_procname
2024-09-09T12:13:03.669 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.669 I t0 command_executor.cc:312 Executing
SQL: SELECT basename('foobar')
2024-09-09T12:13:03.669 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.669 I t0 command_executor.cc:312 Executing
SQL: SELECT basename('foo/bar')
2024-09-09T12:13:03.669 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.669 I t0 command_executor.cc:312 Executing
SQL: SELECT basename('foo/bar/')
2024-09-09T12:13:03.669 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.669 I t0 command_executor.cc:312 Executing
SQL: SELECT basename('')
2024-09-09T12:13:03.669 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.669 I t0 command_executor.cc:312 Executing
SQL: SELECT basename('foo\bar')
2024-09-09T12:13:03.669 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.669 I t0 command_executor.cc:312 Executing
SQL: SELECT basename('/')
2024-09-09T12:13:03.669 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.669 I t0 command_executor.cc:267 compiling
PRQL: from [{p='foo/bar'}] | select { fs.basename p }
2024-09-09T12:13:03.669 I t0 command_executor.cc:312 Executing
SQL: SELECT ceil(1.23)
2024-09-09T12:13:03.669 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.669 I t0 command_executor.cc:312 Executing
SQL: SELECT char(0x48, 0x49)
2024-09-09T12:13:03.669 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.669 I t0 command_executor.cc:312 Executing
SQL: SELECT charindex('abc', 'abcabc', 2)
2024-09-09T12:13:03.670 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.670 I t0 command_executor.cc:312 Executing
SQL: SELECT charindex('abc', 'abcdef', 2)
2024-09-09T12:13:03.670 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.670 I t0 command_executor.cc:312 Executing
SQL: SELECT coalesce(null, 0, null)
2024-09-09T12:13:03.670 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.670 I t0 command_executor.cc:312 Executing
SQL: SELECT count(*) FROM lnav_example_log
2024-09-09T12:13:03.670 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.670 I t0 command_executor.cc:312 Executing
SQL: SELECT count(log_part) FROM lnav_example_log
2024-09-09T12:13:03.670 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.670 I t0 command_executor.cc:312 Executing
SQL: SELECT date('2017-01-02T03:04:05')
2024-09-09T12:13:03.670 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.670 I t0 command_executor.cc:312 Executing
SQL: SELECT date('2017-01-02T03:04:05', '+1 day')
2024-09-09T12:13:03.670 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.670 I t0 command_executor.cc:312 Executing
SQL: SELECT date(1491341842, 'unixepoch')
2024-09-09T12:13:03.670 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.670 I t0 command_executor.cc:312 Executing
SQL: SELECT datetime('2017-01-02T03:04:05')
2024-09-09T12:13:03.670 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.670 I t0 command_executor.cc:312 Executing
SQL: SELECT datetime('2017-01-02T03:04:05', '+1 minute')
2024-09-09T12:13:03.670 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.670 I t0 command_executor.cc:312 Executing
SQL: SELECT datetime(1491341842, 'unixepoch')
2024-09-09T12:13:03.670 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.670 I t0 command_executor.cc:312 Executing
SQL: SELECT decode('%63%75%72%6c', 'uri')
2024-09-09T12:13:03.670 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.670 I t0 command_executor.cc:312 Executing
SQL: SELECT degrees(pi())
2024-09-09T12:13:03.670 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.670 I t0 command_executor.cc:312 Executing
SQL: SELECT dirname('foo/bar')
2024-09-09T12:13:03.670 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.670 I t0 command_executor.cc:312 Executing
SQL: SELECT dirname('/foo/bar')
2024-09-09T12:13:03.670 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.670 I t0 command_executor.cc:312 Executing
SQL: SELECT dirname('/bar')
2024-09-09T12:13:03.670 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.670 I t0 command_executor.cc:312 Executing
SQL: SELECT dirname('foo\bar')
2024-09-09T12:13:03.670 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.670 I t0 command_executor.cc:312 Executing
SQL: SELECT dirname('')
2024-09-09T12:13:03.670 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.670 I t0 command_executor.cc:312 Executing
SQL: SELECT encode('Hello, World!', 'base64')
2024-09-09T12:13:03.670 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.670 I t0 command_executor.cc:312 Executing
SQL: SELECT encode('Hello, World!', 'hex')
2024-09-09T12:13:03.670 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.670 I t0 command_executor.cc:312 Executing
SQL: SELECT encode('Hello, World!', 'uri')
2024-09-09T12:13:03.670 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.670 I t0 command_executor.cc:312 Executing
SQL: SELECT endswith('notbad.jpg', '.jpg')
2024-09-09T12:13:03.670 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.670 I t0 command_executor.cc:312 Executing
SQL: SELECT endswith('notbad.png', '.jpg')
2024-09-09T12:13:03.670 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.670 I t0 command_executor.cc:312 Executing
SQL: SELECT exp(2)
2024-09-09T12:13:03.670 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.670 I t0 command_executor.cc:312 Executing
SQL: SELECT extract('foo=1 bar=2 name="Rolo Tomassi"')
2024-09-09T12:13:03.670 E t0 sql_util.cc:552 (1) statement aborts
at 3: [SELECT extract('foo=1 bar=2 name="Rolo Tomassi"')] misuse
of sqlite3_result_subtype() by extract()
2024-09-09T12:13:03.670 E t0 command_executor.cc:443 sqlite3_step
error code: 1
2024-09-09T12:13:03.670 I t0 command_executor.cc:312 Executing
SQL: SELECT extract('1.0 abc 2.0')
2024-09-09T12:13:03.670 E t0 sql_util.cc:552 (1) statement aborts
at 3: [SELECT extract('1.0 abc 2.0')] misuse of
sqlite3_result_subtype() by extract()
2024-09-09T12:13:03.670 E t0 command_executor.cc:443 sqlite3_step
error code: 1
2024-09-09T12:13:03.670 I t0 command_executor.cc:312 Executing
SQL: SELECT floor(1.23)
2024-09-09T12:13:03.670 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.670 I t0 command_executor.cc:312 Executing
SQL: SELECT ifnull(data, raise_error('cannot read: ' || st_name,
error)) FROM fstat('/non-existent')
2024-09-09T12:13:03.670 E t0 sql_util.cc:552 (1) statement aborts
at 13: [SELECT ifnull(data, raise_error('cannot read: ' ||
st_name, error)) FROM fstat('/non-existent')]
lnav-error:{"level":"error","message":{"str":"cannot read:
non-existent","attrs":[]},"r
2024-09-09T12:13:03.670 E t0 command_executor.cc:443 sqlite3_step
error code: 1
2024-09-09T12:13:03.670 I t0 command_executor.cc:312 Executing
SQL: SELECT value FROM generate_series(10, 14)
2024-09-09T12:13:03.670 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.670 I t0 command_executor.cc:312 Executing
SQL: SELECT value FROM generate_series(10, 14, 2)
2024-09-09T12:13:03.670 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.670 I t0 command_executor.cc:312 Executing
SQL: SELECT value FROM generate_series(1, 5, -1)
2024-09-09T12:13:03.670 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.670 I t0 command_executor.cc:312 Executing
SQL: SELECT gethostbyaddr('127.0.0.1')
2024-09-09T12:13:03.670 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.670 I t0 command_executor.cc:312 Executing
SQL: SELECT gethostbyname('localhost')
2024-09-09T12:13:03.671 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.671 I t0 command_executor.cc:312 Executing
SQL: SELECT glob('a*', 'abc')
2024-09-09T12:13:03.671 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.671 I t0 command_executor.cc:312 Executing
SQL: SELECT group_concat(ex_procname) FROM lnav_example_log
2024-09-09T12:13:03.671 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.671 I t0 command_executor.cc:312 Executing
SQL: SELECT group_concat(ex_procname, ', ') FROM lnav_example_log
2024-09-09T12:13:03.671 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.671 I t0 command_executor.cc:312 Executing
SQL: SELECT group_concat(DISTINCT ex_procname) FROM
lnav_example_log
2024-09-09T12:13:03.671 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.671 I t0 command_executor.cc:312 Executing
SQL: SELECT group_spooky_hash(column1) FROM (VALUES ('abc'),
('123'))
2024-09-09T12:13:03.671 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.671 I t0 command_executor.cc:312 Executing
SQL: SELECT hex('abc')
2024-09-09T12:13:03.671 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.671 I t0 command_executor.cc:312 Executing
SQL: SELECT humanize_duration(15 * 60)
2024-09-09T12:13:03.671 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.671 I t0 command_executor.cc:312 Executing
SQL: SELECT humanize_duration(1.5)
2024-09-09T12:13:03.671 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.671 I t0 command_executor.cc:312 Executing
SQL: SELECT humanize_file_size(10 * 1024 * 1024)
2024-09-09T12:13:03.671 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.671 I t0 command_executor.cc:312 Executing
SQL: SELECT humanize_id('cluster1')
2024-09-09T12:13:03.671 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.671 I t0 command_executor.cc:312 Executing
SQL: SELECT ifnull(null, 0)
2024-09-09T12:13:03.671 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.671 I t0 command_executor.cc:312 Executing
SQL: SELECT instr('abc', 'b')
2024-09-09T12:13:03.671 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.671 I t0 command_executor.cc:312 Executing
SQL: SELECT jget('1', '')
2024-09-09T12:13:03.671 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.671 I t0 command_executor.cc:312 Executing
SQL: SELECT jget('{ "a": 1, "b": 2 }', '/b')
2024-09-09T12:13:03.671 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.671 I t0 command_executor.cc:312 Executing
SQL: SELECT jget(null, '/msg', 'Hello')
2024-09-09T12:13:03.671 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.671 I t0 command_executor.cc:312 Executing
SQL: SELECT joinpath('foo', 'bar')
2024-09-09T12:13:03.671 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.671 I t0 command_executor.cc:312 Executing
SQL: SELECT joinpath('', 'foo', 'bar')
2024-09-09T12:13:03.671 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.671 I t0 command_executor.cc:312 Executing
SQL: SELECT joinpath('/', 'foo', 'bar')
2024-09-09T12:13:03.671 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.671 I t0 command_executor.cc:312 Executing
SQL: SELECT joinpath('/', 'foo', '/bar')
2024-09-09T12:13:03.671 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.671 I t0 command_executor.cc:312 Executing
SQL: SELECT json_array(NULL, 1, 2.1, 'three', json_array(4),
json_object('five', 'six'))
2024-09-09T12:13:03.671 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.671 I t0 command_executor.cc:312 Executing
SQL: SELECT json_array()
2024-09-09T12:13:03.671 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.671 I t0 command_executor.cc:312 Executing
SQL: SELECT json_array_length('[1, 2, 3]')
2024-09-09T12:13:03.671 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.671 I t0 command_executor.cc:312 Executing
SQL: SELECT json_array_length('{"arr": [1, 2, 3]}', '$.arr')
2024-09-09T12:13:03.671 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.671 I t0 command_executor.cc:312 Executing
SQL: SELECT json_concat(NULL, 4)
2024-09-09T12:13:03.671 E t0 sql_util.cc:552 (1) statement aborts
at 4: [SELECT json_concat(NULL, 4)] misuse of
sqlite3_result_subtype() by json_concat()
2024-09-09T12:13:03.671 E t0 command_executor.cc:443 sqlite3_step
error code: 1
2024-09-09T12:13:03.671 I t0 command_executor.cc:312 Executing
SQL: SELECT json_concat('[1, 2, 3]', 4, 5)
2024-09-09T12:13:03.671 E t0 sql_util.cc:552 (1) statement aborts
at 5: [SELECT json_concat('[1, 2, 3]', 4, 5)] misuse of
sqlite3_result_subtype() by json_concat()
2024-09-09T12:13:03.671 E t0 command_executor.cc:443 sqlite3_step
error code: 1
2024-09-09T12:13:03.671 I t0 command_executor.cc:312 Executing
SQL: SELECT json_concat('[1, 2, 3]', json('[4, 5]'))
2024-09-09T12:13:03.671 E t0 sql_util.cc:552 (1) statement aborts
at 5: [SELECT json_concat('[1, 2, 3]', json('[4, 5]'))] misuse of
sqlite3_result_subtype() by json_concat()
2024-09-09T12:13:03.671 E t0 command_executor.cc:443 sqlite3_step
error code: 1
2024-09-09T12:13:03.671 I t0 command_executor.cc:312 Executing
SQL: SELECT json_contains('[1, 2, 3]', 4)
2024-09-09T12:13:03.671 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.671 I t0 command_executor.cc:312 Executing
SQL: SELECT json_contains('["abc", "def"]', 'def')
2024-09-09T12:13:03.671 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.671 I t0 command_executor.cc:312 Executing
SQL: SELECT * FROM json_each('[null,1,"two",{"three":4.5}]')
2024-09-09T12:13:03.671 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.671 I t0 command_executor.cc:312 Executing
SQL: SELECT json_extract('{"num": 1}', '$.num')
2024-09-09T12:13:03.671 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.671 I t0 command_executor.cc:312 Executing
SQL: SELECT json_extract('{"num": 1, "val": 2}', '$.num', '$.val')
2024-09-09T12:13:03.671 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.671 I t0 command_executor.cc:312 Executing
SQL: SELECT json_extract('{"obj": {"sub": 1}}', '$.obj')
2024-09-09T12:13:03.671 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.671 I t0 command_executor.cc:312 Executing
SQL: SELECT json_group_array('one', 2, 3.4)
2024-09-09T12:13:03.672 E t0 sql_util.cc:552 (1) statement aborts
at 6: [SELECT json_group_array('one', 2, 3.4)] misuse of
sqlite3_result_subtype() by json_group_array()
2024-09-09T12:13:03.672 E t0 command_executor.cc:443 sqlite3_step
error code: 1
2024-09-09T12:13:03.672 I t0 command_executor.cc:312 Executing
SQL: SELECT json_group_array(column1) FROM (VALUES (1), (2), (3))
2024-09-09T12:13:03.672 E t0 sql_util.cc:552 (1) statement aborts
at 15: [SELECT json_group_array(column1) FROM (VALUES (1), (2),
(3))] misuse of sqlite3_result_subtype() by json_group_array()
2024-09-09T12:13:03.672 E t0 command_executor.cc:443 sqlite3_step
error code: 1
2024-09-09T12:13:03.672 I t0 command_executor.cc:312 Executing
SQL: SELECT json_group_object('a', 1, 'b', 2)
2024-09-09T12:13:03.672 E t0 sql_util.cc:552 (1) statement aborts
at 7: [SELECT json_group_object('a', 1, 'b', 2)] misuse of
sqlite3_result_subtype() by json_group_object()
2024-09-09T12:13:03.672 E t0 command_executor.cc:443 sqlite3_step
error code: 1
2024-09-09T12:13:03.672 I t0 command_executor.cc:312 Executing
SQL: SELECT json_group_object(column1, column2) FROM (VALUES ('a',
1), ('b', 2))
2024-09-09T12:13:03.672 E t0 sql_util.cc:552 (1) statement aborts
at 16: [SELECT json_group_object(column1, column2) FROM (VALUES
('a', 1), ('b', 2))] misuse of sqlite3_result_subtype() by
json_group_object()
2024-09-09T12:13:03.672 E t0 command_executor.cc:443 sqlite3_step
error code: 1
2024-09-09T12:13:03.672 I t0 command_executor.cc:312 Executing
SQL: SELECT json_insert('[1, 2]', '$[#]', 3)
2024-09-09T12:13:03.672 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.672 I t0 command_executor.cc:312 Executing
SQL: SELECT json_insert('{"a": 1}', '$.b', 2)
2024-09-09T12:13:03.672 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.672 I t0 command_executor.cc:312 Executing
SQL: SELECT json_insert('{"a": 1}', '$.a', 2)
2024-09-09T12:13:03.672 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.672 I t0 command_executor.cc:312 Executing
SQL: SELECT json_insert('{"a": 1}', '$.b', 2, '$.c', 3)
2024-09-09T12:13:03.672 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.672 I t0 command_executor.cc:312 Executing
SQL: SELECT json_object('a', 1, 'b', 'c')
2024-09-09T12:13:03.672 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.672 I t0 command_executor.cc:312 Executing
SQL: SELECT json_object()
2024-09-09T12:13:03.672 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.672 I t0 command_executor.cc:312 Executing
SQL: SELECT json_quote('Hello, World!')
2024-09-09T12:13:03.672 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.672 I t0 command_executor.cc:312 Executing
SQL: SELECT json_quote(json('"Hello, World!"'))
2024-09-09T12:13:03.672 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.672 I t0 command_executor.cc:312 Executing
SQL: SELECT json_remove('[1,2,3]', '$[1]', '$[1]')
2024-09-09T12:13:03.672 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.672 I t0 command_executor.cc:312 Executing
SQL: SELECT json_remove('{"a":1,"b":2}', '$.b')
2024-09-09T12:13:03.672 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.672 I t0 command_executor.cc:312 Executing
SQL: SELECT json_replace('{"a": 1}', '$.a', 2)
2024-09-09T12:13:03.672 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.672 I t0 command_executor.cc:312 Executing
SQL: SELECT json_replace('{"a": 1}', '$.a', 2, '$.b', 3)
2024-09-09T12:13:03.672 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.672 I t0 command_executor.cc:312 Executing
SQL: SELECT json_set('[1, 2]', '$[1]', 3)
2024-09-09T12:13:03.672 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.672 I t0 command_executor.cc:312 Executing
SQL: SELECT json_set('{"a": 1}', '$.a', 2, '$.b', 3)
2024-09-09T12:13:03.672 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.672 I t0 command_executor.cc:312 Executing
SQL: SELECT key,value,type,atom,fullkey,path FROM
json_tree('[null,1,"two",{"three":4.5}]')
2024-09-09T12:13:03.672 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.672 I t0 command_executor.cc:312 Executing
SQL: SELECT json_type('[null,1,2.1,"three",{"four":5}]')
2024-09-09T12:13:03.672 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.672 I t0 command_executor.cc:312 Executing
SQL: SELECT json_type('[null,1,2.1,"three",{"four":5}]', '$[0]')
2024-09-09T12:13:03.672 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.672 I t0 command_executor.cc:312 Executing
SQL: SELECT json_type('[null,1,2.1,"three",{"four":5}]', '$[3]')
2024-09-09T12:13:03.672 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.672 I t0 command_executor.cc:312 Executing
SQL: SELECT json_valid('')
2024-09-09T12:13:03.672 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.672 I t0 command_executor.cc:312 Executing
SQL: SELECT json_valid('"a"')
2024-09-09T12:13:03.672 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.672 I t0 command_executor.cc:312 Executing
SQL: SELECT julianday('2017-01-02T03:04:05')
2024-09-09T12:13:03.672 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.672 I t0 command_executor.cc:312 Executing
SQL: SELECT julianday('2017-01-02T03:04:05', '+1 minute')
2024-09-09T12:13:03.672 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.672 I t0 command_executor.cc:312 Executing
SQL: SELECT julianday(1491341842, 'unixepoch')
2024-09-09T12:13:03.672 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.672 I t0 command_executor.cc:312 Executing
SQL: SELECT leftstr('abc', 1)
2024-09-09T12:13:03.672 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.672 I t0 command_executor.cc:312 Executing
SQL: SELECT leftstr('abc', 10)
2024-09-09T12:13:03.672 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.672 I t0 command_executor.cc:312 Executing
SQL: SELECT length('abc')
2024-09-09T12:13:03.672 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.672 I t0 command_executor.cc:312 Executing
SQL: SELECT like('%b%', 'aabcc')
2024-09-09T12:13:03.672 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.672 I t0 command_executor.cc:312 Executing
SQL: SELECT like('%b:%', 'aab%', ':')
2024-09-09T12:13:03.672 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.672 I t0 command_executor.cc:312 Executing
SQL: SELECT log(8)
2024-09-09T12:13:03.672 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.672 I t0 command_executor.cc:312 Executing
SQL: SELECT log10(100)
2024-09-09T12:13:03.672 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.672 I t0 command_executor.cc:312 Executing
SQL: SELECT logfmt2json('foo=1 bar=2 name="Rolo Tomassi"')
2024-09-09T12:13:03.672 E t0 sql_util.cc:552 (1) statement aborts
at 3: [SELECT logfmt2json('foo=1 bar=2 name="Rolo Tomassi"')]
misuse of sqlite3_result_subtype() by logfmt2json()
2024-09-09T12:13:03.672 E t0 command_executor.cc:443 sqlite3_step
error code: 1
2024-09-09T12:13:03.672 I t0 command_executor.cc:312 Executing
SQL: SELECT lower('AbC')
2024-09-09T12:13:03.672 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.673 I t0 command_executor.cc:312 Executing
SQL: SELECT ltrim(' abc')
2024-09-09T12:13:03.673 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.673 I t0 command_executor.cc:312 Executing
SQL: SELECT ltrim('aaaabbbc', 'ab')
2024-09-09T12:13:03.673 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.673 I t0 command_executor.cc:312 Executing
SQL: SELECT max(2, 1, 3)
2024-09-09T12:13:03.673 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.673 I t0 command_executor.cc:312 Executing
SQL: SELECT max(status) FROM http_status_codes
2024-09-09T12:13:03.673 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.673 I t0 command_executor.cc:312 Executing
SQL: SELECT min(2, 1, 3)
2024-09-09T12:13:03.673 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.673 I t0 command_executor.cc:312 Executing
SQL: SELECT min(status) FROM http_status_codes
2024-09-09T12:13:03.673 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.673 I t0 command_executor.cc:312 Executing
SQL: SELECT nullif(1, 1)
2024-09-09T12:13:03.673 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.673 I t0 command_executor.cc:312 Executing
SQL: SELECT nullif(1, 2)
2024-09-09T12:13:03.673 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.673 I t0 command_executor.cc:312 Executing
SQL: SELECT padc('abc', 6) || 'def'
2024-09-09T12:13:03.673 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.673 I t0 command_executor.cc:312 Executing
SQL: SELECT padc('abcdef', 8) || 'ghi'
2024-09-09T12:13:03.673 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.673 I t0 command_executor.cc:312 Executing
SQL: SELECT padl('abc', 6)
2024-09-09T12:13:03.673 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.673 I t0 command_executor.cc:312 Executing
SQL: SELECT padl('abcdef', 4)
2024-09-09T12:13:03.673 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.673 I t0 command_executor.cc:312 Executing
SQL: SELECT padr('abc', 6) || 'def'
2024-09-09T12:13:03.673 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.673 I t0 command_executor.cc:312 Executing
SQL: SELECT padr('abcdef', 4) || 'ghi'
2024-09-09T12:13:03.673 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.673 I t0 command_executor.cc:312 Executing
SQL: SELECT
parse_url('https://example.com/search?q=hello%20world')
2024-09-09T12:13:03.673 E t0 sql_util.cc:552 (1) statement aborts
at 3: [SELECT
parse_url('https://example.com/search?q=hello%20world')] misuse of
sqlite3_result_subtype() by parse_url()
2024-09-09T12:13:03.673 E t0 command_executor.cc:443 sqlite3_step
error code: 1
2024-09-09T12:13:03.673 I t0 command_executor.cc:312 Executing
SQL: SELECT parse_url('https://alice@[fe80::14ff:4ee5:1215:2fb2]')
2024-09-09T12:13:03.673 E t0 sql_util.cc:552 (1) statement aborts
at 3: [SELECT
parse_url('https://alice@[fe80::14ff:4ee5:1215:2fb2]')] misuse of
sqlite3_result_subtype() by parse_url()
2024-09-09T12:13:03.673 E t0 command_executor.cc:443 sqlite3_step
error code: 1
2024-09-09T12:13:03.673 I t0 command_executor.cc:312 Executing
SQL: SELECT pi()
2024-09-09T12:13:03.673 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.673 I t0 command_executor.cc:312 Executing
SQL: SELECT power(2, 3)
2024-09-09T12:13:03.673 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.673 I t0 command_executor.cc:312 Executing
SQL: SELECT printf('Hello, %s!', 'World')
2024-09-09T12:13:03.673 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.673 I t0 command_executor.cc:312 Executing
SQL: SELECT printf('align: % 10s', 'small')
2024-09-09T12:13:03.673 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.673 I t0 command_executor.cc:312 Executing
SQL: SELECT printf('value: %05d', 11)
2024-09-09T12:13:03.673 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.673 I t0 command_executor.cc:312 Executing
SQL: SELECT proper('hello, world!')
2024-09-09T12:13:03.673 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.673 I t0 command_executor.cc:312 Executing
SQL: SELECT quote('abc')
2024-09-09T12:13:03.673 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.673 I t0 command_executor.cc:312 Executing
SQL: SELECT quote('abc''123')
2024-09-09T12:13:03.673 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.673 I t0 command_executor.cc:312 Executing
SQL: SELECT radians(180)
2024-09-09T12:13:03.673 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.673 I t0 command_executor.cc:312 Executing
SQL: SELECT ifnull($val, raise_error('please set $val',
'because'))
2024-09-09T12:13:03.673 E t0 sql_util.cc:552 (1) statement aborts
at 3: [SELECT ifnull($val, raise_error('please set $val',
'because'))] lnav-error:{"level":"error","message":{"str":"please
set
$val","attrs":[]},"reason":{"str":"because","attrs":[]},"snippet
2024-09-09T12:13:03.673 E t0 command_executor.cc:443 sqlite3_step
error code: 1
2024-09-09T12:13:03.673 I t0 command_executor.cc:312 Executing
SQL: SELECT * FROM regexp_capture('a=1; b=2', '(\w+)=(\d+)')
2024-09-09T12:13:03.673 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.673 I t0 command_executor.cc:312 Executing
SQL: SELECT * FROM regexp_capture_into_json('a=1; b=2',
'(\w+)=(\d+)')
2024-09-09T12:13:03.673 D t0 column_namer.cc:109 column name
already exists (col), trying (col_0)
2024-09-09T12:13:03.673 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.673 I t0 command_executor.cc:312 Executing
SQL: SELECT regexp_match('(\d+)', '123')
2024-09-09T12:13:03.673 D t0 column_namer.cc:109 column name
already exists (col), trying (col_0)
2024-09-09T12:13:03.673 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.673 I t0 command_executor.cc:312 Executing
SQL: SELECT regexp_match('(\d+) (\w+)', '123 four')
2024-09-09T12:13:03.673 D t0 column_namer.cc:109 column name
already exists (col), trying (col_0)
2024-09-09T12:13:03.673 E t0 sql_util.cc:552 (1) statement aborts
at 4: [SELECT regexp_match('(\d+) (\w+)', '123 four')] misuse of
sqlite3_result_subtype() by regexp_match()
2024-09-09T12:13:03.673 E t0 command_executor.cc:443 sqlite3_step
error code: 1
2024-09-09T12:13:03.673 I t0 command_executor.cc:312 Executing
SQL: SELECT regexp_match('(?<num>\d+) (?<str>\w+)',
'123 four')
2024-09-09T12:13:03.673 E t0 sql_util.cc:552 (1) statement aborts
at 4: [SELECT regexp_match('(?<num>\d+) (?<str>\w+)',
'123 four')] misuse of sqlite3_result_subtype() by regexp_match()
2024-09-09T12:13:03.673 E t0 command_executor.cc:443 sqlite3_step
error code: 1
2024-09-09T12:13:03.673 I t0 command_executor.cc:312 Executing
SQL: SELECT regexp_replace('Hello, World!', '^(\w+)', 'Goodbye')
2024-09-09T12:13:03.674 D t0 column_namer.cc:109 column name
already exists (col), trying (col_0)
2024-09-09T12:13:03.674 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.674 I t0 command_executor.cc:312 Executing
SQL: SELECT regexp_replace('123 abc', '(\w+)', '<\1>')
2024-09-09T12:13:03.674 D t0 column_namer.cc:109 column name
already exists (col), trying (col_0)
2024-09-09T12:13:03.674 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.674 I t0 command_executor.cc:312 Executing
SQL: SELECT replace('abc', 'x', 'z')
2024-09-09T12:13:03.674 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.674 I t0 command_executor.cc:312 Executing
SQL: SELECT replace('abc', 'a', 'z')
2024-09-09T12:13:03.674 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.674 I t0 command_executor.cc:312 Executing
SQL: SELECT replicate('abc', 3)
2024-09-09T12:13:03.674 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.674 I t0 command_executor.cc:312 Executing
SQL: SELECT reverse('abc')
2024-09-09T12:13:03.674 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.674 I t0 command_executor.cc:312 Executing
SQL: SELECT rightstr('abc', 1)
2024-09-09T12:13:03.674 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.674 I t0 command_executor.cc:312 Executing
SQL: SELECT rightstr('abc', 10)
2024-09-09T12:13:03.674 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.674 I t0 command_executor.cc:312 Executing
SQL: SELECT round(123.456)
2024-09-09T12:13:03.674 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.674 I t0 command_executor.cc:312 Executing
SQL: SELECT round(123.456, 1)
2024-09-09T12:13:03.674 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.674 I t0 command_executor.cc:312 Executing
SQL: SELECT round(123.456, 5)
2024-09-09T12:13:03.674 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.674 I t0 command_executor.cc:312 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
2024-09-09T12:13:03.674 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.674 I t0 command_executor.cc:312 Executing
SQL: SELECT rtrim('abc ')
2024-09-09T12:13:03.674 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.674 I t0 command_executor.cc:312 Executing
SQL: SELECT rtrim('abbbbcccc', 'bc')
2024-09-09T12:13:03.674 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.674 I t0 command_executor.cc:312 Executing
SQL: SELECT sign(10)
2024-09-09T12:13:03.674 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.674 I t0 command_executor.cc:312 Executing
SQL: SELECT sign(0)
2024-09-09T12:13:03.674 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.674 I t0 command_executor.cc:312 Executing
SQL: SELECT sign(-10)
2024-09-09T12:13:03.674 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.674 I t0 command_executor.cc:312 Executing
SQL: SELECT sparkline(32, 128)
2024-09-09T12:13:03.674 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.674 I t0 command_executor.cc:312 Executing
SQL: SELECT sparkline(value) FROM json_each('[0, 1, 2, 3, 4, 5, 6,
7, 8]')
2024-09-09T12:13:03.674 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.674 I t0 command_executor.cc:312 Executing
SQL: SELECT spooky_hash('Hello, World!')
2024-09-09T12:13:03.674 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.674 I t0 command_executor.cc:312 Executing
SQL: SELECT spooky_hash('Hello, World!', NULL)
2024-09-09T12:13:03.674 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.674 I t0 command_executor.cc:312 Executing
SQL: SELECT spooky_hash('Hello, World!', '')
2024-09-09T12:13:03.674 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.674 I t0 command_executor.cc:312 Executing
SQL: SELECT spooky_hash('Hello, World!', 123)
2024-09-09T12:13:03.674 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.674 I t0 command_executor.cc:312 Executing
SQL: SELECT sqlite_compileoption_used('ENABLE_FTS3')
2024-09-09T12:13:03.674 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.674 I t0 command_executor.cc:312 Executing
SQL: SELECT square(2)
2024-09-09T12:13:03.674 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.674 I t0 command_executor.cc:312 Executing
SQL: SELECT startswith('foobar', 'foo')
2024-09-09T12:13:03.674 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.674 I t0 command_executor.cc:312 Executing
SQL: SELECT startswith('foobar', 'bar')
2024-09-09T12:13:03.674 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.674 I t0 command_executor.cc:312 Executing
SQL: SELECT strfilter('abcabc', 'bcd')
2024-09-09T12:13:03.674 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.674 I t0 command_executor.cc:312 Executing
SQL: SELECT strftime('%Y', '2017-01-02T03:04:05')
2024-09-09T12:13:03.674 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.674 I t0 command_executor.cc:312 Executing
SQL: SELECT strftime('The time is: %H:%M:%S',
'2017-01-02T03:04:05', '+1 minute')
2024-09-09T12:13:03.674 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.674 I t0 command_executor.cc:312 Executing
SQL: SELECT strftime('Julian day: %J', 1491341842, 'unixepoch')
2024-09-09T12:13:03.674 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.674 I t0 command_executor.cc:312 Executing
SQL: SELECT substr('abc', 2)
2024-09-09T12:13:03.674 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.674 I t0 command_executor.cc:312 Executing
SQL: SELECT substr('abc', 2, 1)
2024-09-09T12:13:03.674 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.674 I t0 command_executor.cc:312 Executing
SQL: SELECT substr('abc', -1)
2024-09-09T12:13:03.674 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.674 I t0 command_executor.cc:312 Executing
SQL: SELECT substr('abc', -1, -1)
2024-09-09T12:13:03.674 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.674 I t0 command_executor.cc:312 Executing
SQL: SELECT sum(ex_duration) FROM lnav_example_log
2024-09-09T12:13:03.674 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.674 I t0 command_executor.cc:312 Executing
SQL: SELECT time('2017-01-02T03:04:05')
2024-09-09T12:13:03.674 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.674 I t0 command_executor.cc:312 Executing
SQL: SELECT time('2017-01-02T03:04:05', '+1 minute')
2024-09-09T12:13:03.674 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.674 I t0 command_executor.cc:312 Executing
SQL: SELECT time(1491341842, 'unixepoch')
2024-09-09T12:13:03.674 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.674 I t0 command_executor.cc:312 Executing
SQL: SELECT timediff('2017-02-03T04:05:06', '2017-02-03T04:05:00')
2024-09-09T12:13:03.674 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.674 I t0 command_executor.cc:312 Executing
SQL: SELECT timediff('today', 'yesterday')
2024-09-09T12:13:03.675 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.675 I t0 command_executor.cc:312 Executing
SQL: SELECT timeslice('2017-01-01T05:05:00', '10m')
2024-09-09T12:13:03.675 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.675 I t0 command_executor.cc:312 Executing
SQL: SELECT timeslice(log_time_msecs, '5m') AS slice, count(1)
FROM lnav_example_log GROUP BY slice
2024-09-09T12:13:03.675 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.675 I t0 command_executor.cc:312 Executing
SQL: SELECT timeslice(log_time_msecs, 'before 4:30am') AS slice,
count(1) FROM lnav_example_log GROUP BY slice
2024-09-09T12:13:03.675 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.675 I t0 command_executor.cc:312 Executing
SQL: SELECT timezone('America/Los_Angeles', '2022-03-02T10:00')
2024-09-09T12:13:03.675 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.675 I t0 command_executor.cc:312 Executing
SQL: SELECT total(ex_duration) FROM lnav_example_log
2024-09-09T12:13:03.675 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.675 I t0 command_executor.cc:312 Executing
SQL: SELECT trim(' abc ')
2024-09-09T12:13:03.675 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.675 I t0 command_executor.cc:312 Executing
SQL: SELECT trim('-+abc+-', '-+')
2024-09-09T12:13:03.675 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.675 I t0 command_executor.cc:312 Executing
SQL: SELECT typeof(1)
2024-09-09T12:13:03.675 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.675 I t0 command_executor.cc:312 Executing
SQL: SELECT typeof('abc')
2024-09-09T12:13:03.675 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.675 I t0 command_executor.cc:312 Executing
SQL: SELECT unicode('abc')
2024-09-09T12:13:03.675 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.675 I t0 command_executor.cc:312 Executing
SQL: SELECT unparse_url('{"scheme": "https", "host":
"example.com"}')
2024-09-09T12:13:03.676 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.676 I t0 command_executor.cc:312 Executing
SQL: SELECT upper('aBc')
2024-09-09T12:13:03.676 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.676 I t0 command_executor.cc:312 Executing
SQL: SELECT * FROM xpath('/abc/def', '<abc><def
a="b">Hello</def><def>Bye</def></abc>')
2024-09-09T12:13:03.676 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.676 I t0 command_executor.cc:312 Executing
SQL: SELECT * FROM xpath('/abc/def/@a', '<abc><def
a="b">Hello</def><def>Bye</def></abc>')
2024-09-09T12:13:03.676 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.676 I t0 command_executor.cc:312 Executing
SQL: SELECT * FROM xpath('/abc/def/text()', '<abc><def
a="b">Hello ★</def></abc>')
2024-09-09T12:13:03.676 I t0 command_executor.cc:406
sqlite3_changes() -> 0
2024-09-09T12:13:03.676 I t0 command_executor.cc:312 Executing
SQL: SELECT yaml_to_json('abc: def')
2024-09-09T12:13:03.676 E t0 sql_util.cc:552 (1) statement aborts
at 3: [SELECT yaml_to_json('abc: def')] misuse of
sqlite3_result_subtype() by yaml_to_json()
2024-09-09T12:13:03.676 E t0 command_executor.cc:443 sqlite3_step
error code: 1
2024-09-09T12:13:03.676 I t0 command_executor.cc:267 compiling
PRQL: from [{s='Hello'}] | select { s=text.contains 'lo' s }
2024-09-09T12:13:03.676 I t0 command_executor.cc:267 compiling
PRQL: from [{s='Goodbye'}] | select { s=text.contains 'lo' s }
2024-09-09T12:13:03.676 I t0 command_executor.cc:267 compiling
PRQL: from [{s='Hello'}] | select { s=text.ends_with 'lo' s }
2024-09-09T12:13:03.676 I t0 command_executor.cc:267 compiling
PRQL: from [{s='Goodbye'}] | select { s=text.ends_with 'lo' s }
2024-09-09T12:13:03.676 I t0 command_executor.cc:267 compiling
PRQL: from [{s='Hello, World!'}] | select { s=text.extract 1 5 s }
2024-09-09T12:13:03.676 I t0 command_executor.cc:267 compiling
PRQL: from [{s='Hello, World!'}] | select { s=text.length s }
2024-09-09T12:13:03.676 I t0 command_executor.cc:267 compiling
PRQL: from [{s='HELLO'}] | select { s=text.lower s }
2024-09-09T12:13:03.676 I t0 command_executor.cc:267 compiling
PRQL: from [{s=' HELLO '}] | select { s=text.ltrim s }
2024-09-09T12:13:03.676 I t0 command_executor.cc:267 compiling
PRQL: from [{s='foobar'}] | select { s=text.replace 'foo' '' s }
2024-09-09T12:13:03.676 I t0 command_executor.cc:267 compiling
PRQL: from [{s=' HELLO '}] | select { s=text.rtrim s }
2024-09-09T12:13:03.676 I t0 command_executor.cc:267 compiling
PRQL: from [{s='Hello'}] | select { s=text.starts_with 'He' s }
2024-09-09T12:13:03.676 I t0 command_executor.cc:267 compiling
PRQL: from [{s='Goodbye'}] | select { s=text.starts_with 'He' s }
2024-09-09T12:13:03.676 I t0 command_executor.cc:267 compiling
PRQL: from [{s=' HELLO '}] | select { s=text.trim s }
2024-09-09T12:13:03.676 I t0 command_executor.cc:267 compiling
PRQL: from [{s='hello'}] | select { s=text.upper s }
2024-09-09T12:13:03.676 I t0 command_executor.cc:267 compiling
PRQL: from [{a=1}, {a=2}] | aggregate { arr = json.group_array a }
2024-09-09T12:13:03.676 I t0 command_executor.cc:267 compiling
PRQL: from [{a=1}, {a=2}] | derive b = a * 2
2024-09-09T12:13:03.676 I t0 command_executor.cc:267 compiling
PRQL: from [{a=1}, {a=2}] | filter a > 1
2024-09-09T12:13:03.676 I t0 command_executor.cc:267 compiling
PRQL: from http_status_codes | take 3
2024-09-09T12:13:03.676 I t0 command_executor.cc:267 compiling
PRQL: from [{ col1=1, col2='abc' }, { col1=2, col2='def' }]
2024-09-09T12:13:03.676 I t0 command_executor.cc:267 compiling
PRQL: from lnav_example_log | group { log_level } (aggregate {
count this })
2024-09-09T12:13:03.676 I t0 command_executor.cc:267 compiling
PRQL: from [{a=1, b='abc'}, {a=2, b='def'}] | select b
2024-09-09T12:13:03.676 I t0 command_executor.cc:267 compiling
PRQL: from [{a=1}, {a=2}] | select b = a * 2
2024-09-09T12:13:03.676 I t0 command_executor.cc:267 compiling
PRQL: from [{a=1}, {a=2}] | sort {-a}
2024-09-09T12:13:03.676 I t0 command_executor.cc:267 compiling
PRQL: from [{a=1}, {a=1}, {a=2}] | stats.average_of a
2024-09-09T12:13:03.676 I t0 command_executor.cc:267 compiling
PRQL: from [{a=1, b=1}, {a=1, b=1}, {a=2, b=1}] | stats.by a {sum
b}
2024-09-09T12:13:03.676 I t0 command_executor.cc:267 compiling
PRQL: from [{a=1}, {a=1}, {a=2}] | stats.count_by a
2024-09-09T12:13:03.676 I t0 command_executor.cc:267 compiling
PRQL: from lnav_example_log | stats.hist ex_procname
2024-09-09T12:13:03.676 I t0 command_executor.cc:267 compiling
PRQL: from [{a=1}, {a=1}, {a=2}] | stats.sum_of a
2024-09-09T12:13:03.676 I t0 command_executor.cc:267 compiling
PRQL: from [{a=1}, {a=2}, {a=3}] | take 1
2024-09-09T12:13:03.676 I t0 command_executor.cc:267 compiling
PRQL: from [{a=1}, {a=2}, {a=3}] | take 2..3
2024-09-09T12:13:03.676 I t0 command_executor.cc:267 compiling
PRQL: from [{a=1}, {a=1}, {a=2}] | utils.distinct a
2024-09-09T12:13:03.676 I t0 command_executor.cc:657 Executing
file: /root/.config/lnav/session
2024-09-09T12:13:03.676 D t0 log_format_loader.cc:1596 Searching
for script in path: /etc/lnav/formats/*/*.lnav
2024-09-09T12:13:03.676 D t0 log_format_loader.cc:1596 Searching
for script in path: /etc/lnav/configs/*/*.lnav
2024-09-09T12:13:03.676 D t0 log_format_loader.cc:1596 Searching
for script in path: /usr/local/etc/lnav/formats/*/*.lnav
2024-09-09T12:13:03.676 D t0 log_format_loader.cc:1596 Searching
for script in path: /usr/local/etc/lnav/configs/*/*.lnav
2024-09-09T12:13:03.676 D t0 log_format_loader.cc:1596 Searching
for script in path: /root/.config/lnav/formats/*/*.lnav
2024-09-09T12:13:03.677 D t0 log_format_loader.cc:1608 found
script: /root/.config/lnav/formats/default/dhclient-summary.lnav
2024-09-09T12:13:03.677 D t0 log_format_loader.cc:1608 found
script: /root/.config/lnav/formats/default/docker-url-handler.lnav
2024-09-09T12:13:03.677 D t0 log_format_loader.cc:1608 found
script:
/root/.config/lnav/formats/default/journald-url-handler.lnav
2024-09-09T12:13:03.677 D t0 log_format_loader.cc:1608 found
script: /root/.config/lnav/formats/default/lnav-copy-text.lnav
2024-09-09T12:13:03.677 D t0 log_format_loader.cc:1608 found
script: /root/.config/lnav/formats/default/lnav-pop-view.lnav
2024-09-09T12:13:03.677 D t0 log_format_loader.cc:1608 found
script: /root/.config/lnav/formats/default/partition-by-boot.lnav
2024-09-09T12:13:03.677 D t0 log_format_loader.cc:1608 found
script: /root/.config/lnav/formats/default/piper-url-handler.lnav
2024-09-09T12:13:03.677 D t0 log_format_loader.cc:1608 found
script: /root/.config/lnav/formats/default/rename-stdin.lnav
2024-09-09T12:13:03.677 D t0 log_format_loader.cc:1608 found
script: /root/.config/lnav/formats/default/search-for.lnav
2024-09-09T12:13:03.677 D t0 log_format_loader.cc:1596 Searching
for script in path: /root/.config/lnav/configs/*/*.lnav
2024-09-09T12:13:03.677 D t0 lnav.cc:1508 rescan started
2024-09-09T12:13:03.677 I t4 file_collection.cc:104 fd limit:
5657355; open file limit: 5657323
2024-09-09T12:13:03.678 D t5 archive_manager.cc:91 read open
/var/log/messages
2024-09-09T12:13:03.678 D t5 archive_manager.cc:98 read next
header (null) /var/log/messages
2024-09-09T12:13:03.678 D t5 archive_manager.cc:100 read next done
/var/log/messages
2024-09-09T12:13:03.678 I t5 file_collection.cc:531 loading new
file: filename=/var/log/messages
2024-09-09T12:13:03.678 I t5 logfile.cc:127 Creating logfile:
fd=11; size=34019; mtime=1725909183; filename=/var/log/messages
2024-09-09T12:13:03.678 I t5 logfile.cc:129
actual_path=/var/log/messages
2024-09-09T12:13:03.698 D t0 lnav.cc:1549 initial rescan rebuild
2024-09-09T12:13:03.698 D t0 logfile.cc:660 scanning file...
/var/log/messages
2024-09-09T12:13:03.698 D t0 logfile.cc:729 loading file...
/var/log/messages:0
2024-09-09T12:13:03.699 D t0 logfile.cc:820 setting text format to
text/plain
2024-09-09T12:13:03.699 D t0 logfile.cc:340 (papertrail_log) does
not match file name: /var/log/messages
2024-09-09T12:13:03.700 D t0 log_format.cc:1625 messages:0:
changing pattern lock -1 -> (1)std
2024-09-09T12:13:03.700 I t0 logfile.cc:372 scan with format
(syslog_log) matched with quality (0)
2024-09-09T12:13:03.700 I t0 logfile.cc:385 scan with format
(generic_log) matched, but is low quality (0)
2024-09-09T12:13:03.700 I t0 logfile.cc:416
/var/log/messages:1:log format found -- syslog_log
2024-09-09T12:13:03.700 D t0 logfile.cc:1032 /var/log/messages:
opid_map size: count=1; sizeof(otr)=112; alloc=17
2024-09-09T12:13:03.700 I t0 lnav.indexing.cc:147 promoting text
file to log file: /var/log/messages
(ac4642e4b9402196070f58eb4e20d95e)
2024-09-09T12:13:03.700 D t0 logfile_sub_source.cc:770 forced to
full rebuild
2024-09-09T12:13:03.701 D t0 logfile.cc:1032 /var/log/messages:
opid_map size: count=46; sizeof(otr)=112; alloc=796
2024-09-09T12:13:03.701 D t0 logfile_sub_source.cc:830 new lines
for /var/log/messages:415
2024-09-09T12:13:03.701 D t0 logfile_sub_source.cc:897 expanding
index capacity 100415
2024-09-09T12:13:03.701 D t0 logfile_sub_source.cc:1221 redoing
search
2024-09-09T12:13:03.701 I t0 session_data.cc:901 BEGIN
load_session
2024-09-09T12:13:03.701 I t0 session_data.cc:432 loading bookmark
db: /root/.config/lnav/log_metadata.db
2024-09-09T12:13:03.701 E t0 sql_util.cc:552 (1) no such table:
bookmarks in "ALTER TABLE bookmarks ADD COLUMN comment text
DEFAULT '';"
2024-09-09T12:13:03.701 E t0 session_data.cc:446 unable to upgrade
bookmark table -- (1/1) no such table: bookmarks
2024-09-09T12:13:03.702 E t0 sql_util.cc:552 (1) no such table:
bookmarks in "ALTER TABLE bookmarks ADD COLUMN tags text DEFAULT
'';"
2024-09-09T12:13:03.702 E t0 session_data.cc:446 unable to upgrade
bookmark table -- (1/1) no such table: bookmarks
2024-09-09T12:13:03.702 E t0 sql_util.cc:552 (1) no such table:
bookmarks in "ALTER TABLE bookmarks ADD COLUMN annotations text
DEFAULT NULL;"
2024-09-09T12:13:03.702 E t0 session_data.cc:446 unable to upgrade
bookmark table -- (1/1) no such table: bookmarks
2024-09-09T12:13:03.702 E t0 sql_util.cc:552 (1) no such table:
recent_netlocs in "SELECT netloc FROM recent_netlocs"
2024-09-09T12:13:03.702 E t0 session_data.cc:455 unable to get
netlocs: unable to prepare SQL statement: no such table:
recent_netlocs
2024-09-09T12:13:03.702 I t0 session_data.cc:984 END load_session
2024-09-09T12:13:03.702 D t0 lnav.cc:1572 file count 1
2024-09-09T12:13:03.702 E t0 lnav_log.cc:429 Received signal: 4
0x986e4a <_ZTVNSt3__117bad_function_callE+0x73d402> at
/usr/local/bin/lnav
0x82891c41f <pthread_sigmask+0x54f> at /lib/libthr.so.3
0x82891b9cb <pthread_setschedparam+0x84b> at
/lib/libthr.so.3
0x821cab2d3 <???> at ???
2024-09-09T12:13:03.703 I t0 lnav_log.cc:221 uname:
2024-09-09T12:13:03.703 I t0 lnav_log.cc:222 sysname=FreeBSD
2024-09-09T12:13:03.703 I t0 lnav_log.cc:223 nodename=matanawa
2024-09-09T12:13:03.703 I t0 lnav_log.cc:224 machine=amd64
2024-09-09T12:13:03.703 I t0 lnav_log.cc:225
release=14.1-RELEASE-p3
2024-09-09T12:13:03.703 I t0 lnav_log.cc:226 version=FreeBSD
14.1-RELEASE-p3 GENERIC
2024-09-09T12:13:03.703 I t0 lnav_log.cc:227 PCRE:
2024-09-09T12:13:03.703 I t0 lnav_log.cc:228 jit=1
2024-09-09T12:13:03.703 I t0 lnav_log.cc:229 jittarget=x86 64bit
(little endian + unaligned)
2024-09-09T12:13:03.703 I t0 lnav_log.cc:230 Environment:
2024-09-09T12:13:03.703 I t0 lnav_log.cc:231 HOME=/root
2024-09-09T12:13:03.703 I t0 lnav_log.cc:232
XDG_CONFIG_HOME=(null)
2024-09-09T12:13:03.703 I t0 lnav_log.cc:233 LANG=C.UTF-8
2024-09-09T12:13:03.703 I t0 lnav_log.cc:234
PATH=/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/sbin:/usr/local/bin:/root/bin
2024-09-09T12:13:03.703 I t0 lnav_log.cc:235
TERM=screen-256color
2024-09-09T12:13:03.703 I t0 lnav_log.cc:236 TZ=(null)
2024-09-09T12:13:03.703 I t0 lnav_log.cc:237 Process:
2024-09-09T12:13:03.703 I t0 lnav_log.cc:238 pid=6842
2024-09-09T12:13:03.703 I t0 lnav_log.cc:239 ppid=49994
2024-09-09T12:13:03.703 I t0 lnav_log.cc:240 pgrp=6842
2024-09-09T12:13:03.703 I t0 lnav_log.cc:241 uid=0
2024-09-09T12:13:03.703 I t0 lnav_log.cc:242 gid=0
2024-09-09T12:13:03.703 I t0 lnav_log.cc:243 euid=0
2024-09-09T12:13:03.703 I t0 lnav_log.cc:244 egid=0
2024-09-09T12:13:03.703 I t0 lnav_log.cc:248 cwd=/var/log
2024-09-09T12:13:03.703 I t0 lnav_log.cc:250 Executable:
2024-09-09T12:13:03.703 I t0 lnav_log.cc:251 version=lnav 0.12.2
2024-09-09T12:13:03.703 I t0 lnav_log.cc:254 rusage:
2024-09-09T12:13:03.703 I t0 lnav_log.cc:254 utime=0.138780
2024-09-09T12:13:03.703 I t0 lnav_log.cc:254 stime=0.024490
2024-09-09T12:13:03.703 I t0 lnav_log.cc:254 maxrss=43204
2024-09-09T12:13:03.703 I t0 lnav_log.cc:254 ixrss=128320
2024-09-09T12:13:03.703 I t0 lnav_log.cc:254 idrss=9280
2024-09-09T12:13:03.703 I t0 lnav_log.cc:254 isrss=3456
2024-09-09T12:13:03.703 I t0 lnav_log.cc:254 minflt=4139
2024-09-09T12:13:03.703 I t0 lnav_log.cc:254 majflt=174
2024-09-09T12:13:03.703 I t0 lnav_log.cc:254 nswap=0
2024-09-09T12:13:03.703 I t0 lnav_log.cc:254 inblock=7
2024-09-09T12:13:03.703 I t0 lnav_log.cc:254 oublock=80
2024-09-09T12:13:03.703 I t0 lnav_log.cc:254 msgsnd=68
2024-09-09T12:13:03.703 I t0 lnav_log.cc:254 msgrcv=0
2024-09-09T12:13:03.703 I t0 lnav_log.cc:254 nsignals=1
2024-09-09T12:13:03.703 I t0 lnav_log.cc:254 nvcsw=51
2024-09-09T12:13:03.703 I t0 lnav_log.cc:254 nivcsw=0
2024-09-09T12:13:03.703 D t0 listview_curses.hh:501
listview_curses=0x2072600364d0
2024-09-09T12:13:03.703 D t0 listview_curses.hh:511 lv_title=;
vc_y=0; lv_top=0; lv_left=0; lv_height=0; lv_selection=0;
inner_height=0
2024-09-09T12:13:03.703 D t0 listview_curses.hh:501
listview_curses=0x207260036e70
2024-09-09T12:13:03.703 D t0 listview_curses.hh:511
lv_title=breadcrumb popup; vc_y=0; lv_top=0; lv_left=0;
lv_height=0; lv_selection=-1; inner_height=0
2024-09-09T12:13:03.703 D t0 listview_curses.hh:501
listview_curses=0xac0550
2024-09-09T12:13:03.703 D t0 listview_curses.hh:511 lv_title=;
vc_y=96; lv_top=0; lv_left=0; lv_height=0; lv_selection=0;
inner_height=0
2024-09-09T12:13:03.703 D t0 listview_curses.hh:501
listview_curses=0xac0920
2024-09-09T12:13:03.703 D t0 listview_curses.hh:511
lv_title=Text Filters; vc_y=90; lv_top=0; lv_left=0; lv_height=5;
lv_selection=0; inner_height=0
2024-09-09T12:13:03.703 D t0 listview_curses.hh:501
listview_curses=0xac0d80
2024-09-09T12:13:03.703 D t0 listview_curses.hh:511
lv_title=Files; vc_y=90; lv_top=0; lv_left=0; lv_height=5;
lv_selection=0; inner_height=1
2024-09-09T12:13:03.703 D t0 listview_curses.hh:501
listview_curses=0xac1420
2024-09-09T12:13:03.703 D t0 listview_curses.hh:511 lv_title=;
vc_y=0; lv_top=0; lv_left=0; lv_height=0; lv_selection=0;
inner_height=0
2024-09-09T12:13:03.703 D t0 listview_curses.hh:501
listview_curses=0xac1ac0
2024-09-09T12:13:03.703 D t0 listview_curses.hh:511 lv_title=;
vc_y=96; lv_top=0; lv_left=0; lv_height=0; lv_selection=0;
inner_height=0
2024-09-09T12:13:03.703 D t0 listview_curses.hh:501
listview_curses=0xac2420
2024-09-09T12:13:03.703 D t0 listview_curses.hh:511 lv_title=;
vc_y=96; lv_top=0; lv_left=0; lv_height=0; lv_selection=0;
inner_height=0
2024-09-09T12:13:03.703 D t0 listview_curses.hh:501
listview_curses=0xac27f0
2024-09-09T12:13:03.703 D t0 listview_curses.hh:511 lv_title=;
vc_y=96; lv_top=0; lv_left=0; lv_height=0; lv_selection=0;
inner_height=0
2024-09-09T12:13:03.703 D t0 listview_curses.hh:501
listview_curses=0xac2e90
2024-09-09T12:13:03.703 D t0 listview_curses.hh:511 lv_title=;
vc_y=96; lv_top=0; lv_left=0; lv_height=0; lv_selection=0;
inner_height=0
2024-09-09T12:13:03.703 D t0 listview_curses.hh:501
listview_curses=0xac3270
2024-09-09T12:13:03.703 D t0 listview_curses.hh:511
lv_title=spectro-details; vc_y=89; lv_top=0; lv_left=0;
lv_height=5; lv_selection=0; inner_height=1
2024-09-09T12:13:03.703 D t0 listview_curses.hh:501
listview_curses=0xac3910
2024-09-09T12:13:03.703 D t0 listview_curses.hh:511
lv_title=gantt-details; vc_y=96; lv_top=0; lv_left=0; lv_height=5;
lv_selection=0; inner_height=0
2024-09-09T12:13:03.703 D t0 listview_curses.hh:501
listview_curses=0xac4060
2024-09-09T12:13:03.703 D t0 listview_curses.hh:511
lv_title=LOG; vc_y=2; lv_top=331; lv_left=0; lv_height=-9;
lv_selection=414; inner_height=415
2024-09-09T12:13:03.703 D t0 listview_curses.hh:501
listview_curses=0xac4430
2024-09-09T12:13:03.703 D t0 listview_curses.hh:511
lv_title=TEXT; vc_y=2; lv_top=0; lv_left=0; lv_height=-9;
lv_selection=0; inner_height=0
2024-09-09T12:13:03.703 D t0 listview_curses.hh:501
listview_curses=0xac4800
2024-09-09T12:13:03.703 D t0 listview_curses.hh:511
lv_title=HELP; vc_y=2; lv_top=0; lv_left=0; lv_height=-9;
lv_selection=0; inner_height=0
2024-09-09T12:13:03.703 D t0 listview_curses.hh:501
listview_curses=0xac4bd0
2024-09-09T12:13:03.703 D t0 listview_curses.hh:511
lv_title=HIST; vc_y=2; lv_top=0; lv_left=0; lv_height=-9;
lv_selection=0; inner_height=29
2024-09-09T12:13:03.703 D t0 listview_curses.hh:501
listview_curses=0xac4fa0
2024-09-09T12:13:03.703 D t0 listview_curses.hh:511 lv_title=DB;
vc_y=2; lv_top=0; lv_left=0; lv_height=-9; lv_selection=0;
inner_height=0
2024-09-09T12:13:03.703 D t0 listview_curses.hh:501
listview_curses=0xac5370
2024-09-09T12:13:03.703 D t0 listview_curses.hh:511
lv_title=SCHEMA; vc_y=2; lv_top=0; lv_left=0; lv_height=-9;
lv_selection=0; inner_height=0
2024-09-09T12:13:03.703 D t0 listview_curses.hh:501
listview_curses=0xac5740
2024-09-09T12:13:03.703 D t0 listview_curses.hh:511
lv_title=PRETTY; vc_y=2; lv_top=0; lv_left=0; lv_height=-9;
lv_selection=0; inner_height=0
2024-09-09T12:13:03.703 D t0 listview_curses.hh:501
listview_curses=0xac5b10
2024-09-09T12:13:03.703 D t0 listview_curses.hh:511
lv_title=SPECTRO; vc_y=2; lv_top=0; lv_left=0; lv_height=-9;
lv_selection=-1; inner_height=0
2024-09-09T12:13:03.703 D t0 listview_curses.hh:501
listview_curses=0xac5ee0
2024-09-09T12:13:03.703 D t0 listview_curses.hh:511
lv_title=GANTT; vc_y=2; lv_top=0; lv_left=0; lv_height=-9;
lv_selection=0; inner_height=0
2024-09-09T12:13:03.703 I t0 lnav.hh:98 recent_key_presses:
index=0
0x0 (^@) 0x0 (^@) 0x0 (^@) 0x0 (^@) 0x0 (^@) 0x0 (^@) 0x0 (^@)
0x0 (^@) 0x0 (^@) 0x0 (^@)