Storage Rule Broken - No storage.Storage_deleted (25.2.0)

Help
1

Since the new update im getting the following storage rule fail

Error in alert rule Space is >= 97% (42): SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘storage.storage_deleted’ in ‘WHERE’ (Connection: mysql, SQL: SELECT * FROM devices,storage WHERE (devices.device_id = 789 AND devices.device_id = storage.device_id) AND storage.storage_deleted = 0 AND storage.storage_descr NOT LIKE ‘/%’ AND storage.storage_perc >= 97)

Looks like storage.storage_deleted doesn’t exist anymore in the editor? Any suggests how i could rework this rule?

1 Like
2

This got me too. I did git checkout 25.1.0 then removed the delete clause from the alert rules via the UI, then went back to git checkout 25.2.0 and ran daily.sh

Without rolling back, the alert rule in the UI would load blank and I couldn’t interact with it.

I note the alert collection rule templates are correct and omit the _deleted part now, so it’s not an issue going forward, just traps existing rules that used it.

3

Good solution to work around the issue.

Otherwise it’s manually updating the rule in the database with the relevant column removed.

4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.