https://www.umh.app logo
Join Discord
Powered by
i cant get data out of my database
# umh-support
d
i cant get data out of my database
f
@diederik9434 Can you check how much space you have left on your disk ?
d
it took some time but it's in a good state again
still not able to query the database tho
j
what do you mean by not able to query?
d
data is not loading from grafana
f
Can you do a simple query: SELECT COUNT(1) FROM asset; Inside the explore function of grafana ?
d
this works
f
Can you open one of the queries and manually execute it, to check if grafana gives you any hints ?
d
but no data is getting saved i think; seems like it worked for a short time in between versions updating
f
Which version are you currently using ?
d
Management Companion 0.6.9 Kubernetes 1.29.5+k3s1 Node-RED 3.0.2 factoryinsight 0.26.0 HiveMQ 2024.1 Kafka-Postgresql-v2 0.26.0 OPC UA Simulator 0.1.0 MQTT simulator 1.0.0 Redis 7.2.4-debian-12-r9 Grafana 10.4.0 Redpanda 24.2.7 TimescaleDB pg13.8-ts2.8.0-p1 Ubuntu 24.04 (kernel: 6.8.0-48-generic)
if you want we can have a quick meeting on this
(everything is on the latest version)
except of the base OS (but i think this issue is not related)
f
d
@Ferdinand create index appeared :p
btw, i originally installed on Sunday, May 26, 2024 if you guys have a releaselog with dates somewhere we can know which version i was on originally
i started upgrading today from 0.5.34
f
Great, so it managed to create the 1st out of 3
Also once these 3 commands are completed, you should do the same for the tag_string table:
Copy code
CREATE INDEX IF NOT EXISTS idx_tag_string_asset_timestamp ON tag_string (asset_id, timestamp DESC);
                      CREATE INDEX IF NOT EXISTS idx_tag_string_name ON tag_string (name);
                      CREATE INDEX IF NOT EXISTS idx_tag_string_asset_name ON tag_string (asset_id, name);
d
2 of 3 :p
@Ferdinand
first 3 went ok, second 3 already exist
f
perfect
d
can we continue in the google meet? 🙂
ts_from_regex",path="root.pipeline.processors.7"} 826623 processor_sent{label="extract_hierarchy_from_topic",path="root.pipeline.processors.6"} 826623 processor_sent{label="filter_for_historian_topics",path="root.pipeline.processors.1"} 867488 processor_sent{label="flatten_payload_for_insertion",path="root.pipeline.processors.10"} 826623 processor_sent{label="get_asset_id",path="root.pipeline.processors.8"} 826623 processor_sent{label="reconstruct_full_topic_name",path="root.pipeline.processors.0"} 867488 processor_sent{label="unarchive_json_array",path="root.pipeline.processors.11"} 828614 processor_sent{label="validate_against_historian_schema",path="root.pipeline.processors.5"} 826623 processor_sent{label="validate_message_json",path="root.pipeline.processors.2"} 867488
message
Thanks for helping me out! Great support as always! 😄
@Ferdinand on the next update the helmchart will be changed and my pod memory limit will be reset right? (and the 100gh temp file limit can stay?)
f
yes
d
ok, thanks!
3 Views
PreviousNext
Powered by