[postgis-tickets] [PostGIS] #2703: KNN gist with recheck for 9.5?

[PostGIS]

#2703: KNN gist with recheck for 9.5?
--------------------------+---------------------------
  Reporter:  robe         |      Owner:  pramsey
      Type:  enhancement  |     Status:  new
  Priority:  high         |  Milestone:  PostGIS 2.2.0
 Component:  postgis      |    Version:  trunk
Resolution:               |   Keywords:
--------------------------+---------------------------

Comment (by robe):

 Okay I built with latest commit --
 http://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=c5dd8ead403f85bd041590d2e3e79b72830472d4

 and still crashes for me.

 {{{
 SELECT * FROM test_geog_knn ORDER BY
 ST_GeogFromText('POINT(-71.0518888888889 42.4934722222222)') <-> geog
 limit 1;
 }}}


 My back trace looks like this:


 {{{
 Program received signal SIGSEGV, Segmentation fault.
 [Switching to Thread 10004.0x4b64]
 0x00000000708a3263 in geography_distance (fcinfo=0x4b90610) at
 geography_measurement.c:139
 139                     tolerance = PG_GETARG_FLOAT8(2);
 (gdb) bt
 #0  0x00000000708a3263 in geography_distance (fcinfo=0x4b90610) at
 geography_measurement.c:139
 #1  0x000000000057bf4b in ExecMakeFunctionResultNoSets (fcache=0x4b905a0,
 econtext=0x4b90340, isNull=0x4b9170a "", isDone=<optimized out>) at
 execQual.c:2018
 #2  0x0000000000581eb0 in ExecTargetList (isDone=0x273ebec,
 itemIsDone=0x4b91878, isnull=0x4b91708 "", values=0x4b916d0,
 econtext=0x4b90340, targetlist=0x4b91840) at execQual.c:5363
 #3  ExecProject (projInfo=projInfo at entry=0x4b91728,
 isDone=isDone at entry=0x273ebec) at execQual.c:5578
 #4  0x0000000000582300 in ExecScan (node=node at entry=0x4b90228,
 accessMtd=accessMtd at entry=0x597590 <SeqNext>,
 recheckMtd=recheckMtd at entry=0x597580 <SeqRecheck>) at execScan.c:207
 #5  0x0000000000597603 in ExecSeqScan (node=node at entry=0x4b90228) at
 nodeSeqscan.c:114
 #6  0x000000000057ada8 in ExecProcNode (node=node at entry=0x4b90228) at
 execProcnode.c:412
 #7  0x0000000000598129 in ExecSort (node=node at entry=0x4b8ff90) at
 nodeSort.c:103
 #8  0x000000000057ae18 in ExecProcNode (node=node at entry=0x4b8ff90) at
 execProcnode.c:488
 #9  0x0000000000590a60 in ExecLimit (node=node at entry=0x4b8fc50) at
 nodeLimit.c:91
 #10 0x000000000057acc8 in ExecProcNode (node=node at entry=0x4b8fc50) at
 execProcnode.c:520
 #11 0x0000000000577a6e in ExecutePlan (dest=0x4cd2b50,
 direction=<optimized out>, numberTuples=0, sendTuples=1 '\001',
 operation=CMD_SELECT, planstate=0x4b8fc50, estate=0x4b8fb38) at
 execMain.c:1550
 #12 standard_ExecutorRun (queryDesc=0xde81138, direction=<optimized out>,
 count=0) at execMain.c:337
 #13 0x000000000068ba68 in PortalRunSelect (portal=portal at entry=0x4b85ae8,
 forward=forward at entry=1 '\001', count=0, count at entry=41153104,
 dest=dest at entry=0x0) at pquery.c:952
 #14 0x000000000068d0c6 in PortalRun (portal=0x273eeb0,
 portal at entry=0x4b85ae8, count=41153104, count at entry=2147483647,
 isTopLevel=isTopLevel at entry=0 '\000', dest=0x0, dest at entry=0x4cd2b50,
 altdest=altdest at entry=0x4cd2b50, completionTag=0x273f210 "",
 completionTag at entry=0x40000000075 <error: Cannot access memory at address
 0x40000000075>) at pquery.c:796
 #15 0x000000000068a964 in exec_simple_query (query_string=0x0) at
 postgres.c:1104
 #16 PostgresMain (argc=<optimized out>, argv=argv at entry=0x2e7f90,
 dbname=0x10000f000e000d <error: Cannot access memory at address
 0x10000f000e000d>, username=<optimized out>) at postgres.c:4025
 #17 0x000000000062a913 in BackendRun (port=0x273f400) at postmaster.c:4162
 #18 SubPostmasterMain (argc=argc at entry=3, argv=argv at entry=0x357fa0) at
 postmaster.c:4649
 #19 0x00000000007c6830 in main (argc=3, argv=0x357fa0) at main.c:198
 (gdb)


 }}}

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