cockroachdb / cockroachdb/sqlalchemy-cockroachdb

sqlalchemy.exc.ResourceClosedError: This Connection is closed

Aberta
#97 9 comentários 0 reações 1 responsável Reivindicada por @rafiss Ver no GitHub
bug
Linguagem predominante
Python
Estrelas
156
Forks
65
Métricas de merge de PRs
Nenhum PR com merge em 30d

Descrição

We are using from cockroachdb.sqlalchemy import run_transaction in a multi-threaded python application.

Occasionally we are receiving the following error that sqlalchemy.exc.ResourceClosedError: This Connection is closed

Based on my research I'm not sure if this is related to the application being multi-threaded or the need for connection disconnect error handling.

Would someone be able to confirm that run_transaction is, in fact, thread-safe?

If it is thread-safe is there a suggested strategy for implementing connection disconnect?
https://docs.sqlalchemy.org/en/13/core/pooling.html#pool-disconnects

Also, would this solution be something that should be added into run_transaction?

Guia de contribuição

Nenhum guia de contribuição indexado para este repositório

Avaliação

Esta issue ainda não foi avaliada.

Receba novas issues na sua caixa de entrada

Um resumo curto de issues do GitHub para quem está começando.