I opened my front door, observed contact switch went to open, checked for my GE Zigbee switches that I ordered from smartthings, closed the door and observed the contact sensor went closed and then locked it. I was walking away and the door lock auto opened, checked the logs and this is what i found:
7832cbac-7413-4787-aee8-96c784b2a531 9:04:33 PM: error com.datastax.driver.core.exceptions.InvalidQueryException: Invalid null value for partition key part tonumber @ line 94
7832cbac-7413-4787-aee8-96c784b2a531 9:04:33 PM: debug Sending text message…
7832cbac-7413-4787-aee8-96c784b2a531 9:04:33 PM: debug Sending Push Notification…
7832cbac-7413-4787-aee8-96c784b2a531 9:04:32 PM: debug Unlocking the door.
something about text message… if i open a door and lock the lock and let it auto unlock it throws a error, i don’t think that the error is the root cause of not checking the correct state of the door contact switch. perhaps this app is run in the cloud and the cloud could not be updated quickly enough.
error:
d084175d-1749-4c40-afcb-d8764214142b 8:07:12 AM: error com.datastax.driver.core.exceptions.InvalidQueryException: Invalid null value for partition key part tonumber @ line 63
d084175d-1749-4c40-afcb-d8764214142b 8:07:12 AM: debug Sending text message…
d084175d-1749-4c40-afcb-d8764214142b 8:07:12 AM: debug Sending Push Notification…
d084175d-1749-4c40-afcb-d8764214142b 8:07:12 AM: debug Unlocking the door
This auto unlocking while the door is closed and the SmartThings hub has received the correct state of the door contact sensor is BAD and compromises security!
I have observed where the door is closed and SmartThings never acknowledges that the contact sensor is closed, and i can see from the led on the sensor that it did send the signal.