15:48:45:105 Idle timer triggered
15:48:45:105 Force read attributes for ZHAOpenClose SensorNode Window / Door Sensor
15:48:45:639 unhandled APS-DATA.confirm id: 99 status 0xE1
15:48:46:105 Wait 1s till query finished
15:48:46:745 unhandled APS-DATA.confirm id: 102 status 0xE1
15:48:47:108 Daylight now: solarNoon, status: 170, daylight: 1, dark: 0
15:48:47:109 Idle timer triggered
15:48:47:110 Force read attributes for ZHAConsumption SensorNode Consumption 48
15:48:47:583 CTRL skip creating node 0x540F57FFFEF92C28 while permit join is disabled
15:48:47:808 unhandled APS-DATA.confirm id: 117 status 0xE1
15:48:48:021 unhandled APS-DATA.confirm id: 120 status 0xE1
15:48:48:104 Wait 1s till query finished
15:48:49:087 unhandled APS-DATA.confirm id: 122 status 0xE1
15:48:49:105 Wait 0s till query finished
15:48:50:105 Idle timer triggered
15:48:50:159 unhandled APS-DATA.confirm id: 125 status 0xE1
15:48:51:245 unhandled APS-DATA.confirm id: 128 status 0xE1
15:48:52:331 unhandled APS-DATA.confirm id: 131 status 0xE1
15:48:53:421 unhandled APS-DATA.confirm id: 134 status 0xE1
15:48:53:425 Websocket 192.168.1.38:44542 send message: {"e":"changed","id":"5","r":"lights","state":{"alert":null,"on":false,"reachable":false},"t":"event","uniqueid":"a4:c1:38:da:92:d1:fe:6d-01"} (ret = 141)
15:48:53:427 Websocket 192.168.1.38:44542 send message: {"config":{"on":true,"reachable":false},"e":"changed","id":"47","r":"sensors","t":"event","uniqueid":"a4:c1:38:da:92:d1:fe:6d-01-0b04"} (ret = -1095389920)
15:48:53:430 Websocket 192.168.1.38:44542 send message: {"config":{"on":true,"reachable":false},"e":"changed","id":"48","r":"sensors","t":"event","uniqueid":"a4:c1:38:da:92:d1:fe:6d-01-0702"} (ret = -1095389920)
15:48:53:433 Websocket 192.168.1.38:44542 send message: {"e":"changed","id":"65520","r":"groups","state":{"all_on":false,"any_on":false},"t":"event"} (ret = 20146864)
15:48:57:104 Daylight now: solarNoon, status: 170, daylight: 1, dark: 0
15:48:59:104 CTRL skip creating node 0x540F57FFFEF92C28 while permit join is disabled
15:49:07:104 Daylight now: solarNoon, status: 170, daylight: 1, dark: 0
15:49:10:624 CTRL skip creating node 0x540F57FFFEF92C28 while permit join is disabled
15:49:16:117 [Master] read param with arg 0x19
15:49:17:105 DB save zll database items 0x00000087
15:49:17:106 DB sql exec REPLACE INTO auth (apikey, devicetype, createdate, lastusedate, useragent) VALUES ('CFE4618457', 'Phoscon#B1920x948', '2023-01-04T14:44:37', '2023-01-04T14:49:16', 'Mozilla/5.0 (X11; CrOS armv7l 13597.84.0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.98 Safari/537.36')
15:49:17:108 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-01-04T14:48Z', 'dev', 1672842665 FROM sub_devices WHERE uniqueid = 'a4:c1:38:da:92:d1:fe:6d-01'
15:49:17:111 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastannounced', '', 'dev', 1655324580 FROM sub_devices WHERE uniqueid = 'a4:c1:38:da:92:d1:fe:6d-01'
15:49:17:119 DB sql exec REPLACE INTO nodes (id, state, mac, name, groups, endpoint, modelid, manufacturername, swbuildid, ritems) VALUES ('5', 'normal', 'a4:c1:38:da:92:d1:fe:6d-01', 'On/Off plug-in unit 5', '65520', '1', 'TS011F', '_TZ3000_amdymr7l', '', '{"attr/id":"5","attr/lastannounced":null,"attr/lastseen":"2023-01-04T14:48Z","attr/manufacturername":"_TZ3000_amdymr7l","attr/modelid":"TS011F","attr/name":"On/Off plug-in unit 5","attr/swversion":null,"attr/type":"Smart plug","attr/uniqueid":"a4:c1:38:da:92:d1:fe:6d-01","state/alert":null,"state/on":false,"state/reachable":false}')
15:49:17:122 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-01-04T14:48Z', 'dev', 1672843618 FROM sub_devices WHERE uniqueid = 'a4:c1:38:b9:9d:9c:c0:e3-01'
15:49:17:128 DB sql exec REPLACE INTO nodes (id, state, mac, name, groups, endpoint, modelid, manufacturername, swbuildid, ritems) VALUES ('6', 'normal', 'a4:c1:38:b9:9d:9c:c0:e3-01', 'Smart plug 6', '', '1', 'TS011F', '_TZ3000_amdymr7l', '', '{"attr/id":"6","attr/lastannounced":null,"attr/lastseen":"2023-01-04T14:48Z","attr/manufacturername":"_TZ3000_amdymr7l","attr/modelid":"TS011F","attr/name":"Smart plug 6","attr/swversion":null,"attr/type":"Smart plug","attr/uniqueid":"a4:c1:38:b9:9d:9c:c0:e3-01","state/alert":"none","state/on":false,"state/reachable":false}')
15:49:17:130 DB sql exec REPLACE INTO groups (gid, name, state, mids, devicemembership, lightsequence, hidden, type, class, uniqueid) VALUES ('0xFFF0', 'All', 'normal', '', '', '', 'false', 'LightGroup', 'Other', '')
15:49:17:136 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-01-04T14:48Z', 'dev', 1668772510 FROM sub_devices WHERE uniqueid = '54:ef:44:10:00:25:bd:eb-01-0500'
15:49:17:138 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1649281912 FROM sub_devices WHERE uniqueid = '54:ef:44:10:00:25:bd:eb-01-0500'
15:49:17:140 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'false', 'dev', 1672741989 FROM sub_devices WHERE uniqueid = '54:ef:44:10:00:25:bd:eb-01-0500'
15:49:17:142 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/battery', '90', 'dev', 1672136470 FROM sub_devices WHERE uniqueid = '54:ef:44:10:00:25:bd:eb-01-0500'
15:49:17:145 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/enrolled', '1', 'dev', 1652825526 FROM sub_devices WHERE uniqueid = '54:ef:44:10:00:25:bd:eb-01-0500'
15:49:17:148 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('31', 'OpenClose 31', 'ZHAOpenClose', 'lumi.magnet.acn001', 'LUMI', '54:ef:44:10:00:25:bd:eb-01-0500', '0.0.0_0004', '{"lastupdated":"2022-11-18T11:55:10.144","open":false}', '{"battery":90,"enrolled":1,"on":true,"pending":null,"reachable":false}', '{"d":1026,"ep":1,"in":[0,1,1280,64704],"p":260}', 'normal', '1', '2023-01-04T14:48Z', '')
15:49:17:155 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastannounced', '', 'dev', 1664101100 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:98:4d:58-01-0405'
15:49:17:157 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-01-04T14:48Z', 'dev', 1672842629 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:98:4d:58-01-0405'
15:49:17:159 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1655408406 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:98:4d:58-01-0405'
15:49:17:161 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'false', 'dev', 1672843029 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:98:4d:58-01-0405'
15:49:17:163 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/battery', '72', 'dev', 1672842196 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:98:4d:58-01-0405'
15:49:17:166 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/offset', '0', 'dev', 1655408286 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:98:4d:58-01-0405'
15:49:17:169 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('11', 'Humidity 11', 'ZHAHumidity', 'lumi.weather', 'LUMI', '00:15:8d:00:07:98:4d:58-01-0405', '20191205', '{"humidity":5387,"lastupdated":"2023-01-04T14:20:22.323"}', '{"battery":72,"offset":0,"on":true,"reachable":false,"temperature":null}', '{"d":24321,"ep":1,"in":[0,1029],"p":260}', 'normal', '1', '2023-01-04T14:48Z', '')
15:49:17:174 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastannounced', '', 'dev', 1664101100 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:98:4d:58-01-0402'
15:49:17:177 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-01-04T14:48Z', 'dev', 1672842629 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:98:4d:58-01-0402'
15:49:17:179 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1655408406 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:98:4d:58-01-0402'
15:49:17:181 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'false', 'dev', 1672843029 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:98:4d:58-01-0402'
15:49:17:183 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/battery', '72', 'dev', 1672842196 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:98:4d:58-01-0402'
15:49:17:185 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/offset', '0', 'dev', 1655408286 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:98:4d:58-01-0402'
15:49:17:187 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('10', 'Temperature 10', 'ZHATemperature', 'lumi.weather', 'LUMI', '00:15:8d:00:07:98:4d:58-01-0402', '20191205', '{"lastupdated":"2023-01-04T14:20:22.299","temperature":1756}', '{"battery":72,"offset":0,"on":true,"reachable":false,"temperature":null}', '{"d":24321,"ep":1,"in":[0,1026],"p":260}', 'normal', '1', '2023-01-04T14:48Z', '')
15:49:17:193 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastannounced', '', 'dev', 1664101100 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:98:4d:58-01-0403'
15:49:17:195 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-01-04T14:48Z', 'dev', 1672842629 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:98:4d:58-01-0403'
15:49:17:197 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1655408406 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:98:4d:58-01-0403'
15:49:17:198 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'false', 'dev', 1672843029 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:98:4d:58-01-0403'
15:49:17:201 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/battery', '72', 'dev', 1672842196 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:98:4d:58-01-0403'
15:49:17:202 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/offset', '0', 'dev', 1655408286 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:98:4d:58-01-0403'
15:49:17:205 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('12', 'Pressure 12', 'ZHAPressure', 'lumi.weather', 'LUMI', '00:15:8d:00:07:98:4d:58-01-0403', '20191205', '{"lastupdated":"2023-01-04T14:20:22.332","pressure":1006}', '{"battery":72,"offset":0,"on":true,"reachable":false,"temperature":null}', '{"d":24321,"ep":1,"in":[0,1027],"p":260}', 'normal', '1', '2023-01-04T14:48Z', '')
15:49:17:210 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-01-04T14:48Z', 'dev', 1666039110 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:5f:64:40-01-0405'
15:49:17:212 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1652825526 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:5f:64:40-01-0405'
15:49:17:214 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'false', 'dev', 1672741989 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:5f:64:40-01-0405'
15:49:17:216 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/battery', '100', 'dev', 1652826081 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:5f:64:40-01-0405'
15:49:17:217 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/offset', '0', 'dev', 1655408286 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:5f:64:40-01-0405'
15:49:17:218 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('14', 'Humidity 14', 'ZHAHumidity', 'lumi.weather', 'LUMI', '00:15:8d:00:07:5f:64:40-01-0405', '20191205', '{"humidity":5784,"lastupdated":"2022-10-17T20:38:30.231"}', '{"battery":100,"offset":0,"on":true,"reachable":false,"temperature":null}', '{"d":24321,"ep":1,"in":[0,1029],"p":260}', 'normal', '1', '2023-01-04T14:48Z', '')
15:49:17:220 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-01-04T14:48Z', 'dev', 1666039110 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:5f:64:40-01-0402'
15:49:17:222 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1655408406 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:5f:64:40-01-0402'
15:49:17:222 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'false', 'dev', 1672741989 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:5f:64:40-01-0402'
15:49:17:224 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/battery', '100', 'dev', 1652826081 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:5f:64:40-01-0402'
15:49:17:225 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/offset', '0', 'dev', 1655408286 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:5f:64:40-01-0402'
15:49:17:226 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('13', 'Temperature 13', 'ZHATemperature', 'lumi.weather', 'LUMI', '00:15:8d:00:07:5f:64:40-01-0402', '20191205', '{"lastupdated":"2022-10-17T20:38:30.216","temperature":1904}', '{"battery":100,"offset":0,"on":true,"reachable":false,"temperature":null}', '{"d":24321,"ep":1,"in":[0,1026],"p":260}', 'normal', '1', '2023-01-04T14:48Z', '')
15:49:17:228 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-01-04T14:48Z', 'dev', 1666039110 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:5f:64:40-01-0403'
15:49:17:229 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1655408406 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:5f:64:40-01-0403'
15:49:17:230 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'false', 'dev', 1672741989 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:5f:64:40-01-0403'
15:49:17:231 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/battery', '100', 'dev', 1652826081 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:5f:64:40-01-0403'
15:49:17:232 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/offset', '0', 'dev', 1655408286 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:5f:64:40-01-0403'
15:49:17:233 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('15', 'Pressure 15', 'ZHAPressure', 'lumi.weather', 'LUMI', '00:15:8d:00:07:5f:64:40-01-0403', '20191205', '{"lastupdated":"2022-10-17T20:38:30.247","pressure":1008}', '{"battery":100,"offset":0,"on":true,"reachable":false,"temperature":null}', '{"d":24321,"ep":1,"in":[0,1027],"p":260}', 'normal', '1', '2023-01-04T14:48Z', '')
15:49:17:236 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-01-04T14:48Z', 'dev', 1666041137 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:65:66:db-01-0405'
15:49:17:237 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1655408406 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:65:66:db-01-0405'
15:49:17:238 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'false', 'dev', 1672741989 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:65:66:db-01-0405'
15:49:17:240 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/battery', '95', 'dev', 1670991096 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:65:66:db-01-0405'
15:49:17:241 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/offset', '0', 'dev', 1655408286 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:65:66:db-01-0405'
15:49:17:242 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('8', 'Humidity 8', 'ZHAHumidity', 'lumi.weather', 'LUMI', '00:15:8d:00:07:65:66:db-01-0405', '20191205', '{"humidity":6164,"lastupdated":"2022-10-17T21:12:17.852"}', '{"battery":95,"offset":0,"on":true,"reachable":false,"temperature":null}', '{"d":24321,"ep":1,"in":[0,1029],"p":260}', 'normal', '1', '2023-01-04T14:48Z', '')
15:49:17:245 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-01-04T14:48Z', 'dev', 1666041137 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:65:66:db-01-0402'
15:49:17:247 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1655408406 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:65:66:db-01-0402'
15:49:17:248 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'false', 'dev', 1672741989 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:65:66:db-01-0402'
15:49:17:250 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/battery', '95', 'dev', 1670991096 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:65:66:db-01-0402'
15:49:17:251 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/offset', '0', 'dev', 1655408286 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:65:66:db-01-0402'
15:49:17:253 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('7', 'Temperature 7', 'ZHATemperature', 'lumi.weather', 'LUMI', '00:15:8d:00:07:65:66:db-01-0402', '20191205', '{"lastupdated":"2022-10-17T21:12:17.836","temperature":2007}', '{"battery":95,"offset":0,"on":true,"reachable":false,"temperature":null}', '{"d":24321,"ep":1,"in":[0,1026],"p":260}', 'normal', '1', '2023-01-04T14:48Z', '')
15:49:17:256 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-01-04T14:48Z', 'dev', 1666041137 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:65:66:db-01-0403'
15:49:17:257 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1655408406 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:65:66:db-01-0403'
15:49:17:258 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'false', 'dev', 1672741989 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:65:66:db-01-0403'
15:49:17:259 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/battery', '95', 'dev', 1670991096 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:65:66:db-01-0403'
15:49:17:260 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/offset', '0', 'dev', 1655408286 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:65:66:db-01-0403'
15:49:17:261 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('9', 'Pressure 9', 'ZHAPressure', 'lumi.weather', 'LUMI', '00:15:8d:00:07:65:66:db-01-0403', '20191205', '{"lastupdated":"2022-10-17T21:12:17.866","pressure":1006}', '{"battery":95,"offset":0,"on":true,"reachable":false,"temperature":null}', '{"d":24321,"ep":1,"in":[0,1027],"p":260}', 'normal', '1', '2023-01-04T14:48Z', '')
15:49:17:264 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-01-04T14:48Z', 'dev', 1672842665 FROM sub_devices WHERE uniqueid = 'a4:c1:38:da:92:d1:fe:6d-01-0b04'
15:49:17:265 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1655567565 FROM sub_devices WHERE uniqueid = 'a4:c1:38:da:92:d1:fe:6d-01-0b04'
15:49:17:266 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'false', 'dev', 1672843733 FROM sub_devices WHERE uniqueid = 'a4:c1:38:da:92:d1:fe:6d-01-0b04'
15:49:17:268 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('47', 'Power 47', 'ZHAPower', 'TS011F', '_TZ3000_amdymr7l', 'a4:c1:38:da:92:d1:fe:6d-01-0b04', '', '{"current":368,"lastupdated":"2023-01-04T14:31:31.689","power":42,"voltage":233}', '{"on":true,"reachable":false}', '{"d":81,"ep":1,"in":[0,2820],"p":260}', 'normal', '1', '2023-01-04T14:48Z', '')
15:49:17:270 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-01-04T14:48Z', 'dev', 1672842665 FROM sub_devices WHERE uniqueid = 'a4:c1:38:da:92:d1:fe:6d-01-0702'
15:49:17:271 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1655567565 FROM sub_devices WHERE uniqueid = 'a4:c1:38:da:92:d1:fe:6d-01-0702'
15:49:17:272 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'false', 'dev', 1672843733 FROM sub_devices WHERE uniqueid = 'a4:c1:38:da:92:d1:fe:6d-01-0702'
15:49:17:273 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('48', 'Consumption 48', 'ZHAConsumption', 'TS011F', '_TZ3000_amdymr7l', 'a4:c1:38:da:92:d1:fe:6d-01-0702', '', '{"consumption":246860,"lastupdated":"2023-01-04T14:30:40.723"}', '{"on":true,"reachable":false}', '{"d":81,"ep":1,"in":[0,1794],"p":260}', 'normal', '1', '2023-01-04T14:48Z', '')
15:49:17:276 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-01-04T14:48Z', 'dev', 1672843618 FROM sub_devices WHERE uniqueid = 'a4:c1:38:b9:9d:9c:c0:e3-01-0b04'
15:49:17:277 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1665870766 FROM sub_devices WHERE uniqueid = 'a4:c1:38:b9:9d:9c:c0:e3-01-0b04'
15:49:17:278 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'false', 'dev', 1672843697 FROM sub_devices WHERE uniqueid = 'a4:c1:38:b9:9d:9c:c0:e3-01-0b04'
15:49:17:280 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('51', 'Power 51', 'ZHAPower', 'TS011F', '_TZ3000_amdymr7l', 'a4:c1:38:b9:9d:9c:c0:e3-01-0b04', '', '{"current":0,"lastupdated":"2023-01-04T14:42:42.973","power":0,"voltage":234}', '{"on":true,"reachable":false}', '{"d":81,"ep":1,"in":[0,2820],"p":260}', 'normal', '1', '2023-01-04T14:48Z', '')
15:49:17:283 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-01-04T14:48Z', 'dev', 1672843618 FROM sub_devices WHERE uniqueid = 'a4:c1:38:b9:9d:9c:c0:e3-01-0702'
15:49:17:284 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1665870766 FROM sub_devices WHERE uniqueid = 'a4:c1:38:b9:9d:9c:c0:e3-01-0702'
15:49:17:285 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'false', 'dev', 1672843697 FROM sub_devices WHERE uniqueid = 'a4:c1:38:b9:9d:9c:c0:e3-01-0702'
15:49:17:286 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('52', 'Consumption 52', 'ZHAConsumption', 'TS011F', '_TZ3000_amdymr7l', 'a4:c1:38:b9:9d:9c:c0:e3-01-0702', '', '{"consumption":870,"lastupdated":"2023-01-04T14:45:45.408"}', '{"on":true,"reachable":false}', '{"d":81,"ep":1,"in":[0,1794],"p":260}', 'normal', '1', '2023-01-04T14:48Z', '')
15:49:17:289 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastannounced', '', 'dev', 1671486250 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:65:7e:8b-01-0405'
15:49:17:290 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-01-04T14:48Z', 'dev', 1671486398 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:65:7e:8b-01-0405'
15:49:17:291 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1655408406 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:65:7e:8b-01-0405'
15:49:17:292 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'false', 'dev', 1672741989 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:65:7e:8b-01-0405'
15:49:17:293 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/battery', '100', 'dev', 1652827421 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:65:7e:8b-01-0405'
15:49:17:293 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/offset', '0', 'dev', 1655408286 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:65:7e:8b-01-0405'
15:49:17:295 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('18', 'Humidity 18', 'ZHAHumidity', 'lumi.weather', 'LUMI', '00:15:8d:00:07:65:7e:8b-01-0405', '20191205', '{"humidity":3794,"lastupdated":"2022-12-19T21:46:38.435"}', '{"battery":100,"offset":0,"on":true,"reachable":false,"temperature":null}', '{"d":24321,"ep":1,"in":[0,1029],"p":260}', 'normal', '1', '2023-01-04T14:48Z', '')
15:49:17:297 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastannounced', '', 'dev', 1671486250 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:65:7e:8b-01-0402'
15:49:17:299 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-01-04T14:48Z', 'dev', 1671486398 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:65:7e:8b-01-0402'
15:49:17:300 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1655408406 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:65:7e:8b-01-0402'
15:49:17:300 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'false', 'dev', 1672741989 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:65:7e:8b-01-0402'
15:49:17:302 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/battery', '100', 'dev', 1652827421 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:65:7e:8b-01-0402'
15:49:17:303 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/offset', '0', 'dev', 1655408286 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:65:7e:8b-01-0402'
15:49:17:304 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('17', 'Temperature 17', 'ZHATemperature', 'lumi.weather', 'LUMI', '00:15:8d:00:07:65:7e:8b-01-0402', '20191205', '{"lastupdated":"2022-12-19T21:46:38.392","temperature":2607}', '{"battery":100,"offset":0,"on":true,"reachable":false,"temperature":null}', '{"d":24321,"ep":1,"in":[0,1026],"p":260}', 'normal', '1', '2023-01-04T14:48Z', '')
15:49:17:307 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastannounced', '', 'dev', 1671486250 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:65:7e:8b-01-0403'
15:49:17:308 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-01-04T14:48Z', 'dev', 1671486398 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:65:7e:8b-01-0403'
15:49:17:309 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1655408406 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:65:7e:8b-01-0403'
15:49:17:310 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'false', 'dev', 1672741990 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:65:7e:8b-01-0403'
15:49:17:311 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/battery', '100', 'dev', 1652827421 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:65:7e:8b-01-0403'
15:49:17:312 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/offset', '0', 'dev', 1655408286 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:65:7e:8b-01-0403'
15:49:17:313 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('19', 'Pressure 19', 'ZHAPressure', 'lumi.weather', 'LUMI', '00:15:8d:00:07:65:7e:8b-01-0403', '20191205', '{"lastupdated":"2022-12-19T21:46:38.455","pressure":991}', '{"battery":100,"offset":0,"on":true,"reachable":false,"temperature":null}', '{"d":24321,"ep":1,"in":[0,1027],"p":260}', 'normal', '1', '2023-01-04T14:48Z', '')
15:49:17:316 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastannounced', '', 'dev', 1665858402 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:77:c8:7e-01-0405'
15:49:17:317 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-01-04T14:48Z', 'dev', 1666040257 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:77:c8:7e-01-0405'
15:49:17:318 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1655408406 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:77:c8:7e-01-0405'
15:49:17:319 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'false', 'dev', 1672741989 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:77:c8:7e-01-0405'
15:49:17:320 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/battery', '85', 'dev', 1671875480 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:77:c8:7e-01-0405'
15:49:17:321 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/offset', '0', 'dev', 1655408286 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:77:c8:7e-01-0405'
15:49:17:322 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('26', 'Humidity 26', 'ZHAHumidity', 'lumi.weather', 'LUMI', '00:15:8d:00:07:77:c8:7e-01-0405', '20191205', '{"humidity":8314,"lastupdated":"2022-10-17T20:48:42.852"}', '{"battery":85,"offset":0,"on":true,"reachable":false,"temperature":null}', '{"d":24321,"ep":1,"in":[0,1029],"p":260}', 'normal', '1', '2023-01-04T14:48Z', '')
15:49:17:325 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastannounced', '', 'dev', 1665858402 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:77:c8:7e-01-0402'
15:49:17:326 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-01-04T14:48Z', 'dev', 1666040257 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:77:c8:7e-01-0402'
15:49:17:327 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1655408406 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:77:c8:7e-01-0402'
15:49:17:328 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'false', 'dev', 1672741989 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:77:c8:7e-01-0402'
15:49:17:329 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/battery', '85', 'dev', 1671875481 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:77:c8:7e-01-0402'
15:49:17:330 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/offset', '0', 'dev', 1655408286 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:77:c8:7e-01-0402'
15:49:17:331 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('25', 'Temperature 25', 'ZHATemperature', 'lumi.weather', 'LUMI', '00:15:8d:00:07:77:c8:7e-01-0402', '20191205', '{"lastupdated":"2022-10-17T20:48:42.834","temperature":991}', '{"battery":85,"offset":0,"on":true,"reachable":false,"temperature":null}', '{"d":24321,"ep":1,"in":[0,1026],"p":260}', 'normal', '1', '2023-01-04T14:48Z', '')
15:49:17:334 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastannounced', '', 'dev', 1665858402 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:77:c8:7e-01-0403'
15:49:17:335 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-01-04T14:48Z', 'dev', 1666040257 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:77:c8:7e-01-0403'
15:49:17:336 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1655408406 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:77:c8:7e-01-0403'
15:49:17:336 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'false', 'dev', 1672741990 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:77:c8:7e-01-0403'
15:49:17:338 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/battery', '85', 'dev', 1671875481 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:77:c8:7e-01-0403'
15:49:17:339 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/offset', '0', 'dev', 1655408286 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:77:c8:7e-01-0403'
15:49:17:340 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('27', 'Pressure 27', 'ZHAPressure', 'lumi.weather', 'LUMI', '00:15:8d:00:07:77:c8:7e-01-0403', '20191205', '{"lastupdated":"2022-10-17T20:48:42.867","pressure":1005}', '{"battery":85,"offset":0,"on":true,"reachable":false,"temperature":null}', '{"d":24321,"ep":1,"in":[0,1027],"p":260}', 'normal', '1', '2023-01-04T14:48Z', '')
15:49:17:342 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastannounced', '', 'dev', 1671018165 FROM sub_devices WHERE uniqueid = '54:ef:44:10:00:25:d6:b4-01-0500'
15:49:17:344 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-01-04T14:48Z', 'dev', 1672050315 FROM sub_devices WHERE uniqueid = '54:ef:44:10:00:25:d6:b4-01-0500'
15:49:17:345 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1649281912 FROM sub_devices WHERE uniqueid = '54:ef:44:10:00:25:d6:b4-01-0500'
15:49:17:346 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'false', 'dev', 1672741990 FROM sub_devices WHERE uniqueid = '54:ef:44:10:00:25:d6:b4-01-0500'
15:49:17:347 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/battery', '93', 'dev', 1672127542 FROM sub_devices WHERE uniqueid = '54:ef:44:10:00:25:d6:b4-01-0500'
15:49:17:348 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/enrolled', '0', 'dev', 1672050328 FROM sub_devices WHERE uniqueid = '54:ef:44:10:00:25:d6:b4-01-0500'
15:49:17:348 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/pending', '48', 'dev', 1662789551 FROM sub_devices WHERE uniqueid = '54:ef:44:10:00:25:d6:b4-01-0500'
15:49:17:350 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('32', 'OpenClose 32', 'ZHAOpenClose', 'lumi.magnet.acn001', 'LUMI', '54:ef:44:10:00:25:d6:b4-01-0500', '0.0.0_0004', '{"lastupdated":"2022-12-26T10:25:28.368","open":false}', '{"battery":93,"enrolled":0,"on":true,"pending":48,"reachable":false}', '{"d":1026,"ep":1,"in":[0,1,1280,64704],"p":260}', 'normal', '1', '2023-01-04T14:48Z', '')
15:49:17:352 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastannounced', '', 'dev', 1671842691 FROM sub_devices WHERE uniqueid = '54:ef:44:10:00:25:b9:30-01-0500'
15:49:17:353 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-01-04T14:48Z', 'dev', 1672049624 FROM sub_devices WHERE uniqueid = '54:ef:44:10:00:25:b9:30-01-0500'
15:49:17:354 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1649281912 FROM sub_devices WHERE uniqueid = '54:ef:44:10:00:25:b9:30-01-0500'
15:49:17:355 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'false', 'dev', 1672741990 FROM sub_devices WHERE uniqueid = '54:ef:44:10:00:25:b9:30-01-0500'
15:49:17:356 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/battery', '87', 'dev', 1672134627 FROM sub_devices WHERE uniqueid = '54:ef:44:10:00:25:b9:30-01-0500'
15:49:17:357 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/enrolled', '3', 'dev', 1672049624 FROM sub_devices WHERE uniqueid = '54:ef:44:10:00:25:b9:30-01-0500'
15:49:17:358 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/pending', '48', 'dev', 1655408286 FROM sub_devices WHERE uniqueid = '54:ef:44:10:00:25:b9:30-01-0500'
15:49:17:359 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('33', 'OpenClose 33', 'ZHAOpenClose', 'lumi.magnet.acn001', 'LUMI', '54:ef:44:10:00:25:b9:30-01-0500', '0.0.0_0004', '{"lastupdated":"2022-12-26T10:13:44.659","open":false}', '{"battery":87,"enrolled":3,"on":true,"pending":48,"reachable":false}', '{"d":1026,"ep":1,"in":[0,1,1280,64704],"p":260}', 'normal', '1', '2023-01-04T14:48Z', '')
15:49:17:362 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastannounced', '', 'dev', 1671337792 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:65:79:33-01-0405'
15:49:17:363 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-01-04T14:48Z', 'dev', 1671337792 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:65:79:33-01-0405'
15:49:17:364 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1655408406 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:65:79:33-01-0405'
15:49:17:365 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'false', 'dev', 1672741989 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:65:79:33-01-0405'
15:49:17:366 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/battery', '85', 'dev', 1672066713 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:65:79:33-01-0405'
15:49:17:367 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/offset', '0', 'dev', 1655408286 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:65:79:33-01-0405'
15:49:17:368 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('29', 'Humidity 29', 'ZHAHumidity', 'lumi.weather', 'LUMI', '00:15:8d:00:07:65:79:33-01-0405', '20191205', '{"humidity":2152,"lastupdated":"2022-12-18T03:28:35.064"}', '{"battery":85,"offset":0,"on":true,"reachable":false,"temperature":null}', '{"d":24321,"ep":1,"in":[0,1029],"p":260}', 'normal', '1', '2023-01-04T14:48Z', '')
15:49:17:371 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastannounced', '', 'dev', 1671337792 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:65:79:33-01-0402'
15:49:17:372 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-01-04T14:48Z', 'dev', 1671337792 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:65:79:33-01-0402'
15:49:17:373 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1655408406 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:65:79:33-01-0402'
15:49:17:374 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'false', 'dev', 1672741989 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:65:79:33-01-0402'
15:49:17:375 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/battery', '85', 'dev', 1672066713 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:65:79:33-01-0402'
15:49:17:376 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/offset', '0', 'dev', 1655408286 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:65:79:33-01-0402'
15:49:17:377 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('28', 'Temperature 28', 'ZHATemperature', 'lumi.weather', 'LUMI', '00:15:8d:00:07:65:79:33-01-0402', '20191205', '{"lastupdated":"2022-12-18T03:28:35.033","temperature":723}', '{"battery":85,"offset":0,"on":true,"reachable":false,"temperature":null}', '{"d":24321,"ep":1,"in":[0,1026],"p":260}', 'normal', '1', '2023-01-04T14:48Z', '')
15:49:17:380 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastannounced', '', 'dev', 1671337792 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:65:79:33-01-0403'
15:49:17:381 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-01-04T14:48Z', 'dev', 1671337792 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:65:79:33-01-0403'
15:49:17:382 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1655408406 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:65:79:33-01-0403'
15:49:17:382 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'false', 'dev', 1672741990 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:65:79:33-01-0403'
15:49:17:384 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/battery', '85', 'dev', 1672066713 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:65:79:33-01-0403'
15:49:17:385 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/offset', '0', 'dev', 1655408286 FROM sub_devices WHERE uniqueid = '00:15:8d:00:07:65:79:33-01-0403'
15:49:17:386 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('30', 'Pressure 30', 'ZHAPressure', 'lumi.weather', 'LUMI', '00:15:8d:00:07:65:79:33-01-0403', '20191205', '{"lastupdated":"2022-12-18T03:28:35.084","pressure":1006}', '{"battery":85,"offset":0,"on":true,"reachable":false,"temperature":null}', '{"d":24321,"ep":1,"in":[0,1027],"p":260}', 'normal', '1', '2023-01-04T14:48Z', '')
15:49:17:395 DB saved in 289 ms
15:49:17:396 Daylight now: solarNoon, status: 170, daylight: 1, dark: 0
15:49:18:104 Skip idle timer callback, too early: elapsed 708 msec
15:49:20:753 Websocket 192.168.1.38:44542 send message: {"attr":{"id":"2","lastannounced":null,"lastseen":"2023-01-04T14:49Z","manufacturername":"dresden elektronik","modelid":"ConBee II","name":"Configuration tool 2","swversion":"0x26780700","type":"Configuration tool","uniqueid":"00:21:2e:ff:ff:07:88:de-01"},"e":"changed","id":"2","r":"lights","t":"event","uniqueid":"00:21:2e:ff:ff:07:88:de-01"} (ret = 344)
15:49:21:104 Idle timer triggered
15:49:21:116 node 054EF4410002C77B4 leave wait state
15:49:22:560 CTRL skip creating node 0x540F57FFFEF92C28 while permit join is disabled
15:49:22:666 unhandled APS-DATA.confirm id: 202 status 0xE1
15:49:27:104 Daylight now: solarNoon, status: 170, daylight: 1, dark: 0
15:49:34:079 CTRL skip creating node 0x540F57FFFEF92C28 while permit join is disabled
15:49:37:104 Daylight now: solarNoon, status: 170, daylight: 1, dark: 0
15:49:38:877 node 0A4C138B99D9CC0E3 leave wait state
15:49:39:965 unhandled APS-DATA.confirm id: 233 status 0xE1
15:49:45:600 CTRL skip creating node 0x540F57FFFEF92C28 while permit join is disabled
15:49:47:105 Daylight now: solarNoon, status: 170, daylight: 1, dark: 0
15:49:51:104 sql exec SELECT conf FROM zbconf ORDER BY rowid desc limit 1
15:49:51:106 Idle timer triggered
15:49:54:956 node 0A4C138DA92D1FE6D leave wait state
15:49:55:857 unhandled APS-DATA.confirm id: 18 status 0xE1
15:49:57:109 Daylight now: solarNoon, status: 170, daylight: 1, dark: 0
15:49:57:124 CTRL skip creating node 0x540F57FFFEF92C28 while permit join is disabled
15:50:07:104 Daylight now: solarNoon, status: 170, daylight: 1, dark: 0
15:50:08:777 CTRL skip creating node 0x540F57FFFEF92C28 while permit join is disabled
15:50:11:104 Skip idle timer callback, too early: elapsed 899 msec
15:50:12:413 unknown node 0x540F57FFFEF92C28 (0xDE99), lqi: 255
15:50:12:414 APS-DATA.indication from unknown node 0x540F57FFFEF92C28
15:50:12:613 unknown node 0x540F57FFFEF92C28 (0xDE99), lqi: 255
15:50:12:613 APS-DATA.indication from unknown node 0x540F57FFFEF92C28
15:50:12:811 unknown node 0x540F57FFFEF92C28 (0xDE99), lqi: 255
15:50:12:812 APS-DATA.indication from unknown node 0x540F57FFFEF92C28
15:50:13:011 unknown node 0x540F57FFFEF92C28 (0xDE99), lqi: 255
15:50:13:012 APS-DATA.indication from unknown node 0x540F57FFFEF92C28
15:50:13:213 unknown node 0x540F57FFFEF92C28 (0xDE99), lqi: 255
15:50:13:213 APS-DATA.indication from unknown node 0x540F57FFFEF92C28
15:50:13:432 unknown node 0x540F57FFFEF92C28 (0xDE99), lqi: 255
15:50:13:432 APS-DATA.indication from unknown node 0x540F57FFFEF92C28
15:50:13:610 unknown node 0x540F57FFFEF92C28 (0xDE99), lqi: 255
15:50:13:610 APS-DATA.indication from unknown node 0x540F57FFFEF92C28
15:50:13:810 unknown node 0x540F57FFFEF92C28 (0xDE99), lqi: 255
15:50:13:810 APS-DATA.indication from unknown node 0x540F57FFFEF92C28
15:50:14:022 unknown node 0x540F57FFFEF92C28 (0xDE99), lqi: 255
15:50:14:023 APS-DATA.indication from unknown node 0x540F57FFFEF92C28
15:50:14:209 unknown node 0x540F57FFFEF92C28 (0xDE99), lqi: 255
15:50:14:209 APS-DATA.indication from unknown node 0x540F57FFFEF92C28
15:50:14:408 unknown node 0x540F57FFFEF92C28 (0xDE99), lqi: 255
15:50:14:408 APS-DATA.indication from unknown node 0x540F57FFFEF92C28
15:50:14:631 unknown node 0x540F57FFFEF92C28 (0xDE99), lqi: 255
15:50:14:631 APS-DATA.indication from unknown node 0x540F57FFFEF92C28
15:50:14:805 unknown node 0x540F57FFFEF92C28 (0xDE99), lqi: 255
15:50:14:805 APS-DATA.indication from unknown node 0x540F57FFFEF92C28
15:50:15:006 unknown node 0x540F57FFFEF92C28 (0xDE99), lqi: 255
15:50:15:006 APS-DATA.indication from unknown node 0x540F57FFFEF92C28
15:50:15:205 unknown node 0x540F57FFFEF92C28 (0xDE99), lqi: 255
15:50:15:205 APS-DATA.indication from unknown node 0x540F57FFFEF92C28
15:50:16:118 [Master] read param with arg 0x19
15:50:17:105 Daylight now: solarNoon, status: 170, daylight: 1, dark: 0
15:50:20:298 CTRL skip creating node 0x540F57FFFEF92C28 while permit join is disabled
15:50:21:105 DB save zll database items 0x00000001
15:50:21:106 DB saved in 1 ms
15:50:22:105 Idle timer triggered
15:50:23:173 node 054EF4410002C77B4 leave wait state
15:50:23:300 unhandled APS-DATA.confirm id: 88 status 0xE1
15:50:27:105 Daylight now: solarNoon, status: 170, daylight: 1, dark: 0
15:50:30:016 Websocket 192.168.1.38:44542 send message: {"attr":{"id":"2","lastannounced":null,"lastseen":"2023-01-04T14:50Z","manufacturername":"dresden elektronik","modelid":"ConBee II","name":"Configuration tool 2","swversion":"0x26780700","type":"Configuration tool","uniqueid":"00:21:2e:ff:ff:07:88:de-01"},"e":"changed","id":"2","r":"lights","t":"event","uniqueid":"00:21:2e:ff:ff:07:88:de-01"} (ret = 344)
15:50:31:836 CTRL skip creating node 0x540F57FFFEF92C28 while permit join is disabled
15:50:37:105 Daylight now: solarNoon, status: 170, daylight: 1, dark: 0
15:50:39:463 [INFO] - No button map for: TS011F, unicast to: 0x0000, endpoint: 0x01, cluster: 0x0B04, command: 0x0A, payload: 0805210000, zclSeq: 141
15:50:39:464 ZCL attribute report 0xA4C138B99D9CC0E3 for cluster: 0x0B04, ep: 0x01, frame control: 0x18, mfcode: 0x0000 
15:50:39:465 	payload: 0805210000
15:50:39:466 Websocket 192.168.1.38:44542 send message: {"attr":{"id":"6","lastannounced":null,"lastseen":"2023-01-04T14:50Z","manufacturername":"_TZ3000_amdymr7l","modelid":"TS011F","name":"Smart plug 6","swversion":null,"type":"Smart plug","uniqueid":"a4:c1:38:b9:9d:9c:c0:e3-01"},"e":"changed","id":"6","r":"lights","t":"event","uniqueid":"a4:c1:38:b9:9d:9c:c0:e3-01"} (ret = 315)
15:50:39:468 Websocket 192.168.1.38:44542 send message: {"e":"changed","id":"6","r":"lights","state":{"alert":"none","on":false,"reachable":true},"t":"event","uniqueid":"a4:c1:38:b9:9d:9c:c0:e3-01"} (ret = 142)
15:50:39:471 Websocket 192.168.1.38:44542 send message: {"attr":{"id":"51","lastannounced":null,"lastseen":"2023-01-04T14:50Z","manufacturername":"_TZ3000_amdymr7l","modelid":"TS011F","name":"Power 51","swversion":null,"type":"ZHAPower","uniqueid":"a4:c1:38:b9:9d:9c:c0:e3-01-0b04"},"e":"changed","id":"51","r":"sensors","t":"event","uniqueid":"a4:c1:38:b9:9d:9c:c0:e3-01-0b04"} (ret = -1095390792)
15:50:39:473 Websocket 192.168.1.38:44542 send message: {"config":{"on":true,"reachable":true},"e":"changed","id":"51","r":"sensors","t":"event","uniqueid":"a4:c1:38:b9:9d:9c:c0:e3-01-0b04"} (ret = -1095390792)
15:50:39:475 Websocket 192.168.1.38:44542 send message: {"e":"changed","id":"51","r":"sensors","state":{"current":0,"lastupdated":"2023-01-04T14:50:39.461","power":0,"voltage":234},"t":"event","uniqueid":"a4:c1:38:b9:9d:9c:c0:e3-01-0b04"} (ret = -1095390792)
15:50:39:505 Websocket 192.168.1.38:44542 send message: {"attr":{"id":"52","lastannounced":null,"lastseen":"2023-01-04T14:50Z","manufacturername":"_TZ3000_amdymr7l","modelid":"TS011F","name":"Consumption 52","swversion":null,"type":"ZHAConsumption","uniqueid":"a4:c1:38:b9:9d:9c:c0:e3-01-0702"},"e":"changed","id":"52","r":"sensors","t":"event","uniqueid":"a4:c1:38:b9:9d:9c:c0:e3-01-0702"} (ret = -1095389920)
15:50:39:508 Websocket 192.168.1.38:44542 send message: {"config":{"on":true,"reachable":true},"e":"changed","id":"52","r":"sensors","t":"event","uniqueid":"a4:c1:38:b9:9d:9c:c0:e3-01-0702"} (ret = -1095389920)
15:50:39:516 [INFO] - No button map for: TS011F, unicast to: 0x0000, endpoint: 0x01, cluster: 0x0702, command: 0x0A, payload: 000025570000000000, zclSeq: 140
15:50:39:519 ZCL attribute report 0xA4C138B99D9CC0E3 for cluster: 0x0702, ep: 0x01, frame control: 0x18, mfcode: 0x0000 
15:50:39:520 	payload: 000025570000000000
15:50:39:522 Websocket 192.168.1.38:44542 send message: {"e":"changed","id":"52","r":"sensors","state":{"consumption":870,"lastupdated":"2023-01-04T14:50:39.514"},"t":"event","uniqueid":"a4:c1:38:b9:9d:9c:c0:e3-01-0702"} (ret = -1095390792)
15:50:39:855 add task 179 type 21 to 0xA4C138B99D9CC0E3 cluster 0x0004 req.id 120
15:50:40:921 0xA4C138B99D9CC0E3 error APSDE-DATA.confirm: 0xE1 on task
15:50:40:922 Erase task req-id: 120, type: 21 zcl seqno: 25 send time 1, profileId: 0x0104, clusterId: 0x0004
15:50:40:922 unhandled APS-DATA.confirm id: 120 status 0xE1
15:50:42:427 [INFO] - No button map for: TS011F, unicast to: 0x0000, endpoint: 0x01, cluster: 0x0B04, command: 0x0A, payload: 0805210000, zclSeq: 141
15:50:42:428 ZCL attribute report 0xA4C138B99D9CC0E3 for cluster: 0x0B04, ep: 0x01, frame control: 0x18, mfcode: 0x0000 
15:50:42:429 	payload: 0805210000
15:50:42:430 Websocket 192.168.1.38:44542 send message: {"e":"changed","id":"51","r":"sensors","state":{"current":0,"lastupdated":"2023-01-04T14:50:42.425","power":0,"voltage":234},"t":"event","uniqueid":"a4:c1:38:b9:9d:9c:c0:e3-01-0b04"} (ret = -1095390792)
15:50:42:507 [INFO] - No button map for: TS011F, unicast to: 0x0000, endpoint: 0x01, cluster: 0x0702, command: 0x0A, payload: 000025570000000000, zclSeq: 140
15:50:42:509 ZCL attribute report 0xA4C138B99D9CC0E3 for cluster: 0x0702, ep: 0x01, frame control: 0x18, mfcode: 0x0000 
15:50:42:510 	payload: 000025570000000000
15:50:42:511 Websocket 192.168.1.38:44542 send message: {"e":"changed","id":"52","r":"sensors","state":{"consumption":870,"lastupdated":"2023-01-04T14:50:42.506"},"t":"event","uniqueid":"a4:c1:38:b9:9d:9c:c0:e3-01-0702"} (ret = -1095390792)
15:50:43:335 CTRL skip creating node 0x540F57FFFEF92C28 while permit join is disabled
15:50:47:105 Daylight now: solarNoon, status: 170, daylight: 1, dark: 0
15:50:50:648 unhandled APS-DATA.confirm id: 154 status 0xE1
15:50:52:104 Idle timer triggered
15:50:52:106 Force binding of attribute reporting for node Smart plug 6
15:50:52:106 Force read attributes for ZHAOpenClose SensorNode OpenClose 41
15:50:52:107 Force read attributes for ZHAOpenClose SensorNode Window / Door Sensor
15:50:52:108 Force read attributes for ZHAPower SensorNode Power 51
15:50:53:105 sql exec SELECT conf FROM zbconf ORDER BY rowid desc limit 1
15:50:53:107 Wait 1s till query finished
15:50:53:684 unhandled APS-DATA.confirm id: 162 status 0xE1
15:50:54:105 Idle timer triggered
15:50:54:751 unhandled APS-DATA.confirm id: 166 status 0xE1
15:50:55:840 unhandled APS-DATA.confirm id: 169 status 0xE1
15:50:56:213 node 0A4C138DA92D1FE6D leave wait state
15:50:56:924 unhandled APS-DATA.confirm id: 182 status 0xE1
15:50:57:105 Daylight now: solarNoon, status: 170, daylight: 1, dark: 0
15:50:57:254 CTRL skip creating node 0x540F57FFFEF92C28 while permit join is disabled
15:50:57:964 unhandled APS-DATA.confirm id: 188 status 0xE1
15:50:58:008 unhandled APS-DATA.confirm id: 186 status 0xE1
15:50:59:087 unhandled APS-DATA.confirm id: 190 status 0xE1
15:51:00:165 unhandled APS-DATA.confirm id: 193 status 0xE1
15:51:01:256 unhandled APS-DATA.confirm id: 196 status 0xE1
15:51:02:357 unhandled APS-DATA.confirm id: 199 status 0xE1
15:51:03:435 unhandled APS-DATA.confirm id: 202 status 0xE1
15:51:04:516 unhandled APS-DATA.confirm id: 205 status 0xE1
15:51:05:598 unhandled APS-DATA.confirm id: 208 status 0xE1
15:51:05:606 Websocket 192.168.1.38:44542 send message: {"e":"changed","id":"6","r":"lights","state":{"alert":"none","on":false,"reachable":false},"t":"event","uniqueid":"a4:c1:38:b9:9d:9c:c0:e3-01"} (ret = 143)
15:51:05:609 Websocket 192.168.1.38:44542 send message: {"config":{"on":true,"reachable":false},"e":"changed","id":"51","r":"sensors","t":"event","uniqueid":"a4:c1:38:b9:9d:9c:c0:e3-01-0b04"} (ret = -1095389920)
15:51:05:611 Websocket 192.168.1.38:44542 send message: {"config":{"on":true,"reachable":false},"e":"changed","id":"52","r":"sensors","t":"event","uniqueid":"a4:c1:38:b9:9d:9c:c0:e3-01-0702"} (ret = -1095389920)
15:51:07:105 Daylight now: solarNoon, status: 170, daylight: 1, dark: 0
15:51:08:776 CTRL skip creating node 0x540F57FFFEF92C28 while permit join is disabled
15:51:16:117 [Master] read param with arg 0x19
15:51:17:104 Daylight now: solarNoon, status: 170, daylight: 1, dark: 0
15:51:20:295 CTRL skip creating node 0x540F57FFFEF92C28 while permit join is disabled
15:51:24:104 Idle timer triggered
15:51:24:107 Force read attributes for ZHAOpenClose SensorNode OpenClose 41
15:51:24:108 Force read attributes for ZHAOpenClose SensorNode Window / Door Sensor
15:51:24:133 node 054EF4410002C77B4 leave wait state
15:51:24:248 unhandled APS-DATA.confirm id: 250 status 0xE1
15:51:27:105 Daylight now: solarNoon, status: 170, daylight: 1, dark: 0
15:51:27:467 [INFO] - No button map for: TS011F, unicast to: 0x0000, endpoint: 0x01, cluster: 0x0B04, command: 0x0A, payload: 0B05290000, zclSeq: 142
15:51:27:468 ZCL attribute report 0xA4C138B99D9CC0E3 for cluster: 0x0B04, ep: 0x01, frame control: 0x18, mfcode: 0x0000 
15:51:27:469 	payload: 0b05290000
15:51:27:470 Websocket 192.168.1.38:44542 send message: {"e":"changed","id":"6","r":"lights","state":{"alert":"none","on":false,"reachable":true},"t":"event","uniqueid":"a4:c1:38:b9:9d:9c:c0:e3-01"} (ret = 142)
15:51:27:471 Websocket 192.168.1.38:44542 send message: {"config":{"on":true,"reachable":true},"e":"changed","id":"51","r":"sensors","t":"event","uniqueid":"a4:c1:38:b9:9d:9c:c0:e3-01-0b04"} (ret = -1095390792)
15:51:27:474 Websocket 192.168.1.38:44542 send message: {"e":"changed","id":"51","r":"sensors","state":{"current":0,"lastupdated":"2023-01-04T14:51:27.465","power":0,"voltage":234},"t":"event","uniqueid":"a4:c1:38:b9:9d:9c:c0:e3-01-0b04"} (ret = -1095390792)
15:51:27:476 Websocket 192.168.1.38:44542 send message: {"config":{"on":true,"reachable":true},"e":"changed","id":"52","r":"sensors","t":"event","uniqueid":"a4:c1:38:b9:9d:9c:c0:e3-01-0702"} (ret = -1095390792)
15:51:30:104 DB save zll database items 0x00000081
15:51:30:105 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-01-04T14:50Z', 'dev', 1672843839 FROM sub_devices WHERE uniqueid = 'a4:c1:38:b9:9d:9c:c0:e3-01'
15:51:30:111 DB sql exec REPLACE INTO nodes (id, state, mac, name, groups, endpoint, modelid, manufacturername, swbuildid, ritems) VALUES ('6', 'normal', 'a4:c1:38:b9:9d:9c:c0:e3-01', 'Smart plug 6', '', '1', 'TS011F', '_TZ3000_amdymr7l', '', '{"attr/id":"6","attr/lastannounced":null,"attr/lastseen":"2023-01-04T14:50Z","attr/manufacturername":"_TZ3000_amdymr7l","attr/modelid":"TS011F","attr/name":"Smart plug 6","attr/swversion":null,"attr/type":"Smart plug","attr/uniqueid":"a4:c1:38:b9:9d:9c:c0:e3-01","state/alert":"none","state/on":false,"state/reachable":true}')
15:51:30:115 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-01-04T14:50Z', 'dev', 1672843839 FROM sub_devices WHERE uniqueid = 'a4:c1:38:b9:9d:9c:c0:e3-01-0b04'
15:51:30:117 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1665870766 FROM sub_devices WHERE uniqueid = 'a4:c1:38:b9:9d:9c:c0:e3-01-0b04'
15:51:30:118 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'true', 'dev', 1672843887 FROM sub_devices WHERE uniqueid = 'a4:c1:38:b9:9d:9c:c0:e3-01-0b04'
15:51:30:121 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('51', 'Power 51', 'ZHAPower', 'TS011F', '_TZ3000_amdymr7l', 'a4:c1:38:b9:9d:9c:c0:e3-01-0b04', '', '{"current":0,"lastupdated":"2023-01-04T14:51:27.465","power":0,"voltage":234}', '{"on":true,"reachable":true}', '{"d":81,"ep":1,"in":[0,2820],"p":260}', 'normal', '1', '2023-01-04T14:50Z', '')
15:51:30:124 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'attr/lastseen', '2023-01-04T14:50Z', 'dev', 1672843839 FROM sub_devices WHERE uniqueid = 'a4:c1:38:b9:9d:9c:c0:e3-01-0702'
15:51:30:126 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/on', 'true', 'dev', 1665870766 FROM sub_devices WHERE uniqueid = 'a4:c1:38:b9:9d:9c:c0:e3-01-0702'
15:51:30:127 INSERT INTO resource_items (sub_device_id,item,value,source,timestamp) SELECT id, 'config/reachable', 'true', 'dev', 1672843887 FROM sub_devices WHERE uniqueid = 'a4:c1:38:b9:9d:9c:c0:e3-01-0702'
15:51:30:129 DB sql exec REPLACE INTO sensors (sid, name, type, modelid, manufacturername, uniqueid, swversion, state, config, fingerprint, deletedState, mode, lastseen, lastannounced) VALUES ('52', 'Consumption 52', 'ZHAConsumption', 'TS011F', '_TZ3000_amdymr7l', 'a4:c1:38:b9:9d:9c:c0:e3-01-0702', '', '{"consumption":870,"lastupdated":"2023-01-04T14:50:42.506"}', '{"on":true,"reachable":true}', '{"d":81,"ep":1,"in":[0,1794],"p":260}', 'normal', '1', '2023-01-04T14:50Z', '')
15:51:30:137 DB saved in 32 ms
15:51:30:461 [INFO] - No button map for: TS011F, unicast to: 0x0000, endpoint: 0x01, cluster: 0x0B04, command: 0x0A, payload: 0B05290000, zclSeq: 142
15:51:30:462 ZCL attribute report 0xA4C138B99D9CC0E3 for cluster: 0x0B04, ep: 0x01, frame control: 0x18, mfcode: 0x0000 
15:51:30:462 	payload: 0b05290000
15:51:30:463 Websocket 192.168.1.38:44542 send message: {"e":"changed","id":"51","r":"sensors","state":{"current":0,"lastupdated":"2023-01-04T14:51:30.460","power":0,"voltage":234},"t":"event","uniqueid":"a4:c1:38:b9:9d:9c:c0:e3-01-0b04"} (ret = -1095390792)
15:51:30:798 unhandled APS-DATA.confirm id: 17 status 0xE1
15:51:31:817 CTRL skip creating node 0x540F57FFFEF92C28 while permit join is disabled
15:51:31:870 unhandled APS-DATA.confirm id: 19 status 0xE1
15:51:32:951 unhandled APS-DATA.confirm id: 23 status 0xE1
15:51:34:040 unhandled APS-DATA.confirm id: 26 status 0xE1
15:51:35:126 unhandled APS-DATA.confirm id: 29 status 0xE1
15:51:36:202 unhandled APS-DATA.confirm id: 32 status 0xE1
15:51:37:105 Daylight now: solarNoon, status: 170, daylight: 1, dark: 0
15:51:37:284 unhandled APS-DATA.confirm id: 35 status 0xE1
15:51:37:546 [WARNING] - Missing cluster in sensor fingerprint: 0xA4C138B99D9CC0E3 - 0x93DB (TS011F), endpoint: 0x01, cluster: 0x0006, payload: 00001000, zclSeq: 143
15:51:37:548 [INFO] - No button map for: TS011F, unicast to: 0x0000, endpoint: 0x01, cluster: ONOFF (0x0006), command: ATTRIBUTE_REPORT (0x0A), payload: 00001000, zclSeq: 143
15:51:37:548 ZCL attribute report 0xA4C138B99D9CC0E3 for cluster: 0x0006, ep: 0x01, frame control: 0x18, mfcode: 0x0000 
15:51:37:548 	payload: 00001000
15:51:37:549 Websocket 192.168.1.38:44542 send message: {"e":"changed","id":"6","r":"lights","state":{"alert":"none","on":false,"reachable":true},"t":"event","uniqueid":"a4:c1:38:b9:9d:9c:c0:e3-01"} (ret = 142)
15:51:38:343 unhandled APS-DATA.confirm id: 38 status 0xE1
15:51:39:420 unhandled APS-DATA.confirm id: 42 status 0xE1
15:51:40:492 unhandled APS-DATA.confirm id: 45 status 0xE1
15:51:41:514 Websocket 192.168.1.38:44542 send message: {"attr":{"id":"2","lastannounced":null,"lastseen":"2023-01-04T14:51Z","manufacturername":"dresden elektronik","modelid":"ConBee II","name":"Configuration tool 2","swversion":"0x26780700","type":"Configuration tool","uniqueid":"00:21:2e:ff:ff:07:88:de-01"},"e":"changed","id":"2","r":"lights","t":"event","uniqueid":"00:21:2e:ff:ff:07:88:de-01"} (ret = 344)
15:51:41:558 unhandled APS-DATA.confirm id: 48 status 0xE1
15:51:42:641 unhandled APS-DATA.confirm id: 61 status 0xE1
15:51:43:334 CTRL skip creating node 0x540F57FFFEF92C28 while permit join is disabled
15:51:43:473 [WARNING] - Missing cluster in sensor fingerprint: 0xA4C138B99D9CC0E3 - 0x93DB (TS011F), endpoint: 0x01, cluster: 0x0006, payload: 00001000, zclSeq: 143
15:51:43:475 [INFO] - No button map for: TS011F, unicast to: 0x0000, endpoint: 0x01, cluster: ONOFF (0x0006), command: ATTRIBUTE_REPORT (0x0A), payload: 00001000, zclSeq: 143
15:51:43:476 ZCL attribute report 0xA4C138B99D9CC0E3 for cluster: 0x0006, ep: 0x01, frame control: 0x18, mfcode: 0x0000 
15:51:43:476 	payload: 00001000
15:51:43:477 Websocket 192.168.1.38:44542 send message: {"attr":{"id":"6","lastannounced":null,"lastseen":"2023-01-04T14:51Z","manufacturername":"_TZ3000_amdymr7l","modelid":"TS011F","name":"Smart plug 6","swversion":null,"type":"Smart plug","uniqueid":"a4:c1:38:b9:9d:9c:c0:e3-01"},"e":"changed","id":"6","r":"lights","t":"event","uniqueid":"a4:c1:38:b9:9d:9c:c0:e3-01"} (ret = 315)
15:51:43:480 Websocket 192.168.1.38:44542 send message: {"e":"changed","id":"6","r":"lights","state":{"alert":"none","on":false,"reachable":true},"t":"event","uniqueid":"a4:c1:38:b9:9d:9c:c0:e3-01"} (ret = 142)
15:51:43:482 Websocket 192.168.1.38:44542 send message: {"attr":{"id":"51","lastannounced":null,"lastseen":"2023-01-04T14:51Z","manufacturername":"_TZ3000_amdymr7l","modelid":"TS011F","name":"Power 51","swversion":null,"type":"ZHAPower","uniqueid":"a4:c1:38:b9:9d:9c:c0:e3-01-0b04"},"e":"changed","id":"51","r":"sensors","t":"event","uniqueid":"a4:c1:38:b9:9d:9c:c0:e3-01-0b04"} (ret = -1095390792)
15:51:43:485 Websocket 192.168.1.38:44542 send message: {"attr":{"id":"52","lastannounced":null,"lastseen":"2023-01-04T14:51Z","manufacturername":"_TZ3000_amdymr7l","modelid":"TS011F","name":"Consumption 52","swversion":null,"type":"ZHAConsumption","uniqueid":"a4:c1:38:b9:9d:9c:c0:e3-01-0702"},"e":"changed","id":"52","r":"sensors","t":"event","uniqueid":"a4:c1:38:b9:9d:9c:c0:e3-01-0702"} (ret = -1095390792)
15:51:43:715 unhandled APS-DATA.confirm id: 65 status 0xE1
15:51:44:775 unhandled APS-DATA.confirm id: 69 status 0xE1
15:51:45:840 unhandled APS-DATA.confirm id: 72 status 0xE1
15:51:47:105 Daylight now: solarNoon, status: 170, daylight: 1, dark: 0
15:51:49:854 unhandled APS-DATA.confirm id: 83 status 0xE1
15:51:49:856 Websocket 192.168.1.38:44542 send message: {"e":"changed","id":"6","r":"lights","state":{"alert":"none","on":false,"reachable":false},"t":"event","uniqueid":"a4:c1:38:b9:9d:9c:c0:e3-01"} (ret = 143)
15:51:49:858 Websocket 192.168.1.38:44542 send message: {"config":{"on":true,"reachable":false},"e":"changed","id":"51","r":"sensors","t":"event","uniqueid":"a4:c1:38:b9:9d:9c:c0:e3-01-0b04"} (ret = -1095389920)
15:51:49:861 Websocket 192.168.1.38:44542 send message: {"config":{"on":true,"reachable":false},"e":"changed","id":"52","r":"sensors","t":"event","uniqueid":"a4:c1:38:b9:9d:9c:c0:e3-01-0702"} (ret = -1095389920)
15:51:54:104 sql exec SELECT conf FROM zbconf ORDER BY rowid desc limit 1
15:51:54:106 Idle timer triggered
15:51:54:107 Force read attributes for ZHAOpenClose SensorNode OpenClose 41
15:51:54:108 Force read attributes for ZHAOpenClose SensorNode Window / Door Sensor
15:51:54:854 CTRL skip creating node 0x540F57FFFEF92C28 while permit join is disabled
15:51:57:105 Daylight now: solarNoon, status: 170, daylight: 1, dark: 0
15:51:58:692 node 0A4C138DA92D1FE6D leave wait state
15:51:58:913 unhandled APS-DATA.confirm id: 104 status 0xE1
15:52:06:374 CTRL skip creating node 0x540F57FFFEF92C28 while permit join is disabled
15:52:07:105 Daylight now: solarNoon, status: 170, daylight: 1, dark: 0
15:52:08:765 Incr. ZDP retry count 2 on item 5
15:52:16:116 [Master] read param with arg 0x19
15:52:17:104 Daylight now: solarNoon, status: 170, daylight: 1, dark: 0
15:52:17:895 CTRL skip creating node 0x540F57FFFEF92C28 while permit join is disabled
15:52:22:112 GW firmware version: 0x26780700
15:52:22:112 GW firmware version is up to date: 0x26780700
15:52:24:107 Idle timer triggered
15:52:24:107 Force read attributes for ZHAOpenClose SensorNode OpenClose 41
15:52:24:108 Force read attributes for ZHAOpenClose SensorNode Window / Door Sensor
15:52:25:498 node 054EF4410002C77B4 leave wait state
15:52:25:705 unhandled APS-DATA.confirm id: 152 status 0xE1
15:52:27:105 Daylight now: solarNoon, status: 170, daylight: 1, dark: 0