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/
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
