[postgis-devel] Backend crash with RC3 and RC4

[strk at refractions.net]

On Wed, Mar 23, 2005 at 01:44:06PM -0000, Martin Daly wrote:
> > Postgresql version ?
> > Architecture ?
> 
> Quite right.  Shoddy reporting.  Just what I hate about bug reports too.
> 
> pgAdmin reports:
> PostgreSQL 8.0.1 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2
> (mingw-special)
> The PostGIS RC-s are all native Win32 installations from
> www.webbased.co.uk/mca

Mark, is the RC4 package *really* RC4 or something prior to
the tagged version ?
One of the latest fixes in RC4 was:
	(2005-03-18 13:36)
        - BUGFIX in box3d computation function with collections

--strk;

> 
> > A test file with load/vacuum/select/bang ?
> 
> That's harder.  I've tried with shp2pgsql, with pg_dump/psql and
> pg_dump/pg_restore and no luck.  The closest I've got is adding the data
> with SIS, then using psql with a SQL file of all of our SQL statements
> on the reconnect (attached).  In fact, each time the backend restarts,
> the same SQL will crash it from psql.  This is also true if the service
> is stopped and restarted.  We have noticed that by adding a single line
> (commented out in bang.sql) to close one cursor before opening the
> cursor that causes the crash, the crash is avoided.
> 
> Is there any mileage is zipping up the entire data folder?
> 
> Regards,
> Martin


> _______________________________________________
> postgis-devel mailing list
> postgis-devel at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-devel