@support Is the server down just now as I can’t login or see it on the web ?

    • BitOneZero @ .world@lemmy.world
      link
      fedilink
      arrow-up
      2
      ·
      1 year ago

      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.