[DRBD-user] Linstor hangs on deleting snapshots

[Michał Szamocki]

Hello,

my linstor cluster failed to delete snapshots and now I have:
# linstor rd l | grep DELETING
| snap_vm-107-disk-1_vzdump | 7021 | DfltRscGrp         | DELETING |
| snap_vm-108-disk-1_vzdump | 7019 | DfltRscGrp         | DELETING |

# linstor r l | grep DELETING
| snap_vm-107-disk-1_vzdump | debra | 7021 |        | Ok    | DELETING | 2021-04-28 07:09:35 |
| snap_vm-107-disk-1_vzdump | elsa  | 7021 |        | Ok    | DELETING | 2021-04-28 07:09:36 |
| snap_vm-108-disk-1_vzdump | debra | 7019 |        | Ok    | DELETING | 2021-04-28 07:07:23 |
| snap_vm-108-disk-1_vzdump | elsa  | 7019 |        | Ok    | DELETING | 2021-04-28 07:07:23 |


Any operation fails error similar to this:
Caused by:
==========

Category:                           Exception
Class name:                         JdbcSQLException
Class canonical name:               org.h2.jdbc.JdbcSQLException
Generated at:                       Method 'getJdbcSQLException', Source file 'DbException.java', Line #357

Error message:                      Naruszenie ograniczenia Klucza Głównego lub Indeksu Unikalnego: "FK_LDV_LRI_INDEX_C ON LINSTOR.LAYER_RESOURCE_IDS(LAYER_RESOURCE_ID) VALUES (21, 116935)"
Unique index or primary key violation: "FK_LDV_LRI_INDEX_C ON LINSTOR.LAYER_RESOURCE_IDS(LAYER_RESOURCE_ID) VALUES (21, 116935)"; SQL statement:
 INSERT INTO LAYER_RESOURCE_IDS ( LAYER_RESOURCE_ID, NODE_NAME, RESOURCE_NAME, SNAPSHOT_NAME, LAYER_RESOURCE_PARENT_ID, LAYER_RESOURCE_KIND, LAYER_RESOURCE_SUFFIX, LAYER_RESOURCE_SUSPENDED )  VALUES ( ?, ?, ?, ?, ?, ?, ?, ? ) [23505-197]

lvs and drbdadm status don't show any information about those snapshot. 

How can I safetly remove information about those snapshots from linstor-controller database?

BR,
Michal Szamocki
Cirrus