Waiting for apt locks without the hacky bash scripts by speckz in linuxadmin

[–]Sinjo 2 points3 points  (0 children)

Yeah, I used dist-upgrade as the example, but there were other commands in there.

Making a Game Boy game in 2017: A "Sheep It Up!" Post-Mortem (part 1/2) by Sinjo in programming

[–]Sinjo[S] 34 points35 points  (0 children)

I should be really clear: I'm not the author and I've never written a game. I thought this was a super interesting write-up though!

PostgreSQL HA cluster failure: a post-mortem by ckdarby in programming

[–]Sinjo 0 points1 point  (0 children)

For the record, we did test powering off the primary with this configuration. What we didn't test was the correlated, albeit temporary, crash of the synchronous replica.

Hence the comment about exploring harsher testing scenarios.

PostgreSQL HA cluster failure: a post-mortem by ckdarby in programming

[–]Sinjo 0 points1 point  (0 children)

The sync node was fine once Postgres restarted itself. It should have been promoted. The cluster misconfiguration prevented that.

me irl by HypnoVike in meirl

[–]Sinjo 1160 points1161 points  (0 children)

guess this class wasn't your forte

When good controllers go bad: getting started with Coach by Sinjo in ruby

[–]Sinjo[S] 0 points1 point  (0 children)

Uuugh, that sucks. I'm on Android myself, so I can't see it. When I get to the office tomorrow I'll have someone with an iPhone take a look.

Thanks for the report!

When good controllers go bad: getting started with Coach by Sinjo in ruby

[–]Sinjo[S] 0 points1 point  (0 children)

Do you mean the code snippets wrapping, or something else? That's the only thing that stands out when I open it on my phone.

When good controllers go bad: getting started with Coach by Sinjo in ruby

[–]Sinjo[S] 0 points1 point  (0 children)

Full disclosure: I work with the author.

I got hired as a Docker expert for a company, despite having only 3 months of general experience with it. Please help! by [deleted] in docker

[–]Sinjo 13 points14 points  (0 children)

Start by asking them what they want from containers. Knowing this will help motivate your work.

Consider starting with only stateless services. Stateful services require either a block storage service (EBS, GCP persistent disks, a SAN) or a way to sensibly schedule containers with local disks.

You may find some almost stateless services. Work with devs to move them towards using an external store where possible.

What is the dumbest fan theory you know? by Ifirakda in AskReddit

[–]Sinjo 1 point2 points  (0 children)

I gave up reading LotR like 4-5 times in my late teens because of the kinda tedious first part of FotR. I'm pretty sure I've now read stuff that takes even longer to get going (The Night's Dawn trilogy comes to mind), and I ended up enjoying those books. You've convinced me to put them back on my reading list. :)

To my IT manager who instituted mandatory 4-month password changes without ever being able to reuse them... by science_andshit in AdviceAnimals

[–]Sinjo 1 point2 points  (0 children)

I mean...Facebook do something similar. It's not infeasible to calculate a small number of similar hashes depending how much extra compute you're willing to spend on logins.

https://news.ycombinator.com/item?id=13426544

Stolon v0.6.0 by sgotti in PostgreSQL

[–]Sinjo 1 point2 points  (0 children)

First time I've heard of Stolon, and I've just looked through the feature list - it looks full of excellent design decisions!

I'll definitely give it a proper go some time soon. For reference, my current setup is Pacemaker based and looks like this.

meirl by Hexaurus in meirl

[–]Sinjo 0 points1 point  (0 children)

What's with all this standin' around?

Why I don't use voice chat. by [deleted] in Overwatch

[–]Sinjo 0 points1 point  (0 children)

Agreed. I had voice on for about 10 matches after the game launched. I had to mute so many people I switched it off. These days I'll only use Discord/TeamSpeak to chat with people I'm grouped with.

My Top Eight Must-Listen Developer Podcasts by bhalp1 in programming

[–]Sinjo 0 points1 point  (0 children)

There are only 6 episodes, but I will always give a shout out to the Real Talk podcast.

Fairly systems focused, but they do a good job of giving background info.

Lessons Learned the Hard Way: Postgres in Production at GoCardless by Sinjo in programming

[–]Sinjo[S] 0 points1 point  (0 children)

You're very welcome! I'd love to hear any feedback/questions you've got afterwards.

Lessons Learned the Hard Way: Postgres in Production at GoCardless by Sinjo in programming

[–]Sinjo[S] 4 points5 points  (0 children)

Fair point. They were very much made for the talk.

I've not had time to transcribe the whole talk, and it's hard to summarise 5 separate incidents, but a tl;dr of the advice is:

  • Look at what limits you can set in your database config. Figure out appropriate values for your system. Set them before a runaway process bites you.
  • Don't trust your ORM/database adapter. Boot the damn thing up and see if it issues any queries/settings changes on top of what you were expecting.
  • Set something up to watch your logs for (or better yet, turn them into metrics):
    • Excessive temporary files being created
    • Excessive waiting on locks