WoW's auction house broke for nearly a week, thanks to a code change that made a database table go from roughly 40,000 rows to 'tens of millions'

World of Warcraft The War Within screenshots
(Image credit: Blizzard)

World of Warcraft: The War Within is off to a decent start—there's been a bit of a deserved fuss over the new expansion's early access pricing, but a surprisingly good story campaign, gorgeous world, and a continued lean towards alt-friendly flexibility seems to have put the ambitious Worldsoul Saga in good standing.

Most players, it seems, have been having a good time. Unless they want to use the auction house, that is. Late last week, the in-game auction house—which players use to buy and sell important goods for things like crafting items—was busted on certain regional servers for an appreciable amount of players.

Blizzard called attention to the issue on the forums August 29, though according to some players, the bug had been persisting far longer, as far back as Wednesday in the same week.

The "item not found" bug seemed to be inconsistently applied, making the theorycrafting as to the root cause all over the shop—with some players blaming powerful auction house addons and bots for the plague of technical issues. As one particularly peeved merchant writes on the game's subreddit: "it's really f*cking annoying that the AH is just under 300% capacity all the time by AH goblins trying to flip everything at once."

While I'm sure this state of affairs doesn't help, it turns out that the AH's current woes are due to a completely different problem, as stated by senior game producer Tom Ellis on Twitter:

"So what’s going on with the Auction House is an interesting tech problem, a well meaning and simple design change caused a DB table that used to hold 20-60k rows to now contain tens of millions." I know precious little about coding, but given that's (using 50,000 to 20 million as a number) a 400x increase in rows, uh—yeah. I think that'd do it.

It looks like the end is in sight, though, as Ellis writes: "Ok, got some holiday weekend engineering done by some heroes, AH performance should be significantly improved for now … CPU is still looking so much better (down from 150-200% CPU on each AH service to 40-50%), we should be good!"

It's a fun example of the kinds of stacking, mind-melting technical debt these old MMOs accrue over time. Earlier this year, Season of Discovery had some major issues thanks to layering tech, a feature that saved WoW 10 years ago but was causing massive problems for SoD's gameplay loops in the present. When it comes to maintaining games, every solution can cause another problem. While the situation's still a work-in-progress, players are at least reporting that the auction house is mostly working again, which means the price-flipping war is back on.

Harvey Randall
Staff Writer

Harvey's history with games started when he first begged his parents for a World of Warcraft subscription aged 12, though he's since been cursed with Final Fantasy 14-brain and a huge crush on G'raha Tia. He made his start as a freelancer, writing for websites like Techradar, The Escapist, Dicebreaker, The Gamer, Into the Spine—and of course, PC Gamer. He'll sink his teeth into anything that looks interesting, though he has a soft spot for RPGs, soulslikes, roguelikes, deckbuilders, MMOs, and weird indie titles. He also plays a shelf load of TTRPGs in his offline time. Don't ask him what his favourite system is, he has too many.

Read more
World of Warcraft has a currency problem: more than 500 kinds of tender can currently be used in the 20-year-old game
World of Warcraft The War Within screenshots
Dragonflight got WoW back on its feet, now we get to see if Blizzard can make the Worldsoul Saga run
Gallywix wears an uneasy smile as he's confronted by Xal'atath in WoW: The War Within.
World of Warcraft guild uses exploits to get world 'first' on the game's new raid, gets banned, puts its name backwards and does it again
Concept art of WoW's upcoming player housing system, showing a warm homestead with a welcoming figure in shade.
WoW flexes its MMO player housing system in a new blog post, and it really might just beat FF14's dated furniture placement into the dirt
A mug that reads home sweet home sitting on a wooden table in front of a fireplace in World of Warcraft
'No lotteries, and no onerous upkeep': World of Warcraft takes a cheeky potshot at Final Fantasy 14's egregious housing system as it readies up to unleash its own
Two goblins go for a joyride via the D.R.I.V.E system in World of Warcraft: The War Within.
WoW next big patch, Undermine(d), gets a release date, starting the countdown clock until my gaming time is entirely consumed with doing donuts in my new ride
Latest in World of Warcraft
Concept art of WoW's upcoming player housing system, showing a warm homestead with a welcoming figure in shade.
WoW flexes its MMO player housing system in a new blog post, and it really might just beat FF14's dated furniture placement into the dirt
Gallywix wears an uneasy smile as he's confronted by Xal'atath in WoW: The War Within.
World of Warcraft guild uses exploits to get world 'first' on the game's new raid, gets banned, puts its name backwards and does it again
A World of Warcraft dwarf and human character standing in front of the entrance to a delve dungeon
WoW's nerfed its poor Delve companion into a dwarf-shaped crater after his tank spec made them too easy, and people aren't happy
Three goblins from the goblin cartels smile confidently in WoW: The War Within's Undermine(d) patch.
WoW's new Undermine(d) patch had a live jazz ensemble recording its big-band bangers, and they got to improvise: 'Usually those were the takes that ended up in the final version'
Two goblins go for a joyride via the D.R.I.V.E system in World of Warcraft: The War Within.
WoW's new DRIVE system probably won't be used outside of its GTA-style goblin zone, but devs are 'going to think about' recycling its parts elsewhere
World of Warcraft The War Within screenshots
Delves have given WoW's devs the confidence to put mandatory grinds firmly in the rear-view, says game director Ion Hazzikostas
Latest in News
Gabe Newell in a Valve promotional video, on a yacht.
Go ahead and complain the discounts aren't as steep as they used to be, but Steam just had its biggest year ever for seasonal sales
Valve Steam Deck OLED handheld PC
'The future of hardware at Valve is bright': Valve celebrates the success of Steam Deck and Steam OS
Key art of the videogame Lunacid, showing a pale, long haired knight in purple armor contemplating a purple, flaming sword surrounded by the different phases of the moon.
One of my favorite indie RPGs is getting a follow-up made with FromSoftware's 25-year-old Super Mario Maker for first person dungeon crawlers
Kingdom Come: Deliverance 2 image - Henry riding a pink and blue striped horse while holding a fish
Kingdom Come: Deliverance 2 now has Steam Workshop support, and of course one of the first mods lets you adjust the 'jiggle physics'
Still image of Bastion holding a bird, taken from Microsoft's Copilot for Gaming reveal trailer
Microsoft unveils Copilot for Gaming, an AI-powered 'ultimate gaming sidekick' that will let you talk to your console so you don't have to talk to your friends
Erenshor - A player and two simulated MMO party members stand on a plateau in front of a yellow landscape
This RuneScape-looking 'simulated MMORPG' has all the nostalgia without the drama because all the other 'players' are NPCs