[Django] #35346: Running migrations with Oracle 23c Version 23.3.0.23.09 causes ORA-00600 error

9 views
Skip to first unread message

Django

unread,
Apr 1, 2024, 4:41:00 AM4/1/24
to django-...@googlegroups.com
#35346: Running migrations with Oracle 23c Version 23.3.0.23.09 causes ORA-00600
error
-------------------------------------+-------------------------------------
Reporter: David | Owner: nobody
Sanders |
Type: Bug | Status: new
Component: Database | Version: 5.0
layer (models, ORM) |
Severity: Normal | Keywords: Oracle 23c
Triage Stage: | Has patch: 0
Unreviewed |
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-------------------------------------+-------------------------------------
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
--
Ticket URL: <https://code.djangoproject.com/ticket/35346>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.

Django

unread,
Apr 1, 2024, 6:08:43 AM4/1/24
to django-...@googlegroups.com
#35346: Running migrations with Oracle 23c Version 23.3.0.23.09 causes ORA-00600
error
-------------------------------------+-------------------------------------
Reporter: David Sanders | Owner: nobody
Type: Bug | Status: closed
Component: Database layer | Version: 5.0
(models, ORM) |
Severity: Normal | Resolution: invalid
Keywords: Oracle 23c | Triage Stage:
| Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Mariusz Felisiak):

* resolution: => invalid
* status: new => closed

Comment:

It works for me with [https://www.oracle.com/database/technologies
/databaseappdev-vm.html Oracle 23c] (23.2). `ORA-600` is an internal
Oracle error, this can be anything and there is nothing for us to fix,
IMO.
--
Ticket URL: <https://code.djangoproject.com/ticket/35346#comment:1>
Reply all
Reply to author
Forward
0 new messages