Influxdb and grafana dont start at boot

momo90 · March 16, 2021, 8:39pm

Hi!
I made a fresh install of openhabian 1.6.3. and installed grafana and influxdb via sudo openhabian-config. Before that I restored a backup via sudo openhab-cli restore
Neither influxdb nor grafana starts ant booting. I have to manually start them via sudo systemctl start grafana-server.service and sudo systemctl start influxdb.service.
I also tried sudo systemctl enable influxdb.service but after a reboot it didnt start automatically.

this is the output of sudo systemctl status influxdb.service

● influxdb.service - InfluxDB is an open-source, distributed, time series database
   Loaded: loaded (/lib/systemd/system/influxdb.service; enabled; vendor preset: enabled)
   Active: inactive (dead) since Tue 2021-03-16 20:44:52 CET; 1min 53s ago
     Docs: https://docs.influxdata.com/influxdb/
  Process: 545 ExecStart=/usr/bin/influxd -config /etc/influxdb/influxdb.conf $INFLUXD_OPTS (code=killed, signal=PIPE)
 Main PID: 545 (code=killed, signal=PIPE)

Mar 15 22:06:07 openhabian influxd[545]: ts=2021-03-15T21:06:07.292955Z lvl=info msg="Starting continuous query service" log_id=0SuwCsyW000 service=
Mar 15 22:06:07 openhabian influxd[545]: ts=2021-03-15T21:06:07.302178Z lvl=info msg="Starting HTTP service" log_id=0SuwCsyW000 service=httpd authen
Mar 15 22:06:07 openhabian influxd[545]: ts=2021-03-15T21:06:07.302319Z lvl=info msg="opened HTTP access log" log_id=0SuwCsyW000 service=httpd path=
Mar 15 22:06:07 openhabian influxd[545]: ts=2021-03-15T21:06:07.302353Z lvl=info msg="Auth is enabled but shared-secret is blank. BearerAuthenticati
Mar 15 22:06:07 openhabian influxd[545]: ts=2021-03-15T21:06:07.310831Z lvl=info msg="Listening on HTTP" log_id=0SuwCsyW000 service=httpd addr=127.0
Mar 15 22:06:07 openhabian influxd[545]: ts=2021-03-15T21:06:07.329506Z lvl=info msg="Starting retention policy enforcement service" log_id=0SuwCsyW
Mar 15 22:06:07 openhabian influxd[545]: ts=2021-03-15T21:06:07.330040Z lvl=info msg="Listening for signals" log_id=0SuwCsyW000
Mar 15 22:06:07 openhabian influxd[545]: ts=2021-03-15T21:06:07.620898Z lvl=info msg="Sending usage statistics to usage.influxdata.com" log_id=0SuwC
Mar 16 20:44:52 openhabian systemd[1]: influxdb.service: Main process exited, code=killed, status=13/PIPE
Mar 16 20:44:52 openhabian systemd[1]: influxdb.service: Succeeded.

and sudo systemctl status grafana-server.service

● grafana-server.service - Grafana instance
   Loaded: loaded (/lib/systemd/system/grafana-server.service; enabled; vendor preset: enabled)
   Active: inactive (dead) since Mon 2021-03-15 22:06:11 CET; 22h ago
     Docs: http://docs.grafana.org
  Process: 548 ExecStart=/usr/sbin/grafana-server --config=${CONF_FILE} --pidfile=${PID_FILE_DIR}/grafana-server.pid --packaging=deb cfg:default.pat
 Main PID: 548 (code=killed, signal=PIPE)

Mar 15 22:06:07 openhabian grafana-server[548]: t=2021-03-15T22:06:07+0100 lvl=info msg="Path Logs" logger=settings path=/var/log/grafana
Mar 15 22:06:07 openhabian grafana-server[548]: t=2021-03-15T22:06:07+0100 lvl=info msg="Path Plugins" logger=settings path=/var/lib/grafana/plugins
Mar 15 22:06:07 openhabian grafana-server[548]: t=2021-03-15T22:06:07+0100 lvl=info msg="Path Provisioning" logger=settings path=/etc/grafana/provis
Mar 15 22:06:07 openhabian grafana-server[548]: t=2021-03-15T22:06:07+0100 lvl=info msg="App mode production" logger=settings
Mar 15 22:06:07 openhabian grafana-server[548]: t=2021-03-15T22:06:07+0100 lvl=info msg="Writing PID file" logger=server path=/var/run/grafana/grafa
Mar 15 22:06:07 openhabian grafana-server[548]: t=2021-03-15T22:06:07+0100 lvl=info msg="Connecting to DB" logger=sqlstore dbtype=sqlite3
Mar 15 22:06:07 openhabian grafana-server[548]: t=2021-03-15T22:06:07+0100 lvl=info msg="Starting DB migrations" logger=migrator
Mar 15 22:06:07 openhabian grafana-server[548]: t=2021-03-15T22:06:07+0100 lvl=info msg="Starting plugin search" logger=plugins
Mar 15 22:06:11 openhabian systemd[1]: grafana-server.service: Main process exited, code=killed, status=13/PIPE
Mar 15 22:06:11 openhabian systemd[1]: grafana-server.service: Succeeded.

Can anybody help me?

Wolfgang_S · March 17, 2021, 6:01am

Looks like the logs are cut off and they are not shown to their complete length.
For influxdb there is a warning that no password is set ?
To get more insight please post the output of

sudo journalctl -u influxdb

sudo journalctl -u grafana

momo90 · March 17, 2021, 7:33am

Ok, I’ll post the output as soon as I am home again.

Strange. I am sure I set a password during the installation.

momo90 · March 18, 2021, 5:17pm

sudo journalctl -u influxdb

Mar 16 21:18:32 openhabian systemd[1]: Started InfluxDB is an open-source, distributed, time series database.
Mar 16 21:18:36 openhabian influxd[547]: ts=2021-03-16T20:18:36.140647Z lvl=info msg="InfluxDB starting" log_id=0SwAtLw0000 version=1.8.4 branch=1.8 commit=bc8ec4384eed25436d31045f974bf39f3310fa3c
Mar 16 21:18:36 openhabian influxd[547]: ts=2021-03-16T20:18:36.140867Z lvl=info msg="Go runtime" log_id=0SwAtLw0000 version=go1.13.8 maxprocs=4
Mar 16 21:18:36 openhabian influxd[547]: ts=2021-03-16T20:18:36.299300Z lvl=info msg="Using data dir" log_id=0SwAtLw0000 service=store path=/var/lib/influxdb/data
Mar 16 21:18:36 openhabian influxd[547]: ts=2021-03-16T20:18:36.299600Z lvl=info msg="Compaction settings" log_id=0SwAtLw0000 service=store max_concurrent_compactions=2 throughput_bytes_per_second=50331648 throughput_bytes_per_second_bur
Mar 16 21:18:36 openhabian influxd[547]: ts=2021-03-16T20:18:36.307247Z lvl=info msg="Open store (start)" log_id=0SwAtLw0000 service=store trace_id=0SwAtM_l000 op_name=tsdb_open op_event=start
Mar 16 21:18:36 openhabian influxd[547]: ts=2021-03-16T20:18:36.532813Z lvl=info msg="Opened file" log_id=0SwAtLw0000 engine=tsm1 service=filestore path=/var/lib/influxdb/data/openhab_db/autogen/2/000000003-000000002.tsm id=0 duration=63
Mar 16 21:18:36 openhabian influxd[547]: ts=2021-03-16T20:18:36.579121Z lvl=info msg="Opened file" log_id=0SwAtLw0000 engine=tsm1 service=filestore path=/var/lib/influxdb/data/openhab_db/autogen/2/000000005-000000001.tsm id=1 duration=11
Mar 16 21:18:36 openhabian influxd[547]: ts=2021-03-16T20:18:36.599736Z lvl=info msg="Reading file" log_id=0SwAtLw0000 engine=tsm1 service=cacheloader path=/var/lib/influxdb/wal/openhab_db/autogen/2/_00004.wal size=24117
Mar 16 21:18:36 openhabian influxd[547]: ts=2021-03-16T20:18:36.584173Z lvl=info msg="Opened file" log_id=0SwAtLw0000 engine=tsm1 service=filestore path=/var/lib/influxdb/data/openhab_db/autogen/1/000000003-000000002.tsm id=0 duration=11
Mar 16 21:18:36 openhabian influxd[547]: ts=2021-03-16T20:18:36.784750Z lvl=info msg="Opened shard" log_id=0SwAtLw0000 service=store trace_id=0SwAtM_l000 op_name=tsdb_open index_version=inmem path=/var/lib/influxdb/data/openhab_db/autoge
Mar 16 21:18:36 openhabian influxd[547]: ts=2021-03-16T20:18:36.786362Z lvl=info msg="Opened shard" log_id=0SwAtLw0000 service=store trace_id=0SwAtM_l000 op_name=tsdb_open index_version=inmem path=/var/lib/influxdb/data/openhab_db/autoge
Mar 16 21:18:36 openhabian influxd[547]: ts=2021-03-16T20:18:36.786772Z lvl=info msg="Open store (end)" log_id=0SwAtLw0000 service=store trace_id=0SwAtM_l000 op_name=tsdb_open op_event=end op_elapsed=479.537ms
Mar 16 21:18:36 openhabian influxd[547]: ts=2021-03-16T20:18:36.794950Z lvl=info msg="Opened service" log_id=0SwAtLw0000 service=subscriber
Mar 16 21:18:36 openhabian influxd[547]: ts=2021-03-16T20:18:36.795053Z lvl=info msg="Starting monitor service" log_id=0SwAtLw0000 service=monitor
Mar 16 21:18:36 openhabian influxd[547]: ts=2021-03-16T20:18:36.795087Z lvl=info msg="Registered diagnostics client" log_id=0SwAtLw0000 service=monitor name=build
Mar 16 21:18:36 openhabian influxd[547]: ts=2021-03-16T20:18:36.795115Z lvl=info msg="Registered diagnostics client" log_id=0SwAtLw0000 service=monitor name=runtime
Mar 16 21:18:36 openhabian influxd[547]: ts=2021-03-16T20:18:36.795139Z lvl=info msg="Registered diagnostics client" log_id=0SwAtLw0000 service=monitor name=network
Mar 16 21:18:36 openhabian influxd[547]: ts=2021-03-16T20:18:36.795193Z lvl=info msg="Registered diagnostics client" log_id=0SwAtLw0000 service=monitor name=system
Mar 16 21:18:36 openhabian influxd[547]: ts=2021-03-16T20:18:36.795246Z lvl=info msg="Starting precreation service" log_id=0SwAtLw0000 service=shard-precreation check_interval=10m advance_period=30m
Mar 16 21:18:36 openhabian influxd[547]: ts=2021-03-16T20:18:36.795286Z lvl=info msg="Starting snapshot service" log_id=0SwAtLw0000 service=snapshot
Mar 16 21:18:36 openhabian influxd[547]: ts=2021-03-16T20:18:36.795314Z lvl=info msg="Starting continuous query service" log_id=0SwAtLw0000 service=continuous_querier
Mar 16 21:18:36 openhabian influxd[547]: ts=2021-03-16T20:18:36.825822Z lvl=info msg="Starting HTTP service" log_id=0SwAtLw0000 service=httpd authentication=true
Mar 16 21:18:36 openhabian influxd[547]: ts=2021-03-16T20:18:36.825956Z lvl=info msg="opened HTTP access log" log_id=0SwAtLw0000 service=httpd path=stderr
Mar 16 21:18:36 openhabian influxd[547]: ts=2021-03-16T20:18:36.825991Z lvl=info msg="Auth is enabled but shared-secret is blank. BearerAuthentication is disabled." log_id=0SwAtLw0000 service=httpd
Mar 16 21:18:36 openhabian influxd[547]: ts=2021-03-16T20:18:36.835838Z lvl=info msg="Listening on HTTP" log_id=0SwAtLw0000 service=httpd addr=127.0.0.1:8086 https=false
Mar 16 21:18:36 openhabian influxd[547]: ts=2021-03-16T20:18:36.850154Z lvl=info msg="Starting retention policy enforcement service" log_id=0SwAtLw0000 service=retention check_interval=30m
Mar 16 21:18:36 openhabian influxd[547]: ts=2021-03-16T20:18:36.852633Z lvl=info msg="Listening for signals" log_id=0SwAtLw0000
Mar 16 21:18:37 openhabian influxd[547]: ts=2021-03-16T20:18:37.134310Z lvl=info msg="Sending usage statistics to usage.influxdata.com" log_id=0SwAtLw0000
Mar 18 18:12:23 openhabian systemd[1]: influxdb.service: Main process exited, code=killed, status=13/PIPE
Mar 18 18:12:23 openhabian systemd[1]: influxdb.service: Succeeded.

sudo journalctl -u grafana-service

Mar 16 21:18:32 openhabian systemd[1]: Started Grafana instance.
Mar 16 21:18:37 openhabian grafana-server[544]: t=2021-03-16T21:18:37+0100 lvl=info msg="Starting Grafana" logger=server version=7.4.3 commit=010f20c1c8 branch=HEAD compiled=2021-02-24T11:29:10+0100
Mar 16 21:18:37 openhabian grafana-server[544]: t=2021-03-16T21:18:37+0100 lvl=info msg="Config loaded from" logger=settings file=/usr/share/grafana/conf/defaults.ini
Mar 16 21:18:37 openhabian grafana-server[544]: t=2021-03-16T21:18:37+0100 lvl=info msg="Config loaded from" logger=settings file=/etc/grafana/grafana.ini
Mar 16 21:18:37 openhabian grafana-server[544]: t=2021-03-16T21:18:37+0100 lvl=info msg="Config overridden from command line" logger=settings arg="default.paths.data=/var/lib/grafana"
Mar 16 21:18:37 openhabian grafana-server[544]: t=2021-03-16T21:18:37+0100 lvl=info msg="Config overridden from command line" logger=settings arg="default.paths.logs=/var/log/grafana"
Mar 16 21:18:37 openhabian grafana-server[544]: t=2021-03-16T21:18:37+0100 lvl=info msg="Config overridden from command line" logger=settings arg="default.paths.plugins=/var/lib/grafana/plugins"
Mar 16 21:18:37 openhabian grafana-server[544]: t=2021-03-16T21:18:37+0100 lvl=info msg="Config overridden from command line" logger=settings arg="default.paths.provisioning=/etc/grafana/provisioning"
Mar 16 21:18:37 openhabian grafana-server[544]: t=2021-03-16T21:18:37+0100 lvl=info msg="Path Home" logger=settings path=/usr/share/grafana
Mar 16 21:18:37 openhabian grafana-server[544]: t=2021-03-16T21:18:37+0100 lvl=info msg="Path Data" logger=settings path=/var/lib/grafana
Mar 16 21:18:37 openhabian grafana-server[544]: t=2021-03-16T21:18:37+0100 lvl=info msg="Path Logs" logger=settings path=/var/log/grafana
Mar 16 21:18:37 openhabian grafana-server[544]: t=2021-03-16T21:18:37+0100 lvl=info msg="Path Plugins" logger=settings path=/var/lib/grafana/plugins
Mar 16 21:18:37 openhabian grafana-server[544]: t=2021-03-16T21:18:37+0100 lvl=info msg="Path Provisioning" logger=settings path=/etc/grafana/provisioning
Mar 16 21:18:37 openhabian grafana-server[544]: t=2021-03-16T21:18:37+0100 lvl=info msg="App mode production" logger=settings
Mar 16 21:18:37 openhabian grafana-server[544]: t=2021-03-16T21:18:37+0100 lvl=info msg="Writing PID file" logger=server path=/var/run/grafana/grafana-server.pid pid=544
Mar 16 21:18:37 openhabian grafana-server[544]: t=2021-03-16T21:18:37+0100 lvl=info msg="Connecting to DB" logger=sqlstore dbtype=sqlite3
Mar 16 21:18:37 openhabian grafana-server[544]: t=2021-03-16T21:18:37+0100 lvl=info msg="Starting DB migrations" logger=migrator
Mar 16 21:18:37 openhabian grafana-server[544]: t=2021-03-16T21:18:37+0100 lvl=info msg="Starting plugin search" logger=plugins
Mar 16 21:18:41 openhabian systemd[1]: grafana-server.service: Main process exited, code=killed, status=13/PIPE
Mar 16 21:18:41 openhabian systemd[1]: grafana-server.service: Succeeded.

momo90 · March 18, 2021, 5:19pm

and after

sudo systemctl start influxdb

Mar 18 18:18:39 openhabian systemd[1]: Started InfluxDB is an open-source, distributed, time series database.
Mar 18 18:18:40 openhabian influxd[3432]: ts=2021-03-18T17:18:40.390477Z lvl=info msg="InfluxDB starting" log_id=0SyaOJ1W000 version=1.8.4 branch=1.8 commit=bc8ec4384eed25436d31045f974bf39f3310fa3c
Mar 18 18:18:40 openhabian influxd[3432]: ts=2021-03-18T17:18:40.390623Z lvl=info msg="Go runtime" log_id=0SyaOJ1W000 version=go1.13.8 maxprocs=4
Mar 18 18:18:40 openhabian influxd[3432]: ts=2021-03-18T17:18:40.504201Z lvl=info msg="Using data dir" log_id=0SyaOJ1W000 service=store path=/var/lib/influxdb/data
Mar 18 18:18:40 openhabian influxd[3432]: ts=2021-03-18T17:18:40.504401Z lvl=info msg="Compaction settings" log_id=0SyaOJ1W000 service=store max_concurrent_compactions=2 throughput_bytes_per_second=50331648 throughput_bytes_per_second_bu
Mar 18 18:18:40 openhabian influxd[3432]: ts=2021-03-18T17:18:40.508558Z lvl=info msg="Open store (start)" log_id=0SyaOJ1W000 service=store trace_id=0SyaOJV0000 op_name=tsdb_open op_event=start
Mar 18 18:18:40 openhabian influxd[3432]: ts=2021-03-18T17:18:40.596545Z lvl=info msg="Opened file" log_id=0SyaOJ1W000 engine=tsm1 service=filestore path=/var/lib/influxdb/data/openhab_db/autogen/1/000000003-000000002.tsm id=0 duration=4
Mar 18 18:18:40 openhabian influxd[3432]: ts=2021-03-18T17:18:40.604111Z lvl=info msg="Opened file" log_id=0SyaOJ1W000 engine=tsm1 service=filestore path=/var/lib/influxdb/data/openhab_db/autogen/2/000000003-000000002.tsm id=0 duration=4
Mar 18 18:18:40 openhabian influxd[3432]: ts=2021-03-18T17:18:40.604181Z lvl=info msg="Opened file" log_id=0SyaOJ1W000 engine=tsm1 service=filestore path=/var/lib/influxdb/data/openhab_db/autogen/2/000000005-000000001.tsm id=1 duration=4
Mar 18 18:18:40 openhabian influxd[3432]: ts=2021-03-18T17:18:40.638643Z lvl=info msg="Reading file" log_id=0SyaOJ1W000 engine=tsm1 service=cacheloader path=/var/lib/influxdb/wal/openhab_db/autogen/2/_00004.wal size=24117
Mar 18 18:18:40 openhabian influxd[3432]: ts=2021-03-18T17:18:40.661085Z lvl=info msg="Opened shard" log_id=0SyaOJ1W000 service=store trace_id=0SyaOJV0000 op_name=tsdb_open index_version=inmem path=/var/lib/influxdb/data/openhab_db/autog
Mar 18 18:18:40 openhabian influxd[3432]: ts=2021-03-18T17:18:40.673644Z lvl=info msg="Opened shard" log_id=0SyaOJ1W000 service=store trace_id=0SyaOJV0000 op_name=tsdb_open index_version=inmem path=/var/lib/influxdb/data/openhab_db/autog
Mar 18 18:18:40 openhabian influxd[3432]: ts=2021-03-18T17:18:40.674055Z lvl=info msg="Open store (end)" log_id=0SyaOJ1W000 service=store trace_id=0SyaOJV0000 op_name=tsdb_open op_event=end op_elapsed=165.490ms
Mar 18 18:18:40 openhabian influxd[3432]: ts=2021-03-18T17:18:40.678419Z lvl=info msg="Opened service" log_id=0SyaOJ1W000 service=subscriber
Mar 18 18:18:40 openhabian influxd[3432]: ts=2021-03-18T17:18:40.678532Z lvl=info msg="Starting monitor service" log_id=0SyaOJ1W000 service=monitor
Mar 18 18:18:40 openhabian influxd[3432]: ts=2021-03-18T17:18:40.678584Z lvl=info msg="Registered diagnostics client" log_id=0SyaOJ1W000 service=monitor name=build
Mar 18 18:18:40 openhabian influxd[3432]: ts=2021-03-18T17:18:40.678631Z lvl=info msg="Registered diagnostics client" log_id=0SyaOJ1W000 service=monitor name=runtime
Mar 18 18:18:40 openhabian influxd[3432]: ts=2021-03-18T17:18:40.678669Z lvl=info msg="Registered diagnostics client" log_id=0SyaOJ1W000 service=monitor name=network
Mar 18 18:18:40 openhabian influxd[3432]: ts=2021-03-18T17:18:40.678782Z lvl=info msg="Registered diagnostics client" log_id=0SyaOJ1W000 service=monitor name=system
Mar 18 18:18:40 openhabian influxd[3432]: ts=2021-03-18T17:18:40.678983Z lvl=info msg="Starting precreation service" log_id=0SyaOJ1W000 service=shard-precreation check_interval=10m advance_period=30m
Mar 18 18:18:40 openhabian influxd[3432]: ts=2021-03-18T17:18:40.679044Z lvl=info msg="Starting snapshot service" log_id=0SyaOJ1W000 service=snapshot
Mar 18 18:18:40 openhabian influxd[3432]: ts=2021-03-18T17:18:40.679087Z lvl=info msg="Starting continuous query service" log_id=0SyaOJ1W000 service=continuous_querier
Mar 18 18:18:40 openhabian influxd[3432]: ts=2021-03-18T17:18:40.684194Z lvl=info msg="Starting HTTP service" log_id=0SyaOJ1W000 service=httpd authentication=true
Mar 18 18:18:40 openhabian influxd[3432]: ts=2021-03-18T17:18:40.684301Z lvl=info msg="opened HTTP access log" log_id=0SyaOJ1W000 service=httpd path=stderr
Mar 18 18:18:40 openhabian influxd[3432]: ts=2021-03-18T17:18:40.684341Z lvl=info msg="Auth is enabled but shared-secret is blank. BearerAuthentication is disabled." log_id=0SyaOJ1W000 service=httpd
Mar 18 18:18:40 openhabian influxd[3432]: ts=2021-03-18T17:18:40.690616Z lvl=info msg="Listening on HTTP" log_id=0SyaOJ1W000 service=httpd addr=127.0.0.1:8086 https=false
Mar 18 18:18:40 openhabian influxd[3432]: ts=2021-03-18T17:18:40.693091Z lvl=info msg="Starting retention policy enforcement service" log_id=0SyaOJ1W000 service=retention check_interval=30m
Mar 18 18:18:40 openhabian influxd[3432]: ts=2021-03-18T17:18:40.694233Z lvl=info msg="Listening for signals" log_id=0SyaOJ1W000
Mar 18 18:18:40 openhabian influxd[3432]: ts=2021-03-18T17:18:40.950160Z lvl=info msg="Sending usage statistics to usage.influxdata.com" log_id=0SyaOJ1W000
Mar 18 18:18:41 openhabian influxd[3432]: ts=2021-03-18T17:18:41.677937Z lvl=info msg="TSM compaction (start)" log_id=0SyaOJ1W000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0SyaOO3G000 op_name=tsm1_compact_group op_event
Mar 18 18:18:41 openhabian influxd[3432]: ts=2021-03-18T17:18:41.679506Z lvl=info msg="Beginning compaction" log_id=0SyaOJ1W000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0SyaOO3G000 op_name=tsm1_compact_group tsm1_files
Mar 18 18:18:41 openhabian influxd[3432]: ts=2021-03-18T17:18:41.679620Z lvl=info msg="Compacting file" log_id=0SyaOJ1W000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0SyaOO3G000 op_name=tsm1_compact_group tsm1_index=0 ts
Mar 18 18:18:41 openhabian influxd[3432]: ts=2021-03-18T17:18:41.679690Z lvl=info msg="Compacting file" log_id=0SyaOJ1W000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0SyaOO3G000 op_name=tsm1_compact_group tsm1_index=1 ts
Mar 18 18:18:41 openhabian influxd[3432]: ts=2021-03-18T17:18:41.724010Z lvl=info msg="Compacted file" log_id=0SyaOJ1W000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0SyaOO3G000 op_name=tsm1_compact_group tsm1_index=0 tsm
Mar 18 18:18:41 openhabian influxd[3432]: ts=2021-03-18T17:18:41.725025Z lvl=info msg="Finished compacting files" log_id=0SyaOJ1W000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0SyaOO3G000 op_name=tsm1_compact_group tsm1_
Mar 18 18:18:41 openhabian influxd[3432]: ts=2021-03-18T17:18:41.725147Z lvl=info msg="TSM compaction (end)" log_id=0SyaOJ1W000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0SyaOO3G000 op_name=tsm1_compact_group op_event=e
Mar 18 18:18:46 openhabian influxd[3432]: [httpd] 127.0.0.1 - openhab [18/Mar/2021:18:18:46 +0100] "POST /write?db=openhab_db&rp=autogen&precision=n&consistency=one HTTP/1.1" 204 0 "-" "okhttp/3.14.4" ff69694f-880d-11eb-8001-b827eb94ac63
Mar 18 18:18:56 openhabian influxd[3432]: [httpd] 127.0.0.1 - openhab [18/Mar/2021:18:18:56 +0100] "POST /write?db=openhab_db&rp=autogen&precision=n&consistency=one HTTP/1.1" 204 0 "-" "okhttp/3.14.4" 05500941-880e-11eb-8002-b827eb94ac63

Wolfgang_S · March 18, 2021, 6:36pm

what happened between these two logging lines ?

momo90:

Mar 16 21:18:37 openhabian influxd[547]: ts=2021-03-16T20:18:37.134310Z lvl=info msg="Sending usage statistics to usage.influxdata.com" log_id=0SwAtLw0000
Mar 18 18:12:23 openhabian systemd[1]: influxdb.service: Main process exited, code=killed, status=13/PIPE

my expectation would be that influxdb was running as no exit status is mentioned but on the otherhand also no access from openhab is mentioned as it is the case in the other logging block you posted.
Was the host running in between these two timestamps ?

momo90 · March 18, 2021, 7:14pm

The host was turned off between 16.03.2021 21:18 and 18.03.2021 18:12, because this is my oh3 test pi and i wasnt at home

Influx doesnt work until i start it manually. The log of oh3 also sais that data is lost until i start influx manually. So i dont think its running until starting it via systemctl

Sorry for typos. Used my mobile…

Wolfgang_S · March 19, 2021, 4:14am

I am wondering why the influxdb shutdown from turning off then is not shown in the log.
It was a full shutdown ?
Do you use ZRAM ?

momo90 · March 19, 2021, 5:43am

I do not use zram knowingly. Unless it is enabled by openhabian by default, I do not use it.

There is a topic somewhere where similar problems with influxdb and zram are reported. But there is a different error message in the logs, so I assumed a different error.

It was a “powercord pull shutdown”
But it also occurs after a sudo reboot

Wolfgang_S · March 19, 2021, 6:47pm

pull powercord to shutdown has not to be done as this could end up with a damaged filesystem.
First do shutdown then pull the powercord.

My suggestions would be:

check if you use ZRAM
reinstall influxdb / grafan to check if this fixes the problem

momo90 · March 22, 2021, 7:29am

As far as I know, zram is activated by default in openhabian.

I have reinstalled influxdb and grafana. The problem persists. I looked at the logs when booting and starting openhab. I think influx is started at boot. But when openhab loads, influx exits (I think when the log says the items are loaded).

rdiem · March 25, 2021, 12:17am

Same for me. I’m running on a RP4 4GB with zram enabled. Tried to setup influx as default persistence provider. I used a fresh installation from openhabian 1.63 and also 1.64. Everytime the Pi reboots influx and grafana are started and as soon as openhab starts both are killed. After restarting them with systemctl they are working. Additionally I had some system downs after several days of running. But I dont know if this is related to that issue.

bastler · March 25, 2021, 9:56am

i had the same problem when i tried to install oh3 in my rpi4, 4gb.

don´t know it is really the reason but i did a new install from scratch with zram disabled (in openhabian.conf file) and now it works for me.

you can check if zram is enabled with

sudo systemctl status zram-config

perhaps you may try to disable it in openhabian-config to see what happens

Wolfgang_S · March 25, 2021, 6:15pm

this also was done in other cases.

momo90 · March 26, 2021, 6:19pm

This solved my problems!! Thanks

system · May 7, 2021, 10:19am

This topic was automatically closed 41 days after the last reply. New replies are no longer allowed.