Ursache für "Database dump Database"

[henfri]

Hallo,

in meinem Log sehe ich sehr häufig:

2020-04-05 14:44:33 DEBUG Database dump Database: Fetch SELECT time, item_id, duration, val_str, val_num, val_bool, changed FROM log WHERE item_id = 98 AND time = 1586090654233;: []
2020-04-05 14:44:33 DEBUG Database dump Database: Fetch INSERT INTO log(item_id, time, val_str, val_num, val_bool, duration, changed) VALUES (98,1586090654233,None,3611.9270833333417,1,5383,1 586090673884);: <sqlite3.Cursor object at 0x7f2cbf916730>
2020-04-05 14:44:33 DEBUG Database dump Database: Fetch SELECT time, item_id, duration, val_str, val_num, val_bool, changed FROM log WHERE item_id = 98 AND time = 1586090659616;: []
2020-04-05 14:44:33 DEBUG Database dump Database: Fetch INSERT INTO log(item_id, time, val_str, val_num, val_bool, duration, changed) VALUES (98,1586090659616,None,3611.9791666666665,1,5270,1 586090673884);: <sqlite3.Cursor object at 0x7f2cbf916730>
2020-04-05 14:44:33 DEBUG Database dump Database: Fetch SELECT time, item_id, duration, val_str, val_num, val_bool, changed FROM log WHERE item_id = 98 AND time = 1586090664886;: []
2020-04-05 14:44:33 DEBUG Database dump Database: Fetch INSERT INTO log(item_id, time, val_str, val_num, val_bool, duration, changed) VALUES (98,1586090664886,None,3612.0312500000105,1,5356,1 586090673884);: <sqlite3.Cursor object at 0x7f2cbf916730>
2020-04-05 14:44:33 DEBUG Database dump Database: Fetch SELECT time, item_id, duration, val_str, val_num, val_bool, changed FROM log WHERE item_id = 98 AND time = 1586090670242;: []
2020-04-05 14:44:33 DEBUG Database dump Database: Fetch INSERT INTO log(item_id, time, val_str, val_num, val_bool, duration, changed) VALUES (98,1586090670242,None,3612.0833333333358,1,None,1 586090673884);: <sqlite3.Cursor object at 0x7f2cbf916730>
2020-04-05 14:44:33 DEBUG Database dump Database: Fetch UPDATE item SET time = 1586090670242, val_str = None, val_num = 3612.0833333333358, val_bool = 1, changed = 1586090673884 WHERE id = 98;: <sqlite3.Cursor object at 0x7f2cbf916730>
2020-04-05 14:44:33 DEBUG Database dump Database: Fetch SELECT id, name, time, val_str, val_num, val_bool, changed from item WHERE name = eg.Kueche.heizung.stellwert;: (144, 'eg.Kueche.heizung.stellwert', 1586090510617, None, 7.8, 1, 1586090553366)
2020-04-05 14:44:33 DEBUG Database dump Dumping eg.Kueche.heizung.stellwert/144 with 2 values
2020-04-05 14:44:33 DEBUG Database dump Database: Fetch SELECT time, item_id, duration, val_str, val_num, val_bool, changed FROM log WHERE item_id = 144 AND time = 1586090510617;: [(1586090510617, 144, None, None, 7.8, 1, 1586090553366)]
2020-04-05 14:44:33 DEBUG Database dump Database: Fetch UPDATE log SET duration = 127987, val_str = None, val_num = 7.8, val_bool = 1, changed = 1586090673928 WHERE item_id = 144 AND time = 1586090510617;: <sqlite3.Cursor object at 0x7f2cbf916730>
2020-04-05 14:44:33 DEBUG Database dump Database: Fetch SELECT time, item_id, duration, val_str, val_num, val_bool, changed FROM log WHERE item_id = 144 AND time = 1586090638604;: []
2020-04-05 14:44:33 DEBUG Database dump Database: Fetch INSERT INTO log(item_id, time, val_str, val_num, val_bool, duration, changed) VALUES (144,1586090638604,None,5.9,1,None,1586090673928); : <sqlite3.Cursor object at 0x7f2cbf916730>
2020-04-05 14:44:33 DEBUG Database dump Database: Fetch UPDATE item SET time = 1586090638604, val_str = None, val_num = 5.9, val_bool = 1, changed = 1586090673928 WHERE id = 144;: <sqlite3.Cursor object at 0x7f2cbf916730>
2020-04-05 14:44:33 DEBUG Database dump Database: Fetch SELECT id, name, time, val_str, val_num, val_bool, changed from item WHERE name = eg.Arbeit.heizung.ist;: (193, 'eg.Arbeit.heizung.ist', 1586090266616, None, 24.75, 1, 1586090315913)

Ist das normal? Was macht es?

Gruß,
Hendrik

[Onkelandy]

Das kommt wenn ein Eintrag in die db geschrieben wird. Stell das log Level auf info oder warn, wenn alles nach plan läuft

[henfri]

Ok, danke!