BerriAI/litellm · error · RuntimeError

Error retrieving usage data: {exc}

Error message

Error retrieving usage data: {exc}

What it means

Error "Error retrieving usage data: {exc}" thrown in BerriAI/litellm.

Source

Thrown at litellm/integrations/focus/database.py:101

            ut.user_email as user_email,
            COALESCE(vt.organization_id, tt.organization_id) as organization_id,
            ot.organization_alias as organization_alias
        FROM "LiteLLM_DailyUserSpend" dus
        LEFT JOIN "LiteLLM_VerificationToken" vt ON dus.api_key = vt.token
        LEFT JOIN "LiteLLM_TeamTable" tt ON vt.team_id = tt.team_id
        LEFT JOIN "LiteLLM_UserTable" ut ON dus.user_id = ut.user_id
        LEFT JOIN "LiteLLM_OrganizationTable" ot
            ON ot.organization_id = COALESCE(vt.organization_id, tt.organization_id)
        {where_clause}
        ORDER BY dus.date DESC, dus.created_at DESC
        {limit_clause}
        """

        try:
            db_response: Final = await client.db.query_raw(query, *query_params)
            return pl.DataFrame(db_response, infer_schema_length=None)
        except Exception as exc:
            raise RuntimeError(f"Error retrieving usage data: {exc}") from exc

    async def get_table_info(self) -> dict[str, Any]:
        """Return metadata about the spend table for diagnostics."""
        client: Final = self._ensure_prisma_client()

        info_query: Final = """
        SELECT column_name, data_type, is_nullable
        FROM information_schema.columns
        WHERE table_name = 'LiteLLM_DailyUserSpend'
        ORDER BY ordinal_position;
        """
        try:
            columns_response: Final = await client.db.query_raw(info_query)
            return {"columns": columns_response, "table_name": "LiteLLM_DailyUserSpend"}
        except Exception as exc:
            raise RuntimeError(f"Error getting table info: {exc}") from exc

View on GitHub (pinned to 6c2dcb801b)

Solutions

1. Check the database connection and the daily usage table; see the wrapped exception.

When it happens

Trigger: Thrown at litellm/integrations/focus/database.py:101 when the library encounters an invalid state.

Common situations: See trigger scenarios.

AI-assisted analysis of BerriAI/litellm@6c2dcb801b (2026-08-15). Data as JSON: /api/errors/84644a2b034547f7. Report an issue: GitHub.