this post was submitted on 25 Jul 2023
68 points (95.9% liked)
Lemmy.world Support
3212 readers
2 users here now
Lemmy.world Support
Welcome to the official Lemmy.world Support community! Post your issues or questions about Lemmy.world here.
This community is for issues related to the Lemmy World instance only. For Lemmy software requests or bug reports, please go to the Lemmy github page.
This community is subject to the rules defined here for lemmy.world.
To open a support ticket 
You can also DM https://lemmy.world/u/lwreport or email report@lemmy.world (PGP Supported) if you need to reach our directly to the admin team.
Follow us for server news ๐
Outages ๐ฅ
founded 1 year ago
MODERATORS
lemmy internally has SQL flaws that have not gotten much attention. A few days ago, over the weekend, lemmy.ca people studied some of the SQL and exposed a problem where every single new comment and new post on a local server updates 1500 rows in a database table where it should be updating just 1. There have been similar runaway SQL statements discovered. Fixes for the most recent issue are already on GitHub waiting for merge and publication.