Opened 7 months ago

Closed 7 months ago

#35346 closed Bug (invalid)

Running migrations with Oracle 23c Version 23.3.0.23.09 causes ORA-00600 error

Reported by: David Sanders Owned by: nobody
Component: Database layer (models, ORM) Version: 5.0
Severity: Normal Keywords: Oracle 23c
Cc: Triage Stage: Unreviewed
Has patch: no Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no

Description

Bisected to https://github.com/django/django/commit/175b04942afaff978013db61495f3b39ea12989b

  • Isolated issue to migrations inserting multiple permission rows using the new VALUES constructor.
  • Running the query without any params succeeds.
  • Running the query with a single row + params succeeds.
  • Running the query with multiple rows + params causes ORA-00600

Tested on Version 23.3.0.23.09

Apparently this is fixed in 23.4 [1] but unable to test at this time as the most up-to-date version on https://container-registry.oracle.com/ is 23.3.0.0

If confirmed is indeed an issue and is indeed fixed in 23.4 then we should update the feature flag in the commit above to limit to 23.4.

[1] https://forums.oracle.com/ords/apexds/post/ora-00600-when-using-the-multi-row-values-constructor-inser-5558

Change History (1)

comment:1 by Mariusz Felisiak, 7 months ago

Resolution: invalid
Status: newclosed

It works for me with Oracle 23c (23.2). ORA-600 is an internal Oracle error, this can be anything and there is nothing for us to fix, IMO.

Note: See TracTickets for help on using tickets.
Back to Top