Hacktoberfest 2026: le issue che i maintainer hanno segnato per ottobre, aperte e adatte ai principianti. Sfoglia le issue Hacktoberfest

DPY-3021: OSON version 2 is not supported when selecting a JSON column after an in-place update (23.26)

Aperta
  • Qualcosa non va?
#622 0 commenti 0 reazioni 0 assegnatari Vedi su GitHub

Nessuno ha ancora preso questa issue.

Valutazione

Difficoltà
4/5
Tempo stimato
3-5 giorni
Idoneità per principianti
55/100
Tipo di issue
Bug
Chiarezza
Specificata chiaramente
Stato di attività
Attiva
Stack tecnologico
python
Ambito
backend, databases

Direzione di ricerca

Start by locating the thin mode OSON decoder and its version checks; the report identifies the accepted versions but gives no source file or test path. Reproduce with an in-place JSON_MERGEPATCH update, then read the decoder tests and add coverage for selecting the updated JSON column. Done means the read succeeds and the async statement can be executed again without ORA-01002.

Scritto dal modello di indicizzazione a partire dal testo della issue.

Descrizione

  1. What versions are you using?
  • python-oracledb 26.0.1, thin mode
  • Oracle AI Database 26ai Free 23.26.3.0.0 (the gvenzl/oracle-free:23-faststart image)
  • Python 3.13.6, macOS arm64
  1. Is it an error or a hang or a crash?

An error.

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

Once a row's JSON column has been updated in place, for example with JSON_MERGEPATCH or JSON_TRANSFORM in an UPDATE, selecting that column fails:

oracledb.exceptions.NotSupportedError: DPY-3021: OSON version 2 is not supported

The OSON decoder accepts only versions 1 and 3 (TNS_JSON_VERSION_MAX_FNAME_255 and TNS_JSON_VERSION_MAX_FNAME_65535), and the database sends version 2 for a document updated in place. JSON_SERIALIZE(doc) and JSON_TRANSFORM(doc, KEEP '$') read the same row without error.

With the async API there is a second symptom. If the same statement is executed again on that connection, it fails with ORA-01002: fetch out of sequence. Other statements still work, so the failed cursor seems to stay in the statement cache.

node-oracledb 7.0.1 fails on the same read with NJS-126: OSON version 2 is not supported. I'm reporting it there separately.

  1. Does your application call init_oracle_client()?

No, thin mode.

  1. Include a runnable Python script that shows the problem.
import asyncio
import oracledb

DSN = dict(user="drivine", password="...", dsn="localhost:1521/FREEPDB1")

c = oracledb.connect(**DSN)
cur = c.cursor()
cur.execute("DROP TABLE IF EXISTS oson_v2")
cur.execute("CREATE TABLE oson_v2 (id NUMBER PRIMARY KEY, doc JSON)")
cur.execute("""INSERT INTO oson_v2 VALUES (1, JSON('{"name":"Ada","bio":"b0"}'))""")
cur.execute("""UPDATE oson_v2 SET doc = JSON_MERGEPATCH(doc, JSON('{"bio":"b1"}')) WHERE id = 1""")
c.commit()

cur.execute("SELECT JSON_SERIALIZE(doc) FROM oson_v2")
print(cur.fetchall())  # [('{"name":"Ada","bio":"b1"}',)]
cur.execute("SELECT doc FROM oson_v2")  # DPY-3021: OSON version 2 is not supported


async def main():
    a = await oracledb.connect_async(**DSN)
    for sql in ["SELECT doc FROM oson_v2", "SELECT 1 FROM dual", "SELECT doc FROM oson_v2"]:
        try:
            cursor = a.cursor()
            await cursor.execute(sql)
            print(await cursor.fetchall())
        except Exception as e:
            print(e)
    # DPY-3021: OSON version 2 is not supported
    # [(1,)]
    # ORA-01002: fetch out of sequence


asyncio.run(main())
Lingua principale
Python
Stelle
455
Fork
119
Nessuna PR unita negli ultimi 30g

Preparare l'ambiente

Come iniziare

  1. Leggi tutta la issue e poi la guida ai contributi del progetto.
  2. Commenta sulla issue per dire che te ne occupi tu — evita che due persone facciano lo stesso lavoro.
  3. Fai un fork del repository e lavora su un branch.
  4. Apri una pull request che faccia riferimento al numero della issue.

Altre issue di oracle/python-oracledb

Tutte le issue di oracle/python-oracledb

Issue simili

Altre issue su Python

Ricevi le nuove issue nella tua casella

Un breve riepilogo di issue GitHub adatte ai principianti.