０７６萌ＳＮＳ
  • Login

  • Public

    • Public
    • Network
    • Groups
    • Popular
    • People

Conversation

Notices

  1. idea_enjoyer (idea_enjoyer@nicecrew.digital)'s status on Tuesday, 02-Apr-2024 05:25:10 JST idea_enjoyer idea_enjoyer
    • Matty-kun :Christmas_kitty_bell:
    @matty nicecrew has been acting sluggish, but other sites have not. Is there something going on that you know of?
    In conversation about 8 months ago from nicecrew.digital permalink
    •  (mint@ryona.agency)'s status on Tuesday, 02-Apr-2024 05:25:09 JST  
      in reply to
      • Matty-kun :Christmas_kitty_bell:
      • reeeeeelman
      @realman543 @idea_enjoyer @matty Matty claims "The instance isn't under a heavy load", which is the opposite of my postgres issues.
      In conversation about 8 months ago permalink
      † top dog :pedomustdie: likes this.
    • reeeeeelman (realman543@annihilation.social)'s status on Tuesday, 02-Apr-2024 05:25:10 JST reeeeeelman reeeeeelman
      in reply to
      • 
      • Matty-kun :Christmas_kitty_bell:
      @idea_enjoyer @matty
      Apparently @mint is having a similar issue. Maybe they are related? Check the logs.
      In conversation about 8 months ago permalink
    •  (mint@ryona.agency)'s status on Tuesday, 02-Apr-2024 05:28:22 JST  
      in reply to
      • Matty-kun :Christmas_kitty_bell:
      • reeeeeelman
      @matty @realman543 @idea_enjoyer I've been struggling with long CPU usage spikes from postgres lately, that's about it.
      In conversation about 8 months ago permalink
    • Matty-kun :Christmas_kitty_bell: (matty@nicecrew.digital)'s status on Tuesday, 02-Apr-2024 05:28:23 JST Matty-kun :Christmas_kitty_bell: Matty-kun :Christmas_kitty_bell:
      in reply to
      • 
      • reeeeeelman
      What?
      In conversation about 8 months ago permalink
    • Matty-kun :Christmas_kitty_bell: (matty@nicecrew.digital)'s status on Tuesday, 02-Apr-2024 05:30:40 JST Matty-kun :Christmas_kitty_bell: Matty-kun :Christmas_kitty_bell:
      in reply to
      • 
      • Matty-kun :Christmas_kitty_bell:
      • reeeeeelman
      And when is the last time you repacked or vacuumed your database?
      In conversation about 8 months ago permalink
    •  (mint@ryona.agency)'s status on Tuesday, 02-Apr-2024 05:30:40 JST  
      in reply to
      • Matty-kun :Christmas_kitty_bell:
      • reeeeeelman
      @matty @realman543 @idea_enjoyer Yes and yes. Repacked it as soon as the issues started.
      In conversation about 8 months ago permalink
    • Matty-kun :Christmas_kitty_bell: (matty@nicecrew.digital)'s status on Tuesday, 02-Apr-2024 05:30:41 JST Matty-kun :Christmas_kitty_bell: Matty-kun :Christmas_kitty_bell:
      in reply to
      • 
      • reeeeeelman
      Have you tuned Postgre?
      In conversation about 8 months ago permalink
    • Matty-kun :Christmas_kitty_bell: (matty@nicecrew.digital)'s status on Tuesday, 02-Apr-2024 05:34:14 JST Matty-kun :Christmas_kitty_bell: Matty-kun :Christmas_kitty_bell:
      in reply to
      • 
      • reeeeeelman
      What Postgre job is causing the hang?
      In conversation about 8 months ago permalink
    •  (mint@ryona.agency)'s status on Tuesday, 02-Apr-2024 05:34:14 JST  
      in reply to
      • Matty-kun :Christmas_kitty_bell:
      • reeeeeelman
      @matty @realman543 @idea_enjoyer No idea. Phoenix dashboard shows some long-ass query often running for up to 15 seconds, which I assume is a timeline.
      In conversation about 8 months ago permalink
    •  (mint@ryona.agency)'s status on Tuesday, 02-Apr-2024 05:37:12 JST  
      in reply to
      • Matty-kun :Christmas_kitty_bell:
      • reeeeeelman

      @matty @realman543 @idea_enjoyer SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = associated_object_id(a0."data") INNER JOIN "users" AS u2 ON (a0."actor" = u2."ap_id") AND (u2."is_active" = TRUE) INNER JOIN "users" AS u3 ON (a0."actor" = u3."ap_id") AND (u3."invisible" = FALSE) WHERE ($1 && a0."recipients") AND (a0."actor" = $2) AND (a0."data"->>'type' = $3) AND (not(o1."data"->>'type' = 'Answer')) AND (not(o1."data"->>'type' = 'ChatMessage')) ORDER BY a0."id" desc nulls last LIMIT $4

      I never enabled activity expiration to begin with, so it's unrelated.

      In conversation about 8 months ago permalink
    • Matty-kun :Christmas_kitty_bell: (matty@nicecrew.digital)'s status on Tuesday, 02-Apr-2024 05:37:13 JST Matty-kun :Christmas_kitty_bell: Matty-kun :Christmas_kitty_bell:
      in reply to
      • 
      • reeeeeelman
      Which query specifically? I'm asking because I had this same issue when I had activity expiration on like a year and a half ago.
      In conversation about 8 months ago permalink
    •  (mint@ryona.agency)'s status on Tuesday, 02-Apr-2024 05:44:20 JST  
      in reply to
      • Matty-kun :Christmas_kitty_bell:
      • reeeeeelman
      @matty @realman543 @idea_enjoyer Randomly but frequently. Pretty sure it is timeline since more of the same queries spawn when I just spam the new tab with, say, home timeline.
      In conversation about 8 months ago permalink
    • Matty-kun :Christmas_kitty_bell: (matty@nicecrew.digital)'s status on Tuesday, 02-Apr-2024 05:44:21 JST Matty-kun :Christmas_kitty_bell: Matty-kun :Christmas_kitty_bell:
      in reply to
      • 
      • reeeeeelman
      Is someone spamming chats on your instance? Does this happen periodically like on a cycle or just randomly?
      In conversation about 8 months ago permalink
    • :archlinux: :nyarch: :verified: (lewdthewides@hidamari.apartments)'s status on Tuesday, 02-Apr-2024 05:46:47 JST :archlinux: :nyarch: :verified: :archlinux: :nyarch: :verified:
      in reply to
      • 
      • Matty-kun :Christmas_kitty_bell:
      • reeeeeelman
      @mint @realman543 @idea_enjoyer @matty Are you being scraped?
      In conversation about 8 months ago permalink
    •  (mint@ryona.agency)'s status on Tuesday, 02-Apr-2024 05:46:47 JST  
      in reply to
      • Matty-kun :Christmas_kitty_bell:
      • :archlinux: :nyarch: :verified:
      • reeeeeelman
      @lewdthewides @realman543 @idea_enjoyer @matty No unusual activity in logs.
      In conversation about 8 months ago permalink
    •  (mint@ryona.agency)'s status on Tuesday, 02-Apr-2024 05:56:05 JST  
      in reply to
      • Matty-kun :Christmas_kitty_bell:
      • :archlinux: :nyarch: :verified:
      • reeeeeelman
      @lewdthewides @realman543 @idea_enjoyer @matty There were two IPs that might or might not be scrapers, but dropping them in firewall did literally nothing. Pretty much all other timeline requests are done by legitimate users.
      In conversation about 8 months ago permalink
    • :archlinux: :nyarch: :verified: (lewdthewides@hidamari.apartments)'s status on Tuesday, 02-Apr-2024 05:56:06 JST :archlinux: :nyarch: :verified: :archlinux: :nyarch: :verified:
      in reply to
      • 
      • Matty-kun :Christmas_kitty_bell:
      • reeeeeelman
      @mint @realman543 @idea_enjoyer @matty disable public viewing of timelines and profiles and see what happens :yui_shrug:
      In conversation about 8 months ago permalink
    •  (mint@ryona.agency)'s status on Tuesday, 02-Apr-2024 05:58:34 JST  
      in reply to
      • 
      • Matty-kun :Christmas_kitty_bell:
      • :archlinux: :nyarch: :verified:
      • reeeeeelman
      @lewdthewides @idea_enjoyer @matty @realman543 On closer inspection, their since_id requests have the same delay between them, it's just the timing between requests from both of them happen to be synchronized. Red herring.
      In conversation about 8 months ago permalink
    •  (mint@ryona.agency)'s status on Tuesday, 02-Apr-2024 06:09:51 JST  
      in reply to
      • Matty-kun :Christmas_kitty_bell:
      • :archlinux: :nyarch: :verified:
      • reeeeeelman
      @lewdthewides @realman543 @idea_enjoyer @matty Guess the disk is shitting itself then. Some lower numbers might be due to me setting CPU governor to powersave and not turning postgres off in meanwhile, though.
      fio.txt
      In conversation about 8 months ago permalink

      Attachments


      1. Invalid filename.
    • :archlinux: :nyarch: :verified: (lewdthewides@hidamari.apartments)'s status on Tuesday, 02-Apr-2024 06:09:52 JST :archlinux: :nyarch: :verified: :archlinux: :nyarch: :verified:
      in reply to
      • 
      • Matty-kun :Christmas_kitty_bell:
      • reeeeeelman
      @mint @realman543 @idea_enjoyer @matty I tried. Only other thing I can think of is fio your database drive and check if random reads are where it's suppose to be
      In conversation about 8 months ago permalink
    • munir (munir@fedi.munir.tokyo)'s status on Tuesday, 02-Apr-2024 06:12:33 JST munir munir
      in reply to
      • 
      • Matty-kun :Christmas_kitty_bell:
      • reeeeeelman
      @mint @realman543 @idea_enjoyer @matty its hard to say because the the parameters are missing from the query, im skewing through the code right now but it's hard to find the query because they're using language extensions that simply get translated into a query, grrrrr i hate pleroma
      In conversation about 8 months ago permalink
       likes this.
    • :archlinux: :nyarch: :verified: (lewdthewides@hidamari.apartments)'s status on Tuesday, 02-Apr-2024 06:13:21 JST :archlinux: :nyarch: :verified: :archlinux: :nyarch: :verified:
      in reply to
      • 
      • Matty-kun :Christmas_kitty_bell:
      • reeeeeelman
      @mint @realman543 @idea_enjoyer @matty iops aren't terrible, but what good is that when the data isn't being fed in fast enough
      In conversation about 8 months ago permalink
       likes this.
    •  (mint@ryona.agency)'s status on Tuesday, 02-Apr-2024 06:15:14 JST  
      in reply to
      • Matty-kun :Christmas_kitty_bell:
      • :archlinux: :nyarch: :verified:
      • reeeeeelman
      @lewdthewides @realman543 @idea_enjoyer @matty I will try scoring some better SSD one day, but guess I'd have to bear with it for now.
      In conversation about 8 months ago permalink

Feeds

  • Activity Streams
  • RSS 2.0
  • Atom
  • Help
  • About
  • FAQ
  • TOS
  • Privacy
  • Source
  • Version
  • Contact

０７６萌ＳＮＳ is a social network, courtesy of ０７６. It runs on GNU social, version 2.0.2-beta0, available under the GNU Affero General Public License.

Creative Commons Attribution 3.0 All ０７６萌ＳＮＳ content and data are available under the Creative Commons Attribution 3.0 license.