cockroachdb / cockroachdb/sqlalchemy-cockroachdb
backoff in the transaction loop is problematic
- 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.