Build #2032
I have a problem, I think in rest-api.
I am using Influxdb v1, item OnOff type.
I’m trying to display its state history on the timeline widget in the HabPanel. The state is always zero.
http://192.168.215.221:8080/rest/persistence/items/BlitzWOLF?serviceId=influxdb
result:
{"name":"BlitzWOLF","datapoints":"43","data":[{"time":1606638256335,"state":"OFF"},{"time":1606638459792,"state":"OFF"},{"time":1606638459792,"state":"OFF"},{"time":1606638588388,"state":"OFF"},{"time":1606638588388,"state":"OFF"},{"time":1606638748433,"state":"OFF"},{"time":1606638748433,"state":"OFF"},{"time":1606639034587,"state":"OFF"},{"time":1606639034587,"state":"OFF"},{"time":1606639081056,"state":"OFF"},{"time":1606639081056,"state":"OFF"},{"time":1606639121731,"state":"OFF"},{"time":1606639121731,"state":"OFF"},{"time":1606639132055,"state":"OFF"},{"time":1606639132055,"state":"OFF"},{"time":1606639144777,"state":"OFF"},{"time":1606639144777,"state":"OFF"},{"time":1606639176381,"state":"OFF"},{"time":1606639176381,"state":"OFF"},{"time":1606639259360,"state":"OFF"},{"time":1606639259360,"state":"OFF"},{"time":1606639293975,"state":"OFF"},{"time":1606639293975,"state":"OFF"},{"time":1606639312017,"state":"OFF"},{"time":1606639312017,"state":"OFF"},{"time":1606639373996,"state":"OFF"},{"time":1606639373996,"state":"OFF"},{"time":1606639381979,"state":"OFF"},{"time":1606639381979,"state":"OFF"},{"time":1606639440471,"state":"OFF"},{"time":1606639440471,"state":"OFF"},{"time":1606639457103,"state":"OFF"},{"time":1606639457103,"state":"OFF"},{"time":1606639515489,"state":"OFF"},{"time":1606639515489,"state":"OFF"},{"time":1606639534864,"state":"OFF"},{"time":1606639534864,"state":"OFF"},{"time":1606639538980,"state":"OFF"},{"time":1606639538980,"state":"OFF"},{"time":1606639806866,"state":"OFF"},{"time":1606639806866,"state":"OFF"},{"time":1606640170666,"state":"OFF"},{"time":1606640170666,"state":"OFF"}]}
tracert influx:
2020-11-29 16:59:34.418 [DEBUG] [.influxdb.InfluxDBPersistenceService] - Got a query for historic points!
2020-11-29 16:59:34.423 [TRACE] [.influxdb.InfluxDBPersistenceService] - Filter: itemname: BlitzWOLF, ordering: ASCENDING, state: null, operator: EQ, getBeginDate: 2020-11-28T16:59:34.418093+08:00[Asia/Irkutsk], getEndDate: 2020-11-29T16:59:34.418093+08:00[Asia/Irkutsk], getPageSize: 2147483647, getPageNumber: 0
2020-11-29 16:59:34.425 [TRACE] [.influxdb.InfluxDBPersistenceService] - Query SELECT value FROM autogen.BlitzWOLF WHERE time >= '2020-11-28T08:59:34.418093Z' AND time <= '2020-11-29T08:59:34.418093Z' ORDER BY time ASC;
2020-11-29 16:59:34.434 [TRACE] [rnal.influx1.InfluxDB1RepositoryImpl] - series Series [name=BlitzWOLF, tags=null, columns=[time, value], values=[[1.606638256335E12, 0.0], [1.606638459792E12, 1.0], [1.606638588388E12, 0.0], [1.606638748433E12, 1.0], [1.606639034587E12, 0.0], [1.606639081056E12, 1.0], [1.606639121731E12, 0.0], [1.606639132055E12, 1.0], [1.606639144777E12, 0.0], [1.606639176381E12, 1.0], [1.60663925936E12, 0.0], [1.606639293975E12, 1.0], [1.606639312017E12, 0.0], [1.606639373996E12, 1.0], [1.606639381979E12, 0.0], [1.606639440471E12, 1.0], [1.606639457103E12, 0.0], [1.606639515489E12, 1.0], [1.606639534864E12, 0.0], [1.60663953898E12, 1.0], [1.606639806866E12, 0.0], [1.606640170666E12, 1.0]]]
2020-11-29 16:59:34.436 [TRACE] [rnal.influx1.InfluxDB1RepositoryImpl] - columns [time, value]
2020-11-29 16:59:34.439 [TRACE] [rnal.influx1.InfluxDB1RepositoryImpl] - adding historic item BlitzWOLF: time 2020-11-29T08:24:16.335Z value 0.0
2020-11-29 16:59:34.441 [TRACE] [rnal.influx1.InfluxDB1RepositoryImpl] - adding historic item BlitzWOLF: time 2020-11-29T08:27:39.792Z value 1.0
2020-11-29 16:59:34.443 [TRACE] [rnal.influx1.InfluxDB1RepositoryImpl] - adding historic item BlitzWOLF: time 2020-11-29T08:29:48.388Z value 0.0
2020-11-29 16:59:34.445 [TRACE] [rnal.influx1.InfluxDB1RepositoryImpl] - adding historic item BlitzWOLF: time 2020-11-29T08:32:28.433Z value 1.0
2020-11-29 16:59:34.448 [TRACE] [rnal.influx1.InfluxDB1RepositoryImpl] - adding historic item BlitzWOLF: time 2020-11-29T08:37:14.587Z value 0.0
2020-11-29 16:59:34.450 [TRACE] [rnal.influx1.InfluxDB1RepositoryImpl] - adding historic item BlitzWOLF: time 2020-11-29T08:38:01.056Z value 1.0
2020-11-29 16:59:34.452 [TRACE] [rnal.influx1.InfluxDB1RepositoryImpl] - adding historic item BlitzWOLF: time 2020-11-29T08:38:41.731Z value 0.0
2020-11-29 16:59:34.454 [TRACE] [rnal.influx1.InfluxDB1RepositoryImpl] - adding historic item BlitzWOLF: time 2020-11-29T08:38:52.055Z value 1.0
2020-11-29 16:59:34.456 [TRACE] [rnal.influx1.InfluxDB1RepositoryImpl] - adding historic item BlitzWOLF: time 2020-11-29T08:39:04.777Z value 0.0
2020-11-29 16:59:34.458 [TRACE] [rnal.influx1.InfluxDB1RepositoryImpl] - adding historic item BlitzWOLF: time 2020-11-29T08:39:36.381Z value 1.0
2020-11-29 16:59:34.460 [TRACE] [rnal.influx1.InfluxDB1RepositoryImpl] - adding historic item BlitzWOLF: time 2020-11-29T08:40:59.360Z value 0.0
2020-11-29 16:59:34.462 [TRACE] [rnal.influx1.InfluxDB1RepositoryImpl] - adding historic item BlitzWOLF: time 2020-11-29T08:41:33.975Z value 1.0
2020-11-29 16:59:34.464 [TRACE] [rnal.influx1.InfluxDB1RepositoryImpl] - adding historic item BlitzWOLF: time 2020-11-29T08:41:52.017Z value 0.0
2020-11-29 16:59:34.466 [TRACE] [rnal.influx1.InfluxDB1RepositoryImpl] - adding historic item BlitzWOLF: time 2020-11-29T08:42:53.996Z value 1.0
2020-11-29 16:59:34.468 [TRACE] [rnal.influx1.InfluxDB1RepositoryImpl] - adding historic item BlitzWOLF: time 2020-11-29T08:43:01.979Z value 0.0
2020-11-29 16:59:34.470 [TRACE] [rnal.influx1.InfluxDB1RepositoryImpl] - adding historic item BlitzWOLF: time 2020-11-29T08:44:00.471Z value 1.0
2020-11-29 16:59:34.472 [TRACE] [rnal.influx1.InfluxDB1RepositoryImpl] - adding historic item BlitzWOLF: time 2020-11-29T08:44:17.103Z value 0.0
2020-11-29 16:59:34.475 [TRACE] [rnal.influx1.InfluxDB1RepositoryImpl] - adding historic item BlitzWOLF: time 2020-11-29T08:45:15.489Z value 1.0
2020-11-29 16:59:34.477 [TRACE] [rnal.influx1.InfluxDB1RepositoryImpl] - adding historic item BlitzWOLF: time 2020-11-29T08:45:34.864Z value 0.0
2020-11-29 16:59:34.479 [TRACE] [rnal.influx1.InfluxDB1RepositoryImpl] - adding historic item BlitzWOLF: time 2020-11-29T08:45:38.980Z value 1.0
2020-11-29 16:59:34.481 [TRACE] [rnal.influx1.InfluxDB1RepositoryImpl] - adding historic item BlitzWOLF: time 2020-11-29T08:50:06.866Z value 0.0
2020-11-29 16:59:34.483 [TRACE] [rnal.influx1.InfluxDB1RepositoryImpl] - adding historic item BlitzWOLF: time 2020-11-29T08:56:10.666Z value 1.0
Am I doing something wrong?
I just installed the first version of the database, first I experimented with the second version, there I also had two problems, which I wrote about here and here.
Thanks!