langchain-ai/langgraph · error · ValueError

Error executing GET query

Error message

Error executing GET query: 
{query.query}
{query.params}
{e}

What it means

A defensive wrapper inside AsyncSqliteStore's batch GET processing (abatch path): after TTL refreshes, the SELECT for one namespace failed at the aiosqlite driver level and the exception is re-raised as ValueError together with the failing SQL text and bound parameters. Common root causes: database file locked/corrupt, schema mismatch after upgrades, or invalid stored data.

Solutions

1. Read the embedded query and params in the message to pinpoint the failing namespace lookup
2. Retry after releasing concurrent writers or closing other connections to the SQLite file
3. Re-run store setup/migrations if the items table schema predates current expectations

When it happens

Trigger: Thrown at libs/checkpoint-sqlite/langgraph/store/sqlite/aio.py:439 when the library encounters an invalid state.

Common situations: See trigger scenarios.

AI-assisted analysis of langchain-ai/langgraph@38031739e5 (2026-08-26). Data as JSON: /api/errors/7d55a720b391d2bc. Report an issue: GitHub.

Appendix: source

Thrown at libs/checkpoint-sqlite/langgraph/store/sqlite/aio.py:439

        # Process each namespace's operations
        for namespace, queries in namespace_queries.items():
            # Execute TTL refresh queries first
            for query in queries:
                if query.kind == "refresh":
                    try:
                        await cur.execute(query.query, query.params)
                    except Exception as e:
                        raise ValueError(
                            f"Error executing TTL refresh: \n{query.query}\n{query.params}\n{e}"
                        ) from e

            # Then execute GET queries and process results
            for query in queries:
                if query.kind == "get":
                    try:
                        await cur.execute(query.query, query.params)
                    except Exception as e:
                        raise ValueError(
                            f"Error executing GET query: \n{query.query}\n{query.params}\n{e}"
                        ) from e

                    rows = await cur.fetchall()
                    key_to_row = {
                        row[0]: {
                            "key": row[0],
                            "value": row[1],
                            "created_at": row[2],
                            "updated_at": row[3],
                            "expires_at": row[4] if len(row) > 4 else None,
                            "ttl_minutes": row[5] if len(row) > 5 else None,
                        }
                        for row in rows
                    }

                    # Process results for this query
                    for idx, key in query.items:

View on GitHub (pinned to 38031739e5)