I’m posting here again (my previous post https://community.home-assistant.io/t/influxdb-problem-question/82777 ), as it’s not problem with InfluxDB.
It seems Home Assistant somehow generate duplicate events.
I receive data from Aeotec ZW096 Smart Switch every minute for ex.:
2018-12-04 17:42:53.696 Detail, Node010, Received: 0x01, 0x10, 0x00, 0x04, 0x00, 0x0a, 0x0a, 0x32, 0x02, 0xa1, 0x64, 0x00, 0x03, 0x7a, 0xf4, 0x00, 0x00, 0x93
2018-12-04 17:42:53.696 Detail,
2018-12-04 17:42:53.696 Detail, Node010, Refreshed Value: old value=false, new value=false, type=bool
2018-12-04 17:42:53.696 Detail, Node010, Changes to this value are not verified
2018-12-04 17:42:53.696 Info, Node010, Received Meter report from node 10: Voltage=228.084V
2018-12-04 17:42:53.696 Detail, Node010, Refreshed Value: old value=230.829, new value=228.084, type=decimal
2018-12-04 17:42:53.696 Detail, Node010, Changes to this value are not verified
2018-12-04 17:42:53.696 Detail, Node010, Notification: ValueChanged
2018-12-04 17:42:53.699 Detail, Node010, Notification: ValueChanged
2018-12-04 17:42:53.796 Detail, Node010, Received: 0x01, 0x10, 0x00, 0x04, 0x00, 0x0a, 0x0a, 0x32, 0x02, 0xa1, 0x6c, 0x00, 0x00, 0x06, 0x0e, 0x00, 0x00, 0x1e
2018-12-04 17:42:53.796 Detail,
2018-12-04 17:42:53.796 Detail, Node010, Refreshed Value: old value=false, new value=false, type=bool
2018-12-04 17:42:53.796 Detail, Node010, Changes to this value are not verified
2018-12-04 17:42:53.796 Info, Node010, Received Meter report from node 10: Current=1.550A
2018-12-04 17:42:53.796 Detail, Node010, Refreshed Value: old value=1.547, new value=1.550, type=decimal
2018-12-04 17:42:53.796 Detail, Node010, Changes to this value are not verified
2018-12-04 17:42:53.796 Detail, Node010, Notification: ValueChanged
2018-12-04 17:42:53.798 Detail, Node010, Notification: ValueChanged
2018-12-04 17:42:53.898 Detail, Node010, Received: 0x01, 0x14, 0x00, 0x04, 0x00, 0x0a, 0x0e, 0x32, 0x02, 0x21, 0x64, 0x00, 0x00, 0x32, 0x7f, 0x00, 0x3c, 0x00, 0x00, 0x32, 0x7a, 0xa7
2018-12-04 17:42:53.898 Detail,
2018-12-04 17:42:53.898 Detail, Node010, Refreshed Value: old value=false, new value=false, type=bool
2018-12-04 17:42:53.898 Detail, Node010, Changes to this value are not verified
2018-12-04 17:42:53.898 Info, Node010, Received Meter report from node 10: Energy=12.927kWh
2018-12-04 17:42:53.898 Detail, Node010, Refreshed Value: old value=12.922, new value=12.927, type=decimal
2018-12-04 17:42:53.898 Detail, Node010, Changes to this value are not verified
2018-12-04 17:42:53.898 Info, Node010, Previous value was 12.922kWh, received 60 seconds ago.
2018-12-04 17:42:53.898 Detail, Node010, Refreshed Value: old value=12.917, new value=12.922, type=decimal
2018-12-04 17:42:53.898 Detail, Node010, Changes to this value are not verified
2018-12-04 17:42:53.898 Detail, Node010, Refreshed Value: old value=60, new value=60, type=int
2018-12-04 17:42:53.898 Detail, Node010, Changes to this value are not verified
2018-12-04 17:42:53.898 Detail, Node010, Notification: ValueChanged
2018-12-04 17:42:53.900 Detail, Node010, Notification: ValueChanged
2018-12-04 17:42:53.903 Detail, Node010, Notification: ValueChanged
2018-12-04 17:42:53.908 Detail, Node010, Notification: ValueChanged
2018-12-04 17:42:53.996 Detail, Node010, Received: 0x01, 0x10, 0x00, 0x04, 0x00, 0x0a, 0x0a, 0x32, 0x02, 0x21, 0x74, 0x00, 0x04, 0x77, 0x46, 0x00, 0x00, 0xbb
2018-12-04 17:42:53.996 Detail,
2018-12-04 17:42:53.996 Detail, Node010, Refreshed Value: old value=false, new value=false, type=bool
2018-12-04 17:42:53.996 Detail, Node010, Changes to this value are not verified
2018-12-04 17:42:53.996 Info, Node010, Received Meter report from node 10: Power=292.678W
2018-12-04 17:42:53.996 Detail, Node010, Refreshed Value: old value=293.876, new value=292.678, type=decimal
2018-12-04 17:42:53.996 Detail, Node010, Changes to this value are not verified
2018-12-04 17:42:53.996 Detail, Node010, Notification: ValueChanged
2018-12-04 17:42:53.997 Detail, Node010, Notification: ValueChanged
in events table I see:
{
"entity_id": "sensor.ups_voltage",
"old_state": {
"entity_id": "sensor.ups_voltage",
"state": "230.83",
"attributes": {
"node_id": 10,
"value_index": 16,
"value_instance": 1,
"value_id": "72057594210713858",
"power_consumption": 293.876,
"unit_of_measurement": "V",
"friendly_name": "UPS Voltage"
},
"last_changed": "2018-12-04T16:41:54.100974+00:00",
"last_updated": "2018-12-04T16:41:54.100974+00:00",
"context": {
"id": "7c0eb6d85afc4cf2b60f21f51ae4d86b",
"user_id": null
}
},
"new_state": {
"entity_id": "sensor.ups_voltage",
"state": "228.08",
"attributes": {
"node_id": 10,
"value_index": 16,
"value_instance": 1,
"value_id": "72057594210713858",
"power_consumption": 293.876,
"unit_of_measurement": "V",
"friendly_name": "UPS Voltage"
},
"last_changed": "2018-12-04T16:42:53.803088+00:00",
"last_updated": "2018-12-04T16:42:53.803088+00:00",
"context": {
"id": "75f8427e057b4a1688bd4b8e35db4e4f",
"user_id": null
}
}
}
{
"entity_id": "sensor.ups_current",
"old_state": {
"entity_id": "sensor.ups_current",
"state": "1.55",
"attributes": {
"node_id": 10,
"value_index": 20,
"value_instance": 1,
"value_id": "72057594210713922",
"power_consumption": 293.876,
"unit_of_measurement": "A",
"friendly_name": "UPS current"
},
"last_changed": "2018-12-04T16:41:54.101432+00:00",
"last_updated": "2018-12-04T16:41:54.101432+00:00",
"context": {
"id": "fbe5b6ace913480f9ca33b18e96877d7",
"user_id": null
}
},
"new_state": {
"entity_id": "sensor.ups_current",
"state": "1.55",
"attributes": {
"node_id": 10,
"value_index": 20,
"value_instance": 1,
"value_id": "72057594210713922",
"power_consumption": 293.876,
"unit_of_measurement": "A",
"friendly_name": "UPS current"
},
"last_changed": "2018-12-04T16:42:53.904512+00:00",
"last_updated": "2018-12-04T16:42:53.904512+00:00",
"context": {
"id": "7862bfc0ad5141c59ac1fcfdc0ee4e10",
"user_id": null
}
}
}
there are also events for enery, power and again voltage, current:
{
"entity_id": "sensor.ups_voltage",
"old_state": {
"entity_id": "sensor.ups_voltage",
"state": "228.08",
"attributes": {
"node_id": 10,
"value_index": 16,
"value_instance": 1,
"value_id": "72057594210713858",
"power_consumption": 293.876,
"unit_of_measurement": "V",
"friendly_name": "UPS Voltage"
},
"last_changed": "2018-12-04T16:42:53.803088+00:00",
"last_updated": "2018-12-04T16:42:53.803088+00:00",
"context": {
"id": "75f8427e057b4a1688bd4b8e35db4e4f",
"user_id": null
}
},
"new_state": {
"entity_id": "sensor.ups_voltage",
"state": "228.08",
"attributes": {
"node_id": 10,
"value_index": 16,
"value_instance": 1,
"value_id": "72057594210713858",
"power_consumption": 292.678,
"unit_of_measurement": "V",
"friendly_name": "UPS Voltage"
},
"last_changed": "2018-12-04T16:42:54.102691+00:00",
"last_updated": "2018-12-04T16:42:54.102691+00:00",
"context": {
"id": "1745d4541f39430994a3911709e26a53",
"user_id": null
}
}
}
{
"entity_id": "sensor.ups_current",
"old_state": {
"entity_id": "sensor.ups_current",
"state": "1.55",
"attributes": {
"node_id": 10,
"value_index": 20,
"value_instance": 1,
"value_id": "72057594210713922",
"power_consumption": 293.876,
"unit_of_measurement": "A",
"friendly_name": "UPS current"
},
"last_changed": "2018-12-04T16:42:53.904512+00:00",
"last_updated": "2018-12-04T16:42:53.904512+00:00",
"context": {
"id": "7862bfc0ad5141c59ac1fcfdc0ee4e10",
"user_id": null
}
},
"new_state": {
"entity_id": "sensor.ups_current",
"state": "1.55",
"attributes": {
"node_id": 10,
"value_index": 20,
"value_instance": 1,
"value_id": "72057594210713922",
"power_consumption": 292.678,
"unit_of_measurement": "A",
"friendly_name": "UPS current"
},
"last_changed": "2018-12-04T16:42:54.103183+00:00",
"last_updated": "2018-12-04T16:42:54.103183+00:00",
"context": {
"id": "92e00f47e22b4a4ab77794aba825b3cb",
"user_id": null
}
}
}
and after minute:
2018-12-04 17:43:53.694 Detail, Node010, Received: 0x01, 0x10, 0x00, 0x04, 0x00, 0x0a, 0x0a, 0x32, 0x02, 0xa1, 0x64, 0x00, 0x03, 0x85, 0x80, 0x00, 0x00, 0x18
2018-12-04 17:43:53.694 Detail,
2018-12-04 17:43:53.694 Detail, Node010, Refreshed Value: old value=false, new value=false, type=bool
2018-12-04 17:43:53.694 Detail, Node010, Changes to this value are not verified
2018-12-04 17:43:53.694 Info, Node010, Received Meter report from node 10: Voltage=230.784V
2018-12-04 17:43:53.694 Detail, Node010, Refreshed Value: old value=228.084, new value=230.784, type=decimal
2018-12-04 17:43:53.694 Detail, Node010, Changes to this value are not verified
2018-12-04 17:43:53.694 Detail, Node010, Notification: ValueChanged
2018-12-04 17:43:53.697 Detail, Node010, Notification: ValueChanged
2018-12-04 17:43:53.796 Detail, Node010, Received: 0x01, 0x10, 0x00, 0x04, 0x00, 0x0a, 0x0a, 0x32, 0x02, 0xa1, 0x6c, 0x00, 0x00, 0x06, 0x05, 0x00, 0x00, 0x15
2018-12-04 17:43:53.796 Detail,
2018-12-04 17:43:53.796 Detail, Node010, Refreshed Value: old value=false, new value=false, type=bool
2018-12-04 17:43:53.796 Detail, Node010, Changes to this value are not verified
2018-12-04 17:43:53.796 Info, Node010, Received Meter report from node 10: Current=1.541A
2018-12-04 17:43:53.796 Detail, Node010, Refreshed Value: old value=1.550, new value=1.541, type=decimal
2018-12-04 17:43:53.796 Detail, Node010, Changes to this value are not verified
2018-12-04 17:43:53.796 Detail, Node010, Notification: ValueChanged
2018-12-04 17:43:53.798 Detail, Node010, Notification: ValueChanged
2018-12-04 17:43:53.897 Detail, Node010, Received: 0x01, 0x14, 0x00, 0x04, 0x00, 0x0a, 0x0e, 0x32, 0x02, 0x21, 0x64, 0x00, 0x00, 0x32, 0x84, 0x00, 0x3c, 0x00, 0x00, 0x32, 0x7f, 0x59
2018-12-04 17:43:53.898 Detail,
2018-12-04 17:43:53.898 Detail, Node010, Refreshed Value: old value=false, new value=false, type=bool
2018-12-04 17:43:53.898 Detail, Node010, Changes to this value are not verified
2018-12-04 17:43:53.898 Info, Node010, Received Meter report from node 10: Energy=12.932kWh
2018-12-04 17:43:53.898 Detail, Node010, Refreshed Value: old value=12.927, new value=12.932, type=decimal
2018-12-04 17:43:53.898 Detail, Node010, Changes to this value are not verified
2018-12-04 17:43:53.898 Info, Node010, Previous value was 12.927kWh, received 60 seconds ago.
2018-12-04 17:43:53.898 Detail, Node010, Refreshed Value: old value=12.922, new value=12.927, type=decimal
2018-12-04 17:43:53.898 Detail, Node010, Changes to this value are not verified
2018-12-04 17:43:53.898 Detail, Node010, Refreshed Value: old value=60, new value=60, type=int
2018-12-04 17:43:53.898 Detail, Node010, Changes to this value are not verified
2018-12-04 17:43:53.898 Detail, Node010, Notification: ValueChanged
2018-12-04 17:43:53.900 Detail, Node010, Notification: ValueChanged
2018-12-04 17:43:53.903 Detail, Node010, Notification: ValueChanged
2018-12-04 17:43:53.904 Detail, Node010, Notification: ValueChanged
2018-12-04 17:43:53.996 Detail, Node010, Received: 0x01, 0x10, 0x00, 0x04, 0x00, 0x0a, 0x0a, 0x32, 0x02, 0x21, 0x74, 0x00, 0x04, 0x73, 0x54, 0x00, 0x00, 0xad
2018-12-04 17:43:53.996 Detail,
2018-12-04 17:43:53.996 Detail, Node010, Refreshed Value: old value=false, new value=false, type=bool
2018-12-04 17:43:53.996 Detail, Node010, Changes to this value are not verified
2018-12-04 17:43:53.996 Info, Node010, Received Meter report from node 10: Power=291.668W
2018-12-04 17:43:53.996 Detail, Node010, Refreshed Value: old value=292.678, new value=291.668, type=decimal
2018-12-04 17:43:53.996 Detail, Node010, Changes to this value are not verified
2018-12-04 17:43:53.996 Detail, Node010, Notification: ValueChanged
2018-12-04 17:43:53.996 Detail, Node010, Notification: ValueChanged
in home-assistant_v2.db database in table events is this:
{
"entity_id": "sensor.ups_voltage",
"old_state": {
"entity_id": "sensor.ups_voltage",
"state": "228.08",
"attributes": {
"node_id": 10,
"value_index": 16,
"value_instance": 1,
"value_id": "72057594210713858",
"power_consumption": 292.678,
"unit_of_measurement": "V",
"friendly_name": "UPS Voltage"
},
"last_changed": "2018-12-04T16:42:54.102691+00:00",
"last_updated": "2018-12-04T16:42:54.102691+00:00",
"context": {
"id": "1745d4541f39430994a3911709e26a53",
"user_id": null
}
},
"new_state": {
"entity_id": "sensor.ups_voltage",
"state": "230.78",
"attributes": {
"node_id": 10,
"value_index": 16,
"value_instance": 1,
"value_id": "72057594210713858",
"power_consumption": 292.678,
"unit_of_measurement": "V",
"friendly_name": "UPS Voltage"
},
"last_changed": "2018-12-04T16:43:53.805073+00:00",
"last_updated": "2018-12-04T16:43:53.805073+00:00",
"context": {
"id": "d972b1baec0a46a89de7ed27f803426a",
"user_id": null
}
}
}
{
"entity_id": "sensor.ups_current",
"old_state": {
"entity_id": "sensor.ups_current",
"state": "1.55",
"attributes": {
"node_id": 10,
"value_index": 20,
"value_instance": 1,
"value_id": "72057594210713922",
"power_consumption": 292.678,
"unit_of_measurement": "A",
"friendly_name": "UPS current"
},
"last_changed": "2018-12-04T16:42:54.103183+00:00",
"last_updated": "2018-12-04T16:42:54.103183+00:00",
"context": {
"id": "92e00f47e22b4a4ab77794aba825b3cb",
"user_id": null
}
},
"new_state": {
"entity_id": "sensor.ups_current",
"state": "1.54",
"attributes": {
"node_id": 10,
"value_index": 20,
"value_instance": 1,
"value_id": "72057594210713922",
"power_consumption": 292.678,
"unit_of_measurement": "A",
"friendly_name": "UPS current"
},
"last_changed": "2018-12-04T16:43:53.906182+00:00",
"last_updated": "2018-12-04T16:43:53.906182+00:00",
"context": {
"id": "d6d891e705744d01b3b805693c03696f",
"user_id": null
}
}
}
there are also events for power and energy
and then again:
{
"entity_id": "sensor.ups_voltage",
"old_state": {
"entity_id": "sensor.ups_voltage",
"state": "230.78",
"attributes": {
"node_id": 10,
"value_index": 16,
"value_instance": 1,
"value_id": "72057594210713858",
"power_consumption": 292.678,
"unit_of_measurement": "V",
"friendly_name": "UPS Voltage"
},
"last_changed": "2018-12-04T16:43:53.805073+00:00",
"last_updated": "2018-12-04T16:43:53.805073+00:00",
"context": {
"id": "d972b1baec0a46a89de7ed27f803426a",
"user_id": null
}
},
"new_state": {
"entity_id": "sensor.ups_voltage",
"state": "230.78",
"attributes": {
"node_id": 10,
"value_index": 16,
"value_instance": 1,
"value_id": "72057594210713858",
"power_consumption": 291.668,
"unit_of_measurement": "V",
"friendly_name": "UPS Voltage"
},
"last_changed": "2018-12-04T16:43:54.100307+00:00",
"last_updated": "2018-12-04T16:43:54.100307+00:00",
"context": {
"id": "5eec5ca417e1468babf1640d917d5b5e",
"user_id": null
}
}
}
{
"entity_id": "sensor.ups_current",
"old_state": {
"entity_id": "sensor.ups_current",
"state": "1.54",
"attributes": {
"node_id": 10,
"value_index": 20,
"value_instance": 1,
"value_id": "72057594210713922",
"power_consumption": 292.678,
"unit_of_measurement": "A",
"friendly_name": "UPS current"
},
"last_changed": "2018-12-04T16:43:53.906182+00:00",
"last_updated": "2018-12-04T16:43:53.906182+00:00",
"context": {
"id": "d6d891e705744d01b3b805693c03696f",
"user_id": null
}
},
"new_state": {
"entity_id": "sensor.ups_current",
"state": "1.54",
"attributes": {
"node_id": 10,
"value_index": 20,
"value_instance": 1,
"value_id": "72057594210713922",
"power_consumption": 291.668,
"unit_of_measurement": "A",
"friendly_name": "UPS current"
},
"last_changed": "2018-12-04T16:43:54.100762+00:00",
"last_updated": "2018-12-04T16:43:54.100762+00:00",
"context": {
"id": "c8d39d2d1cce4cfba6786977e363f5e8",
"user_id": null
}
}
}
So it’s like:
voltage change
current change
energy change
power change
voltage change
current change
and then again:
voltage change
current change
energy change
power change
voltage change
current change
event for voltage and current are repeated. But in z-wave log it’s only received once.
It seems first 2 events for voltage and current are the same values as in previous event and then new ones.
It’s not the same for all switches, for some there are duplicate kWh values.
Why is this?