Node hang when received "WARN retain failed to delete piece" warning message

This warning mean that the node cannot access a database file.
I would suggest to stop and remove the container, then check and fix the filesystem, after that check and fix databases

If you would not like to fix corrupted databases (if you have the corruption), you may also re-create only corrupted instead, but you will lose the historic and Stat data:

If they are not broken, you do not need to fix them though.
However, the node will not stop because of warning. You need to search for FATAL error in the node’s logs or OOM events in the system journals.