site banner
ZorbaTHut  1mo ago (text post)   1433 thread views

I Lost Some Stuff From The Database, Sorry

I've been pushing lately to fix up some of the giant outstanding code issues that made it hard to work on this. In no particular order, the codebase now has 70% code coverage and all routes with at least some coverage, Python has been updated to 3.13 (from 3.10), and all the packages have been updated, which probably fixes some security issues.

The last thing on this list was to get Postgres from Version 12 to Version 17. This, unfortunately, I screwed up a bit, thanks to a few dumb decisions and also discovering that one of my backup solutions was no longer working after I needed it. The end result is that we've lost some data; I'm not quite sure how much, but it should at least be under 24 hours.

Great apologies if anyone lost an effort-post.

The bad backup solution has been fixed, and better monitoring put in place so I'll know if that happens again; also, while I may literally never use this, I now have a better postgres update checklist that avoids this issue in, like, literally three separate ways, not counting the better backup validation.

40
Top Bottom Old Controversial Comments
Jump in the discussion.

No email address required.

shit happens. thanks for all of the stuff that goes well! we really appreciate it!

Thanks. Could be worse: you could be South Korean government IT.

Please explain.

G-Drive Fire Destroys 125,000 Officials' Data. (The "G" in G-Drive does not stand for "Google", but "Government".) No back ups.

Big Ouch.

All good bro, thanks for all you do to run this place!

You know where to find out postmortem template. You can use Gemini but be discreet about it. Drop a link to your PR in Slack when you're done.

(but srsly, thanks for your hard work and transparency)

Shit happens. Thanks for continuing to work on the Motte!

Thanks for the site! And please don’t sweat it

Thanks for all the hard work, Zorba, and for letting us know.

What is this place?

This website is a place for people who want to move past shady thinking and test their ideas in a court of people who don't all share the same biases. Our goal is to optimize for light, not heat; this is a group effort, and all commentators are asked to do their part.

The weekly Culture War threads host the most controversial topics and are the most visible aspect of The Motte. However, many other topics are appropriate here. We encourage people to post anything related to science, politics, or philosophy; if in doubt, post!

Check out The Vault for an archive of old quality posts. You are encouraged to crosspost these elsewhere.


Why are you called The Motte?

A motte is a stone keep on a raised earthwork common in early medieval fortifications. More pertinently, it's an element in a rhetorical move called a "Motte-and-Bailey", originally identified by philosopher Nicholas Shackel. It describes the tendency in discourse for people to move from a controversial but high value claim to a defensible but less exciting one upon any resistance to the former. He likens this to the medieval fortification, where a desirable land (the bailey) is abandoned when in danger for the more easily defended motte. In Shackel's words, "The Motte represents the defensible but undesired propositions to which one retreats when hard pressed."

On The Motte, always attempt to remain inside your defensible territory, even if you are not being pressed.


New post guidelines

If you're posting something that isn't related to the culture war, we encourage you to post a thread for it. A submission statement is highly appreciated, but isn't necessary for text posts or links to largely-text posts such as blogs or news articles; if we're unsure of the value of your post, we might remove it until you add a submission statement. A submission statement is required for non-text sources (videos, podcasts, images).

Culture war posts go in the culture war thread; all links must either include a submission statement or significant commentary. Bare links without those will be removed.

If in doubt, please post it!


Rules


Recommended Posts And Communities

Recommended Realtime Chats