Problem: queued collections can't be set to failed using bulk operations

[scollazo]

We had a user request in order to be able to fail already queued transfers.

[scollazo]

As this is not supported, we plan to update the mysql database using sql

[scollazo]

Bulk operation also doesn't allow to set all the "pending" transfers to "abandoned"

[sevein]

As this is not supported, we plan to update the mysql database using sql

@scollazo it's probably better to cancel the workflows, e.g. cadence workflow cancel -w <wid> -r <rid>. That gives the workflow an opportunity to exit gracefully and update the database on its way out. If you updated the database manually then you'd be introducing state inconsistency I suppose.

[scollazo]

@sevein any quick way to find the wid and rid? In this case, the change involved all the QUEUED transfers, but there could be cases where you only want to cancel a bunch of sips, and not all the queued ones.

[scollazo]

Forget the previous comment, I can see them on the collections table.