<div dir="ltr"><div>Hello,</div><div><br></div><div>can you please give us more details? for example the version of the linstor controller</div><div> linstor controller version</div><div><br></div><div>also what exactly happened before you tried to delete ... what exactly? You are talking about snapshots, but you are showing us a list of resources and resource-definitions, not snapshots and snapshot-definitions. <br></div><div>Please describe what happened since you created the origin resource. Did you create a snapshot? And afterwards restored it in a new *resource* called "snap_vm-107-disk-1_vzdump"? <br></div><div>Did something else happen which seems unrelated (restart of controller, other resources failing, or other resources were deleted or such...)</div><div><br></div><div>My goal would be here to reproduce this issue, afterwards I am quite sure we can figure out what happens and come up with a proper fix.</div><div><br></div><div>For the database, feel free to send me a direct email (not via mailing list) with the database file so I can fix it for you. <br></div><div>Or if you want to try it yourself - make a BACKUP first of the database, just in case. Afterwards your goal should be to let Linstor delete the resource as there are quite a few tables that need to be cleaned up. As the exception states an entry in LDV (LAYER_DRBD_VOLUME) has still a foreign key to LRI (LAYER_RESOURCE_IDS), I'd look for entries in LDV and see if there are orphaned or duplicates (same "target resource" but multiple IDs per KIND) . After double checking that, you can try to delete the orphaned entries and see if Linstor manages to cleanly remove the rest of the resource. <br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Apr 28, 2021 at 12:01 PM Michał Szamocki <<a href="mailto:mszamocki@cirrus.pl" target="_blank">mszamocki@cirrus.pl</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Hello,<br>
<br>
my linstor cluster failed to delete snapshots and now I have:<br>
# linstor rd l | grep DELETING<br>
| snap_vm-107-disk-1_vzdump | 7021 | DfltRscGrp | DELETING |<br>
| snap_vm-108-disk-1_vzdump | 7019 | DfltRscGrp | DELETING |<br>
<br>
# linstor r l | grep DELETING<br>
| snap_vm-107-disk-1_vzdump | debra | 7021 | | Ok | DELETING | 2021-04-28 07:09:35 |<br>
| snap_vm-107-disk-1_vzdump | elsa | 7021 | | Ok | DELETING | 2021-04-28 07:09:36 |<br>
| snap_vm-108-disk-1_vzdump | debra | 7019 | | Ok | DELETING | 2021-04-28 07:07:23 |<br>
| snap_vm-108-disk-1_vzdump | elsa | 7019 | | Ok | DELETING | 2021-04-28 07:07:23 |<br>
<br>
<br>
Any operation fails error similar to this:<br>
Caused by:<br>
==========<br>
<br>
Category: Exception<br>
Class name: JdbcSQLException<br>
Class canonical name: org.h2.jdbc.JdbcSQLException<br>
Generated at: Method 'getJdbcSQLException', Source file 'DbException.java', Line #357<br>
<br>
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)"<br>
Unique index or primary key violation: "FK_LDV_LRI_INDEX_C ON LINSTOR.LAYER_RESOURCE_IDS(LAYER_RESOURCE_ID) VALUES (21, 116935)"; SQL statement:<br>
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]<br>
<br>
lvs and drbdadm status don't show any information about those snapshot. <br>
<br>
How can I safetly remove information about those snapshots from linstor-controller database?<br>
<br>
BR,<br>
Michal Szamocki<br>
Cirrus<br>
_______________________________________________<br>
Star us on GITHUB: <a href="https://github.com/LINBIT" rel="noreferrer" target="_blank">https://github.com/LINBIT</a><br>
drbd-user mailing list<br>
<a href="mailto:drbd-user@lists.linbit.com" target="_blank">drbd-user@lists.linbit.com</a><br>
<a href="https://lists.linbit.com/mailman/listinfo/drbd-user" rel="noreferrer" target="_blank">https://lists.linbit.com/mailman/listinfo/drbd-user</a><br>
</blockquote></div><br clear="all"><br>-- <br><div dir="ltr"><div dir="ltr"><div><div dir="ltr"><div>Best regards,<br></div>Gabor Hernadi<br></div></div></div></div>