[postgis-tickets] [PostGIS] #3502: Debbie failing PostGIS trunk regress tickets on PostgreSQL 9.6

[PostGIS]

#3502: Debbie failing PostGIS trunk regress tickets on PostgreSQL 9.6
------------------------+---------------------------
  Reporter:  robe       |      Owner:  pramsey
      Type:  defect     |     Status:  new
  Priority:  medium     |  Milestone:  PostGIS 2.2.2
 Component:  buildbots  |    Version:  trunk
Resolution:             |   Keywords:  regress
------------------------+---------------------------
Description changed by robe:

Old description:

> I thought I complained about this issue already, but can't find the
> ticket.
>
> Debbie is failing (seems only on 9.6 runs)
>

> {{{
>  swapordinates .. ok
>  summary .. ok
>  temporal .. ok
>  tickets .. failed (diff expected obtained:
> /var/lib/jenkins/workspace/postgis/tmp/2_3_pg9.6w64/test_87_diff)
> -----------------------------------------------------------------------------
> --- tickets_expected    2016-02-26 14:25:42.278086250 +0000
> +++ /var/lib/jenkins/workspace/postgis/tmp/2_3_pg9.6w64/test_87_out
> 2016-03-11 02:26:21.953618580 +0000
> @@ -280,8 +280,8 @@
>  #3375|GEOMETRYCOLLECTION(POINT(0 -7))
>  #3399|1|1
>  #3399|10|10
> -#3399|1000|1000
>  #3399|100|100
> +#3399|1000|1000
>  ERROR:  invalid KML representation
>  #3437a|5
>  #3437b|5
> }}}
>

> Even thought it shows as 2.3 only issue, I think that's because I'm
> testing 9.6 only on 2.3.  I had the same issue with this test on one run
> on my computer against 9.5/ 2.2
>
> So I think the main issue is this test is not deterministic because it
> lacks an order by so since debbie always tests against 9.6 dev change -
> its possible something in 9.6 changed in planner to make this always
> fail.

New description:

 I thought I complained about this issue already, but can't find the
 ticket.

 Debbie is failing (seems only on 9.6 runs)


 {{{
  swapordinates .. ok
  summary .. ok
  temporal .. ok
  tickets .. failed (diff expected obtained:
 /var/lib/jenkins/workspace/postgis/tmp/2_3_pg9.6w64/test_87_diff)
 -----------------------------------------------------------------------------
 --- tickets_expected    2016-02-26 14:25:42.278086250 +0000
 +++ /var/lib/jenkins/workspace/postgis/tmp/2_3_pg9.6w64/test_87_out
 2016-03-11 02:26:21.953618580 +0000
 @@ -280,8 +280,8 @@
  #3375|GEOMETRYCOLLECTION(POINT(0 -7))
  #3399|1|1
  #3399|10|10
 -#3399|1000|1000
  #3399|100|100
 +#3399|1000|1000
  ERROR:  invalid KML representation
  #3437a|5
  #3437b|5
 }}}


 Even though it shows as 2.3 only issue, I think that's because I'm testing
 9.6 only on 2.3 (others seem to be passing fine).  I had the same issue
 with this test on one run on my computer against 9.5/ 2.2

 So I think the main issue is this test is not deterministic because it
 lacks an order by so since debbie always tests against 9.6 dev change -
 its possible something in 9.6 changed in planner to make this always fail.

--

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3502#comment:2>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.