Inconsistency between grafana database and influxdatabase

Hey all!

Since some days, I see an inconsistency between the data i can select in grafana and the data stored in my influx database. In grafana, i can see only data until the letter L, all datapoints higher than L are not shown/ listed. Can someone explain this or give me a hint how to solve this?

See a section of my influxdb series:

LUMILumiSensor_switchAq2_Switch
LaCrosseTemperatureSensorBadezimmer_Luftfeuchtigkeit
LaCrosseTemperatureSensorBadezimmer_Temperatur
LaCrosseTemperatureSensorKHlschrank_Luftfeuchtigkeit
LaCrosseTemperatureSensorKHlschrank_Temperatur
LaCrosseTemperatureSensorKueche_Luftfeuchtigkeit
LaCrosseTemperatureSensorKueche_Temperatur
LaCrosseTemperatureSensorSchlafzimmer_Luftfeuchtigkeit
LaCrosseTemperatureSensorSchlafzimmer_Temperatur
LaCrosseTemperatureSensorWohnzimmer_Luftfeuchtigkeit
LaCrosseTemperatureSensorWohnzimmer_Temperatur
LampeBadezimmer_Color
LampeFlur_ColorTemperature
LampeFlur_Dimmer
LampeFlur_Farbtemperatur
LampeFlur_FarbtemperaturNeu
LampeFlur_Helligkeit
LampeFlur_HelligkeitNeu
LampeHerd_Dimmer
LampeHerd_Helligkeit
LampeHerd_HelligkeitNeu
LampeSchlafzimmer1_Dimmer
LampeSchlafzimmer2_Dimmer
LampeSchlafzimmer3_Dimmer
LampeTisch_Dimmer

And here a screenshot what is available in Grafana:

any hints for this issue?

InfluxDB has a maximum amount of rows it can return, check the configuration file for max-row-limit=10000
Set it to a higher number or 0 for unlimited.

thanks for the hint. unfortunately, this change did not the trick.

I changed the following file: /etc/influxdb/influxdb.conf
and set the setting to

#The default chunk size for result sets that should be chunked.
max-row-limit = 0

Afterwards, i restarted my openhab system. but nothing changed…?!

There is only a box with suggestions, which have limits for the displayed items. Doesn’t make sense to list all items there. It can be slow and it will be a problem to show many items in the UI. You need to update Grafana source code and increase that limit if you want to change that.

many thanks for these tipps.

Please give me some more hints, which setting/ limit do i have to change to adapt this behaviour?