Wrapping up volume 2 of Seven Seas’ new print edition of PSOH! Sometimes with comparisons to volume 3 of the original Tokyopop translation.

I’m posting the individual reactions on Mastodon and Bluesky, then rounding them up in the blog. Previous roundups in my PSOH fandom tag. You can pick up the books with my affiliate links here.

I made myself so hungry looking up the desserts named in this one, and I don’t think any of them are sold in my area. Boo.

Some recs:

Preorders are open for this comics anthology by Iranian cartoonists. Already got mine.

A long and thorough Megatokyo breakdown from an ex-fan. (“I think I hate it better than anyone else.”) The criticisms are well-founded and well-explained, so even though I have some nostalgic fondness for Megatokyo and I’m not on board with every criticism, I liked reading it anyway.

The Skyjacks podcast, an original fantasy actual-play series, was on my “to try” list for a while. Recently, I opened the RSS feed, scrolled to the bottom, downloaded the first few episodes…and was confused to realize that it was (a) picking up from an existing story and (b) set in the Star Wars universe?

Yeah, the same group of players did an extensive Star Wars fangame first, spinning off from a short Star Wars adventure in a different feed, then moved on to their own series and kept adding that to the same feed. It’s a good jumping-on point, though. I’m 11 episodes in and not stopping.

Got caught up with Sporadic Phantoms, which was the last new podcast I mentioned starting. It continues to be very good. There’s a big pivot in season 2, but I think they handled it well. And…the season isn’t finished, so now I’m on a cliffhanger. Fingers crossed they stick the landing.

Also watched season 2 of the Ranma 1/2 reboot. It had a lot more of the madcap Jenga-tower-of-connected-gags pacing that I was missing while watching s1, where the personalities are wildly pinballing off each other and if you look away for 30 seconds you’ll miss something great. My “they couldn’t fully do this in s1 because they were too busy establishing the characters” theory is panning out.

And I did end up rewatching Cosmic Princess Kaguya. Turns out it absolutely rewards a second watch. There’s one character who knows about The Reveal from the start, and the amount of “oh that’s what you meant, I see what you did there” is amazing.

Cat news: Vet checkup for Fiddlesticks the other day.

When she had dental problems last May, they said she was down from 7-ish pounds to 6-ish, and theorized “maybe she’s eating less because it hurts her teeth.” But the current visit said she’s 7-ish pounds…and said that she was already back to 7-ish pounds last July (the visit where she had the bad teeth out).

Wonder if their scale in May was just having problems.

She developed these two Mystery Bumps since the last visit — you can’t really see them, they’re pea-sized at most and have normal fur growing over them, it’s just something you can feel when petting her. Official vet analysis on those is “probably just cysts, could develop problems in the future, but as long as she isn’t messing with them, we won’t mess with them.”

And she’s not messing with them! Doesn’t seem to notice them at all.

Good job not having cancer, kitty.

As a lot of y’all probably noticed, AO3 had some extended downtime this past weekend.

They upgraded their database software on Saturday. The first crash happened with Sunday-evening traffic. AD&T (the committee of OTW volunteers who manage the AO3 software) painstakingly nursed the servers back onto their feet. Then they crashed again under Monday-evening traffic. (I’m describing this in US time zones, because it correlated with “the spike when USians get out of school/work and start opening fic en masse.”)

Official AO3 social-media posts haven’t named the software. I assumed because it’s a third-party vendor, and they (very reasonably!) don’t want the place getting deluged with angry emails from AO3’s wankiest users. But at this point, there’s other public confirmation that it’s MariaDB.

AO3’s public Jira board had two new tickets created while they were dealing with the downtime. There’s a helpful breakdown of the tech implications by siropsalot on Bluesky. In short:

“Audits cleanup job” – AO3 has been storing certain logs in a single giant table that updates forever and never gets archived or cleared, which is fine if you’re a small or low-traffic project, but bad if you’re one of the top 100 highest-traffic sites on the internet. (This is part of a long pattern of AO3 being, ah, poorly-designed for the scale of traffic it gets.) This ticket is to create a regular clearing-up process.

“Patch Devise to prevent excessive audits” – One specific user has a buggy older browser, which generated over 2 million entries in the giant table just for them. This ticket is to patch against that specific edge case.

(Denise was pretty alarmed by the first one, because the proposed fix might delete data the OTW is legally required to keep. That’s a tangent, this is mostly a post about the tech problems, I’m just throwing it in because it seems worth knowing.)

MariaDB also has a public Jira board. Which documents this bug in the version of the software that AO3 just upgraded to: ““Local temporary space limit reached” on not so rare occasions.”

AD&T brought the site back up on Tuesday. It’s been safely up ever since. My understanding is, it stayed up after tech support from MariaDB helped them troubleshoot and implement a workaround for that issue.

Disclaimer that I am not a programmer! Someone more technical might come along and correct me on this! AD&T is working on an official postmortem — hopefully after they catch up on some well-deserved sleep — which will be way more illuminating than anything I can figure out in the meantime.

But my impression right now is that “AO3 software has problems with huge poorly-managed piles of data” ran headlong into “MariaDB upgrade has problems with not allocating certain operations enough space,” and it went about as well as a 12′ truck trying to drive under the 11’8″ bridge.

(Except in this case it’s a more normal bridge, where safely-loaded trucks usually pass under it with no problem, while AO3 is…I guess a truck with an extra 5 feet of clearance, caused by a wobbly pile of stuff held on top of it with a precarious set of bungee cords?) (It’s not a perfect analogy, okay. But you get the point.)