// AI 步骤开始/完成的事务边界:执行前与回写前分别校验权限、租约和目标身份,防止迟到输出覆盖新状态。 package platform import ( "context" "database/sql" "encoding/json" "errors" "gitea.entroia.com/Zayden-Jung/foundry-core/internal/codex" ) // startCanvasStep 持工作区锁解析目标当前 owner,再检查租约、编辑权限与内容指纹,成功才将 queued 改 running。 // 不可执行时先释放事务,再调用完成流程记录拒绝状态,避免嵌套事务互锁。 func (s *service) startCanvasStep(ctx context.Context, run canvasQueueRun, step canvasAIStepPlan) (bool, error) { tx, err := s.db.BeginTx(ctx, nil) if err != nil { return false, err } defer tx.Rollback() if err = lockCanvasAIWorkspace(ctx, tx, run.Project, run.Workspace); err != nil { return false, err } board, identityOK, err := resolveCanvasAITarget(ctx, tx, run.Project, run.Workspace, step) if err != nil { return false, err } if !identityOK { tx.Rollback() _, err = s.finishCanvasStep(ctx, run, step, "", "target_removed", false) return false, err } _, role, permissionErr := lockMaterial(ctx, tx, run.Project, run.Workspace, board, run.Account) if permissionErr != nil || role == "viewer" { tx.Rollback() if permissionErr != nil && permissionErr != sql.ErrNoRows { return false, permissionErr } _, err = s.finishCanvasStep(ctx, run, step, "", "permission_revoked", false) return false, err } var active bool err = tx.QueryRowContext(ctx, `SELECT status='running' AND lease_id=$4 AND NOT cancel_requested FROM canvas_ai_runs WHERE project=$1 AND workspace_id=$2 AND id=$3 FOR UPDATE`, run.Project, run.Workspace, run.ID, run.Lease).Scan(&active) if err != nil { return false, err } if !active { tx.Rollback() _, err = s.finishCanvasStep(ctx, run, step, "", "generation_cancelled", false) return false, err } snapshot, err := loadCanvas(queueRequest(ctx), tx, run.Project, run.Workspace, board) if err != nil { return false, err } data := canvasNodeData(snapshot.Document)[step.NodeID] if !identityOK || data == nil || canvasTargetFingerprint(step.BoardID, step.NodeID, data) != step.Fingerprint { tx.Rollback() _, err = s.finishCanvasStep(ctx, run, step, "", "target_changed", false) return false, err } result, err := tx.ExecContext(ctx, `UPDATE canvas_ai_steps SET status='running',started_at=now() WHERE project=$1 AND workspace_id=$2 AND run_id=$3 AND id=$4 AND status='queued'`, run.Project, run.Workspace, run.ID, step.ID) if err != nil { return false, err } count, _ := result.RowsAffected() if count != 1 { return false, nil } if err = appendAIEvent(ctx, tx, run.Project, run.Workspace, run.ID, "step.running", response{"step_id": step.ID, "board_id": step.BoardID, "node_id": step.NodeID}); err != nil { return false, err } for _, edge := range run.Plan.Edges { if edge.Target == step.ID { if err = appendAIEvent(ctx, tx, run.Project, run.Workspace, run.ID, "edge.active", response{"logical_edge_id": edge.ID, "step_id": step.ID, "status": "active"}); err != nil { return false, err } } } if err = tx.Commit(); err != nil { return false, err } return true, nil } // finishCanvasStep 是文本/无输出失败路径的兼容包装,所有落库与事件逻辑集中在结构化完成函数。 func (s *service) finishCanvasStep(ctx context.Context, run canvasQueueRun, step canvasAIStepPlan, text, code string, started bool) (string, error) { return s.finishCanvasStepOutput(ctx, run, step, codex.CanvasOutput{Kind: "text", Text: text}, code, started) } // finishCanvasStepOutput 在同一事务中保存输出、条件应用、步骤终态与事件;已终态或租约失效则直接保留旧结果。 func (s *service) finishCanvasStepOutput(ctx context.Context, run canvasQueueRun, step canvasAIStepPlan, generated codex.CanvasOutput, code string, started bool) (string, error) { tx, err := s.db.BeginTx(ctx, nil) if err != nil { return "", err } defer tx.Rollback() var locked string err = tx.QueryRowContext(ctx, `SELECT id::text FROM workspaces WHERE project=$1 AND id=$2 FOR UPDATE`, run.Project, run.Workspace).Scan(&locked) if err != nil { return "", err } var runStatus string var cancelled bool var lease sql.NullString err = tx.QueryRowContext(ctx, `SELECT status,cancel_requested,lease_id::text FROM canvas_ai_runs WHERE project=$1 AND workspace_id=$2 AND id=$3 FOR UPDATE`, run.Project, run.Workspace, run.ID).Scan(&runStatus, &cancelled, &lease) if err != nil { return "", err } var oldStatus string err = tx.QueryRowContext(ctx, `SELECT status FROM canvas_ai_steps WHERE project=$1 AND workspace_id=$2 AND run_id=$3 AND id=$4 FOR UPDATE`, run.Project, run.Workspace, run.ID, step.ID).Scan(&oldStatus) if err != nil { return "", err } // 取消、删除失效和其他完成者已写出的终态优先,迟到 worker 结果不得改回成功。 if oldStatus != "queued" && oldStatus != "running" { return oldStatus, nil } if runStatus != "running" || !lease.Valid || lease.String != run.Lease { return oldStatus, nil } // 统一映射依赖失败、内容冲突、取消与生成错误,run.cancel_requested 优先于局部生成结果。 status := "succeeded" switch code { case "dependency_failed": status = "skipped" case "target_changed": status = "conflict" case "generation_cancelled", "target_removed": status = "cancelled" default: if code != "" { status = "failed" } } if cancelled { status = "cancelled" code = "generation_cancelled" } board, identityOK, err := resolveCanvasAITarget(ctx, tx, run.Project, run.Workspace, step) if err != nil { return "", err } eventBoard := board if !identityOK { eventBoard = step.BoardID } var appliedBoard any var appliedEvent response var output any var version any // 生成成功才保存可供恢复的输出;内容指纹冲突时仍保留 output,但不覆盖当前节点。 if code == "" && started { var outputID string err = tx.QueryRowContext(ctx, `SELECT gen_random_uuid()::text`).Scan(&outputID) if err != nil { return "", err } patch := response{} if generated.Kind == "image" { imageOutput, err := s.persistCanvasImage(ctx, tx, run, outputID, generated.Image) if err != nil { return "", err } output = imageOutput patch["src"] = imageOutput["src"] patch["assetId"] = imageOutput["assetId"] } else { output = response{"output_id": outputID, "kind": "text", "text": generated.Text} patch["text"] = generated.Text } _, role, permissionErr := lockCanvasAIRunRoute(ctx, tx, run.Project, run.Workspace, eventBoard, run.Account) if permissionErr != nil && permissionErr != sql.ErrNoRows { return "", permissionErr } if permissionErr != nil || role == "viewer" { status = "failed" code = "permission_revoked" } else { snapshot, err := loadCanvas(queueRequest(ctx), tx, run.Project, run.Workspace, eventBoard) if err != nil { return "", err } target := canvasNodeData(snapshot.Document)[step.NodeID] if image, ok := output.(response); ok && image["kind"] == "image" && identityOK { if _, err = tx.ExecContext(ctx, `INSERT INTO canvas_asset_bindings(project,workspace_id,asset_id,board_id) VALUES($1,$2,$3,$4) ON CONFLICT DO NOTHING`, run.Project, run.Workspace, image["assetId"], eventBoard); err != nil { return "", err } } // 仍使用原计划来源构造指纹,owner 变化由 canonical 稳定身份单独解析,拖动不造成假冲突。 if !identityOK || target == nil || canvasTargetFingerprint(step.BoardID, step.NodeID, target) != step.Fingerprint { status, code = "conflict", "target_changed" } else { change, err := prepareCanvasAIPatch(queueRequest(ctx), tx, run.Project, run.Workspace, snapshot, step.NodeID, patch) if err != nil { if !errors.Is(err, errAIInvalidPatch) && !errors.Is(err, errCanvasModel) && !errors.Is(err, errGraphCapacity) { return "", err } status, code = "failed", "generation_output_too_large" } else { if err = s.saveCanvasAIChange(queueRequest(ctx), tx, run.Project, run.Workspace, run.Account, change); err != nil { return "", err } version = change.Snapshot.Version appliedBoard = eventBoard applied := response{"step_id": step.ID, "board_id": eventBoard, "node_id": step.NodeID, "patch": patch, "canvas_version": change.Snapshot.Version} change.addTargetContext(applied, step) appliedEvent = applied } } } } // output 与 applied 是不同事件;换 owner 后的冲突附完整模型,客户端可定位当前显式应用目标。 if output != nil { event := response{"step_id": step.ID, "board_id": eventBoard, "origin_board_id": step.BoardID, "canonical_root": step.CanonicalRoot, "target_incarnation": step.TargetIncarnation, "node_id": step.NodeID, "output": output} if status == "conflict" && identityOK && step.CanonicalRoot != "" && eventBoard != step.BoardID { model, e := loadCanvasModel(ctx, tx, run.Project, run.Workspace, step.CanonicalRoot) if e != nil { return "", e } event["model"], event["document_format_version"], event["canvas_version"] = model.view(nil), canvasModelFormat, model.Versions[eventBoard] } if err = appendAIEvent(ctx, tx, run.Project, run.Workspace, run.ID, "step.output", event); err != nil { return "", err } } if appliedEvent != nil { if err = appendAIEvent(ctx, tx, run.Project, run.Workspace, run.ID, "step.applied", appliedEvent); err != nil { return "", err } } var outputJSON any if output != nil { encoded, _ := json.Marshal(output) outputJSON = encoded } _, err = tx.ExecContext(ctx, `UPDATE canvas_ai_steps SET status=$5,output=$6,error_code=NULLIF($7,''),applied_version=$8,applied_board_id=$9,completed_at=now() WHERE project=$1 AND workspace_id=$2 AND run_id=$3 AND id=$4`, run.Project, run.Workspace, run.ID, step.ID, status, outputJSON, code, version, appliedBoard) if err != nil { return "", err } if status != "succeeded" { if err = appendAIEvent(ctx, tx, run.Project, run.Workspace, run.ID, "step."+status, response{"step_id": step.ID, "board_id": step.BoardID, "node_id": step.NodeID, "status": status, "error": code}); err != nil { return "", err } } edgeStatus := "completed" if status == "failed" || status == "conflict" { edgeStatus = "failed" } else if status != "succeeded" { edgeStatus = "skipped" } for _, edge := range run.Plan.Edges { if edge.Target == step.ID { if err = appendAIEvent(ctx, tx, run.Project, run.Workspace, run.ID, "edge."+edgeStatus, response{"logical_edge_id": edge.ID, "step_id": step.ID, "status": edgeStatus}); err != nil { return "", err } } } if err = tx.Commit(); err != nil { return "", err } return status, nil } // completeCanvasRun 从数据库步骤聚合实际终态而非信任内存 results;仍有活跃步骤则不提前结束 run。 // 仅当前租约可清空租约并写 run.completed,兼容部分成功、全冲突和取消。 func (s *service) completeCanvasRun(ctx context.Context, run canvasQueueRun, _ map[string]canvasStepResult) error { tx, err := s.db.BeginTx(ctx, nil) if err != nil { return err } defer tx.Rollback() var status string var cancelled bool var lease sql.NullString err = tx.QueryRowContext(ctx, `SELECT status,cancel_requested,lease_id::text FROM canvas_ai_runs WHERE project=$1 AND workspace_id=$2 AND id=$3 FOR UPDATE`, run.Project, run.Workspace, run.ID).Scan(&status, &cancelled, &lease) if err != nil { return err } if status != "running" || !lease.Valid || lease.String != run.Lease { return nil } var succeeded, failed, conflicts, cancelledSteps, active int err = tx.QueryRowContext(ctx, `SELECT count(*) FILTER(WHERE status='succeeded'),count(*) FILTER(WHERE status='failed'),count(*) FILTER(WHERE status='conflict'),count(*) FILTER(WHERE status='cancelled'),count(*) FILTER(WHERE status IN('queued','running')) FROM canvas_ai_steps WHERE project=$1 AND workspace_id=$2 AND run_id=$3`, run.Project, run.Workspace, run.ID).Scan(&succeeded, &failed, &conflicts, &cancelledSteps, &active) if err != nil { return err } if active > 0 { return nil } status = "succeeded" if cancelled { status = "cancelled" } else if failed+conflicts+cancelledSteps > 0 { status = "failed" if succeeded > 0 { status = "partially_succeeded" } else if cancelledSteps > 0 && failed+conflicts == 0 { status = "cancelled" } else if conflicts > 0 && failed == 0 { status = "conflict" } } _, err = tx.ExecContext(ctx, `UPDATE canvas_ai_runs SET status=$4,completed_at=now(),lease_id=NULL,lease_until=NULL WHERE project=$1 AND workspace_id=$2 AND id=$3`, run.Project, run.Workspace, run.ID, status) if err != nil { return err } if err = appendAIEvent(ctx, tx, run.Project, run.Workspace, run.ID, "run.completed", response{"status": status}); err != nil { return err } return tx.Commit() }