[Django] #23969: Test failures on Oracle -- ORA-01658: unable to [enlarge] tablespace

6 views
Skip to first unread message

Django

unread,
Dec 7, 2014, 4:41:51 AM12/7/14
to django-...@googlegroups.com
#23969: Test failures on Oracle -- ORA-01658: unable to [enlarge] tablespace
---------------------------------------------+------------------------
Reporter: shaib | Owner: shaib
Type: Bug | Status: new
Component: Testing framework | Version: 1.7
Severity: Normal | Keywords: oracle
Triage Stage: Unreviewed | Has patch: 0
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
---------------------------------------------+------------------------
Consistently, in the last few runs on CI on all Python versions, and also
reproduced on my machine:
{{{
======================================================================
ERROR [0.001s]: test_long_string (backends.tests.OracleTests)
----------------------------------------------------------------------
Traceback (most recent call last):
File "<http://djangoci.com/job/django-
oracle-1.7/database=oracle11,python=python2.7/ws/tests/backends/tests.py",>
line 81, in test_long_string
cursor.execute('INSERT INTO ltext VALUES (%s)', [long_str])
File "<http://djangoci.com/job/django-
oracle-1.7/database=oracle11,python=python2.7/ws/django/db/backends/utils.py",>
line 65, in execute
return self.cursor.execute(sql, params)
File "<http://djangoci.com/job/django-
oracle-1.7/database=oracle11,python=python2.7/ws/django/db/utils.py",>
line 94, in __exit__
six.reraise(dj_exc_type, dj_exc_value, traceback)
File "<http://djangoci.com/job/django-
oracle-1.7/database=oracle11,python=python2.7/ws/django/db/backends/utils.py",>
line 65, in execute
return self.cursor.execute(sql, params)
File "<http://djangoci.com/job/django-
oracle-1.7/database=oracle11,python=python2.7/ws/django/db/backends/oracle/base.py",>
line 916, in execute
return self.cursor.execute(query, self._param_generator(params))
DatabaseError: ORA-01658: unable to create INITIAL extent for segment in
tablespace D_DJANGOORACLE17_27
}}}

Notes:

1. This is on 1.7.x only -- on master, this has been solved for good by
the fix to #21775.
2. This only shows up when running a lot of tests, although the failure
is consistently in the same test.

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

Django

unread,
Dec 7, 2014, 5:57:41 AM12/7/14
to django-...@googlegroups.com
#23969: Test failures on Oracle -- ORA-01658: unable to [enlarge] tablespace
-----------------------------------+--------------------------------------
Reporter: shaib | Owner: shaib
Type: Bug | Status: closed

Component: Testing framework | Version: 1.7
Severity: Normal | Resolution: fixed

Keywords: oracle | Triage Stage: Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-----------------------------------+--------------------------------------
Changes (by Shai Berger <shai@…>):

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


Comment:

In [changeset:"991f523753baff73b32859c906649767a2bc8061"]:
{{{
#!CommitTicketReference repository=""
revision="991f523753baff73b32859c906649767a2bc8061"
[1.7.x] Fixed #23969: Made Oracle default test-tablespace larger.

It seems our test suite has grown...
Refs #21775
}}}

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

Django

unread,
Dec 8, 2014, 7:31:08 AM12/8/14
to django-...@googlegroups.com
#23969: Test failures on Oracle -- ORA-01658: unable to [enlarge] tablespace
-----------------------------------+--------------------------------------
Reporter: shaib | Owner: shaib
Type: Bug | Status: closed

Component: Testing framework | Version: 1.7
Severity: Normal | Resolution: fixed

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

Comment (by timgraham):

Shall we add a mention to the 1.7.2 release notes about this since it
presumably also affects anyone who is running their own tests on Oracle?

Also the 1.8 release notes could be updated; it currently says "The
default max size of the Oracle test tablespace has increased from 200M to
500M."

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

Django

unread,
Dec 8, 2014, 7:35:47 AM12/8/14
to django-...@googlegroups.com
#23969: Test failures on Oracle -- ORA-01658: unable to [enlarge] tablespace
-----------------------------------+--------------------------------------
Reporter: shaib | Owner: shaib
Type: Bug | Status: closed

Component: Testing framework | Version: 1.7
Severity: Normal | Resolution: fixed

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

Comment (by shaib):

Yes, I thought it wasn't needed but you're right. I'll take care of it
later (hopefully today).

--
Ticket URL: <https://code.djangoproject.com/ticket/23969#comment:3>

Django

unread,
Dec 13, 2014, 4:09:12 PM12/13/14
to django-...@googlegroups.com
#23969: Test failures on Oracle -- ORA-01658: unable to [enlarge] tablespace
-----------------------------------+--------------------------------------
Reporter: shaib | Owner: shaib
Type: Bug | Status: closed

Component: Testing framework | Version: 1.7
Severity: Normal | Resolution: fixed

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

Comment (by Shai Berger <shai@…>):

In [changeset:"9189ef438ef885446b20bf4c017d3cf53335ab08"]:
{{{
#!CommitTicketReference repository=""
revision="9189ef438ef885446b20bf4c017d3cf53335ab08"
[1.7.x] Added release note for Refs #23969
}}}

--
Ticket URL: <https://code.djangoproject.com/ticket/23969#comment:4>

Django

unread,
Dec 13, 2014, 4:09:50 PM12/13/14
to django-...@googlegroups.com
#23969: Test failures on Oracle -- ORA-01658: unable to [enlarge] tablespace
-----------------------------------+--------------------------------------
Reporter: shaib | Owner: shaib
Type: Bug | Status: closed

Component: Testing framework | Version: 1.7
Severity: Normal | Resolution: fixed

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

Comment (by Shai Berger <shai@…>):

In [changeset:"cc6275eeefe3da508a1203cf39aed237962e0171"]:
{{{
#!CommitTicketReference repository=""
revision="cc6275eeefe3da508a1203cf39aed237962e0171"
Ammended release notes for Refs #23969

(this includes a forward-port of 9189ef438ef885446b20bf4c017d3cf53335ab08)
}}}

--
Ticket URL: <https://code.djangoproject.com/ticket/23969#comment:5>

Reply all
Reply to author
Forward
0 new messages