[postgis-users] Query crashed

[Stephen Woodbridge]

Another piece of information. I ran the query from psql client and the 
"NOTICE: ..." line is emitted as soon as the query is started and 
probably is not related to the "server closed ..." message only in 
pgadmin3 the output is not flushed to the console. I am rerunning the 
query with a slight change that should be a little faster by using:

... expand(r.the_geom, 0.00007) && s.the_geom and ...

-Steve

Stephen Woodbridge wrote:
> Hi all,
> 
> I was running the following query:
> 
> select count(*)
> from
>   roadseg r, streets s
> where
>   buffer(r.the_geom, 0.00007) && s.the_geom and
>   within(s.the_geom, buffer(r.the_geom, 0.00007));
> 
> And it crashed with the following error message after running for 
> 1,959,844 ms in pgadmin3:
> 
> NOTICE:  LWGEOM_gist_joinsel called with arguments that are not column 
> references
> server closed the connection unexpectedly
>     This probably means the server terminated abnormally
>     before or while processing the request.
> 
> The "roadseg" table is the geobase roadseg data for all provinces loaded 
> into a table and the "streets" is the same for the Census streets data 
> for all provinces.
> 
> postgis_full_version() reports:
> POSTGIS="1.0.4"
> GEOS="2.0.1"
> PROJ="Rel. 4.4.9, 29 Oct 2004"
> USE_STATS DBPROC="0.3.0"
> RELPROC="0.3.0"
> 
> and version() reports:
> 
> "PostgreSQL 8.0.4 on i386-portbld-freebsd5.3, compiled by GCC cc (GCC) 
> 3.4.2 [FreeBSD] 20040728"
> 
> Any ideas on what this is about. All the data was loaded via shp2pgsql.
> 
> Thanks,
>   -Steve
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>