Post ARbERYbcB3JT8Xl4Iy by Curator@artisan.chat
(DIR) More posts by Curator@artisan.chat
(DIR) Post #ARbERXvmgZqv2oBf6W by girino@mastodon.girino.org
2023-01-12T03:00:02Z
0 likes, 0 repeats
#mastoadmin Please help. This query is being repeated by all my sidekiq threads in all instances, and taking a huge amount of time: REFRESH MATERIALIZED VIEW CONCURRENTLY "instances";This looks like like something that should be executed only once, not by all threads all the time. What might be happening?
(DIR) Post #ARbERYbcB3JT8Xl4Iy by Curator@artisan.chat
2023-01-12T03:04:47Z
0 likes, 0 repeats
@girino Block activitypub-troll.cf, misskey-forkbomb.cf, and repl.co; they're generating bogus hostnames to overwhelm servers.(I block the entire cf TLD, fwiw.)
(DIR) Post #ARbERZ3yTbzwYV1iVc by girino@mastodon.girino.org
2023-01-12T03:18:33Z
0 likes, 0 repeats
@Curator how do i block the entire cf TLD?
(DIR) Post #ARbERZPbBDINdZ8zDM by developers@forfuture.social
2023-01-13T10:59:11Z
0 likes, 0 repeats
@girino You can add a domain block (suspend!) with a wildcard, like so:*.activitypub-troll.cf(cf. thread https://mastodon.world/@ruud/109449235553044156 )#mastoadmin@Curator
(DIR) Post #ARbERa40kxcbeu3GCm by ruud@mastodon.world
2023-01-13T11:55:36Z
0 likes, 0 repeats
@developers @girino @Curator Doesn't work with a wildcard.Just block the activitypub-troll.cf domain and that will automatically block all subdomains.
(DIR) Post #ARbMhsw79hK8SRdxCq by Curator@artisan.chat
2023-01-13T13:28:12Z
0 likes, 0 repeats
@ruud @developers @girino Or just block plain "cf" and the whole TLD goes away.Check beforehand, though. I had zero follows on any domains in it, so there was basically no downside. YMMV.activitypub-troll.cfbarcelo.cfbeta.mstdn.cfcyberspace.netrunner.cfdhakodon.cfmastodon.barcelo.cfpixelfed.barcelo.cfvideo.barcelo.cfmastodon.cfmastodong-lol.aproxy-testing-stop-flooding-my-debug-log.cfmisskey-forkbomb.cfmisskey.cfmitsukey.cfmstdn-social.activitypub-proxy.cfmstdn.cftalkabout.cf