[Django] #37136: Integrate Oracle Test Pilot into CI

[Django]

#37136: Integrate Oracle Test Pilot into CI
-------------------------------------+-------------------------------------
Reporter: Tim Schilling | Type:
| Cleanup/optimization
Status: new | Component:
| Uncategorized
Version: dev | Severity: Normal
Keywords: GitHub Actions, | Triage Stage:
Oracle | Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
As per this [https://forum.djangoproject.com/t/proposal-leverage-oracle-
test-pilot-for-django-ci/45197 forum post], there's a new tool from Oracle
that's being built which is designed to help open source projects support
Oracle.

The goal here is to be able to run the oracle tests with GitHub Actions
using Oracle Test Pilot. Based on that, the support and reliability, we
can later investigate a complete migration to the tool.
--
Ticket URL: <https://code.djangoproject.com/ticket/37136>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.

[Django]

#37136: Integrate Oracle Test Pilot into CI
-------------------------------------+-------------------------------------

Reporter: Tim Schilling | Owner: (none)
Type: | Status: new
Cleanup/optimization |
Component: Uncategorized | Version: dev
Severity: Normal | Resolution:

Keywords: GitHub Actions, | Triage Stage:
Oracle | Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Comment (by Loïc LEFEVRE):

Which workflow would be the best to target for Oracle Test Pilot
integration?

I've tested with schedule_tests.yml by adding a new Job but please
confirm.
--
Ticket URL: <https://code.djangoproject.com/ticket/37136#comment:1>

[Django]

#37136: Integrate Oracle Test Pilot into CI
-------------------------------------+-------------------------------------

Reporter: Tim Schilling | Owner: Loïc
Type: | LEFEVRE
Cleanup/optimization | Status: assigned
Component: Core (Other) | Version: dev
Severity: Normal | Resolution:
Keywords: GitHub Actions, | Triage Stage: Accepted
Oracle |

Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Jacob Walls):

* component: Uncategorized => Core (Other)
* owner: (none) => Loïc LEFEVRE
* stage: Unreviewed => Accepted
* status: new => assigned

Comment:

Thanks, let's evaluate this.

Replying to [comment:1 Loïc LEFEVRE]:

> Which workflow would be the best to target for Oracle Test Pilot
integration?
>
> I've tested with schedule_tests.yml by adding a new Job but please
confirm.

Yep, a new job next to the postgresql job seems logical. We can always
port to the PR workflow later.
--
Ticket URL: <https://code.djangoproject.com/ticket/37136#comment:2>

[Django]

#37136: Integrate Oracle Test Pilot into CI
-------------------------------------+-------------------------------------
Reporter: Tim Schilling | Owner: Loïc
Type: | LEFEVRE
Cleanup/optimization | Status: assigned
Component: Core (Other) | Version: dev
Severity: Normal | Resolution:
Keywords: GitHub Actions, | Triage Stage: Accepted
Oracle |
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Comment (by Loïc LEFEVRE):

Hi Tim,
you can find an example of a job run here: https://github.com/loiclefevre
/django-otp/actions/runs/26885786028/job/79297503877

I've just commented the other jobs for the time being.

Feel free to comment.
Thanks
--
Ticket URL: <https://code.djangoproject.com/ticket/37136#comment:3>

[Django]

#37136: Integrate Oracle Test Pilot into CI
-------------------------------------+-------------------------------------
Reporter: Tim Schilling | Owner: Loïc
Type: | LEFEVRE
Cleanup/optimization | Status: assigned
Component: Core (Other) | Version: dev
Severity: Normal | Resolution:
Keywords: GitHub Actions, | Triage Stage: Accepted
Oracle |
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Comment (by Tim Schilling):

The code looks pretty manageable!
https://github.com/django/django/compare/main...loiclefevre:django-otp:otp
--
Ticket URL: <https://code.djangoproject.com/ticket/37136#comment:4>

[Django]

#37136: Integrate Oracle Test Pilot into CI
-------------------------------------+-------------------------------------
Reporter: Tim Schilling | Owner: Loïc
Type: | LEFEVRE
Cleanup/optimization | Status: assigned
Component: Core (Other) | Version: dev
Severity: Normal | Resolution:
Keywords: GitHub Actions, | Triage Stage: Accepted
Oracle |
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Comment (by Loïc LEFEVRE):

Quick question: is there any possibility that Connection(s) open to the
test database(s) (defaut, other) may not be closed properly while running
the tests? (at the very end, in the case there are no errors)
--
Ticket URL: <https://code.djangoproject.com/ticket/37136#comment:5>

[Django]

#37136: Integrate Oracle Test Pilot into CI
-------------------------------------+-------------------------------------
Reporter: Tim Schilling | Owner: Loïc
Type: | LEFEVRE
Cleanup/optimization | Status: assigned
Component: Core (Other) | Version: dev
Severity: Normal | Resolution:
Keywords: GitHub Actions, | Triage Stage: Accepted
Oracle |
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Comment (by Loïc LEFEVRE):

Reason for asking is that I've enabled Autonomous databases 19c and 26ai
and the database cleanup process fail with following errors:
- ORA-01940: cannot drop a user that is currently connected
- ORA-01940: cannot drop a user that is currently connected

see: https://github.com/loiclefevre/django-otp/actions/runs/26998861078
--
Ticket URL: <https://code.djangoproject.com/ticket/37136#comment:6>