🙃

[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.