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:  0|UI/UX:  0
-+-
Comment (by Sarah Boyce):

 Thank you, I will do the revert and backport shortly
-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/01070191131db756-24d444fb-de35-4b3a-a9a9-3377a589fbee-00%40eu-central-1.amazonses.com.

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:  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: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/0107019112915f44-657ab275-e0b2-4b18-9630-cef7352eb364-00%40eu-central-1.amazonses.com.

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:  0|UI/UX:  0
-+-
Changes (by Sarah Boyce):

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

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/010701911286f67d-52329846-b828-420e-bd2e-bd9b10a0d476-00%40eu-central-1.amazonses.com.

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:  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: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/010701911268772f-d80ed98d-0a66-48ff-b92f-19365be6ab54-00%40eu-central-1.amazonses.com.

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:  0|UI/UX:  0
-+-
Changes (by Suraj Shaw):

 * easy:  1 => 0

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/0107019112645b0e-6fd68f9f-65db-4acc-80ed-e1e57bd851d8-00%40eu-central-1.amazonses.com.

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: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/01070191125f7ef4-d4d0bd67-37ed-4943-a5a1-158ce13e941d-00%40eu-central-1.amazonses.com.

Re: [Django] #35655: Django crashes with Oracle database Version > 23.3 (was: Django crashes with oracle_db_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
-+-
Changes (by Suraj Shaw):

 * summary:  Django crashes with oracle_db_version > 23.3 => Django crashes
 with Oracle database Version > 23.3

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/010701911259543a-2ccca25e-7de5-4940-a473-5202c233c6c5-00%40eu-central-1.amazonses.com.