- Platform information:
- Hardware: 4 CPU / 6 GB Memory
- OS: Debian 12 (Proxmox LXC)
- Java Runtime Environment:
openjdk version “17.0.13” 2024-10-15 LTS
OpenJDK Runtime Environment Zulu17.54+21-CA (build 17.0.13+11-LTS)
OpenJDK 64-Bit Server VM Zulu17.54+21-CA (build 17.0.13+11-LTS, mixed mode, sharing) - openHAB version: 4.3.1
- influxDB version: 2.7.11 (dedicated LXC on the same host)
Problem Description
Hello, I have a problem with a chart that calls a relatively large amount of data from the influxDB and causes the openHAB instance to hangs completely the first or at least second time the chart is called. And after about 4-5 minutes at max. memory utilization, the OH service restarts. The DB instance gets bored, only the OH instance escalates CPU and memory usage. I previously had org.openhab and org.openhab.persistence.influxdb on log: DEBUG, but unfortunately there are no errors or anything in the 24MB log.
- Can I somehow optimize the chart and still display the data for the entire year?
- Is there a different problem here?
- Or is there just too much data and I have to reduce the chart to 6 months or less?
Systeminfo Chart
Hardware - normal operations
Hardware - problem operations
Chart
config:
chartType: year
label: Mtl - Strom
order: "301"
sidebar: true
slots:
grid:
- component: oh-chart-grid
config: {}
legend:
- component: oh-chart-legend
config:
orient: vertical
right: "10"
top: "100"
type: scroll
series:
- component: oh-aggregate-series
config:
aggregationFunction: last
dimension1: month
gridIndex: 0
item: Oh_Item_Power_Home_Consumption_Monthly
name: Verbrauch
type: bar
xAxisIndex: 0
yAxisIndex: 0
- component: oh-aggregate-series
config:
aggregationFunction: last
dimension1: month
gridIndex: 0
item: Oh_Item_Power_Grid_Consumption_Monthly
name: Bezug
type: bar
xAxisIndex: 0
yAxisIndex: 0
- component: oh-aggregate-series
config:
aggregationFunction: last
dimension1: month
gridIndex: 0
item: Oh_Item_Power_Production_Monthly
name: Produktion
type: bar
xAxisIndex: 0
yAxisIndex: 0
- component: oh-aggregate-series
config:
aggregationFunction: last
dimension1: month
gridIndex: 0
item: Oh_Item_Power_OwnConsumption_Monthly
name: Eigenverbrauch
type: bar
xAxisIndex: 0
yAxisIndex: 0
- component: oh-aggregate-series
config:
aggregationFunction: last
dimension1: month
gridIndex: 0
item: Oh_Item_Power_Surplus_Monthly
name: Überschuss
type: bar
xAxisIndex: 0
yAxisIndex: 0
tooltip:
- component: oh-chart-tooltip
config:
confine: true
orient: vertical
xAxis:
- component: oh-category-axis
config:
categoryType: year
gridIndex: 0
monthFormat: short
weekdayFormat: short
yAxis:
- component: oh-value-axis
config:
gridIndex: 0
name: kWh