palengh
(Pål Engh)
September 7, 2019, 11:38am
1
I just simply cannot figure out what is wrong…
All of my nicely looking graphs are gone, or they are all flat…
I am using the Mini Graph Card
Is there a module missing in my installation?
Here is an example from one of the Lovelace cards
animate: true
color_thresholds:
- color: '#CCE5FF'
value: 0
- color: '#66B2FF'
value: 10
- color: '#0080FF'
value: 15
- color: '#87c087'
value: 18
- color: '#389638'
value: 21
- color: '#FF9932'
value: 24
- color: '#FF8000'
value: 25
- color: '#ff0000'
value: 26
entities:
- entity: sensor.yr_temperature
height: 75
hour24: true
line_color: var(--primary-color)
location_icon: left
location_state: center
name: Utetemperatur fra Yr.no
show:
extrema: true
fill: fade
type: 'custom:mini-graph-card'
tom_l
September 7, 2019, 12:07pm
2
Are the built in history graphs working (more info pop-up)?
Do you have database errors in your log?
palengh
(Pål Engh)
September 7, 2019, 7:30pm
4
… and my database seems to be malformed (whatever that means)
2019-09-07 21:27:54 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (sqlite3.DatabaseError) database disk image is malformed
sqlite3.DatabaseError: database disk image is malformed
palengh
(Pål Engh)
September 7, 2019, 7:48pm
5
I came across this article.
Hi, after some hussel around sd card images (i.e. restoring snapshots) and some updates this errors occures:
2018-11-01 22:37:01 ERROR (SyncWorker_4) [homeassistant.components.recorder.util] Error executing query: (sqlite3.DatabaseError) database disk image is malformed [SQL: 'SELECT events.event_id AS events_event_id, events.event_type AS events_event_type, events.event_data AS events_event_data, events.origin AS events_origin, events.time_fired AS events_time_fired, events.created AS events_c…
So i deleted the db file and this error was gone. Thank you, @tom_l for pointing me in right direction.
FWIW: Why/how do this type of errors occur?
palengh
(Pål Engh)
September 7, 2019, 8:07pm
6
BTW: Any suggestion why this one node don’t report its temperature?
The Z-wave communication with the node is woking.
… although its dead right now this error occurred some weeks ago when the states was Ready: TRUE, Awake: TRUE and Failed: FALSE