Request for help to modify the database

[mikael]

Hello,

Due to a slowness issue (probably due to my card), I have devices that I tried to delete in Gladys but were not completely removed, so there are still references in Gladys.
Could I get help to go and modify this data. Mainly how to display the database and the language associated with it.

Bonus question: what files need to be backed up to allow a reinstallation without starting over? (scenes and devices)

Thanks in advance

[AlexTrovato]

I’m quite surprised that these devices cannot be removed from the service page.

Do you know SQL? You need to connect to the DB file with sqlite3.
Normally, you only need this DB file which contains all the information.

[mikael]

They are no longer on the « devices » page under Gladys, but there must be remnants in the database.
For SQL, I just need to brush up a bit.
For SQLite3, is it included by default in the pre-built version of Gladys, or do I need to install it?

I tried a find but found nothing.

[cicoub13]

The simplest solution for me is to stop the Gladys container, copy the database file to my PC, and use Downloads - DB Browser for SQLite to browse the database.

[pierre-gilles]

@mikael

but there must be remains in the database.

How are you sure? I’m surprised too!

In Gladys, when a device is deleted, it cascades to delete the child entities of that device (deviceFeature, deviceParam, deviceFeatureState, etc…)

If you find an entity that is not properly deleted, let us know because that’s not normal

@mikael

which files should be backed up to allow a reinstallation without starting from scratch? (scenes and devices)

Solutions de sauvegarde / Backup Raspberri Pi

Le dossier /var/lib/gladysassistant contient tout Après attention lors d’un backup “à chaud”, Gladys écrit dans une base de donnée SQLite en WAL mode, et donc il y a 3 fichiers de DB. Si tu fais un backup qui prend les 3 fichiers en séquentiel, tu auras une DB corrompue Le mieux est d’utiliser le CLI de SQlite3 pour dupliquer la DB dans un unique fichier avant de la sauvegarder

[mikael]

For the database, that’s what seemed logical to me

I just found references in the T_dashboard table but it didn’t change anything. I still get the message « An error occurred during saving ». My database is over 500MB

I confirm that my SD card has a problem writing. It freezes when it writes.

Oh, I just found this in the gladys logs:

2021-12-02T15:24:54+0100 <warn> handleMqttMessage.js:79 (Zigbee2mqttManager.handleMqttMessage) Zigbee2mqtt topic zigbee2mqtt/détecteur Noe empty message.
2021-12-02T15:24:55+0100 <warn> handleMqttMessage.js:100 (Zigbee2mqttManager.handleMqttMessage) Zigbee2mqtt device detecteur Noe not configured in Gladys.

Strange on the « Zigbee discovery » page, it doesn’t put « suggest this device » like my carbon monoxide detector which, following the update, is no longer recognized

My motion detector is the Xiaomi Aqara RTCGQ11LM

[pierre-gilles]

@mikael

I confirm that my SD card has a problem writing. It freezes when it writes.

Indeed, everything you describe clearly resembles a hardware problem Switching to an SSD seems to be the best solution!