Autumnal Ash @ashfurrow@mastodon.technology

folks, computer programming. what a concept

https://mastodon.technology/media/OfoK110gxuTA4KNRwsc https://mastodon.technology/media/xsLADsZRdTM9dOIYXeE

Okay, rapid fire: Celsius, Greco pizza, the CBC, the trans Canada walking trail, proximity to Halifax, folk music, the Harvest Jazz and Blues Festival, farmers markets... oh and let’s not forget my family! My niece and nephew have grown up nearly a year since I saw them!!!

The place has fibre internet, which is very cool. We’ll have an extra bedroom for a home office. I’m going to get a couch, in my office, for when I need to step back and ponder my work. Amazing.

The accent... oh my gosh. People will finally sound right to me again. I can’t wait to stop correcting my own accent too and let myself sound like a maritimer again. (There are some lines I won’t cross, though – for example I’ll never call it “kwee-beck”.)

Okay more things I’m excited about... (moving to unlisted so as to not spam people)

New Brunswick has this incredible microbrewery called Picaroons (any lumberjack fans out there? jk I know there are). Their beers are *amazing* and all have really great stories and regional names. Can’t wait for next summer’s Dooryard ale, but I’ll have the Winter Warmer to, well, keep me warm ☺️

Other things I’m keen on... hmm...

A yard. Like a front yard. Not having a a door that opens to a hallway, but just to the outside. A freaking mailbox. A garbage day.

I’m trying not to gloat or whatever, but five years living in New York has lowered my bar of a nice apartment to “oh my god, you have like a whole two rooms? Separated by a door? Amaaaaaazing.”

One thing I’m looking forward to about living back in New Brunswick is a larger apartment with a home office (I’ll be working remotely for... ever haha).

My desk in new York is comically small, and a bigger space means a bigger desk, and enough room for me to put a lil basket on it, like a sourdough basket, for my cat to sleep in. Next to my monitor, while I work 💤 😺

@bclindner okay so, all the queries I killed were identical, a complex SELECT (I took a screenshot). So far there’s one that’s come back. I’m going to set a two-minute timeout on our Postgres install to prevent this from happening again. Two minutes is still very generous, and longer than our nginx timeout, so the API should be unaffected. Let me know if you (or, indeed, if any curious watchers) have questions!

@bclindner load was spiking way up so just I killed the queries.

@bclindner haha wait, I’m see mdszy in the logs when I grep for delete... maybe
@skelly ‘s auto-delete script is running?

@bclindner ah, forgot to say that one of the queries I found was this:

DELETE FROM "accounts" WHERE "accounts"."id" = $1

It only took a few minutes to complete though 😅

@bclindner I’m seeing instance slowdown. iotop showed a Postgres DELETE query using a lot of disk IO and PGHero indicates there are *nine* long-running queries currently being executed. Some have been active for almost 40 minutes (whaaaat).

My theory is that a user with many status has deleted their account and Postgres is chewing through the work to make that happen. I’m monitoring, and if need be we can kill the queries in PGHero.

oh hey I'm moving back to Canada next month, cool https://ashfurrow.com/blog/moving-home-to-new-brunswick/

It’s #NationalComingOutDay, which is cool! Coming out as bi was hard for me, but now how I think of myself internally finally overlaps with how I present myself externally, which lifted a heavy mental burden. It was hard but so, so worth it.

Someone said earlier today that the hardest person you’ll come out *to* is yourself. It was for me, anyway. So if you’re discovering stuff about yourself only now, today is for you, too.

those three numbers? they aren’t real, they can’t hurt you

load averages are a myth, they do not exist

one of the only days that Americans and the rest of the world agree on the order of the numbers. it’s like a -40° but on a calendar.

good morning

I didn’t even mean to do this, I was just testing out a PSD of the Apple Watch mock-up and had the three worf morn photo handy.

folks we have productized the three worf morn watch face [cw face]

once again, I've forgotten to book off Canadian Thanksgiving 😪 it sneaks up on me every year and I'll just say it: American Thanksgiving is too close to Christmas. Sorry but it's true.

not really curious, more angry is all