LemmyNet/lemmy

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

bjoern-tantau opened this issue · 2 comments

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.

Screenshot_20240419-185303

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

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?

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.