infryq

Yesterday we discovered that the API database had run out of integers to use as primary keys, and so while it had been merrily attempting to add new data every hour since Tuesday, it had instead been dropping that data on the floor. There are 1.5 billion rows in the database, and we’ve done enough deletions over the past nine months to account for 2.1 billion integer ids. Some kind of rite of passage, sure, but not my favorite thing to discover on a Friday. Spent all day in meetings and working to organize the direct fix (ALTER TABLE MODIFY COLUMN BIGINT UNSIGNED, which is likely to take 24 hours+ to run so we’re testing it in staging first) and all the cascading fixes (turn off the uploader so it stops throwing data on the floor, write a script to archive incoming data and organize it by day of delivery, assign folks to figure out how to reconstruct the deliveries from earlier this week that got dropped, work with the forecasting team to figure out what they’ll need to submit a forecast on Monday with this week’s data largely absent). It was. A lot. Benefit of working from home: lots of hug breaks with P.

Dinner, reviewed J’s science fair presentation, crossword, SG-1, snack, sleep. Dreamt of traveling to Singapore and Taiwan to visit K and J, who both lived there for some reason; J with his daughter and K with a bustling import/export business.

Deerskin continues, with new CWs for non consensual pregnancy, miscarriage, brain injury, and PTSD. It’s becoming a fairy tale about recovering from trauma, and while there’s a bit of deus ex machina in there, I’ve never read anything in fiction that goes to this much trouble to show what trauma recovery is like. It’s grueling at times, but super worth it so far.

Yesterday I added some options for curved back hems, and started a version
of the front where the darts are folded into new seamlines. I finished
Raven again. I get now why it’s important whether they’re gnyxvat gb gur
Enira be gb n arj tbq (jvgu jubz gurl unir ab nterrzragf), ohg jul vf Rbyb
fb greevsvrq bs gur fgbar jura ur svaqf vg naq fb oynfr nobhg gur fanxr?

P’s throat tickle had developed into painful soreness, but the first
appointment he could get wasn’t for two weeks, so he went to urgentcare
just in case it was strep. It wasn’t; probably allergies.

At work I added a student to the nell cluster, noticed sudo was running
slow, and “fixed” it hard enough that now I can’t log in. Sent a very
contrite message to helpdesk. Spent the rest of the afternoon chasing theo
bugs and optimizations.

P had the car on campus, drove us home, immediately dinner, trash, then we
went to the pottery for the second meeting of the soda firing class. I
trimmed and handled four mugs (with compliments on my handles, ☺️), and
dipped four bowls in a blue/orange/brown flashing slip. Next time I’ll
carve patterns into the slip inside a stripe. Home, crossword, sleep.

Yesterday I had a session with R, ate lunch from Rooted in the CC, and
spent the rest of the afternoon bashing on T’s servers. LDAP is still a
problem, and I’ve dug far enough into the mailing list archives to reach
the jerks who just say rtfm and insult others’ intelligence. Each of the
servers is also running sendmail for some ungodly reason, and the queues
filled up to the point of rejecting connections because of several cron
jobs (one every five minutes) hanging when they tried to access a stuck nfs
share. There are backups, both manual and automatic, of config files you
should never edit directly. No idea what my predecessor thought they were
doing.

P had the car on campus so we went to geagle on the way home and got almond
butter, dairy, and some stuff for the kitchen sink.

Dinner, P discovered a batch of forgotten romanesco whose funk we were
blaming on the sink, the crossword was quite challenging, and then bed.

Yesterday I repeated the morning/afternoon nlg/Android pattern. In the
morning I got the imperative/passive-perfect switch to work satisfactorily
by adding a new type that will uniformly apply the different grammar
transformations, and transparently handle effectors which haven’t been
updated yet. In the afternoon I got sucked into a morass of gradle issues,
eventually calling in an expert. Even with her help it took us over an hour
to get things running. Gradle error messages are almost completely useless.
On top of that, one of the more useful signals it could provide (what build
phase has the error) is completely ephemeral— it literally deletes it from
the screen before printing out the error messages. Just bad. Really bad.

After work P and I dodged raindrops to go to open studio. I trimmed my
candy dish, but the bowl I threw a week ago was still too wet. Probably
wrapped too tightly. I attempted to throw something new off the hump, but
the clay was stiff, and I didn’t wedge it enough, so it was mostly a
disaster. I wound up with a larger candy dish from the remnants. I also
glazed the beehive vase. Should be exciting.

Yesterday I finished spinning the Romney-mohair singles. At work I started
ripping apart the android app into separate concerns; not fun but necessary
if I want to make it obvious where the middleware needs to be installed.
After work I did a turn through the garden and picked beans and a couple of
the new white sweet pepper variety I’m growing this year. They have a mild
flavor, not sure they’re worth it. Spent the evening looking up kick and
treadle wheel designs. The industrially available design space is a lot
richer in the UK for human-powered wheels, which is not terribly surprising
I suppose. The Leach wheel has been implemented as a pared-down,
powder-coated metal version for both standing and sitting at £250. There’s
another variety called the SAVIAC which has a much more complex mechanism
but accepts gearing; nice for centering without having to treadle like a
panicked weasel.

Yesterday I finished binding the last two panel seams and started pinning
pleats. I spent most of the afternoon at work fixing grable errors, which
of course have very little to do with what you’re supposed to do to fix
them. Why are we still so bad at this?

Once home I watered the garden and picked coreopsis, calendula,
raspberries, blackcurrants, and gooseberries.

I’ve been listening to a pandora station seeded with k.d. lang and neko
case, and aside from a little too much Sarah McLaughlin it’s delightful.