cockroachdb / cockroachdb/sqlalchemy-cockroachdb

backoff in the transaction loop is problematic

Abierto
#188 5 comentarios 0 reacciones 0 asignados Ver en GitHub
Lenguaje dominante
Python
Estrellas
156
Forks
65
Métricas de merge de PR
Sin PR fusionados en 30 d

Descripción

In cockroach, when using the `SAVEPOINT cockroach_restart` technique to recover from serializable restarts, the transaction's locks are held across restarts. This enables liveness among contended transactions. In the driver today, there's exponential backoff in those restarts. That means that locks will be held for a long period of inactivity, exacerbating the cost of contention potentially greatly.

See https://github.com/cockroachdb/sqlalchemy-cockroachdb/blob/19e66cce1c1cafaf762cf587d46549dd6b43b3cf/sqlalchemy_cockroachdb/transaction.py#L77-L90

Guía de contribución

No hay ninguna guía de contribución indexada para este repositorio

Evaluación

Este issue todavía no se ha evaluado.

Recibe los nuevos issues en tu correo

Un resumen breve de issues de GitHub para principiantes.