[postgis-tickets] [PostGIS] #2985: server crash when analyzing table with 1 row

[PostGIS]

#2985: server crash when analyzing table with 1 row
----------------------------------+-----------------------------------------
 Reporter:  nkiraly               |       Owner:  pramsey           
     Type:  defect                |      Status:  new               
 Priority:  critical              |   Milestone:  PostGIS PostgreSQL
Component:  postgis               |     Version:  2.1.x             
 Keywords:  analyze server crash  |  
----------------------------------+-----------------------------------------

Comment(by nkiraly):

 I built with debug symbols and crashed the backend with 1 row inserted
 scenario, here is the trace, gdb console log attached


 {{{
 (gdb) bt
 #0  0x000000000060b1d2 in std_fetch_func (stats=0x807846852, rownum=0,
 isNull=0x7fffffffca57 "?") at analyze.c:1755
 #1  0x0000000807c3fea7 in geometry_estimated_extent () from
 /usr/local/lib/postgresql/postgis-2.1.so
 #2  0x000000000060777f in do_analyze_rel (onerel=0x802e2ee10,
 vacstmt=0x802c5dae0, acquirefunc=0x606590 <acquire_sample_rows>,
 relpages=1, inh=0 '\0', elevel=17) at analyze.c:527
 #3  0x0000000000606515 in analyze_rel (relid=58705, vacstmt=0x802c5dae0,
 bstrategy=0x80781a038) at analyze.c:267
 #4  0x0000000000690f32 in vacuum (vacstmt=0x802c5dae0, relid=0, do_toast=1
 '\001', bstrategy=0x80781a038, for_wraparound=0 '\0', isTopLevel=1 '\001')
 at vacuum.c:254
 #5  0x0000000000839cc3 in standard_ProcessUtility (parsetree=0x802c5dae0,
 queryString=0x802c5d038 "ANALYZE VERBOSE dat_location_tho;",
 context=PROCESS_UTILITY_TOPLEVEL, params=0x0, dest=0x802c5de88,
     completionTag=0x7fffffffd480 "") at utility.c:639
 #6  0x00000000008393eb in ProcessUtility (parsetree=0x802c5dae0,
 queryString=0x802c5d038 "ANALYZE VERBOSE dat_location_tho;",
 context=PROCESS_UTILITY_TOPLEVEL, params=0x0, dest=0x802c5de88,
     completionTag=0x7fffffffd480 "") at utility.c:309
 #7  0x0000000000838f78 in PortalRunUtility (portal=0x802dce038,
 utilityStmt=0x802c5dae0, isTopLevel=1 '\001', dest=0x802c5de88,
 completionTag=0x7fffffffd480 "") at pquery.c:1187
 #8  0x0000000000837f68 in PortalRunMulti (portal=0x802dce038, isTopLevel=1
 '\001', dest=0x802c5de88, altdest=0x802c5de88,
 completionTag=0x7fffffffd480 "") at pquery.c:1318
 #9  0x00000000008375bd in PortalRun (portal=0x802dce038,
 count=9223372036854775807, isTopLevel=1 '\001', dest=0x802c5de88,
 altdest=0x802c5de88, completionTag=0x7fffffffd480 "") at pquery.c:816
 #10 0x0000000000832e21 in exec_simple_query (query_string=0x802c5d038
 "ANALYZE VERBOSE dat_location_tho;") at postgres.c:1048
 #11 0x0000000000832150 in PostgresMain (argc=1, argv=0x802c0c210,
 dbname=0x802c0c058 "pg93_postgis21_sig10", username=0x802c0c030
 "deployment") at postgres.c:4007
 #12 0x00000000007b8842 in BackendRun (port=0x802c71200) at
 postmaster.c:4011
 #13 0x00000000007b7e17 in BackendStartup (port=0x802c71200) at
 postmaster.c:3685
 #14 0x00000000007b4090 in ServerLoop () at postmaster.c:1586
 #15 0x00000000007b1984 in PostmasterMain (argc=3, argv=0x7fffffffdbe8) at
 postmaster.c:1253
 #16 0x00000000006f912c in main (argc=3, argv=0x7fffffffdbe8) at main.c:226
 }}}

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