Opened 3 weeks ago

Last modified 2 weeks ago

#37136 assigned Cleanup/optimization

Integrate Oracle Test Pilot into CI

Reported by: Tim Schilling Owned by: Loïc LEFEVRE
Component: Core (Other) Version: dev
Severity: Normal Keywords: GitHub Actions, Oracle
Cc: Triage Stage: Accepted
Has patch: no Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no

Description

As per this ​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.

Change History (6)

comment:1 by Loïc LEFEVRE, 2 weeks ago

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.

in reply to:  1 comment:2 by Jacob Walls, 2 weeks ago

Component: Uncategorized → Core (Other)
Owner: set to Loïc LEFEVRE
Status: new → assigned
Triage Stage: Unreviewed → Accepted

Thanks, let's evaluate this.

Replying to 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.

comment:3 by Loïc LEFEVRE, 2 weeks ago

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

comment:5 by Loïc LEFEVRE, 2 weeks ago

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)

comment:6 by Loïc LEFEVRE, 2 weeks ago

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

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