Hi,
i’m on latest 3.02 release and generally persistence works fine with influx 1.86. However, after adding an existing item to the persistence file i now receive a bunch of error messages without a reason. In general, no clue what could be the problem mentioning line 1 that does not even hold complex configuration.
Tried to reboot already, but same issue again…maybe i’m blind and you see something. also removed this simple Wimberg_TempTop1011 item…error keeps coming, so i do not believe its really a “the new” item issue…
Here is the persistence file:
Strategies {
everyMinute : "0 * * * * ?"
}
Items {
RH_Basement,LRMotionSensor_Temperature,PufferState,RestO2state,EGthermo,DGthermo : strategy = everyMinute
Hofer_Temps*,PowerMap*,EGvlauf,DGvlauf,Pool_Power,EVchargePower : strategy = everyMinute
LivingRoom_Power,PowerTotal,VeACkWhFor,VeACkWhRev,EnergyImpDaily,EnergyExpDaily,NG4EnergyExp,NG4EnergyExpDaily,PVisland_Power,PvXL_Power,Devolo3_Power,AirCon_Power,AirDryer_Power,TV_Power,PVislandVolt : strategy = everyMinute
DBtemp,YRtemp,NG4Top1temp,NG4Top1BathTemp,BathESPtemp,BaseESPtemp,AtticTemp,BaseESPhum,Base2ESPhum,Base2ESPtemp,TuyaSensor01_temp : strategy = everyMinute
PVng5sum,PvMicro_Power,NG4power,FibGarage_Power,BathESPvcc,SmartDisplay01vcc,SmartDisplay02vcc,AtticVcc,NG4Top1vcc,DBvcc,YRvcc,CollectorTemp : strategy = everyMinute
NG5_JeelinkOutside_Temperature,NG5_JeelinkOutsideTX22_Rain,NG5_JeelinkFridge_Temperature,NG5_JeelinkLivingRoom_Temperature,NG5_JeelinkOutsideTX22_Temperature,NG5_JeelinkOutside_Humidity,NG5_JeelinkTX25_TempEXT,NG5_JeelinkOutside$
Wimberg_TempTop9,Wimberg_TempTop1011, EPsolar_PVpower,EPsolar_CASEtemp,EPsolar_BATvolt,Rain_1h : strategy = everyMinute
BigSmartEPD1vcc,BigSmartEPD2vcc,BigSmartEPD3vcc,BigSmartEPD4vcc,BigSmartEPD5vcc : strategy = everyMinute
VeBatSoc,VeBatTemp,VeBatPower,VeMP2Temp : strategy = everyMinute
}
and here the error log that shows up as soon as i save/exit the editor @closing peresistence file…
2021-09-16 00:05:27.571 [INFO ] [el.core.internal.ModelRepositoryImpl] - Loading model 'influxdb.persist'
2021-09-16 00:05:28.695 [ERROR] [nal.common.AbstractInvocationHandler] - An error occurred while calling method 'QueryablePersistenceService.query()' on 'org.openhab.persistence.influxdb.InfluxDBPersistenceService@1b0901f': error parsing query: found ALL, expected identifier at line 1, char 48
org.influxdb.InfluxDBException: error parsing query: found ALL, expected identifier at line 1, char 48
at org.influxdb.InfluxDBException.buildExceptionFromErrorMessage(InfluxDBException.java:161) ~[?:?]
at org.influxdb.InfluxDBException.buildExceptionForErrorState(InfluxDBException.java:173) ~[?:?]
at org.influxdb.impl.InfluxDBImpl.execute(InfluxDBImpl.java:827) ~[?:?]
at org.influxdb.impl.InfluxDBImpl.executeQuery(InfluxDBImpl.java:814) ~[?:?]
at org.influxdb.impl.InfluxDBImpl.query(InfluxDBImpl.java:714) ~[?:?]
at org.openhab.persistence.influxdb.internal.influx1.InfluxDB1RepositoryImpl.query(InfluxDB1RepositoryImpl.java:155) ~[?:?]
at org.openhab.persistence.influxdb.InfluxDBPersistenceService.query(InfluxDBPersistenceService.java:231) ~[?:?]
at jdk.internal.reflect.GeneratedMethodAccessor177.invoke(Unknown Source) ~[?:?]
at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]
at org.openhab.core.internal.common.AbstractInvocationHandler.invokeDirect(AbstractInvocationHandler.java:154) [bundleFile:?]
at org.openhab.core.internal.common.Invocation.call(Invocation.java:52) [bundleFile:?]
at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]
at java.lang.Thread.run(Thread.java:829) [?:?]
2021-09-16 00:05:28.714 [ERROR] [ence.internal.PersistenceManagerImpl] - Exception occurred while querying persistence service 'influxdb': error parsing query: found ALL, expected identifier at line 1, char 48
org.influxdb.InfluxDBException: error parsing query: found ALL, expected identifier at line 1, char 48
at org.influxdb.InfluxDBException.buildExceptionFromErrorMessage(InfluxDBException.java:161) ~[?:?]
at org.influxdb.InfluxDBException.buildExceptionForErrorState(InfluxDBException.java:173) ~[?:?]
at org.influxdb.impl.InfluxDBImpl.execute(InfluxDBImpl.java:827) ~[?:?]
at org.influxdb.impl.InfluxDBImpl.executeQuery(InfluxDBImpl.java:814) ~[?:?]
at org.influxdb.impl.InfluxDBImpl.query(InfluxDBImpl.java:714) ~[?:?]
at org.openhab.persistence.influxdb.internal.influx1.InfluxDB1RepositoryImpl.query(InfluxDB1RepositoryImpl.java:155) ~[?:?]
at org.openhab.persistence.influxdb.InfluxDBPersistenceService.query(InfluxDBPersistenceService.java:231) ~[?:?]
at jdk.internal.reflect.GeneratedMethodAccessor177.invoke(Unknown Source) ~[?:?]
at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]
at org.openhab.core.internal.common.AbstractInvocationHandler.invokeDirect(AbstractInvocationHandler.java:154) [bundleFile:?]
at org.openhab.core.internal.common.Invocation.call(Invocation.java:52) [bundleFile:?]
at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]
at java.lang.Thread.run(Thread.java:829) [?:?]