Lemdro.id

2,019 readers
16 users here now

Our Mission 🚀

Lemdro.id strives to be a fully open source instance with incredible transparency. Visit our GitHub for the nuts and bolts that make this instance soar and our Matrix Space to chat with our team and access the read-only backroom admin chat.

Community Guidelines

We believe in maintaining a respectful and inclusive environment for all members. We encourage open discussion, but we do not tolerate spam, harassment, or disrespectful behaviour. Let's keep it civil!

Get Involved

Are you an experienced moderator, interested in bringing your subreddit to the Fediverse, or a Lemmy app developer looking for a home community? We'd be happy to host you! Get in touch!

Quick Links

Lemdro.id Interfaces 🪟

Our Communities 🌐

Lemmy App List 📱

Chat and More 💬

Instance Updates

!lemdroid@lemdro.id

founded 2 years ago
ADMINS

Now powered by Photon (by default)!

26
 
 

Not a huge achievement, but I went the whole battle with relatively minimal resource usage

27
 
 

Hello,

as some of you may have noticed we just had about 25 minutes of downtime due to the update to Lemmy 0.19.10.

Lemmy release notes: https://join-lemmy.org/news/2025-03-19_-_Lemmy_Release_v0.19.10_and_Developer_AMA

This won't fix YouTube thumbnails for us, as YouTube banned all IPs belonging to our hosting provider.

We were intending to apply this update without downtime, as we're looking to apply the database migration that allows marking PMs as removed due to the recent spam waves.

Although this update contains database migrations, we expected to still be able to apply the migration in the background before updating the running software, as the database schema between the versions was backwards compatible. Unfortunately, once we started the migrations, we started seeing the site go down.

In the first minutes we assumed that the migrations contained in this upgrade were somehow unexpectedly blocking more than intended but still processing, but it turned out that nothing was actually happening on the database side. Our database deadlocked due to what appears to be an orphaned transaction, which didn't die even after we killed all Lemmy containers other than the one running the migrations.

While the orphaned transaction was pending, a pending schema migration was waiting for the previous transaction to complete or be rolled back, so nothing was moving anymore. As the previous transaction also didn't move anymore everything started to die. We're not entirely sure why the original transaction broke down, as it was started about 30 seconds before the schema migration query, which seems like that shouldn't have been broken by that happening at the same time.

Lemmy has a "replaceable" schema, which is applied separately from the regular database schema migrations, which runs every time a DB migration occurs. We unfortunately did not consider this replaceable schema migration in our planning, as we would otherwise have realized that this would likely have larger impact on the overall migration.

After we identified that the database had deadlocked, we resorted to restarting our postgres container, then run the migration again. Once we restarted the database, everything was back online in less than 30 seconds, which includes first running the remaining migrations and then starting up all containers again.

When we tested this process on our test instance prior to deploying this to the Lemmy.World production environment we did not run into this issue. Everything was working fine with the backend services running on Lemmy 0.19.9 and the database being upgraded to Lemmy 0.19.10 schema already, but the major difference here is the lack of user activity during the time of the migration.

Our learning from this is to always plan for downtime for Lemmy updates if any database migrations are included, as it does not appear to be possible to "safely" apply them even if they seem small enough to be theoretically doable without downtime.

28
29
 
 

French President Emmanuel Macron says that a proposed European armed force for possible deployment in Ukraine in tandem with an eventual peace deal could “respond” to a Russian attack if Moscow launched one.

Archived version: https://archive.is/newest/https://apnews.com/article/france-uk-ukraine-russia-war-military-11b305c4073f476318ea0c4fd0c01354


Disclaimer: The article linked is from a single source with a single perspective. Make sure to cross-check information against multiple sources to get a comprehensive view on the situation.

30
 
 

Can I get a down button in the comments to the next comment thread so I don't have to scroll?

Also, it feels like I should have a subscribe and a leave button to sub to communities. I'm long pressing then tapping subscribe. Would love a single tap option.

Love the app even tho I'm new!

31
 
 
32
 
 

cross-posted from: https://lemmy.world/post/27480772

I hope this gets defeated by the courts or will everyone else's union job be next?

33
 
 

In addition to supporting jobs that address oil patch pollution, these federal dollars are used on wells that lack any owner to pay for reclamation. Left unplugged, such orphaned oil and gas wells leak huge amounts of methane into the atmosphere and can contaminate local water sources with salty water and benzene.

The Interior Department estimates that there are about 157,000 documented orphaned oil and gas wells nationwide. This figure is likely a dramatic undercount: The Environmental Protection Agency stated in an April 2021 report that there could be as many as 3.4 million abandoned wells nationally.

“Undocumented orphaned wells may emit nearly 63 million grams of methane per hour into the atmosphere,” according to a November 2024 report, “the equivalent of over 3.6 million gasoline-powered passenger cars driven per year.”

Orphaned wells represent the final stage in what ProPublica recently described as the oil industry’s “playbook”: When oil wells are no longer productive, large companies sell them off to smaller companies and thereby shed their obligation to plug those wells.

The increasingly marginal wells change hands, eventually landing with operators who lack the financial means to plug them. And when these companies go bankrupt, the wells become orphaned, meaning that the plugging costs then fall on American taxpayers.

34
35
 
 

Les étudiants et les mouvements de citoyens critiquent aussi bien les coupes budgétaires du gouvernement indonésien que sa politique alimentaire et ses dérives autoritaires.

De nombreuses villes d’Indonésie sont depuis plusieurs semaines secouées par des manifestations de rues inédites dans ce pays depuis l’arrivée au pouvoir du président Prabowo Subianto. Un phénomène qui témoigne du profond mécontentement de la population envers les méthodes jugées autoritaires et prédatrices de son gouvernement.

Ces manifestations, ouvertement critiques à l’égard des cent premiers jours du mandat du président indonésien, arrivé au pouvoir le 20 octobre 2024, rassemblent de nombreuses associations d’étudiants, de même que des mouvements citoyens. Fait sans précédent dans l’archipel indonésien ces dernières années, elles ont essaimé dans presque toutes les principales villes.

36
 
 

cross-posted from: https://lemm.ee/post/59668524

37
 
 
38
39
 
 

cross-posted from: https://lemm.ee/post/59668524

40
 
 

Last time I posted I was in the process of figuring out a new place to live. Just wanted to check in and say I made the move and I'm okay. It was hard, and maybe not exactly as far as I wanted but it's better than the deep south. I'm making friends and have decent work. Hopefully life will be kind. Community is helping me a lot. Posting a photo I took this morning while slacking off and feeling cute. HRT for 1.5 years now.

41
42
 
 

The browser disables firefox telemetry and Pocket by default.

43
44
45
 
 

On Wednesday, the Riigikogu voted in favor of amending the Constitution to revoke the right of Russian and Belarusian citizens to vote in local elections. Holders of so-called grey passports will still be allowed to vote in the next round of local elections, but it will be the last time.

Archived version: https://archive.is/newest/https://news.err.ee/1609644830/estonia-amends-constitution-to-strip-russian-belarusian-citizens-of-right-to-vote


Disclaimer: The article linked is from a single source with a single perspective. Make sure to cross-check information against multiple sources to get a comprehensive view on the situation.

46
 
 

According to journalist Fatih Altaylı, Turkish Embassy in Canada has filmed protests made in front of the embassy and identified a student who attended the protest against the Erdogan regime, called them and confiscated their passport. Embassy has said "You're a protester, go take your passport from Imamoglu if you can" as their reasoning behind this action to the student.

47
 
 
48
49
 
 

On Wednesday, Cora Anderson, who works with the Russian scientist Kseniia Petrova, shared the news of Petrova’s detention on Facebook, saying the Russian scientist arrived at Boston Logan international airport on 16 February from a trip to France when she was stopped by US authorities.

According to Anderson, authorities revoked Petrova’s visa and told her that she was to be deported to Russia. In response, Petrova said that she feared political persecution and was instead sent by authorities to a detention facility, Anderson said.

50
view more: ‹ prev next ›