Skip to content

Issue importing big catalog from VOTable  #56

@jeandet

Description

@jeandet

Timetable_archive_20231115_1045.tar.gz

Importing this catalog I get:

In [2]: tscat.import_votable("/home/jeandet/Downloads/Timetable_archive_20231115_1045/THEMIS_MPcrossings_2007-2016_V1.xml")
---------------------------------------------------------------------------
OperationalError                          Traceback (most recent call last)
File ~/.local/lib/python3.10/site-packages/sqlalchemy/engine/base.py:1910, in Connection._execute_context(self, dialect, constructor, statement, parameters, execution_options, *args, **kw)
   1909     if not evt_handled:
-> 1910         self.dialect.do_execute(
   1911             cursor, statement, parameters, context
   1912         )
   1914 if self._has_events or self.engine._has_events:

File ~/.local/lib/python3.10/site-packages/sqlalchemy/engine/default.py:736, in DefaultDialect.do_execute(self, cursor, statement, parameters, context)
    735 def do_execute(self, cursor, statement, parameters, context=None):
--> 736     cursor.execute(statement, parameters)

OperationalError: too many SQL variables

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    Status

    No status

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions