Skip to content
Python
3.7 KB
Raw Blame
//! SDK-managed execution ownership. One host per schema; PostgreSQL durability
//! does not imply that an embedded SDK has enabled distributed scheduling.
use crate::db::Database;
use anyhow::{ensure, Result};
impl Database {
    pub(crate) fn claim_sdk_host(
        &mut self,
        coworkers: &[String],
    ) -> Result<
        Vec<(
            openworker_runtime::store::Session,
            openworker_runtime::team_type_catalog::Record,
        )>,
    > {
        ensure!(
            self.leases.is_empty(),
            "SDK host must claim before starting sessions"
        );
        let locked: bool = self
            .client
            .query_one(
                "SELECT pg_try_advisory_lock(hashtext(current_schema()), 18475001)",
                &[],
            )?
            .get(0);
        ensure!(locked, "Another SDK host owns this PostgreSQL schema");
        let mut tx = self.client.transaction()?;
        let marked: bool = tx
            .query_one("SELECT EXISTS(SELECT 1 FROM sdk_host_mode)", &[])?
            .get(0);
        if !marked {
            let empty: bool = tx
                .query_one("SELECT NOT EXISTS(SELECT 1 FROM sessions)", &[])?
                .get(0);
            ensure!(empty,"Use a fresh PostgreSQL schema for SDK-managed execution; distributed sessions cannot be silently adopted");
            tx.execute("INSERT INTO sdk_host_mode VALUES(TRUE,'sdk')", &[])?;
        }
        let parents = coworkers.iter().cloned().collect();
        let mut restored = vec![];
        for row in tx.query("SELECT data FROM agent_teams WHERE data ? 'type_catalog' AND data->'type_catalog' <> 'null'::jsonb", &[])? {
            let doc: openworker_runtime::agent_team::Document = serde_json::from_value(row.get(0))?;
            let lead = doc.roster.instance(&doc.lead).ok_or_else(|| anyhow::anyhow!("Missing catalog lead"))?;
            let lead: openworker_runtime::store::Session = serde_json::from_value(tx.query_one("SELECT data FROM sessions WHERE id=$1", &[&lead.session_id])?.get(0))?;
            restored.extend(openworker_runtime::team_type_catalog::restore(&doc, &lead, &parents)?);
            for instance in doc.roster.instances().filter(|i| doc.type_bindings.contains_key(&i.agent_id)) {
                if let Some(row) = tx.query_opt("SELECT data FROM sessions WHERE id=$1", &[&instance.session_id])? {
                    let child: openworker_runtime::store::Session = serde_json::from_value(row.get(0))?;
                    ensure!(child.coworker == openworker_runtime::agent_team::runtime_type(&doc, instance)? && child.agent_team.as_ref().is_some_and(|m| m.team_id == doc.id && m.agent_id == instance.agent_id), "Private child lost its approved type pin");
                }
            }
        }
        let mut allowed = coworkers.to_vec();
        allowed.extend(restored.iter().map(|(_, r)| r.runtime_id()));
        let valid:bool=tx.query_one("SELECT NOT EXISTS(SELECT 1 FROM sessions WHERE NOT (data->>'coworker'=ANY($1)) OR data ? 'environment')",&[&allowed])?.get(0);
        ensure!(
            valid,
            "SDK coworker configuration does not cover persisted sessions"
        );
        // Holding this connection-level lock proves any previous SDK database
        // connection has closed. Fence its epochs before recovery, retaining
        // uncertain effects rather than replaying them.
        tx.execute("UPDATE sessions SET expires=clock_timestamp()", &[])?;
        let ids: Vec<String> = tx
            .query("SELECT id FROM sessions ORDER BY id", &[])?
            .into_iter()
            .map(|r| r.get(0))
            .collect();
        tx.commit()?;
        for id in ids {
            self.claim(&id)?;
        }
        Ok(restored)
    }
}