[Bug]: Bulk-removing comments leads to timeout if there are many

[bjoern-tantau]

Requirements

• Is this a bug report? For questions or discussions use https://lemmy.ml/c/lemmy_support
• Did you check to see if this issue already exists?
• Is this only a single bug? Do not put multiple bugs in one issue.
• Do you agree to follow the rules in our Code of Conduct?
• Is this a backend issue? Use the lemmy-ui repo for UI / frontend issues.

Summary

When bulk-removing comments from a user who has lots of them it takes a long time and then times out. I guess it's trying to remove all of them in one go.

Steps to Reproduce

1. Start to ban a user with lots of content.
2. Select "remove content"
3. Send

Technical Details

Sorry, don't have access to the server at the moment.

Version

BE 0.19.3

Lemmy Instance URL

swg-empire.de

[MV-GH]

This might also be partially Jerboa, Jerboa has a timeout of 20s. Not sure if the Server has a timeout but that also might be exceeded by this request regardless. Perhaps the server should queue this action?

[dessalines]

Yep, these longer actions could potentially be backgrounded... but I'd rather investigate which DB action in crates/api_common/src/utils.rs remove_user_data is taking so long.