Re: [Django] #23649: Oracle GIS testing -- fails to destroy old leftover test database after unclean ending

[Django]

#23649: Oracle GIS testing -- fails to destroy old leftover test database after
unclean ending
-+-
 Reporter:  shaib|Owner:  shaib
 Type:  Uncategorized|   Status:  closed
Component:  Database layer   |  Version:  master
  (models, ORM)  |   Resolution:  fixed
 Severity:  Normal   | Triage Stage:  Accepted
 Keywords:  oracle testing   |  Needs documentation:  0
  geodjango gis  |  Patch needs improvement:  0
Has patch:  1|UI/UX:  0
  Needs tests:  0|
Easy pickings:  0|
-+-

Comment (by shaib):

 Thanks, Tim, for adding the release notes I neglected.

--
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/063.18421b1e27fae0100aa4d5f8f59e4b61%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #23649: Oracle GIS testing -- fails to destroy old leftover test database after unclean ending

[Django]

#23649: Oracle GIS testing -- fails to destroy old leftover test database after
unclean ending
-+-
 Reporter:  shaib|Owner:  shaib
 Type:  Uncategorized|   Status:  closed
Component:  Database layer   |  Version:  master
  (models, ORM)  |   Resolution:  fixed
 Severity:  Normal   | Triage Stage:  Accepted
 Keywords:  oracle testing   |  Needs documentation:  0
  geodjango gis  |  Patch needs improvement:  0
Has patch:  1|UI/UX:  0
  Needs tests:  0|
Easy pickings:  0|
-+-

Comment (by Tim Graham ):

 In [changeset:"55a5f0b49a7adca008076fa0af6f67ef64d575d8"]:
 {{{
 #!CommitTicketReference repository=""
 revision="55a5f0b49a7adca008076fa0af6f67ef64d575d8"
 [1.7.x] Added 1.7.1 release notes for refs #23649.

 Backport of 6ce6c77e03 from master
 }}}

--
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/063.a68399154d51d064a859cc2b5df3665a%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #23649: Oracle GIS testing -- fails to destroy old leftover test database after unclean ending

[Django]

#23649: Oracle GIS testing -- fails to destroy old leftover test database after
unclean ending
-+-
 Reporter:  shaib|Owner:  shaib
 Type:  Uncategorized|   Status:  closed
Component:  Database layer   |  Version:  master
  (models, ORM)  |   Resolution:  fixed
 Severity:  Normal   | Triage Stage:  Accepted
 Keywords:  oracle testing   |  Needs documentation:  0
  geodjango gis  |  Patch needs improvement:  0
Has patch:  1|UI/UX:  0
  Needs tests:  0|
Easy pickings:  0|
-+-

Comment (by Tim Graham ):

 In [changeset:"6ce6c77e03fea68ef1bdadd45f15e403f5b71057"]:
 {{{
 #!CommitTicketReference repository=""
 revision="6ce6c77e03fea68ef1bdadd45f15e403f5b71057"
 Added 1.7.1 release notes for refs #23649.
 }}}

--
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/063.fc62ba8fb442f6f298f6338942bdacd4%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #23649: Oracle GIS testing -- fails to destroy old leftover test database after unclean ending

[Django]

#23649: Oracle GIS testing -- fails to destroy old leftover test database after
unclean ending
-+-
 Reporter:  shaib|Owner:  shaib
 Type:  Uncategorized|   Status:  closed
Component:  Database layer   |  Version:  master
  (models, ORM)  |   Resolution:  fixed
 Severity:  Normal   | Triage Stage:  Accepted
 Keywords:  oracle testing   |  Needs documentation:  0
  geodjango gis  |  Patch needs improvement:  0
Has patch:  1|UI/UX:  0
  Needs tests:  0|
Easy pickings:  0|
-+-

Comment (by Shai Berger ):

 In [changeset:"a1578055e61e8815d1b6d445e8b24ad02d38c3ee"]:
 {{{
 #!CommitTicketReference repository=""
 revision="a1578055e61e8815d1b6d445e8b24ad02d38c3ee"
 [1.7.x] Fixed #23649 -- Made Oracle test-db creation drop test-user
 earlier when needed

 Checked database destruction for ORA-29857, which happens when objects of
 some types are left over in an old test database (notably, such objects
 are created by the GIS backend). When this happens, we can resolve the
 issue by dropping the test-user (if we are allowed to).

 An alternative approach, to just switch the order of creation (so that,
 if the test user exists and can be dropped, it is always dropped before
 the tablespace) was considered; but since the user creation depends on
 the tablespace, this would necessitate separating the dropping of the user
 from its creation -- a change I am reluctant to make.

 Thanks Josh Smeaton and Tim Graham for reviews.

 Backport of 2e1ed5f33c from master
 }}}

--
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/063.8f64f3c245d9f473298f32a59b121470%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #23649: Oracle GIS testing -- fails to destroy old leftover test database after unclean ending

[Django]

#23649: Oracle GIS testing -- fails to destroy old leftover test database after
unclean ending
-+-
 Reporter:  shaib|Owner:  shaib
 Type:  Uncategorized|   Status:  closed
Component:  Database layer   |  Version:  master
  (models, ORM)  |   Resolution:  fixed
 Severity:  Normal   | Triage Stage:  Accepted
 Keywords:  oracle testing   |  Needs documentation:  0
  geodjango gis  |  Patch needs improvement:  0
Has patch:  1|UI/UX:  0
  Needs tests:  0|
Easy pickings:  0|
-+-
Changes (by Shai Berger ):

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


Comment:

 In [changeset:"2e1ed5f33cf5756b52a10ceadd0ce8e9ecf989e3"]:
 {{{
 #!CommitTicketReference repository=""
 revision="2e1ed5f33cf5756b52a10ceadd0ce8e9ecf989e3"
 Fixed #23649 -- Made Oracle test-db creation drop test-user earlier when
 needed

 Checked database destruction for ORA-29857, which happens when objects of
 some types are left over in an old test database (notably, such objects
 are created by the GIS backend). When this happens, we can resolve the
 issue by dropping the test-user (if we are allowed to).

 An alternative approach, to just switch the order of creation (so that,
 if the test user exists and can be dropped, it is always dropped before
 the tablespace) was considered; but since the user creation depends on
 the tablespace, this would necessitate separating the dropping of the user
 from its creation -- a change I am reluctant to make.

 Thanks Josh Smeaton and Tim Graham for reviews.
 }}}

--
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/063.5a50831ae01dda112d86915b0e3a74e8%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #23649: Oracle GIS testing -- fails to destroy old leftover test database after unclean ending

[Django]

#23649: Oracle GIS testing -- fails to destroy old leftover test database after
unclean ending
-+-
 Reporter:  shaib|Owner:  shaib
 Type:  Uncategorized|   Status:  assigned
Component:  Database layer   |  Version:  master
  (models, ORM)  |   Resolution:
 Severity:  Normal   | Triage Stage:  Accepted
 Keywords:  oracle testing   |  Needs documentation:  0
  geodjango gis  |  Patch needs improvement:  0
Has patch:  1|UI/UX:  0
  Needs tests:  0|
Easy pickings:  0|
-+-
Changes (by shaib):

 * has_patch:  0 => 1


--
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/063.4d806028f426328003ebae72c56aed9f%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #23649: Oracle GIS testing -- fails to destroy old leftover test database after unclean ending

[Django]

#23649: Oracle GIS testing -- fails to destroy old leftover test database after
unclean ending
-+-
 Reporter:  shaib|Owner:  shaib
 Type:  Uncategorized|   Status:  assigned
Component:  Database layer   |  Version:  master
  (models, ORM)  |   Resolution:
 Severity:  Normal   | Triage Stage:  Accepted
 Keywords:  oracle testing   |  Needs documentation:  0
  geodjango gis  |  Patch needs improvement:  0
Has patch:  0|UI/UX:  0
  Needs tests:  0|
Easy pickings:  0|
-+-

Comment (by shaib):

 PR: https://github.com/django/django/pull/3367

--
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/063.3f15170cb818ca773914b6151fe30496%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #23649: Oracle GIS testing -- fails to destroy old leftover test database after unclean ending

[Django]

#23649: Oracle GIS testing -- fails to destroy old leftover test database after
unclean ending
-+-
 Reporter:  shaib|Owner:  shaib
 Type:  Uncategorized|   Status:  assigned
Component:  Database layer   |  Version:  master
  (models, ORM)  |   Resolution:
 Severity:  Normal   | Triage Stage:  Accepted
 Keywords:  oracle testing   |  Needs documentation:  0
  geodjango gis  |  Patch needs improvement:  0
Has patch:  0|UI/UX:  0
  Needs tests:  0|
Easy pickings:  0|
-+-
Changes (by shaib):

 * owner:  nobody => shaib
 * status:  new => assigned


--
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/063.ce228ebadfb67503fcf2f23794b1e1d0%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

[Django] #23649: Oracle GIS testing -- fails to destroy old leftover test database after unclean ending

[Django]

#23649: Oracle GIS testing -- fails to destroy old leftover test database after
unclean ending
-+-
   Reporter:  shaib  |  Owner:  nobody
   Type: | Status:  new
  Uncategorized  |Version:  master
  Component:  Database   |   Keywords:  oracle testing
  layer (models, ORM)|  geodjango gis
   Severity:  Normal |  Has patch:  0
   Triage Stage:  Accepted   |Needs tests:  0
Needs documentation:  0  |  Easy pickings:  0
Patch needs improvement:  0  |
  UI/UX:  0  |
-+-
 If you run Django tests and they end without proper clean-up (e.g. the
 test process is forcibly killed) then the next test run will try to
 destroy the test-database before rebuilding it from scratch.

 On Oracle GIS, this destroy-leftover-database process fails, because the
 backend tries to drop the test tablespace (`DROP TABLESPACE TEST_DB
 INCLUDING CONTENTS`), and for some reason the GIS artifacts make this
 fail.

 The workaround is to drop first the test user (`DROP USER TEST_USER
 CASCADE`), but currently this needs to be done manually.

--
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/048.288417f235de51b1d3b8622d96481c12%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.