#28596: Oracle 11.2 + large search related = boom in instance.delete()
-------------------------------------+-------------------------------------
Reporter: Markus | Owner: nobody
Stenberg |
Type: Bug | Status: new
Component: Database | Version: 1.11
layer (models, ORM) |
Severity: Normal | Keywords:
Triage Stage: | Has patch: 0
Unreviewed |
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-------------------------------------+-------------------------------------
Given model B, which has foreign key to model A (and delete=CASCADE).
If deleting A instance with 100k references from different B instances,
Oracle closes connection and the Oracle worker dies to ORA-0600.
Reason:
Django does search_related with id__in of 100k different ids. Oracle (at
least 11.2) cannot handle it and blows up. (This is known by Oracle IIRC
but not fixed at least not in 11.)
Workaround:
provide bulk_batch_size with e.g. 5000 maximum number of items in a
query.
--
Ticket URL: <https://code.djangoproject.com/ticket/28596>
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/049.615b43a1c0802b8afd714de0f8121e5c%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
