#28596: Oracle 11.2 + large search related = boom in instance.delete()
-------------------------------------+-------------------------------------
Reporter: Markus Stenberg | Owner: nobody
Type: Bug | Status: new
Component: Database layer | Version: 1.11
(models, ORM) |
Severity: Normal | Resolution:
Keywords: felixxm | Triage Stage:
| Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Comment (by Markus Stenberg):
Unfortunately I do not have test setup with Oracle 12 and that codebase
(it takes awhile to reproduce as well).
Django 2.0 code in affected parts is same, but maybe Oracle has fixed the
bug; however, 500+kb single SQL query sounds like a bug to me to start
with.
(it leads to SELECT .. WHERE id IN .. list of 100k ids .. in the related
gathering part of deletion.py.)
This isn't technically regression as the Oracle 11.2 (at least) in
question been broken always (we have encountered it now with both Django
1.8 and Django 1.11.).
I wrote ugly few-line monkeypatch that fixes the issue but I guess I have
to live with that until we get to Oracle 12 (and hopefully fixed bug and
Django 2.0+).
--
Ticket URL: <https://code.djangoproject.com/ticket/28596#comment:3>
Django <https://code.djangoproject.com/>
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 post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/064.e73de2ec8346eeea3df5778066f36108%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
