Re: [Django] #35655: Django crashes with Oracle database Version > 23.3

[Django]

#35655: Django crashes with Oracle database Version > 23.3
-------------------------------------+-------------------------------------
Reporter: Suraj Shaw | Owner: Suraj
| Shaw
Type: Bug | Status: assigned
Component: Database layer | Version: 5.1
(models, ORM) |
Severity: Release blocker | Resolution:
Keywords: | Triage Stage:
| Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 1 | UI/UX: 0
-------------------------------------+-------------------------------------
Comment (by Suraj Shaw):

The issue is reproducible.

Probable Fixes:

1 -> Switch to earlier version for multi-row insert (using select-union
combination) till the issue is being resolved.
2-> Migrate to ExecuteMany() instead of Execute() for multi-row insert.
3-> Migrate from NVARCHAR2 to VARCHAR2 as it also resolves the issue with
multi-row insert.
--
Ticket URL: <https://code.djangoproject.com/ticket/35655#comment:2>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.

[Django]

#35655: Django crashes with Oracle database Version > 23.3
-------------------------------------+-------------------------------------
Reporter: Suraj Shaw | Owner: Suraj
| Shaw
Type: Bug | Status: assigned
Component: Database layer | Version: 5.1
(models, ORM) |
Severity: Release blocker | Resolution:
Keywords: | Triage Stage:
| Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0

Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Suraj Shaw):

* easy: 1 => 0

--
Ticket URL: <https://code.djangoproject.com/ticket/35655#comment:3>

[Django]

#35655: Django crashes with Oracle database Version > 23.3
-------------------------------------+-------------------------------------
Reporter: Suraj Shaw | Owner: Suraj
| Shaw
Type: Bug | Status: assigned
Component: Database layer | Version: 5.1
(models, ORM) |
Severity: Release blocker | Resolution:
Keywords: | Triage Stage:
| Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Description changed by Suraj Shaw:

Old description:

> The recent optimisation in Django for multi-row insert in case of Oracle
> db version greater than 23+ is crashing with specific db versions. The
> issue is being reported [https://github.com/oracle/python-
> oracledb/issues/356]. The upcoming version 5.1 release have this changes
> and may cause crashes with database versions greater than 23.3

New description:

The recent optimisation in Django for multi-row insert in case of Oracle
db version greater than 23+ is crashing with specific db versions. The
issue is being reported [https://github.com/oracle/python-
oracledb/issues/356]. The upcoming version 5.1 release have this changes
and may cause crashes with database versions greater than 23.3.
Link to the PR which added this optimisation -
[https://github.com/django/django/pull/17969/]

--
--
Ticket URL: <https://code.djangoproject.com/ticket/35655#comment:4>

[Django]

#35655: Django crashes with Oracle database Version > 23.3
-------------------------------------+-------------------------------------
Reporter: Suraj Shaw | Owner: Suraj
| Shaw
Type: Bug | Status: assigned
Component: Database layer | Version: 5.1
(models, ORM) |
Severity: Release blocker | Resolution:
Keywords: | Triage Stage:
| Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Sarah Boyce):

* cc: Csirmaz Bendegúz, Mariusz Felisiak (added)

--
Ticket URL: <https://code.djangoproject.com/ticket/35655#comment:5>

[Django]

#35655: Django crashes with Oracle database Version > 23.3
-------------------------------------+-------------------------------------
Reporter: Suraj Shaw | Owner: Suraj
| Shaw
Type: Bug | Status: assigned
Component: Database layer | Version: 5.1
(models, ORM) |
Severity: Release blocker | Resolution:
Keywords: | Triage Stage:
| Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Comment (by Mariusz Felisiak):

As for me, it's an issue in Oracle not in Django itself. (2) and (3) are
not doable (at least on this stage of our release cycle, (3) probably
never, TBH). I'm not sure it's worth keeping
175b04942afaff978013db61495f3b39ea12989b for 23.3 > Oracle >= 23.0. Let's
revert it, we can also close #35295 as "wontfix" (waiting for Oracle to
make it work as promised).
--
Ticket URL: <https://code.djangoproject.com/ticket/35655#comment:6>

[Django]

#35655: Django crashes with Oracle database Version > 23.3
-------------------------------------+-------------------------------------
Reporter: Suraj Shaw | Owner: Suraj
| Shaw
Type: Bug | Status: assigned
Component: Database layer | Version: 5.1
(models, ORM) |
Severity: Release blocker | Resolution:
Keywords: | Triage Stage:
| Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Comment (by Sarah Boyce):

Thank you, I will do the revert and backport shortly
--
Ticket URL: <https://code.djangoproject.com/ticket/35655#comment:7>