I don’t get it, if you don’t have any experience with coding logging/levels why don’t look at some other databases?
Spot the differences, if you find them I have for you special super patches ‘Earned First researcher’, ‘Earned Einstein’, ‘Earned Syslog super expert’ (oh and influxdb is sort of testing here, we have a lot more data/db’s in the others).
service stop / service start at info level
Mar 9 18:28:39 db1 systemd: Stopping MariaDB database server…
Mar 9 18:28:39 db1 systemd: Stopping MariaDB database server…
Mar 9 18:28:42 db1 systemd: Starting MariaDB database server…
Mar 9 18:28:42 db1 systemd: Starting MariaDB database server…
Mar 9 18:28:42 db1 mariadb-prepare-db-dir: Database MariaDB is probably initialized in /var/lib/mysql already, nothing is done.
Mar 9 18:28:42 db1 mariadb-prepare-db-dir: Database MariaDB is probably initialized in /var/lib/mysql already, nothing is done.
Mar 9 18:28:42 db1 mariadb-prepare-db-dir: If this is not the case, make sure the /var/lib/mysql is empty before running mariadb-prepare-db-dir.
Mar 9 18:28:42 db1 mariadb-prepare-db-dir: If this is not the case, make sure the /var/lib/mysql is empty before running mariadb-prepare-db-dir.
Mar 9 18:28:43 db1 mysqld_safe: 180309 18:28:43 mysqld_safe Logging to ‘/var/log/mariadb/mariadb.log’.
Mar 9 18:28:43 db1 mysqld_safe: 180309 18:28:43 mysqld_safe Logging to ‘/var/log/mariadb/mariadb.log’.
Mar 9 18:28:45 db1 systemd: Started MariaDB database server.
Mar 9 18:28:45 db1 systemd: Started MariaDB database server.
Mar 9 18:31:57 db1 systemd: Stopping PostgreSQL 9.5 database server…
Mar 9 18:31:57 db1 systemd: Stopping PostgreSQL 9.5 database server…
Mar 9 18:31:58 db1 systemd: Stopped PostgreSQL 9.5 database server.
Mar 9 18:31:58 db1 systemd: Stopped PostgreSQL 9.5 database server.
Mar 9 18:32:11 db1 systemd: Starting PostgreSQL 9.5 database server…
Mar 9 18:32:11 db1 systemd: Starting PostgreSQL 9.5 database server…
Mar 9 18:32:12 db1 pg_ctl: LOG: redirecting log output to logging collector process
Mar 9 18:32:12 db1 pg_ctl: LOG: redirecting log output to logging collector process
Mar 9 18:32:12 db1 pg_ctl: HINT: Future log output will appear in directory “pg_log”.
Mar 9 18:32:12 db1 pg_ctl: HINT: Future log output will appear in directory “pg_log”.
Mar 9 18:32:12 db1 systemd: Started PostgreSQL 9.5 database server.
Mar 9 18:32:12 db1 systemd: Started PostgreSQL 9.5 database server.
Mar 9 18:37:54 db1 systemd: Starting Cleanup of Temporary Directories…
Mar 9 18:37:54 db1 systemd: Starting Cleanup of Temporary Directories…
Mar 9 18:37:54 db1 systemd: Started Cleanup of Temporary Directories.
Mar 9 18:37:54 db1 systemd: Started Cleanup of Temporary Directories.
Mar 9 18:38:02 db1 systemd: Stopping InfluxDB is an open-source, distributed, time series database…
Mar 9 18:38:02 db1 systemd: Stopping InfluxDB is an open-source, distributed, time series database…
Mar 9 18:38:02 db1 influxd: ts=2018-03-09T17:38:02.739999Z lvl=info msg=“Signal received, initializing clean shutdown…” log_id=06jxbnel000
Mar 9 18:38:02 db1 influxd: ts=2018-03-09T17:38:02.739999Z lvl=info msg=“Signal received, initializing clean shutdown…” log_id=06jxbnel000
Mar 9 18:38:02 db1 influxd: ts=2018-03-09T17:38:02.740137Z lvl=info msg=“Waiting for clean shutdown…” log_id=06jxbnel000
Mar 9 18:38:02 db1 influxd: ts=2018-03-09T17:38:02.740137Z lvl=info msg=“Waiting for clean shutdown…” log_id=06jxbnel000
Mar 9 18:38:02 db1 influxd: ts=2018-03-09T17:38:02.740196Z lvl=info msg=“Shutting down monitor service” log_id=06jxbnel000 service=monitor
Mar 9 18:38:02 db1 influxd: ts=2018-03-09T17:38:02.740196Z lvl=info msg=“Shutting down monitor service” log_id=06jxbnel000 service=monitor
Mar 9 18:38:02 db1 influxd: ts=2018-03-09T17:38:02.740258Z lvl=info msg=“Terminating storage of statistics” log_id=06jxbnel000 service=monitor
Mar 9 18:38:02 db1 influxd: ts=2018-03-09T17:38:02.740258Z lvl=info msg=“Terminating storage of statistics” log_id=06jxbnel000 service=monitor
Mar 9 18:38:02 db1 influxd: ts=2018-03-09T17:38:02.740312Z lvl=info msg=“Terminating precreation service” log_id=06jxbnel000 service=shard-precreation
Mar 9 18:38:02 db1 influxd: ts=2018-03-09T17:38:02.740312Z lvl=info msg=“Terminating precreation service” log_id=06jxbnel000 service=shard-precreation
Mar 9 18:38:02 db1 influxd: ts=2018-03-09T17:38:02.740387Z lvl=info msg=“Listener closed” log_id=06jxbnel000 service=snapshot
Mar 9 18:38:02 db1 influxd: ts=2018-03-09T17:38:02.740387Z lvl=info msg=“Listener closed” log_id=06jxbnel000 service=snapshot
Mar 9 18:38:02 db1 influxd: ts=2018-03-09T17:38:02.740423Z lvl=info msg=“Terminating continuous query service” log_id=06jxbnel000 service=continuous_querier
Mar 9 18:38:02 db1 influxd: ts=2018-03-09T17:38:02.740423Z lvl=info msg=“Terminating continuous query service” log_id=06jxbnel000 service=continuous_querier
Mar 9 18:38:02 db1 influxd: ts=2018-03-09T17:38:02.740454Z lvl=info msg=“Closing retention policy enforcement service” log_id=06jxbnel000 service=retention
Mar 9 18:38:02 db1 influxd: ts=2018-03-09T17:38:02.740454Z lvl=info msg=“Closing retention policy enforcement service” log_id=06jxbnel000 service=retention
Mar 9 18:38:02 db1 influxd: ts=2018-03-09T17:38:02.757806Z lvl=info msg=“Server shutdown completed” log_id=06jxbnel000
Mar 9 18:38:02 db1 influxd: ts=2018-03-09T17:38:02.757806Z lvl=info msg=“Server shutdown completed” log_id=06jxbnel000
Mar 9 18:38:02 db1 systemd: Stopped InfluxDB is an open-source, distributed, time series database.
Mar 9 18:38:02 db1 systemd: Stopped InfluxDB is an open-source, distributed, time series database.
Mar 9 18:43:48 db1 influxd: ts=2018-03-09T17:43:48.993473Z lvl=info msg=“InfluxDB starting” log_id=06jycx0G000 version=1.5.0 branch=1.5 commit=6ac835404e7e64ea7299a6eebcce1ab1ef15fe3c
Mar 9 18:43:48 db1 influxd: ts=2018-03-09T17:43:48.993473Z lvl=info msg=“InfluxDB starting” log_id=06jycx0G000 version=1.5.0 branch=1.5 commit=6ac835404e7e64ea7299a6eebcce1ab1ef15fe3c
Mar 9 18:43:48 db1 influxd: ts=2018-03-09T17:43:48.994260Z lvl=info msg=“Go runtime” log_id=06jycx0G000 version=go1.9.2 maxprocs=1
Mar 9 18:43:48 db1 influxd: ts=2018-03-09T17:43:48.994260Z lvl=info msg=“Go runtime” log_id=06jycx0G000 version=go1.9.2 maxprocs=1
Mar 9 18:43:49 db1 influxd: ts=2018-03-09T17:43:49.095938Z lvl=info msg=“Using data dir” log_id=06jycx0G000 service=store path=/var/lib/influxdb/data
Mar 9 18:43:49 db1 influxd: ts=2018-03-09T17:43:49.095938Z lvl=info msg=“Using data dir” log_id=06jycx0G000 service=store path=/var/lib/influxdb/data
Mar 9 18:43:49 db1 influxd: ts=2018-03-09T17:43:49.096994Z lvl=info msg=“Open store (start)” log_id=06jycx0G000 service=store trace_id=06jycxQ0000 op_name=tsdb_open op_event=start
Mar 9 18:43:49 db1 influxd: ts=2018-03-09T17:43:49.096994Z lvl=info msg=“Open store (start)” log_id=06jycx0G000 service=store trace_id=06jycxQ0000 op_name=tsdb_open op_event=start
Mar 9 18:43:49 db1 influxd: ts=2018-03-09T17:43:49.572423Z lvl=info msg=“Reading file” log_id=06jycx0G000 engine=tsm1 service=cacheloader path=/var/lib/influxdb/wal/_internal/monitor/5/_00001.wal size=65584
Mar 9 18:43:49 db1 influxd: ts=2018-03-09T17:43:49.572423Z lvl=info msg=“Reading file” log_id=06jycx0G000 engine=tsm1 service=cacheloader path=/var/lib/influxdb/wal/_internal/monitor/5/_00001.wal size=65584
Mar 9 18:43:50 db1 influxd: ts=2018-03-09T17:43:50.121012Z lvl=info msg=“Opened shard” log_id=06jycx0G000 service=store trace_id=06jycxQ0000 op_name=tsdb_open path=/var/lib/influxdb/data/_internal/monitor/5 duration=551.181ms
Mar 9 18:43:50 db1 influxd: ts=2018-03-09T17:43:50.121012Z lvl=info msg=“Opened shard” log_id=06jycx0G000 service=store trace_id=06jycxQ0000 op_name=tsdb_open path=/var/lib/influxdb/data/_internal/monitor/5 duration=551.181ms
Mar 9 18:43:50 db1 influxd: ts=2018-03-09T17:43:50.122203Z lvl=info msg=“Opened shard” log_id=06jycx0G000 service=store trace_id=06jycxQ0000 op_name=tsdb_open path=/var/lib/influxdb/data/_internal/monitor/1 duration=0.511ms
Mar 9 18:43:50 db1 influxd: ts=2018-03-09T17:43:50.122203Z lvl=info msg=“Opened shard” log_id=06jycx0G000 service=store trace_id=06jycxQ0000 op_name=tsdb_open path=/var/lib/influxdb/data/_internal/monitor/1 duration=0.511ms
Mar 9 18:43:50 db1 influxd: ts=2018-03-09T17:43:50.123825Z lvl=info msg=“Opened shard” log_id=06jycx0G000 service=store trace_id=06jycxQ0000 op_name=tsdb_open path=/var/lib/influxdb/data/_internal/monitor/2 duration=0.484ms
Mar 9 18:43:50 db1 influxd: ts=2018-03-09T17:43:50.123825Z lvl=info msg=“Opened shard” log_id=06jycx0G000 service=store trace_id=06jycxQ0000 op_name=tsdb_open path=/var/lib/influxdb/data/_internal/monitor/2 duration=0.484ms
Mar 9 18:43:50 db1 influxd: ts=2018-03-09T17:43:50.124701Z lvl=info msg=“Opened shard” log_id=06jycx0G000 service=store trace_id=06jycxQ0000 op_name=tsdb_open path=/var/lib/influxdb/data/_internal/monitor/3 duration=0.396ms
Mar 9 18:43:50 db1 influxd: ts=2018-03-09T17:43:50.124701Z lvl=info msg=“Opened shard” log_id=06jycx0G000 service=store trace_id=06jycxQ0000 op_name=tsdb_open path=/var/lib/influxdb/data/_internal/monitor/3 duration=0.396ms
Mar 9 18:43:50 db1 influxd: ts=2018-03-09T17:43:50.261705Z lvl=info msg=“Opened file” log_id=06jycx0G000 engine=tsm1 service=filestore path=/var/lib/influxdb/data/_internal/monitor/313/000000002-000000002.tsm id=0 duration=136.034ms
Mar 9 18:43:50 db1 influxd: ts=2018-03-09T17:43:50.261705Z lvl=info msg=“Opened file” log_id=06jycx0G000 engine=tsm1 service=filestore path=/var/lib/influxdb/data/_internal/monitor/313/000000002-000000002.tsm id=0 duration=136.034ms
Mar 9 18:43:50 db1 influxd: ts=2018-03-09T17:43:50.386183Z lvl=info msg=“Opened shard” log_id=06jycx0G000 service=store trace_id=06jycxQ0000 op_name=tsdb_open path=/var/lib/influxdb/data/_internal/monitor/313 duration=260.984ms
Mar 9 18:43:50 db1 influxd: ts=2018-03-09T17:43:50.386183Z lvl=info msg=“Opened shard” log_id=06jycx0G000 service=store trace_id=06jycxQ0000 op_name=tsdb_open path=/var/lib/influxdb/data/_internal/monitor/313 duration=260.984ms
Mar 9 18:43:50 db1 influxd: ts=2018-03-09T17:43:50.532765Z lvl=info msg=“Opened file” log_id=06jycx0G000 engine=tsm1 service=filestore path=/var/lib/influxdb/data/_internal/monitor/314/000000011-000000003.tsm id=0 duration=145.179ms
Mar 9 18:43:50 db1 influxd: ts=2018-03-09T17:43:50.532765Z lvl=info msg=“Opened file” log_id=06jycx0G000 engine=tsm1 service=filestore path=/var/lib/influxdb/data/_internal/monitor/314/000000011-000000003.tsm id=0 duration=145.179ms
Mar 9 18:43:50 db1 influxd: ts=2018-03-09T17:43:50.658432Z lvl=info msg=“Opened shard” log_id=06jycx0G000 service=store trace_id=06jycxQ0000 op_name=tsdb_open path=/var/lib/influxdb/data/_internal/monitor/314 duration=272.177ms
Mar 9 18:43:50 db1 influxd: ts=2018-03-09T17:43:50.658432Z lvl=info msg=“Opened shard” log_id=06jycx0G000 service=store trace_id=06jycxQ0000 op_name=tsdb_open path=/var/lib/influxdb/data/_internal/monitor/314 duration=272.177ms
Mar 9 18:43:50 db1 influxd: ts=2018-03-09T17:43:50.739087Z lvl=info msg=“Opened file” log_id=06jycx0G000 engine=tsm1 service=filestore path=/var/lib/influxdb/data/_internal/monitor/39/000000015-000000002.tsm id=0 duration=78.849ms
Mar 9 18:43:50 db1 influxd: ts=2018-03-09T17:43:50.739087Z lvl=info msg=“Opened file” log_id=06jycx0G000 engine=tsm1 service=filestore path=/var/lib/influxdb/data/_internal/monitor/39/000000015-000000002.tsm id=0 duration=78.849ms
Mar 9 18:43:50 db1 influxd: ts=2018-03-09T17:43:50.857717Z lvl=info msg=“Opened shard” log_id=06jycx0G000 service=store trace_id=06jycxQ0000 op_name=tsdb_open path=/var/lib/influxdb/data/_internal/monitor/39 duration=198.214ms
Mar 9 18:43:50 db1 influxd: ts=2018-03-09T17:43:50.857717Z lvl=info msg=“Opened shard” log_id=06jycx0G000 service=store trace_id=06jycxQ0000 op_name=tsdb_open path=/var/lib/influxdb/data/_internal/monitor/39 duration=198.214ms
Mar 9 18:43:50 db1 influxd: ts=2018-03-09T17:43:50.884174Z lvl=info msg=“Opened file” log_id=06jycx0G000 engine=tsm1 service=filestore path=/var/lib/influxdb/data/_internal/monitor/4/000000001-000000001.tsm id=0 duration=24.846ms
Mar 9 18:43:50 db1 influxd: ts=2018-03-09T17:43:50.884174Z lvl=info msg=“Opened file” log_id=06jycx0G000 engine=tsm1 service=filestore path=/var/lib/influxdb/data/_internal/monitor/4/000000001-000000001.tsm id=0 duration=24.846ms
Mar 9 18:43:51 db1 influxd: ts=2018-03-09T17:43:51.033859Z lvl=info msg=“Opened shard” log_id=06jycx0G000 service=store trace_id=06jycxQ0000 op_name=tsdb_open path=/var/lib/influxdb/data/_internal/monitor/4 duration=175.252ms
Mar 9 18:43:51 db1 influxd: ts=2018-03-09T17:43:51.033859Z lvl=info msg=“Opened shard” log_id=06jycx0G000 service=store trace_id=06jycxQ0000 op_name=tsdb_open path=/var/lib/influxdb/data/_internal/monitor/4 duration=175.252ms
Mar 9 18:43:51 db1 influxd: ts=2018-03-09T17:43:51.181530Z lvl=info msg=“Opened file” log_id=06jycx0G000 engine=tsm1 service=filestore path=/var/lib/influxdb/data/_internal/monitor/41/000000015-000000002.tsm id=0 duration=145.385ms
Mar 9 18:43:51 db1 influxd: ts=2018-03-09T17:43:51.181530Z lvl=info msg=“Opened file” log_id=06jycx0G000 engine=tsm1 service=filestore path=/var/lib/influxdb/data/_internal/monitor/41/000000015-000000002.tsm id=0 duration=145.385ms
Mar 9 18:43:51 db1 influxd: ts=2018-03-09T17:43:51.609149Z lvl=info msg=“Opened shard” log_id=06jycx0G000 service=store trace_id=06jycxQ0000 op_name=tsdb_open path=/var/lib/influxdb/data/_internal/monitor/41 duration=574.115ms
Mar 9 18:43:51 db1 influxd: ts=2018-03-09T17:43:51.609149Z lvl=info msg=“Opened shard” log_id=06jycx0G000 service=store trace_id=06jycxQ0000 op_name=tsdb_open path=/var/lib/influxdb/data/_internal/monitor/41 duration=574.115ms
Mar 9 18:43:51 db1 influxd: ts=2018-03-09T17:43:51.817862Z lvl=info msg=“Opened file” log_id=06jycx0G000 engine=tsm1 service=filestore path=/var/lib/influxdb/data/_internal/monitor/42/000000015-000000002.tsm id=0 duration=207.866ms
Mar 9 18:43:51 db1 influxd: ts=2018-03-09T17:43:51.817862Z lvl=info msg=“Opened file” log_id=06jycx0G000 engine=tsm1 service=filestore path=/var/lib/influxdb/data/_internal/monitor/42/000000015-000000002.tsm id=0 duration=207.866ms
Mar 9 18:43:53 db1 influxd: ts=2018-03-09T17:43:53.344139Z lvl=info msg=“Opened shard” log_id=06jycx0G000 service=store trace_id=06jycxQ0000 op_name=tsdb_open path=/var/lib/influxdb/data/_internal/monitor/42 duration=1734.890ms
Mar 9 18:43:53 db1 influxd: ts=2018-03-09T17:43:53.344139Z lvl=info msg=“Opened shard” log_id=06jycx0G000 service=store trace_id=06jycxQ0000 op_name=tsdb_open path=/var/lib/influxdb/data/_internal/monitor/42 duration=1734.890ms
Mar 9 18:43:53 db1 influxd: ts=2018-03-09T17:43:53.629683Z lvl=info msg=“Opened file” log_id=06jycx0G000 engine=tsm1 service=filestore path=/var/lib/influxdb/data/_internal/monitor/44/000000015-000000002.tsm id=0 duration=284.919ms
Mar 9 18:43:53 db1 influxd: ts=2018-03-09T17:43:53.629683Z lvl=info msg=“Opened file” log_id=06jycx0G000 engine=tsm1 service=filestore path=/var/lib/influxdb/data/_internal/monitor/44/000000015-000000002.tsm id=0 duration=284.919ms
Mar 9 18:43:53 db1 influxd: ts=2018-03-09T17:43:53.819134Z lvl=info msg=“Opened shard” log_id=06jycx0G000 service=store trace_id=06jycxQ0000 op_name=tsdb_open path=/var/lib/influxdb/data/_internal/monitor/44 duration=474.930ms
Mar 9 18:43:53 db1 influxd: ts=2018-03-09T17:43:53.819134Z lvl=info msg=“Opened shard” log_id=06jycx0G000 service=store trace_id=06jycxQ0000 op_name=tsdb_open path=/var/lib/influxdb/data/_internal/monitor/44 duration=474.930ms
Mar 9 18:43:53 db1 influxd: ts=2018-03-09T17:43:53.941330Z lvl=info msg=“Opened file” log_id=06jycx0G000 engine=tsm1 service=filestore path=/var/lib/influxdb/data/_internal/monitor/45/000000010-000000002.tsm id=0 duration=120.300ms
Mar 9 18:43:53 db1 influxd: ts=2018-03-09T17:43:53.941330Z lvl=info msg=“Opened file” log_id=06jycx0G000 engine=tsm1 service=filestore path=/var/lib/influxdb/data/_internal/monitor/45/000000010-000000002.tsm id=0 duration=120.300ms
Mar 9 18:43:54 db1 influxd: ts=2018-03-09T17:43:54.074697Z lvl=info msg=“Opened shard” log_id=06jycx0G000 service=store trace_id=06jycxQ0000 op_name=tsdb_open path=/var/lib/influxdb/data/_internal/monitor/45 duration=254.443ms
Mar 9 18:43:54 db1 influxd: ts=2018-03-09T17:43:54.074697Z lvl=info msg=“Opened shard” log_id=06jycx0G000 service=store trace_id=06jycxQ0000 op_name=tsdb_open path=/var/lib/influxdb/data/_internal/monitor/45 duration=254.443ms
Mar 9 18:43:54 db1 influxd: ts=2018-03-09T17:43:54.230532Z lvl=info msg=“Opened file” log_id=06jycx0G000 engine=tsm1 service=filestore path=/var/lib/influxdb/data/_internal/monitor/46/000000015-000000002.tsm id=0 duration=153.833ms
Mar 9 18:43:54 db1 influxd: ts=2018-03-09T17:43:54.230532Z lvl=info msg=“Opened file” log_id=06jycx0G000 engine=tsm1 service=filestore path=/var/lib/influxdb/data/_internal/monitor/46/000000015-000000002.tsm id=0 duration=153.833ms
Mar 9 18:43:54 db1 influxd: ts=2018-03-09T17:43:54.690199Z lvl=info msg=“Opened shard” log_id=06jycx0G000 service=store trace_id=06jycxQ0000 op_name=tsdb_open path=/var/lib/influxdb/data/_internal/monitor/46 duration=614.488ms
Mar 9 18:43:54 db1 influxd: ts=2018-03-09T17:43:54.690199Z lvl=info msg=“Opened shard” log_id=06jycx0G000 service=store trace_id=06jycxQ0000 op_name=tsdb_open path=/var/lib/influxdb/data/_internal/monitor/46 duration=614.488ms
Mar 9 18:43:54 db1 influxd: ts=2018-03-09T17:43:54.694271Z lvl=info msg=“Opened file” log_id=06jycx0G000 engine=tsm1 service=filestore path=/var/lib/influxdb/data/_internal/monitor/47/000000012-000000001.tsm id=3 duration=1.594ms
AND THERE IS EVEN MORE!!!
PS. and stop censoring my messages, otherwise I will start posting on reddit