#25438: Oracle GIS test failures for Django 1.9
----------------------------+------------------------------------
Reporter: timgraham | Owner: nobody
Type: Bug | Status: new
Component: GIS | Version: master
Severity: Normal | Resolution:
Keywords: oracle 1.9 | Triage Stage: Accepted
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
----------------------------+------------------------------------
Old description:
> After the patch for #24688 to add support for new-style GIS functions,
> some test failures remain:
> {{{
> gis_tests.geoapp.test_functions.GISFunctionsTests.test_difference
>
> Traceback (most recent call last):
> File "/mnt/jenkinsdata/workspace/pull-requests-
> oracle/database/oragis11/python/python3.5/django/test/testcases.py", line
> 1093, in skip_wrapper
> return test_func(*args, **kwargs)
> File "/mnt/jenkinsdata/workspace/pull-requests-
> oracle/database/oragis11/python/python3.5/tests/gis_tests/geoapp/test_functions.py",
> line 180, in test_difference
> self.assertEqual(c.mpoly.difference(geom), c.diff)
> AssertionError: <MultiPolygon object at 0x7f768d20f450> != <MultiPolygon
> object at 0x7f768d1df2b8>
>
> gis_tests.geoapp.test_functions.GISFunctionsTests.test_intersection
>
> Traceback (most recent call last):
> File "/mnt/jenkinsdata/workspace/pull-requests-
> oracle/database/oragis11/python/python3.5/django/test/testcases.py", line
> 1093, in skip_wrapper
> return test_func(*args, **kwargs)
> File "/mnt/jenkinsdata/workspace/pull-requests-
> oracle/database/oragis11/python/python3.5/tests/gis_tests/geoapp/test_functions.py",
> line 234, in test_intersection
> self.assertEqual(c.inter, expected)
> AssertionError: '' != <GeometryCollection object at 0x7f768ea5a120>
>
> gis_tests.geoapp.test_functions.GISFunctionsTests.test_difference_mixed_srid
>
> Traceback (most recent call last):
> File "/mnt/jenkinsdata/workspace/pull-requests-
> oracle/database/oragis11/python/python3.5/django/db/utils.py", line 102,
> in inner
> return func(*args, **kwargs)
> File "/mnt/jenkinsdata/workspace/pull-requests-
> oracle/database/oragis11/python/python3.5/django/db/backends/oracle/base.py",
> line 516, in fetchmany
> return tuple(_rowfactory(r, self.cursor) for r in
> self.cursor.fetchmany(size))
> cx_Oracle.DatabaseError: ORA-13199: SRID does not exist.
> ORA-06512: at "MDSYS.MD", line 1723
> ORA-06512: at "MDSYS.MDERR", line 17
> ORA-06512: at "MDSYS.SDO_CS", line 5264
> ORA-06512: at "MDSYS.SDO_CS", line 3034
>
> gis_tests.geoapp.tests.GeoQuerySetTest.test_gml
>
> Traceback (most recent call last):
> File "/mnt/jenkinsdata/workspace/pull-requests-
> oracle/database/oragis11/python/python3.5/django/test/testcases.py", line
> 1093, in skip_wrapper
> return test_func(*args, **kwargs)
> File "/mnt/jenkinsdata/workspace/pull-requests-
> oracle/database/oragis11/python/python3.5/tests/gis_tests/geoapp/tests.py",
> line 635, in test_gml
> self.assertTrue(gml_regex.match(ptown.gml))
> AssertionError: None is not true
>
> gis_tests.geogapp.tests.GeographyFunctionTests.test_distance_function
>
> Traceback (most recent call last):
> File "/mnt/jenkinsdata/workspace/pull-requests-
> oracle/database/oragis11/python/python3.5/django/test/testcases.py", line
> 1093, in skip_wrapper
> return test_func(*args, **kwargs)
> File "/mnt/jenkinsdata/workspace/pull-requests-
> oracle/database/oragis11/python/python3.5/tests/gis_tests/geogapp/tests.py",
> line 120, in test_distance_function
> self.assertAlmostEqual(z.distance.m, ref, 2)
> AssertionError: 4899.67677194225 != 4891.2 within 2 places
> }}}
New description:
After the patch for #24688 to add support for new-style GIS functions,
some test failures remain:
{{{
gis_tests.geoapp.test_functions.GISFunctionsTests.test_difference
Traceback (most recent call last):
File "/mnt/jenkinsdata/workspace/pull-requests-
oracle/database/oragis11/python/python3.5/django/test/testcases.py", line
1093, in skip_wrapper
return test_func(*args, **kwargs)
File "/mnt/jenkinsdata/workspace/pull-requests-
oracle/database/oragis11/python/python3.5/tests/gis_tests/geoapp/test_functions.py",
line 180, in test_difference
self.assertEqual(c.mpoly.difference(geom), c.diff)
AssertionError: <MultiPolygon object at 0x7f768d20f450> != <MultiPolygon
object at 0x7f768d1df2b8>
gis_tests.geoapp.test_functions.GISFunctionsTests.test_intersection
Traceback (most recent call last):
File "/mnt/jenkinsdata/workspace/pull-requests-
oracle/database/oragis11/python/python3.5/django/test/testcases.py", line
1093, in skip_wrapper
return test_func(*args, **kwargs)
File "/mnt/jenkinsdata/workspace/pull-requests-
oracle/database/oragis11/python/python3.5/tests/gis_tests/geoapp/test_functions.py",
line 234, in test_intersection
self.assertEqual(c.inter, expected)
AssertionError: '' != <GeometryCollection object at 0x7f768ea5a120>
gis_tests.geoapp.test_functions.GISFunctionsTests.test_difference_mixed_srid
Traceback (most recent call last):
File "/home/jenkins/workspace/django-
oracle-1.9/database/oragis12/label/trusty/python/python2.7/django/test/testcases.py",
line 1093, in skip_wrapper
return test_func(*args, **kwargs)
File "/home/jenkins/workspace/django-
oracle-1.9/database/oragis12/label/trusty/python/python2.7/tests/gis_tests/geoapp/test_functions.py",
line 191, in test_difference_mixed_srid
self.assertEqual(c.mpoly.difference(geom), c.difference)
AssertionError: <MultiPolygon object at 0x7f3422ed02e0> != <MultiPolygon
object at 0x7f3422ed0130>
gis_tests.geogapp.tests.GeographyFunctionTests.test_distance_function
Traceback (most recent call last):
File "/mnt/jenkinsdata/workspace/pull-requests-
oracle/database/oragis11/python/python3.5/django/test/testcases.py", line
1093, in skip_wrapper
return test_func(*args, **kwargs)
File "/mnt/jenkinsdata/workspace/pull-requests-
oracle/database/oragis11/python/python3.5/tests/gis_tests/geogapp/tests.py",
line 120, in test_distance_function
self.assertAlmostEqual(z.distance.m, ref, 2)
AssertionError: 4899.67677194225 != 4891.2 within 2 places
}}}
New since Jenkins was updated from Oracle 11 to Oracle 12.1.0.2.0:
{{{
gis_tests.geoapp.test_functions.GISFunctionsTests.test_sym_difference
Items in the first set but not the second: u'POLYGON
((-103.0024339999999938 36.5003969999999995, -103.0419239999999945
36.5004390000000001, .............
gis_tests.geogapp.tests.GeographyFunctionTests.test_geography_area
gis_tests.geogapp.tests.GeographyTest.test06_geography_area (same issue
probably)
Traceback (most recent call last):
File "/home/jenkins/workspace/django-
oracle-1.9/database/oragis12/label/trusty/python/python2.7/django/test/testcases.py",
line 1093, in skip_wrapper
return test_func(*args, **kwargs)
File "/home/jenkins/workspace/django-
oracle-1.9/database/oragis12/label/trusty/python/python2.7/tests/gis_tests/geogapp/tests.py",
line 131, in test_geography_area
self.assertAlmostEqual(z.area.sq_m, ref_area, tol)
AssertionError: 5439100.13586914 != 5439100.95415646 within 5 places
--
Comment (by timgraham):
Jenkins is upgraded to Oracle 12.1.0.2.0. I updated the ticket description
with the test failures.
--
Ticket URL: <https://code.djangoproject.com/ticket/25438#comment:6>
Django <https://code.djangoproject.com/>
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/067.488f48611351c569de2889ecfee5c956%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
