mem0ai/mem0 · error · ValueError

Collection {self.collection_name} not found

Error message

Collection {self.collection_name} not found

What it means

Error "Collection {self.collection_name} not found" thrown in mem0ai/mem0.

Source

Thrown at mem0/vector_stores/oracledb.py:551

            table_name,
            (SELECT COUNT(*) FROM {self.collection_name}) AS row_count,
            (SELECT
                ROUND(SUM(bytes) / 1024 / 1024, 2) || ' MB'
            FROM user_segments
            WHERE segment_name = :table_name
            AND segment_type = 'TABLE'
            ) AS total_size
        FROM all_tables
        WHERE table_name = :table_name
        AND owner = NVL(:owner, USER)
        """

        with self._get_cursor() as cursor:
            cursor.execute(sql, table_name=table_name, owner=owner)
            result = cursor.fetchone()

        if result is None:
            raise ValueError(f"Collection {self.collection_name} not found")

        return {"name": result[0], "count": result[1], "size": result[2]}

    def _split_collection_name(self) -> tuple[Optional[str], str]:
        """Split the quoted collection name into its optional owner and table parts."""
        segments = re.findall(r'"([^"]+)"', self.collection_name)
        if len(segments) > 1:
            return segments[-2], segments[-1]
        return None, segments[-1]

    def list(self, filters: Optional[Dict[str, Any]] = None, top_k: Optional[int] = 100) -> List[List[OutputData]]:
        """
        List all vectors in a collection.

        Args:
            filters (Dict, optional): Filters to apply to the list.
            top_k (int, optional): Number of vectors to return. Defaults to 100.

View on GitHub (pinned to 001c235229)

Solutions

1. Create the collection first or verify the collection_name matches an existing table.

When it happens

Trigger: Thrown at mem0/vector_stores/oracledb.py:551 when the library encounters an invalid state.

Common situations: See trigger scenarios.

AI-assisted analysis of mem0ai/mem0@001c235229 (2026-08-15). Data as JSON: /api/errors/7e4292482a81b96f. Report an issue: GitHub.