Datenabfrage geht nicht mehr

[DiePolle]

Guten Morgen,

Habe seit heute Früh ein lustiges verhalten. Nachdem ich vorgestern ein Backup einspielen musste da meine SD Karte defekt wurde lief für 2 Tage alles ohne Probleme. Nun wollte ich heute morgen die Werte meiner Wärmepumpe checken. Ging nicht. Dann dachte ich mir auch wenn es noch finster ist schau ich halt mal auf die Photovoltaikanlage Seite - ging auch nicht. Wenn ich nun im DEBUG modus starte und die Seiten aufrufe sehe ich folgendes:

2015-07-29 05:24:22,078 DEBUG Main WebSocket: incoming connection from 10.0.0.204:54898 to 10.0.0.200:2424 -- connection.py:accept:188
2015-07-29 05:24:22,651 DEBUG Main 10.0.0.204:54898 sent '{"cmd":"proto","ver":3}' -- __init__.py:json_parse:270
2015-07-29 05:24:22,663 DEBUG Main 10.0.0.204:54898 sent '{"cmd":"monitor","items":["Heizung.temp_outside","Heizung.state","Heizung.it em56","Heizung.item57","Heizung.item60","Heizung.i tem63","Heizung.item64","Heizung.item65","Heizung. item67","Heizung.item17","Heizung.item18","Heizung .item10","Heizung.item11","Heizung.item12","Heizun g.item13","Heizung.item14","Heizung.item16","Heizu ng.item19","Heizung.item20","Heizung.item21","Heiz ung.item22","Heizung.item24","Heizung.item25","Hei zung.item26","Heizung.item27","Heizung.item28","He izung.item36","Heizung.item105"]}' -- __init__.py:json_parse:270
2015-07-29 05:24:22,688 DEBUG Main 10.0.0.204:54898 sent '{"cmd":"series","item":"Heizung.temp_outside","se ries":"avg","start":"48h"}' -- __init__.py:json_parse:270
2015-07-29 05:24:22,695 ERROR Main Problem fetching series for Heizung.temp_outside: 'SQL' object has no attribute '_frames' -- __init__.py:json_parse:323
Traceback (most recent call last):
File "/usr/smarthome/plugins/visu/__init__.py", line 321, in json_parse
reply = self.items[path]['item'].series(series, start, end, count)
File "/usr/smarthome/plugins/sqlite/__init__.py", line 308, in _series
istart = self._get_timestamp(start)
File "/usr/smarthome/plugins/sqlite/__init__.py", line 205, in _get_timestamp
elif frame[-1] in self._frames:
AttributeError: 'SQL' object has no attribute '_frames'

2015-07-29 05:24:54,598 DEBUG Main WebSocket: incoming connection from 10.0.0.204:54911 to 10.0.0.200:2424 -- connection.py:accept:188
2015-07-29 05:24:55,284 DEBUG Main 10.0.0.204:54911 sent '{"cmd":"proto","ver":3}' -- __init__.py:json_parse:270
2015-07-29 05:24:55,294 DEBUG Main 10.0.0.204:54911 sent '{"cmd":"monitor","items":["PV.status","PV.current","PV.total","PV.day"]}' -- __init__.py:json_parse:270
2015-07-29 05:24:55,302 DEBUG Main 10.0.0.204:54911 sent '{"cmd":"series","item":"PV.current","series":"avg ","start":"48h"}' -- __init__.py:json_parse:270
2015-07-29 05:24:55,309 ERROR Main Problem fetching series for PV.current: 'SQL' object has no attribute '_frames' -- __init__.py:json_parse:323
Traceback (most recent call last):
File "/usr/smarthome/plugins/visu/__init__.py", line 321, in json_parse
reply = self.items[path]['item'].series(series, start, end, count)
File "/usr/smarthome/plugins/sqlite/__init__.py", line 308, in _series
istart = self._get_timestamp(start)
File "/usr/smarthome/plugins/sqlite/__init__.py", line 205, in _get_timestamp
elif frame[-1] in self._frames:
AttributeError: 'SQL' object has no attribute '_frames'
2015-07-29 05:24:55,319 DEBUG Main 10.0.0.204:54911 sent '{"cmd":"series","item":"PV.day","series":"max","s tart":"168h"}' -- __init__.py:json_parse:270
2015-07-29 05:24:55,326 ERROR Main Problem fetching series for PV.day: 'SQL' object has no attribute '_frames' -- __init__.py:json_parse:323
Traceback (most recent call last):
File "/usr/smarthome/plugins/visu/__init__.py", line 321, in json_parse
reply = self.items[path]['item'].series(series, start, end, count)
File "/usr/smarthome/plugins/sqlite/__init__.py", line 308, in _series
istart = self._get_timestamp(start)
File "/usr/smarthome/plugins/sqlite/__init__.py", line 205, in _get_timestamp
elif frame[-1] in self._frames:
AttributeError: 'SQL' object has no attribute '_frames'
2015-07-29 05:24:55,336 DEBUG Main 10.0.0.204:54911 sent '{"cmd":"series","item":"PV.l1v","series":"avg","s tart":"48h"}' -- __init__.py:json_parse:270
2015-07-29 05:24:55,343 ERROR Main Problem fetching series for PV.l1v: 'SQL' object has no attribute '_frames' -- __init__.py:json_parse:323
Traceback (most recent call last):
File "/usr/smarthome/plugins/visu/__init__.py", line 321, in json_parse
reply = self.items[path]['item'].series(series, start, end, count)
File "/usr/smarthome/plugins/sqlite/__init__.py", line 308, in _series
istart = self._get_timestamp(start)
File "/usr/smarthome/plugins/sqlite/__init__.py", line 205, in _get_timestamp
elif frame[-1] in self._frames:
AttributeError: 'SQL' object has no attribute '_frames'
2015-07-29 05:24:55,352 DEBUG Main 10.0.0.204:54911 sent '{"cmd":"series","item":"PV.l2v","series":"avg","s tart":"48h"}' -- __init__.py:json_parse:270
2015-07-29 05:24:55,359 ERROR Main Problem fetching series for PV.l2v: 'SQL' object has no attribute '_frames' -- __init__.py:json_parse:323
Traceback (most recent call last):
File "/usr/smarthome/plugins/visu/__init__.py", line 321, in json_parse
reply = self.items[path]['item'].series(series, start, end, count)
File "/usr/smarthome/plugins/sqlite/__init__.py", line 308, in _series
istart = self._get_timestamp(start)
File "/usr/smarthome/plugins/sqlite/__init__.py", line 205, in _get_timestamp
elif frame[-1] in self._frames:
AttributeError: 'SQL' object has no attribute '_frames'
2015-07-29 05:24:55,370 DEBUG Main 10.0.0.204:54911 sent '{"cmd":"series","item":"PV.l3v","series":"avg","s tart":"48h"}' -- __init__.py:json_parse:270
2015-07-29 05:24:55,377 ERROR Main Problem fetching series for PV.l3v: 'SQL' object has no attribute '_frames' -- __init__.py:json_parse:323
Traceback (most recent call last):
File "/usr/smarthome/plugins/visu/__init__.py", line 321, in json_parse
reply = self.items[path]['item'].series(series, start, end, count)
File "/usr/smarthome/plugins/sqlite/__init__.py", line 308, in _series
istart = self._get_timestamp(start)
File "/usr/smarthome/plugins/sqlite/__init__.py", line 205, in _get_timestamp
elif frame[-1] in self._frames:
AttributeError: 'SQL' object has no attribute '_frames'
2015-07-29 05:24:55,386 DEBUG Main 10.0.0.204:54911 sent '{"cmd":"series","item":"PV.l1w","series":"avg","s tart":"48h"}' -- __init__.py:json_parse:270
2015-07-29 05:24:55,393 ERROR Main Problem fetching series for PV.l1w: 'SQL' object has no attribute '_frames' -- __init__.py:json_parse:323
Traceback (most recent call last):
File "/usr/smarthome/plugins/visu/__init__.py", line 321, in json_parse
reply = self.items[path]['item'].series(series, start, end, count)
File "/usr/smarthome/plugins/sqlite/__init__.py", line 308, in _series
istart = self._get_timestamp(start)
File "/usr/smarthome/plugins/sqlite/__init__.py", line 205, in _get_timestamp
elif frame[-1] in self._frames:
AttributeError: 'SQL' object has no attribute '_frames'
2015-07-29 05:24:55,403 DEBUG Main 10.0.0.204:54911 sent '{"cmd":"series","item":"PV.l2w","series":"avg","s tart":"48h"}' -- __init__.py:json_parse:270
2015-07-29 05:24:55,411 ERROR Main Problem fetching series for PV.l2w: 'SQL' object has no attribute '_frames' -- __init__.py:json_parse:323
Traceback (most recent call last):
File "/usr/smarthome/plugins/visu/__init__.py", line 321, in json_parse
reply = self.items[path]['item'].series(series, start, end, count)
File "/usr/smarthome/plugins/sqlite/__init__.py", line 308, in _series
istart = self._get_timestamp(start)
File "/usr/smarthome/plugins/sqlite/__init__.py", line 205, in _get_timestamp
elif frame[-1] in self._frames:
AttributeError: 'SQL' object has no attribute '_frames'
2015-07-29 05:24:55,420 DEBUG Main 10.0.0.204:54911 sent '{"cmd":"series","item":"PV.l3w","series":"avg","s tart":"48h"}' -- __init__.py:json_parse:270
2015-07-29 05:24:55,427 ERROR Main Problem fetching series for PV.l3w: 'SQL' object has no attribute '_frames' -- __init__.py:json_parse:323
Traceback (most recent call last):
File "/usr/smarthome/plugins/visu/__init__.py", line 321, in json_parse
reply = self.items[path]['item'].series(series, start, end, count)
File "/usr/smarthome/plugins/sqlite/__init__.py", line 308, in _series
istart = self._get_timestamp(start)
File "/usr/smarthome/plugins/sqlite/__init__.py", line 205, in _get_timestamp
elif frame[-1] in self._frames:
AttributeError: 'SQL' object has no attribute '_frames'
2015-07-29 05:24:55,438 DEBUG Main 10.0.0.204:54911 sent '{"cmd":"series","item":"PV.str1v","series":"avg", "start":"48h"}' -- __init__.py:json_parse:270
2015-07-29 05:24:55,445 ERROR Main Problem fetching series for PV.str1v: 'SQL' object has no attribute '_frames' -- __init__.py:json_parse:323
Traceback (most recent call last):
File "/usr/smarthome/plugins/visu/__init__.py", line 321, in json_parse
reply = self.items[path]['item'].series(series, start, end, count)
File "/usr/smarthome/plugins/sqlite/__init__.py", line 308, in _series
istart = self._get_timestamp(start)
File "/usr/smarthome/plugins/sqlite/__init__.py", line 205, in _get_timestamp
elif frame[-1] in self._frames:
AttributeError: 'SQL' object has no attribute '_frames'
2015-07-29 05:24:55,455 DEBUG Main 10.0.0.204:54911 sent '{"cmd":"series","item":"PV.str1a","series":"avg", "start":"48h"}' -- __init__.py:json_parse:270
2015-07-29 05:24:55,463 ERROR Main Problem fetching series for PV.str1a: 'SQL' object has no attribute '_frames' -- __init__.py:json_parse:323
Traceback (most recent call last):
File "/usr/smarthome/plugins/visu/__init__.py", line 321, in json_parse
reply = self.items[path]['item'].series(series, start, end, count)
File "/usr/smarthome/plugins/sqlite/__init__.py", line 308, in _series
istart = self._get_timestamp(start)
File "/usr/smarthome/plugins/sqlite/__init__.py", line 205, in _get_timestamp
elif frame[-1] in self._frames:
AttributeError: 'SQL' object has no attribute '_frames'
2015-07-29 05:24:55,472 DEBUG Main 10.0.0.204:54911 sent '{"cmd":"series","item":"PV.str2v","series":"avg", "start":"48h"}' -- __init__.py:json_parse:270
2015-07-29 05:24:55,479 ERROR Main Problem fetching series for PV.str2v: 'SQL' object has no attribute '_frames' -- __init__.py:json_parse:323
Traceback (most recent call last):
File "/usr/smarthome/plugins/visu/__init__.py", line 321, in json_parse
reply = self.items[path]['item'].series(series, start, end, count)
File "/usr/smarthome/plugins/sqlite/__init__.py", line 308, in _series
istart = self._get_timestamp(start)
File "/usr/smarthome/plugins/sqlite/__init__.py", line 205, in _get_timestamp
elif frame[-1] in self._frames:
AttributeError: 'SQL' object has no attribute '_frames'
2015-07-29 05:24:55,490 DEBUG Main 10.0.0.204:54911 sent '{"cmd":"series","item":"PV.str2a","series":"avg", "start":"48h"}' -- __init__.py:json_parse:270
2015-07-29 05:24:55,497 ERROR Main Problem fetching series for PV.str2a: 'SQL' object has no attribute '_frames' -- __init__.py:json_parse:323
Traceback (most recent call last):
File "/usr/smarthome/plugins/visu/__init__.py", line 321, in json_parse
reply = self.items[path]['item'].series(series, start, end, count)
File "/usr/smarthome/plugins/sqlite/__init__.py", line 308, in _series
istart = self._get_timestamp(start)
File "/usr/smarthome/plugins/sqlite/__init__.py", line 205, in _get_timestamp
elif frame[-1] in self._frames:
AttributeError: 'SQL' object has no attribute '_frames'
2015-07-29 05:27:14,113 DEBUG Kostal set status = Aus -- __init__.py:_refresh:94
2015-07-29 05:27:14,117 DEBUG Kostal set power_day = 0 -- __init__.py:_refresh:94
2015-07-29 05:27:14,121 DEBUG Kostal set string3_ampere = -- __init__.py:_refresh:94
2015-07-29 05:27:14,125 DEBUG Kostal set power_total = 10109 -- __init__.py:_refresh:94
2015-07-29 05:27:14,129 DEBUG Kostal set string3_volt = -- __init__.py:_refresh:94
2015-07-29 05:27:14,133 DEBUG Kostal cycle takes 0.1141049861907959 seconds -- __init__.py:_refresh:105
2015-07-29 05:27:14,527 DEBUG Scheduler Kostal next time: 2015-07-29 05:32:14+02:00 -- scheduler.py:_next_time:289
2015-07-29 05:27:16,164 DEBUG env_stat Item env.core.memory = 18153472 via Logic None None -- item.py:__update:363
2015-07-29 05:27:16,181 DEBUG Luxtronic2 Item Heizung.item10 = 24.1 via Luxtronic2 None None -- item.py:__update:363
2015-07-29 05:27:16,183 DEBUG env_stat Item env.system.load = 3.06 via Logic None None -- item.py:__update:363
2015-07-29 05:27:16,192 DEBUG Luxtronic2 Item Heizung.item11 = 22.5 via Luxtronic2 None None -- item.py:__update:363
2015-07-29 05:27:16,208 DEBUG Luxtronic2 Item Heizung.item14 = 195 via Luxtronic2 None None -- item.py:__update:363
2015-07-29 05:27:16,200 ERROR env_stat Logic: env_stat, File: /usr/smarthome/lib/env/stat.py, Line: 33, Method: <module>, Exception: 'Orb' object has no attribute 'light' -- scheduler.py:_task:334

Was ist denn da nun wieder das Problem? Und warum gings gestern Abend noch?

Danke euch.

[DiePolle]

Gut, habe nun herausgefunden dass es an den Plots liegt. Wenn ich diese auskommentiere dann komme ich auf die Seiten. Kann es sein dass die Datenbank was abbekommen hat?

Was mir aufgefallen ist auch auf die config seite (page=config) komme ich nicht. Da passiert nix, allerdings auch kein Log Eintrag.

Welche einfache Lösung gibt es mein System wieder voll funktionstüchtig zu machen?

[DiePolle]

Bedingt durch das schöne Wetter hatte ich keine Zeit/Lust mich intensiv mit einem PC zu beschäftigen. Jetzt gehts aber wieder los :-)

Habe leider noch immer mein Datenbank Problem, das steht in meinem Log

2015-10-20 09:11:51 ERROR    Main         SQLite: database corrupt. Seek help.
2015-10-20 09:11:53 WARNING  Main         SQLite: Problem with '("SELECT avg from history WHERE item = 'env.core.memory' ORDER BY time DESC LIMIT 1",)': database disk image is malformed
2015-10-20 09:11:53 WARNING  Main         SQLite: Problem with '("SELECT avg from history WHERE item = 'env.core.threads' ORDER BY time DESC LIMIT 1",)': database disk image is malformed
2015-10-20 09:11:53 WARNING  Main         SQLite: Problem with '("SELECT avg from history WHERE item = 'env.core.garbage' ORDER BY time DESC LIMIT 1",)': database disk image is malformed
2015-10-20 09:11:53 WARNING  Main         SQLite: Problem with '("SELECT avg from history WHERE item = 'env.system.load' ORDER BY time DESC LIMIT 1",)': database disk image is malformed

Hätte jemand einen Tipp was man dagegen machen kann?


"Lustig" ist auch dass seit heute keine Daten mehr von meiner Wärmepumpe kommen (Luxtronic), das dürfte aber eine andere Geschichte sein ...

[MiWu]

Hallo,

das sieht aus, als wäre die Datei mit der Datenbank im Eimer. Ich würde unter var/db/ die Datei smarthome.db löschen und neustarten.

Besten Gruß
Michael

[bmx]

Kann es sein, das Du defekte SD-Karten am laufenden Band produzierst ...?

[DiePolle]

Nein, es scheint meine ursprüngliche Sicherung hatte auch ein Problem. Habe jetzt nochmal alles neu installiert, gleich eine Sicherung gemacht und diese getestet.

Alles OK wieder.