[postgis-users] itemnquery limitation

[Zamil Murji]

So here is where I'm at:
On simple queries, ones with less than 10 items, I get the following:
[Mon Aug 11 14:14:01 2003] [error] [client 10.0.50.205] msPOSTGISLayerGetShape called for record = 19107034
[Mon Aug 11 14:14:01 2003] [error] [client 10.0.50.205] msPOSTGISLayerGetShape sql=DECLARE mycursor BINARY CURSOR FOR SELECT well_node_id::text,well_no::text,uwi::text,latitude::text,longitude::text,riley_logs::text,riley_logs_rasters::text,depth_registered::text,asbinary(force_collection(force_2d(the_geom)),'NDR') from well_node WHERE OID = 19107034
[Mon Aug 11 14:14:01 2003] [error] [client 10.0.50.205] msPOSTGISLayerGetShape called for record = 19106935
[Mon Aug 11 14:14:01 2003] [error] [client 10.0.50.205] msPOSTGISLayerGetShape sql=DECLARE mycursor BINARY CURSOR FOR SELECT well_node_id::text,well_no::text,uwi::text,latitude::text,longitude::text,riley_logs::text,riley_logs_rasters::text,depth_registered::text,asbinary(force_collection(force_2d(the_geom)),'NDR') from well_node WHERE OID = 19106935

The above is what was returned for a query that returned 2 rows. When i do a query for more than 11 (11 works) nothing ever gets printed out in the error logs. After a while i get this in the error log:
[Mon Aug 11 14:19:25 2003] [error] [client 10.0.50.205] (70007)The timeout specified has expired: ap_content_length_filter: apr_bucket_read() failed

Can anybody make sense of this?

Zamil


-----Original Message-----
From: Zamil Murji 
Sent: Monday, August 11, 2003 2:50 PM
To: PostGIS Users Discussion
Subject: RE: [postgis-users] itemnquery limitation


I am in the process of trying this out. FYI, I am not doing an itemnquery, I am doing an NQUERY.

Sorry for the confusion.

Will debug msg still come through?
Zamil

-----Original Message-----
From: David Blasby [mailto:dblasby at refractions.net]
Sent: Monday, August 11, 2003 2:44 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] itemnquery limitation


Zamil Murji wrote:

>  Can you think of any reason why this may be?

Unfortunately, no.  It seems to be working fine on my machine.  Perhaps 
its because I'm directly running the cgi mapserv instead of hitting it 
with an httpd.

> Could you try installing the new mappostgis.c and running your query? 
> It should give some output (probably in your httpd's error_log) like this:
> 
> msPOSTGISLayerGetShape called for record = 3532689
> msPOSTGISLayerGetShape sql=DECLARE mycursor BINARY CURSOR FOR SELECT 
> asbinary(force_collection(force_2d(the_geom)),'NDR') from nodescomb_2003 
> WHERE OID = 3532689

Did you find this?


dave
ps. I cannot access your url, but thats ok.


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

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