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
_______________________________________________
Star us on GITHUB: https://github.com/LINBIT
drbd-user mailing list
drbd-user@lists.linbit.com
https://lists.linbit.com/mailman/listinfo/drbd-user

Reply via email to