[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):

 The place where I tested this and always see failures is a FreeBSD 10
 virtual machine. I am getting these errors on QA servers also running
 FreeBSD 10 when QA databases are redeployed clean.

 I ran tests from #2267 and I get postmaster terminate notification,
 {{{
 pg93_postgis21_trac2985=# analyze verbose foo;
 INFO:  analyzing "public.foo"
 INFO:  "foo": scanned 1 of 1 pages, containing 2 live rows and 0 dead
 rows; 2 rows in sample, 2 estimated total rows
 The connection to the server was lost. Attempting reset: WARNING:
 terminating connection because of crash of another server process
 }}}

 and sig 10 in server logs.
 {{{
 Nov  5 11:17:34 bludgeon kernel: pid 37842 (postgres), uid 70: exited on
 signal 10 (core dumped)
 Nov  5 11:17:34 bludgeon postgres[15724]: [27-1] WARNING:  terminating
 connection because of crash of another server process
 Nov  5 11:17:34 bludgeon postgres[15724]: [27-2] DETAIL:  The postmaster
 has commanded this server process to roll back the current transaction and
 exit, because another server process exited abnormally and possibly
 corrupted shared memory.
 Nov  5 11:17:34 bludgeon postgres[15724]: [27-3] HINT:  In a moment you
 should be able to reconnect to the database and repeat your command.
 }}}

 VM build is
 {{{
 [nicholas.kiraly at bludgeon ~]$ uname -a
 FreeBSD bludgeon 10.0-RELEASE-p7 FreeBSD 10.0-RELEASE-p7 #0: Tue Jul  8
 06:37:44 UTC 2014
 root at amd64-builder.daemonology.net:/usr/obj/usr/src/sys/GENERIC  amd64
 }}}

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