id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
28596	Oracle crashes with query with 2^16+1 bind parameters.	Markus Stenberg	Mariusz Felisiak	"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.
 "	Bug	closed	Database layer (models, ORM)	dev	Normal	fixed		Mariusz Felisiak	Accepted	1	0	0	0	0	0