Skip to content

OperationalError for graph.successors(node_ids=node_ids) #249

@yfukai

Description

@yfukai

A similar issue to that resolved in #208 still exists for graph.successors(node_ids=verified_nodes).

---------------------------------------------------------------------------
OperationalError                          Traceback (most recent call last)
File c:\Users\owner\Desktop\fukai\.venv\Lib\site-packages\sqlalchemy\engine\base.py:1967, in Connection._exec_single_context(self, dialect, context, statement, parameters)
   1966     if not evt_handled:
-> 1967         self.dialect.do_execute(
   1968             cursor, str_statement, effective_parameters, context
   1969         )
   1971 if self._has_events or self.engine._has_events:

File c:\Users\owner\Desktop\fukai\.venv\Lib\site-packages\sqlalchemy\engine\default.py:952, in DefaultDialect.do_execute(self, cursor, statement, parameters, context)
    951 def do_execute(self, cursor, statement, parameters, context=None):
--> 952     cursor.execute(statement, parameters)

OperationalError: too many SQL variables

The above exception was the direct cause of the following exception:

OperationalError                          Traceback (most recent call last)
Cell In[9], line 1
----> 1 candidates = graph.successors(node_ids=verified_nodes)
      2 candidates = set(candidates) - set(verified_nodes)

File c:\Users\owner\Desktop\fukai\.venv\Lib\site-packages\tracksdata\graph\_sql_graph.py:1106, in SQLGraph.successors(self, node_ids, attr_keys, return_attrs)
   1065 def successors(
   1066     self,
...
[SQL: SELECT "Edge".source_id, "Node".node_id 
FROM "Node" JOIN "Edge" ON "Edge".target_id = "Node".node_id 
WHERE "Edge".source_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ....

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions