I delete outdated sensors and lamps in Phoscon 2.27.0 on my Raspi 4 with Bookworm HomeBridge Image (incl. all updates).
Same with previously deleted automations / sensor controls
After a restart, the previously deleted devices will appear again, deleted sensor controls / automations the same.
After a backup and subsequent restore these deleted devices also appear again.
Hello, you haven’t issue with the database ?
Try adding a new device to see if you have same issue.
Do you have access to deconz ? The full application, you can see on logs some error that can prevent the database be updated.
So the database seem good 07:39:02:871 /home/pi/.local/share/dresden-elektronik/deCONZ/zll.db exists and is writeable
But you have at start
07:39:03:418 SQL exec failed: DELETE from nodes WHERE manufacturername = '_TZ3000_4fjiwweb', error: database is locked (5)
07:39:03:418 SQL exec failed: UPDATE config2 SET value = 0 WHERE key = 'zclvaluemaxage' AND value = 3600, error: database is locked (5)
This can happen, but it need to work later, and on your log I don’t see new request DELETE or UPDATE, so can’t be sure if the database is locked or not.
You have only SELECT request and with error too, but IDK if this one is important, I think no else nothing will work.
I don’t see zigbee config network error message.
But you have problem with your USB port.
On all your pastebin log, you have a disconnection after some mn running
07:39:03:074 COM: /dev/ttyUSB0 : ConBee III : dresden elektronik (0x0403/0x6015)
07:39:06:790 COM: /dev/ttyUSB0 : ConBee III : dresden elektronik (0x0403/0x6015)
07:39:06:815 failed open com status: (-3), path: /dev/serial/by-id/usb-dresden_elektronik_ConBee_III_DE03110669-if00-port0
07:39:07:780 wait reconnect 5 seconds
07:39:07:834 COM: /dev/ttyUSB0 : ConBee III : dresden elektronik (0x0403/0x6015)
07:39:11:950 COM: /dev/ttyUSB0 : ConBee III : dresden elektronik (0x0403/0x6015)
07:39:12:008 failed open com status: (-3), path: /dev/serial/by-id/usb-dresden_elektronik_ConBee_III_DE03110669-if00-port0
07:39:16:944 COM: /dev/ttyUSB0 : ConBee III : dresden elektronik (0x0403/0x6015)
07:39:16:972 failed open com status: (-3), path: /dev/serial/by-id/usb-dresden_elektronik_ConBee_III_DE03110669-if00-port0
You haven’t changed something ? USB 2.0 > USB 3.0, another USB extension cable, a new SSD ?
You can found some information with searching “Failed open com status (-3)”, but I don’t found the command to test for Conbee 3.
If I insert the backup into a new installation
You have tried on another host ? like a PC machine ? It’s a good way to have the GUI and check the database integrity.
But for me the more important is your USB disconnection.
16:24:38:856 SQL exec failed: CREATE TABLE if NOT EXISTS dev_resource_items ( device_id TEXT REFERENCES devices(id) ON DELETE CASCADE, item STRING NOT NULL, value NOT NULL, timestamp INTEGER NOT NULL, PRIMARY KEY (device_id, item) ON CONFLICT REPLACE), error: database disk image is malformed (11), line: 803
And still disconnection.
16:24:46:113 COM: /dev/ttyUSB0 : ConBee III : dresden elektronik (0x0403/0x6015)
16:24:46:133 failed open com status: (-3), path: /dev/serial/by-id/usb-dresden_elektronik_ConBee_III_DE03110669-if00-port0
But @Mimiix is right, can be hardware, you can’t make a try on another host ? Installing deconz on a PC take 10 mn. If you still have the issue > problem on the gateway, else it’s on the host.
It’s fine you have only one running, the headless ATM.
Honneslty I can’t say if your problem is from the database or the disconnection, but you can’t stay with this permanent disconnection.