I'm trying to use bulk_insert_mapping with SQL Alchemy and Firebird and I'm facing an issue. Note that a normal insert with session.add() works well.
# This is a simple example that bulk insert filenames in history table
session.bulk_insert_mappings(
Historique,
[dict(fichier=f'fichier_{i}') for i in range(1, 10)]
)
session.commit()
And I'm getting the following error:
ERROR sqlalchemy.pool.impl.QueuePool:base.py:1868 Error closing cursor
Traceback (most recent call last):
File "/home/manu/Dev/my_project/env/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1786, in _execute_context
result = context._setup_result_proxy()
File "/home/manu/Dev/my_project/env/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 1406, in _setup_result_proxy
result = self._setup_dml_or_text_result()
File "/home/manu/Dev/my_project/env/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 1488, in _setup_dml_or_text_result
strategy.alternate_cursor_description or self.cursor.description
File "/home/manu/Dev/my_project/env/lib/python3.8/site-packages/fdb/fbcore.py", line 3554, in __get_description
if self.__valid_ps():
File "/home/manu/Dev/my_project/env/lib/python3.8/site-packages/fdb/fbcore.py", line 3552, in __valid_ps
and not dir(self._ps))
ReferenceError: weakly-referenced object no longer exists
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/home/manu/Dev/my_project/env/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1865, in _safe_close_cursor
cursor.close()
File "/home/manu/Dev/my_project/env/lib/python3.8/site-packages/fdb/fbcore.py", line 3643, in close
if is_dead_proxy(self._ps):
File "/home/manu/Dev/my_project/env/lib/python3.8/site-packages/fdb/fbcore.py", line 481, in is_dead_proxy
return isinstance(obj, weakref.ProxyType) and not dir(obj)
ReferenceError: weakly-referenced object no longer exists
This is how I create the session:
@lru_cache()
def _get_session_maker(user, password, host, port, name, echo):
try:
engine = create_engine(
f'firebird://{user}:{password}@{host}'
f':{port}/{name}?charset=utf8',
echo=echo)
# Test que la base existe bien sur le serveur
engine.execute(text("SELECT 1 FROM RDB$DATABASE")).fetchone()
return sessionmaker(autocommit=False, autoflush=False, bind=engine)
except DatabaseError as e:
raise DatabaseError(f"-- Base '{name}': Connexion impossible", e.params, e.orig)
I'm using bulk_insert_mapping on a PostgreSQL database in the same way and I don't have any problem. How can I solve this?
