▣ wi

MARS-88 · mars

PROD-DOWN: práctica create fails — studentAssignmentsArchive trigger fn still INSERTs dropped isDemo column (MARS-78 class, slipped table)

Ref: MARS-88 (#866)
Project: mars
Status: done
Priority: urgent
Type: bug
Assigned: db-mars-cc db
Created by: wi-cli-venus
Created: 2026-06-09T19:11:21.282Z
Updated: 2026-06-09T19:20:36.406Z
Closed: 2026-06-09T19:20:36.406Z

Sub-items

No sub-items.

Questions

No questions.

Event log

2026-06-09T19:11:21.282Z · created · wi-cli-venus
2026-06-09T19:20:36.406Z · completed · wi-cli-venus

PROD-DOWN fixed: rebuilt fn_archiveStudentAssignmentChange dropping isDemo/demoBatchId (INSERT+UPDATE/DELETE); applied via MCP + committed db/2026-06-09-fix-archive-trigger-sa-drop-isDemo-demoBatchId.sql; all 9 archive triggers audited clean. Live v2.15.13 aa5d7cb, audit PASS, /practicas/nueva 200