#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 [email protected].
To post to this group, send email to [email protected].
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.
