Changes between Initial Version and Version 1 of Ticket #28596
- Timestamp:
- Sep 14, 2017, 4:57:01 AM (7 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #28596 – Description
initial v1 3 3 If deleting A instance with 100k references from different B instances, Oracle closes connection and the Oracle worker dies to ORA-0600. 4 4 5 Reason: 6 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.) 5 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.) 7 6 8 Workaround: 9 provide bulk_batch_size with e.g. 5000 maximum number of items in a query. 7 Workaround: provide `bulk_batch_size` with e.g. 5000 maximum number of items in a query. 10 8