Lemmy.world has been down between 02:00 UTC and 05:45 UTC. This was caused by the database spiking to 100% cpu (all 32 cores/64 threads!) due to inefficient queries been fired to the db very often.

I’ve collected the logs and we’ll be checking how to prevent this. (And what caused this)

  • zikk_transport2
    link
    fedilink
    arrow-up
    97
    arrow-down
    1
    ·
    2 years ago

    lemmy.world is a test environment for Lemmy developers… 😅 Jokes aside, issue is an issue.

    • slimerancher
      link
      fedilink
      English
      arrow-up
      40
      arrow-down
      1
      ·
      2 years ago

      Well, as pretty much the biggest instance, it provides the best data for load-testing. 🫣

    • Ready! Player 31
      link
      fedilink
      English
      arrow-up
      36
      ·
      2 years ago

      All Lemmy instances are test environments right now. It’s just that lemmy.world is being tested the hardest.

      • Ready! Player 31
        link
        fedilink
        English
        arrow-up
        12
        ·
        2 years ago

        My issue with the smaller instances is that I enjoy browsing Local, and this is typically not as active or interesting on there. Is there a way to browse lemmy.world’s Local from another instance?

        • Blaze (he/him)@sopuli.xyz
          link
          fedilink
          arrow-up
          1
          arrow-down
          1
          ·
          2 years ago

          Local makes sense for a country or field focused instance (queer rights, programming, even porn or whatever), not so much for generalist instances, unfortunately.

          The way you use local only makes sense now as most of the communities are on LW. Once a few of them start to branch out (such as lemdro.id or startrek.website), if you want to see that content, you will either subscribe or use all

  • flubba86
    link
    fedilink
    arrow-up
    60
    arrow-down
    1
    ·
    2 years ago

    Every Lemmy update:

    “We fixed some performance issues by optimising some queries.”

    Also: “To balance it out, we added some new even more inefficient queries.”

      • RookiA
        link
        fedilink
        arrow-up
        3
        arrow-down
        27
        ·
        2 years ago

        Next time just god damn upload it directly. Thx

          • RookiA
            link
            fedilink
            arrow-up
            1
            arrow-down
            1
            ·
            2 years ago

            what You can just simply copy the video directly and paste it directly into the comments

            • kratoz29
              link
              fedilink
              English
              arrow-up
              12
              ·
              2 years ago

              I don’t know how to do that from Android and into the Summit app.

              • RookiA
                link
                fedilink
                arrow-up
                2
                arrow-down
                1
                ·
                2 years ago

                There should be an icon like this:

                And you can probably upload a picture there

                • kratoz29
                  link
                  fedilink
                  English
                  arrow-up
                  3
                  ·
                  2 years ago

                  There is, but my file was a video, maybe that’s why I could not.

    • El Barto@lzrprt.sbs
      link
      fedilink
      English
      arrow-up
      8
      ·
      2 years ago

      How else are they supposed to patch things out? can’t leave it up to fate, gotta make your own destiny!

      • kratoz29
        link
        fedilink
        English
        arrow-up
        2
        ·
        2 years ago

        Huh, isn’t this instance only?

        I just think tried from Connect for Lemmy in this comment and I couldn’t.

  • ttmrichter
    link
    fedilink
    English
    arrow-up
    31
    arrow-down
    11
    ·
    2 years ago

    (And what caused this)

    Prediction: bad database programming. ;)

    • NewNewAccount
      link
      fedilink
      English
      arrow-up
      14
      ·
      2 years ago

      Are we extracting enough value out of our volunteer developers and DBAs?!

      • ewe
        link
        fedilink
        arrow-up
        7
        arrow-down
        5
        ·
        2 years ago

        The beatings will continue until morale improves!

  • Possible_EmuWrangler
    link
    fedilink
    English
    arrow-up
    17
    ·
    edit-2
    2 years ago

    Thanks for keeping us updated. FYI i noticed an issue there was an error message saying to check (the matix) and (somewhere else, Lemmy community support?). Both of them pointed to the same URL, but im sure they were meant to point to different places.

    Edit. Happed again and I took notes. Both point to lemmy.ml community support

    • RuudOPMA
      link
      fedilink
      English
      arrow-up
      12
      ·
      2 years ago

      Yup. We might be on to something now

  • 𝐘Ⓞz҉
    link
    fedilink
    arrow-up
    7
    arrow-down
    27
    ·
    2 years ago

    People move to smaller instances so that with such outage not everyone is affected. Use fediverse as its supposed to be used.

    • SpaceBar
      link
      fedilink
      English
      arrow-up
      17
      ·
      2 years ago

      What’s the name of the server you are running?

      A large instance today will be a small instance in the future. There are hardly any users on lemmy compared to other more established platforms. So if lemmy is to ever handle a lot more users, stress testing the code makes a lot of sense.

      What’s going to happen in the future, do you expect there to be 50,000 servers? That’s unrealistic.

      • Sl00k@programming.dev
        link
        fedilink
        arrow-up
        3
        ·
        2 years ago

        Instances should be divided more into groups of Communities. So they theoretically don’t grow infinitely, only as high as the “group” if communities grows. Ex. An NBA or Sports instance containing /c/NBA /c/NFL /c/NHL and all the related teams. Or similar to the programming.dev instance all being programming and development. While these would grow it would grow at a much slower rate than everything in one instance and be much more maintainable.

        Of course this is somewhat of a social construct so everyone has to be in agreement with how to handle this and move accordingly, which won’t happen.

        Long-term long-term for federation there has to be a distributed computing solution that allows the users to contribute to hosting.

      • 𝐘Ⓞz҉
        link
        fedilink
        arrow-up
        1
        arrow-down
        24
        ·
        2 years ago

        You’re not taking into account that some people are dumb as fuck. They will sit on one instance and when the instance goes down , they’ll start whining

        • HTTP_404_NotFound@lemmyonline.com
          link
          fedilink
          English
          arrow-up
          12
          ·
          2 years ago

          They will sit on one instance and when the instance goes down , they’ll start whining

          Its true. Especially so, since its my instance, and it being broken means I need to fix it. :'(

    • cerevant
      link
      fedilink
      English
      arrow-up
      9
      arrow-down
      6
      ·
      2 years ago

      I can’t claim to know what the designers intended, but having users spread across a large numbers of servers is terribly inefficient for how Lemmy works: each server maintains a copy of each community that it’s users are subscribed to, and changes to those communities need to be communicated across each of those instances.

      Given this architecture, it is much more efficient and robust to have users concentrate on what are effectively high performance cacheing servers, and communities spread out on smaller, interest focused instances.

      • ewe
        link
        fedilink
        arrow-up
        4
        arrow-down
        4
        ·
        2 years ago

        Yeah, I think this is the way things should move in the future. Have community vs user focuses on servers instead of having the same server get hit with both high community/comment usage and a server with lots of login/audit/user browsing requests. Servers with big communities could focus on stability and perfomance. Servers with users could focus on cool UIs and features for their users.

      • 𝐘Ⓞz҉
        link
        fedilink
        arrow-up
        1
        arrow-down
        16
        ·
        2 years ago

        Bro I was talking about you. read my previous comment