Hacktoberfest 2026: los issues que los mantenedores marcaron para octubre, abiertos y aptos para principiantes. Explorar issues de Hacktoberfest

Async Thin: call_timeout returns DPY-4024 before RESET completes

Abierto
  • ¿Algo no está bien?
#624 0 comentarios 0 reacciones 0 asignados Ver en GitHub

Nadie ha tomado este issue todavía.

Evaluación

Dificultad
4/5
Tiempo estimado
1-2 días
Aptitud para principiantes
45/100
Tipo de issue
Error
Claridad
Bien especificado
Estado de actividad
Activo
Stack tecnológico
python
Área
backend-api-design, database

Línea de trabajo

Start by reading BaseAsyncProtocol._process_timeout_helper() and trace how _break_external() and _receive_packet(message) handle DATA and RESET marker packets. Compare that flow with the packet sequence described in the issue and inspect related async protocol tests for timeout recovery. Done means a timed out call completes BREAK/RESET recovery before raising DPY-4024, and a subsequent statement does not fail with DPY-4011.

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

Descripción

bug
  1. What versions are you using?
  • Oracle Database Free 23.5.0.24.7 (local testing); Observed in production against Oracle Database 19c.
  • python-oracledb 4.0.2 and 26.0.1, Thin mode. The same timeout-helper code is present on main (c92c8420).
  • Python 3.13, asyncio, on macOS arm64 and Linux arm64.
  • Production also uses uvloop and SQLAlchemy 2.0 (oracle+oracledb_async), but the reproduction below uses native python-oracledb only.
  • Oracle Client: not applicable (Thin mode).
  1. Is it an error or a hang or a crash?

An error after a timeout, followed by a delayed failure when reusing a connection that still reports healthy.

  1. What error(s) or behavior you are seeing?

With call_timeout = 500, a statement that completes between approximately 500 and 1000 ms can raise DPY-4024 while connection.is_healthy() returns True. The next statement on that connection waits approximately 1 second and fails with:

DPY-4011: the database or network closed the connection
socket timed out while recovering from previous socket timeout

Representative output from the original reproduction on 26.0.1, Linux arm64:

  sleep=0.6: call 1 DPY-4024, is_healthy=True
    call 2 DPY-4011 after 1.01s
  sleep=0.7: call 1 DPY-4024, is_healthy=True
    call 2 DPY-4011 after 1.01s
  sleep=0.8: call 1 DPY-4024, is_healthy=True
    call 2 DPY-4011 after 1.00s

This is timing-dependent: some runs recover successfully or return ORA-01013 on the next call. The same behavior was reproduced on 4.0.2.

Source inspection and packet traces point to incomplete BREAK/RESET recovery in BaseAsyncProtocol._process_timeout_helper():

self._break_external()
await self._receive_packet(message)
self._break_in_progress = False
errors._raise_err(errors.ERR_CALL_TIMEOUT_EXCEEDED, timeout=timeout)

If the first packet received is the completed statement's DATA response rather than a MARKER, the helper raises DPY-4024 without completing RESET. The trace shows the server's RESET marker arriving without a client RESET response. The next call clears buffered packets and sends a request while the server is still waiting for RESET.

  1. Does your application call init_oracle_client()?

No. Thin mode.

  1. Include a runnable Python script that shows the problem.
import asyncio
import os
import platform
import sys
import time

import oracledb

PARAMS = dict(
    user=os.environ["ORACLE_USER"],
    password=os.environ["ORACLE_PASSWORD"],
    dsn=os.environ["ORACLE_DSN"],
)

async def main():
   
    for sleep_s in (0.55, 0.6, 0.7, 0.8, 0.9):
        async with oracledb.connect_async(**PARAMS) as conn:
            print("connection.version:", conn.version)
            conn.call_timeout = 500
            with conn.cursor() as cur:
                try:
                    await cur.execute(
                        "begin dbms_session.sleep(:s); end;", [sleep_s]
                    )
                except oracledb.DatabaseError as exc:
                    print(
                        f"  sleep={sleep_s}: call 1 {exc.args[0].full_code}, "
                        f"is_healthy={conn.is_healthy()}"
                    )

                start = time.monotonic()
                try:
                    await cur.execute("select 1 from dual")
                    print("    call 2 ok")
                except oracledb.DatabaseError as exc:
                    print(
                        f"    call 2 {exc.args[0].full_code} "
                        f"after {time.monotonic() - start:.2f}s"
                    )


asyncio.run(main())
Lenguaje dominante
Python
Estrellas
455
Forks
119
Sin PR fusionados en 30 d

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 oracle/python-oracledb

Todos los issues de oracle/python-oracledb

Issues similares

Más issues de Python

Recibe los nuevos issues en tu correo

Un resumen breve de issues de GitHub para principiantes.