Retrieve transaction state from `sqlite3_txn_state`

Abierto
#849 0 comentarios 0 reacciones 0 asignados Ver en GitHub

Los mantenedores suelen responder en 1 día

Nadie ha tomado este issue todavía.

Evaluación

Dificultad
4/5
Tiempo estimado
3-5 días
Aptitud para principiantes
38/100
Tipo de issue
Nueva funcionalidad
Claridad
Bastante claro
Estado de actividad
Estancado
Stack tecnológico
java, sqlite
Área
database

Línea de trabajo

Start by reading the native binding code around NativeDB and how it exposes SQLite C API functions to Java; the issue does not name specific files or tests. Check how sqlite3_txn_state() can be exposed with the requested database argument, then identify or add coverage for the returned transaction state. Done means Java callers can retrieve that state for debugging.

Escrito por el modelo de indexación a partir del texto del issue.

Descripción

enhancement:SQLite impacts:JNI

Is your feature request related to a problem? Please describe.
Sometimes, it is necessary to debug transactions when things are getting stuck (a classic is where two threads are both attempting to upgrade a read lock to a write lock at the same time; that's horrible to hunt down and causes weird failures but only really in production use). Improving the tools for debugging such things would be a Good Thing™.

Note that the bug in question is not in SQLite or the Xerial driver, but in how it is being called. I'm asking for a tool to help find my own bugs.

Describe the solution you'd like
Access to the sqlite3_txn_state() function somehow would be nice (maybe as a transactionState(String) method of NativeDB?).

I'll not write a PR for this as I don't have experience with the binding of C API functions into Java.

Lenguaje dominante
Java
Estrellas
3.3k
Forks
676
Merge medio
1 d 15 h
PR fusionados (30 d)
18

Preparar el entorno

Primeros pasos

  1. Lee el issue completo y luego la guía de contribución del proyecto.
  2. Comenta en el issue que vas a ocuparte — evita que dos personas hagan lo mismo.
  3. Haz un fork del repositorio y trabaja en una rama.
  4. Abre un pull request que haga referencia al número del issue.

Más de xerial/sqlite-jdbc

Todos los issues de xerial/sqlite-jdbc

Issues similares

Más issues de Java

Recibe los nuevos issues en tu correo

Un resumen breve de issues de GitHub para principiantes.