Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[dbquery] Thing status unknown since openhab 4.2 #17064

Closed
rpsmonkey opened this issue Jul 15, 2024 · 13 comments · Fixed by #17159
Closed

[dbquery] Thing status unknown since openhab 4.2 #17064

rpsmonkey opened this issue Jul 15, 2024 · 13 comments · Fixed by #17159
Labels
bug An unexpected problem or unintended behavior of an add-on

Comments

@rpsmonkey
Copy link

rpsmonkey commented Jul 15, 2024 •
edited by lsiepel
Loading

Hi all,

it's about add-on dbquery.

The status for the Bridge-Thing stays at "unknown" and queries are not working anymore.
The dbquery thing query says, that the belonging bridge is offline.

Problem exists since update to openhab version 4.2.0.
openhab version: 4.2.0
dbquery addon version: 4.2.0

I tried to reinstall add-on, delete and add again the Bridge Thing and deleted openhab cache with openhab-cli clean-cache.

On influxdb site nothing was changed (like updates, config, user, password, tokens, etc)

Kind Regards
Robert

Here some lines from openhab.log:

2024-07-15 09:42:16.827 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (327)[org.openhab.binding.dbquery.action.DBQueryActions(447)] : ServiceFactory.ungetService()
2024-07-15 09:42:16.828 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (327)[org.openhab.binding.dbquery.action.DBQueryActions(447)] : DependencyManager: osgi.ds.satisfying.condition close component unbinding from org.apache.felix.scr.impl.manager.ComponentContextImpl@43291c33 at tracking count 1 refpairs: [[RefPair: ref: [{org.osgi.service.condition.Condition}={service.id=6, service.bundleid=0, service.scope=singleton, service.pid=0.org.osgi.service.condition.ConditionImpl, osgi.condition.id=true}] service: [null]]]
2024-07-15 09:42:17.439 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (327)[org.openhab.binding.dbquery.action.DBQueryActions(447)] : ServiceFactory.getService()
2024-07-15 09:42:17.441 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (327)[org.openhab.binding.dbquery.action.DBQueryActions(447)] : This thread collected dependencies
2024-07-15 09:42:17.442 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (327)[org.openhab.binding.dbquery.action.DBQueryActions(447)] : getService (ServiceFactory) dependencies collected.
2024-07-15 09:42:17.442 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (327)[org.openhab.binding.dbquery.action.DBQueryActions(447)] : Querying state active
2024-07-15 09:42:17.443 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (327)[org.openhab.binding.dbquery.action.DBQueryActions(447)] : For dependency osgi.ds.satisfying.condition, optional: false; to bind: [[RefPair: ref: [{org.osgi.service.condition.Condition}={service.id=6, service.bundleid=0, service.scope=singleton, service.pid=0.org.osgi.service.condition.ConditionImpl, osgi.condition.id=true}] service: [null]]]
2024-07-15 09:42:17.443 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (327)[org.openhab.binding.dbquery.action.DBQueryActions(447)] : Changed state from active to active```
@rpsmonkey rpsmonkey added the bug An unexpected problem or unintended behavior of an add-on label Jul 15, 2024
@lsiepel
Copy link
Contributor

lsiepel commented Jul 21, 2024 •
edited
Loading

What was the last known version for you that seemed to work?

From 4.1.0 to 4.2.0 there is only one PR: #16458. That PR bumped two dependency's:
okhttp3 3.14.4 => 4.12.0
okio3.9.0 => 1.17.3

Can you provide a debug log when you enable enagble the bridge and or thing? Can you share some configuration?

@curro81
Copy link

curro81 commented Jul 21, 2024

Hi, i have also the same Problem.
I upgraded vom 4.1.3 to 4.2.0

Here is my Bridge Code

UID: dbquery:influxdb2:XXXXXX
label: InfluxDB2 Bridge Growatt
thingTypeUID: dbquery:influxdb2
configuration:
  bucket: Growatt
  user: home
  url: http://10.1.1.5:8087
  organization: openHAB
  token: XXXXXXXXXXXXXX

When i enable the bridge, i see this log.
Except for the 1st part the log repeats itself.


2024-07-21 21:32:16.410 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (296)[org.openhab.binding.dbquery.action.DBQueryActions(349)] : ServiceFactory.getService()
2024-07-21 21:32:16.410 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (296)[org.openhab.binding.dbquery.action.DBQueryActions(349)] : This thread collected dependencies
2024-07-21 21:32:16.410 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (296)[org.openhab.binding.dbquery.action.DBQueryActions(349)] : getService (ServiceFactory) dependencies collected.
2024-07-21 21:32:16.410 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (296)[org.openhab.binding.dbquery.action.DBQueryActions(349)] : Querying state active
2024-07-21 21:32:16.410 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (296)[org.openhab.binding.dbquery.action.DBQueryActions(349)] : For dependency osgi.ds.satisfying.condition, optional: false; to bind: [[RefPair: ref: [{org.osgi.service.condition.Condition}={service.id=6, service.bundleid=0, service.scope=singleton, service.pid=0.org.osgi.service.condition.ConditionImpl, osgi.condition.id=true}] service: [null]]]
2024-07-21 21:32:16.410 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (296)[org.openhab.binding.dbquery.action.DBQueryActions(349)] : Changed state from active to active
2024-07-21 21:32:16.413 [DEBUG] [query.internal.DatabaseBridgeHandler] - connectDatabase Influx2Database{config=InfluxDB2BridgeConfiguration[url='http://10.1.1.5:8087', user='home', token='****************************************************************************************', organization='openHAB', bucket='Growatt']}
2024-07-21 21:32:16.414 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (296)[org.openhab.binding.dbquery.action.DBQueryActions(349)] : ServiceFactory.getService()
2024-07-21 21:32:16.415 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (296)[org.openhab.binding.dbquery.action.DBQueryActions(349)] : This thread collected dependencies
2024-07-21 21:32:16.415 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (296)[org.openhab.binding.dbquery.action.DBQueryActions(349)] : getService (ServiceFactory) dependencies collected.
2024-07-21 21:32:16.415 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (296)[org.openhab.binding.dbquery.action.DBQueryActions(349)] : Querying state active
2024-07-21 21:32:16.415 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (296)[org.openhab.binding.dbquery.action.DBQueryActions(349)] : For dependency osgi.ds.satisfying.condition, optional: false; to bind: [[RefPair: ref: [{org.osgi.service.condition.Condition}={service.id=6, service.bundleid=0, service.scope=singleton, service.pid=0.org.osgi.service.condition.ConditionImpl, osgi.condition.id=true}] service: [null]]]
2024-07-21 21:32:16.415 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (296)[org.openhab.binding.dbquery.action.DBQueryActions(349)] : Changed state from active to active
2024-07-21 21:32:16.415 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (296)[org.openhab.binding.dbquery.action.DBQueryActions(349)] : ServiceFactory.getService()
2024-07-21 21:32:16.415 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (296)[org.openhab.binding.dbquery.action.DBQueryActions(349)] : This thread collected dependencies
2024-07-21 21:32:16.415 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (296)[org.openhab.binding.dbquery.action.DBQueryActions(349)] : getService (ServiceFactory) dependencies collected.
2024-07-21 21:32:16.416 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (296)[org.openhab.binding.dbquery.action.DBQueryActions(349)] : Querying state active
2024-07-21 21:32:16.416 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (296)[org.openhab.binding.dbquery.action.DBQueryActions(349)] : For dependency osgi.ds.satisfying.condition, optional: false; to bind: [[RefPair: ref: [{org.osgi.service.condition.Condition}={service.id=6, service.bundleid=0, service.scope=singleton, service.pid=0.org.osgi.service.condition.ConditionImpl, osgi.condition.id=true}] service: [null]]]
2024-07-21 21:32:16.416 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (296)[org.openhab.binding.dbquery.action.DBQueryActions(349)] : Changed state from active to active
2024-07-21 21:32:16.416 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (296)[org.openhab.binding.dbquery.action.DBQueryActions(349)] : ServiceFactory.getService()
2024-07-21 21:32:16.416 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (296)[org.openhab.binding.dbquery.action.DBQueryActions(349)] : This thread collected dependencies
2024-07-21 21:32:16.416 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (296)[org.openhab.binding.dbquery.action.DBQueryActions(349)] : getService (ServiceFactory) dependencies collected.
2024-07-21 21:32:16.416 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (296)[org.openhab.binding.dbquery.action.DBQueryActions(349)] : Querying state active
2024-07-21 21:32:16.416 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (296)[org.openhab.binding.dbquery.action.DBQueryActions(349)] : For dependency osgi.ds.satisfying.condition, optional: false; to bind: [[RefPair: ref: [{org.osgi.service.condition.Condition}={service.id=6, service.bundleid=0, service.scope=singleton, service.pid=0.org.osgi.service.condition.ConditionImpl, osgi.condition.id=true}] service: [null]]]

The influxdb2 is working well. All values are saved as expected.

if you need more let me know.
THX for your help.

@lsiepel
Copy link
Contributor

lsiepel commented Jul 21, 2024 •
edited
Loading

Gentle ping @Skinah do you have any clue why this is not working? We might have to revert changes for dbquery.

@rpsmonkey
Copy link
Author

rpsmonkey commented Jul 22, 2024 •
edited
Loading

Last known version for me was 4.1.3.

This my debug log when enabling dbquery Thing.

2024-07-22 10:50:08.188 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (327)[org.openhab.binding.dbquery.action.DBQueryActions(447)] : This thread collected dependencies
2024-07-22 10:50:08.188 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (327)[org.openhab.binding.dbquery.action.DBQueryActions(447)] : getService (ServiceFactory) dependencies collected.
2024-07-22 10:50:08.188 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (327)[org.openhab.binding.dbquery.action.DBQueryActions(447)] : Querying state satisfied
2024-07-22 10:50:08.189 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (327)[org.openhab.binding.dbquery.action.DBQueryActions(447)] : For dependency osgi.ds.satisfying.condition, optional: false; to bind: [[RefPair: ref: [{org.osgi.service.condition.Condition}={service.id=6, service.bundleid=0, service.scope=singleton, service.pid=0.org.osgi.service.condition.ConditionImpl, osgi.condition.id=true}] service: [null]]]
2024-07-22 10:50:08.189 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (327)[org.openhab.binding.dbquery.action.DBQueryActions(447)] : Changed state from satisfied to active
2024-07-22 10:50:08.192 [DEBUG] [query.internal.DatabaseBridgeHandler] - connectDatabase Influx2Database{config=InfluxDB2BridgeConfiguration[url='http://192.168.1.23:8086', user='admin', token='****************************************************************************************', organization='daheim', bucket='pvforecast']}
2024-07-22 10:50:08.193 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (327)[org.openhab.binding.dbquery.action.DBQueryActions(447)] : ServiceFactory.getService()
2024-07-22 10:50:08.194 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (327)[org.openhab.binding.dbquery.action.DBQueryActions(447)] : This thread collected dependencies
2024-07-22 10:50:08.194 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (327)[org.openhab.binding.dbquery.action.DBQueryActions(447)] : getService (ServiceFactory) dependencies collected.
2024-07-22 10:50:08.195 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (327)[org.openhab.binding.dbquery.action.DBQueryActions(447)] : Querying state active
2024-07-22 10:50:08.195 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (327)[org.openhab.binding.dbquery.action.DBQueryActions(447)] : For dependency osgi.ds.satisfying.condition, optional: false; to bind: [[RefPair: ref: [{org.osgi.service.condition.Condition}={service.id=6, service.bundleid=0, service.scope=singleton, service.pid=0.org.osgi.service.condition.ConditionImpl, osgi.condition.id=true}] service: [null]]]
2024-07-22 10:50:08.196 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (327)[org.openhab.binding.dbquery.action.DBQueryActions(447)] : Changed state from active to active
2024-07-22 10:50:08.196 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (327)[org.openhab.binding.dbquery.action.DBQueryActions(447)] : ServiceFactory.getService()
2024-07-22 10:50:08.196 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (327)[org.openhab.binding.dbquery.action.DBQueryActions(447)] : This thread collected dependencies
2024-07-22 10:50:08.197 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (327)[org.openhab.binding.dbquery.action.DBQueryActions(447)] : getService (ServiceFactory) dependencies collected.
2024-07-22 10:50:08.197 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (327)[org.openhab.binding.dbquery.action.DBQueryActions(447)] : Querying state active
2024-07-22 10:50:08.198 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (327)[org.openhab.binding.dbquery.action.DBQueryActions(447)] : For dependency osgi.ds.satisfying.condition, optional: false; to bind: [[RefPair: ref: [{org.osgi.service.condition.Condition}={service.id=6, service.bundleid=0, service.scope=singleton, service.pid=0.org.osgi.service.condition.ConditionImpl, osgi.condition.id=true}] service: [null]]]
2024-07-22 10:50:08.198 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (327)[org.openhab.binding.dbquery.action.DBQueryActions(447)] : Changed state from active to active
2024-07-22 10:50:08.198 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (327)[org.openhab.binding.dbquery.action.DBQueryActions(447)] : ServiceFactory.getService()
2024-07-22 10:50:08.199 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (327)[org.openhab.binding.dbquery.action.DBQueryActions(447)] : This thread collected dependencies
2024-07-22 10:50:08.200 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (327)[org.openhab.binding.dbquery.action.DBQueryActions(447)] : getService (ServiceFactory) dependencies collected.
2024-07-22 10:50:08.200 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (327)[org.openhab.binding.dbquery.action.DBQueryActions(447)] : Querying state active
2024-07-22 10:50:08.200 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (327)[org.openhab.binding.dbquery.action.DBQueryActions(447)] : For dependency osgi.ds.satisfying.condition, optional: false; to bind: [[RefPair: ref: [{org.osgi.service.condition.Condition}={service.id=6, service.bundleid=0, service.scope=singleton, service.pid=0.org.osgi.service.condition.ConditionImpl, osgi.condition.id=true}] service: [null]]]
2024-07-22 10:50:08.200 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (327)[org.openhab.binding.dbquery.action.DBQueryActions(447)] : Changed state from active to active

My dbquery bridge thing config:

label: InfluxDB2 Bridge Local
thingTypeUID: dbquery:influxdb2
configuration:
  bucket: pvforecast
  user: admin
  url: http://192.168.1.23:8086
  organization: daheim
  token: ***

@rpsmonkey
Copy link
Author

Did some more testing.

Fresh install of openhab 4.2.0 with only dbquery as add-on installed.
Enabling Bridge Thing debug log:

2024-07-22 11:18:37.432 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (267)[org.openhab.binding.dbquery.action.DBQueryActions(338)] : ServiceFactory.getService()
2024-07-22 11:18:37.434 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (267)[org.openhab.binding.dbquery.action.DBQueryActions(338)] : This thread collected dependencies
2024-07-22 11:18:37.437 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (267)[org.openhab.binding.dbquery.action.DBQueryActions(338)] : getService (ServiceFactory) dependencies collected.
2024-07-22 11:18:37.438 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (267)[org.openhab.binding.dbquery.action.DBQueryActions(338)] : Querying state satisfied
2024-07-22 11:18:37.440 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (267)[org.openhab.binding.dbquery.action.DBQueryActions(338)] : For dependency osgi.ds.satisfying.condition, optional: false; to bind: [[RefPair: ref: [{org.osgi.service.condition.Condition}={service.id=6, service.bundleid=0, service.scope=singleton, service.pid=0.org.osgi.service.condition.ConditionImpl, osgi.condition.id=true}] service: [null]]]
2024-07-22 11:18:37.441 [DEBUG] [inding.dbquery.action.DBQueryActions] - bundle org.openhab.binding.dbquery:4.2.0 (267)[org.openhab.binding.dbquery.action.DBQueryActions(338)] : Changed state from satisfied to active
2024-07-22 11:18:37.456 [DEBUG] [query.internal.DatabaseBridgeHandler] - connectDatabase Influx2Database{config=InfluxDB2BridgeConfiguration[url='http://192.168.1.23:8086', user='admin', token='****************************************************************************************', organization='daheim', bucket='pvforecast']}

Downgraded openhab to version 4.1.3
Enabling Bridge Thing debug log:

2024-07-22 11:25:50.568 [DEBUG] [query.internal.DatabaseBridgeHandler] - connectDatabase Influx2Database{config=InfluxDB2BridgeConfiguration[url='http://192.168.1.23:8086', user='admin', token='****************************************************************************************', organization='daheim', bucket='pvforecast']}
2024-07-22 11:25:50.582 [DEBUG] [mpl.influx2.InfluxDBClientFacadeImpl] - database status is OK
2024-07-22 11:25:50.586 [DEBUG] [mpl.influx2.InfluxDBClientFacadeImpl] - Successfully connected to InfluxDB. Instance ready=class Ready {
    status: ready
    started: 2024-06-14T17:21:56.968517879+02:00
    up: 906h3m53.615339899s
}

So it definitely works with openhab version 4.1.3, but not with 4.2.0.

And it is just a felling from my side, but I don't know if it is really caused by dbquery directly or maybe there was a change at a different code and dbquery is no longer compatible to it. E.g. the log output seems to have a different structure --> I searched for thing changes in release notes and found openhab/openhab-core#3957
I'm not an expert, but maybe changes there breaks something in (some) add ons.

@Skinah
Copy link
Contributor

Skinah commented Jul 23, 2024

@lsiepel I have no idea why. I would recommend people install the InfluxDB binding even if they do not want/need it as it may install some missing dependencies when you install that binding. I had a huge pain getting that influxdb binding to work as it also uses the okio library. influxdb binding was building fine and then having issues during runtime, so it may be the same cause. If installing influxDB solves the issue for dbquery, then the fix should be easier to track down, so if a user can try and report back that would be great.

If there is an issue, then I would try dropping only okio back to 3.6 or 3.8 for just the one dbquery binding and leaving everything else as merged.
https://square.github.io/okio/changelog/

In the meantime I am currently installing a test server onto a pi3 to run a test to see if I can reproduce it here.

@rpsmonkey
Copy link
Author

Hi @Skinah, thanks a lot for debugging.

I have installed InfluxDB Persistence add-on and that is working fine, but still the same issue with dbquery. (for openhab version 4.2.0)

@Skinah
Copy link
Contributor

Skinah commented Jul 27, 2024

Can someone try this new jar please? Uninstall the merged copy first, then UNZIP this into your addons folder. A number of dependencies have changed in this build but its basically a copy of what fixed the influxdb bundle.

http://pcmus.com/openhab/org.openhab.binding.dbquery-4.3.0-SNAPSHOT.zip

@Skinah Skinah mentioned this issue Jul 27, 2024
Merged
@openhab-bot
Copy link
Collaborator

This issue has been mentioned on openHAB Community. There might be relevant details there:

https://community.openhab.org/t/openhab-4-2-release-discussion/157076/110

@lsiepel lsiepel linked a pull request Jul 27, 2024 that will close this issue
[dbquery] Fix dependency issues and bump to newer version libs #17159
Merged
@speham
Copy link

speham commented Jul 27, 2024

Can someone try this new jar please? Uninstall the merged copy first, then UNZIP this into your addons folder. A number of dependencies have changed in this build but its basically a copy of what fixed the influxdb bundle.

http://pcmus.com/openhab/org.openhab.binding.dbquery-4.3.0-SNAPSHOT.zip

Great thank you very much, you´re fix works.

@curro81
Copy link

curro81 commented Jul 27, 2024

Can someone try this new jar please? Uninstall the merged copy first, then UNZIP this into your addons folder. A number of dependencies have changed in this build but its basically a copy of what fixed the influxdb bundle.

http://pcmus.com/openhab/org.openhab.binding.dbquery-4.3.0-SNAPSHOT.zip

Works for me :-)
THX

@Skinah
Copy link
Contributor

Skinah commented Jul 28, 2024

Thanks for the testing and reporting back as openhabian only installs influx V1.8 and the binding needs v2 minimum, if what I read is correct. I could reproduce the issue, but can not test further without wasting a lot of time learning about influxDB2 and setting it up. Glad that it is fixed.

@rpsmonkey
Copy link
Author

Thanks a lot @Skinah! Also works for me.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug An unexpected problem or unintended behavior of an add-on
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

[dbquery] Fix dependency issues and bump to newer version libs Skinah/openhab-addons
6 participants
@openhab-bot @lsiepel @Skinah @speham @rpsmonkey @curro81