Method InsertChatDebugStep

coderd/database/querier.go:946–946

The CTE atomically locks the parent run via UPDATE, bumps its updated_at (eliminating a separate TouchChatDebugRunUpdatedAt call), and enforces the finalization guard: if the run is already finished, the UPDATE returns zero rows, the INSERT gets no source rows, and sql.ErrNoRows is returned. The UPD

(ctx context.Context, arg InsertChatDebugStepParams)

	// rows, and sql.ErrNoRows is returned. The UPDATE also serializes
	// with concurrent FinalizeStale under READ COMMITTED isolation.
	InsertChatDebugStep(ctx context.Context, arg InsertChatDebugStepParams) (ChatDebugStep, error)
	InsertChatFile(ctx context.Context, arg InsertChatFileParams) (InsertChatFileRow, error)
	InsertChatMessages(ctx context.Context, arg InsertChatMessagesParams) ([]ChatMessage, error)
	InsertChatModelConfig(ctx context.Context, arg InsertChatModelConfigParams) (ChatModelConfig, error)