Post-mortems concept: blameless culture (Etsy/Google exemplars), document anatomy (summary/impact/timeline/root-cause/action-items/lessons), 5 Whys + fishbone RCA, action item tracking discipline, anti-patterns ("human error" root cause). Four scenarios: timeline reconstruction, 5 whys analysis, monthly action item retro, blameless vs accountability. ADR on blameless vs accountability tension.
A postmortem is a durable learning record after an incident or near miss. It reconstructs impact and timeline from evidence, explains contributing technical and organizational conditions without hindsight blame, and creates concrete follow-up work. A template can help, but Google does not prescribe one universal number of required sections for every organization.
Blameless does not mean consequence-free or evidence-free. It means the analysis avoids treating a person’s action as a sufficient cause and asks why the action made sense in context and which controls were absent or ineffective. Accountability appears through clear owners, priorities, tracked work, measurable endpoints, and review of whether risk actually fell.
NOT NULL column without a suitable default to a table that already contains rows fails while checking existing rows. A safe staged migration can add nullable, backfill in batches, validate, then enforce the constraint.NOT NULL constraint requires existing rows to satisfy it; staged backfill/validation avoids pretending the invalid schema would install and fail only later at runtime.Evidence to reviewed record. The author separates observed facts, hypotheses and decisions, then peers review the system conditions without personal blame.
Correct NOT NULL migration analysis. Existing rows make an immediate NOT NULL check relevant; the corrective action stages backfill and validation before enforcement.
Accountable action lifecycle. A material finding becomes owned work and is closed only after the expected control is measured.
Historical claim discipline. Named incidents are attributed to their primary RCA and are not rewritten to fit a favorite failure category.
NOT NULL с существующими NULL успешно установлен и сломал только последующий request.Введите числа или выберите пресет