[manhattan@Tango mapserver_bug]$ [manhattan@Tango mapserver_bug]$ /usr/local/mapserver-5.0.2/shp2img -m ncgap.map -o 1234.png -e 806873 188697 969149 273715 -all_debug 2 [Mon Jan 11 15:36:52 2010].838878 msPOSTGISLayerOpen called datastatement: wkb_geometry FROM counties [Mon Jan 11 15:36:52 2010].839078 MSPOSTGISLayerOpen -- shared connection not available. [Mon Jan 11 15:36:52 2010].843764 msConnPoolRegister(counties,user=postgres dbname=ncgap host=localhost,0xa6a2770) [Mon Jan 11 15:36:52 2010].843810 msPOSTGISLayerFreeItemInfo called [Mon Jan 11 15:36:52 2010].843846 msPOSTGISLayerWhichShapes called [Mon Jan 11 15:36:52 2010].843885 msPOSTGISLayerRetrievePGVersion(): query = select substring(version() from 12 for (position('on' in version()) - 13)) [Mon Jan 11 15:36:52 2010].845011 msPOSTGISLayerRetrievePGVersion: Version String: 8.4.2 [Mon Jan 11 15:36:52 2010].845035 msPOSTGISLayerRetrievePGVersion(): Found version 8, 4, 2 [Mon Jan 11 15:36:52 2010].845056 msPOSTGISLayerRetrievePK: query = 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 = 'counties' and pg_table_is_visible(pg_class.oid) and pg_constraint.conkey[2] is null [Mon Jan 11 15:36:52 2010].849421 msPOSTGISLayerParseData: unique column = ogc_fid, srid='', geom_column_name = wkb_geometry, table_name=counties [Mon Jan 11 15:36:52 2010].849586 query_string_0_6:DECLARE mycursor BINARY CURSOR FOR SELECT asbinary(force_collection(force_2d(wkb_geometry)),'NDR'),ogc_fid::text from counties WHERE wkb_geometry && setSRID('BOX3D(806873 173283.450643777,969149 289128.549356223)'::BOX3D, find_srid('','counties','wkb_geometry') ) [Mon Jan 11 15:36:52 2010].904091 msPOSTGISLayerFreeItemInfo called [Mon Jan 11 15:36:52 2010].904136 msPOSTGISLayerClose datastatement: wkb_geometry FROM counties [Mon Jan 11 15:36:52 2010].904150 msPOSTGISLayerClose -- closing query_result [Mon Jan 11 15:36:52 2010].904408 msConnPoolRelease(counties,user=postgres dbname=ncgap host=localhost,0xa6a2770) [Mon Jan 11 15:36:52 2010].904438 msConnPoolClose(user=postgres dbname=ncgap host=localhost,0xa6a2770) [Mon Jan 11 15:36:52 2010].910503 msDrawMap(): Layer 1 (counties), 0.075s [Mon Jan 11 15:36:52 2010].913584 msPOSTGISLayerOpen called datastatement: wkb_geometry FROM nc_owner [Mon Jan 11 15:36:52 2010].913607 MSPOSTGISLayerOpen -- shared connection not available. [Mon Jan 11 15:36:52 2010].916472 msConnPoolRegister(gapown,user=postgres dbname=ncgap host=localhost,0xa6ab1a0) [Mon Jan 11 15:36:52 2010].916622 msPOSTGISLayerFreeItemInfo called [Mon Jan 11 15:36:52 2010].916642 msPOSTGISLayerInitItemInfo called [Mon Jan 11 15:36:52 2010].916655 msPOSTGISLayerWhichShapes called [Mon Jan 11 15:36:52 2010].916671 msPOSTGISLayerRetrievePGVersion(): query = select substring(version() from 12 for (position('on' in version()) - 13)) [Mon Jan 11 15:36:52 2010].917750 msPOSTGISLayerRetrievePGVersion: Version String: 8.4.2 [Mon Jan 11 15:36:52 2010].917847 msPOSTGISLayerRetrievePGVersion(): Found version 8, 4, 2 [Mon Jan 11 15:36:52 2010].917931 msPOSTGISLayerRetrievePK: query = 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 [Mon Jan 11 15:36:52 2010].921763 msPOSTGISLayerParseData: unique column = ogc_fid, srid='', geom_column_name = wkb_geometry, table_name=nc_owner [Mon Jan 11 15:36:52 2010].922047 query_string_0_6:DECLARE mycursor BINARY CURSOR FOR SELECT "ownc"::text,asbinary(force_collection(force_2d(wkb_geometry)),'NDR'),ogc_fid::text from nc_owner WHERE wkb_geometry && setSRID('BOX3D(806873 173283.450643777,969149 289128.549356223)'::BOX3D, find_srid('','nc_owner','wkb_geometry') ) [Mon Jan 11 15:36:53 2010].434633 msPOSTGISLayerFreeItemInfo called [Mon Jan 11 15:36:53 2010].434689 msPOSTGISLayerClose datastatement: wkb_geometry FROM nc_owner [Mon Jan 11 15:36:53 2010].434724 msPOSTGISLayerClose -- closing query_result [Mon Jan 11 15:36:53 2010].435427 msConnPoolRelease(gapown,user=postgres dbname=ncgap host=localhost,0xa6ab1a0) [Mon Jan 11 15:36:53 2010].435452 msConnPoolClose(user=postgres dbname=ncgap host=localhost,0xa6ab1a0) [Mon Jan 11 15:36:53 2010].441685 msDrawMap(): Layer 10 (gapown), 0.531s [Mon Jan 11 15:36:53 2010].450877 msDrawMap(): Drawing Label Cache, 0.009s [Mon Jan 11 15:36:53 2010].450915 msDrawMap() total time: 0.618s [Mon Jan 11 15:36:53 2010].500820 msPOSTGISLayerClose datastatement: wkb_geometry FROM counties [Mon Jan 11 15:36:53 2010].500866 msPOSTGISLayerClose -- layerinfo is NULL [Mon Jan 11 15:36:53 2010].500881 msPOSTGISLayerClose datastatement: wkb_geometry FROM nc_owner [Mon Jan 11 15:36:53 2010].500892 msPOSTGISLayerClose -- layerinfo is NULL [manhattan@Tango mapserver_bug]$ [manhattan@Tango mapserver_bug]$ [manhattan@Tango mapserver_bug]$ [manhattan@Tango mapserver_bug]$ [manhattan@Tango mapserver_bug]$ [manhattan@Tango mapserver_bug]$ [manhattan@Tango mapserver_bug]$ [manhattan@Tango mapserver_bug]$ [manhattan@Tango mapserver_bug]$ [manhattan@Tango mapserver_bug]$ [manhattan@Tango mapserver_bug]$ [manhattan@Tango mapserver_bug]$ [manhattan@Tango mapserver_bug]$ [manhattan@Tango mapserver_bug]$ [manhattan@Tango mapserver_bug]$ [manhattan@Tango mapserver_bug]$ /usr/local/mapserver-5.6.1/shp2img -m ncgap.map -o 12345.png -e 806873 188697 969149 273715 -all_debug 2 [Mon Jan 11 15:37:00 2010].627789 msLoadMap(): 0.004s [Mon Jan 11 15:37:00 2010].630683 msPostGISLayerOpen called: wkb_geometry FROM counties [Mon Jan 11 15:37:00 2010].630729 msPostGISLayerOpen: No connection in pool, creating a fresh one. [Mon Jan 11 15:37:00 2010].635330 msConnPoolRegister(counties,user=postgres dbname=ncgap host=localhost,0xf2c5ee0) [Mon Jan 11 15:37:00 2010].635376 msPostGISLayerFreeItemInfo called. [Mon Jan 11 15:37:00 2010].635394 msPostGISLayerGetItems called. [Mon Jan 11 15:37:00 2010].635412 msPostGISParseData called. [Mon Jan 11 15:37:00 2010].635473 msPostGISRetrievePK called. [Mon Jan 11 15:37:00 2010].635501 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 = 'counties' and pg_table_is_visible(pg_class.oid) and pg_constraint.conkey[2] is null [Mon Jan 11 15:37:00 2010].639831 msPostGISParseData: unique_column=ogc_fid, srid=, geom_column_name=wkb_geometry, table_name=counties [Mon Jan 11 15:37:00 2010].639856 msPostGISLayerGetItems executing SQL: select * from counties where false limit 0 [Mon Jan 11 15:37:00 2010].641898 msPostGISLayerInitItemInfo called. [Mon Jan 11 15:37:00 2010].641923 msPostGISLayerWhichShapes called. [Mon Jan 11 15:37:00 2010].641937 msPostGISParseData called. [Mon Jan 11 15:37:00 2010].641955 msPostGISRetrievePK called. [Mon Jan 11 15:37:00 2010].641967 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 = 'counties' and pg_table_is_visible(pg_class.oid) and pg_constraint.conkey[2] is null [Mon Jan 11 15:37:00 2010].643494 msPostGISParseData: unique_column=ogc_fid, srid=, geom_column_name=wkb_geometry, table_name=counties [Mon Jan 11 15:37:00 2010].643517 msPostGISBuildSQL called. [Mon Jan 11 15:37:00 2010].643531 msPostGISBuildSQLItems called. [Mon Jan 11 15:37:00 2010].643547 msPostGISBuildSQLItems: 0 items requested. [Mon Jan 11 15:37:00 2010].643562 msPostGISBuildSQLFrom called. [Mon Jan 11 15:37:00 2010].643589 msPostGISBuildSQLWhere called. [Mon Jan 11 15:37:00 2010].643602 msPostGISBuildSQLSRID called. [Mon Jan 11 15:37:00 2010].643626 msPostGISBuildSQLSRID: Building find_srid line. [Mon Jan 11 15:37:00 2010].643641 msPostGISBuildSQLSRID: Found table (counties) [Mon Jan 11 15:37:00 2010].643657 msPostGISBuildSQLBox called. [Mon Jan 11 15:37:00 2010].643717 msPostGISLayerWhichShapes query: select encode(AsBinary(force_collection(force_2d("wkb_geometry")),'NDR'),'hex') as geom,"ogc_fid" from counties where wkb_geometry && GeomFromText('POLYGON((806873 173283.450643777,806873 289128.549356223,969149 289128.549356223,969149 173283.450643777,806873 173283.450643777))',find_srid('','counties','wkb_geometry')) [Mon Jan 11 15:37:00 2010].688441 msPostGISLayerWhichShapes query status: PGRES_TUPLES_OK (2) [Mon Jan 11 15:37:00 2010].688576 msPostGISLayerWhichShapes got 16 records in result. [Mon Jan 11 15:37:00 2010].688596 msPostGISLayerNextShape called. [Mon Jan 11 15:37:00 2010].688609 msPostGISReadShape called. [Mon Jan 11 15:37:00 2010].689631 msPostGISLayerNextShape called. [Mon Jan 11 15:37:00 2010].689647 msPostGISReadShape called. [Mon Jan 11 15:37:00 2010].690557 msPostGISLayerNextShape called. [Mon Jan 11 15:37:00 2010].690570 msPostGISReadShape called. [Mon Jan 11 15:37:00 2010].690865 msPostGISLayerNextShape called. [Mon Jan 11 15:37:00 2010].690878 msPostGISReadShape called. [Mon Jan 11 15:37:00 2010].691157 msPostGISLayerNextShape called. [Mon Jan 11 15:37:00 2010].691169 msPostGISReadShape called. [Mon Jan 11 15:37:00 2010].691793 msPostGISLayerNextShape called. [Mon Jan 11 15:37:00 2010].691807 msPostGISReadShape called. [Mon Jan 11 15:37:00 2010].692364 msPostGISLayerNextShape called. [Mon Jan 11 15:37:00 2010].692377 msPostGISReadShape called. [Mon Jan 11 15:37:00 2010].692965 msPostGISLayerNextShape called. [Mon Jan 11 15:37:00 2010].692978 msPostGISReadShape called. [Mon Jan 11 15:37:00 2010].693704 msPostGISLayerNextShape called. [Mon Jan 11 15:37:00 2010].693718 msPostGISReadShape called. [Mon Jan 11 15:37:00 2010].694171 msPostGISLayerNextShape called. [Mon Jan 11 15:37:00 2010].694184 msPostGISReadShape called. [Mon Jan 11 15:37:00 2010].694851 msPostGISLayerNextShape called. [Mon Jan 11 15:37:00 2010].694865 msPostGISReadShape called. [Mon Jan 11 15:37:00 2010].695381 msPostGISLayerNextShape called. [Mon Jan 11 15:37:00 2010].695419 msPostGISReadShape called. [Mon Jan 11 15:37:00 2010].695937 msPostGISLayerNextShape called. [Mon Jan 11 15:37:00 2010].695955 msPostGISReadShape called. [Mon Jan 11 15:37:00 2010].696656 msPostGISLayerNextShape called. [Mon Jan 11 15:37:00 2010].696673 msPostGISReadShape called. [Mon Jan 11 15:37:00 2010].697639 msPostGISLayerNextShape called. [Mon Jan 11 15:37:00 2010].697656 msPostGISReadShape called. [Mon Jan 11 15:37:00 2010].699486 msPostGISLayerNextShape called. [Mon Jan 11 15:37:00 2010].699508 msPostGISReadShape called. [Mon Jan 11 15:37:00 2010].700287 msPostGISLayerNextShape called. [Mon Jan 11 15:37:00 2010].700301 msPostGISLayerFreeItemInfo called. [Mon Jan 11 15:37:00 2010].700313 msPostGISLayerClose called: wkb_geometry FROM counties [Mon Jan 11 15:37:00 2010].700397 msConnPoolRelease(counties,user=postgres dbname=ncgap host=localhost,0xf2c5ee0) [Mon Jan 11 15:37:00 2010].700413 msConnPoolClose(user=postgres dbname=ncgap host=localhost,0xf2c5ee0) [Mon Jan 11 15:37:00 2010].700583 msDrawMap(): Layer 1 (counties), 0.070s [Mon Jan 11 15:37:00 2010].700627 msPostGISLayerOpen called: wkb_geometry FROM nc_owner [Mon Jan 11 15:37:00 2010].700639 msPostGISLayerOpen: No connection in pool, creating a fresh one. [Mon Jan 11 15:37:00 2010].704699 msConnPoolRegister(gapown,user=postgres dbname=ncgap host=localhost,0xf2c5f70) [Mon Jan 11 15:37:00 2010].704937 msPostGISLayerFreeItemInfo called. [Mon Jan 11 15:37:00 2010].704952 msPostGISLayerGetItems called. [Mon Jan 11 15:37:00 2010].704964 msPostGISParseData called. [Mon Jan 11 15:37:00 2010].704981 msPostGISRetrievePK called. [Mon Jan 11 15:37:00 2010].704997 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 [Mon Jan 11 15:37:00 2010].710516 msPostGISParseData: unique_column=ogc_fid, srid=, geom_column_name=wkb_geometry, table_name=nc_owner [Mon Jan 11 15:37:00 2010].710630 msPostGISLayerGetItems executing SQL: select * from nc_owner where false limit 0 [Mon Jan 11 15:37:00 2010].711526 msPostGISLayerInitItemInfo called. [Mon Jan 11 15:37:00 2010].711639 msPostGISLayerInitItemInfo called. [Mon Jan 11 15:37:00 2010].711717 msPostGISLayerWhichShapes called. [Mon Jan 11 15:37:00 2010].711801 msPostGISParseData called. [Mon Jan 11 15:37:00 2010].711881 msPostGISRetrievePK called. [Mon Jan 11 15:37:00 2010].711960 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 [Mon Jan 11 15:37:00 2010].713596 msPostGISParseData: unique_column=ogc_fid, srid=, geom_column_name=wkb_geometry, table_name=nc_owner [Mon Jan 11 15:37:00 2010].713718 msPostGISBuildSQL called. [Mon Jan 11 15:37:00 2010].713804 msPostGISBuildSQLItems called. [Mon Jan 11 15:37:00 2010].713884 msPostGISBuildSQLItems: 1 items requested. [Mon Jan 11 15:37:00 2010].713963 msPostGISBuildSQLFrom called. [Mon Jan 11 15:37:00 2010].714043 msPostGISBuildSQLWhere called. [Mon Jan 11 15:37:00 2010].714120 msPostGISBuildSQLSRID called. [Mon Jan 11 15:37:00 2010].714201 msPostGISBuildSQLSRID: Building find_srid line. [Mon Jan 11 15:37:00 2010].714278 msPostGISBuildSQLSRID: Found table (nc_owner) [Mon Jan 11 15:37:00 2010].714358 msPostGISBuildSQLBox called. [Mon Jan 11 15:37:00 2010].714475 msPostGISLayerWhichShapes query: select "ownc",encode(AsBinary(force_collection(force_2d("wkb_geometry")),'NDR'),'hex') as geom,"ogc_fid" from nc_owner where wkb_geometry && GeomFromText('POLYGON((806873 173283.450643777,806873 289128.549356223,969149 289128.549356223,969149 173283.450643777,806873 173283.450643777))',find_srid('','nc_owner','wkb_geometry')) [Mon Jan 11 15:37:00 2010].995892 msPostGISLayerWhichShapes query status: PGRES_TUPLES_OK (2) [Mon Jan 11 15:37:00 2010].996040 msPostGISLayerWhichShapes got 14 records in result. [Mon Jan 11 15:37:00 2010].996056 msPostGISLayerNextShape called. [Mon Jan 11 15:37:00 2010].996068 msPostGISReadShape called. [Mon Jan 11 15:37:01 2010].4666 msPostGISReadShape: [ownc] "1300" [Mon Jan 11 15:37:01 2010].28616 msPostGISLayerNextShape called. [Mon Jan 11 15:37:01 2010].28801 msPostGISReadShape called. [Mon Jan 11 15:37:01 2010].40110 msPostGISReadShape: [ownc] "1400" [Mon Jan 11 15:37:01 2010].49271 msPostGISLayerNextShape called. [Mon Jan 11 15:37:01 2010].49317 msPostGISReadShape called. [Mon Jan 11 15:37:01 2010].50340 msPostGISReadShape: [ownc] "1500" [manhattan@Tango mapserver_bug]$