Influx persist issue

Setup, Configuration and Use Installation
1

I’m having an issue with getting influx to persist data, I have validated that the module is loading, I’ve validated permissions in influx and validated that I have connections to influx. I just upgraded to OpenHab2.5 and decided it was time to install influx

from openhab2.log
2020-02-13 18:54:18.131 [INFO ] [el.core.internal.ModelRepositoryImpl] - Loading model ‘influx.persist’

here’s my influxdb.cfg
# The database URL, e.g. http://127.0.0.1:8086 or https://127.0.0.1:8084 .
# Defaults to: http://127.0.0.1:8086
url=http://localhost:8086
# The name of the database user, e.g. openhab.
# Defaults to: openhab
# user=
user=openhab
# The password of the database user.
# password=
password=
# The name of the database, e.g. openhab.
# Defaults to: openhab
# db=
db=openhab_db
retentionPolicy=autogen

and here’s my influx.persist

Strategies {
    everyMinute : "0 * * * * ?"
    everyHour : "0 0 * * * ?"
    everyDay : "0 0 0 * * ?"
    every2Minutes : "0 */2 * ? * *"
}
Items {
    Group_AquaLink* : strategy = everyChange, everyHour, everyDay
    AquaLinkPoolTemp, AquaLinkAirTemp : strategy = everyChange, everyHour, everyDay
}

What I’m trying to capture are these events:
2020-02-13 18:58:12.067 [vent.ItemStateChangedEvent] - AquaLinkAirTemp changed from 85.0 °F to 84.0 °F
2020-02-13 18:59:13.062 [vent.ItemStateChangedEvent] - AquaLinkAirWater changed from 80.0 °F to 79.0 °F

Here’s my influx install:
Connected to http://localhost:8086 version 1.7.10
InfluxDB shell version: 1.7.10
> auth
username: openhab
password:
> use openhab_db
Using database openhab_db
> show series

2

This is all you pulled? You need to get a debug log.

3

Here are the debug logs from a restart grepping for influx:

2020-02-13 22:15:48.920 [DEBUG] [org.apache.felix.configadmin ] - Adding configuration org.openhab.influxdb
2020-02-13 22:16:00.828 [DEBUG] [org.apache.felix.configadmin ] - getConfiguration(pid=org.openhab.influxdb, location=null)
2020-02-13 22:16:00.831 [DEBUG] [org.apache.felix.configadmin ] - Found cached configuration org.openhab.influxdb bound to null
2020-02-13 22:16:03.591 [DEBUG] [org.osgi.framework.ServiceEvent ] - ServiceEvent REGISTERED - {org.openhab.core.karaf.internal.FeatureInstaller, org.osgi.service.cm.ConfigurationListener}={package=expert, service.id=222, service.bundleid=160, service.scope=bundle, binding=astro, ntp, iaqualink, dscalarm, nest, weatherunderground, lgwebos, zwave, unifi, persistence=mapdb, influxdb, transformation=map, misc=openhabcloud, component.name=org.openhab.addons, service.config.label=Add-on Management, component.id=104, ui=basic, paper, habmin, habpanel, remote=true, service.config.category=system, service.config.description.uri=system:addons, service.pid=org.openhab.addons}
2020-02-13 22:16:10.600 [DEBUG] [pse.xtext.util.OnChangeEvictingCache] - Clear 18 cache entries for resource tmp_influx.persist after 54 hits and 18 misses (quota: 75%)
2020-02-13 22:16:10.606 [INFO ] [el.core.internal.ModelRepositoryImpl] - Loading model ‘influx.persist’

4

Did configure debug logging for the persistence layer, the influxdb client and the items in question?
Because none of those is shown in what you captured.

5

That’s a problem. It needs to be influxdb.persist, not influx.persist.

6

that was a typo in my message… the file is named correctly.

7

also as I mentioned there is an open connections to influxdb:

$ netstat -an | grep 8086
tcp 0 0 127.0.0.1:8086 0.0.0.0:* LISTEN
tcp 0 0 127.0.0.1:8086 127.0.0.1:49736 ESTABLISHED
tcp 0 0 127.0.0.1:49736 127.0.0.1:8086 ESTABLISHED

8

What’s in /var/log/syslog? InfluxDB normally logs each access there. Any problems that you can see?

9

Feb 13 23:23:57 openHABianPine64 influxd[727]: [httpd] 127.0.0.1 - admin [13/Feb/2020:23:23:56 -0500] “POST /write?consistency=one&db=openhab_db&p=%5BREDACTED%5D&precision=n&rp=autogen&u=admin HTTP/1.1” 204 0 “-” “okhttp/2.4.0” d0ec4f38-4ee1-11ea-8075-76c975e7d02a 270161
Feb 13 23:25:49 openHABianPine64 influxd[727]: [httpd] 127.0.0.1 - admin [13/Feb/2020:23:25:49 -0500] “POST /write?consistency=one&db=openhab_db&p=%5BREDACTED%5D&precision=n&rp=autogen&u=admin HTTP/1.1” 204 0 “-” “okhttp/2.4.0” 1456a8b2-4ee2-11ea-8076-76c975e7d02a 46641
Feb 13 23:33:00 openHABianPine64 influxd[727]: [httpd] 127.0.0.1 - admin [13/Feb/2020:23:33:00 -0500] “POST /write?consistency=one&db=openhab_db&p=%5BREDACTED%5D&precision=n&rp=autogen&u=admin HTTP/1.1” 204 0 “-” “okhttp/2.4.0” 14e14e15-4ee3-11ea-8077-76c975e7d02a 16025
Feb 13 23:33:38 openHABianPine64 influxd[727]: [httpd] 127.0.0.1 - admin [13/Feb/2020:23:33:38 -0500] “POST /write?consistency=one&db=openhab_db&p=%5BREDACTED%5D&precision=n&rp=autogen&u=admin HTTP/1.1” 204 0 “-” “okhttp/2.4.0” 2b683e51-4ee3-11ea-8078-76c975e7d02a 6486
Feb 13 23:35:00 openHABianPine64 influxd[727]: ts=2020-02-14T04:35:00.718738Z lvl=info msg=“Retention policy deletion check (start)” log_id=0KxAuC2G000 service=retention trace_id=0KxVVZwW000 op_name=retention_delete_check op_event=start
Feb 13 23:35:00 openHABianPine64 influxd[727]: ts=2020-02-14T04:35:00.718975Z lvl=info msg=“Retention policy deletion check (end)” log_id=0KxAuC2G000 service=retention trace_id=0KxVVZwW000 op_name=retention_delete_check op_event=end op_elapsed=0.310ms
Feb 13 23:35:28 openHABianPine64 influxd[727]: [httpd] 127.0.0.1 - - [13/Feb/2020:23:35:28 -0500] “GET /ping HTTP/1.1” 204 0 “-” “okhttp/2.4.0” 6d000dee-4ee3-11ea-8079-76c975e7d02a 83
Feb 13 23:36:49 openHABianPine64 influxd[727]: [httpd] 127.0.0.1 - - [13/Feb/2020:23:36:49 -0500] “GET /ping HTTP/1.1” 204 0 “-” “okhttp/2.4.0” 9d571444-4ee3-11ea-807a-76c975e7d02a 74

10

Those writes look okay. You are getting 204 responses, so they seem to be accepted.

When you connect to the Influx command line, can you type “show measurements”. If you see your measurement, type “select * from name” where name is the name of your measurement.

11

I’m not sure what changed or what I just did but I’m persisting events.