haley.io
  • Communities
  • Create Post
  • Create Community
  • heart
    Support Lemmy
  • search
    Search
  • Login
  • Sign Up
RoundSparrow@lemmy.mlM to Lemmy Federation@lemmy.ml · 2 years ago

PSA for Lemmy instance admins: in backend v0.18.3 there is a bug that causes your instance to stop federating properly and to stop sending out outgoing messages - Lemmy.ca direct link

lemmy.ca

external-link
message-square
0
fedilink
1
external-link

PSA for Lemmy instance admins: in backend v0.18.3 there is a bug that causes your instance to stop federating properly and to stop sending out outgoing messages - Lemmy.ca direct link

lemmy.ca

RoundSparrow@lemmy.mlM to Lemmy Federation@lemmy.ml · 2 years ago
message-square
0
fedilink
PSA for Lemmy instance admins: in backend v0.18.3 there is a bug that causes your instance to stop federating properly and to stop sending out outgoing messages - Lemmy.ca
lemmy.ca
external-link
This new version introduced a system so that your instance stops sending out content to other instances that are supposedly dead / offline. Unfortunately for some reason there’s false positives. When I checked comparing the results from a curl request vs the information in our Lemmy database I found over 350+ false positives. In the DB there is a table called “instance” which has a column called “updated”. If the date on that column is older than 3 days, your server will stop sending any content to those instances. For some reason I had entries that were dated as last being alive in July, while actually they were always up. If an entry is incorrect, you can fix it by manually using an update statement and adding today’s date. If your instance is not too large you can safely update all entries to today’s date and check if everything works as expected from then on any new content created on your instances. The dead instances won’t have an impact unless your instance is larger and generates more content, thus it might be easier to simply update all entries and have Lemmy believe they’re all alive if you start noticing wonky behavior and don’t want to check one by one. If you don’t know how to access the database run this command where domaincom is your instance domain without the dot. 1. docker exec -it domaincom_postgres_1 busybox /bin/sh 2. psql -U (The default user is ‘lemmy’) You could technically do this is one single step, but it’s good to know the command to get shell access to the container itself if you didn’t know how to. This should give you access to a postgres CLI interface. Use \c to connect, \dt to list tables and \d+ tablename to list table definition. You can also run SQL queries from there. Try with this query: SELECT * from instance to list all instances and their updated date. You can use other SQL queries to get better results or correct false positives. Just be careful with what you execute since there’s no undo.
alert-triangle
You must log in or register to comment.

Lemmy Federation@lemmy.ml

lemmyfederation@lemmy.ml

Subscribe from Remote Instance

Create a post
You are not logged in. However you can subscribe from another Fediverse account, for example Lemmy or Mastodon. To do this, paste the following into the search field of your instance: !lemmyfederation@lemmy.ml

Focus on Lemmy to Lemmy issues with post/comment sharing, servers being upgraded to new releases, reports of technical problems, etc.

Visibility: Public
globe

This community can be federated to other instances and be posted/commented in by their users.

  • 1 user / day
  • 1 user / week
  • 1 user / month
  • 1 user / 6 months
  • 1 local subscriber
  • 199 subscribers
  • 28 Posts
  • 0 Comments
  • Modlog
  • mods:
  • RoundSparrow@lemmy.ml
  • BE: 0.19.5
  • Modlog
  • Instances
  • Docs
  • Code
  • join-lemmy.org