Deleted outdated sensors / lights recovered after restoring backup

@de_employees

No, these lights and sensors are not active but still remain in Phoscon.
They are greyed out.
But HomeBridge put these unusable devices forward to HomeKit.

I have installed deCONZ 2.27.2 on my MBAir M3 (macOS 14.5), attached the Conbee III and recovered my backup.

I delete several sensors and lights.

After quitting and starting the app deCONZ, I can start Phoscon from there.

But than, the formerly delete items still appear.

It must have something to do with importing backups / zll.db.
Here are some sensors formerly delete and still in Phoscon.

Now I installed deCONZ 2.27.2 on Windows 11 (BootCamp Partition) with the same Conbee III.
I replaced the zll.db, started Phoscon, all used or formerly deleted device still present.

Then I delete unused sensors, devices. Exported a backup and copied the actual zll.db from this Windows Installation to my SD Card for the Pi4.
Booting up and all formerly devices are still there??

It must have something to do with the database zll.db.

Here´s the file:

Just to be sure, you (try to) delete device in phoscon ? not deconz ?
Do you still have disconnection on others host ?

And yes, I have checked your database integrity, it have fail, but how to restore it … You haven’t an old backup ?

Hello Smanar,

I ´ve deleted the devices within Phoscon.
I can control the other devices without any problem.
No old backup from phoscon.

Ho can I check disconnections on macOS or Windows?

With log, and easier as you will have the complete application to see them, in deconz/help/debug view.

Here is the deCONZ log from my MacBook Air M2 14.5 with Conbee III connected via multiport adapter.

Lot of error but no USB disconnection.
No one know the SQL request to repair a corrupted database ? Even with data loose.

Have found that, but not the same corruption Database corruption - 10000s of duplicate sensors in the sensors table · Issue #3972 · dresden-elektronik/deconz-rest-plugin · GitHub

I´ve found an older phoscon backup and give it a try.

With the 3 month old backup everything feels ok, I can delete sensors, lights and restart and no deleted items appear any more.
Thanks for the help.

Sorry, I don’t know SQL enought to help you to restore the actual one.
And about the disconnection with this old backup ?