dresden-elektronik / deconz-rest-plugin

deCONZ REST-API plugin to control ZigBee devices
BSD 3-Clause "New" or "Revised" License
1.89k stars 496 forks source link

all nodes lost overnight #767

Closed ErnstEeldert closed 6 years ago

ErnstEeldert commented 6 years ago

Hey manup,

Here's a new one I hadn't encountered yet. A couple of days ago, lights stopped responding to commands. As I didn't have time to dig into it, I used the wall switches.

Today, I had a look, and it looked like I've lost all lights in PWA. So I restarted deconz, same result. Upgraded from .31 to .37, lights (and sensors and switches I think) got back, but all in unavailable state. Upgraded firmare from e500 to the latest, same result.

As I run deconz in headless mode, I decided to run it in headed mode, and the network diagram shows me the raspbee, but nothing else. Here's the node info:

screen shot 2018-09-03 at 09 47 15

What should I do to rebuild the zigbee mes(s|h), without loosing all my config on the deconz (and related homebridge) side of things? I have around 50 lights here...

Thanks!

manup commented 6 years ago

I guess the networks settings are messed up, likely the channel.

The zll.db table zbconf contains all network setting changes, a bit hacky but I would suggest opening the file with sqlitebrowser and look if the channel has changed (or other parameters).

ErnstEeldert commented 6 years ago

Channel seems to be fine, has been stuck on 25 since the start. However, the latest change is showing a different network key. You can see the full contents of the table here.

manup commented 6 years ago

Ups did reply in the gist :)

ErnstEeldert commented 6 years ago

Setting the network key and panid as per the old values and rejoining the fixed the issue. All nodes are now returning to deconz.

Scary stuff though that this kind of corruption just happens overnight :(