[mapserver-users] zoom fails with postgis layer displayed

[jim white]

I am having a failure zooming in when a postgis layer is displayed. Have 
recently upgraded from  postgis-1.2.1 to postgis-1.3.6, and suspect this 
is the problem. Have also tried postgis-1.4.0 and does not fix problem. 
Here is output of debug when map fails to draw.

[Sun Aug  9 17:22:36 2009].277240 msDrawRasterLayerLow(elevation): entering.
[Sun Aug  9 17:22:36 2009].345538 msDrawMap(): Layer 1 (elevation), 0.071s
[Sun Aug  9 17:22:36 2009].395028 msDrawMap(): Layer 6 (counties), 0.049s
[Sun Aug  9 17:22:36 2009].395105 msPostGISLayerOpen called: 
wkb_geometry FROM nc_owner
[Sun Aug  9 17:22:36 2009].395119 msPostGISLayerOpen: No connection in 
pool, creating a fresh one.
[Sun Aug  9 17:22:36 2009].398144 
msConnPoolRegister(gapown,user=postgres  dbname=ncgap 
host=localhost,0xaf60d0)
[Sun Aug  9 17:22:36 2009].398164 msPostGISLayerFreeItemInfo called.
[Sun Aug  9 17:22:36 2009].398186 msPostGISLayerInitItemInfo called.
[Sun Aug  9 17:22:36 2009].398198 msPostGISLayerWhichShapes called.
[Sun Aug  9 17:22:36 2009].398209 msPostGISParseData called.
[Sun Aug  9 17:22:36 2009].398223 msPostGISRetrievePK called.
[Sun Aug  9 17:22:36 2009].398238 msPostGISRetrievePK: select attname 
from pg_attribute, pg_constraint, pg_class where pg_constraint.conrelid 
= pg_class.oid and pg_class.oid = pg_attribute.attrelid and 
pg_constraint.contype = 'p' and pg_constraint.conkey[1] = 
pg_attribute.attnum and pg_class.relname = 'nc_owner' and 
pg_table_is_visible(pg_class.oid) and pg_constraint.conkey[2] is null
[Sun Aug  9 17:22:36 2009].401659 msPostGISParseData: 
unique_column=ogc_fid, srid=, geom_column_name=wkb_geometry, 
table_name=nc_owner
[Sun Aug  9 17:22:36 2009].401672 msPostGISBuildSQL called.
[Sun Aug  9 17:22:36 2009].401683 msPostGISBuildSQLItems called.
[Sun Aug  9 17:22:36 2009].401696 msPostGISBuildSQLItems: 1 items requested.
[Sun Aug  9 17:22:36 2009].401708 msPostGISBuildSQLFrom called.
[Sun Aug  9 17:22:36 2009].401720 msPostGISBuildSQLWhere called.
[Sun Aug  9 17:22:36 2009].401731 msPostGISBuildSQLSRID called.
[Sun Aug  9 17:22:36 2009].401742 msPostGISBuildSQLSRID: Building 
find_srid line.
[Sun Aug  9 17:22:36 2009].401753 msPostGISBuildSQLSRID: Found table 
(nc_owner)
[Sun Aug  9 17:22:36 2009].401804 msPostGISBuildSQLBox called.
[Sun Aug  9 17:22:36 2009].401851 msPostGISLayerWhichShapes query: 
select 
"ownc",encode(AsBinary(force_collection(force_2d("wkb_geometry")),'NDR'),'base64') 
as geom,"ogc_fid" from nc_owner where wkb_geometry && 
GeomFromText('POLYGON((808714.771276572 
192556.671839357,808714.771276572 252934.922638107,910137.271276619 
252934.922638107,910137.271276619 192556.671839357,808714.771276572 
192556.671839357))',find_srid('','nc_owner','wkb_geometry'))
[Sun Aug  9 17:22:36 2009].678298 msPostGISLayerWhichShapes query status: 2
[Sun Aug  9 17:22:36 2009].678360 msPostGISLayerWhichShapes got 14 
records in result.
[Sun Aug  9 17:22:36 2009].678374 msPostGISLayerNextShape called.
[Sun Aug  9 17:22:36 2009].678385 msPostGISReadShape called.
[Sun Aug  9 17:22:36 2009].699918 msPostGISReadShape: [ownc] "1300"
[Sun Aug  9 17:22:36 2009].748636 msPostGISLayerNextShape called.
[Sun Aug  9 17:22:36 2009].748690 msPostGISReadShape called.
[Sun Aug  9 17:22:36 2009].776902 msPostGISReadShape: [ownc] "1400"
[Sun Aug  9 17:24:36 2009].572102 msFreeMap(): freeing map at 0xb41d10.
[Sun Aug  9 17:24:36 2009].572148 msPostGISLayerClose called: 
wkb_geometry FROM nc_owner
[Sun Aug  9 17:24:36 2009].573226 
msConnPoolRelease(gapown,user=postgres  dbname=ncgap 
host=localhost,0xaf60d0)
[Sun Aug  9 17:24:36 2009].573242 msConnPoolClose(user=postgres  
dbname=ncgap host=localhost,0xaf60d0)
[Sun Aug  9 17:24:36 2009].573827 msPostGISLayerIsOpen called.

Thanks,
Jim

-- 
James (Jim) B. White
tel: (919)-380-9615
homepage: http://jimserver.net/