[Django] #29485: Testing with Oracle in AWS RDS (oracle managed files)

Django

unread,

Jun 8, 2018, 11:04:36 AM6/8/18

to django-...@googlegroups.com

#29485: Testing with Oracle in AWS RDS (oracle managed files)
-------------------------------------+-------------------------------------
Reporter: Vackar | Owner: nobody
Afzal |
Type: | Status: new
Uncategorized |
Component: Testing | Version: 2.0
framework | Keywords: oracle, testing,
Severity: Normal | OMF, AWS, RDS
Triage Stage: | Has patch: 0
Unreviewed |
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-------------------------------------+-------------------------------------
I am trying to run y test suite against an oracle server running on amazon
web services under RDS.

It fails when executing this statement:
{{{
CREATE TABLESPACE NAME_OF_TBS
DATAFILE 'name_of_tbs_dev1.dbf' SIZE 50M
REUSE AUTOEXTEND ON NEXT 25M MAXSIZE 500M
}}}

Error message is:
{{{
ORA-20900: RDS only supports Oracle Managed Files. Check ddl and remove
any named identifiers
ORA-06512: at "RDSADMIN.RDSADMIN", line 211
ORA-06512: at line 2)
}}}

What is the best way to add support for oracle managed files i.e.
- Additional param in django settings?
- Catch this exception and generate an OMF compatible SQL statement?

--
Ticket URL: <https://code.djangoproject.com/ticket/29485>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.

Django

unread,

Jun 18, 2018, 2:52:06 AM6/18/18

to django-...@googlegroups.com

#29485: Testing with Oracle in AWS RDS (oracle managed files)
-------------------------------------+-------------------------------------

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

Changes (by Carlton Gibson):

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

Comment:

As it stands this is a usage question, which needs to be referred to an
appropriate channel (Django Users, StackOverflow, etc).

It's not clear how this is an **issue** for Django. What's the Django code
that causes the offending SQL to be generated? If you can give us that
then we can assess whether there's something that needs to be addressed
here.

--
Ticket URL: <https://code.djangoproject.com/ticket/29485#comment:1>

Django

unread,

Jun 18, 2018, 6:40:09 AM6/18/18

to django-...@googlegroups.com

#29485: Testing with Oracle in AWS RDS (oracle managed files)
-------------------------------------+-------------------------------------

Has patch: 0 | Needs documentation: 0

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

Comment (by Vackar Afzal):

My current approach is to Monkey patch the default statements to read as
follows:
{{{

statements = [
"""CREATE TABLESPACE %(tblspace)s""",
"""CREATE TEMPORARY TABLESPACE %(tblspace_temp)s""",
]

}}}

Works for the time being, but would be nice to have it integrated back
into django

--
Ticket URL: <https://code.djangoproject.com/ticket/29485#comment:2>

Django

unread,

Nov 8, 2018, 4:55:52 AM11/8/18

to django-...@googlegroups.com

#29485: Testing with Oracle in AWS RDS (oracle managed files)
-------------------------------------+-------------------------------------

Reporter: Vackar Afzal | Owner: nobody
Type: Uncategorized | Status: closed
Component: Testing framework | Version: 2.0

Severity: Normal | Resolution: duplicate

Keywords: oracle, testing, | Triage Stage:
OMF, AWS, RDS | Unreviewed

Has patch: 0 | Needs documentation: 0

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