[postgis-tickets] [PostGIS] #3131: KNN geography still gives ERROR: index returned tuples in wrong order

[PostGIS]

#3131: KNN geography still gives  ERROR:  index returned tuples in wrong order
----------------------+---------------------------
  Reporter:  robe     |      Owner:  pramsey
      Type:  defect   |     Status:  reopened
  Priority:  blocker  |  Milestone:  PostGIS 2.2.0
 Component:  postgis  |    Version:  trunk
Resolution:           |   Keywords:
----------------------+---------------------------
Changes (by robe):

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


Comment:

 nope knn_check regress still crashing for me at r13587 and with newest
 PostgreSQL 9.5 (
 http://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=ac6f22957d2f2999034b6a14d0d4bee25ba95f04
 )


 {{{
 POSTGIS="2.2.0dev r13587" GEOS="3.5.0dev-CAPI-1.9.0 r4034" PROJ="Rel.
 4.8.0, 6 March 2012" LIBXML="2.7.8" LIBJSON="0.12"
 }}}


 Back trace looks like this now:

 {{{
 [Switching to Thread 2580.0x2014]
 0x00000000708a3314 in geography_distance_uncached
 (fcinfo=fcinfo at entry=0x273e690) at geography_measurement.c:87
 87                      tolerance = PG_GETARG_FLOAT8(2);
 (gdb) bt
 #0  0x00000000708a3314 in geography_distance_uncached
 (fcinfo=fcinfo at entry=0x273e690) at geography_measurement.c:87
 #1  0x0000000000782fa4 in DirectFunctionCall4Coll
 (func=func at entry=0x708a3200 <geography_distance_uncached>,
 collation=collation at entry=0, arg1=<optimized out>, arg2=<optimized out>,
 arg3=arg3 at entry=0, arg4=arg4 at entry=0) at fmgr.c:1101
 #2  0x00000000708a33ec in geography_distance_knn (fcinfo=<optimized out>)
 at geography_measurement.c:58
 #3  0x000000000057c19b in ExecMakeFunctionResultNoSets (fcache=0x4da1398,
 econtext=0x4da11d0, isNull=0x4da24f1 "\177~\177\177\177\177\177\060x\037",
 isDone=<optimized out>) at execQual.c:2018
 #4  0x0000000000582100 in ExecTargetList (isDone=0x273ebec,
 itemIsDone=0x4da2640, isnull=0x4da24f0 "", values=0x4da24c8,
 econtext=0x4da11d0, targetlist=0x4da2608) at execQual.c:5363
 #5  ExecProject (projInfo=projInfo at entry=0x4da2510,
 isDone=isDone at entry=0x273ebec) at execQual.c:5578
 #6  0x0000000000582550 in ExecScan (node=node at entry=0x4da10b8,
 accessMtd=accessMtd at entry=0x597900 <SeqNext>,
 recheckMtd=recheckMtd at entry=0x5978f0 <SeqRecheck>) at execScan.c:207
 #7  0x0000000000597973 in ExecSeqScan (node=node at entry=0x4da10b8) at
 nodeSeqscan.c:114
 #8  0x000000000057aff8 in ExecProcNode (node=node at entry=0x4da10b8) at
 execProcnode.c:412
 #9  0x0000000000598499 in ExecSort (node=node at entry=0x4da0e20) at
 nodeSort.c:103
 #10 0x000000000057b068 in ExecProcNode (node=node at entry=0x4da0e20) at
 execProcnode.c:488
 #11 0x0000000000590dd0 in ExecLimit (node=node at entry=0x4da0ae0) at
 nodeLimit.c:91
 #12 0x000000000057af18 in ExecProcNode (node=node at entry=0x4da0ae0) at
 execProcnode.c:520
 #13 0x0000000000577cbe in ExecutePlan (dest=0x4dd5868,
 direction=<optimized out>, numberTuples=0, sendTuples=1 '\001',
 operation=CMD_SELECT, planstate=0x4da0ae0, estate=0x4da09c8) at
 execMain.c:1549
 #14 standard_ExecutorRun (queryDesc=0x4e61158, direction=<optimized out>,
 count=0) at execMain.c:337
 #15 0x000000000068bde8 in PortalRunSelect (portal=portal at entry=0x4d98988,
 forward=forward at entry=1 '\001', count=0, count at entry=41153104,
 dest=dest at entry=0x0) at pquery.c:946
 #16 0x000000000068d3e6 in PortalRun (portal=0x273eeb0,
 portal at entry=0x4d98988, count=41153104, count at entry=2147483647,
 isTopLevel=isTopLevel at entry=0 '\000', dest=0x0, dest at entry=0x4dd5868,
 altdest=altdest at entry=0x4dd5868, completionTag=0x273f210 "",
 completionTag at entry=0x40000000057 <error:
 #17 0x000000000068ace4 in exec_simple_query (query_string=0x0) at
 postgres.c:1104
 #18 PostgresMain (argc=<optimized out>, argv=argv at entry=0xf81a8,
 dbname=0x10000f000e000d <error: Cannot access memory at address
 0x10000f000e000d>, username=<optimized out>) at postgres.c:4025
 #19 0x000000000062ac43 in BackendRun (port=0x273f400) at postmaster.c:4162
 #20 SubPostmasterMain (argc=argc at entry=3, argv=argv at entry=0x167fa0) at
 postmaster.c:4649
 #21 0x00000000007c6b70 in main (argc=3, argv=0x167fa0) at main.c:198
 (gdb)
 }}}

 which doesn't look all that diferent

--
Ticket URL: <http://trac.osgeo.org/postgis/ticket/3131#comment:7>
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.